Hi there, @afterthoughtsystem… if I understand your post correctly, you can achieve the desired result by using an advanced filter on your search, although, advanced filters are not the most efficient way to retrieve data. That being said, if I understand your setup correctly, it might not be so bad in this case, and it might actually be the only way to go unless you restructure some things.

Anyway, if you just want to see if it works, first, remove the rank constraints from your Search for Users. Next, click More… after Search for Users and select the :filtered option. Then, add a constraint to the filter, scroll to the bottom of the dropdown, and select Advanced…. Finally, construct the following filter: This User's Rank is Lieutenant or This User's Rank is Captain.

If you need to be able to use greater than and less than to define a category’s ranks, you would have to add another attribute to your option set that is a number and that orders the ranks because the option set doesn’t know that Captain is higher than Lieutenant just because that’s the way you have them ordered in the set (or at least I’m fairly certain that’s the case).

So, any of that make any sense? Hope it helps.

Best…
Mike

1 Like