Format control calculation initialize Resolve time as NULL

There is an OOB calculation on format control IM.update.incident which initializes resolved.time, resolved.by NULL on initialization of format.

Steps to reproduce:

1. Resolve an Incident

2. Save the Incident

3. Exit and again search the Incident

4. Resolve time is NULL

If user saves the record it make the resolve time NULL.

Calculation:resolved.by in $file=NULL;resolved.group in $file=NULL;resolved.time in $file=NULL;adj.resolution.by in $file=NULL;adj.resolution.time in $file=NULL

Solution

Go to trigger and set a trigger –>add.resolution.infomation

Table name–>probsummary

Tigger Type –>3 – Before Update

Application –>leave blank

if(record.problem_status==’Resolved’ && oldrecord.problem_status !=record.problem_status)

{

record.resolved_time=system.functions.tod();

record.resolved_by=system.functions.operator();

}

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s