Is there a text mode solution for filtering projects when the actual duration is greater than the planned duration? | Community
Skip to main content
Jared_Mauch
Jared_Mauch
Level 6
March 1, 2021
Solved

Is there a text mode solution for filtering projects when the actual duration is greater than the planned duration?

  • March 1, 2021
  • 1 reply
  • 1413 views

I'm trying to filter completed projects in a report when the actual duration is greater than the planned duration but I'm not having success in text mode. I've tried:

actualDuration=FIELD:duration

actualDuration_Mod=gt

actualDuration=FIELD:plannedDuration

actualDuration_Mod=gt

Applying either of those makes the report show no data, but it'll show data when either of those are not applied. Can someone tell me what I'm doing wrong and point me in the right direction? Thanks!

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 imgrund

Hi Jared, looking at the API Explorer (which is a treasure when doing text mode https://one.workfront.com/s/api-explorer) I'm not seeing actualDuration, duration, or plannedDuration as field that exist on a project object type.

I would try...

actualDurationMinutes=FIELD:durationMinutes

actualDurationMinutes_Mod=gt

See if that works for you :)

1 reply

imgrund
Adobe Employee
imgrundAdobe EmployeeAccepted solution
Adobe Employee
March 1, 2021

Hi Jared, looking at the API Explorer (which is a treasure when doing text mode https://one.workfront.com/s/api-explorer) I'm not seeing actualDuration, duration, or plannedDuration as field that exist on a project object type.

I would try...

actualDurationMinutes=FIELD:durationMinutes

actualDurationMinutes_Mod=gt

See if that works for you :)

    Jared_Mauch
    Jared_MauchAuthor
    Level 6
    March 2, 2021

    Hi Anthony,

    That worked for my report. Thanks for the suggestion and the link to the API Explorer!

    Terms & ConditionsAccessibility statement

    Loading footer...