Ok, good to read this
You can expect option sets to be free in terms of speed, since it’s just plain text being delivered and that weights nothing. Of course it’s best for them to confirm, this may be wrong.
@austin3 I may be speaking out of turn here… I use the :filter command to “Do a search for” on an Option Set. Since the options are client side, I’m guessing that’s why there isn’t a literal “Do a search for”.
Notice that when you do :filter, it is a “Constraint” just like a search.
And unlike a “Do a Search For”, you can inline “and” and “or” functions.
Finally, if I am interpreting this correctly, this :filter works just like the “Advanced” - Giving extreme control over your :filter for an Option Set.
I’m not sure your exact use case, but I’ve been able to search option sets fine with “:filter”.
Apologies, I realize in hindsight this may need clarification. I’m looking for a way to sort a list of data items by their option set field. Ideally you could sort by any attribute of the option set, but at least being able to sort by display and/or the order they’re listed in the option set tab would be helpful. I actually made a suggestion post related to OS sorting last month, but I don’t believe it ever got a response.
@w.fly, your response above has gotten me closer to what I want to achieve and suggests that what I want to achieve is doable but I can’t quite get it to work. Hoping you can help get me over the hump.
I have an option set Primary Use with Display text and Detail text. The Display text is a one word nickname that I the developer sees. The Details text is a corresponding long string that the user sees. Example:
The option set is used to control a text field titled “Primary Use” on the User data type.
I want the current user to be able to modify his/her own Primary Use via a dropdown input.
I can get the option set’s Detail (i.e. long string names) to display in the dropdown choices as intended.
But I’m having trouble getting the dropdown’s placeholder text to show the Detail text.
I’ve tried using your filter suggestion to filter the option set to only show the options whose Display text matches the Current User’s Primary Use field but I can’t seem to construct a valid filter constraint expression that accomplishes this.
Of course I could just ditch the option set idea and use the long text. But I’d prefer to (1) see nicknames in my workflow logic and (2) better understand how Option Sets can be filtered so if you have any suggestions I’d love to hear them.
Hmm if I comprehended that right, I believe you need to make the Primary Use field from a “text” to a “Primary Use” data type. You can have an Option Set as the field for a Data type. @tjc4
@w.fly, thanks for letting me know. I switched from an Option Set to a Data Type.
@tjc4 Actually what I meant was inside of the User data type, change “Primary Use” from being text to being Primary Use (the option set). You can make the field inside of a data type an option set.
So you’d go from this:
Or am I misunderstanding?
Hey you find a workaround?
Huge +1 on this, really need an import method for CSV - cheers