Hi All,
I am running this queryEntity in script task inside a process model but i am getting an error
ERROR: Expression evaluation error at function a!queryEntity [line 1]: An error occurred while retrieving the data
a!queryEntity(
entity: cons!tableName,
query: a!query( pagingInfo: a!pagingInfo( 1, - 1 ))
) .data.columnName
Note: I am having 20,000 rows in that table will that be the reason?
Could any one help me with this issue
Discussion posts and replies are publicly visible
I know this is old news now, BUT...
I ran into this problem and just spent the day trying everything I could think of even recreating the table, constants, rules, etc.
Answer was stupid simple...
if you forget to check mark "Allow NULLs" for a date field and create a record, it puts "0000-00-00" in that field. from then on out you fail trying to get anything from that table. Appian cant do a date with zeroes.