Hello, I purchased the Powerful Filters yesterday and I doesn't quite support what I want, and I'm thinking maybe the Gravity Form Filters does, but I'm not sure. Here's what I want to do.
I want to add filters that allow customers to pick not only filters by Gender, Race, and Craft - which I did to some degree by using placeholders, but I need to filter and run a report by age ranges:
Junior Under 18
Open 18 to 39
Masters 40-49
Masters 50-59
Masters 60+
So I was thinking, I need a drop down that provides the details to WP Table to confine it by a set of ages when someone selects the above. Lastly, the table needs to "re-read from the DB" whenever the request is made...because I calculate the "rank" at the time of DB read. (I'm using the SQL option to hit the table with a custom SQL)
Can the Gravity form do this? If not, or if there's a better way, your help is REALLY appreciated. Thanks! Tim
First off, I'd like to quickly explain what these add-ons do:
Powerful Filters - they only add Cascade Filtering and the ability to hide the table before filters are applied.
Gravity Forms Integration for wpDataTables add-on - Gravity Formsis a 3rd party plugin which is used specifically for creating forms. Our Gravity add-on simply allows you to create wpDataTables from those forms. Nothing else - they can't provide any extended filtering function.
Unfortunately working with ranges doesn't work like that when filtering is applied. If the column consists of only numbers, you would be able to use the Number Range filter, but then people would need to define the filters FROM and TO.
To have a filter that will filter the table like you explained is not possible with the plugin.
What you could do is use SQL queries to add a condition where "if a column is under 18, create data in a new column with a value "Junior Under 18", from 18 - 39 create a new value "Open 18 - 39" " and so on.
So, you would have something like this:
Then you can hide the B column:
But enable filtering per that column. Your customers would get the feeling that they are filtering per column A, since you can add a custom label:
And then it would look like this:
and when a filter is applied:
I hope that helps.
Each SQL table gets the data in real time, so you don't have to worry about that.
Apologies for the late reply on this. I have a follow-up question on the below. This works...as in it creates the column and the concept makes sense, however, the filtering doesn't seem to work. It works for some some of the ranges...maybe on the first time, and then on others it doesn't. It seems like the "filtering" isn't working for the data in the table. Is there anything special I need to know? I have server side processing turned off...but other than that, I can't seem to think of a reason why it wouldn't be actually filtering.
Let me know how we can maybe try to diagnose this.
Yes, go to the page below, click on filter by age, then go to SUP or click the other "The 2k Tangle" tab and you'll notice that the dropdown only has the last age selected.
Well, even though that's the only filtering option for those two tables, it doesn't really work.
I'd need to take a look at these tables.
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party.
You can write credentials here just check Private Reply so nobody can see them except us.
Hello, I purchased the Powerful Filters yesterday and I doesn't quite support what I want, and I'm thinking maybe the Gravity Form Filters does, but I'm not sure. Here's what I want to do.
I want to add filters that allow customers to pick not only filters by Gender, Race, and Craft - which I did to some degree by using placeholders, but I need to filter and run a report by age ranges:
Junior Under 18
Open 18 to 39
Masters 40-49
Masters 50-59
Masters 60+
So I was thinking, I need a drop down that provides the details to WP Table to confine it by a set of ages when someone selects the above. Lastly, the table needs to "re-read from the DB" whenever the request is made...because I calculate the "rank" at the time of DB read. (I'm using the SQL option to hit the table with a custom SQL)
Can the Gravity form do this? If not, or if there's a better way, your help is REALLY appreciated. Thanks! Tim
Hello Tim
Thank you for your purchase.
First off, I'd like to quickly explain what these add-ons do:
Powerful Filters - they only add Cascade Filtering and the ability to hide the table before filters are applied.
Gravity Forms Integration for wpDataTables add-on - Gravity Forms is a 3rd party plugin which is used specifically for creating forms. Our Gravity add-on simply allows you to create wpDataTables from those forms. Nothing else - they can't provide any extended filtering function.
Unfortunately working with ranges doesn't work like that when filtering is applied. If the column consists of only numbers, you would be able to use the Number Range filter, but then people would need to define the filters FROM and TO.
To have a filter that will filter the table like you explained is not possible with the plugin.
What you could do is use SQL queries to add a condition where "if a column is under 18, create data in a new column with a value "Junior Under 18", from 18 - 39 create a new value "Open 18 - 39" " and so on.
So, you would have something like this:
Then you can hide the B column:
But enable filtering per that column. Your customers would get the feeling that they are filtering per column A, since you can add a custom label:
And then it would look like this:
and when a filter is applied:
I hope that helps.
Each SQL table gets the data in real time, so you don't have to worry about that.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
Apologies for the late reply on this. I have a follow-up question on the below. This works...as in it creates the column and the concept makes sense, however, the filtering doesn't seem to work. It works for some some of the ranges...maybe on the first time, and then on others it doesn't. It seems like the "filtering" isn't working for the data in the table. Is there anything special I need to know? I have server side processing turned off...but other than that, I can't seem to think of a reason why it wouldn't be actually filtering.
Let me know how we can maybe try to diagnose this.
Thanks, Tim
Hi again Tim
I checked your related page: https://www.paddlemonster.com/virtual-world-ranking-board/
And it seems that filters applied there work fine.
Can you show me an example where they don't work?
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
Yes, go to the page below, click on filter by age, then go to SUP or click the other "The 2k Tangle" tab and you'll notice that the dropdown only has the last age selected.
Thanks...lmk what you think.
I see, Tim
Well, even though that's the only filtering option for those two tables, it doesn't really work.
I'd need to take a look at these tables.
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party.
You can write credentials here just check Private Reply so nobody can see them except us.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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