Hey everyone!
With the holiday season upon us, we want to share our upcoming working hours:
- New Year: Our team will be off on January 1st and 2nd. We’ll be back on Friday, January 3rd, to respond to any messages received during this time.
- Weekend: As usual, we don’t work on weekends, so January 4th and 5th will also be non-working days.
- Orthodox Christmas: Our office will be closed on Monday and Tuesday, January 6th and 7th for the holiday.
After that, we’ll return to our regular schedule and assist you as quickly as possible.
In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.
Thanks a bunch for your understanding and support!
Warm regards and happy holidays!
TMS
I cannot find example for filtering with url using a date range
Hi, Karl.
If you want to use the URL pre-filtering for range filters ( number or date Range)
you will separate values with pipe symbol (“|”). You can check that with this link below on our Documentation:
https://wpdatatables.com/documentation/table-features/global-search-via-url/?wdt_column_filter[3]=60|80
Here is my local host example from my computer's WordPress Test.
If my initial table and page look like this :
I add this to my page URL :
?wdt_column_filter[8]=01/01/2022|01/04/2023
As we pointed out in the documentation, you can either use the Index number of your Column,
or the Header Name.
It is safer to use the column index number; in my case it is column 8.
Please note, the index for Columns is zero based, so the first column starts as zero, then 1, 2 and so on.
And, this is how my table looks with the applied Date Range :
Let me know if that helps and if you have any 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
I have spent days and hundreds of dollars trying with contractors and cannot get the url filtering to work
http://3.137.132.39/customer-invoicing/?wdt_column_filter[0]=06/04/2023|06/10/2023
I should note that it is MySql server. Not sure if that matters. (they store the date as 2023-06-10) I have tried formmating the URL request every which way but loose.
If anyone can get the URL query to work, please contact me there definately will be a good reward
http://3.137.132.39/customer-invoicing/?wdt_column_filter[0]=06/04/2023|06/10/2023
Hi, Karl
Yes, it is possible that the Date Format in the source data from the Database tables is not working since you change the Date Format in the Plugin's tables,
but first we need to check if filtering works at all in these tables, maybe there is a misconfiguration in our plugin settings.
I notice that there are no filters available for either of these tables on your page.
Can you first check if the filters when you input them manually in these tables work,
on the back-end of the table(s)?
Maybe there is an issue that the date filter is not working on the tables,
so first we need to establish if filtering works in these tables,
then after that, the next step will be the URL filtering.
-Make sure that the "Invoice Date" Column has a date range filter enabled in the Column settings/Filtering,
and check if this Date column has "allow filtering" as well as "Date Range" as the chosen filter type?
After this, try to do the same date range that you're trying from the URL prefilter.
From 06/04/2023 until 06/10/2023,
and see if it gives results on the table like that, when directly inputting the date range.
Let me know if it works.
If not, try to change the Date Format in our main Plugin settings to match the same Date Format from your source Data in the Database Table.
Then try again to run the filter on the table.
If none of this works, i would like to remotely take a look at the back-end.
Please provide me a temporary WP-admin (administrator) user for your website where this happens,
as well as FTP credentials
and access to the database ( either link with credentials for PHPmyAdmin, or access to Hosting Panel),
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 parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
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