Skip to main content
Participating Frequently
Mar 20, 2021 6:11 AM UTC
Question

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

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
    Mar 20, 2021 11:10 AM UTC

    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
    Participating Frequently
    Mar 20, 2021 12:45 PM UTC

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

    csteward
    Brainy
    Mar 20, 2021 4:12 PM UTC

    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
    Participating Frequently
    Mar 20, 2021 5:35 PM UTC

    thanks alot for the help