Filter Table By User

[thorsten.langner]

@John

Maybe splitting the difference: Once you drop-down the single select menu, you can use the keyboard to take you directly to the user you’re interested in. Try typing once you’ve opened it.

If that doesn’t work: Looking at the structure of your table, have you considered making the filter over the “Name” field and not the user field? Might get you closer to the desired result.

I have a similar issue and it is an often discussed one. It would be great to have access zu User-Parameters in the User-Field Table. Like Name, eMail, Role…
That would make it possible to search users with those information and use these parameters in app as well.

@yuhuan.pu
However, you could use an aggregation on all Users in this table, to reduce the amount in the singe select on only available users.
(Query with no filter, Aggregation “UniqueValues” on “User” column.
The downside is, that the users are then in the same order as in the table, since you can not order them by neme in the Query!

@John the typing in the single select works but is not handy at all. You need to type relatively quick and you dont see your typing. It also matters if you know the first or the last name, since you need to know the beginning of the user name. You cant reorder the list by name, when the source is the table iself (Aggregation to limit the users to available ones).