Need to create a Aging field in Incident Table to calculate the age of the tickets

[bijender1]

Need to create a Aging field in Incident Table to calculate the age of the tickets

[Shashikant Yada]

Can you add the logs and check

var aftertrim=datetrim.substring(0,index);
gr.u_aging_category = aftertrim;

gs.log('age date',aftertrim);

gs.log('age date Incident',gr.u_aging_category);

[Kush Bajpai2]

Hi Bijender,

I'm creating   one Duration field   in incident Form.

Then create Business Rule.

Name:Incident Age Calculate

Table:Incident

When to Run :Async(Insert,Update,Query)

Filter Condition:Active is True

Script:

(function executeRule(current, previous /*null when async*/) {

calculateAge();

function calculateAge()

{

var datedif = gs.dateDiff(current.sys_created_on.getDisplayValue(), gs.nowDateTime(),false);

current.u_incident_age = datedif;

current.update();

}

})(current, previous);

Please mark it helpful if it resolves your issue

[Community Alums]

I'm creating   one Duration field   in incident Form.

Then create Business Rule.

Name:Incident Age Calculate

Table:Incident

When to Run :Async(Insert,Update,Query)

Filter Condition:Active is True

Script:

(function executeRule(current, previous /*null when async*/) {

calculateAge();

function calculateAge()

{

var datedif = gs.dateDiff(current.sys_created_on.getDisplayValue(), gs.nowDateTime(),false);

current.u_incident_age = datedif;

current.update();

}

})(current, previous);

Note: create one incident then observe Incident age field its automatically update every 10 sec with out refresh page

Please mark Helpful if it resolves your issue

[Sathwik1]

@Kush Bajpai 

will it stopped after incident is closed?