Using an MM field in a task collection column | Community
Skip to main content
imgrund
Adobe Employee
imgrundAdobe Employee
Adobe Employee
June 3, 2020
Question

Using an MM field in a task collection column

  • June 3, 2020
  • 1 reply
  • 540 views

Hi, I have a request where they want a task collection column in a project report, but the filter is that a certain role is assigned. Now, there isn't a way to guaranteed that the role will be the Task Owner, so I was thinking I would try the assignmentsRolesMM:ID you can do in a task report.

However, when I put {assignmentsRolesMM}.{ID}=51003a37000adbe5e63492b3c19a9ccf or {assignmentsRolesMM}.{ID}="51003a37000adbe5e63492b3c19a9ccf" in my IF statement, it doesn't work.

Has anyone either 1) figured out how to use MM fields in a task collection, or 2) has come up with a way to filter on a task collection for any assignee (whether User or Role)?

Thank you so much :)

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

    1 reply

    S
    SuryaLa1
    Level 2
    June 9, 2020

    Haven't used MM fields but if you are trying to filter for only projects with a specific role/individual assigned to a task you might be able to achieve that with the following filter:

    tasks:roleID={roleID}

    tasks:roleID_Mod=in

    OR

    tasks:assignedToID={userID}

    tasks:assignedToID_Mod=in

    If you're just trying to add a column with showing Role/assigned users for only some particular values the following works too:

    valueexpression=IF({assignedTo}.{role}.{name}="Copywriter",{assignedTo}.{name},"")

    You can also use {assignedToID},{assignedTo}.{roleID} for the expression.

    Although you might want to add a unique identifier for specific tasks you are looking for or the column would just show all names/roles that match the criteria.

    Hopefully this helps.

    Best,

    Surya

    imgrund
    Adobe Employee
    imgrundAdobe EmployeeAuthor
    Adobe Employee
    June 9, 2020

    Thank, Surya. But unfortunately I cannot guarantee that the role will be the task owner. Almost every task we have has multiple assignees so role ID on it's own (or assignedTo's role) doesn't work.

    In a task report, I can use {assignmentsRolesMM}.{ID} which works beautifully, but I can't get it to work in a task collection on a project report (my guess being it is technically a collection within a collection), but was hoping someone found some magically way to do it. ;)

    Terms & ConditionsAccessibility statement

    Loading footer...