john ackers

Presents the results a database SQL query in a table. The query can be saved as a 
named view which can then be embedded as a table in any post using the shortcode 
[dbview name=name-of-view]. Views can be created and edited in the dashboard.
<h4>Shortcode examples</h4>
Show the ‘world cities’ view with a page size of 50 rows. 
 [dbview name=’world cities’ pagesize=50]
Show the ‘world cities’ view initially sorted by column ‘city’ in ascending order. 
 [dbview name=’world cities’ sort=city order=asc]
Show the ‘world cities’ view initially sorted by column ‘population’ in descending order. 
 [dbview name=’world cities’ sort=population order=desc]
Show the ‘world cities’ view without any pagination. 
 [dbview name=’world cities’]
Show the ‘world cities’ in the US with a population of greater than 5 million. See FAQ on passing arguments. 
 [dbview name=’world cities in country’ sort=city order=asc pagesize=10 
 arg1=’United States’ arg2=5000000]
<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>
When the plugin is activated, administrators are given the capability to ‘manage DB views’. 
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>. 
Only a view that is explicitly checked as public will be visible to non administrators and the public.

dbview

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

WPLake

Advanced Views is a powerful, flexible tool that lets you display posts, custom fields, and content from ACF, MetaBox, Pods, WooCommerce, and WordPress itself.
Whether you’re building a custom layout, creating dynamic templates, or designing advanced content displays, this plugin simplifies the process – without relying on bulky page builders.
<h3>Why Choose Advanced Views?</h3>
✅ Display Posts & Custom Fields Anywhere – Show posts, Custom Post Types (CPT), WooCommerce products, and metadata effortlessly. 
✅ Supports ACF, MetaBox, and Pods – Retrieve and display data from <a href="https://docs.advanced-views.com/getting-started/supported-data-vendors" rel="nofollow ugc">multiple field plugins</a> with ease. 
✅ Solution for Everyone – Perfect for site owners, developers, and designers who want full control over content display. 
✅ Smart, Lightweight, and Developer-Friendly – Uses <a href="https://docs.advanced-views.com/templates/template-engines" rel="nofollow ugc">Twig & Blade templates</a> with automatic escaping, and <a href="https://docs.advanced-views.com/templates/css-and-js#id-1.1-just-in-time-assets" rel="nofollow ugc">Just-in-Time assets strategy</a> for smooth performance.
<h3>🎨 One Plugin – Multiple Content Sources</h3>
Advanced Views <a href="https://docs.advanced-views.com/getting-started/supported-data-vendors" rel="nofollow ugc">seamlessly integrates</a> with:
🔹 WordPress Posts & Pages 
🔹 Custom Post Types (CPTs) 
🔹 <a href="https://wordpress.org/plugins/woocommerce/" rel="ugc">WooCommerce</a> Products & Fields 
🔹 <a href="https://wordpress.org/plugins/advanced-custom-fields/" rel="ugc">Advanced Custom Fields</a> (ACF) 
🔹 <a href="https://wordpress.org/plugins/meta-box/" rel="ugc">MetaBox</a> & <a href="https://wordpress.org/plugins/pods/" rel="ugc">Pods</a> Fields
Whether you’re crafting a blog, directory, or custom WooCommerce store, Advanced Views makes it easy to query and display dynamic content.
<h3>🚀 Powerful Features</h3>
High-quality results without the time-consuming steps.
🔄 Smart Content Queries & Display
🔹 Easily <a href="https://docs.advanced-views.com/getting-started/introduction/creating-your-first-view" rel="nofollow ugc">display posts, custom fields</a>, and taxonomies with powerful <a href="https://docs.advanced-views.com/getting-started/introduction/creating-your-first-card" rel="nofollow ugc">WP_Query enhancements</a> 
🔹 Filter, sort, and customize results with Twig or Blade templates.
📌 Pre-Built Components for Quick Setup
🔹 Use <a href="https://docs.advanced-views.com/templates/pre-built-components" rel="nofollow ugc">ready-made components</a> for fast and easy content structuring. 
🔹 Includes meta fields, responsive CSS rules, and reusable templates.
⚡ Streamlined Development Workflow
🔹 <a href="https://docs.advanced-views.com/getting-started/introduction/key-aspects#id-3.1-built-in-data-binding" rel="nofollow ugc">Built-in Data Binding</a> & <a href="https://docs.advanced-views.com/getting-started/introduction/key-aspects#id-3.2-automated-template-generation" rel="nofollow ugc">Template Generation</a> – No need to manually convert field data. 
🔹 <a href="https://docs.advanced-views.com/templates/file-system-storage" rel="nofollow ugc">File System Storage option</a> & <a href="https://docs.advanced-views.com/templates/live-reload" rel="nofollow ugc">Live Reload feature</a> – Works seamlessly with IDEs, Git, Sass, and TypeScript.
🛠️ Simplified WordPress Queries
🔹 Master WP_Query with <a href="https://docs.advanced-views.com/getting-started/introduction/key-aspects#id-4.-card-component" rel="nofollow ugc">intuitive wrappers</a> that make querying posts and fields easier. 
🔹 Bulk template validation to keep everything running smoothly.
📚 Extensive Documentation & Friendly Support
🔹 <a href="https://docs.advanced-views.com/" rel="nofollow ugc">Step-by-step guides</a> to help you get started. 
🔹 <a href="https://wordpress.org/support/plugin/acf-views/" rel="ugc">Community forum</a> for free support, plus <a href="https://wplake.org/acf-views-support/" rel="nofollow ugc">Pro version support</a> for premium users.
<h3>🔓 Unlock More with Advanced Views Pro</h3>
<a href="https://advanced-views.com/pro/" rel="nofollow ugc">Advanced Views Pro</a> takes your content displays to the next level with powerful features designed for flexibility, interactivity, and efficiency:
✅ Repeater, Group & Flexible Fields Support – Display complex nested fields — including repeaters within repeaters and flexible content layouts. 
✅ Meta & Taxonomy Filters – Powerful backend filters based on custom fields and taxonomies. 
✅ AJAX Pagination – Improve user experience by loading new content pages seamlessly without full page reloads. 
✅ Sliders & Gallery Field Integration – Assign slider and gallery fields directly in your Views, enabling slick interactive carousels and image galleries out of the box. 
✅ Custom Data Integration – Inject additional PHP variables into templates for more tailored content outputs beyond the standard fields. 
✅ Custom Gutenberg Blocks – Turn any View into a reusable Gutenberg block, making it simple to insert dynamic content inside the block editor. 
✅ Reusable Component Libraries – Build and manage a library of reusable components to maintain design consistency and speed up site building.

Advanced Views – Display Posts, Custom Fields, and More


I could not figure out how to display google maps on front end but this plugin made it real simple. Very easy to use.


Makes Posting Google Maps Real Simple

Effortlessly display WordPress posts, custom fields, and WooCommerce data.

dbview vs Advanced Views – Display Posts, Custom Fields, and More