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

Display content with full control over selection and layout. Lightweight and compatible with any theme or page builder.
<h3>⭐ Why Choose Advanced Views?</h3>
Advanced Views is a framework that empowers you to create the layouts and selections you need, without bloatware or heavy dependencies.
✅ Solid by design: craft modular and reusable layouts. Avoid repetition, style conflicts, and messy code snippets. 
✅ Content-driven: pull content dynamically, with granular filtering and sorting options, built on top of the native WordPress Query. Master advanced database queries with post fields, taxonomies, and meta values. 
✅ Time-saver: automate the groundwork and data fetching. Focus on creating while leaving typical routines behind. 
✅ Fully customizable: directly access the template code to create advanced elements, like Grids and Sliders, and harness your theme styles and scripts. 
✅ Easy to embed: copy and paste a native WordPress shortcode to add layouts anywhere.
<h3>🧩 Plenty of Use Cases</h3>
Custom fields and Post Types are essential to WordPress. Advanced Views natively supports them – giving you the freedom to pull, mix, and combine them in a common layout.
Popular scenarios include:
Displaying custom fields:
🔹On a single page: to enrich landing page sections 
🔹CPT-wide: estimated delivery time for all Products 
🔹Site-wide: contact details from the Options page 
🔹User-specific: fields of the current user in a custom banner or profile page
Displaying Posts, Products and CPT:
🔹Posts: blog posts from a specific category 
🔹WooCommerce: related Products in a grid or carousel 
🔹Event lists: Show upcoming events, hide past events 
🔹Real Estate listings: properties by location, size, or type 
🔹Locations map: display all pick-up location markers on a single map 
🔹Reviews and Comments: product reviews or user comments
<h3>🔗 Multiple Content Sources</h3>
Advanced Views is vendor-independent and plugin-agnostic – so it will work with WordPress Posts, WooCommerce Products, and any CPT on your website.
Learn it once and use it everywhere with built-in support for:
🔹All Custom Post Types registered in WordPress 
🔹<a href="https://wplake.gitbook.io/advanced-views/getting-started/supported-data-vendors#id-1.-wordpress" rel="nofollow ugc">WordPress post fields</a> (title, featured image, author, taxonomy terms…) 
🔹<a href="https://wplake.gitbook.io/advanced-views/getting-started/supported-data-vendors#id-2.-woocoomerce-plugin" rel="nofollow ugc">Woo Product fields</a> (price, sku, stock status, weight…) 
🔹<a href="https://wplake.gitbook.io/advanced-views/getting-started/supported-data-vendors#id-3.-advanced-custom-fields-plugin" rel="nofollow ugc">Advanced Custom Fields</a> (whether it’s text, select, image, gallery, repeater or relationship) 
🔹<a href="https://wplake.gitbook.io/advanced-views/getting-started/supported-data-vendors#id-4.-metabox-plugin" rel="nofollow ugc">MetaBox fields</a> (like map, oEmbed, taxonomy, group… ) 
🔹<a href="https://wplake.gitbook.io/advanced-views/getting-started/supported-data-vendors#id-5.-pods-plugin" rel="nofollow ugc">Pods fields</a> (from WYSIWYG, price, date and time… )
You can integrate data from any external source, including API-based, directly into Layouts using snippets.
<h3>🚀 Powerful features</h3>
Whether you’re a developer working on a child theme, a web creator using a page builder, or a tech-savvy website owner, Advanced Views makes the process easier with:
🔹<a href="https://wplake.gitbook.io/advanced-views/templates/file-system-storage" rel="nofollow ugc">Storage options</a>: craft Layouts using the on-site editor, or edit them inside your favourite IDE, with git-friendly templates. 
🔹<a href="https://wplake.gitbook.io/advanced-views/templates/multilingual" rel="nofollow ugc">Multilingual-friendly</a>: translate any text or label in the Layouts using your favourite tool (like WPML or Polylang) 
🔹<a href="https://wplake.gitbook.io/advanced-views/getting-started/introduction/key-aspects#id-3.3-seamless-data-connection" rel="nofollow ugc">Automatic template validation</a>: keep all the Layouts up-to-date with bulk validation, and get prompted to update the relevant layouts when used meta fields have been changed. 
🔹<a href="https://wplake.gitbook.io/advanced-views/templates/template-engines" rel="nofollow ugc">Template engine options</a>: opt for the Twig or Blade template engine site-wide, or mix it up and make a per Layout decision. 
🔹<a href="https://wplake.gitbook.io/advanced-views/templates/css-and-js#id-1.1-just-in-time-assets" rel="nofollow ugc">Just-in-time assets loader</a>: get layout styles and scripts injected just-in-time, on a per-page basis. Make fast page loading and great speed metrics your defaults. 
🔹<a href="https://wplake.gitbook.io/advanced-views/templates/live-reload" rel="nofollow ugc">Live reload and Dev mode</a>: see live changes to Layouts on the page, and find used layouts without searching.
<h3>📚 Extensive Documentation & Friendly Support</h3>
🔹<a href="https://docs.advanced-views.com/" rel="nofollow ugc">Helpful guides</a>, FAQs, tips, and common use cases with code snippets 
🔹Lite users are supported via the public <a href="https://wordpress.org/support/plugin/acf-views/" rel="ugc">wordpress.org forum</a> 
🔹Pro users get priority support via <a href="https://advanced-views.com/support/" rel="nofollow ugc">our website</a> 
🔹Actively maintained and tested against the latest WordPress releases
<h3>🔓 Unlock More with Advanced Views Pro</h3>
<a href="https://advanced-views.com/pro/#pricing" rel="nofollow ugc">Advanced Views Pro</a> takes your content displays to the next level with extended features:
Layouts get:
🔹<a href="https://wplake.gitbook.io/advanced-views/display-content/meta-fields/layout-fields/repeater-pro" rel="nofollow ugc">Repeater, Group, and Flexible fields support</a> – display complex nested fields — including repeaters within repeaters. 
🔹<a href="https://wplake.gitbook.io/advanced-views/display-content/custom-gutenberg-blocks-pro" rel="nofollow ugc">Gutenberg block option</a> – turn any layout into a Gutenberg block with a single checkbox. Same template with full markup control and zero React coding. 
🔹<a href="https://wplake.gitbook.io/advanced-views/display-content/front-end-assets-management-pro#supported-libraries-and-field-types" rel="nofollow ugc">Masonry, LightBox, Slider integrations</a> – turn your Repeater or User fields into a slider, Gallery Images into Masonry, or enable LightBox for single images. 
🔹<a href="https://wplake.gitbook.io/advanced-views/templates/reusable-components-library-pro" rel="nofollow ugc">Reusable components library</a> – reuse existing Layouts on other websites with a single-click Git sync.
Post Selections get:
🔹<a href="https://wplake.gitbook.io/advanced-views/query-content/meta-filters-pro" rel="nofollow ugc">Meta filters</a> – precise post selections with filtering by meta fields: define bindings to URL arguments, current meta values, and more. 
🔹<a href="https://wplake.gitbook.io/advanced-views/query-content/pagination-pro" rel="nofollow ugc">Ajax pagination</a> of results: choose between options for load more button, infinity scroll, or page numbers. 
🔹Post carousels: turn queried posts into sliders.

Advanced Views – Display Custom Fields (ACF, Pods, MetaBox), Posts, CPT and Woo Products anywhere in Gutenberg, Elementor, Divi, Beaver…


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

Display content with full control over selection and layout. Lightweight and compatible with any theme or page builder.

dbview vs Advanced Views – Display Custom Fields (ACF, Pods, MetaBox), Posts, CPT and Woo Products anywhere in Gutenberg, Elementor, Divi, Beaver…