Screenshot 1<\/p>","2":"
Screenshot 2<\/p>","3":"
Screenshot 3<\/p>","4":"
Screenshot 4<\/p>","5":"
Screenshot 5<\/p>"},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[4108,1627,1625,235340,5643],"plugin_category":[59],"plugin_contributors":[81159],"plugin_business_model":[],"class_list":["post-42078","plugin","type-plugin","status-publish","hentry","plugin_tags-charts","plugin_tags-mysql","plugin_tags-sql","plugin_tags-sql-chart","plugin_tags-visualizer","plugin_category-utilities-and-tools","plugin_contributors-elvinhaci","plugin_committers-elvinhaci"],"banners":{"banner":"https:\/\/ps.w.org\/sql-chart-builder\/assets\/banner-772x250.png?rev=2343690","banner_2x":"https:\/\/ps.w.org\/sql-chart-builder\/assets\/banner-1544x500.png?rev=2343690","banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/ps.w.org\/sql-chart-builder\/assets\/icon-128x128.png?rev=2343690","icon_2x":"https:\/\/ps.w.org\/sql-chart-builder\/assets\/icon-256x256.png?rev=2343690","generated":false},"screenshots":[{"src":"https:\/\/ps.w.org\/sql-chart-builder\/assets\/screenshot-1.png?rev=2727756","caption":"
Screenshot 1<\/p>"},{"src":"https:\/\/ps.w.org\/sql-chart-builder\/assets\/screenshot-2.png?rev=2343690","caption":"
Screenshot 2<\/p>"},{"src":"https:\/\/ps.w.org\/sql-chart-builder\/assets\/screenshot-3.png?rev=2727756","caption":"
Screenshot 3<\/p>"},{"src":"https:\/\/ps.w.org\/sql-chart-builder\/assets\/screenshot-4.png?rev=2343690","caption":"
Screenshot 4<\/p>"},{"src":"https:\/\/ps.w.org\/sql-chart-builder\/assets\/screenshot-5.png?rev=2727756","caption":"
Screenshot 5<\/p>"},{"src":"https:\/\/ps.w.org\/sql-chart-builder\/assets\/screenshot-6.png?rev=2727756","caption":""}],"raw_content":"\n
The plugin can create beautiful charts based on your SQL queries, then you can use those charts in any part of your website.\nYou can use both native wp and non-wp mysql tables in your queries.<\/p>\n\n
Give any name to your report.<\/p><\/li>\n
Use our preinstalled chart or create new one yourself: choose desired chart type, type sql query,\nenter field names, labels and then press to Publish\/Update<\/p><\/li>\n
You can use multiple SQL queries too. Just split them by ; sign. You can also add shortcode argument to SQL query. For example if you\ntype \"select * from wp_posts where ID>{arg1}\" then it you can pass arg1 value to the query with [gvn_schart_2 id=\"2\" arg1=\"11\"] shortcode.<\/p><\/li>\n
After update\/save you will see needed shortcode below there. You can use that shortcode anywhere in your website: in pages, posts, widgets etc.<\/p><\/li>\n
Just check \"Show table-view data below the graph\" in order to get table-list view below each chart.<\/p><\/li>\n
Using \"Dynamic Filters\" you can create dynamic variables inside SQL code. It also creates corresponding dynamic input form above each chart.<\/p><\/li>\n<\/ol>\n\n
Use this format: variable_name~default_value~variable_label~variable_type | variable_name~default_value~variable_label~variable_type etc.<\/p>\n\n
For example if to put<\/p>\n\n
limit_tag~10~Count~number | post_date_tag~2010-07-05 17:25:18~Date Published~date,<\/p>\n\n
then you can use this SQL code<\/p>\n\n
select * from wp_posts where post_date<{post_date_tag} limit {limit_tag}<\/p>\n\n
in SQL CODE field.\n{post_date_tag} and {limit_tag} would be replaced with dynamic variables.<\/p>\n\n
So, the plugin will automatically recognize it and put corresponding selectboxes above the chart.<\/p>\n\n
https:\/\/guaven.com\/my-sql-charts\/<\/a><\/p>\n\n https:\/\/guaven.com\/my-sql-charts\/#docs<\/a><\/p>\n\nDocumentation<\/h4>\n\n
Bug Submission and Forum Support<\/h4>\n\n