getting error on sorting when grid contains toDatasubset

Forum|Forum|2 years ago
February 15, 2024
4 replies
0 views

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:

mikes0011

Brainy

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.

snehalm0001Author

Participating Frequently

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

stefanhelzle0001

Brainy

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.

Sign up

Login with SSO

Login to the community

Login with SSO