GlideAggregate Query Data Resource in UI Builder

[Bernard Esterhu]

We would like to make use of GlideAggregate in UI Builder. However, there is no GlideAggregate Query Data Resource available out of the box. 

This means we need to make use of a Transform Data Resource (which needs an acl rule).

Is there any reason that this does not exist? If would be very useful, and is very similar to the existing GlideRecord Query Data Resource

[Yashsvi]

Hi @Bernard Esterhu,

The absence of a GlideAggregate Query Data Resource in UI Builder likely stems from architectural considerations and design choices specific to how UI Builder integrates with ServiceNow's data model and APIs. GlideAggregate is typically used for aggregating data (like counts, sums, averages) rather than fetching detailed records like GlideRecord does.

Here are a few reasons why GlideAggregate might not have a direct counterpart in UI Builder:

1. Aggregation vs. Record Retrieval: GlideAggregate is primarily used for performing aggregate functions on data, not for fetching detailed records. UI Builder focuses more on presenting and interacting with individual records or lists of records rather than aggregated data.

2. Customization and Scripting Options: While not out-of-the-box, you can still leverage Transform Data Resources with ACLs to achieve similar functionality to GlideAggregate. This approach ensures that data operations are secure and efficient within the UI Builder framework.

Thank you, please make helpful if you accept the solution.

[Bernard Esterhu]

Hi @Yashsvi thanks a lot for these pointers.

"UI Builder focuses more on presenting and interacting with individual records or lists of records rather than aggregated data."

On the contrary, we use UI Builder based dashboards extensively to report using aggregated data 😃