| Author |
Message
|
| scar |
 Posted: Fri Jan 14, 2005 5:11 am Post subject: SOLVED-Container Data from Audit Trail |
 |
|
Centurion
Joined: 23 Jun 2004
Posts: 145
|
We are trying to get the container data from the audit trail db.
with out using a global container how can I get the container information for a work item.
Thanks
Last edited by scar on Wed Jan 19, 2005 10:10 am; edited 1 time in total |
|
| Back to top |
|
 |
| jmac |
| Posted: Fri Jan 14, 2005 5:20 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
The only container data in the audit trail is the Global Data Container. Input/Output containers are not avaialble in the audit trail.
Selected fields from the input container can be placed in the Description, but that's all you can do.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| scar |
| Posted: Fri Jan 14, 2005 7:58 am Post subject: |
|
|
Centurion
Joined: 23 Jun 2004
Posts: 145
|
| Is there any other table where I can get container data. |
|
| Back to top |
|
|
| jmac |
| Posted: Fri Jan 14, 2005 8:19 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Access of any table other than the audit table is discouraged. The data is obviously stored in one of the Container Tables, but you probably should not be accessing that table for performance reasons, and there is not doc on what the column names would be, and no guarantee that they would not change. It is generally best to design your application to not need this information.
GOOD LUCK
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| hos |
| Posted: Sun Jan 16, 2005 11:53 pm Post subject: |
|
|
Chevalier
Joined: 03 Feb 2002
Posts: 470
|
Hi,
depending on the bussiness problem that you want to resolve it might also help to keep finished process instances/workitems for a certain time period. Then you could use the API to access the container data of these (finished) objects. |
|
| Back to top |
|
|
| scar |
| Posted: Tue Jan 18, 2005 6:39 am Post subject: |
|
|
Centurion
Joined: 23 Jun 2004
Posts: 145
|
We are going to make necessay changes to get the container data .
but for the current ones is there any way I can access the container data.
Does any one know the actual table that contains container information.
there are 161 tables in the db.
I started searching some of them but I couldnt find the one that has the container information.
We do even have WBI Monitor.
Is there a way we can get the business measures we defined from the monitor db. |
|
| Back to top |
|
|
| hos |
| Posted: Tue Jan 18, 2005 8:05 am Post subject: |
|
|
Chevalier
Joined: 03 Feb 2002
Posts: 470
|
Hi,
container data are stored as binary objects in the database. There is no way to access the values even if you know the correct tables.
Why do you think that the container data are still available in the database? If the process instances are not yet finished you can access the containers via API. If they ARE finished the related containers are deleted in the database. Or do I miss something? |
|
| Back to top |
|
|
| scar |
| Posted: Wed Jan 19, 2005 3:44 am Post subject: |
|
|
Centurion
Joined: 23 Jun 2004
Posts: 145
|
as the number of work items grow its taking a while to query using APIs.
The queries are based on multiple elements inthe conatiner. |
|
| Back to top |
|
|
| jmac |
| Posted: Wed Jan 19, 2005 7:44 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
It is never advisable to do queries based on container fields. Try to put the necessary container fields in the Description and do your queries based on that... or you could use a Global Data Container and do the queries based on the GDC.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| Rishi |
| Posted: Wed Apr 27, 2005 12:24 pm Post subject: |
|
|
Newbie
Joined: 10 Nov 2003
Posts: 8
Location: United States
|
| Quote: |
or you could use a Global Data Container and do the queries based on the GDC |
Can I query the Global Data Container from the command prompts?
Thanks |
|
| Back to top |
|
|
| jmac |
| Posted: Wed Apr 27, 2005 1:48 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
| Rishi wrote: |
| Can I query the Global Data Container from the command prompts? |
I do not understand the question.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
|
|
