| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| [SOLVED] Getting data from Global Data Containers |
« View previous topic :: View next topic » |
| Author |
Message
|
| mca |
 Posted: Thu Jul 07, 2005 2:14 pm Post subject: [SOLVED] Getting data from Global Data Containers |
 |
|
Disciple
Joined: 09 Mar 2005
Posts: 196
|
Hi all,
Its been a while since i talked to you guys. Now i am back to work again with questions. 
I have 3 tasks A,B and C in a process in workflow. Data is flowing to all 3 activities. I am capturing the data by using Global Containers at each activity. The values of fields i am capturing are FName, LName and Loan Amount. Now my manager came and asked me to generate reports like
1. Get me the FNames and LNames of persons who requested loan amount > 100.
2. Get me the Loan amount with FName JOE requested for.
I may need to generate such reports. I refered some manuals like WF Admin guide - How to use Audit tables section. But it does not have information about how to query values of user-defined varaiables like FName, LName etc. If i cannot query the datadase directly with user-defined values, I know GDC values will be stored in Blob format in database. How can i convert that and make my queries.
If this information is in some manual, please specify from which manual i can get this information from.
Thanks and its nice getting back to this forum saying HI. 
Last edited by mca on Mon Jul 11, 2005 5:38 am; edited 1 time in total |
|
| Back to top |
|
 |
| kotha |
| Posted: Thu Jul 07, 2005 4:46 pm Post subject: |
|
|
Partisan
Joined: 12 Mar 2005
Posts: 333
|
As I understood, You need to retrieve two or three names with some condition credit<100 or something like that. Refer Workflow API to retrieve the necessary values.
check for the condition for credit and retrieve the necessary names. If you need more info, contact me!! |
|
| Back to top |
|
|
| jmac |
| Posted: Fri Jul 08, 2005 5:25 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Why would you be doing these queries against the MQWF RTDB? It seems to me these should go against your application database... I may not understand your question. If this data is in the GDC, then you can definitely do queries against that while the instances are running. The query syntax for GDC is documented in the programming guide.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| mca |
| Posted: Mon Jul 11, 2005 5:37 am Post subject: |
|
|
Disciple
Joined: 09 Mar 2005
Posts: 196
|
| Thanks Jmac, This is the reply i needed. Thanks again. |
|
| 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
|
|
|
|
