# LIKE or LIKE\_IGNORE\_CASE doesnot work for tasks/process filter

**URL:** <https://forum.flowable.org/t/like-or-like-ignore-case-doesnot-work-for-tasks-process-filter/4499>\
**Category:** Uncategorized\
**Created:** [September 10, 2019, 2:40pm UTC](https://forum.flowable.org/t/like-or-like-ignore-case-doesnot-work-for-tasks-process-filter/4499 "2019-09-10T14:40:59Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![lohiavivek](https://avatars.discourse-cdn.com/v4/letter/l/d26b3c/32.png) [@lohiavivek](https://forum.flowable.org/u/lohiavivek)\
**Post date:** [September 10, 2019, 2:40pm UTC](https://forum.flowable.org/t/like-or-like-ignore-case-doesnot-work-for-tasks-process-filter/4499/1 "2019-09-10T14:40:59Z")

</div>

LIKE or LIKE\_IGNORE\_CASE doesnot work for tasks or process query. It returns the results as EQUALS .  
For eg.  
If we have tasks / process with process variable var\_1 = “abcd”  
We need to search for those tasks/ process which have var\_1 starts with “ab”  
Was calling /query/tasks API with  
name : “var\_1”  
value : “ab”  
operation : “LIKE”

but didnot get desired output.

if we pass  
name : “var\_1”  
value : “abcd”  
operation : “LIKE”

We get the result.  
Ideally, passing “ab” with “LIKE” operation , should have fetched us the desired results.

---

<div class="post-metadata">

**Author:** ![wwitt](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/wwitt/32/706_2.png) [@wwitt](https://forum.flowable.org/u/wwitt)\
**Post date:** [September 10, 2019, 9:31pm UTC](https://forum.flowable.org/t/like-or-like-ignore-case-doesnot-work-for-tasks-process-filter/4499/2 "2019-09-10T21:31:39Z")

</div>

The like operation uses the SQL like operator behind the scenes. As a result it’s expecting SQL like wildcards.

Try value `ab%` or `%bc%` instead.

Will

---

<div class="post-metadata">

**Author:** ![lohiavivek](https://avatars.discourse-cdn.com/v4/letter/l/d26b3c/32.png) [@lohiavivek](https://forum.flowable.org/u/lohiavivek)\
**Post date:** [September 12, 2019, 12:28pm UTC](https://forum.flowable.org/t/like-or-like-ignore-case-doesnot-work-for-tasks-process-filter/4499/3 "2019-09-12T12:28:08Z")

</div>

It works for process.  
But it doesnot work for task query.  
For Task it returns  
{  
“message”: “Bad request”,  
“exception”: “Unsupported variable query operation: LIKE\_IGNORE\_CASE”  
}

---

<div class="post-metadata">

**Author:** ![wwitt](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/wwitt/32/706_2.png) [@wwitt](https://forum.flowable.org/u/wwitt)\
**Post date:** [September 12, 2019, 1:50pm UTC](https://forum.flowable.org/t/like-or-like-ignore-case-doesnot-work-for-tasks-process-filter/4499/4 "2019-09-12T13:50:17Z")

</div>

It appears that the task query is looking for “friendly operation names” like ‘equalsIgnoreCase’ and ‘likeIgnoreCase’ but that `likeIgnoreCase` is not currently supported.

---

<div class="post-metadata">

**Author:** ![lohiavivek](https://avatars.discourse-cdn.com/v4/letter/l/d26b3c/32.png) [@lohiavivek](https://forum.flowable.org/u/lohiavivek)\
**Post date:** [September 13, 2019, 12:20pm UTC](https://forum.flowable.org/t/like-or-like-ignore-case-doesnot-work-for-tasks-process-filter/4499/5 "2019-09-13T12:20:02Z")

</div>

Is there any specific reason for it to be not supported. Like heavy operation on engine or not very efficient to search tasks using such a filter. It looks like a very obvious requirement to have support for such a filter. Please help.

---

<div class="post-metadata">

**Author:** ![wwitt](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/wwitt/32/706_2.png) [@wwitt](https://forum.flowable.org/u/wwitt)\
**Post date:** [September 15, 2019, 12:49am UTC](https://forum.flowable.org/t/like-or-like-ignore-case-doesnot-work-for-tasks-process-filter/4499/6 "2019-09-15T00:49:18Z")

</div>

Opened [https://github.com/flowable/flowable-engine/issues/1939](https://github.com/flowable/flowable-engine/issues/1939) and created PR [https://github.com/flowable/flowable-engine/pull/1940](https://github.com/flowable/flowable-engine/pull/1940)

---

<div class="post-metadata">

**Author:** ![wwitt](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/wwitt/32/706_2.png) [@wwitt](https://forum.flowable.org/u/wwitt)\
**Post date:** [September 17, 2019, 12:18pm UTC](https://forum.flowable.org/t/like-or-like-ignore-case-doesnot-work-for-tasks-process-filter/4499/7 "2019-09-17T12:18:08Z")

</div>

As a followup, this has been corrected in the current Master Branch and will become part of the next Flowable release.