I am working on a dashboard that helps businesses manage events. The application has a dashboard with a repeating group that has a data source
Search for Events (database table)
Events Table has a value called “type” for the type of event (e.g. Live Webinar, Recorded Webinar, Public Workshop, etc). That data comes from an Option Set cleverly named Event Types.
I added a drop down over the dashboard set up as follows:
Choice of style: Dynamic Choices
Type of Choices: Event Type (an Option Set)
Choices Source: All Event Type
Option Caption: Current Option Display
Ta-dah - they are all there.
The workflow is to Set a Custom State on the dashboard that
Does a Search for Events
Type (from the Event table) contains This Dropdowns Selected Display is not empty.
When I accept the conditional and go back to the Set State the error is:
“Evaluates to a List of Event Types”
Option Sets are not in the database. But once the Dropdown has a selected option, why would the Search that is constrained by the Dropdowns Selected Display (or value) find anything other than the value from the Dropdown?
I am assuming the value stored in the Events table for type (Option Set Event Type) is an integer or ID. Do I need to expose that and match ID’s?
Have been messing with this for a few days, walk away, ice, JW Black, and it’s still a mystery to me why Option Sets are so difficult to apply as a filter. There are at least 10 queries on the same topic and each one lost me along the way.