How do I retrieve Tasks for all Actors?

[mikeodell77]

I see how to get task for a specific actor... but what about all open tasks?

I am trying to make an administration module to allow an administrator to see all tasks and move them around if need be.

[fallow]

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

[mikeodell77]

That is what I was affraid the answer was going to be.

Thanks for the reply.

[mikeodell77]

Although, after thinking about it more... surely there is a way to get persisted instances from the database through the JBPM API.

[kukeltje]

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

[daniel.brum]

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?"

[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...