topic Is it possible to override some sql queries? in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/is-it-possible-to-override-some-sql-queries/m-p/23590#M10297 <HTML><HEAD></HEAD><BODY><P>I found out that some queries are not optimal, for example:</P><P></P><P>select count(distinct RES.ID_) from ACT_RU_TASK RES inner join ACT_RU_VARIABLE A0 on RES.PROC_INST_ID_ = A0.PROC_INST_ID_ WHERE ( exists(select LINK.USER_ID_ from ACT_RU_IDENTITYLINK LINK where USER_ID_ = ? and LINK.TASK_ID_ = RES.ID_) or RES.ASSIGNEE_ = ? or RES.OWNER_ = ? ) and A0.TASK_ID_ is null and A0.NAME_= ? and A0.TYPE_ = ? and A0.TEXT_ = ?</P><P></P><P>I want to override this query</P></BODY></HTML> Mon, 09 Apr 2018 09:28:54 GMT rnovikov 2018-04-09T09:28:54Z Is it possible to override some sql queries? https://connect.hyland.com/t5/alfresco-forum/is-it-possible-to-override-some-sql-queries/m-p/23590#M10297 I found out that some queries are not optimal, for example:select count(distinct RES.ID_) from ACT_RU_TASK RES inner join ACT_RU_VARIABLE A0 on RES.PROC_INST_ID_ = A0.PROC_INST_ID_ WHERE ( exists(select LINK.USER_ID_ from ACT_RU_IDENTITYLINK LINK where USER_ID_ = ? and LINK.TASK_ID_ = RES.ID_) or RE Mon, 09 Apr 2018 09:28:54 GMT https://connect.hyland.com/t5/alfresco-forum/is-it-possible-to-override-some-sql-queries/m-p/23590#M10297 rnovikov 2018-04-09T09:28:54Z Re: Is it possible to override some sql queries? https://connect.hyland.com/t5/alfresco-forum/is-it-possible-to-override-some-sql-queries/m-p/23591#M10298 <HTML><HEAD></HEAD><BODY><P>You probably can, but you will need to make sure that your query is correct for all the use cases that the previous one was defined.&nbsp;</P><P>I would rather recommend to submit a PR with a test case that demonstrate that the new query is better, so we can all benefit from it.&nbsp;</P></BODY></HTML> Tue, 24 Apr 2018 12:52:46 GMT https://connect.hyland.com/t5/alfresco-forum/is-it-possible-to-override-some-sql-queries/m-p/23591#M10298 salaboy 2018-04-24T12:52:46Z