Adding sys_journal_field to a DB view for reporting - assistance

[tysteelsii]

Hello.

I've created the following database view which I run various RITM-TASK reports with:

The view is working well for me since I'm only showing one variable and the variables in rows in the report aren't an issue.   I want to add associated work notes/activity entries in my report so I need to add the sys_journal_field table.   The problem is that I'm confused on the "Where clause" as well as the view fields needed in sys_journal_field table which needs to be added.   I know I want to see the "value" but there's "element", "element ID" and more in sys_journal_field table.  

Any help would be appreciated.

Ty Steels II --

[Deepak Kumar5 · Accepted solution]

[tysteelsii]

Thank you very much.   This helped immensely.