How do I know which field in the table is sys_id?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-17-2023 05:00 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-17-2023 05:02 PM
Hi, the sys_id field is system generated and always called sys_id.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-17-2023 05:10 PM
I already know the content.
ex) Requested item record's sys_id is element_id in sys_journal_field table
When I don't know the above, how can i know that?
This is my question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-17-2023 06:28 PM
Hi, this is a different question; but the requirement is still not clear.
The sys_id of your request item record will appear in the element_id field of the sys_journal_field record. If you don't know the sys_id of your request item record you will need to find it either manually by looking at the request item record - it is visible in the URL from the form view, or via the records xml file.
Or if you are writing a script you can use GlideRecord to query the task records table based on some other unique value like the task number.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-17-2023 08:11 PM
That's what I know.
My question is....
when i know requsted item record's sys_id (ex) a55f2748db68651058f1d19ed39619b6)
I want....
How to find a field connected to sys_id(a55f2748db68651058f1d19ed39619b6)
