database view for history and record history table and task table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-05-2017 08:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-05-2017 09:18 AM
Hi Snehal,
Whats the use case here? What do you want to see in the Database view?
Also, before building your use case around these tables, please have a look at the below links of what these tables contain and they records get removed from these tables.
http://wiki.servicenow.com/index.php?title=History_Sets#gsc.tab=0
Hope this helps. Mark the answer as correct/helpful based on impact.
Thanks
Antin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-05-2017 11:04 AM
Hi Antin,
I want all the fields available on the three tables... so that I can display old value, new value,task type , update date time ,etc.. all on one.
Is this possible?
Thanks & Regards,
Snehal Khare
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-05-2017 11:08 AM
You can get all those fields from 'sys_audit' table itself? Also, please check the below URL which explains how the data get removed from history set tables.
http://wiki.servicenow.com/index.php?title=History_Sets#gsc.tab=0
Hope this helps. Mark the answer as correct/helpful based on impact.
Thanks
Antin