ServiceNow Metrics relationship between sc_task and metric_instance

[Scott29]

I created new metric definitions for the sc_task table. I have never created a relationship between tables before. How can I make a 1-to-many relationship between sc_task and metric_instance? Only the metrics that relate to that task and the task ID are in the metric

I want to be able to show the related metrics on a relationship tab on the bottom of the task form. 

[Rohit Singh · Accepted solution]

Hi @Scott29 ,

To create a related list showing all metrics related to the sc_task record you can do the following.

1. Create a new Custom Relationship. System Definition->Relationships (Table Name: sys_relationship)
2. Applies to -> sc_task (since you want to show related list on SC Task form)
3. Query from -> Metric Table
4. Use script section to build you query. 

(function refineQuery(current, parent) {

	// Add your code here, such as current.addQuery(field, value);

	current.addQuery("id",parent.sys_id);

})(current, parent);

• Now in the SC Task from view use "configure related list" and bring you Custom Relationship in the from using slush bucket.

Refer an example in Incident Form:

If my response helped, please mark it helpful and accept the solution so that it benefits future readers.

Regards,
Rohit

[AndersBGS]

Hi @Scott29 ,

i don’t quite understand your question due to metric and metric definition is to capture previous state or other field change over time. This is not a relationship between tables - so what if that your looking for and what is the business requirement?