Aggregation of related records -- First value only

Question

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

Stefan Helzle · Accepted Answer

Did you try this? 
 https://docs.appian.com/suite/help/22.3/fnc_system_relatedrecorddata.html

Peter Lewis · Answer

It's not possible to use the a!relatedRecordData() function in a custom record field, but I still think you can likely get what you need. Can you share more information about your use case? If you just need to display this in a grid, you shouldn't need a custom record field. Instead, just add a!relatedRecordData() to your grid data and configure it to only return one itme. 
 For instance, something like the example here would work, do to the same thing in a grid instead: docs.appian.com/.../fnc_system_relatedrecorddata.html

Peter Lewis · Answer

Actually what I would recommend is not using an expression rule at all - the query is an example for how the data is returned, but you can directly call the record type as the source of your grid instead (which I think will be easier to configure and change as necessary). 
 To do this, you can use a!recordData() as the "data" parameter and add your usage of a!relatedRecordData() inside of that function. 
 Here's more information about this from the grid documentation .

Aggregation of related records --> First value only

Top Replies