| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Reporting Question. |
« View previous topic :: View next topic » |
| Author |
Message
|
| ProcessCentric |
 Posted: Fri Apr 28, 2006 3:36 am Post subject: Reporting Question. |
 |
|
Apprentice
Joined: 04 Nov 2005
Posts: 25
Location: USA
|
Our users would like to generate a report which lists every user on the system and all of the items that are in their worklists. This reprot will contain over 1,000 users and be provided on demand. This is so supervisors can look across the dept and make sure they are adequately staffed for the days work, shift work from one user to another user, etc. Is there any API call that will pull this information. (obviously without calling once per user) I was consider using direct SQL against the Run Time DB, but I know this is not recommended. Has anyone had to deal with a similar requirement? (Currently on 3.5 but moving to 3.6 later this year).
thanks! |
|
| Back to top |
|
 |
| jmac |
| Posted: Fri Apr 28, 2006 4:35 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
If you query workitems from the ADMIN sort by OWNER, I think you will easily get what you want. However, this would bring back all of the Workitems in the system with a single call and it might blow the maximum message size.
A little trickier would be to query the activity Instances in the Ready state. This would bring back all ready activity instances, then you would need to use the staff() method to determine what users are assigned to the activity (i.e have a workitem). This MIGHT result in a smaller message but will definitely require a little more work.
Its the ON DEMAND part that bothers me. IF you have people running this command whenever they like, it could have a negative impact on performance.
_________________
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
|
|
|
|
