How to filter / search an option set

Need help Database
1

I created an option set “Roles” with “coach” “athlete” values. My User table has a “role” field set to this option set as a data type. How then do I create a search or a filter that will show / hide elements on the page based on the user’s role?

I tried creating a condition and checking “Current User’s role / Do a search for” but I can’t search option sets for a value:

option.set
option.set1491×472 69.6 KB

But, when I set “Current User’s role / is / …” the list of available filtering/searching doesn’t make sense to me… I would think I would see something “Roles” then set a “Roles’s value = Roles.Coach” or something similar…

option.set.search
option.set.search541×632 51.9 KB

I also tried “Get an Option” but couldn’t see a way to filter/search for a speific Option Value… Thanks! New here, obviously…

2

Get an option: filtered

1 Like
3

Having said that, you should just be able to select current user’s role is coach, directly in the conditional expression…

Are you certain you’ve set up your database correctly?

1 Like
4

I believe so here’s the option set and the User table with Roles field. And, below that is the drop list I get when I enter “Current User’s Role”…

option.set.values
option.set.values1141×485 36.1 KB

user.table
user.table1377×161 20.2 KB

user.fields
user.fields482×594 39.2 KB

5

You have set up your option set roles (athlete and coach) as attributes of the option set, not as actual options. So, delete those attributes and enter athlete and coach as options in the New option field below the Create a new attribute button.

2 Likes
6

hmmmmm, ok, let me see… THANKS

7

Noobz… THANKS!!!
option.set.correct

1 Like