Async business rule to fetch the date in which state is updated as fix in progress

[Nandhinisri]

Hi,

I need to write a async business rule to fetch the date dynamically in which the problem state is changed to fix in progress. Can anyone give me the base idea?

TIA

[Ankur Bawiskar]

@Nandhinisri 

seems similar question was asked by you earlier and I had responded to it

Getting the exact time and date when the problem record is updated as Fix in progress 

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

[Nandhinisri]

Yeah @Ankur Bawiskar  

The code was fine but we shouldn't query the audit table I guess. So this method is recommended.

[Ankur Bawiskar]

@Nandhinisri 

then you will have to create a custom field and store the date/time when the state changes from Fix in progress

Should be an easy before update BR

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

[Ankur Bawiskar]

@Nandhinisri 

before update BR

Condition: State Changes to Fix in Progress

Script:

current.u_fix_datetime = new GlideDateTime();

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