I have a table that has two columns to represent a price: price minimum and price maximum. I want to create a filter that can provide me the ability to filter the rows that are between the entered minimum column and maximum column. For example:
I have the following table:
NAME | PRICE_MIN | PRICE_MAX Mike | 100 | 200
Brad | 150 | 300
John | 120 | 400
The filter that I want to create, must have two fields price min and price max, and if the user enters 110 at min and 500 at max, only the second and the thrid rows must be displayed. Now I can filter by column (min value between something and max value between something), but what I want is to can create something like >=min column and <=max column. Anyone can help me? Thanks!!
Sorry to disappoint you but unfortunately something like this is not possible to achieve with the plugin built in features at the moment.
The only suggestion with the >= or <= is maybe to use the conditional formatting to color the cells but to use them in the filters like this is not possible. Link to documentation.
I have a table that has two columns to represent a price: price minimum and price maximum. I want to create a filter that can provide me the ability to filter the rows that are between the entered minimum column and maximum column. For example:
I have the following table:
NAME | PRICE_MIN | PRICE_MAX
Mike | 100 | 200
Brad | 150 | 300
John | 120 | 400
The filter that I want to create, must have two fields price min and price max, and if the user enters 110 at min and 500 at max, only the second and the thrid rows must be displayed. Now I can filter by column (min value between something and max value between something), but what I want is to can create something like >=min column and <=max column. Anyone can help me? Thanks!!
Hi davitx17,
Thank you for your purchase.
Sorry to disappoint you but unfortunately something like this is not possible to achieve with the plugin built in features at the moment.
The only suggestion with the >= or <= is maybe to use the conditional formatting to color the cells but to use them in the filters like this is not possible.
Link to documentation.
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