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
Question
Aggregate Model with SOQL HAVING" clause?"
+10This topic has been closed for replies.
+10Thanks for the link!
Got it working!
Added this to the model’s XML in its own section after the section:
+13Yes, you can add clauses via the XML, see this post:
+5- Nintex Employee
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 ? [image]
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.