Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
15 replies
Subscribers
9 subscribers
Views
11447 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Expression evaluation error at function a!queryEntity [line 6]: An error occurred while retrieving the data.
ajinkyab277
Certified Lead Developer
over 8 years ago
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
0
chetany
A Score Level 1
over 8 years ago
@ajinkyab277, I tried the same thing as you mentioned.
The code snippet is:
load(
local!pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: - 1
),
a!queryEntity(
entity: cons!EMP_ENTITY_EMPLOYEE,
query: a!query(
pagingInfo: local!pagingInfo
)
)
)
Now, first I typed it manually - and it was not formatted and then tested, I got the same error as you - "An Error occurred while retrieving the data: line 7".
Then I just formatted the code using Ctrl+Shift+F in the expression editor.
And then it started working fine.
I know this sounds very strange, but this is what I observed
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ajinkyab277
Certified Lead Developer
over 8 years ago
@chetany : Tried formatting code. But still same issue.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
chetany
A Score Level 1
over 8 years ago
I could not reproduce it again. But, it did happen, it was the same code before formatting..
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ajinkyab277
Certified Lead Developer
over 8 years ago
Got the issue: I had some Fields in CDT with @Transient JPA annotation. After removing those field it started working
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
chetany
A Score Level 1
over 8 years ago
Thanks for the update. As far as I know, @Transient fields will not be persisted in DB..so maybe that was causing the problem
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
<