grexican

<p>If you’ve ever needed your ACF choices to be dynamically generated by a SQL query, this plugin will help you get the job done.</p>
<p>You can mix and match static choices with dynamic, SQL-based choices by placing as many regular choices in the list as you’d like, followed by the special <code>%%QUERY%%</code> choice that will tell this plugin to load choices dynamically from the database.</p>
<p>An example on how to list users, setting the <code>id</code> as the value, would look like this:</p>
<pre><code>%%QUERY%% : SELECT user_nicename AS text, id AS value FROM wp_users
</code></pre>
<h3>Arbitrary section</h3>


ACF Dynamic Choices

Advanced Custom Fields plugin to allow for dynamic choices (through SQL queries)

joeyoungblood

<p>WP Business Intelligence Lite allows you to powerfully display responsive data tables and charts on your website. This plugin is simple to use and allows you to connect with your wordpress database and display the data in real time. Once you have created at least one SQL query that retrieves data from your DB, you can define the type of chart (bar, donut, line, or grouped bar) or table to be used to display them. A simple shortcode embeds the chart or table in any post or page. Each page refresh retrieves the data from the DB so that the information in the chart or table is always up-to-date.</p>
<p>Installation guide, FAQs and support can be found at <a href="http://www.wpbusinessintelligence.com/support" rel="nofollow ugc">WP Business Intelligence Support</a></p>
<p><a href="http://www.wpbusinessintelligence.com/demos" rel="nofollow ugc">WP Business Intelligence Demos</a></p>
<p>In order to use your own live MySQL, MS SQL, or PostgreSQL database with WP Business Intelligence, purchase the Pro version of WP Business Intelligence from the <a href="http://www.wpbusinessintelligence.com" rel="nofollow ugc">WP Business Intelligence web site</a></p>
<p>We are actively developing this plugin and would love to hear from you with feature requests. <a href="http://www.wpbusinessintelligence.com/contact/" rel="nofollow ugc">Contact Us.</a></p>
<p>Some icons provided by <a href="https://fontawesome.com/license" rel="nofollow ugc">Font Awesome</a></p>
<h4>Features</h4>
<ol>
<li>Live connection to your WordPress DB via custom SQL queries</li>
<li>Responsive charts/tables</li>
<li>Works in Chrome, Firefox, IE9+</li>
<li>Charts based on <a href="https://eventbrite.github.io/britecharts/tutorial-kitchen-sink.html" rel="nofollow ugc">Britecharts</a></li>
<li>Tables build on <a href="https://datatables.net/" rel="nofollow ugc">Datatables</a></li>
</ol>


WP Business Intelligence Lite

As a long-time user of this plugin I had been dismayed with how it had eroded in recent years. A few months ago the developer and I reached an agreement for me to take over the plugin so my team and I could start making updates. 

Since December of last year we have fixed all of the known bugs in the display of the charts, fixed the tooltip display, introduced more free charts for WP users, fixed a handful of database query bugs, added a feature to give your charts and graphs a name, added animation to all charts and graphs, and added a feature to give charts and graphs a caption. 

This is only the beginning of our updates, but after 3 months of hardwork the issues with this plugin that were breaking reporting dashboards for us and our clients have now been fixed. We have an aggressive roadmap to bring more charts, features, and functionality to both the free and paid version of this plugin and I am excited to keep using it to build business intelligence dashboards and to display in-depth data on our clients websites.

Problems Getting Fixed, Great Charts!

Dynamic web charts and tables for your site! Connect to your live WordPress instance DB to retrieve data in real-time and update charts and tables!

ACF Dynamic Choices vs WP Business Intelligence Lite