Expand my Community achievements bar.

SOLVED

Journal Entry Report Filtered By Edited By

Avatar

Level 4

Hello,

 

Is there a way to filter by "Edited By?" in a Journal Entry report? I am attempting to create a Journal Entry report that will show the most recent "update" or "action" by (specific) users. 

 

Thank you

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Eric,

You would need to use textmode in the Groupings area of the report to do so, it would look like below:

group.0.linkedname=direct
group.0.namekey=editedBy
group.0.valuefield=editedBy:name
group.0.valueformat=string
textmode=true

It would look like below in the report:

Kurt_Jones_0-1742563109532.png

You should then be able to filter by specific users for their last update to get you want you need

 

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Eric,

You would need to use textmode in the Groupings area of the report to do so, it would look like below:

group.0.linkedname=direct
group.0.namekey=editedBy
group.0.valuefield=editedBy:name
group.0.valueformat=string
textmode=true

It would look like below in the report:

Kurt_Jones_0-1742563109532.png

You should then be able to filter by specific users for their last update to get you want you need

 

Avatar

Level 4

Hi Kurt,

 

Thank you for the response! What field should I use to filter for Journal Entries entered by specific users?

 

UPDATE: The field is named Edited By not Entered By. All good now!