ReportSQL - Income

This is a stub article.

Case has One or More Income Types

When you don't want to filter on Income Types and exclude cases, but you need to know if a case has a particular type or types of income.

• Boolean formula field on Case Data
• Get the IDs from the Income Categories lookup list

case when
(select count(*) from matter_income
where matter_id = %tableAlias%.id
and (type = 2550 or type = 100355))
> 0
then true
else
false
end