problem with ...Like('pattern') methods

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

ankits

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:

<sql id="selectHistoricTaskInstancesByQueryCriteriaSql">
    from ${prefix}ACT_HI_TASKINST RES
    <if test="processFinished || processUnfinished">
          inner join ${prefix}ACT_HI_PROCINST HPI ON RES.PROC_INST_ID_ = HPI.ID_
    </if>
    <if test="processDefinitionKey != null || processDefinitionName != null">
      inner join ${prefix}ACT_RE_PROCDEF D on RES.PROC_DEF_ID_ = D.ID_
    </if>
    <where>
      .
      .
      .
        <if test="taskNameLike != null">
                and RES.NAME_ like #{taskNameLike}
        </if>
      .
      .
   </where>
</sql>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

but in above query no pattern matching characters are used. If it cannot search based on given pattern, what is the point in using <strong>like</strong> operator here.

jbarrez

You need to add '%' to your query. Eg %blah% to search for everything with 'blah' in