EXISTS filter on a journal entry report | Community
Skip to main content
LaurensKr1
LaurensKr1
Level 2
February 17, 2025
Question

EXISTS filter on a journal entry report

  • February 17, 2025
  • 1 reply
  • 443 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. 

1 reply

skyehansen
Community Advisor
skyehansenCommunity Advisor
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
Community Advisor
skyehansenCommunity Advisor
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...