Skip to main content
December 10, 2022
Solved

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

  • December 10, 2022
  • 8 replies
  • 0 views

Hi All,

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

Requirement is to display the count in UI by using a!gaugeField(). Please help with some ideas.

Regards,
Sandeep

    Best answer by stefanhelzle0001

    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

    8 replies

    stefanhelzle0001
    December 10, 2022

    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

    December 12, 2022

    Thanks Stefan Helzle

    December 10, 2022

    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. 

    stefanhelzle0001
    December 11, 2022

    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.