|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
 |
|
How to use "distinct" in WF Query ?? |
« View previous topic :: View next topic » |
Author |
Message
|
amittalekar |
Posted: Fri Apr 25, 2003 7:46 am Post subject: How to use "distinct" in WF Query ?? |
|
|
 Disciple
Joined: 03 Apr 2002 Posts: 166 Location: VA, USA
|
My requirement is:-
Query on GDC and get distinct workItem.
Is this possible?...
ex. my GDC query is :- "PT:City ='*' AND STATE =RUNNING".
What i want is query should return me a single (distinct) workItem for each city even though there may be more than one workItem present on that city.
or is there any other way to achieve this? |
|
Back to top |
|
 |
jmac |
Posted: Fri Apr 25, 2003 8:47 am Post subject: |
|
|
 Jedi Knight
Joined: 27 Jun 2001 Posts: 3081 Location: EmeriCon, LLC
|
Amit:
I dont see how you can get a single workitem returned per city. If there are multiple instances running then there could be multiple workitems for a city right?
Perhaps I don't understand. _________________ John McDonald
RETIRED |
|
Back to top |
|
 |
amittalekar |
Posted: Fri Apr 25, 2003 9:38 am Post subject: |
|
|
 Disciple
Joined: 03 Apr 2002 Posts: 166 Location: VA, USA
|
No, may be i have not explained correctly.
ex.
In the oracle db, u can query database using distinct keyword. Say there are 5 records in DataBase where city = "NK" & other 5 records for city = "VA" (total 10 records). When queried oracle using "distinct" I can retrieve only two (one for VA & one for NK) record and not all 10 records.
Can I achieve this using any API supprted by WorkFlow?
I believe this is something that is not supported in Workflow. Just wanted to recofirm this... |
|
Back to top |
|
 |
jmac |
Posted: Fri Apr 25, 2003 9:48 am Post subject: |
|
|
 Jedi Knight
Joined: 27 Jun 2001 Posts: 3081 Location: EmeriCon, LLC
|
Amit:
Now I understand, and in my opinion this is not supported in the MQWF database.
You could post the question to the IBM newsgroup and perhaps one of the developers could give you a definitve answer. _________________ John McDonald
RETIRED |
|
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
|
|
|
|