Respecting ACLs in GlideAggregate

barcar
Tera Contributor

I have a ServicePortal widget which calculates a set of filtered record counts using GlideAggregate.

Is there a way, like GlideRecordSecure to make the aggregate respect the ACL on the table and only count records which the logged in user can see? It seems crazy to have to replicate the same ACL logic in the aggregate query filter.

7 REPLIES 7

asifnoor
Kilo Patron

Hi,

ACLs are executed based on the logged in user querying the table. So technically aggregate will respect the aCL that is already there and returns you the data.

is it not returning like that?

 

Also check this link

Kindly mark the comment as a correct answer if this answers your question.

barcar
Tera Contributor
How would I use canRead in a GlideAggregate query filter?

barcar
Tera Contributor
No. The aggregate count is returning, for example, a count of 4 but when the user drills in to the widget they see 2 records and 2 filtered out by the ACL.