Filtering out issues with multiple assignments | Community
Skip to main content
A
Anonymous
January 24, 2023
Solved

Filtering out issues with multiple assignments

  • January 24, 2023
  • 2 replies
  • 1472 views

Hi Workfront Community!

 

I have been working on an Issue Report for a team that self-assigns their work. Ideally, the report would show issues with the specific team and job roles assigned. Once the user (with the correct job role) assigns themselves, it would no longer appear on the report. The issue is sometimes these issues will have other folks assigned to them as well. I have been trying to leverage the Assignments options, but they don't seem to work. Current filters are below with IDs replaced by usable information:

 

assignmentsTeamsMM:ID="Team assigned to the Issues"
assignmentsTeamsMM:ID_Mod=in
assignmentsUsersMM:roleID="Job Role 1" "Job Role 2"
assignmentsUsersMM:roleID_Mod=notin
status=CLS DED DUP
status_Mod=notin

 

This looks like it should grab issues with the specified Team assigned and then it should look at the Users in the Assignments list and filter out issues if any have the specified roles, but it doesn't seem to work. I can't tell if I am miss understanding how assignmentsUsers/assignmentsTeams works or what. Any help would be appreciated!!

 

Thanks,

Rob

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Madalyn_Destafney

    Hi there, are wanting to pull assignment teams OR assignment roles and not AND? If you're trying to pull either scenario, and not necessarily both scenarios at the same time, then do your team filters OR your role filters, not AND.

    2 replies

    ChrisStephens
    Community Advisor
    ChrisStephensCommunity Advisor
    Community Advisor
    January 25, 2023

    Try using

     

    assignmentsRolesMM:ID= the job roles

    assignmentRolesMM:ID_Mod=notin

    A
    Anonymous
    January 25, 2023

    Hey @chrisstephens -

     

    When I use that filter, it takes out the unassigned issues that just have the Role. I guess I can just request the issue not be assigned to the Role as well as the Team. We default assign the team and role, but maybe this just won't work that way. 

     

    Thanks for the suggestion

    ChrisStephens
    Community Advisor
    ChrisStephensCommunity Advisor
    Community Advisor
    January 25, 2023

    Ah yea, sorry!

    Madalyn_Destafney
    Community Advisor
    Madalyn_DestafneyCommunity AdvisorAccepted solution
    Community Advisor
    January 25, 2023

    Hi there, are wanting to pull assignment teams OR assignment roles and not AND? If you're trying to pull either scenario, and not necessarily both scenarios at the same time, then do your team filters OR your role filters, not AND.

    If this helped you, please mark correct to help others : )
    A
    Anonymous
    January 26, 2023

    Thanks for your suggestion!

     

    The Team filter is an "In" looking to grab tasks that have the Team Assigned, but my User: Job Role filter is a "Not In" with the intent being to filter out tasks/issues that have already been picked up by the appropriate team member. So I think I should be using AND in this case, because I want tasks that are assigned to the Team AND don't have a user with the specified roles assigned. 

     

     

    Terms & ConditionsAccessibility statement

    Loading footer...