I setup an admin website to manage items for a small company. Basically we have customer and products. I bought your plugin and I'm using it on my website.
I use JSON query to get the data. JSON is coming from REST endpoint on my wordpress site, and result is OK. But the table does not reflect the same value as you can seen in attachment. Is there any way to force the JSON query? Is there something else?
Thanks for your support.
Attached files: Capture d’écran 2019-01-05 à 18.52.19.png Capture d’écran 2019-01-05 à 18.51.53.png
Again, we apologize for the late response.
This is quite strange, and also I'm not able to access http://gestion.nidabeilles.ch/wp-json/gestionnid/v1/liste-paniers.
Can You please, provide me a temporary WP-admin login for your site where this happens, 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 party. You can write credentials here just check Private Reply so nobody can see them except us.
Check out our new Support Help Center!
Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin
Kind Regards, Aleksandar Vukovicaleksandar.email@example.com
Hello again Romain.
I'd like to access the dashboard on Your website. You can see from the attachment that I do not have administrator privileges.
Also, when I try to access the tables on this link: http://gestion.nidabeilles.ch/liste-paniers it just keeps loading without ever loading the page. After a few minutes it says that the connection timed out.
Can You please inspect and let me know if I You can provide me with admin level account for Your website?
Attached files: Selection_097.png
I see what You mean.
I am sorry to disappoint You, but unfortunately this is not possible with the plugin's built-in functions. wpDataTables doesn't load the session from JSON file, and it only uses it as a read-only source.
Please visit our Documentation to find out about limit for JSON format that our plugin could understand. If you have format that is different from one that our plugin needs you can write a PHP script that fetch the data from API and manipulate that data and return it in form of serialized PHP array.
You can take a look at these two tickets, maybe they'll help You get a clearer picture of what needs to be done with a serialized PHP array, in order to get the tables function the way You'd want them to.
I'm not sure that wpDataTables can use sessions in this way.
You can take a look at a similar request with a solution on these two tickets:
From version 2.2 it is possible to use placeholders with other table types – JSON, XML, and PHP array through the shortcodes and as predefined values in filters and editing. You can read more about that here.
Please take a look and let me know if you were able to solve the issue.
I tried something and tried to add the line as mentioned in the tickets, but my site crashed.
curl_setopt($ch, CURLOPT_COOKIE, $_SERVER['HTTP_COOKIE']);
So, as I my first requirement is to get a variable value in the code that generates JSON or PHP array, is there any way to pass a parameter / variable in the JSON or PHP url? When I configure the data source location of the wpdatatable it would be perfect to add something.
If so, this would solve my problem, and I can retrieve the value with a get method.
GOOD NEWS!!! I finally get the expected results. I added at the end of the datasource URL (Json) something like ?myparam=%VAR1%. Then, I created a wordpress template for the page, which let me populate the variable 1 with some value coming from URL (GET). It means that in the PHP code where I construct the JSON, I'm now able to get the value by GET, and build only content needed based on this parameter. Thank you very much to all the team for your great support.
Great news Romain!
You are welcome. Glad you got that working.
If you have any more issues or questions feel free to open a new ticket, we will gladly help.
We'd greatly appreciate it if you could take a minute and leave a Review on CodeCanyon on this link. Thanks!