Skip to main content
thomasm0013
thomasm0013
November 17, 2022
Solved

How to aggregate data records to view in lists or tables?

  • November 17, 2022
  • 4 replies
  • 0 views

What would be a good way to aggregate data records (or data record types) to display in a list? Appian supports the aggregation of record types in charts - I wonder if there is an easy way to display aggegration results in tables.

    Best answer by stefanhelzle0001

    a!queryRecordType supports fetching, filtering and aggregating related data. This is what the charts are doing and this is what you can do as well. The documentation includes some nice examples.

    4 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    November 17, 2022

    You create your query using the query wizard and display the result in a grid. This is similar to charts. Do you have any specific questions.

      thomasm0013
      thomasm0013Author
      November 17, 2022

      Hi Stefan,

      I was just wondering if there is a way without having to define an additional query, just as in the chart option. As suspected, that is not the case - so for me its not similar to charts. :-)

      stefanhelzle0001
      stefanhelzle0001Answer
      Brainy
      November 17, 2022

      a!queryRecordType supports fetching, filtering and aggregating related data. This is what the charts are doing and this is what you can do as well. The documentation includes some nice examples.

        Terms & ConditionsAccessibility statement