if you filter on a column that has a multi select filter option it filters on any value selected. I need to have the filter records based on the combination of items selected. For example: I have a resort booking system where a potential renter may want the months of Jan,feb,mar. If they select the 3 months I want the filter to only present records where all three values exist in the record (field) instead of any record that matches any of the 3 values. In other words. Availability = “Jan and Feb and Mar”. Not “Jan or feb or mar”.
Is there a hook I can use to change the search fuctionality for that availability field to only return records that match all records that have all combined selections?
if you filter on a column that has a multi select filter option it filters on any value selected. I need to have the filter records based on the combination of items selected. For example: I have a resort booking system where a potential renter may want the months of Jan,feb,mar. If they select the 3 months I want the filter to only present records where all three values exist in the record (field) instead of any record that matches any of the 3 values. In other words. Availability = “Jan and Feb and Mar”. Not “Jan or feb or mar”.
Is there a hook I can use to change the search fuctionality for that availability field to only return records that match all records that have all combined selections?
Hi hrvresort,
Thank you for your purchase.
Can you please send me the link of that table so I can take a look and give you my suggestion.
Also please tell me did you try to check Exact filtering option for that column ( attachment )
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables