Thank you for the great plugin. My question is about something that I want to achieve but I'm not sure how to. Can you please advice on how I can do this with WPDataTables?
I have two SQL tables, one has all the information. The other one is a SQL table that can be edited and is limited to user only data.
Now I would like to add information from a JSON API parsed and inserted into another SQL table. For this, I plan to have a PHP code.
The issue is:
I want the JSON data to be refreshed or pulled when the user accesses his own table. The JSON API URL should have a custom input based on column 1 of the user table, for example.
I'll make it clearer. The tables have information on stocks. The table 1 has over 17K stocks in SQL. Table 2 are only the stocks that user adds to his own table. Both these tables are connected in a Table 3 using the SQL table connector in WPDataTables. So Table 3 displays data from Table 2 and Table 1 depending on how many rows are in Table 2 (i.e. the number of stocks the user has in his own table).
Now I need updated prices on the stocks available from JSON API only for the stocks that are loaded in the page. Since SQL will only load 10 or 25 (depending on the number of rows).
So each JSON API URL changes according to the name of stock. For the PHP code, I need to check how many rows are in the table so I can insert those many API URLs.
Do you have any idea on how I can achieve this in an easier way? I just need to add JSON data to another SQL table and connect it to these tables. But the data should only be refreshed according to the stocks loaded on the page (instead of refreshing all stocks).
Really sorry for the long question. Any ideas will be very helpful!
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.
-
If you have coding skills and wish to try to make a custom solution now,
Hello,
Thank you for the great plugin. My question is about something that I want to achieve but I'm not sure how to. Can you please advice on how I can do this with WPDataTables?
I have two SQL tables, one has all the information. The other one is a SQL table that can be edited and is limited to user only data.
Now I would like to add information from a JSON API parsed and inserted into another SQL table. For this, I plan to have a PHP code.
The issue is:
I want the JSON data to be refreshed or pulled when the user accesses his own table. The JSON API URL should have a custom input based on column 1 of the user table, for example.
I'll make it clearer. The tables have information on stocks. The table 1 has over 17K stocks in SQL. Table 2 are only the stocks that user adds to his own table. Both these tables are connected in a Table 3 using the SQL table connector in WPDataTables. So Table 3 displays data from Table 2 and Table 1 depending on how many rows are in Table 2 (i.e. the number of stocks the user has in his own table).
Now I need updated prices on the stocks available from JSON API only for the stocks that are loaded in the page. Since SQL will only load 10 or 25 (depending on the number of rows).
So each JSON API URL changes according to the name of stock. For the PHP code, I need to check how many rows are in the table so I can insert those many API URLs.
Do you have any idea on how I can achieve this in an easier way? I just need to add JSON data to another SQL table and connect it to these tables. But the data should only be refreshed according to the stocks loaded on the page (instead of refreshing all stocks).
Really sorry for the long question. Any ideas will be very helpful!
Thank you very much!
Hi, Syed
Sorry for the delayed response.
Thanks for reaching out to us.
-
At this time, we don't have any built-in solution to achieve anything similar to this kind of use-case,
and we also don't have any workarounds or custom example to offer as an idea for a solution.
You can suggest it to our developers - they will do their best to make a solution 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.
-
If you have coding skills and wish to try to make a custom solution now,
you can check out our available hooks for Developers on this documentation and see if you can find any hook that might help.
Please be advised that custom solutions with hooks are not included in our support.
You can also research resources such as Stack Overflow to see if any other user perhaps found a workaround.
( We do like to give examples for certain solutions whenever possible,
but for this kind of use-case, we, unfortunately, don't have anything yet)
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