a!query inside a!queryProcessAnalytics not working where in we need to show up tasks whose assignedto column is not empty .check if one of the column is not null
query: a!query( filter: a!queryFilter( field: "c8", operator: "is not null") )
Discussion posts and replies are publicly visible
Not sure whether you can have a task which is assigned to nobody. What do you want to achieve?
But besides that, this field is a list and that list can only be empty, but not null. I typically add a special boolean column to the report that does these kinds of logic.
Business request was to give a screen with ONLY assigned tasks on a grid from which they would like to select and reassign the tasks if the current assigned user goes on unplanned leaves.
I think you just need a filter that checks if the user is in the list. You could add a dropdown filter above the grid to allow selecting a user and apply the selected user to the filter like this:
a!queryFilter( field: "c8", operator: "in", value: local!selectedUser )
In the past I implemented extra functionality for this. A managing user selects the user on leave, gets a list of his tasks and reassigns in batch or individually. Was a great success with business.