GET /user - lastNameLike and lastName filters issue

Camunda 7 Topics Discussion & Questions
1

Hello dear community,

I have been testing the rest api recently and found a strange behavior with the user endpoint.
While trying to list users with a query parameter lastNameLike, I couldn’t retrieve the data.

I’m using the standard, full tomcat CE distribution.

the calls tried:

  1. http://localhost:9090/engine-rest/user?lastName=Meter - this one works as expected
    returns:
    [
    {
    “id”: “peter”,
    “firstName”: “Peter”,
    “lastName”: “Meter”,
    “email”: “peter@camunda.org”
    }
    ]

  2. http://localhost:9090/engine-rest/user?lastNameLike=eter - returns []

  3. http://localhost:9090/engine-rest/user?lastNameLike=Meter - returns the same object as for #1

The very same behavior I have with firstName and firstNameLike.
Can anyone advise?
Am I using the endpoint correct?
How can I get a list of users by combining firstNameLike and lastNameLike?

Thanks in advance

2

@roman.levinta you can use SQL wildcard symbol % for like search. You can query like below, which will return array of users for given criteria.

https://docs.camunda.org/manual/7.12/reference/rest/user/get-query/

Valid Queries are:

/engine-rest/user?firstNameLike=%ter&lastNameLike=Met%

/engine-rest/user?firstNameLike=Pe%er&lastNameLike=Met%r

/engine-rest/user?firstNameLike=%&lastNameLike=%eter

/engine-rest/user?firstNameLike=%ter

/engine-rest/user?lastNameLike=Met%

SQL Wildcard Characters:

Wildcard Description
% A substitute for zero or more characters