topic Re: Using both TaskQuery and NativeTaskQuery in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/using-both-taskquery-and-nativetaskquery/m-p/122366#M86183 <HTML><HEAD></HEAD><BODY><SPAN>Don't really see what your problem is. Do you want to combine UserTasks from TaskQuery and NatvieTaskQuery? Why not include the SQL you need (the SQL generated by suspended()) in the NativeQuery?</SPAN></BODY></HTML> Wed, 03 Apr 2013 07:38:17 GMT frederikherema1 2013-04-03T07:38:17Z Using both TaskQuery and NativeTaskQuery https://connect.hyland.com/t5/alfresco-archive/using-both-taskquery-and-nativetaskquery/m-p/122365#M86182 Hi,Is there any way that i can use createTaskQuery and createNativeTaskQuery for the same taskService Object?Like:TaskService taskService = engine.getTaskService();taskService.createNativeTaskQuery().sql("select * from "+managementService.getTableName(Task.class)+" T where T.name_ ilike #{taskName}" Sat, 30 Mar 2013 08:08:51 GMT https://connect.hyland.com/t5/alfresco-archive/using-both-taskquery-and-nativetaskquery/m-p/122365#M86182 c_arunrathnakum 2013-03-30T08:08:51Z Re: Using both TaskQuery and NativeTaskQuery https://connect.hyland.com/t5/alfresco-archive/using-both-taskquery-and-nativetaskquery/m-p/122366#M86183 <HTML><HEAD></HEAD><BODY><SPAN>Don't really see what your problem is. Do you want to combine UserTasks from TaskQuery and NatvieTaskQuery? Why not include the SQL you need (the SQL generated by suspended()) in the NativeQuery?</SPAN></BODY></HTML> Wed, 03 Apr 2013 07:38:17 GMT https://connect.hyland.com/t5/alfresco-archive/using-both-taskquery-and-nativetaskquery/m-p/122366#M86183 frederikherema1 2013-04-03T07:38:17Z Re: Using both TaskQuery and NativeTaskQuery https://connect.hyland.com/t5/alfresco-archive/using-both-taskquery-and-nativetaskquery/m-p/122367#M86184 <HTML><HEAD></HEAD><BODY><SPAN>If i m using SQLs instead of API, will there be any changes in performance?</SPAN></BODY></HTML> Thu, 11 Apr 2013 10:13:04 GMT https://connect.hyland.com/t5/alfresco-archive/using-both-taskquery-and-nativetaskquery/m-p/122367#M86184 c_arunrathnakum 2013-04-11T10:13:04Z Re: Using both TaskQuery and NativeTaskQuery https://connect.hyland.com/t5/alfresco-archive/using-both-taskquery-and-nativetaskquery/m-p/122368#M86185 <HTML><HEAD></HEAD><BODY><SPAN>No, in the end the API is just a wrapper around the SQL calls.</SPAN></BODY></HTML> Mon, 15 Apr 2013 07:55:54 GMT https://connect.hyland.com/t5/alfresco-archive/using-both-taskquery-and-nativetaskquery/m-p/122368#M86185 jbarrez 2013-04-15T07:55:54Z