Help with filtering via text mode

Question

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=NOTEXISTSEXISTS:1:$$OBJCODE=HOUREXISTS:1:ownerID=FIELD:assignedToIDEXISTS:1:taskID=FIELD:taskIDassignedToID=$$USER.IDassignedToID_Mod=in

Rafal_Bainie · Accepted Answer

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

Rafal_Bainie · Answer

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=enIf you need another filter now, than this has to be modified accordingly or removed if you no longer require that Exist filter

Sign up

Login with SSO

Login to the community

Login with SSO