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?

[LaurentChicoine]

I don't know if it is related to the fact that I tried it on the Istanbul release but I have no problem seing the Comments and Work Notes field on the Incident metric database view.

Could you try to make a report on the Incident Metric database view and see if you're able to see the field's content?

[kchorny]

I did what you suggested, and when I run a report on the incident_metric view and add the comments and work notes field, it shows no values.   I did the same in my personal dev instance with the same results.   Both are on Helsinki.   I'm going to upgrade my dev instance and see if it works after that.

[kchorny]

I upgraded my personal dev instance to Istanbul, and it does work there now. 😕

[sergiu_panaite]

Hi Karla,

We cannot do reporting on journal fields as far as I know.

Look at the screen below:

You can't display that data in one field.

[reginabautista]

Hi Karla, as far as I know when you are using database views it would create a new set of fields for the combined tables. Try to open one of the records in the database view then do Show XML. Find the field you are looking for and update the list view with this field.