getNumericValue() in glide duration type field is returning undefined?

[SatheeshKumar]

I’m trying to extract the duration values from a metric instance record in a GlideRecord, but getNumericValue() is not working and is returning undefined. What are the other ways to access values from a duration field?

In the end, I need to sum the values from two instance records.

Tried both

var gr = new GlideRecord('metric_instance');

gr.query();

if (gr.next()) {

gs.info(gr.duration.getNumericValue())

var gd = new GlideDuration(gr.getValue('duration'));

var ms = gd.getNumericValue();

gs.info(ms);

}

[Raghav Sharma24]

This should be simple, did you refer :

https://www.servicenow.com/community/developer-forum/calculate-duration-with-start-and-end-dates/m-p... 

[SN_Learn]

Hi @SatheeshKumar ,

Please check the below:

var gr = new GlideRecord('metric_instance');
gr.setLimit(1);
gr.query();
if (gr.next()) {
    gs.info(gr.duration.getGlideObject().getNumericValue()); //In milliseconds
}

Output:

*** Script: 5000

Refer to SN Docs: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0780039 

[Ankur Bawiskar · Accepted solution]

@SatheeshKumar 

this is the simple script to get display value and numeric value

var rec = new GlideRecord('metric_instance');
rec.get('089b46dddbeb5610727ee7dcd39619d8');

gs.info('Display value for duration-> ' + rec.duration.getDisplayValue());
gs.info('Numeric value for duration in milliseconds -> ' + rec.duration.getGlideObject().getNumericValue());

If my response helped please mark it correct and close the thread so that it benefits future readers.

[NISCHITHHEGDE]

code:
var rec = new GlideRecord('incident_metric');

rec.addQuery('inc_number', 'INC0710808');

rec.setLimit(10);

rec.query();

while (rec.next()) {

    if(!rec.mi_duration.nil())

    gs.info('Display value for duration -> ' + rec.mi_duration.getDisplayValue());

    gs.info('Numeric value (ms) -> ' + rec.mi_duration.getGlideObject().getNumericValue());

}

Output:

Please view the screenshot