-
1. Re: How do I retrieve Tasks for all Actors?
fallow Mar 10, 2006 2:45 PM (in response to mikeodell77)Mike, we have solved a number of these types of problems by creating our own SQL call and returning the data. You can easily get this list through direct SQL or HSQL. Something like the following I think gets you what you need.
select * from JBPM_TASKINSTANCE where end_ is not null
Eric -
2. Re: How do I retrieve Tasks for all Actors?
mikeodell77 Mar 10, 2006 2:51 PM (in response to mikeodell77)That is what I was affraid the answer was going to be.
Thanks for the reply. -
3. Re: How do I retrieve Tasks for all Actors?
mikeodell77 Mar 10, 2006 2:57 PM (in response to mikeodell77)Although, after thinking about it more... surely there is a way to get persisted instances from the database through the JBPM API.
-
4. Re: How do I retrieve Tasks for all Actors?
kukeltje Mar 11, 2006 9:21 AM (in response to mikeodell77)may I ask why you 'were afraid that was going to be the answer'?
These things are not obvious, think about systems where there are thousands of open tasks. Retrieving all in one go can put an unnecessary load on a system. So some kind of paging db side/ui side etc is needed. Extending the administrator webapp with this functionality could be nice. If you implement this and contribute, nobody has to be 'afraid' anymore ;-)
Ronald -
5. Re: How do I retrieve Tasks for all Actors?
daniel.brum Mar 12, 2006 5:11 AM (in response to mikeodell77)You could easily write an administration console that makes a SQL call to the DB and returns all of this data, is that much harder then using an API from jBPM? Why "afraid that would be the answer?"
-
6. Re: How do I retrieve Tasks for all Actors?
mikeodell77 Mar 13, 2006 2:06 PM (in response to mikeodell77)Thanks for the replies. That is exactly what I have done. I have a page that displays the information I was looking for. I just wanted to make sure I hadn't missed anything before I did that.
Thanks for the replies. If I get the time to properly extend jBPM to do this I will certainly submit it.
again thanks...