| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| State Management |
« View previous topic :: View next topic » |
| Author |
Message
|
| chiping33 |
 Posted: Fri Nov 05, 2004 1:49 pm Post subject: State Management |
 |
|
Newbie
Joined: 05 Nov 2004
Posts: 1
|
I am creating a workflow and I need to know the state of my worklist item whether it is waiting of for approval or declined.
When someone changes something in the database a workitem is sent to a user for approval or decline.
I need to find out if someone has checked the workitem and is working on it.
If it is declined can I undo all the previous changes in the database.
Is this possible in MQ? |
|
| Back to top |
|
 |
| sac |
| Posted: Fri Dec 10, 2004 7:11 am Post subject: |
|
|
Apprentice
Joined: 10 Feb 2003
Posts: 44
|
Hi,
The way you can do it is, that in DB design you can keep one version (time stamp) column and one Approve/Reject column in the table. This version column will correspond to the current approved version in the DB. Meaning whenever an update is made to the details, you will insert another row in DB with this new version (current time stamp). You will have this current and old version in your workflow container as well. So, when the approver, declines or Accepts the changes, you will accordingly make the status of Accepted version as "A" or "R". Whereas while the inserted data is still in approval stage, you can have the status as "P" (pending).
I hope am clear in stating my idea. Also i understand that this might require change in DB desing for you, but if it's possible, then i think you can go for it.
-Thanks |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
