Skip to main content
Nintex Community Menu Bar

Is it possible to specify “HAVING” in an aggregate model?


Reference: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_having.htm

My use case is that I want to filter out 0 SUMs

https://community.skuid.com/t/set-having-with-javascript


Thanks for the link!

Got it working!

Added this to the model’s XML in its own section after the section:




Yes, you can add clauses via the XML, see this post:


https://community.skuid.com/t/filter-on-count


All of these links are broken. Can someone provide the updated links to the ‘having’ capability?


Hi Paul,

Here are the updated links for those threads:



Does anyone know how I would set “Having” (as described in the following community post) via JavaScript Snippet? I would like to create a table filter based on Having. Thanks!



i have an aggregate model that counts the number of times a first name last name combination appears in the client object can i filter the model to only display > 1 for the count ? 5image]