Skip to main content
Mempin
New Member
Mar 4, 2024 5:02 AM UTC
Solved

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

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.
    The_Real_Melinda_Layten
    The_Real_Melinda_LaytenAccepted solution
    Level 3
    Mar 5, 2024 10:59 PM UTC

    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.

    View in thread

    1 reply

    The_Real_Melinda_Layten
    The_Real_Melinda_LaytenAccepted solution
    Level 3
    Mar 5, 2024 10:59 PM UTC

    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.

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...