user search not behaving as expected #1310

New Issue

yksflip · 2022-11-07T12:58:01Z

yksflip commented

2022-11-07 12:58:01 +00:00

With the username konrad.s and Name Konrad S the api/v1/users?s= endpoint behaves not as expected.

searching for konrad gives null
searching for konrad.s returns the user
searching for Konrad returns the user

I would expect to find the user in any of these cases

Just by trying around I assume that either matching the exact username or its fuzzy searching by Name / Email?

also the webui makes it look like that I'm only searching by username by only showing it in the results. This confuses additionally.

Version: v0.19.2

With the username `konrad.s` and Name `Konrad S` the `api/v1/users?s=` endpoint behaves not as expected. searching for `konrad` gives `null` searching for `konrad.s` returns the user searching for `Konrad` returns the user I would expect to find the user in any of these cases Just by trying around I assume that either matching the exact username or its fuzzy searching by Name / Email? also the webui makes it look like that I'm only searching by username by only showing it in the results. This confuses additionally. Version: v0.19.2

yksflip changed title from ~~searching for user broken~~ to user search not behaving as expected

2022-11-07 12:58:37 +00:00

konrad commented

2022-11-07 12:59:11 +00:00

What are you expecting?

yksflip commented

2022-11-07 13:21:55 +00:00

sorry, excidentially pressed shift+enter 🤦‍♂️

😆 1

konrad commented

2022-11-07 13:52:15 +00:00

Just by trying around I assume that either matching the exact username or its fuzzy searching by Name / Email?

That's almost correct. It will match the user by exact username by default, if the user enabled it in their settings also by exact email address or fuzzily by name.

also the webui makes it look like that I'm only searching by username by only showing it in the results. This confuses additionally.

That will be changed in the next release for team member search, it's already changed for assignee search.

> Just by trying around I assume that either matching the exact username or its fuzzy searching by Name / Email? That's almost correct. It will match the user by exact username by default, if the user enabled it in their settings also by exact email address or fuzzily by name. > also the webui makes it look like that I'm only searching by username by only showing it in the results. This confuses additionally. That will be changed in the next release for team member search, it's already changed for assignee search.

yksflip commented

2022-11-07 14:16:22 +00:00

thx for your explanations!
In my case the user setting for search by name is enabled, so do you know why searching for konrad doesn't work but K? - should'nt the sql ILIKE be case-insensitive?
(we use postgres)

thx for your explanations! In my case the user setting for search by name is enabled, so do you know why searching for `konrad` doesn't work but `K`? - should'nt the sql `ILIKE` be case-insensitive? (we use postgres)

konrad commented

2022-11-07 14:26:06 +00:00

In my case the user setting for search by name is enabled, so do you know why searching for konrad doesn't work but K? - should'nt the sql ILIKE be case-insensitive?

Yes, but that was a change which happend after the release you're using. Try the last stable release or unstable build.

> In my case the user setting for search by name is enabled, so do you know why searching for konrad doesn't work but K? - should'nt the sql ILIKE be case-insensitive? Yes, but that was a change which happend after the release you're using. Try the last stable release or unstable build.

yksflip commented

2022-11-08 09:22:02 +00:00

ah oh okay, didn't see that, it was a confusing day o.o
thanks for your help! :)

ah oh okay, didn't see that, it was a confusing day o.o thanks for your help! :)

👍 1

yksflip closed this issue

2022-11-08 09:22:02 +00:00

Sign in to join this conversation.