It appears the url filtering is not working. I have set the Advanced column filters / Enable advanced column filters to true in the table settings under sorting and filtering. See SubRegion and Region columns (they reference hidden columns, but the original columns also do not work).
Better Example. I believe the amount of data may be impacting the filtering.
I managed to have it work for one table but now it does not seem to work. It appears the parameter is being fed into the tables as expected however the table does not find any results (when there are results). Screenshots attached.
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.
I have created other charts frame scratch that seem to work so I'm not certain why these don't. If I continue to have issues I'll open another ticket. Behavior seems to be volatile after editing tables/charts too frequently. Close this ticket for now :)
I believe I found the source of the problem. It happens when I use an alias. I am using the alias name in the url.. In the below example I am using state instead of state_name:
The workaround I found is to place any query with an alias into a sub query. It seems the filtering must directly interact with the database and not the current data set. When calling back I suspect (you would know for sure!) that the alias name is being used against the column name resulting in no records found.
Workaround for filtering on columns that are aliased would look like this if you want to filter on State:
select State from (
select state_name as State from tablename
) as newtable
You only need to do this if you want to filter on a column with an alias. For columns you do not need to filter on the alias still works as expected.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
For server side tables we used php-sql parser which is responsible for parsing of the query and building new queries dynamically and in those cases when you have such queries or more complicated we suggest to prepare a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.
Hi,
It appears the url filtering is not working. I have set the Advanced column filters / Enable advanced column filters to true in the table settings under sorting and filtering. See SubRegion and Region columns (they reference hidden columns, but the original columns also do not work).
Better Example. I believe the amount of data may be impacting the filtering.
https://data-ace.com/?page_id=83&wdt_column_filter[state_name]=Wisconsin
I believe this is resolved this.
I needed to :
1) have chart follow table (given)
2) turn on Show filters in Table -> Sorting and Filtering
3) Column Settings -> Filtering -> Allow Filtering on.
I managed to have it work for one table but now it does not seem to work. It appears the parameter is being fed into the tables as expected however the table does not find any results (when there are results). Screenshots attached.
Hi Andrew,
Thank you for your purchase.
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.
Also provide us table id so we can investigate
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
I have created other charts frame scratch that seem to work so I'm not certain why these don't. If I continue to have issues I'll open another ticket. Behavior seems to be volatile after editing tables/charts too frequently. Close this ticket for now :)
I believe I found the source of the problem. It happens when I use an alias. I am using the alias name in the url.. In the below example I am using state instead of state_name:
select state_name as state from tablename
Hi Andrew,
I am glad that you find what cause the issue.
If you have any issue or question please open new ticket, and we will gladly help.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
The workaround I found is to place any query with an alias into a sub query. It seems the filtering must directly interact with the database and not the current data set. When calling back I suspect (you would know for sure!) that the alias name is being used against the column name resulting in no records found.
Workaround for filtering on columns that are aliased would look like this if you want to filter on State:
select State from (
select state_name as State from tablename
) as newtable
You only need to do this if you want to filter on a column with an alias. For columns you do not need to filter on the alias still works as expected.
Hi Andrew,
Sorry for late response.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
For server side tables we used php-sql parser which is responsible for parsing of the query and building new queries dynamically and in those cases when you have such queries or more complicated we suggest to prepare a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables