I have gone through several times, however I'm unable to understand why this error is getting.
Discussion posts and replies are publicly visible
Seems you are trying to get an existing data from one table to another table. In the Database If your are passing an primary ID from parent table to Child table(foreign key) better go with record type and give relationship between two ID's then fetch the data accordingly.
Can you please elaborate it.?I'm new bee to Appian so, please...
The issue is, that you true to compare a list of integers to a single field in DB. This is what the error message tries to tell you.
The curly brackets indicate a list.
So, you can either use the "in" operator to compare, or make sure that this getVendorId expression returns only a single. The index() function might help you in doing that.
getVendorId rule return more than 1 integer value and while filtering out the data you are using "=" operator. Could you please try by using 'in' operator in your query filter. or use index function over the getVendorId function to get only 1 data.
© 2024 Appian. All rights reserved.