topic Re: How to query all task of a user(userId and candidate user and group) including historic? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/how-to-query-all-task-of-a-user-userid-and-candidate-user-and/m-p/235703#M188833 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>yes, there is a better approach "Custom SQL queries" : </SPAN><BR /><A href="http://www.jorambarrez.be/blog/2014/01/17/execute-custom-sql-in-activiti/" rel="nofollow noopener noreferrer">http://www.jorambarrez.be/blog/2014/01/17/execute-custom-sql-in-activiti/</A><BR /><BR /><SPAN>you could have a look in the Activiti code over this Test:</SPAN><BR /><BR /><SPAN>CustomMybatisXMLMapperTest.java </SPAN><BR /><BR /><SPAN>This will help you a lot for sure <img id="smileywink" class="emoticon emoticon-smileywink" src="https://connect.hyland.com/i/smilies/16x16_smiley-wink.png" alt="Smiley Wink" title="Smiley Wink" /></SPAN></BODY></HTML> Mon, 28 Mar 2016 09:52:24 GMT vasile_dirla 2016-03-28T09:52:24Z How to query all task of a user(userId and candidate user and group) including historic? https://connect.hyland.com/t5/alfresco-archive/how-to-query-all-task-of-a-user-userid-and-candidate-user-and/m-p/235702#M188832 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 Sat, 26 Mar 2016 04:19:47 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-query-all-task-of-a-user-userid-and-candidate-user-and/m-p/235702#M188832 bbbxixixixi 2016-03-26T04:19:47Z Re: How to query all task of a user(userId and candidate user and group) including historic? https://connect.hyland.com/t5/alfresco-archive/how-to-query-all-task-of-a-user-userid-and-candidate-user-and/m-p/235703#M188833 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>yes, there is a better approach "Custom SQL queries" : </SPAN><BR /><A href="http://www.jorambarrez.be/blog/2014/01/17/execute-custom-sql-in-activiti/" rel="nofollow noopener noreferrer">http://www.jorambarrez.be/blog/2014/01/17/execute-custom-sql-in-activiti/</A><BR /><BR /><SPAN>you could have a look in the Activiti code over this Test:</SPAN><BR /><BR /><SPAN>CustomMybatisXMLMapperTest.java </SPAN><BR /><BR /><SPAN>This will help you a lot for sure <img id="smileywink" class="emoticon emoticon-smileywink" src="https://connect.hyland.com/i/smilies/16x16_smiley-wink.png" alt="Smiley Wink" title="Smiley Wink" /></SPAN></BODY></HTML> Mon, 28 Mar 2016 09:52:24 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-query-all-task-of-a-user-userid-and-candidate-user-and/m-p/235703#M188833 vasile_dirla 2016-03-28T09:52:24Z Re: How to query all task of a user(userId and candidate user and group) including historic? https://connect.hyland.com/t5/alfresco-archive/how-to-query-all-task-of-a-user-userid-and-candidate-user-and/m-p/235704#M188834 <HTML><HEAD></HEAD><BODY><SPAN>Thanks, I will try</SPAN></BODY></HTML> Mon, 28 Mar 2016 10:39:06 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-query-all-task-of-a-user-userid-and-candidate-user-and/m-p/235704#M188834 bbbxixixixi 2016-03-28T10:39:06Z