| Author |
Message
|
| MaheshPN |
 Posted: Fri Aug 01, 2003 10:29 am Post subject: Query Global Container |
 |
|
Master
Joined: 21 May 2003
Posts: 245
Location: Charlotte, NC
|
Hi,
I Read in book that we can use global container data to filter data in worklist.
I have assigned Global container to one of the activity in buildtime and I am getting the data in GC_table. But I am not able to see the data in the Audit trail CONTAINER_CONTENT field and also in Thick client's Filter List.
I donno how to do it 
If somebody have done it please share
Thanks,
Mahesh
IBM Certified Solution Expert - MQWorkflow |
|
| Back to top |
|
 |
| manoj |
| Posted: Sat Aug 02, 2003 7:51 am Post subject: |
|
|
Master
Joined: 30 Jan 2002
Posts: 237
Location: Virgina
|
CONTAINER_CONTENT is of type BLOB...so u won't get the data using a simple SQL query. Also the data which goes in to the GDC table is mapped from the datastructure of source/activity. so why do u want to see the data in GDC, it's the same.
If you are sure you want to look in to the data in GDC then you could use
AUDIT TO MQ option ..this will give you GDC data in the XML put in to the audit Q (u 've to define the Q). Also if you use Filters for Auditing then you will 've to add the event "Global container changed" in the filter (i guess it 's 20081)
_________________
-manoj |
|
| Back to top |
|
|
| leongor |
| Posted: Sun Aug 03, 2003 1:42 am Post subject: |
|
|
Master
Joined: 13 May 2002
Posts: 264
Location: Israel
|
You cannot set filter for global container in a fat client, only in a web client.
_________________
Regards.
Leonid.
IBM Certified MQSeries Specialist. |
|
| Back to top |
|
|
| jmac |
| Posted: Sun Aug 03, 2003 5:22 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Leonid:
Why do you say this? The filter has nothing to do with the client type. Are you saying that it is not available in the IBM Out of the Box client? Or are you saying it is not avaialble at all?
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| leongor |
| Posted: Sun Aug 03, 2003 9:07 am Post subject: |
|
|
Master
Joined: 13 May 2002
Posts: 264
Location: Israel
|
Yes you right, I meant a default fat client, that really behind a web client.
For example you don't have access to Process Context or Global Container in a default fat client.
_________________
Regards.
Leonid.
IBM Certified MQSeries Specialist. |
|
| Back to top |
|
|
| jmac |
| Posted: Sun Aug 03, 2003 10:16 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Leonid:
I am certain that you understand, I just want to add a clarification for anyone else who might look at this.
The IBM suppplied fat (Windows) client does not allow you to set a filter using the ProcessContext, or a GlobalContainer Member from the dropdown list associated with the list properties. HOWEVER, if you create a worklist that has either of the above types of filters using some other client (fat or thin) these filters will be used.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| MaheshPN |
| Posted: Mon Aug 04, 2003 10:07 am Post subject: Query Global Container |
|
|
Master
Joined: 21 May 2003
Posts: 245
Location: Charlotte, NC
|
Thanks Manoj, Leonid and Jhon.
I will try using API's or From Audit to MQ.
Regards,
Mahesh |
|
| Back to top |
|
|
|
|
