Use the Contact and User Table to Create a Case
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-22-2022 09:11 AM
Hello!
We are currently setup to create a case using the contact table but is it possible to pull from both the contacts and user table?
Thank you,
James
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-22-2022 09:17 AM
Hi @joconnor ,
It is not possible on one field.
Because the contact field has reference from customer_contact table
If you wanted to use the sys_user table then you will have to either change its reference table which is not recommended. Because of that their is one more field as "Internal User" present in case form.
It is having reference to sys_user table. You can use that field.
Please Mark My Response as Correct/Helpful based on Impact
Regards,
Gunjan Kiratkar
2X ServiceNow MVP
Community Rising Star 2022
Youtube : ServiceNow Guy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2022 02:57 AM
Hi, You can refer the field 'class' from sys_user table. It will give the key to understand the record from contact or user table.
Suresh.