| Author |
Message
|
| RJoubert |
 Posted: Tue Jun 18, 2002 6:35 am Post subject: Sorting Workitems |
 |
|
Apprentice
Joined: 30 May 2002
Posts: 43
Location: Buffalo, NY
|
How can I sort work items by a date value (stored in a variable length string data member) in the data container? The date the work item is created will not work for us...we need to sort by a received date which will be given to workflow in the data container. Any suggestions?
Thanks.
_________________
Rich Joubert
Computer Systems Engineer
Univera HealthCare, an Excellus Company |
|
| Back to top |
|
 |
| manoj |
| Posted: Tue Jun 18, 2002 12:35 pm Post subject: |
|
|
Master
Joined: 30 Jan 2002
Posts: 237
Location: Virgina
|
Hi,
As far as i know there's no direct way to sort based on a datacontainer element which is date. You need to get all the workitems and perform a sort in u r application logic
manoj |
|
| Back to top |
|
|
| vedbhat |
| Posted: Tue Jun 18, 2002 5:19 pm Post subject: |
|
|
Disciple
Joined: 19 Mar 2002
Posts: 186
Location: Singapore
|
Hi,
The easiest way to do this is by having the value of date field in the description field of the work item and then sort it accordingly.
There was similar question sometime back. For more information please look at,
http://www.webmq.com/phpBB2/viewtopic.php?t=3422
Cheers
Ved
_________________
IBM Certified Solutions Expert - MQSeries Workflow
IBM Certified Specialist - MQSeries |
|
| Back to top |
|
|
| RJoubert |
| Posted: Wed Jun 19, 2002 10:38 am Post subject: |
|
|
Apprentice
Joined: 30 May 2002
Posts: 43
Location: Buffalo, NY
|
Maybe I should elaborate a bit on my dilemma...
I will be storing several data fields in the description, so I plan to have the description look something like this...
ID=%ID Field%
NAME=%Name Field%
DATE=%Date Field%
If I do this how can I sort by the Date Field???
Thanks.
_________________
Rich Joubert
Computer Systems Engineer
Univera HealthCare, an Excellus Company |
|
| Back to top |
|
|
| manoj |
| Posted: Wed Jun 19, 2002 10:57 am Post subject: |
|
|
Master
Joined: 30 Jan 2002
Posts: 237
Location: Virgina
|
To my knowledge there's no substring operation availabe yet . So if your date field is not in the starting of the Description field then it's not possible to sort on that.
cheers
manoj |
|
| Back to top |
|
|
|
|
