topic Re: problem with ...Like('pattern') methods in Alfresco Archive 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 ankits 2013-05-14T09:24:16Z 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