I am trying to do advanced filtering in the URL. It works if I hard code the value I want to filter on but not if I want to use a value from one of the columns in the table. I'm sure I am not formatting it correctly but I have tried all options I could think of. Here is the URL I have in my quote table:
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
I am sorry to disappoint you, but something like this is not currently possible.
If you use our pre-filtering via URL, you must set the column name inside the brackets, and you need to give it a fixed value from the cell in order for it to work.
So "quoteid" and then setting a "column Name" can not work, because it needs a specific value from a row and it needs the column name from which the row value is being called, in order to filter it.
Please follow the instructions how this works on this Documentation Page.
You will see our example Table and an example of how the URL should be formatted with a column name and the value from the row as a parameter.
For example, for our Table from that Documentation, if we wish to filter on Column 'City' and value as 'Linz', the URL would be :
I am trying to do advanced filtering in the URL. It works if I hard code the value I want to filter on but not if I want to use a value from one of the columns in the table. I'm sure I am not formatting it correctly but I have tried all options I could think of. Here is the URL I have in my quote table:
https://spanguard.net/quote-items/?wdt_column_filter[quoteid]=wdt_ID
Hi Beverly,
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
I am sorry to disappoint you, but something like this is not currently possible.
If you use our pre-filtering via URL, you must set the column name inside the brackets, and you need to give it a fixed value from the cell in order for it to work.
So "quoteid" and then setting a "column Name" can not work, because it needs a specific value from a row and it needs the column name from which the row value is being called, in order to filter it.
Please follow the instructions how this works on this Documentation Page.
You will see our example Table and an example of how the URL should be formatted with a column name and the value from the row as a parameter.
For example, for our Table from that Documentation, if we wish to filter on Column 'City' and value as 'Linz', the URL would be :
https://www.wpdatatables.com/documentation/table-features/global-search-via-url/?wdt_column_filter[1]=Linz
You can either place the index number of the Column inside the squared brackets ( zero indexed), or you can insert the Header Name.
-
If you need to search two or more values in same column by URL filter,
this can be done if you make the filter as multiselectbox, and separate the data with a pipe like this:
?wdt_column_filter[State]=Alabama|Texas
Let me know if that helps and if you have any additional questions.
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