Skip to main content
LaurensKr1
LaurensKr1
Level 2
February 17, 2025
Question

EXISTS filter on a journal entry report

  • February 17, 2025
  • 3 replies
  • 449 views

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. 

3 replies

skyehansen
skyehansen
Level 4
February 17, 2025

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-complex-text-mode-filters-using-exists-statements )

 

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

LaurensKr1
LaurensKr1Author
Level 2
February 18, 2025

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
skyehansen
Level 4
February 18, 2025

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.

Terms & ConditionsAccessibility statement

Loading footer...