Join asmt_metric_result table with sc_task table Database View

Eddie5
Tera Contributor

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.

7 REPLIES 7

Eddie5
Tera Contributor

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.

sc_task table extends task table. So Task assignment group and sc_task assignment group will be same (Hope you are not using any custom assignment group field created in sc_task table). 

You can create a report with the filter in the screenshot

find_real_file.png


Thanks & Regards,
Vasanth

mgalvin
Tera Contributor

Did you ever manage to do this, I'm  trying to do the same.