topic problem with ...Like('pattern') methods in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/problem-with-like-pattern-methods/m-p/127744#M89813 <HTML><HEAD></HEAD><BODY><SPAN>I want to search for the task names using some pattern. but the method taskNameLike("taskName") does not return the result based on the pattern provided. I can see in the HistoricTaskInstance.xml file the query as:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;sql id="selectHistoricTaskInstancesByQueryCriteriaSql"&gt;<BR />&nbsp;&nbsp;&nbsp; from ${prefix}ACT_HI_TASKINST RES<BR />&nbsp;&nbsp;&nbsp; &lt;if test="processFinished || processUnfinished"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; inner join ${prefix}ACT_HI_PROCINST HPI ON RES.PROC_INST_ID_ = HPI.ID_<BR />&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;if test="processDefinitionKey != null || processDefinitionName != null"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; inner join ${prefix}ACT_RE_PROCDEF D on RES.PROC_DEF_ID_ = D.ID_<BR />&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;where&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="taskNameLike != null"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and RES.NAME_ like #{taskNameLike}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .<BR />&nbsp;&nbsp; &lt;/where&gt;<BR />&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></CODE></PRE><SPAN>but in above query no pattern matching characters are used. If it cannot search based on given pattern, what is the point in using &lt;strong&gt;like&lt;/strong&gt; operator here.</SPAN></BODY></HTML> Mon, 13 May 2013 11:23:22 GMT ankits 2013-05-13T11:23:22Z problem with ...Like('pattern') methods https://connect.hyland.com/t5/alfresco-archive/problem-with-like-pattern-methods/m-p/127744#M89813 I want to search for the task names using some pattern. but the method taskNameLike("taskName") does not return the result based on the pattern provided. I can see in the HistoricTaskInstance.xml file the query as:&lt;sql id="selectHistoricTaskInstancesByQueryCriteriaSql"&gt;&nbsp;&nbsp;&nbsp; from ${prefix}ACT_HI Mon, 13 May 2013 11:23:22 GMT https://connect.hyland.com/t5/alfresco-archive/problem-with-like-pattern-methods/m-p/127744#M89813 ankits 2013-05-13T11:23:22Z Re: problem with ...Like('pattern') methods https://connect.hyland.com/t5/alfresco-archive/problem-with-like-pattern-methods/m-p/127745#M89814 <HTML><HEAD></HEAD><BODY><SPAN>You need to add '%' to your query. Eg %blah% to search for everything with 'blah' in</SPAN></BODY></HTML> Tue, 14 May 2013 08:09:24 GMT https://connect.hyland.com/t5/alfresco-archive/problem-with-like-pattern-methods/m-p/127745#M89814 jbarrez 2013-05-14T08:09:24Z Re: problem with ...Like('pattern') methods https://connect.hyland.com/t5/alfresco-archive/problem-with-like-pattern-methods/m-p/127746#M89815 <HTML><HEAD></HEAD><BODY><SPAN>thanx for your response, but why not add it to the xml itself…</SPAN></BODY></HTML> Tue, 14 May 2013 09:24:16 GMT https://connect.hyland.com/t5/alfresco-archive/problem-with-like-pattern-methods/m-p/127746#M89815 ankits 2013-05-14T09:24:16Z Re: problem with ...Like('pattern') methods https://connect.hyland.com/t5/alfresco-archive/problem-with-like-pattern-methods/m-p/127747#M89816 <HTML><HEAD></HEAD><BODY><SPAN>Because sometimes you want to search for '%blah%', but sometimes you only want 'blah%', meaning only the ones starting with 'blah'. Or %blah%somethingelse%. or … </SPAN><BR /><BR /><SPAN>I think you get the picture … not having it fixed is way more flexible.</SPAN></BODY></HTML> Wed, 15 May 2013 13:33:41 GMT https://connect.hyland.com/t5/alfresco-archive/problem-with-like-pattern-methods/m-p/127747#M89816 jbarrez 2013-05-15T13:33:41Z Re: problem with ...Like('pattern') methods https://connect.hyland.com/t5/alfresco-archive/problem-with-like-pattern-methods/m-p/127748#M89817 <HTML><HEAD></HEAD><BODY><SPAN>ya got it.. thanx..</SPAN><BR /></BODY></HTML> Thu, 16 May 2013 05:01:16 GMT https://connect.hyland.com/t5/alfresco-archive/problem-with-like-pattern-methods/m-p/127748#M89817 ankits 2013-05-16T05:01:16Z