Skip to main content
banshp0001
banshp0001
June 10, 2021
Question

Query Entity fails when using operator "include" for the column having NULL value in database

  • June 10, 2021
  • 1 reply
  • 0 views

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.

Exception details:

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]))])

1 reply

csteward
csteward
June 10, 2021

Note, I replied in your original thread with this same question:  https://community.appian.com/discussions/f/data/21170/query-entity-fails-when-using-operator-include-for-the-column-having-null-value-in-database 

Terms & ConditionsAccessibility statement