If you do not have foreign keys in the tables the cascade filtering will work.
For example if you have table with 10,000 entries and you just want to be able to cascade only first 2 columns, you just need to enable the cascade filtering and enable filtering for only that 2 columns.
Cascade filtering is working with and without foreign keys ( you do not need to have foreign keys in order for cascade to work).
Hi
I have 2 column Countries and City as filters
I want user if select Country show the city in same selected country
Example if user select USA will show only all city from USA
My question is how I did that?
HI anas6666,
Thank you for your purchase.
Unfortunately that type of filtering ( "cascade" filtering ) is not possible with the main plugin feature.
It request our Add-on called Powerful filters.
You can take a look at the examples and all features for this Add-on on this link.
Best regards.
Kind Regards,
Miloš Jovanović
[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
Thank you for your response
Is need foregn key or foregn column to can use cascade filtering
Hi anas6666,
Foreign keys and cascading filtering will work together.
Best regards.
Kind Regards,
Miloš Jovanović
[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
In my case I have table with more than 10,000 records with no primary or foregn key
Can I use cascading filtering for 2 column or should create foregn key??
I need to know before I buy it
I mean is need to switch both 2 column to foregn key to can work cascading filtering?
HI anas6666,
If you do not have foreign keys in the tables the cascade filtering will work.
For example if you have table with 10,000 entries and you just want to be able to cascade only first 2 columns, you just need to enable the cascade filtering and enable filtering for only that 2 columns.
Cascade filtering is working with and without foreign keys ( you do not need to have foreign keys in order for cascade to work).
Best regards.
Kind Regards,
Miloš Jovanović
[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