"Work note" field in the filter of a report

Thibaut
Mega Contributor

Hello,

How do I get the "Work note" field to appear in the filter of an incident report ? I only see the "Work note list" field.

See screenshot.

Thanks.

2 REPLIES 2

Jaspal Singh
Mega Patron
Mega Patron

Hi Thibaut,

 

Unfortunately reporting on Worknotes & Additional Comments field or any field of type journal is not available for reporting.

You need to create a database view for required table (Incident, RITM, etc.) & sys_journal_field table & then report on view accordingly.

Refer link for a check once.

Thibaut
Mega Contributor

Thanks for your answer !