API filter params for "like" params required a "%"?

Camunda 7 Topics Discussion & Questions
1

Is there docs on the need to add a % character for substring filters?

Example

if you do POST /task for get Task list and you use assigneeLike, you have to use percent (%) character for the “like” match to work

2

Hi Stephen,

whenever a “like” filter criteria is used, the SQL statement looks like this:

... WHERE assignee LIKE ${assignee}

This means that you can use all SQL placeholder characters inside the filter criterion value.
For instance % _ [a-z].

Cheers,
Tassilo

1 Like
3

Where can I add this to docs? Would like to add a single location to reference this plus add a link to each of the API query Params that use “like”

4

Hi Stephen,

there is a category called Query API in the User Guide.

Thanks in advance for your contribution! :slight_smile:

Cheers,
Tassilo