Is it possible to use query aggregation with content returned from a query rule?

Hi James. Perhaps you need to look at a!queryEntity() function? Or am I misreading your question.

It's difficult to aggregate on data returned from query rule as there is no way to use query filter, but you can do that very easily with query entity. Please take a look at query recipes for aggregating on a Field.

forum.appian.com/.../Query_Recipes.html

As Tim and Amit suggested it is possible to use a!queryEntity() inside an expression rule to achieve this, however be mindful of performance if you are calling the rule often or performing a complex aggregation over a large dataset.

Thanks guys, I had a feeling this was either going to get expensive or be convoluted to achieve. Best done with a sql query instead by the looks of things since my prospective data set is going to become quite large. Yes Tim I thought queryEntity would be the logical route but I couldn't find it in 7.5, so assumed it was something that has been recently introduced. Since I don't need up to the minute stats returned I will model the sql query under a repeating schedule and pull the data from that instead. Thanks James

You can create a stored proc and execute it in appian by using execute stored proc smart service and get all the result set. Stored proc is meant to handle complex aggregation of data and lot of things. I created stored proc for one of my use case which had complex query selection and aggregation and i am happy with performance of smart service as well.

We've been creating SQL Views for this, and additional CDTs/Query Rules to access the view containing complex SQL. Works great.