Help with filtering via text mode | Community
Skip to main content
J
Justin_Charles
Level 3
February 22, 2023
Solved

Help with filtering via text mode

  • February 22, 2023
  • 2 replies
  • 1109 views

Hello!  I worked with a consultant to get the code below to show a list of tasks (1 line item per assignee, even if there were multiple assignees on a task) for tasks that have 0 actual hours.  I want to remove the "for tasks that have 0 actual hours" filter, but I can't figure out how.  Removing the first line, or the first 2 lines did not work.  Anyone have ideas?  Thanks in advance!

 

EXISTS:1:$$EXISTSMOD=NOTEXISTS
EXISTS:1:$$OBJCODE=HOUR
EXISTS:1:ownerID=FIELD:assignedToID
EXISTS:1:taskID=FIELD:taskID
assignedToID=$$USER.ID
assignedToID_Mod=in

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 Rafal_Bainie

you need assignment report instead, you won't achieve this with task report, but you can easily do this with assignment report. In this report use Assigned To>>Name field.

For any task you will get as many entries as you have assigned users

2 replies

Rafal_Bainie
Community Advisor
Rafal_BainieCommunity Advisor
Community Advisor
February 23, 2023

Hi Justin,

what you have here is called "exist filters" and their syntax is such that you cannot just have part of it. 
https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/create-complex-text-mode-filters-using-exists-statements.html?lang=en

If you need another filter now, than this has to be modified accordingly or removed if you no longer require that Exist filter

J
Justin_CharlesAuthor
Level 3
February 23, 2023

Thanks Rafal.  Do you know the text code that will achieve what I'm looking for?  I'm looking for a task report that will show all tasks as 1 time item per assignee.  For example if there is a task with 2 people assigned to it, it will show as 2 line items - 1 for each assignee.

Rafal_Bainie
Community Advisor
Rafal_BainieCommunity AdvisorAccepted solution
Community Advisor
February 23, 2023

you need assignment report instead, you won't achieve this with task report, but you can easily do this with assignment report. In this report use Assigned To>>Name field.

For any task you will get as many entries as you have assigned users

    RandyRoberts
    Community Advisor
    RandyRobertsCommunity Advisor
    Community Advisor
    February 23, 2023

    Hmmm… When I paste that in as is, I get a Whoops! error.Some of this code makes no sense:

    EXISTS:1:$$EXISTSMOD=NOTEXISTS EXISTS:1:$$OBJCODE=HOUR

    The object code "hour" does exist, it's just zero. This code alone returns nothing in my instance.

    EXISTS:1:ownerID=FIELD:assignedToID

    OwnerID = AssignedToID returns only primary assignees, not secondary

    EXISTS:1:taskID=FIELD:taskID

    taskID will always match taskID, this seems redundant

    assignedToID=$$USER.ID assignedToID_Mod=in

    This will return only tasks assigned to ME

     

    Maybe I'm wrong but since this returns an error for me, I'd say it doesn't work.

     

    Terms & ConditionsAccessibility statement

    Loading footer...