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

Question

Hi, need help on this one.

I'm trying to filter Projects that:

have Tasks that are on the Iteration , and that Iteration has a status of "In Progress"...
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

The_Real_Melinda_Layten · Accepted Answer

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.

Sign up

Login with SSO

Login to the community

Login with SSO