mix up two tables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-02-2023 03:03 AM
hello community, i want to create a table that display the result of task table and asmt_metric_result.
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-02-2023 03:06 AM
Please use a database view:
Database views (servicenow.com)
Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-02-2023 03:13 AM
Hi, @Peter Bodelier i need a table not a database view it's for an extract purpose i want to extract tasks tickets with satisfaction survey (send or not , satisfaction ....)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-02-2023 03:14 AM
Hi @mregragui_ext,
What can't you do with a database view what you want to do?
For example : task_sla table is also a database view 😉
Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-02-2023 03:58 AM
@Peter Bodelier can you tell me what i need to do in the where clause to join them bases on task number
