Reference fields in archive table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-24-2022 08:24 AM
Hi All,
I am trying to get tree picker view for reference fields fields in form layout of custom archive tables created for my custom tables where as the tree picker view for reference field which are available in my custom table form are not visible when I go to form layout of the archive table. Can someone suggest how can I get it

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-24-2022 11:16 AM
I don't think archive works that way.
If you are talking about table archiving, it is just storing the form values in XML format, and you don't have controls over any of the field, how you would have on your original table.
Stores an xml version of each archived record in the sys_archive_log table. This archive log is the same table for all archive rules, and you cannot alter this behavior. It is also the only place where the sys_id is stored together with the display value for reference fields.
Ref link:
https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/administer/database-rotation/concept/c_ArchiveData.html
Aman Kumar