Holiday Notice – Support Unavailable on April 18 and April 21
We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!
In the meantime, if you need any help, feel free to:
-
Use the support widget in the bottom right corner on our websites (Amelia and wpDataTables) — our latest AI-powered assistant is there 24/7 to help with basic and intermediate questions,
-
Browse our detailed documentation (Amelia, wpDataTables)
-
Explore helpful articles,
-
Or check out our YouTube channels for video guides!
Amelia YouTube Channel
wpDataTables YouTube Channel
Thank you for your understanding, and we wish you a wonderful holiday weekend!
Hi, I have set up a table with a Float column called "Cuota a Favor". I then created a Number range filter for this column in order for the table to show only the rows within a "Cuota a Favor" range.
However, the filter only works when entering integer numbers. For example, when inputting From 2 To 5 it works ok, but inputting From 2.5 or 2,5 makes the table to show no results.
On the other hand, this filter works as expected when I enable the option "Number range slider". The filter works correctly with decimals, but is a real pain to adjust the filter with this slider, at least in my dataset.
I hope you can help me with this problem, as if I can't solve it, it will render the plugin unusable for my needs, and I have just purchased it.
Hi David,
Thank you for your purchase.
Sorry for the late response, we have some agents that have contracted Covid-19, so our team is cut in half.
Yes you will need to use same Number format(that you set in Global settings) as in your source. If you still need that number format then you will need to make some changes in our plugin.
In file wp-content/plugins/wpdatatables/source/class.wpdatatable.php around lines 2026 and
you will find this
$left = str_replace(',', '.', str_replace('.', '', $left));
and you have to add comments like this
// $left = str_replace(',', '.', str_replace('.', '', $left));
also in same file around line 2035
you will find this
$right = str_replace(',', '.', str_replace('.', '', $right));
and you have to add comments like this
// $right = str_replace(',', '.', str_replace('.', '', $right));
Please note that will be overwritten in next update so you will need to do it again.
Best regards.
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
Hi Milan, thanks for your reply. I hope everyone is ok in your team.
I don't really get this: "you will need to use same Number format(that you set in Global settings) as in your source."
My table is created with a SQL query, and this column (Cuota a Favor) corresponds to a 'decimal(6,2) unsigned' column (Back_Odds) in my BBDD. In wpDataTables, I have set the data type for this column to Float, and the filter type to Number Range.
I will happily change the data of any of the datasets if that would solve the problem, it is just that I don't see any incompatibility there. I'm sure I must be missing something here.
Hi David
I believe Milan was referring to the number format in wpDataTables main settings as displayed on the image below
the values in the table need to be structured in the same way as they are in the source.
Can you please change the number format and let us know if you still have the same issue.
Oh god, finally working. Thanks a lot guys, this was driving me crazy. I thought that setting was for purely frontend "decorative" purposes
Sure!
Thank you!
If there is anything else we can assist you with please don't hesitate to open a new ticket.
Have a wonderful day!