Filter is not working on history table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-14-2025 12:48 AM
In the sys_history_line.list table, I have applied the filter condition, but it is not working. Please see the attachments below.
Without filter condition under set file records is available but applying the filter records is not showing
see the below one before the applying the filter
Afterfilter
The Set field contains records like INC, CAS, RITM, etc., but none of them are showing
Please provide a solution for this it is very help full
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-14-2025 01:00 AM
Hi @vinod6
The 'Set' field is a reference field that refers to the 'sys_history_set' table. The 'ID' field is the display field on the 'sys_history_set' table and is of type Document ID."
Searching with the record number doesn't work because it stores the SYS ID.
Try searching with the record sys id. i.e Incident record sys_id. It'll work.
Searching with record sys_id:
Hope it helps.
Regards,
Siva
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-14-2025 01:10 AM - edited ‎04-14-2025 01:12 AM
Hello @vinod6 ,
Set is <sys_id> of record you want to search. Also the History [sys_history_line] table stores the actual changes to field values that occurred.
So get sys_id of incident/RITM, search for Set is <sys_id>.
If this solution helped resolve your issue, please consider marking it as helpful or correct.
This will assist others in finding the solution faster and close the thread.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-14-2025 01:48 AM
I agree with point shared by @J Siva
That's the correct way to apply filter for document id field types
Document id field always store sysId
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-14-2025 03:52 AM
@vinod6 You can dot walk to the table field on the Set reference field and apply a filter of table name.
In your case the table name will be incident and it will bring you the list of incident records in this table.