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
This document demos filtering of tables using a URL link which is great: https://wpdatatables.com/documentation/table-features/global-search-via-url/
But this falls apart if you're trying to filter a table by a number, for example, say a column has IDs, and you're trying to filter by ID using the URL. So you set the search filter value to 2, you would still get other results shown such as "22", "200" etc.
How can I get WPDT to filter for exactly/strictly for the record with value 2?
---
As a matter of fact, this whole workflow even fails for ranges. Example here's your demo where I'm trying to filter the "amount_purchased" column to show the record "11": https://wpdatatables.com/documentation/table-features/global-search-via-url/?wdt_column_filter[3]=11
You can see it puts 1 in start range and 1 end range...but if you add the pipe, then it works as expected, like so:
https://wpdatatables.com/documentation/table-features/global-search-via-url/?wdt_column_filter[3]=11|20
I'm not trying to filter a range but just thought I'd point that out since it looks like a bug.
Hi Uriahs,
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 did some tests and I can see what you mean. This is not a bug, it is the default behaviour of how our Logic for filtering Number Range works.
For the Table on that Example, we only set the Number Range as chosen filter for both numeric columns "amount purchased" and 'Total'.
So if you try to pre-filter via URL, for a Number Range we need to add the entire range, as you said, with the pipe symbol 11|20.
-
But I exported the Table as excel in order to make a demonstration of how it behaves if I change the filter type on a Column from "Number range" to "Number".
In this case you will see an additional option to set Exact Filtering.
Now, if you try to pre-filter via URL, you will get just the rows with "2".
Here are before and after exact filtering option screenshots :
So, to summarize, if you use a Number range filter - for that there is no Exact Filtering option because it expects us to give it a full number range via URL Pre-Filter.
When we need exact filtering, then you can switch to a regular "number" filter and you can achieve it.
-
The only strange detail I agree is not as I expect is, as you have shown, if we do "11" as pre-filter value, I would expect it to set it as the "from 11 " as the value, not to set "1" in from and to.
For that detail I will check with our QA Team and the developers if it is a bug, or a current limitation, and we will let you know, it will just take some time to investigate that particular behaviour.
Let me know if you have any additional questions in the meantime in regards to the Exact Filtering with a standard Number filter.
Thanks.
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
Hi Uriahs,
I have futher confirmations from our QA Team, we worked on further tests and made a conclusion, in regards to that 'strange detail' I was not sure about, when we input "11" as the Number Range URL parameter.
Basically, our URL Pre-Filter feature was primarily made to be used with standard filters, such as "Number" filter, as we shown before, on that you can place the "exact filtering", which works as intended.
-
For a Number Range, on the other hand, it is not designed to be passed inside URL parameter just as the number value, but you need to combine it with the pipe symbol for it to work as expected.
We have multiple ways :
1. If you wish to set the "from" value, add the value with the pipe, like "11|"
2. If you wish to set just the "to" value in the Range, set the pipe before the number like "|11"
3. Or if you wish the full Range , then set both numbers as you did before, like "11|12" for example.
So we will not consider that as a bug, but it is the current default logic for filtering Number Ranges as our developers created it.
Of course, if you have any suggestion how it can be improved in the future,
Please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
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
Thank you for the details and getting back to me
Hi Uriahs,
No problem, I am happy to advise.
Anything else that we could assist with, please don't hesitate to create new tickets.
Thank you.
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