Can't search user by username starts with numbers

[MissMakima 2]

Hi, my Emby Server has some people with username like '12345@mail.com' and when I tried to search them by their username, the Emby Server gave me tons of users whose names are all like '23456@mail.com' or other '<numbers>@<mail adress>'. I have to scroll by multiple pages to find the correct user.

I noticed that these users are all under a Prefix '#', not the beginning number of their username. Is that a problem related to SQLite storage structure? Is there any approach to solve this?

[Luke 40096]

@MissMakima

HI, the Prefix field is based on the position in the A-Z picker, so that's why all entries that begin with a number have a Prefix of #.

But I tested NameStartsWithOrGreater on the 4.9 beta channel and it is returning accurate results there, so I think there are improvements in newer releases.

[MissMakima 2]

34 minutes ago, Luke said:

@MissMakima

HI, the Prefix field is based on the position in the A-Z picker, so that's why all entries that begin with a number have a Prefix of #.

But I tested NameStartsWithOrGreater on the 4.9 beta channel and it is returning accurate results there, so I think there are improvements in newer releases.

So could this new method be applied to A-Z prefix? Or I have to use both of them to search different kind of users?

[Luke 40096]

I can't change that, sorry. Emby apps need that to be #. Your best bet might be to just not use the Prefix field for whatever you're doing, but you can still use NameStartsWithOrGreater for searching.

[MissMakima 2]

1 minute ago, Luke said:

I can't change that, sorry. Emby apps need that to be #. Your best bet might be to just not use the Prefix field for whatever you're doing, but you can still use NameStartsWithOrGreater for searching.

I will give it a try. Thank you.

[Luke 40096]

Let us know how you get on. Thanks.