ODBC guide

Read incident work notes


Retrieve Work Notes added to incidents. Work notes are stored as journal entries in the sys_journal_field table, not directly on the incident record.

This example returns all internal notes entered by agents.

-- Get work notes for all incidents
SELECT *
FROM get_table_rows
WITH(
	TableName='sys_journal_field',
	Query='name=incident^element=work_notes'
)