Database view and journal field

[kchorny]

I've read all of the posts I can find on this subject, and still am not having any luck.

The requirement is to add the Task Notes (u_task_notes) field from the Time Card table to a view that is used for reporting time associated to project tasks.

I added the Task Notes field to the Time Card table in my view, but it displayed blank in the list... makes sense, because it's a journal field.   So I added the sys_journal_field table to the view with the where clause as shown, and added the value, element and element_id fields to its view fields.

But when I 'Try it' the Task Notes field is blank.   I've tried several other changes, nothing is working.

I have confirmed that the majority of time cards do have entries in the Task Notes field.

What am I doing wrong?

[Mani27]

Hi ,

Since you are reporting on sys_journal_field table for which user has no access to read, it is restricting the view access. You need to create a custom read acl for this new table(database view) and add a custom role to that user/ group