Cannot apply operator [EQUALS] error to field [partyName] when comparing to value [...]

Question

Here is the whole error message: 
 Problem: An invalid expression has been encountered in a task. 
 Details: ERROR:An error occurred while evaluating expression: party:cast( 'type!{urn:com:appian:types}CB_Party', a!queryEntity( entity: cons!CB_PARTY_DS_POINTER, query: a!query( filter: a!queryFilter( field: "partyName", operator: "=", value: pv!CIprod.mfgName ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1 /* returns all */ ) ) ).data ) (Expression evaluation error at function a!queryEntity [line 3]: Cannot apply operator [EQUALS] to field [partyName] when comparing to value [TypedValue[it=103,v={LRF Enterprises}]].) (Data Outputs) 
 In the CB_Party table, the field partyName is type text (length 100). The value "LRF Enterprises" was itself a field from an item retrieved from another table in a previous step--that field is also of type text (length 100). 
 Net-net, I'm puzzled why the expression evaluator can't apply [EQUALS] to these fields.

bradc · Accepted Answer

Your pv!CIprod.mfgName appears to be a text array. The EQUALS function expects a non-array variable to be passed. Convert this value to a string by wrapping it in a tostring() function. 
 
Alternatively, you can change the operator to "in" if you wish to allow multiple values.

Cannot apply operator [EQUALS] error to field [partyName] when comparing to value [...]

Top Replies