Skip to main content
abhishekm0007
Inspiring
Oct 7, 2022 5:55 PM UTC
Solved

Record column sort not working

Hi,

I'm trying to add this grid column sort where my data is being pulled from a record, 

a!gridColumn(
label: "Modified",
width: "2X",
sortField: 'recordType!Record.fields.updatedDt',
value: fv!row['recordType!Record.fields.updatedDt']
),

Now when i try to manually sort on the column getting the error:

Interface Definition: Expression evaluation error [evaluation ID = 779f6:4b583] : An error occurred while executing a save: Expression evaluation error at function fn!error [line 114]: Invalid field identifier: "#"urn:appian:record-field:v1:adaa93fd-a839-446b-9a78-c0ea56a7b0d9/a20944d4-cb3d-4847-877e-ce0bf6144e3b"".

    4 replies

    Participating Frequently
    Oct 7, 2022 6:08 PM UTC

    Your are passing the sort field in quotes that is not correct select the field directly using recordType.

    and the error is also stating the same 

    [quote userid="169431" url="~/discussions/f/data/26163/record-column-sort-not-working"] fn!error [line 114]: Invalid field identifier:[/quote]

    We need to pass it like this 

    abhishekm0007
    Inspiring
    Oct 7, 2022 6:14 PM UTC

    Hi Ujjwal,

    Since i copied the recordtype!record from Appian... its converted to uuid in the text editor, hence the quotes. below is how i have:

    Participating Frequently
    Oct 7, 2022 6:20 PM UTC

    ok I took this wrong