I am trying to create one expression rule to get count of records created by Tester_Group. In table, we have CreatedBy column.

Using the query editor, this should be pretty simple. There is also an similar example in the queries recipes.

https://docs.appian.com/suite/help/22.4/Query_Recipes.html#aggregate-data-from-a-field

create a query entity that gets all the records from the created_by column than you can use count() to get the count and display it in your ui. 

It is never a good idea to load all data into Appian and then aggregate it. Just takes up more CPU cycles and memory. Do that in the database.

Thanks Stefan Helzle

Thank you

Hi Stefan,

How to check in query filter, that createdby user is belong to Tester_Group?

Regards,
Sandeep 

You need to check this before the actual query. Use the function isusermemberofgroup().

Thanks Stefan
it worked