175766 - no subject - I am using a!query() function to retriev

You should be doing the aggregation and complex logic inside a database view and then you can just select the data with queryEntity.

@tim.clarke: I am using same VIEW for different button widgets from dashboard which should have different aggregation. I have included the complex logic already in VIEW but will try to handle this as well. Seems I may need to pass some parameter to view. Any other though?

Why do you need to do both selection and aggregation? If you need to do aggregation, you should be able to meet your requirements by using that.

@Tom Ryan: I need to display certain fields in grid for a report. Also I need to display a pie chart with aggregated count based on certain conditions. I was looking to do both in one call to DB (external).

If you need two data sets, you will most likely need to do two queries.