I am trying to compare date in expression rule but i am getting very strange error in that.
Kindly help me out in this.
ri!date - "2/24/2018" type Date
error : Expression evaluation error at function a!queryEntity [line 11]: Cannot apply operator [EQUALS] to field [date] when comparing to value [TypedValue[it=107,v={2018-02-24}]].
load( local!pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1, sort: a!sortInfo( field: "a", ascending: true ) ), with( a!queryEntity( entity: cons!TEST, query: a!query( filter: a!queryFilter( field: "date", operator: "=", value:=todate(ri!date) ), pagingInfo: local!pagingInfo ) ).data ))
Discussion posts and replies are publicly visible
The error suggests a mismatch between types.
What is the type of the field "date" in the CDT for that entity?
What is the type of the rule input ri!date? Is it possibly an array of Dates...? It's calling out the value of {2018-02-24} as type 107 which is "List of Date with Timezone"
very similar issue here but with different types: community.appian.com/.../i-am-creating-a-query-entity-rule-where-i-need-to-compare-one-of-my-ri-value-whi