john ackers

<p>Presents the results a database SQL query in a table. The query can be saved as a<br />
named view which can then be embedded as a table in any post using the shortcode<br />
[dbview name=name-of-view]. Views can be created and edited in the dashboard.</p>
<h4>Shortcode examples</h4>
<p>Show the ‘world cities’ view with a page size of 50 rows.<br />
    [dbview name=’world cities’ pagesize=50]</p>
<p>Show the ‘world cities’ view initially sorted by column ‘city’ in ascending order.<br />
    [dbview name=’world cities’ sort=city order=asc]</p>
<p>Show the ‘world cities’ view initially sorted by column ‘population’ in descending order.<br />
    [dbview name=’world cities’ sort=population order=desc]</p>
<p>Show the ‘world cities’ view without any pagination.<br />
    [dbview name=’world cities’]</p>
<p>Show the ‘world cities’ in the US with a population of greater than 5 million. See FAQ on passing arguments.<br />
    [dbview name=’world cities in country’ sort=city order=asc pagesize=10<br />
     arg1=’United States’ arg2=5000000]</p>
<h4>End User Features</h4>
<ul>
<li>Column sorting on table header. Columns are enabled on each column.</li>
<li>Page navigation is on the table footer (from 0.5.3).  </li>
<li>Tables are loaded using AJAX.</li>
</ul>
<h4>Management Features</h4>
<ul>
<li>Each view can be created/edited/deleted and tested under dbview/Settings in the dashboard.</li>
<li>Easy view consists of one SQL statement plus an optional PHP snippet associated wthe each column.</li>
<li>Sorting on each column can be enabled and disabled.</li>
<li>Each column can be manipulated using a PHP snippet. This functionality allows the introduction of permalinks, images and other customisations. </li>
<li>Each view is stored in a single serialized object in the wp_options table.</li>
</ul>
<h4>Limitations</h4>
<ul>
<li>Tables are not styled; this is left to the theme. </li>
<li>The data in the results table(s) cannot be edited.</li>
</ul>
<h4>Security</h4>
<p>When the plugin is activated, administrators are given the capability to ‘manage DB views’.<br />
Any other wp user with a different role that needs to create/edit views <a href="https://codex.wordpress.org/Roles_and_Capabilities" rel="nofollow ugc">must be granted that capability</a>.<br />
Only a view that is explicitly checked as public will be visible to non administrators and the public.</p>


dbview

Presents the results a database SQL query in a table. The query can be saved as a

Darren Cooney

<p>Easy Query is the fastest and simplest way to build and display WordPress queries without writing a single line of code.</p>
<p>Visually build a custom <code>easy_query</code> shortcode and <code>WP_Query</code> code snippet based on the content of your website by adjusting various parameters in the Query Builder. Then simply place the generated shortcode or WP_Query() directly into a template, content editor or widget area of your theme.</p>
<h3>Features</h3>
<ul>
<li><strong>Query Builder</strong> – Create your own Easy Query shortcode in seconds by adjusting the various query parameters.</li>
<li><strong>Query Generator</strong> – Generate a custom WP_Query by adjusting parameters in the Query Builder.</li>
<li><strong>Customizable Template</strong> – The Easy Query customizable template allows you to match the look and feel of your website.</li>
<li><strong>Paging</strong> – Easily enable Easy Query paging by setting paging=”true” in your shortcode.</li>
<li><strong>Multiple Instances</strong> – Include multiple instances of Easy Query on a page, post or page template.</li>
<li><strong>Save Time and Reduce Frustration</strong> – Stop searching the WP Docs and build a query visually using the Query Builder.</li>
</ul>
<blockquote>
<h3>Want More?</h3>
<p>Upgrading to <strong><a href="https://connekthq.com/plugins/easy-query/" rel="nofollow ugc">Easy Query Pro</a></strong> unlocks added features and functionality of the plugin.</p>
<h4>Unlimited Templates</h4>
<p>Create, modify and delete Easy Query templates as you need them with zero restrictions.</p>
<h4>Saved Queries</h4>
<p>Save, edit and delete past queries using the custom query editor.</p>
<h4>Responsive Layouts</h4>
<p>A library of fully responsive layout templates ready for use on your website.</p>
<h4>Paging Styles</h4>
<p>Select from additional pagination styles and colors.</p>
<h4>Additional Query Arguments</h4>
<p>Unlock additional query parameters such a taxonomy and custom fields.</p>
<h4>Multisite Compatibility</h4>
<p>Install and manage Easy Query templates and queries across multiple sites in your network.</p>
<p><strong><a href="https://connekthq.com/plugins/easy-query/" rel="nofollow ugc">Learn more</a></strong></p>
</blockquote>
<h3>Shortcode Parameters</h3>
<p>Easy Query accepts a number of parameters that are passed to the WordPress query via shortcode.</p>
<ul>
<li><strong>container</strong> – Select the type of HTML container that will wrap your Easy Query templates. Default = < ul ></li>
<li><strong>classes</strong> – Target your content by adding custom classes to the container. Default = null</li>
<li><strong>template</strong> – Select which template you would like to use. Default = ‘default’</li>
<li><strong>post_type</strong> – Comma separated list of post types. Default = ‘post’</li>
<li><strong>category__in</strong> – A comma separated list of categories to include by ID. Default = null</li>
<li><strong>category__not_in</strong> – A comma separated list of categories to exclude by ID. Default = null</li>
<li><strong>tag__in</strong> – A comma separated list of tags to include by ID. Default = null</li>
<li><strong>tag__not_in</strong> – A comma separated list of tags to exclude by ID. Default = null</li>
<li><strong>day</strong> – Day of the week. Default = null</li>
<li><strong>month</strong> – Month of the year. Default = null</li>
<li><strong>year</strong> – Year of post. Default = null</li>
<li><strong>author</strong> – Query by author id. Default = null</li>
<li><strong>search</strong> – Query search term (‘s’). Default = null</li>
<li><strong>post__in</strong> – Comma separated list of post ID’s to include in query. Default = null </li>
<li><strong>post__not_in</strong> – Comma separated list of post ID’s to exclude from query. Default = null </li>
<li><strong>post_status</strong> – Select status of the post. Default = ‘publish’</li>
<li><strong>order</strong> – Display posts in ASC(ascending) or DESC(descending) order. Default = ‘DESC’</li>
<li><strong>orderby</strong> – Order posts by date, title, name, menu order, random, author, post ID or comment count.  Default = ‘date’</li>
<li><strong>offset</strong> – Offset the initial query (number). Default = ’0′</li>
<li><strong>posts_per_page</strong> – Number of posts to load with each Ajax request. Default = ’6′</li>
<li><strong>paging</strong> – Enable Easy Query to page the results. Default = ’true′</li>
</ul>
<h3>Example Shortcode</h3>
<pre><code>[easy_query type="ul" classes="blog-listing entry-list" template="default" posts_per_page="6" post_type="post, portfolio"]
</code></pre>
<h3>Demos</h3>
<ul>
<li><strong><a href="https://connekthq.com/plugins/easy-query/examples/default/" rel="nofollow ugc">Default</a></strong> – Out of the box functionality and styling</li>
<li><strong><a href="https://connekthq.com/plugins/easy-query/examples/multiple-instances/" rel="nofollow ugc">Multiple Instances</a></strong> – Include multiple Easy Query instances on a single page</li>
<li><strong><a href="https://connekthq.com/plugins/easy-query/examples/owl-carousel/" rel="nofollow ugc">Owl Carousel</a></strong> – Creating a responsive jQuery carousel with Owl Carousel</li>
</ul>
<h3>Tested Browsers</h3>
<ul>
<li>Firefox (Mac, PC)</li>
<li>Chrome (Mac, PC, iOS, Android)</li>
<li>Safari (Mac, iOS)</li>
<li>IE8+</li>
<li>Android (Native)</li>
<li>BB10 (Native)</li>
</ul>
<h3>Official Website</h3>
<p>https://connekthq.com/easy-query/</p>


Easy Query – WP Query Builder

This plugin is missing a key feature I need BUT I am giving it 5 stars because I believe this is the best query builder I've seen AND the dev got back to me within 10 minutes and assured me that the feature I needed was in the works.

Very Nice Indeed

Create a custom WordPress query in seconds with Easy Query.

dbview vs Easy Query – WP Query Builder