EXISTS filter on a journal entry report

[LaurensKr1]

Hi,

I have used EXISTS filters on various objects within Workfront reporting. 

I am wondering if it is possible to use an EXISTS filter on a journal entry report. I am trying to track changes on a specific field within projects where a specific task exists within projects. I am not sure if this is possible within a journal entry report. 

[skyehansen]

this seems to be possible.

Are you maybe getting stuck on your linking line? (in the documentation linked to below, they refer to a linking field:
https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/text-mode/create-comple... )

If so -- at a guess -- you can probably use "EXISTS:a:projectID=FIELD:projectID"

[LaurensKr1]

Hi Skye,

I was looking at that. I am testing this filter text mode at the moment on a Journal Entry report:
EXISTS:a:$$EXISTSMOD=CONTAINS

EXISTS:a:$$OBJCODE=TASK

EXISTS:a:name=Task name I am looking for in projects

EXISTS:a:projectID=FIELD:ID

fieldname=status

fieldname_Mod-cieq

obObjCode_Mod=isblank

The goal is to track project level status changes where those tasks live in the projects. 

[skyehansen]

Per my previous reply, the issue is with the fourth line of your code block (your linking line) -- kindly swap it out for the line I suggested please and let me know if that works better.