Join asmt_metric_result table with sc_task table Database View

[Eddie5]

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.

[Vasantharajan N]

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

[Shivani_singh]

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

[Vasantharajan N]

@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.

[Shivani_singh]

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