Task report filtered by task owner/ assigned group member

Hello amikb0002 

Sounds right. Are you facing any problem in implementing this?

Sorry I missed to ask what I am looking for. I would like to know if there is any way to use the owner/ group name in the query so I can filter the data based on assigned user/ member of the group when the user logs in. 

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.

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.

I have done these steps already. I created a column in the task report with task owner name (tp!owner) but it displays all the user name and assigned groups in a list. Question is how group can be handled for the logged in user? 

Could you please share your report configuration screen shot. Mostly the above three parts in your report and query process analytics.

And your query?

I am looking for a query to handle this group. query with only logged in user can be done but not catering what is expected.

Here owner column holds only group name "WLRD Users"

You will have to check if the user in present in the groups, and show the details. One way to do is as shown below
Have a local variable where you get the group Ids and then use those to filter.

Thank you. Will try that out and keep you posted here. 

Great! Please verify the relevant answers if it worked, Thanks.

This approach appears to be little complex as local!groups will have a list and also c7 also is a list type. So it would need a nested loop.