I have an issue with filters above a table in the form of range.
The typical scenario is as follows:
1) For the first time when a page is opened filters correctly read the data and set a proper range with respect to the data.
2) However, once new data are available on the SQL server and the table is refreshed via a custom ajax function (below) then only the table is refreshed and filters keep their values from point (1), i.e. values are the same forever equal to the first point of the load → when the page was opened for the first time.
3) Thus, filters behave like static objects without reacting to table refreshment, data changes. However, as a range is wrong, it causes wrong filtering of the table (e.g. new data have a range up to 100, however old filter has a range = 70, thus the table is shown only up to 70).
4) The only way how to update the range is to reload the whole page which is obviously a solution from 90s :)
The custom function to refresh all wpdatatables on the page (works good for tables and even connected graphs when a graph's table is present on the page):
My question is, how to refresh the filter range via an ajax function? What object should I call? I believe the filter function will be very close to the table function, only objects will be different.
Firstly my apologies that it took so much to confirm this.
We did our best to find any examples from our developers;
but unfortunately, they don't have any custom workaround examples at this time.
If you'd like to see a built in solution for this, 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.
-
Maybe it can be done with a high level of custom work, but I am not sure, to be honest. Our developers are very busy at the moment, working on some priority tasks and fixing bugs and issues with our plugins, so they won't be having the time for custom work in the near future.
We can recommend reaching out to someone who does custom solutions, such as WP Kraken, but we can't advise on their pricing.
Yes, i can completely understand your position, and i am sorry about this...
I would love to be able to assist further, but as you can see, unfortunately, it turned out to be a higher level of custom work than is covered by our support.
I will do my best to affect this being pushed on the priority list as much as possible.
If you have any other questions, please don't hesitate to open a new ticket, of course.
Hello,
I have an issue with filters above a table in the form of range.
The typical scenario is as follows:
1) For the first time when a page is opened filters correctly read the data and set a proper range with respect to the data.
2) However, once new data are available on the SQL server and the table is refreshed via a custom ajax function (below) then only the table is refreshed and filters keep their values from point (1), i.e. values are the same forever equal to the first point of the load → when the page was opened for the first time.
3) Thus, filters behave like static objects without reacting to table refreshment, data changes. However, as a range is wrong, it causes wrong filtering of the table (e.g. new data have a range up to 100, however old filter has a range = 70, thus the table is shown only up to 70).
4) The only way how to update the range is to reload the whole page which is obviously a solution from 90s :)
----------------------------------------------------------------------------------------
The custom function to refresh all wpdatatables on the page (works good for tables and even connected graphs when a graph's table is present on the page):
{
jQuery('table[id^=table_]').each(function(){
jQuery(this).DataTable().ajax.reload();
});
}
----------------------------------------------------------------------------------------
My question is, how to refresh the filter range via an ajax function? What object should I call? I believe the filter function will be very close to the table function, only objects will be different.
Thank you,
Michal
Hi, Michal
Sorry for the delayed response.
This is a bit higher than my level of expertise, usually, for callbacks or custom functions we have to coordinate with our developers.
I will check this with them, and as soon as they respond, i will report back to you on this.
Thank you for your patience.
Kind Regards,
Miloš Jovanović
[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
Hello Miloš,
thank you very much, looking forward to the update.
Best,
Michal
Hey, Michal
I am so sorry for all the waiting time.
I still did not get confirmation, but i will keep checking with our senior Team, and i will advise you as soon as they respond about this.
Thank you for your patience on both of the open tickets.
Kind Regards,
Miloš Jovanović
[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
Hey, Michal
Firstly my apologies that it took so much to confirm this.
We did our best to find any examples from our developers;
but unfortunately, they don't have any custom workaround examples at this time.
If you'd like to see a built in solution for this, 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.
-
Maybe it can be done with a high level of custom work, but I am not sure, to be honest.
Our developers are very busy at the moment, working on some priority tasks and fixing bugs and issues with our plugins, so they won't be having the time for custom work in the near future.
We can recommend reaching out to someone who does custom solutions, such as WP Kraken,
but we can't advise on their pricing.
Kind Regards,
Miloš Jovanović
[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
Hello,
that is sad news as my idea was that this will be an easy and quick one for your dev team.
Best,
Michal
Hi, Michal
Yes, i can completely understand your position, and i am sorry about this...
I would love to be able to assist further, but as you can see, unfortunately, it turned out to be a higher level of custom work than is covered by our support.
I will do my best to affect this being pushed on the priority list as much as possible.
If you have any other questions, please don't hesitate to open a new ticket, of course.
Thank you
Kind Regards,
Miloš Jovanović
[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