AND another textmode trick...

[Doug_Den_Hoed__AtAppStore]

While reading a sidebar in this solved thread with @Richard_Le_ and @Madalyn_Destafney, I remembered a trick I picked up a while ago that I decided to lift up in this separate thread.

For context, Madalyn wanted to filter Tasks twice on the same field (actualCompletionDate), but as Rich pointed out, Workfront does not (As Designed) allow that, "swallowing" one of the directives upon save.

However, in a pattern similar to the more familiar textmode "OR" concept that does allow the same field to be used in two or more separate clauses, Workfront does recognize and correctly execute and "AND" against the same field, which in Madalyn's case would be as follows:

AND:a:actualCompletionDate=$$TODAYb-2m
AND:a:actualCompletionDate_Mod=between
AND:a:actualCompletionDate_Range=$$TODAYe-2m
AND:b:actualCompletionDate=FIELD:plannedCompletionDate
AND:b:actualCompletionDate_Mod=gt

Save until needed.

Regards,

Doug

[Richard_Le_]

Awesome! Thanks so much for sharing, Doug. That is going straight into the text-mode vault for future reference.

[Madalyn_Destafney]

Thanks, Doug! Used in my report : )

[Madalyn_Destafney]

Hi Doug, I've seen EXISTS too in text mode like this. When to use EXISTS vs AND?

[Doug_Den_Hoed__AtAppStore]

Hi @Madalyn_Destafney,

As a general rule, I use AND when I can, and EXISTS when I have to.

Regards,

Doug