hi All,
I have a use case where I have two tables product and LOB. Both have rlobid as a common field. I am fetching all rlobid from product table and storing in a variable (local!pdata). Now if I am passing these id in filter for LOB table , I am getting the below error. I want to fetch names from LOb table corresponding to a given rlobid. What possibly Im doing wrong here. Attached error code. I have inserted my QE code too. Kindly help. Thanks.
a!localVariables( local!pdata: index( a!queryEntity( entity: cons!PLC_DSE_PRODUCT_TYPE, query: a!query( selection: a!querySelection( columns: a!queryColumn( field: "rLobId" ) ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: - 1, ), ), fetchTotalCount: true(), ).data, "rLobId", null ), local!lobdata: index( a!queryEntity( entity: cons!PLC_DSE_LOB, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: a!queryFilter( field: "rLobId", operator: "=", value: local!pdata ), ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: - 1, ), ), fetchTotalCount: true(), ).data, "name", null ), local!lobdata )
Expression evaluation error at function a!queryEntity [line 23]: Cannot apply operator [EQUALS] to field [rLobId] when comparing to value [TypedValue[it=197,v={TypedValue[it=1,v=1],TypedValue[it=1,v=1],TypedValue[it=1,v=1],TypedValue[it=1,v=2],TypedValue[it=1,v=2],TypedValue[it=1,v=2],TypedValue[it=1,v=3],TypedValue[it=1,v=4]}]].
Discussion posts and replies are publicly visible
Hi Shikha
The variable local!pdata would be of type List of Number, you can either cast it to Number using Cast function or apply "in" operator instead of "=".
Hi Hema,
I used the in operator too. Still same error comes.