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

Vasantharajan N
Giga Sage
Giga Sage

Already there is a DB view available in the platform named "Task Assessment Details" reference link to the record is shared below, Please update your instance name and use it

https://instance_name.service-now.com/nav_to.do?uri=sys_db_view.do?sys_id=47cca9829f333100736af84bc42e7007

Note: You can apply filter on Task type to get assessment related to SC task


Thanks & Regards,
Vasanth

Hi @Vasantharajan N 
I have similar requirement ,i want to combine metric result and sc_req_item table.
Can you please help me .

@Shivani_singh - The answer remains same here. You can just apply the filter on the column task type to sc_req_item using the DB view "Task Assessment Details". Please refer to the screenshot in my previous response post.


Thanks & Regards,
Vasanth

Hi @Vasantharajan N 
I did try, but that field is not present in the task table.
Field name is variable.