I have created Expression rule with queryEntity() function. It connects with dis

I have created Expression rule with queryEntity() function. It connects with distant database, and fetches data.
The rule works fine in dev environment. but it fails in another environment.
I tried publishing datastore for entity: MY_PROJECT_CUST
Rule is:
a!queryEntity(
entity: cons!MY_PROJECT_CUST,
query: a!query(
selection: a!querySelection(
columns: {
a!queryColumn(
field: "CUST_ID"
),
a!queryColumn(
field: "CUST_NME"
)
}
),
pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: - 1,
sort: a!sortInfo(
field: "CUST_NME",
ascending: true()
)
)
)
).data

I am getting error:Expression evaluation error at function a!queryEntity [line 2]: An error occurred while retrieving the data.

OriginalPostID-187384

OriginalPostID-187384

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data