How do I know which field in the table is sys_id?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-17-2023 05:00 PM
6 REPLIES 6
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-19-2023 11:23 AM
The element_id field is being used by the sys_journal_field table to associate it with the record the comment (journal entry) was added to. The comment is a record on the sys_journal_field and has it’s own sys_id.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-19-2023 10:39 AM
Look at reference fields in the desired table for the 'Requested Item' table. Those table records will contain the sys_id value of the record in 'Requested Item' table.