Hello, I'm learning Oracle Apex using a free workspace, so I'm on the newest version.
I am trying to add a faceted filter to a map page I have but I am kind of at a loss on how to get it working properly and have not had luck finding any info online.
In my application, I have a map page. I managed to add a working faceted checkbox filter to it, that filters between objects on the map, but this of course only works for 1 column each.
My problem is that I have 5 separate columns, with opening hours of the various objects on the map, on each weekday. Some of them are closed on certain days, others are open at varying times on different days and so on.
I am trying to add a filter that has the 5 weekdays as the checkboxes and if you click on say, Monday, it filters out any locations that aren't open on Monday.
It seems maybe a Facet Group would be the way to go for me but I am unable to figure out how to get it working. I've created one, added 5 checkboxes, I set the source of the checkboxes to the proper column and I tried playing around with that “Default” setting, that you can set to Static, Item, SQL Query etc.
I tried adding a simple SQL query to it but it doesn't look like it's finding anything at all because they were hidden by the “Zero Count Entries” setting being set to “Hide” by default.
The 5 columns are varchar and have data like:
“08:00-17:00”, “08:00-15:00”, “00:00-24:00”, “Closed”
Any assistance/guidance would be appreciated.
Thank you very much!