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

[Dr Atul G- LNG]

Hi @Scott29 

Metrics are used to track the previous state or assignment group of a record. I'm not sure what your exact requirement is regarding the 1-to-M relationship."

[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

[Chaitanya ILCR · Accepted solution]

Hi @Scott29 ,

if you have created a metric definition for SC task table

you should be able to see Metrics (just configure the related lists and add metrics)

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

[Scott29]

Thanks, you are correct. I checked for the relationship before I built the metric.