Text Mode EXISTS filter, how to reference the Parent Custom field | Community
Skip to main content
M
Mempin
New Member
March 4, 2024
Solved

Text Mode EXISTS filter, how to reference the Parent Custom field

  • March 4, 2024
  • 1 reply
  • 843 views

Hi, need help on this one.  

 

I'm trying to filter Projects that:

  1. have Tasks that are on the Iteration , and that Iteration has a status of "In Progress"...
  2. AND has a launch date (Project custom field = "Campaign Launch Date") happening between the Iteration start and end date.

 

I manage to accomplish # 1 starting with below:

EXISTS:1:$$OBJCODE=TASK
EXISTS:1:iteration:status=INP
EXISTS:1:iteration:status_Mod=in
EXISTS:1:projectID=FIELD:ID

 

... then started to try below to add #2 and got nowhere. Please help and if you have alternate solution. Thanks in advance.

EXISTS:1:$$OBJCODE=TASK
EXISTS:1:iteration:endDate=FIELD:DE:Campaign Launch Date
EXISTS:1:iteration:endDate_Mod=gte
EXISTS:1:iteration:startDate=FIELD:DE:Campaign Launch Date
EXISTS:1:iteration:startDate_Mod=lte
EXISTS:1:iteration:status=INP
EXISTS:1:iteration:status_Mod=in
EXISTS:1:projectID=FIELD:ID

    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 The_Real_Melinda_Layten

    Whenever I'm making an exists filter, I start by building that filter directly on the object type in question.

     

    So get your filter working in a task report, and then you can copy that filter into the exists framework you've already built here.

    1 reply

    The_Real_Melinda_Layten
    The_Real_Melinda_LaytenAccepted solution
    Level 3
    March 5, 2024

    Whenever I'm making an exists filter, I start by building that filter directly on the object type in question.

     

    So get your filter working in a task report, and then you can copy that filter into the exists framework you've already built here.

      Terms & ConditionsAccessibility statement

      Loading footer...