Hi Community,I am trying to query form Active Task assigned to users in my application from a Process report. I was not able to create a filter for the same to check assigned tasks for selected users.
= a!queryProcessAnalytics( report: cons!I_MY_OPEN_TASKS, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "c0", operator: "includes", value: ri!taskName ), a!queryFilter( field: "c3", operator: "between", value: { ri!assignedOnFrom, a!defaultValue(ri!assignedOnTo, today()) } ), a!queryFilter( field: "c4", operator: "in", value: ri!assignedTo /*issue at this filter*/ ) }, ignorefilterswithemptyvalues: true() ), pagingInfo: a!defaultValue( ri!pagingInfo, a!pagingInfo( startIndex: 1, batchSize: - 1, sort: a!sortInfo(field: "c3", ascending: false) ) ) ), )
Discussion posts and replies are publicly visible
If you try to display tasks assigned to a user from a specific set of process models, I suggest to create that report the other way around. Start with "Tasks for user" and then filter by process models using a constant with a list of the models.