Expression evaluation error at function a!queryEntity [line 5]: Cannot apply operator [EQUALS] to field [vendorId] when comparing to value [TypedValue[it=101,v={1}]].

Question

I have gone through several times, however I'm unable to understand why this error is getting.

Prateek · Answer

Hi shukurs0001 , It looks like local!vendorId is either returning a list of integers, which might not be what you're expecting, or it's returning a single integer wrapped in a list. Depending on your use case, you can resolve the issue as follows: 1. If you want the filter to work with a list of integers, use the "in" operator : a!queryFilter( field: "vendorId", operator: "in", value: a!flatten({ local!vendorId }), applyWhen: a!isNotNullOrEmpty(local!vendorId) ) 2. If you want the filter to work with a single integer, use the "=" operator, but ensure the value is treated as a single integer : a!queryFilter( field: "vendorId", operator: "=", value: cast(1, local!vendorId), applyWhen: a!isNotNullOrEmpty(local!vendorId) ) Also, since you're new to Appian, here's a quick tip: Instead of using an if condition, you can simplify things by using a!isNotNullOrEmpty .

Expression evaluation error at function a!queryEntity [line 5]: Cannot apply operator [EQUALS] to field [vendorId] when comparing to value [TypedValue[it=101,v={1}]].

Top Replies