SORTING - Error at function fn!error [line 120]: Invalid field identifier: "#"urn:appian:record-field...

Hello all,

Just checking to see if anyone knows how to sort a grid's field when the data property is not a typical query. Please see code below for what I mean.

The grid displays as expected with values and all, but when trying to sort the fields I get the error in the Subject above. Are there any other ways to sort other than [recordType.field] or [recordType.relationship.field]?

I did see an earlier post solution on here with similar error, but that scenario was quite direct working with recordData for the data property of the grid. Any input regarding this particular scenario would be much appreciated. Thanks

a!gridField(
      label: "Grid for  ",
      labelPosition: "COLLAPSED",
      emptyGridMessage: "No reports for this day",
      data: index(local!reportsPerDayOfLastSevenDays, local!selectedDay),
      columns: {
        a!gridColumn(
          label: cons!LABEL_NAME,
          sortField: 'recordType!{8360b17d-94c9-478d-af7a-8e685ada463b}LNU Rep Sched.fields.{f4d0c828-fe5b-4064-90b2-f12ce802e849}reportId',
          value: a!linkField(
            links: a!recordLink(
              label: index(
                fv!row,
                'recordType!{8360b17d-94c9-478d-af7a-8e685ada463b}LNU Rep Sched.relationships.{5afa58bb-0a4b-4f63-94f0-58116be2d973}lnurep.fields.{5c4a840d-3d2c-4bc9-9fb5-fc8041123628}reportName'
              ),

  Discussion posts and replies are publicly visible

Parents Reply Children