Interface Definition: Expression evaluation error at function a!gridField [line 212]: Invalid field identifier: "#"urn:appian:record-field:v1:f93971d1-a676-475d-bcde-b5eb7ffea268/66d74798-e23e-48d6-8801-b307250c1052""
I am getting data from external system and mapping it into Appian. I am mapping it to appian record since will be storing it using write to record.
I wanted to do sorting on all the columns using code below but getting this error when trying to sort:
Discussion posts and replies are publicly visible
You're wrapping your "data" parameter in "dataSubset()" here for some reason -- instead you should be querying it initially in a way that returns a dataSubset and then just using that for the "data" parameter. I'm guessing it might be messing up the data type the grid thinks it's seeing.
I was trying that for resolving this error, even without datasubset I get same error. The thing is I am getting data from a!queryrecordData instead of recorddata. i think thats what is messing it up, But I have to since I have to get result on click of search. not out of the box one's
When you query data outside the grid and store it in a local variable, you need to also manage the paging info. Add another local variable with a default paging info and use this to query the data and also to feed it into the grid.
Example here: https://docs.appian.com/suite/help/23.4/read-only-grid-configuration.html#query-in-a-local-variable