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 stephens over 9 years ago

...:c3,drilldownField:dp3,configuredFormatting:NORMAL_TEXT,configuredDrilldown:PROCESS_DASHBOARD]; [label:From,field:c1,drilldownField:dp1,configuredFormatting:USER_NAME,configuredDrilldown:]; [label:Assignee(s),field:c10,drilldownField:dp10,configuredFormatting:USER_OR_GROUP_NAME,configuredDrilldown:]; [label:Owner,field:c9,drilldownField:dp9,configuredFormatting:USER_NAME,configuredDrilldown:]; [label:Received,field:c2,drilldownField:dp2,configuredFormatting:DATE_TIME,configuredDrilldown:]; [label:Completed,field:c11,drilldownField:dp11,configuredFormatting:DATE_TIME,configuredDrilldown:]; [label:Status,field:c5,drilldownField:dp5,configuredFormatting:TASK_STATUS,configuredDrilldown:]; [label:Application Id,field:c7,drilldownField:dp7,configuredFormatting:NUMBER,configuredDrilldown:];
[label:Task Id,field:c12,drilldownField:dp12,configuredFormatting:NUMBER,configuredDrilldown:]; [label:Terminate Application,field:c13,drilldownField:dp13,configuredFormatting:NORMAL_T...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 stephens over 9 years ago

...:c3,drilldownField:dp3,configuredFormatting:NORMAL_TEXT,configuredDrilldown:PROCESS_DASHBOARD]; [label:From,field:c1,drilldownField:dp1,configuredFormatting:USER_NAME,configuredDrilldown:]; [label:Assignee(s),field:c10,drilldownField:dp10,configuredFormatting:USER_OR_GROUP_NAME,configuredDrilldown:]; [label:Owner,field:c9,drilldownField:dp9,configuredFormatting:USER_NAME,configuredDrilldown:]; [label:Received,field:c2,drilldownField:dp2,configuredFormatting:DATE_TIME,configuredDrilldown:]; [label:Completed,field:c11,drilldownField:dp11,configuredFormatting:DATE_TIME,configuredDrilldown:]; [label:Status,field:c5,drilldownField:dp5,configuredFormatting:TASK_STATUS,configuredDrilldown:]; [label:Application Id,field:c7,drilldownField:dp7,configuredFormatting:NUMBER,configuredDrilldown:];
[label:Task Id,field:c12,drilldownField:dp12,configuredFormatting:NUMBER,configuredDrilldown:]; [label:Terminate Application,field:c13,drilldownField:dp13,configuredFormatting:NORMAL_T...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data