• State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 9 replies
  • Subscribers 4 subscribers
  • Views 14649 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Reports

How can I get all the tasks where loggedInUser is an Assignee

vbhardwaj
Certified Senior Developer

Have a task report with an "Assigned To" column which can have multiple users based on the task type.

Using queryProcessAnalytics() in one of the task reports to get the tasks where logged in user is a part of the assignees.

Using the following query filter :
a!queryFilter(field:"c1",operator:"includes",value:loggedInUser()),

But its not working as expected. How can I get all the tasks where loggedInUser is an Assignee.

Thanks in advance.

OriginalPostID-216672

OriginalPostID-216672

  Discussion posts and replies are publicly visible

Parents
  • 0
    @vikrantb To the best of my knowledge, whatever you have been trying is not possible.

    But you can opt for an alternate way as mentioned below:
    1. Create a Task Report which gets the Tasks based on User Context and add the Process Model Id (pm!id) in the Report as a column.
    2. Use a!queryProcessAnalytics() with the desired users as the contextUsers argument and apply the desired process model ids as filter by making use of filters argument.
    3. As there could be a possibility of getting duplicate results(as the group tasks are open for all the users), discard the duplicates from the resultant dataset and the resultant dataset minus duplicates is the actual result what you are looking for.

    Until and Unless I miss something, above mentioned approach should do the job as per my knowledge.
Reply
  • 0
    @vikrantb To the best of my knowledge, whatever you have been trying is not possible.

    But you can opt for an alternate way as mentioned below:
    1. Create a Task Report which gets the Tasks based on User Context and add the Process Model Id (pm!id) in the Report as a column.
    2. Use a!queryProcessAnalytics() with the desired users as the contextUsers argument and apply the desired process model ids as filter by making use of filters argument.
    3. As there could be a possibility of getting duplicate results(as the group tasks are open for all the users), discard the duplicates from the resultant dataset and the resultant dataset minus duplicates is the actual result what you are looking for.

    Until and Unless I miss something, above mentioned approach should do the job as per my knowledge.
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.