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 

simply query the table record and get the value of this new field and it will give the exact date/time when that state got moved

what's the issue?

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

[Nandhinisri]

Let me make my understanding more clear to you, so that you can correct me if I am wrong.

Firstly, the state of the problem can be changed to fix in progress more than once. So the date in which it is changed to fix in progress is not a constant one in worst case. Secondly, we cant query the audit history table. Now my implementation goes this way, I am storing the date in async business rule. And I have my Scheduled Job to send notification. I have to take this date from Async business rule. How this can be implemented? ( taking the variable from br to job --- I am not sure how this works!!!!! and the reply you gave me above to query the table isn't clear to me). Expecting a brief answer for my query. Hope I made my points clear.

[Nandhinisri]

@Ankur Bawiskar 

1. State of the Problem changes to Fix in progress.

2. Store the date

3. Check if its a week ago and send the notification

[Ankur Bawiskar]

@Nandhinisri 

1st 2 points you already know how it can be done, I already informed

For 3rd point you can run daily scheduled job and check if the date is 1 week ago then send notification

I believe you will be able to complete the 3rd point based on your developer skills.

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

[Ankur Bawiskar]

@Nandhinisri 

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