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
Discussion posts and replies are publicly visible
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.
i deleted a row in db and i did not update it in xsd so its throwing error while retriving data...
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).
thanks alot for the help