Hi there, I have a decimal (13,2) mysql column that contains negative currency values (ex. -300.00). If I enable SUM on that column, it causes all of the filters to fail to work. All filters return 0 records, even though they shouldn't. When I disable SUM on that column, the filters work again. Is there anyway to allow negative values to calculate properly with SUM?
The error I see in the console - network response is - Invalid JSON response
This error can occur for several reasons. Inspect the page, and see if you have any errors, warnings, or notices. If you do, you will need to clear them because they impact the JSON response wpDataTables expects to see.
If that doesn't help, check if you have some security measures imposed by a security plugin or your server. If there's anything blocking wpDataTables admin-ajax calls, the JSON response will not be valid.
Another thing that could be causing this is the cache. Please delete cache from your website and browser and see if the issue is resolved. If it is, prevent this page from being cached in the future.
Hi there, I have a decimal (13,2) mysql column that contains negative currency values (ex. -300.00). If I enable SUM on that column, it causes all of the filters to fail to work. All filters return 0 records, even though they shouldn't. When I disable SUM on that column, the filters work again. Is there anyway to allow negative values to calculate properly with SUM?
The error I see in the console - network response is - Invalid JSON response
Hello jko5er
This error can occur for several reasons. Inspect the page, and see if you have any errors, warnings, or notices. If you do, you will need to clear them because they impact the JSON response wpDataTables expects to see.
If that doesn't help, check if you have some security measures imposed by a security plugin or your server. If there's anything blocking wpDataTables admin-ajax calls, the JSON response will not be valid.
Another thing that could be causing this is the cache. Please delete cache from your website and browser and see if the issue is resolved. If it is, prevent this page from being cached in the future.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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