Expression evaluation error at function a!queryEntity [line 6]: An error occurred while retrieving the data.

Certified Lead Developer
I am receiving below error when I try to execute the query entity rule qith below code
------------------------------
load(
local!pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: 20
),
a!queryEntity(
entity: cons!MERCP_DSE_TEST_DS,
query: a!query(
pagingInfo: local!pagingInfo
)
).data
)

--------------------------
However same code works when i just insert query selection in above code


load(
local!pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: 20
),
a!queryEntity(
entity: cons!MERCP_DSE_TEST_DS,
query: a!query(
selection: a!querySelection(
columns: {
a!queryColumn(
field: "CreateUser"
)
}
),

pagingInfo: local!pagingInfo
)
).data
)

----------------------

No error in a...

OriginalPostID-261209

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer
    @Sally: I have also added filter condition which should return only one row. But this time also same error. I am expecting my query rule to return all the columns from the database.
    -----------------------------
    load(
    local!pagingInfo: a!pagingInfo(
    startIndex: 1,
    batchSize: 20
    ),
    a!queryEntity(
    entity: cons!MERCP_DSE_TEST_DS,
    query: a!query(
    filter: a!queryFilter(
    field: "ActivityTypeId",
    operator: "=",
    value: 127
    ),
    pagingInfo: local!pagingInfo
    )
    ).data
    )
Reply
  • 0
    Certified Lead Developer
    @Sally: I have also added filter condition which should return only one row. But this time also same error. I am expecting my query rule to return all the columns from the database.
    -----------------------------
    load(
    local!pagingInfo: a!pagingInfo(
    startIndex: 1,
    batchSize: 20
    ),
    a!queryEntity(
    entity: cons!MERCP_DSE_TEST_DS,
    query: a!query(
    filter: a!queryFilter(
    field: "ActivityTypeId",
    operator: "=",
    value: 127
    ),
    pagingInfo: local!pagingInfo
    )
    ).data
    )
Children
No Data