Skip to main content
B
bernhar1k143337
January 8, 2026
Solved

Retrieving Related Record Type Fields using a!selectionFields

  • January 8, 2026
  • 4 replies
  • 0 views

Hi,

As the title says, I'm trying to retrieve all fields of a record type and its related record types in a query using a!selectionFields.

I have the following hierarchy

  • Produktbeschreibung (Prroduct Description)
    • Konzept (Concept) as (one-to-many)
      • [several other types, such as related risks]

My problem now is, that using the following expression:

I get all fields that are directly related to Produktbeschreibung and Konzept, but not the data for the related record types under Konzept. I'm suspecting that selection fields cannot drill down more than one relationship at a time. If that is correct, is there any way, I could get the data for the nested ralationships in a way such that I can retrieve the full record?

Best answer by bernhar1k143337

I just realized that the issue was the record-level security I had configured. After ensuring that I actually could access the records, I was even able to use a!selectionFields to dig two levels down.

4 replies

shubhama926776
shubhama926776
January 8, 2026

a!selectionFields() only works one level deep.
Use a!relatedRecordData() for nested relationships.

https://docs.appian.com/suite/help/25.4/fnc_system_relatedrecorddata.html

B
bernhar1k143337Author
January 8, 2026

Thanks for the quick reply! Maybe I'm misunderstanding something here, but isn't a!relatedRecordData only applying sorts, limits, and filters, as opposed to just retrieving the related records?

stefanhelzle0001
stefanhelzle0001
January 8, 2026

You are right.

    B
    bernhar1k143337AuthorAnswer
    January 8, 2026

    I just realized that the issue was the record-level security I had configured. After ensuring that I actually could access the records, I was even able to use a!selectionFields to dig two levels down.

      Terms & ConditionsAccessibility statement