We're updating the issue view to help you get more done. 

Preside object filters: should be able to do aggregate filters (i.e. HAVING)

Description

It is currently not possible to supply a HAVING filter through the preside object service. i.e. you may want to do something like:

1 2 3 4 5 select Count(1) as record_count from `psys_website_user` `website_user` left join `psys_website_benefit__join__website_user` `benefits` on (`benefits`.`website_user` = `website_user`.`id`) group by `website_user`.`id` having Count( `benefits`.`website_user` ) > 0;

Provide some way of making this possible!

Status

Assignee

Unassigned

Reporter

Dominic Watson

Accepted

Yes

Fix versions

Priority

Medium