Turning query results into array

Question

Dear all,
I need to turn the results of the below query into an array including all "submissionunit"s to further use the wherecontains() formula on that.
Could anybody tell me which function to use to create an array in that case?

local!datasubset2: a!queryEntity(
      entity: cons!MR_ABGABE_DSE,
      query: a!query(
        selection: "submissionunit",
        filter: a!queryFilter(
          field: "submissionperiod",
          operator: "=",
          value: local!period
        ),
        pagingInfo: local!pagingInfo2
      ),
      fetchTotalCount: false
    )

Thank you very much in advance!
Chris

danny.verb · Answer

a!queryEntity will return a datasubset. You can index into datasubset using the field 'data', for example 'local!datasubset2.data' and this will return a list of dictionary. Appian dictionaries can be sliced, this means you can also index into a specific field to get a list of data for that field. For example, 'local!datasubset2.data.submissionunit'. However, since indexing with dot notation might break if the field does not exist, I recommend using the index function. 'index(local!datasubset2.data, "submissionunit", {})'

Sign up

Login with SSO

Login to the community

Login with SSO