Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

Journal Entry Report filtered to ONLY Project Scope

Avatar

Level 2

I want to see only changes on the Priority field in a Journal Entry Report for the Projects.  None of my filters for Scope or Top Obj Code seem to be working...  How do I get only the Projects to return?

 

fieldName=priority
fieldName_Mod=cicontains
entryDate=$$TODAYb-2w
entryDate_Mod=between
entryDate_Range=$$TODAY
changeType=E A
changeType_Mod=in
objObjCode=PROJ
objObjCode_Mod=cicontains
project:status=CUR
project:status_Mod=in

1 Reply

Avatar

Community Advisor

In my tests, updating the priority of a project created a journal entry without a scope value, but updating the priority of a task created an entry with a scope value. Therefore, you should be able to filter "Scope is blank". I did not need a Change Type rule to return the correct list of entries. 

fieldName=priority
fieldName_Mod=cicontains
entryDate=$$TODAYb-2w
entryDate_Mod=between
entryDate_Range=$$TODAY
objObjCode_Mod=isblank
project:status=CUR
project:status_Mod=in


If your JE reports aren't returning any results, you should confirm in Setup > Interface > Update Feeds that you are tracking Priority for the Project object. 

WE_0-1664980649523.png

 

If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf