Query Entity fails when using operator "include" for the column having NULL value in database. I am using view to retrieve the data.
This is working fine when I remove the query filter having "include" operator.
Seems "include" is having problem with columns having null values specially in case of view.
Anyone, please suggest some solution around this.
Expression evaluation error at function a!queryEntity [line 3]: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [TWMVwDocumentMappingDT4091], query: [queryentity expression], order by: [[Sort[isDeleted asc]]], filters:[((isDeleted = TypedValue[it=26,v=0]) AND (siteId includes TypedValue[it=3,v=AB41855]))])
Discussion posts and replies are publicly visible
This may be a wild guess, but does it have anything to do with your sort? Maybe the values in "isDeleted" are not as expected. Change that and try it out.
© 2021 Appian. All rights reserved.