How to query all task of a user(userId and candidate user and group) including historic?

[bbbxixixixi]

I find that we can do this when the task is not finished by calling taskService.createTaskQuery().taskCandidateOrAssigned, however, there is no such method for running and historic tasks all together. I may do this by querying all running and historic respectively and manage them via java code, but I consider it is not a very good idea and it surely will comsume a lot of resources.
Could you give me some advice? Thanks.

[vasile_dirla]

Hi,
yes, there is a better approach "Custom SQL queries" :
http://www.jorambarrez.be/blog/2014/01/17/execute-custom-sql-in-activiti/

you could have a look in the Activiti code over this Test:

CustomMybatisXMLMapperTest.java

This will help you a lot for sure

[bbbxixixixi]

Thanks, I will try