- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-14-2022 01:30 AM
How to get data from multiple tables in widget which are child to task table?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-14-2022 02:36 AM
Hi Harry,
So you do GlideRecord the complete task table but add a condition with to say task type if one of x,y,z
This is what the query will look like on the task table records -
sys_class_name=change_request^ORsys_class_name=incident
If the answer has helped you, please mark the answer correct/helpful. Thank you.
-Harneet
ServiceNow Certified Technical Architect
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-14-2022 02:00 AM
You can GlideRecord the task table in server script of the widget and store the data in data variables like
data.variable_name = task details;
You can use that in client script like c.data.variable_name and in html code directly as data.variable_name.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-14-2022 02:20 AM
but if i do that it will take data from all tables which are child of task , i need it from specific tables itself
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-14-2022 02:36 AM
Hi Harry,
So you do GlideRecord the complete task table but add a condition with to say task type if one of x,y,z
This is what the query will look like on the task table records -
sys_class_name=change_request^ORsys_class_name=incident
If the answer has helped you, please mark the answer correct/helpful. Thank you.
-Harneet
ServiceNow Certified Technical Architect