Report on Additional Comments column for Incidents

[Amalesh Bandopa]

I am creating a report on Incident table and using the "Additional Comments" column in it.

I want to add a filter condition on the column "Additional Comments" to check for some text string.

But the field "Additional Comments" is not coming in the add filter condition dropdown list.

Any suggestions?

[Prasun]

Hello Amalesh,

You can not get additional comments in a direct report for incident table.

You have to create a new Database View for that and you have to join sys_journal_field and incident table.

sys_journal_field is the table where all the journal entries are kept. You can query that table using the field name (for you it is Commnets) and the sys_id of that incident. you will get all the comments added in the incident using that query (or report) of the sys_journal_field table.

Useful Links:

Reporting on Journal fields

http://wiki.servicenow.com/index.php?title=Database_Views