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

mainpage.pl

marsjaninzmarsa

<p>Plugin for advanced filtering of site content by taxonomies and custom fields. If you have portfolio site and need to give users power of filtering items by topic and year, or photoblog with hundreds of photos categorized by colors, place and photographer, or even shop with bikes various type, vendor and price – this is something for you. You can setup filtering of any Post Type by any tax or meta parameter, text or numeric and display to your visitors fancy and configurable filtering widget.</p>
<p>Development is happening <a href="https://github.com/marsjaninzmarsa/WordPress-J-QueryFilter" rel="nofollow ugc">on GitHub</a>.</p>
<h4>Functions</h4>
<ul>
<li>Support for any Post Type on site and any theme – if you can display it, you can filter it</li>
<li>Support for any Taxonomy and any Custom Field – if you have post with it, you can filter by it</li>
<li>Support for multilingual sites (WPML and Polylang, qTranslate may work, but please don’t use it)</li>
<li>Uses native WordPress templates to display posts</li>
<li>Toolset, ACF and WooCommerce compatible</li>
<li>Easy to use for every user</li>
<li>Fully extendable and customizable for developers (AJAX? No problem. Filtering of users or comments? Even easier)</li>
</ul>
<h4>Todo</h4>
<ul>
<li>Fancy, drag’n’drop filter form configuration</li>
<li>Full and out of the box support for filtering by text, range (with or without slider) and date</li>
<li>More build in themes (Pro?)</li>
<li>AJAX support for every theme (Pro?)</li>
</ul>
<h3>Advanced integration</h3>
<p>Coming soon…</p>


Query Filter

Advanced taxonomy and Custom Fields CPT filtering plugin.

dbview vs Query Filter