Need to create a Database view for two metric Definitions and Complaint Case table

sreeshsurendran
Tera Guru

3 weeks ago

Hi Team

 

Need to create a Database view to show Products that added before resolving the Complaint and Products added after resolving the Complaint.

 

I have created the Metric Definitions to bring in the data and data is coming as expected. But somehow, I'm not getting how to create the Database views and bring all the data required.

 

This database is required to report on the Products before resolving the Complaint vs the Products after resolving the Complaint.

 

Any help would be grateful.

 

Regards,

Sreesh Surendran

0 Helpfuls
  • 192 Views
1 REPLY 1

sivasankaris
Tera Guru

3 weeks ago

Hi @sreeshsurendran,

You need to use the Metric Instance table as the base table  for your database view because it already stores the information captured by the metrics.

From there, you can join the Complaint table using the complaint record’s sys_id .
If the products are stored in a separate table related to the complaint, you can add that table to the database view as another join based on the reference field that links the product to the complaint.

 

Once the database view is created, you can use the Metric Name in the report to distinguish whether the product was added before the complaint was resolved or after it was resolved. This way, the report can clearly show and compare the products added before resolution versus those added after resolution for each complaint.

 

Please refer the below link, to know about how to create the database view..

Joining tables • Yokohama ServiceNow AI Platform Administration • Docs | ServiceNow

 

If this is helpful.. Please Mark it as helpful and Please Accept My Solution..

 

Best Regards,

SIVASANKARI S

0 Helpfuls