Querying Journal Fields

[jmiskey]

I have just started working with Journal Fields.   We have some Business Rules that remove groups from Users as they become Inactive, and write an entry to the Journal Field of that User, documenting which Groups that they have been removed from.

I am curious as to the best way to query against these Journal Fields.   Let's say that I wanted to look for a particular Journal Field entry, and once found, see which Users it is applied to.   If I do a sys_journal_field.list, I can see and filter on the Entries (Values) and Table (Name).   However, how can I link back to the User to see which User a particular journal entry is applied to?

Thanks

[Jaspal Singh · Accepted solution]

Hi Joe,

Yes it is possible.

All you need to do is to create a database view for journal table & user table(provided if worknotes are added to User record).

Marked in table column contains table name & variable.

Then you can use the view to report on by adding Value & also User fields as required.

[jmiskey]

Perfect!

Thank you very much!