Search found 2 matches
- Fri Jan 05, 2024 12:35 am
- Forum: Advanced Topics
- Topic: How can I FIlter by PayType?
- Replies: 0
- Views: 4456
How can I FIlter by PayType?
I've below query ortho payments here I also want to filter by Payment Group currently I can able to filter by payment PayType SELECT SUM(amt) AS total_sum FROM ( SELECT payment.PayDate AS DatePay, MAX(CONCAT(patient.LName, ', ', patient.FName, ' ', patient.MiddleI)) AS lfname, GROUP_CONCAT(DISTINCT ...
- Fri Jan 05, 2024 12:34 am
- Forum: Main Forum
- Topic: How can I FIlter by PayType?
- Replies: 0
- Views: 4427
How can I FIlter by PayType?
I've below query ortho payments here I also want to filter by Payment Group currently I can able to filter by payment PayType SELECT SUM(amt) AS total_sum FROM ( SELECT payment.PayDate AS DatePay, MAX(CONCAT(patient.LName, ', ', patient.FName, ' ', patient.MiddleI)) AS lfname, GROUP_CONCAT(DISTINCT ...