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
6 replies
Subscribers
7 subscribers
Views
4186 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
I'm receiving an error: “Expression evaluation error at function 'union&
stephens
over 9 years ago
I'm receiving an error: “Expression evaluation error at function 'union' [line 15]: Cannot compare type List of Number (Integer)”
I'm using the following expression to return a list of application ids, which is then passed through a ‘union’ command to remove duplicate ids. The error appears to manifest when the list of returned application ids reaches a certain size (around about 40 ids), less than that the expression runs as expected.
Any suggestions why this maybe happening?
=with(
local!tasks: a!queryProcessAnalytics(
report: cons!LUA_OPEN_TASKS_REPORT_DOCUMENT,
contextProcessModels: cons!LUA_OPEN_TASKS_PROCESS_MODELS,
query: a!query(
filter: a!queryFilter(
field: "c10",
operator: "in",
value: ri!user
),
pagingInfo: a!pagingInfo(startIndex: 1, batchSize: -1)
)
),
union(local!tasks.data.c7, local!tasks.data.c7)
)
The output query format is:
[label:Process,field...
OriginalPostID-154528
OriginalPostID-154528
Discussion posts and replies are publicly visible
Parents
0
stephens
over 9 years ago
...EXT,configuredDrilldown:CUSTOM_URL];
[label:Process Id,field:c14,drilldownField:dp14,configuredFormatting:NUMBER,configuredDrilldown:]; [label:Name,field:c15,drilldownField:dp15,configuredFormatting:NORMAL_TEXT,configuredDrilldown:]; [label:parentProcessId,field:c16,drilldownField:dp16,configuredFormatting:NUMBER,configuredDrilldown:], errorMessage=]
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
stephens
over 9 years ago
...EXT,configuredDrilldown:CUSTOM_URL];
[label:Process Id,field:c14,drilldownField:dp14,configuredFormatting:NUMBER,configuredDrilldown:]; [label:Name,field:c15,drilldownField:dp15,configuredFormatting:NORMAL_TEXT,configuredDrilldown:]; [label:parentProcessId,field:c16,drilldownField:dp16,configuredFormatting:NUMBER,configuredDrilldown:], errorMessage=]
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data