Query Wrangler

Description

This plugin lets you create new WP queries as widgets and use shortcodes for queries on your pages. It also allows you to override the way category and tag pages display.

Query Wrangler’s interface is highly intuitive way to create queries and will be second nature for any Drupal Views user.

This plugin will bring extreme flexibility to WordPress users with its ability to create custom queries using the WP_Query class with a user interface.

Supports:

  • Most post data, including meta fields
  • Taxonomy data
  • Advanced Custom Fields
  • Custom Content Type Manager
  • Some exposed filters

Some examples of how you would use this plugin include:

  • Create a list posts with featured images
  • Create a list of pages or posts within a specific category or tag
  • Create an image gallery
  • Modify the way your category pages look

Screenshots

  • Drupal Views Editor Theme

Installation

  1. Upload query-wrangler to the /wp-content/plugins/ directory
  2. Activate the plugin
  3. Visit the Query Wrangler Menu to begin creating your custom queries

FAQ

How do I use query shortcodes?

Easy, the code you’re looking for is like this. [query id=2] , where the number 2 is the query id. This can be found on the Query Wrangler page eside each query.

  • By slug: [query slug=”my-query”]
  • Customize WP_Query arguments: [query id=2 args=”posts_per_page=1&post_type=page”]
  • Customize WP_Query arguments with contextual data: [query id=1 args=”author={{post:post_author}}&post_type={{post:post_type}}”]

Developer & Usage

What are overrides and how do I use them?

Overrides allow you to alter the display and information given on category and tag pages.
For a simple example, add a new query and chose the type override. Choose how you want the content to display, then examine the Overrides box.
Select a category or multiple categories to override. Save the query, then visit that category page.

Reviews

مې 19, 2020
Coming from Drupal, it is such a relief to find this 'Views' like plugin. Thank you!
دسمبر 22, 2018 3 replies
As a long-time Drupal developer, this plugin feels like coming home. It works just the way I expect it to.
مې 10, 2017
This is one I have been looking for! Thank you!
Read all 37 reviews

Contributors & Developers

“Query Wrangler” is open source software. The following people have contributed to this plugin.

Contributors

Translate “Query Wrangler” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Changelog

1.5.53

  • Bug fix on post type archive override page when dealing with multiple post types.

1.5.52

  • New setting to allow caching of meta keys.

1.5.51

  • Tested up to WordPress 5.8-RC4.
  • Minor style improvement on editor form.

1.5.50

  • Bug fix: Regression in 1.5.49. Redundant dispatch of qw_pre_render broke QW widgets.

1.5.49

  • Feature: Setting to hide header or footer when no results are found.

1.5.48

  • Bug fix: Fix regression with pagination vs offset.

1.5.46

  • Bug fix: removing debugging function.
  • Bug fix: Pagination vs offset. WP_Query doesn’t handle this, so we do it manually.
  • Bug fix: Caching for expensive meta keys query on large sites.

1.5.45

  • Bug fix: Pagination vs offset. WP_Query doesn’t handle this, so we do it manually.
  • Bug fix: @jpSimkins – Caching for expensive meta keys query on large sites.

1.5.43

  • Bug fix: Using array_replace instead of array_merge in a few places.
  • Bug fix: Removing deprecated preg_replace eval flag for PHP 7 support.

1.5.42

  • Feature: Search box on query list page
  • Feature: Strip tags on Group by field
  • Feature: Added query shortcode by ID on edit page
  • Bug fix: Maintain token settings in later fields
  • Bug fix: Query data doesn’t unserialize correctly in some environments
  • Bug fix: Query wasn’t retaining Group by field in editor
  • Bug fix: JSON export may not load correctly

1.5.41

  • Feature: Contextual tokens allowed in callback text parameters
  • Change: Now using json for export & import to avoid eval. Warning, his will make existing saved exports useless.
  • Change: HTML span tag around file attachments for styling
  • Bug fix: Providing simple array polyfills for PHP5.2-
  • Bug fix: Some php notices on query creation & save
  • Bug fix: Query data doesn’t appear to save. Unserialize method was sometimes failing when loading a query in the editor.
  • Bug fix: Allow nested limited terms in filters

1.5.40

  • Bug fix: New meta field setting compared too strictly
  • Bug fix: Exposed Taxonomy filter not showing values when unlimited.

1.5.39

  • Bug fix: Pagination
  • Bug fix: Tag & Category override data storage
  • Bug fix: Meta value filter compare field value
  • Bug fix: Taxonomy exposed filter retaining values after submit
  • Feature: Shortcode compatibility for conflicts on the “query” shortcode
  • Feature: Contextual tokens on post_id filter

1.5.38

  • Upkeep: Renaming .inc files to .php
  • Upkeep: Changing source whitespace
  • Bug fix: Better restriction for admin_head hook
  • Feature: new row classes query-row-first, query-row-last

1.5.37

  • PHP updated for WP 4.3

1.5.36

  • Feature: New meta_value field handler as a setting. Autocomplete on the field.

1.5.35

  • Bug fix: missing jQuery ui css
  • Bug fix: not-linked avatar field
  • Bug fix: first field weight
  • Feature: custom classes on fields

1.5.34

  • Feature: “active-item” class on rows whose post is currently being viewed.
  • Feature: Group by field in Row Style > Field Settings (requires saving the query before choosing)

1.5.33

  • Cleaned up a lot of PHP warnings and notices

1.5.32

  • Better Overrides
  • Feature: meta_query filter
  • Feature: Override entire taxonomy
  • Feature: Extended callback field to include text parameters
  • Feature: Callback filter
  • UI bug fixes with rearranging handler items and field tokens
  • UI bug fix regarding canceling and new handler items dialog

1.5.31

  • Feature: Fields can now be hidden if empty
  • Feature: New setting “Show silent meta” allow for custom fields that start with underscores.
  • Feature: post_id filter can now use a callback to provide an array of post ids
  • Feature: New sort “meta_value” – for sorting strings
  • Feature: New sort “Meta_value_num” – for sorting numbers
  • Feature: New filter “Search” – for searching
  • Changed get_category_ids() to get_terms()
  • Minor UI improvements

1.5.30

  • Feature: post content and post excerpt fields have new option to apply the_content filter
  • Feature: new sort option: post__in to sort by order of post__in filter array
  • New shortcode hooks for custom attributes and query options
  • Bug fix: is_array check for missing override value
  • Bug fix: category__not_in needs term ids as array

1.5.26

  • Bug fix: Admin UI fix on WP 4.1

1.5.25

  • Bug fix: qw_pre_query & qw_pre_render hooks
  • Bug fix: Plugin activation warnings
  • Bug fix: Import textarea CSS
  • Bug fix: Live Preview error on new query
  • Feature: Show Display Title on widget with or without theme compatibility
  • Feature: Arguments field on widgets

1.5.24

  • New: Callback field – Use any function to provide a field value.
  • New: Shortcode argument contextual tokens. eg, [query id=1 args=”author={{post:post_author}}&post_type={{post:post_type}}”] – returns the query showing only posts by the author of the current page being viewed, and of the post type of the current post_type being viewed.
  • Fix: index on query_override_terms table

1.5.23

  • New: Shortcode arguments. eg, [query id=1 args=”posts_per_page=1&post_type=page”]
  • New: Support for “Advanced Custom Fields” fields as settings for meta_values
  • New: Support for “Custom Content Type Manager” fields as settings for meta_values

1.5rc22

  • Bug fix: Empty request_uri causing issues.

1.5rc21

  • New: Field – Featured Image
  • New: Exposed filter – Post IDs
  • New: Exposed filter – Post Parent
  • New: Exposed filter – Post Types
  • New: Exposed filter – Taxonomies
  • New: Setting – Live Preview default
  • Fix: Image field style setting

1.5rc20

  • Updating template wrangler to use apply_filters instead of do_action_ref_array

1.5rc19

  • Feature: New author filter

1.5rc18

  • Fix: Pagination bug when using Page numbers.

1.5rc17

  • Fix: post_parent filter

1.5rc16

  • Feature: New taxonomies filter
  • Feature: Featured Image setting for “Image Attachment” field
  • Fix: Making js better
  • Fix: New handler item weight bug
  • Fix: New field tokens bug
  • Remove: tabs editor
  • Refactoring a lot

1.5rc15

  • Compatibility issues with Widget Wrangler
  • Feature: Template suggestions in preview.

1.5rc14

  • Fix: Child theme page templating
  • Fix: Comment disabling works on pages with shortcodes
  • Feature/Fix: Theme compatibility for widgets – enable in QW settings.

1.5rc13

  • Fix: Shortcode & Widget paging – but can’t have 2 independent pagers on 1 page yet.
  • Fix: Unserialize bug – https://wordpress.org/support/topic/bug-that-wipes-all-settings-of-query-after-excluding-fields-from-display?replies=2
  • Fix: 3.7 problem – according to – https://wordpress.org/support/topic/update-has-broken-site#post-4868397
  • Fix: Row style settings form bug
  • More complete default query according to WP_Query defaults
  • Feature: PHP WP_Query in preview

1.5rc12

  • New page routing with hook parse_request

1.5rc11

  • Chasing WP 3.7 related bugs

1.5rc10

  • UI fixes and improvements.

1.5rc9

  • Fix: WordPress 3.7 update redirecting from custom pages

1.5rc8

  • Fix: Fixing sortable jquery ui issue. QW UI working w/ WP 3.5

1.5rc7

  • Fix: No longer relying on external jquery sources, working to fix views ui

1.5rc6

  • Fix: WP update broke jquery and jquery ui. now relying on external sources

1.5rc5

  • Fix: bug, javascript sometimes enqueuing in wrong order (Google Libraries)

1.5rc4

  • Fix: bug, custom label and rewrite output fields not showing up.

1.5rc3

  • Fix: bug in looking for a query page’s path

1.5rc2

  • Fix: meta field returning array
  • Fix: page links missing starting slash

1.5rc1

  • Major API enhancements
  • New simpler editor theme
  • Lots of Refactoring

1.4.1beta

  • Template preprocess fix

1.4beta

  • Fixed override pagination
  • UI Improvements
  • Template hierarchy solidification
  • Live Preview
  • Meta Key / Value Filters
  • Filter Api

1.3.2beta

  • Fixed template-wrangler comments bug
  • Fixed display style bug
  • Refactored javascript some

1.3beta1

  • Added WordPress hooks for fields, field styles, filters, and pagers
  • Fixed some bugs with replacement tokens and rewriting output
  • Fixed some templates from displaying excluded fields
  • Determined methodology for field callbacks and arguments
  • Shortcode support for fields

1.2beta3

  • Bug fix for empty category and tag pages
  • Bug fix for query shortcodes

1.2beta2

  • Added shortcode support

1.2beta1

  • Added WordPress page overrides for categories and tags.
  • Fixed query edit page js bug.

1.1beta

  • Bug with canceling forms. Changed use of jQuery unserializeForm

1.0beta

  • Initial Release