Join asmt_metric_result table with sc_task table Database View
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-22-2022 01:35 AM
Hi All,
We want to join tables asmt_metric_result and sc_task to create a database views.
Aim is to get sc task assignment groups for each survey.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-22-2022 03:40 AM
Hi Vasantharajan,
We are not able to get the information that we are trying to.
The requirement is as below :
We want to get surveys of incident and requests broken down by assignment group in performance analytics
request table (REQ) does not have any field in table for assignment group, however we want to consider assignment groups of sc_task table. perhaps we are trying to join asmt_metric_result table to sc_task to get data.
the metric assessment database joins with task table but we are not able to get sctask assignmnet group by the databse.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-22-2022 06:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-07-2025 12:45 PM
Did you ever manage to do this, I'm trying to do the same.