| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Querying the Workfow RT Database |
« View previous topic :: View next topic » |
| Author |
Message
|
| praveenchhangani |
 Posted: Wed Jul 16, 2003 1:06 pm Post subject: Querying the Workfow RT Database |
 |
|
Disciple
Joined: 20 Sep 2002
Posts: 192
Location: Chicago, IL
|
Hi Folks,
Does anyone what table(s) in the workflow runtime database to query against to extract user information.
Essentially what I want to find out is what authorization a user has over another users' work items.
eg. John has authorization of Janes work items.
So if John is J123456 and Jane is JA23456 (user ids), I want to be able to select all authorization for other people that John has over.
I don't know what table in the workflow runtime database will give me this. I suspect it may be the PER_AUTH_FOR_WITMS or the PER_AUTH_FOR_CATEG, but am not sure..
Please feel free to throw out any ideas if you could.
Thanks,
Praveen Chhangani
_________________
Praveen K. Chhangani,
IBM Certified Solutions Designer -
MQ Workflow 3.4. |
|
| Back to top |
|
 |
| Ratan |
| Posted: Wed Jul 16, 2003 1:09 pm Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
Hi Praveen,
why do you want to query runtime DB to do that? you can as well export the FDL and check the workitem authorization of the users.
_________________
-Ratan |
|
| Back to top |
|
|
| praveenchhangani |
| Posted: Thu Jul 17, 2003 5:18 am Post subject: |
|
|
Disciple
Joined: 20 Sep 2002
Posts: 192
Location: Chicago, IL
|
| Quote: |
Hi Praveen,
why do you want to query runtime DB to do that? you can as well export the FDL and check the workitem authorization of the users.
|
Ratan, thanks for the quick response. Essentially the reason I ask is because I want to be able to do this programmatically. I am in the process of coming up with an admin utility of some sort that will allow certain managers to look up user information and make modifications respectively. I understand I can do this by simply exporting the fdl, but I want to be able to do this programmatically and dynamically, so is why I ask.
Thanks,
_________________
Praveen K. Chhangani,
IBM Certified Solutions Designer -
MQ Workflow 3.4. |
|
| Back to top |
|
|
| jmac |
| Posted: Thu Jul 17, 2003 6:29 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Praveen:
Is there some reason you cant just use the API for this?
Maybe I'm missing something but it seems to me that the following Person Methods do what you want:
personsAuthorizedFor()
personsAuthorizedForMe()
If you are a reader of this forum I'm sure you know where I stand on direct access to the DB.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| praveenchhangani |
| Posted: Thu Jul 17, 2003 7:49 am Post subject: |
|
|
Disciple
Joined: 20 Sep 2002
Posts: 192
Location: Chicago, IL
|
John,
Thanks for the reply. I am aware of your stance/opinion on the issue direct access to db. Quite frankly I maintain the same, howeever, this is more of a unique situaion that we are having to deal with, hence the exception is being made.
You bring up a good point in regards to the methods
personsAuthorizedFor()
personsAuthorizedForMe()
I am assuming I would have to import the workflow libraries for this. My only thought is that I have all gotten all the information other than the two that I mentioned in my post. Is it really worth it at this point to import the workflow libraries into the my java class just for those two methods, or simply query the tables with a SQL query that will do the same.
I currently have two (2) tables in mind, but am unsure as to whether or not these will do the job.
1.) PER_AUTH_FOR_CATEG
2.) PER_AUTH_FOR_WITMS
If anyone has ever done this by simply performing a query, please let me know.
John, Your thoughts?
Thanks.
_________________
Praveen K. Chhangani,
IBM Certified Solutions Designer -
MQ Workflow 3.4. |
|
| Back to top |
|
|
| jmac |
| Posted: Thu Jul 17, 2003 8:11 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Praveen:
I would assume it to be the PER_AUTH_FOR_WITMS but I am not sure. I don't think the Category table will be of any help.
GOOD LUCK
_________________
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
|
|
|
|
