| Author |
Message
|
| ajomillar |
 Posted: Tue Oct 14, 2003 12:04 pm Post subject: Web client displays count of workitems |
 |
|
Centurion
Joined: 22 Aug 2003
Posts: 121
Location: Milwaukee, WI
|
| What is a best practice for displaying the total number of workitems in a worklist (using a Web client)? Are there aggregate functions in the Workflow API that would suit this purpose? I would like to build a web client that displays the total count, so the end user knows what to expect. For example, if office# 1234 has 10 orders in their worklist, the end user would see "Number of Orders = 10" in a summary page before navigating to the actual worklist. |
|
| Back to top |
|
 |
| jmac |
| Posted: Tue Oct 14, 2003 2:04 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
If I understand correctly, the only way you will be able to get this count is by doing the queryWorkitems call.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| MaheshPN |
| Posted: Tue Oct 14, 2003 5:33 pm Post subject: |
|
|
Master
Joined: 21 May 2003
Posts: 245
Location: Charlotte, NC
|
You can try writing an aggregate SQL query on Audit trial table with required activity name and state equal to 'ready'
-Mahesh
IBM Certified Solution Expert - MQWorkflow |
|
| Back to top |
|
|
| ajomillar |
| Posted: Wed Oct 15, 2003 5:52 am Post subject: |
|
|
Centurion
Joined: 22 Aug 2003
Posts: 121
Location: Milwaukee, WI
|
Thanks for the replies.  Is using either the API call or aggregate SQL query typically used in workflow web clients that you know of? |
|
| Back to top |
|
|
| vennela |
| Posted: Wed Oct 15, 2003 5:57 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| Quote: |
| Is using either the API call or aggregate SQL query typically used in workflow web clients that you know of? |
I would bet it would be an API call. Querying the runtime DB is discouraged by IBM. You would be better off using the API call.
-------
Venny |
|
| Back to top |
|
|
| ajomillar |
| Posted: Mon Dec 08, 2003 1:03 pm Post subject: |
|
|
Centurion
Joined: 22 Aug 2003
Posts: 121
Location: Milwaukee, WI
|
| I want to display a page showing counts of work items by user. In this case, the user is represented by a 4-digit office number. Also, there's a requirement to display counts based on input data container elements. Since there is a worklist by a specific element, the enduser wants to know how many workitems exists -- before diving in. I've used the API to create a filtered worklist, but kind of performance should I expect if there are 100's or 1000's of workitems? Also, has anyone implemented this in the web client before? |
|
| Back to top |
|
|
| jmac |
| Posted: Mon Dec 08, 2003 1:08 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
If you must access container items for each workitem performance is going to be POOR.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| Andy |
| Posted: Tue Dec 09, 2003 10:44 pm Post subject: |
|
|
Centurion
Joined: 14 May 2003
Posts: 122
|
| MaheshPN wrote: |
You can try writing an aggregate SQL query on Audit trial table with required activity name and state equal to 'ready'
|
Is this information also written in Audit Trail table? I dont feel so. I am just lazy to check so pls confirm if somebody knows 
Might be its there when Full Log is on, but that also impacts server performance.
_________________
 Andy |
|
| Back to top |
|
|
| Andy |
| Posted: Wed Dec 10, 2003 1:10 am Post subject: |
|
|
Centurion
Joined: 14 May 2003
Posts: 122
|
Yeah I checked....Activity Ready state would be written in log if Full Log is on!!!
_________________
Andy |
|
| Back to top |
|
|
| jmac |
| Posted: Wed Dec 10, 2003 5:52 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Look at the couple of "views" that IBM provides... see chapter 14 in the programming guide, hopefully one of these will give you what you want, but it will not give you container data.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
|
|
