Task report filtered by task owner/ assigned group member

Question

Hello All- 
 There is a requirement to display all the tasks name along with other details in an interface and the data should be filtered by the task owner/ assigned group. When task owner or the user of the assigned group logs in, the user should be able to view all the details along with the tasks which are assigned to the user. 
 I am using query process analytics to fetch details from a task report within read-only grid. Any advice? TIA

Konduru Chaitanya · Answer

You will have to create task report and add a field for the owner/assignee in the configuration if not present . Once you get the column added take the column identifier such as c2, or c5 or so and add the field in your query and in the value ri!variable or loggedInUser. 
 In the Report Designer click on edit and select the Owner/Assignee in the show column

In your query add the field/column Name 
 
 ri!user will contain the value as loggedInUser. 
 
 If you are not unable to find the column name you can find it without adding the indexing of data. 
 
 Field from the dictionary will be your field value.

Harshit Bumb (Appyzie) · Answer

This blog of mine should help you understand the complete procedure, including filtering part - appianspace.com/.../

Stefan Helzle · Answer

I suggest to use a slightly different approach. Trying to add a query filter that handles all the assignment and group complexity will not work. 
 Use a process of type "Tasks per User". Then Appian will do all the filtering for the logged in user, including group memberships etc. If you then need to filter for tasks in specific processes, add the process model UUID to the report and filter by the models you need.