Place "Count" conditions on Aggregate Models

[Dave]

@_Deleted_User1

Yes, this is possible, but currently only through XML. Essentially what you are trying to accomplish is a “Post-Aggregation” Condition. Whereas a normal “Pre-Aggregation” Condition affects the set of records that get included in your aggregate query, a “Post-Aggregation” Condition is applied after the aggregate query is already run. Taking your example, say you have 1000’s of Client records. Say, for instance, you are only interested in Clients whose Age is over 65. You would write a “Pre-Aggregation” Condition (Conditions you’re used to with Skuid right now) to limit the scope of Client records that your Client_dups Aggregate Model even looks at. So, then, your Aggregate Model is run. It groups all Clients over the age of 65 by some field, then runs your aggregation — a Count. So now you have, say, 15 “aggregate result” records. Now, you want to apply a Condition to THESE 15 aggregate result records — finding just the ones where the Count is greater than 1. THIS is the scenario where “Post-Aggregation” Conditions come into play. Skuid currently only supports Post-Aggregation Conditions via XML, so for anyone reading this who’s uncomfortable working with XML — PLEASE, WAIT FOR THIS TO BE SUPPORTED IN THE PAGE BUILDER. But, for those of you at home in XML, here we go… In the Salesforce world, Post-Aggregation Conditions are achieved via a “HAVING” Clause. So in Skuid XML, we store Post-Aggregation Conditions in a node, with each Post-Aggregation Condition being defined as a separate . Other than that slight syntactical difference, having nodes are exactly the same as condition nodes, so basically if you just think of how your Skuid Condition XML would look, that’s how your Having XML should look. The only difference is that Havings / Post-Aggregation Conditions can only operate on Fields that you either Grouped or Aggregated on. Havings / Post-Aggregation Conditions are applied, by definition, only to the result set — so the only “fields” that are available to filter on are fields in your aggregate result set. So here’s the XML that you will need to add to your Client_dups Model XML to achieve what you’re after: Here’s a screenshot of a Model XML just to give some context: The key piece to notice here that may not be familiar is the “fieldfunction” XML attribute. This is where you select the aggregation function that you are filtering on. And here’s what it looks like on a working finished page — exactly the same, except that only rows where COUNT(Id) is 2 or more are included:

Hey Old post, but I guess the ‘Having’ method only applies to Salesforce Data? I just tried same exact logic on a DSO but it’s not working.

@skuid Since then any other method that this can be accoomplished?