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