Skip to main content
March 20, 2021
Question

i am getting expression evalution error when i try to excute following snippet of code

  • March 20, 2021
  • 4 replies
  • 0 views

a!queryEntity(
entity: cons!CH_ENTITY_Clients,
query: a!query(
filter: a!queryFilter(
field: "cid",
operator: "=",
value: ri!rid,

),
pagingInfo: a!pagingInfo(
startIndex: "1",
batchSize: "1"


)
)
).data

    4 replies

    stefanhelzle0001
    Brainy
    March 20, 2021

    OK. And which error message do you get? Pretty difficult to help without knowing what the actual error is!

    You are filtering for the field "cid" and refer to the rule input "rid". Maybe it is just a typo.

    siria0001Author
    March 20, 2021

    i deleted a row in db and i did not update it in xsd so its throwing error while retriving data... 

    csteward
    March 20, 2021

    As Stefan notes, please post a screen shot or copy/paste of the error!  

    Did you delete a column in the DB (vs a row?)  If this occurred you certainly could expect an error without the CDT updated.

    If you deleted a row, this would not cause an error from the code above.  Including that pagingInfo is expecting integer values for startIndex and batchSize, but Appian is converting those types for you (you can remove the quotes). 

    siria0001Author
    March 20, 2021

    thanks alot for the help