Having trouble filtering option-set data. Not sure what the issue is. Might be helpful is a layout my current process.
Under my data type “Job” I have a field called “Job Types”. This field is an option set for the different types of jobs each job can have (Full-time, Part-time, Internship, etc).
I’ve created a drop-down that is connected to this option-set (Job Type). The goal is to allow users to filter their search based on options in the drop-down.
To allow the user to filter, I have created a workflow that filters search results based on the drop-down changes (when user selects different options). I then try to filter the job value based on the drop-downs value. However, it does not allow me the drop-down’s value.
Hi @brandon6 - I was able to replicate what you are trying to do with Option Sets.
I see 2 differences in filtering rules between our approaches. I was able to do that with a ‘Do a Search for Jobs’ (without :filtered) and add the constraint as ‘Job Type = This Dropdown’s Value’ (instead of ‘This Dropdown’s value’s Display’).
I think the reason for the error on your filter is that ‘job type’ is probably an object from Option Set and not a text.
No, you don’t need to change the filter to text. (Only when you are using This Dropdown’s Value’s Display, then it has to be text). But we can use the OptionSet directly, as I was able to do as well.
I can’t think of anything else that can go wrong. Are the drop-down value settings configured correctly - like dynamic choices, with source as Job Type (& not static choice)?
I appreciate you working with me to figure this out.
Thankfully the issue is now solved. To be honest I’m not sure what fixed it, i played around with many different options (kinda disappointing). I believe it was the load state that was the issue. I think I had the custom state set to the wrong thing.