Aggregation of related records --> First value only

Hello,

when a record type has a (1,n) relation, Appian supports some aggration for those related records ( 'Create Custom Record Field' --> 'AGGREGATE RELATED RECORD FIELDS').

The avaible aggregation functions seem to be dependend on the data type of the 'AGGREGATE RELATED RECORD FIELDS' - in any case, I'm looking for something like FIRST_OF (LAST_OF) so that I can get the first record field(s) of related data records (which are string based).

Maybe a small example: (Author)  <-- (Books) (an author can have many books)

Should be presented in a list

author number of books book title (first) book release year (first)
Scott Lynch 6 The Lies of Locke Lamora 2006
...

What would be a good way to achieve this?

Thank you in advance

Thomas

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data