MySQL Query with Charts .js or Google Charts Template or View By User ID

This support ticket is created 2 years, 8 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	-
-	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	-

Supporter timezone: Asia/Karachi (GMT+05:00)

Tagged: Toolset Blocks, Types plugin

This topic contains 3 replies, has 2 voices.

Last updated by Waqar 2 years, 8 months ago.

Assisted by: Waqar.

Author

Posts

April 14, 2022 at 10:58 pm #2341689

janO-3

Tell us what you are trying to do? Perform MySQL query with Charts.js or Google Charts View/Template to return line or other chart for User ID data. OR... can this be done with Looping and styled with CSS using Charts.js or Google Charts?

Is there any documentation that you are following? If not Toolset solution will invest in wpDataTables.

Is there a similar example that we can see? NOT EXACTLY. Below example doesn't include charting, only tables., but plugin further can create charts from generated tables. Best example found -> "How to create editable tables in WordPress where users edit only own... " hidden link

What is the link to your site? Private

April 15, 2022 at 5:30 am #2341851

Waqar

Hi,

Thank you for contacting us and I'd be happy to assist.

I'm afraid, Toolset doesn't offer any built-in integration with charting tools like Charts.js or Google Charts, but, you're welcome to submit a feature request at:
https://toolset.com/home/contact-us/suggest-a-new-feature-for-toolset/

For custom integration, you can include the example HTML from the desired charting tool on a page, and for the dynamic part, use the Toolset's classic/legacy view, to generate the raw data values, as needed.

For more personalized assistance around custom code, you can consider hiring a professional from our list of recommended contractors:
https://toolset.com/contractors/

regards,
Waqar

April 15, 2022 at 7:29 pm #2342311

janO-3

I realize that Toolset doesn't inherently integrate with Charts. I need an answer on the second inquiry. I can do custom integration of that in my theme. Can Toolset perform a MySQL query and create a table of results that I can use is more the question? Thanks.

April 16, 2022 at 12:26 pm #2342705

Waqar

Thanks for writing back.

You can use Toolset to perform a MySQL query and create a table of results indirectly, by using classic/legacy views. A view can query, posts, taxonomy terms, or WordPress users.

To use the classic/legacy views, please go to WP Admin -> Toolset -> Settings -> General and select the option "Show both the legacy and Blocks interface and let me choose which to use for each item I build" for editing experience.

After that, you'll be able to create classic/legacy views from WP Admin -> Toolset -> Views. The documentation on using the classic/legacy views is available at:
https://toolset.com/documentation/legacy-features/views-plugin/