- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-28-2016 01:38 PM
I noticed that when I pull my table via REST, any columns that are type "Journal" and "Choice" are empty in my JSON object. They are there in Servicenow though.
Maybe i'm missing something.
Please let me know.
Thanks.
Dave
Solved! Go to Solution.
- Labels:
-
Scripting and Coding

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-28-2016 03:13 PM
Those journaled values aren't stored on that record. they are stored on a combination of sys_audit, sys_history_line, and sys_journal, DONT JUST LOAD those tables they're huge.
Here's some threads about people getting the notes, but I think it's a big gap in the tool.
sys_journal_field not available in REST api
What is the best way to find sys_audit record for sys_journal_field

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-28-2016 02:15 PM
var notes = current.work_notes.getJournalEntry(-1); //gets all journal entries as a string where each entry is delimited by '\n\n'
var worknotesArray = notes.split("\n\n"); //stores each entry into an array of strings

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-28-2016 03:13 PM
Those journaled values aren't stored on that record. they are stored on a combination of sys_audit, sys_history_line, and sys_journal, DONT JUST LOAD those tables they're huge.
Here's some threads about people getting the notes, but I think it's a big gap in the tool.
sys_journal_field not available in REST api
What is the best way to find sys_audit record for sys_journal_field