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...

Discussion posts and replies are publicly visible

Parents

0 Amitkumar over 9 years ago

Just note that, this type of error is more prevalent with functions such as difference, union, wherecontains, contains, and etc. where all inputs required must be of same type. And appropriate casting needs to be done prior to execution at design time to avoid an error.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Amitkumar over 9 years ago

Just note that, this type of error is more prevalent with functions such as difference, union, wherecontains, contains, and etc. where all inputs required must be of same type. And appropriate casting needs to be done prior to execution at design time to avoid an error.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data