Filter is not working on history table

[vinod6]

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!

[J Siva]

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

[Shree_G]

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>.

[Ankur Bawiskar]

@vinod6 

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.

[Sandeep Rajput]

@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.