Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.
SOLVED

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

Avatar

Level 1

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

1 Accepted Solution

Avatar

Correct answer by
Level 4

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 solution in original post

1 Reply

Avatar

Correct answer by
Level 4

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.