Cannot apply operator [EQUALS] to field

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