ReportSQL - Services (Phases)

Number of Service Records on a Case even if 0

Number of Service Records on a Case even if 0

Remit: Cases with a count of service records even if there are none. You can't filter without filtering out cases that don't have any service/phase records.

Number field on top level Case Data table:

(select count(*) from phase where phase.matter_id = %tableAlias%.id and active is true and title = 'Primary HUD Eviction Prevention Service')
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us