topic CategoryLike Query Is Not Filtering Results in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/categorylike-query-is-not-filtering-results/m-p/59565#M36660 <HTML><HEAD></HEAD><BODY><SPAN>All process definitions are being pulled back from the database when calling </SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />repositoryService.createProcessDefinitionQuery().processDefinitionCategoryLike(..)<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>It appears the query is being build from the 'selectProcessDefinitionsByQueryCriteriaSql' definition in the ProcessDefinition.xml file:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR /> &lt;sql id="selectProcessDefinitionsByQueryCriteriaSql"&gt;&nbsp; <BR />&nbsp;&nbsp;&nbsp; from ACT_RE_PROCDEF PD<BR />&nbsp;&nbsp;&nbsp; &lt;where&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="id != null"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PD.ID_ = #{id}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="category != null"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PD.CATEGORY_ = #{category}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="name != null"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PD.NAME_ = #{name}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="nameLike != null"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PD.NAME_ like #{nameLike}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="key != null"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and PD.KEY_ = #{key}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="keyLike != null"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and PD.KEY_ like #{keyLike}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="resourceName != null"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and PD.RESOURCE_NAME_ = #{resourceName}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="resourceNameLike != null"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and PD.RESOURCE_NAME_ like #{resourceNameLike}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="version != null"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and PD.VERSION_ = #{version}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="deploymentId != null"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and PD.DEPLOYMENT_ID_ = #{deploymentId}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="latest"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and PD.VERSION_ = (select max(VERSION_) from ACT_RE_PROCDEF where KEY_ = PD.KEY_)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;/where&gt;<BR />&nbsp; &lt;/sql&gt;<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>A test for </SPAN><STRONG>categoryLike</STRONG><SPAN> seems to be missing.&nbsp; </SPAN><BR /><BR /><SPAN>I'm using activiti-5.6, and I wanted to make sure I wasn't missing something before creating a jira issue. </SPAN><BR /><BR /><SPAN>Thanks.</SPAN></BODY></HTML> Thu, 21 Jul 2011 14:33:44 GMT nfox241 2011-07-21T14:33:44Z CategoryLike Query Is Not Filtering Results https://connect.hyland.com/t5/alfresco-archive/categorylike-query-is-not-filtering-results/m-p/59565#M36660 All process definitions are being pulled back from the database when calling repositoryService.createProcessDefinitionQuery().processDefinitionCategoryLike(..)‍‍‍It appears the query is being build from the 'selectProcessDefinitionsByQueryCriteriaSql' definition in the ProcessDefinition.xml file: &amp;l Thu, 21 Jul 2011 14:33:44 GMT https://connect.hyland.com/t5/alfresco-archive/categorylike-query-is-not-filtering-results/m-p/59565#M36660 nfox241 2011-07-21T14:33:44Z Re: CategoryLike Query Is Not Filtering Results https://connect.hyland.com/t5/alfresco-archive/categorylike-query-is-not-filtering-results/m-p/59566#M36661 <HTML><HEAD></HEAD><BODY><SPAN>JIRA Issue - </SPAN><A href="http://jira.codehaus.org/browse/ACT-886" rel="nofollow noopener noreferrer">http://jira.codehaus.org/browse/ACT-886</A></BODY></HTML> Fri, 22 Jul 2011 13:32:38 GMT https://connect.hyland.com/t5/alfresco-archive/categorylike-query-is-not-filtering-results/m-p/59566#M36661 nfox241 2011-07-22T13:32:38Z