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
Discussion posts and replies are publicly visible
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.
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 belowHave a local variable where you get the group Ids and then use those to filter.