Create a gist now

Instantly share code, notes, and snippets.

Embed
WP: Query $args
// This gist is now maintained on github at https://github.com/luetkemj/wp-query-ref
<?php
/**
* WordPress Query Comprehensive Reference
* Compiled by luetkemj - luetkemj.github.io
*
* CODEX: http://codex.wordpress.org/Class_Reference/WP_Query#Parameters
* Source: https://core.trac.wordpress.org/browser/tags/4.9.4/src/wp-includes/query.php
*/
$args = array(
// Author Parameters - Show posts associated with certain author.
// http://codex.wordpress.org/Class_Reference/WP_Query#Author_Parameters
'author' => '1,2,3,', // (int | string) - use author id or comma-separated list of IDs [use minus (-) to exclude authors by ID ex. 'author' => '-1,-2,-3,']
'author_name' => 'luetkemj', // (string) - use 'user_nicename' (NOT name)
'author__in' => array( 2, 6 ), // (array) - use author id (available with Version 3.7).
'author__not_in' => array( 2, 6 ), // (array)' - use author id (available with Version 3.7).
// Category Parameters - Show posts associated with certain categories.
// http://codex.wordpress.org/Class_Reference/WP_Query#Category_Parameters
'cat' => 5, // (int) - Display posts that have this category (and any children of that category), using category id.
'cat' => '-12,-34,-56' // Display all posts except those from a category by prefixing its id with a '-' (minus) sign.
'category_name' => 'staff, news', // (string) - Display posts that have these categories (and any children of that category), using category slug.
'category_name' => 'staff+news', // (string) - Display posts that have "all" of these categories, using category slug.
'category__and' => array( 2, 6 ), // (array) - Display posts that are in multiple categories. This shows posts that are in both categories 2 and 6.
'category__in' => array( 2, 6 ), // (array) - Display posts that have this category (not children of that category), using category id.
'category__not_in' => array( 2, 6 ), // (array) - Display posts that DO NOT HAVE these categories (not children of that category), using category id.
// Tag Parameters - Show posts associated with certain tags.
// http://codex.wordpress.org/Class_Reference/WP_Query#Tag_Parameters
'tag' => 'cooking', // (string) - use tag slug.
'tag_id' => 5, // (int) - use tag id.
'tag__and' => array( 2, 6), // (array) - use tag ids.
'tag__in' => array( 2, 6), // (array) - use tag ids.
'tag__not_in' => array( 2, 6), // (array) - use tag ids.
'tag_slug__and' => array( 'red', 'blue'), // (array) - use tag slugs.
'tag_slug__in' => array( 'red', 'blue'), // (array) - use tag slugs.
// Taxonomy Parameters - Show posts associated with certain taxonomy.
// http://codex.wordpress.org/Class_Reference/WP_Query#Taxonomy_Parameters
// Important Note: tax_query takes an array of tax query arguments arrays (it takes an array of arrays)
// This construct allows you to query multiple taxonomies by using the relation parameter in the first (outer) array to describe the boolean relationship between the taxonomy queries.
'tax_query' => array( // (array) - use taxonomy parameters (available with Version 3.1).
'relation' => 'AND', // (string) - The logical relationship between each inner taxonomy array when there is more than one. Possible values are 'AND', 'OR'. Do not use with a single inner taxonomy array. Default value is 'AND'.
array(
'taxonomy' => 'color', // (string) - Taxonomy.
'field' => 'slug', // (string) - Select taxonomy term by Possible values are 'term_id', 'name', 'slug' or 'term_taxonomy_id'. Default value is 'term_id'.
'terms' => array( 'red', 'blue' ), // (int/string/array) - Taxonomy term(s).
'include_children' => true, // (bool) - Whether or not to include children for hierarchical taxonomies. Defaults to true.
'operator' => 'IN' // (string) - Operator to test. Possible values are 'IN', 'NOT IN', 'AND', 'EXISTS' and 'NOT EXISTS'. Default value is 'IN'.
),
array(
'taxonomy' => 'actor',
'field' => 'id',
'terms' => array( 103, 115, 206 ),
'include_children' => false,
'operator' => 'NOT IN'
)
),
// Post & Page Parameters - Display content based on post and page parameters.
// http://codex.wordpress.org/Class_Reference/WP_Query#Post_.26_Page_Parameters
'p' => 1, // (int) - use post id.
'name' => 'hello-world', // (string) - use post slug.
'title' => 'Hello World' // (string) - use post title (available with Version 4.4)
'page_id' => 1, // (int) - use page id.
'pagename' => 'sample-page', // (string) - use page slug.
'pagename' => 'contact_us/canada', // (string) - Display child page using the slug of the parent and the child page, separated ba slash
'post_name__in' => 'sample-post' (array) // - use post slugs. Specify posts to retrieve. (available since Version 4.4)
'post_parent' => 1, // (int) - use page id. Return just the child Pages. (Only works with heirachical post types.)
'post_parent__in' => array(1,2,3) // (array) - use post ids. Specify posts whose parent is in an array. NOTE: Introduced in 3.6
'post_parent__not_in' => array(1,2,3), // (array) - use post ids. Specify posts whose parent is not in an array.
'post__in' => array(1,2,3), // (array) - use post ids. Specify posts to retrieve. ATTENTION If you use sticky posts, they will be included (prepended!) in the posts you retrieve whether you want it or not. To suppress this behaviour use ignore_sticky_posts
'post__not_in' => array(1,2,3), // (array) - use post ids. Specify post NOT to retrieve.
// NOTE: you cannot combine 'post__in' and 'post__not_in' in the same query
// Password Parameters - Show content based on post and page parameters. Remember that default post_type is only set to display posts but not pages.
// http://codex.wordpress.org/Class_Reference/WP_Query#Password_Parameters
'has_password' => true, // (bool) - available with Version 3.9
// true for posts with passwords;
// false for posts without passwords;
// null for all posts with and without passwords
'post_password' => 'multi-pass', // (string) - show posts with a particular password (available with Version 3.9)
// Post Type Parameters - Show posts associated with certain type or status.
// http://codex.wordpress.org/Class_Reference/WP_Query#Type_Parameters
'post_type' => array( // (string / array) - use post types. Retrieves posts by Post Types, default value is 'post';
'post', // - a post.
'page', // - a page.
'revision', // - a revision.
'attachment', // - an attachment. The default WP_Query sets 'post_status'=>'published', but atchments default to 'post_status'=>'inherit' so you'll need to set the status to 'inherit' or 'any'.
'nav_menu_item' // - a navigation menu item
'my-custom-post-type', // - Custom Post Types (e.g. movies)
),
// NOTE: The 'any' keyword available to both post_type and post_status queries cannot be used within an array.
'post_type' => 'any', // - retrieves any type except revisions and types with 'exclude_from_search' set to true.
// Post Status Parameters - Show posts associated with certain type or status.
// http://codex.wordpress.org/Class_Reference/WP_Query#Status_Parameters
'post_status' => array( // (string | array) - use post status. Retrieves posts by Post Status, default value i'publish'.
'publish', // - a published post or page.
'pending', // - post is pending review.
'draft', // - a post in draft status.
'auto-draft', // - a newly created post, with no content.
'future', // - a post to publish in the future.
'private', // - not visible to users who are not logged in.
'inherit', // - a revision. see get_children.
'trash', // - post is in trashbin (available with Version 2.9).
),
// NOTE: The 'any' keyword available to both post_type and post_status queries cannot be used within an array.
'post_status' => 'any', // - retrieves any status except those from post types with 'exclude_from_search' set to true.
// Comment Paremters - @since Version 4.9 Introduced the `$comment_count` parameter.
// https://codex.wordpress.org/Class_Reference/WP_Query#Comment_Parameters
'comment_count' => 10 // (int | array) The amount of comments your CPT has to have ( Search operator will do a '=' operation )
'comment_count' => array(
'value' => 10 // (int) - The amount of comments your CPT has to have when comparing
'compare' => '=' // (string) - The search operator. Possible values are '=', '!=', '>', '>=', '<', '<='. Default value is '='.
)
// Pagination Parameters
//http://codex.wordpress.org/Class_Reference/WP_Query#Pagination_Parameters
'posts_per_page' => 10, // (int) - number of post to show per page (available with Version 2.1). Use 'posts_per_page' => -1 to show all posts.
// Note: if the query is in a feed, wordpress overwrites this parameter with the stored 'posts_per_rss' option. Treimpose the limit, try using the 'post_limits' filter, or filter 'pre_option_posts_per_rss' and return -1
'nopaging' => false, // (bool) - show all posts or use pagination. Default value is 'false', use paging.
'paged' => get_query_var('paged'), // (int) - number of page. Show the posts that would normally show up just on page X when usinthe "Older Entries" link.
// NOTE: Use get_query_var('page'); if you want your query to work in a Page template that you've set as your static front page. The query variable 'page' holds the pagenumber for a single paginated Post or Page that includes the <!--nextpage--> Quicktag in the post content.
'nopaging' => false, // (boolean) - show all posts or use pagination. Default value is 'false', use paging.
'posts_per_archive_page' => 10, // (int) - number of posts to show per page - on archive pages only. Over-rides posts_per_page and showposts on pages where is_archive() or is_search() would be true.
'offset' => 3, // (int) - number of post to displace or pass over.
// Warning: Setting the offset parameter overrides/ignores the paged parameter and breaks pagination. for a workaround see: http://codex.wordpress.org/Making_Custom_Queries_using_Offset_and_Pagination
// The 'offset' parameter is ignored when 'posts_per_page'=>-1 (show all posts) is used.
'paged' => get_query_var('paged'), // (int) - number of page. Show the posts that would normally show up just on page X when usinthe "Older Entries" link.
// NOTE: This whole paging thing gets tricky. Some links to help you out:
// http://codex.wordpress.org/Function_Reference/next_posts_link#Usage_when_querying_the_loop_with_WP_Query
// http://codex.wordpress.org/Pagination#Troubleshooting_Broken_Pagination
'page' => get_query_var('page'), // (int) - number of page for a static front page. Show the posts that would normally show up just on page X of a Static Front Page.
// NOTE: The query variable 'page' holds the pagenumber for a single paginated Post or Page that includes the <!--nextpage--> Quicktag in the post content.
'ignore_sticky_posts' => false, // (boolean) - ignore sticky posts or not (available with Version 3.1, replaced caller_get_posts parameter). Default value is 0 - don't ignore sticky posts. Note: ignore/exclude sticky posts being included at the beginning of posts returned, but the sticky post will still be returned in the natural order of that list of posts returned.
// Order & Orderby Parameters - Sort retrieved posts.
// http://codex.wordpress.org/Class_Reference/WP_Query#Order_.26_Orderby_Parameters
'order' => 'DESC', // (string) - Designates the ascending or descending order of the 'orderby' parameter. Default to 'DESC'.
//Possible Values:
//'ASC' - ascending order from lowest to highest values (1, 2, 3; a, b, c).
//'DESC' - descending order from highest to lowest values (3, 2, 1; c, b, a).
'orderby' => 'date', // (string) - Sort retrieved posts by parameter. Defaults to 'date'. One or more options can be passed. EX: 'orderby' => 'menu_order title'
//Possible Values:
// 'none' - No order (available since Version 2.8).
// 'ID' - Order by post id. Note the capitalization.
// 'author' - Order by author. ('post_author' is also accepted.)
// 'title' - Order by title. ('post_title' is also accepted.)
// 'name' - Order by post name (post slug). ('post_name' is also accepted.)
// 'type' - Order by post type (available since Version 4.0). ('post_type' is also accepted.)
// 'date' - Order by date. ('post_date' is also accepted.)
// 'modified' - Order by last modified date. ('post_modified' is also accepted.)
// 'parent' - Order by post/page parent id. ('post_parent' is also accepted.)
// 'rand' - Random order. You can also use 'RAND(x)' where 'x' is an integer seed value.
// 'comment_count' - Order by number of comments (available since Version 2.9).
// 'relevance' - Order by search terms in the following order: First, whether the entire sentence is matched. Second, if all the search terms are within the titles. Third, if any of the search terms appear in the titles. And, fourth, if the full sentence appears in the contents.
// 'menu_order' - Order by Page Order. Used most often for Pages (Order field in the Edit Page Attributes box) and for Attachments (the integer fields in the Insert / Upload Media Gallery dialog), but could be used for any post type with distinct 'menu_order' values (they all default to 0).
// 'meta_value' - Note that a 'meta_key=keyname' must also be present in the query. Note also that the sorting will be alphabetical which is fine for strings (i.e. words), but can be unexpected for numbers (e.g. 1, 3, 34, 4, 56, 6, etc, rather than 1, 3, 4, 6, 34, 56 as you might naturally expect). Use 'meta_value_num' instead for numeric values.
// 'meta_type' if you want to cast the meta value as a specific type. Possible values are 'NUMERIC', 'BINARY', 'CHAR', 'DATE', 'DATETIME', 'DECIMAL', 'SIGNED', 'TIME', 'UNSIGNED', same as in '$meta_query'. When using 'meta_type' you can also use 'meta_value_*' accordingly. For example, when using DATETIME as 'meta_type' you can use 'meta_value_datetime' to define order structure.
// 'meta_value_num' - Order by numeric meta value (available since Version 2.8). Also note that a 'meta_key=keyname' must also be present in the query. This value allows for numerical sorting as noted above in 'meta_value'.
// 'post__in' - Preserve post ID order given in the 'post__in' array (available since Version 3.5). Note - the value of the order parameter does not change the resulting sort order.
// 'post_name__in' - Preserve post slug order given in the 'post_name__in' array (available since Version 4.6). Note - the value of the order parameter does not change the resulting sort order.
// 'post_parent__in' - Preserve post parent order given in the 'post_parent__in' array (available since Version 4.6). Note - the value of the order parameter does not change the resulting sort order.
// Date Parameters - Show posts associated with a certain time and date period.
// http://codex.wordpress.org/Class_Reference/WP_Query#Date_Parameters
'year' => 2014, // (int) - 4 digit year (e.g. 2011).
'monthnum' => 4, // (int) - Month number (from 1 to 12).
'w' => 25, // (int) - Week of the year (from 0 to 53). Uses the MySQL WEEK command. The mode is dependenon the "start_of_week" option.
'day' => 17, // (int) - Day of the month (from 1 to 31).
'hour' => 13, // (int) - Hour (from 0 to 23).
'minute' => 19, // (int) - Minute (from 0 to 60).
'second' => 30, // (int) - Second (0 to 60).
'm' => 201404, // (int) - YearMonth (For e.g.: 201307).
'date_query' => array( // (array) - Date parameters (available with Version 3.7).
// these are super powerful. check out the codex for more comprehensive code examples http://codex.wordpress.org/Class_Reference/WP_Query#Date_Parameters
array(
'year' => 2014, // (int) - 4 digit year (e.g. 2011).
'month' => 4, // (int) - Month number (from 1 to 12).
'week' => 31, // (int) - Week of the year (from 0 to 53).
'day' => 5, // (int) - Day of the month (from 1 to 31).
'hour' => 2, // (int) - Hour (from 0 to 23).
'minute' => 3, // (int) - Minute (from 0 to 59).
'second' => 36, // (int) - Second (0 to 59).
'after' => 'January 1st, 2013', // (string/array) - Date to retrieve posts after. Accepts strtotime()-compatible string, or array of 'year', 'month', 'day'
'before' => array( // (string/array) - Date to retrieve posts after. Accepts strtotime()-compatible string, or array of 'year', 'month', 'day'
'year' => 2013, // (string) Accepts any four-digit year. Default is empty.
'month' => 2, // (string) The month of the year. Accepts numbers 1-12. Default: 12.
'day' => 28, // (string) The day of the month. Accepts numbers 1-31. Default: last day of month.
),
'inclusive' => true, // (boolean) - For after/before, whether exact value should be matched or not'.
'compare' => '=', // (string) - Possible values are '=', '!=', '>', '>=', '<', '<=', 'LIKE', 'NOT LIKE', 'IN', 'NOT IN', 'BETWEEN', 'NOT BETWEEN', 'EXISTS' (only in WP >= 3.5), and 'NOT EXISTS' (also only in WP >= 3.5). Default value is '='
'column' => 'post_date', // (string) - Column to query against. Default: 'post_date'.
'relation' => 'AND', // (string) - OR or AND, how the sub-arrays should be compared. Default: AND.
),
),
// Custom Field Parameters - Show posts associated with a certain custom field.
// http://codex.wordpress.org/Class_Reference/WP_Query#Custom_Field_Parameters
'meta_key' => 'key', // (string) - Custom field key.
'meta_value' => 'value', // (string) - Custom field value.
'meta_value_num' => 10, // (number) - Custom field value.
'meta_compare' => '=', // (string) - Operator to test the 'meta_value'. Possible values are '=', '!=', '>', '>=', '<', '<=', 'LIKE', 'NOT LIKE', 'IN', 'NOT IN', 'BETWEEN', 'NOT BETWEEN', 'NOT EXISTS', 'REGEXP', 'NOT REGEXP' or 'RLIKE'. Default value is '='.
'meta_query' => array( // (array) - Custom field parameters (available with Version 3.1).
'relation' => 'AND', // (string) - Possible values are 'AND', 'OR'. The logical relationship between each inner meta_query array when there is more than one. Do not use with a single inner meta_query array.
array(
'key' => 'color', // (string) - Custom field key.
'value' => 'blue', // (string/array) - Custom field value (Note: Array support is limited to a compare value of 'IN', 'NOT IN', 'BETWEEN', or 'NOT BETWEEN') Using WP < 3.9? Check out this page for details: http://codex.wordpress.org/Class_Reference/WP_Query#Custom_Field_Parameters
'type' => 'CHAR', // (string) - Custom field type. Possible values are 'NUMERIC', 'BINARY', 'CHAR', 'DATE', 'DATETIME', 'DECIMAL', 'SIGNED', 'TIME', 'UNSIGNED'. Default value is 'CHAR'. The 'type' DATE works with the 'compare' value BETWEEN only if the date is stored at the format YYYYMMDD and tested with this format.
//NOTE: The 'type' DATE works with the 'compare' value BETWEEN only if the date is stored at the format YYYYMMDD and tested with this format.
'compare' => '=', // (string) - Operator to test. Possible values are '=', '!=', '>', '>=', '<', '<=', 'LIKE', 'NOT LIKE', 'IN', 'NOT IN', 'BETWEEN', 'NOT BETWEEN', 'EXISTS' (only in WP >= 3.5), and 'NOT EXISTS' (also only in WP >= 3.5). Default value is '='.
),
array(
'key' => 'price',
'value' => array( 1,200 ),
'compare' => 'NOT LIKE',
)
),
// Permission Parameters - Display published posts, as well as private posts, if the user has the appropriate capability:
// http://codex.wordpress.org/Class_Reference/WP_Query#Permission_Parameters
'perm' => 'readable', // (string) Possible values are 'readable', 'editable'
// Mime Type Parameters - Used with the attachments post type.
// https://codex.wordpress.org/Class_Reference/WP_Query#Mime_Type_Parameters
'post_mime_type' => 'image/gif', // (string/array) - Allowed mime types.
// Caching Parameters
// http://codex.wordpress.org/Class_Reference/WP_Query#Caching_Parameters
// NOTE Caching is a good thing. Setting these to false is generally not advised.
'cache_results' => true, // (bool) Default is true - Post information cache.
'update_post_term_cache' => true, // (bool) Default is true - Post meta information cache.
'update_post_meta_cache' => true, // (bool) Default is true - Post term information cache.
'no_found_rows' => false, // (bool) Default is false. WordPress uses SQL_CALC_FOUND_ROWS in most queries in order to implement pagination. Even when you don’t need pagination at all. By Setting this parameter to true you are telling wordPress not to count the total rows and reducing load on the DB. Pagination will NOT WORK when this parameter is set to true. For more information see: http://flavio.tordini.org/speed-up-wordpress-get_posts-and-query_posts-functions
// Search Parameter
// http://codex.wordpress.org/Class_Reference/WP_Query#Search_Parameter
's' => $s, // (string) - Passes along the query string variable from a search. For example usage see: http://www.wprecipes.com/how-to-display-the-number-of-results-in-wordpress-search
'exact' => true, // (bool) - flag to make it only match whole titles/posts - Default value is false. For more information see: https://gist.github.com/2023628#gistcomment-285118
'sentence' => true, // (bool) - flag to make it do a phrase search - Default value is false. For more information see: https://gist.github.com/2023628#gistcomment-285118
// Post Field Parameters
// For more info see: http://codex.wordpress.org/Class_Reference/WP_Query#Return_Fields_Parameter
// also https://gist.github.com/luetkemj/2023628/#comment-1003542
'fields' => 'ids', // (string) - Which fields to return. All fields are returned by default.
// Possible values:
// 'ids' - Return an array of post IDs.
// 'id=>parent' - Return an associative array [ parent => ID, … ].
// Passing anything else will return all fields (default) - an array of post objects.
// Filters
// For more information on available Filters see: http://codex.wordpress.org/Class_Reference/WP_Query#Filters
);
$the_query = new WP_Query( $args );
// The Loop
if ( $the_query->have_posts() ) :
while ( $the_query->have_posts() ) : $the_query->the_post();
// Do Stuff
endwhile;
endif;
// Reset Post Data
wp_reset_postdata();
?>
@luetkemj

This comment has been minimized.

Show comment
Hide comment
@luetkemj

luetkemj Mar 12, 2012

This gist is now being maintained in this github repo Help wanted!

Of course you would never use a query like this. It's just a comprehensive grouping for quick reference.
Also formatting in the github and raw view sucks. best to copy the raw and past in a code editor. I wrote this in SublimeText if that helps.
EDIT: Fixed formatting issues

Owner

luetkemj commented Mar 12, 2012

This gist is now being maintained in this github repo Help wanted!

Of course you would never use a query like this. It's just a comprehensive grouping for quick reference.
Also formatting in the github and raw view sucks. best to copy the raw and past in a code editor. I wrote this in SublimeText if that helps.
EDIT: Fixed formatting issues

@ryanduff

This comment has been minimized.

Show comment
Hide comment
@ryanduff

ryanduff Mar 13, 2012

You're missing the undocumented no_found_rows parameter. It takes a boolean value so I usually use true instead of 1 in this example: http://flavio.tordini.org/speed-up-wordpress-get_posts-and-query_posts-functions

You're missing the undocumented no_found_rows parameter. It takes a boolean value so I usually use true instead of 1 in this example: http://flavio.tordini.org/speed-up-wordpress-get_posts-and-query_posts-functions

@luetkemj

This comment has been minimized.

Show comment
Hide comment
@luetkemj

luetkemj Mar 13, 2012

Thanks Ryan, I added no_found_rows into the caching section at the bottom. If you think it belongs somewhere else I'm open to suggestions. Regarding using true/false vs 1/0 for booleans, is that just a preference or is there a best practice or other reason in there to choose one over the other?

Owner

luetkemj commented Mar 13, 2012

Thanks Ryan, I added no_found_rows into the caching section at the bottom. If you think it belongs somewhere else I'm open to suggestions. Regarding using true/false vs 1/0 for booleans, is that just a preference or is there a best practice or other reason in there to choose one over the other?

@ryanduff

This comment has been minimized.

Show comment
Hide comment
@ryanduff

ryanduff Mar 13, 2012

@luetkemj

This comment has been minimized.

Show comment
Hide comment
@luetkemj

luetkemj Mar 13, 2012

Thanks Ryan, good call on writing out the keywords True/False. Makes a lot of sense. Will be updating the code shortly.

Owner

luetkemj commented Mar 13, 2012

Thanks Ryan, good call on writing out the keywords True/False. Makes a lot of sense. Will be updating the code shortly.

@HoundstoothSTL

This comment has been minimized.

Show comment
Hide comment
@HoundstoothSTL

HoundstoothSTL Mar 14, 2012

This is solid, thanks for posting!

This is solid, thanks for posting!

@PotterSys

This comment has been minimized.

Show comment
Hide comment
@PotterSys

PotterSys Mar 15, 2012

It seems a the closing parenthesis for the whole array is missing on the 'tax_query' array

It seems a the closing parenthesis for the whole array is missing on the 'tax_query' array

@luetkemj

This comment has been minimized.

Show comment
Hide comment
@luetkemj

luetkemj Mar 15, 2012

Thanks PotterSys, fixing now.
EDIT: Closed tax query array properly per PotterSys comment ^

Owner

luetkemj commented Mar 15, 2012

Thanks PotterSys, fixing now.
EDIT: Closed tax query array properly per PotterSys comment ^

@Japh

This comment has been minimized.

Show comment
Hide comment
@Japh

Japh Mar 15, 2012

Great reference, thanks! :)

Japh commented Mar 15, 2012

Great reference, thanks! :)

@fjarrett

This comment has been minimized.

Show comment
Hide comment
@fjarrett

fjarrett Mar 16, 2012

Thanks for sharing!

Thanks for sharing!

@rabinbiswas

This comment has been minimized.

Show comment
Hide comment
@rabinbiswas

rabinbiswas Mar 18, 2012

First of all You did a great job compiling this in one file, congrats and thanks for it.
I have posted your work on my site http://updateox.com/wordpress/wp-query-quick-reference-with-all-its-parameters/ with all of your reference of course. I hope you won't mind it.

First of all You did a great job compiling this in one file, congrats and thanks for it.
I have posted your work on my site http://updateox.com/wordpress/wp-query-quick-reference-with-all-its-parameters/ with all of your reference of course. I hope you won't mind it.

@luetkemj

This comment has been minimized.

Show comment
Hide comment
@luetkemj

luetkemj Mar 19, 2012

@rabinbiswas Thanks! Don't mind at all, nice to see others find it useful.

Owner

luetkemj commented Mar 19, 2012

@rabinbiswas Thanks! Don't mind at all, nice to see others find it useful.

@littlefyr

This comment has been minimized.

Show comment
Hide comment
@littlefyr

littlefyr Mar 20, 2012

@luetkemj -- there is nothing better, IMHO, than a pathological example to know what's going on. The next thing would be comprehensive examples, but that would be a whole lot more work.

I did notice small error. Well, its theoretically correct, but probably isn't given what preceeds. In tag_slug__and and tag_slug__in have arrays of ints for their values but I think you want an array of strings.

@luetkemj -- there is nothing better, IMHO, than a pathological example to know what's going on. The next thing would be comprehensive examples, but that would be a whole lot more work.

I did notice small error. Well, its theoretically correct, but probably isn't given what preceeds. In tag_slug__and and tag_slug__in have arrays of ints for their values but I think you want an array of strings.

@luetkemj

This comment has been minimized.

Show comment
Hide comment
@luetkemj

luetkemj Mar 21, 2012

@adsmart, that is def an error, thanks for the catch!

Owner

luetkemj commented Mar 21, 2012

@adsmart, that is def an error, thanks for the catch!

@r-a-y

This comment has been minimized.

Show comment
Hide comment
@r-a-y

r-a-y Mar 27, 2012

Nice! Just wanted to note that you're missing the 's' parameter for searching the post title and content.

r-a-y commented Mar 27, 2012

Nice! Just wanted to note that you're missing the 's' parameter for searching the post title and content.

@ryanduff

This comment has been minimized.

Show comment
Hide comment
@ryanduff

ryanduff Mar 27, 2012

More or less passing along the search from the query string ($s) into the query...

new WP_Query("s=$s&showposts=-1");

More or less passing along the search from the query string ($s) into the query...

new WP_Query("s=$s&showposts=-1");

@luetkemj

This comment has been minimized.

Show comment
Hide comment
@luetkemj

luetkemj Mar 27, 2012

I didn't know about that one! Very interesting, will add it tomorrow.

Owner

luetkemj commented Mar 27, 2012

I didn't know about that one! Very interesting, will add it tomorrow.

@luetkemj

This comment has been minimized.

Show comment
Hide comment
@luetkemj

luetkemj Mar 28, 2012

Added "Search Parameter " section based on r-a-y and ryanduff's suggestions.

Owner

luetkemj commented Mar 28, 2012

Added "Search Parameter " section based on r-a-y and ryanduff's suggestions.

@ihorvorotnov

This comment has been minimized.

Show comment
Hide comment
@ihorvorotnov

ihorvorotnov Apr 1, 2012

Great job, thanks for sharing!

Great job, thanks for sharing!

@eoinkelly

This comment has been minimized.

Show comment
Hide comment
@eoinkelly

eoinkelly Apr 14, 2012

Very handy reference. Good job.

Very handy reference. Good job.

@eoinkelly

This comment has been minimized.

Show comment
Hide comment
@eoinkelly

eoinkelly Apr 16, 2012

I just noticed that WordPress treats the 'any' value for 'post_type' differently to other values. It is treated as a special "keyword" and it cannot be in an array e.g.

$my_query = new WP_Query(array('post_type' => array('post'))); // Works
$my_query = new WP_Query(array('post_type' => array('post','page'))); // Works
$my_query = new WP_Query(array('post_type' => array('any'))); // Does not work
$my_query = new WP_Query(array('post_type' => 'any')); // Works

I think it would be worth updating this gist to reflect that.
cheers
/Eoin/

I just noticed that WordPress treats the 'any' value for 'post_type' differently to other values. It is treated as a special "keyword" and it cannot be in an array e.g.

$my_query = new WP_Query(array('post_type' => array('post'))); // Works
$my_query = new WP_Query(array('post_type' => array('post','page'))); // Works
$my_query = new WP_Query(array('post_type' => array('any'))); // Does not work
$my_query = new WP_Query(array('post_type' => 'any')); // Works

I think it would be worth updating this gist to reflect that.
cheers
/Eoin/

@luetkemj

This comment has been minimized.

Show comment
Hide comment
@luetkemj

luetkemj Apr 16, 2012

@eoinkelly
Very interesting, thanks for the catch, Gist has been updated.

Owner

luetkemj commented Apr 16, 2012

@eoinkelly
Very interesting, thanks for the catch, Gist has been updated.

@andredublin

This comment has been minimized.

Show comment
Hide comment
@andredublin

andredublin Apr 24, 2012

thank you for this

thank you for this

@saas786

This comment has been minimized.

Show comment
Hide comment

saas786 commented Apr 28, 2012

Thanks.

@saas786

This comment has been minimized.

Show comment
Hide comment
@saas786

saas786 Apr 28, 2012

I would like you to add this if you don't mind.
with :]-> 's' => $s
compare is very useful
[{ compare (string) - Operator to test. Possible values are '=', '!=', '>', '>=', '<', '<=', 'LIKE', 'NOT LIKE', 'IN', 'NOT IN', 'BETWEEN', 'NOT BETWEEN'. Default value is '='.}]

And also sentence is very useful if we want users to search for exact words (like "why search for exact words") if we use sentence = true then wordpress will search the whole sentence & depending upon the compare parameter. But if we don't use sentence parameter wordpress will split each word and search for each word in database depending upon the compare.

I hope my comment makes sense to you. I am not good with words though ;)

saas786 commented Apr 28, 2012

I would like you to add this if you don't mind.
with :]-> 's' => $s
compare is very useful
[{ compare (string) - Operator to test. Possible values are '=', '!=', '>', '>=', '<', '<=', 'LIKE', 'NOT LIKE', 'IN', 'NOT IN', 'BETWEEN', 'NOT BETWEEN'. Default value is '='.}]

And also sentence is very useful if we want users to search for exact words (like "why search for exact words") if we use sentence = true then wordpress will search the whole sentence & depending upon the compare parameter. But if we don't use sentence parameter wordpress will split each word and search for each word in database depending upon the compare.

I hope my comment makes sense to you. I am not good with words though ;)

@luetkemj

This comment has been minimized.

Show comment
Hide comment
@luetkemj

luetkemj Apr 28, 2012

@saas786

Thanks for these! Will take a closer look on monday and add them.

Owner

luetkemj commented Apr 28, 2012

@saas786

Thanks for these! Will take a closer look on monday and add them.

@luetkemj

This comment has been minimized.

Show comment
Hide comment
@luetkemj

luetkemj Apr 30, 2012

@saas786

I added the additions you mentioned. Please review and let me know if they are accurate. From some research I found an old post that mentions an "exact" flag as well: http://wordpress.org/support/topic/how-to-search-phrases

I didn't add this as it seems that you could do the same thing with the compare parameters. Have you used "exact" before? Currently I'm leaning towards not including it here.

Owner

luetkemj commented Apr 30, 2012

@saas786

I added the additions you mentioned. Please review and let me know if they are accurate. From some research I found an old post that mentions an "exact" flag as well: http://wordpress.org/support/topic/how-to-search-phrases

I didn't add this as it seems that you could do the same thing with the compare parameters. Have you used "exact" before? Currently I'm leaning towards not including it here.

@saas786

This comment has been minimized.

Show comment
Hide comment
@saas786

saas786 Apr 30, 2012

@luetkemj

Thanks for adding it. Yes "exact" flag / parameter is correct. @otto is an experienced guy, so his comments are valid. I further explored it and found that compare has no impact on search query instead exact is used for comparison.

//////Search Parameter
's' => $s,
'exact' => true // if set to true then search will be like "LIKE 'search_term')" if set to false then it will be like "LIKE '%ssearch_term%s')"
'sentance' => true

you can remove the compare parameter from the list and I found no impact on query (I thought it was the compare parameter that made impact on my search query, but instead it was "exact" flag / parameter.

Thanks.

saas786 commented Apr 30, 2012

@luetkemj

Thanks for adding it. Yes "exact" flag / parameter is correct. @otto is an experienced guy, so his comments are valid. I further explored it and found that compare has no impact on search query instead exact is used for comparison.

//////Search Parameter
's' => $s,
'exact' => true // if set to true then search will be like "LIKE 'search_term')" if set to false then it will be like "LIKE '%ssearch_term%s')"
'sentance' => true

you can remove the compare parameter from the list and I found no impact on query (I thought it was the compare parameter that made impact on my search query, but instead it was "exact" flag / parameter.

Thanks.

@luetkemj

This comment has been minimized.

Show comment
Hide comment
@luetkemj

luetkemj Apr 30, 2012

@saas786

Thanks for checking up on that, I didn't have time this morning to do an actual test. I have used a mix of the verbiage from you, myself, and Otto as well a link to the comments here for more info.

Owner

luetkemj commented Apr 30, 2012

@saas786

Thanks for checking up on that, I didn't have time this morning to do an actual test. I have used a mix of the verbiage from you, myself, and Otto as well a link to the comments here for more info.

@cam5

This comment has been minimized.

Show comment
Hide comment
@cam5

cam5 Jun 27, 2012

You are a good man, luetkemj.

cam5 commented Jun 27, 2012

You are a good man, luetkemj.

@luetkemj

This comment has been minimized.

Show comment
Hide comment
Owner

luetkemj commented Jun 27, 2012

Thanks @cam5 :)

@roborourke

This comment has been minimized.

Show comment
Hide comment

Epic

@charlietriplett

This comment has been minimized.

Show comment
Hide comment
@charlietriplett

charlietriplett Jul 26, 2012

Something I had to do today - Mix/Match Orderby:

Sort a custom post type (people) by last name (by default) or by menu_order (when the posts have a menu order entered).
The title field is always lastnamef, which made me think I could do this:
'orderby' => 'menu_order title',
It doesn't seem to work consistently for my custom post type.

But from this post:
http://wordpress.org/support/topic/order-by-slug-not-work
And from this post:
http://wordpress.stackexchange.com/questions/2969/order-by-menu-order-and-title

I deduced this - which does work:
'orderby' => 'menu_order name',

Might be worth adding.

Something I had to do today - Mix/Match Orderby:

Sort a custom post type (people) by last name (by default) or by menu_order (when the posts have a menu order entered).
The title field is always lastnamef, which made me think I could do this:
'orderby' => 'menu_order title',
It doesn't seem to work consistently for my custom post type.

But from this post:
http://wordpress.org/support/topic/order-by-slug-not-work
And from this post:
http://wordpress.stackexchange.com/questions/2969/order-by-menu-order-and-title

I deduced this - which does work:
'orderby' => 'menu_order name',

Might be worth adding.

@luetkemj

This comment has been minimized.

Show comment
Hide comment
@luetkemj

luetkemj Jul 27, 2012

@charlietriplett, This is really interesting! Do you know if it works to just mix and match any of the orderby options?

This should definitely be added but I want to play around with it first to get a good idea on how to document it.

Thanks!

Owner

luetkemj commented Jul 27, 2012

@charlietriplett, This is really interesting! Do you know if it works to just mix and match any of the orderby options?

This should definitely be added but I want to play around with it first to get a good idea on how to document it.

Thanks!

@charlietriplett

This comment has been minimized.

Show comment
Hide comment
@charlietriplett

charlietriplett Jul 27, 2012

I don't — and I don't understand why 'menu_order title' isn't just as consistent. Hrmm … But a very useful tool for sorting posts/pages. I'll be incorporating it into some automated child-nav features as well where some degree of custom ordering is desirable.

I don't — and I don't understand why 'menu_order title' isn't just as consistent. Hrmm … But a very useful tool for sorting posts/pages. I'll be incorporating it into some automated child-nav features as well where some degree of custom ordering is desirable.

@keesiemeijer

This comment has been minimized.

Show comment
Hide comment
@keesiemeijer

keesiemeijer Sep 17, 2012

//NOTE: You should set get_query_var( 'page' ); if you want your query to work with pagination. Since Wordpress 3.0.2, you dget_query_var( 'page' ) instead of get_query_var( 'paged' ). The pagination parameter 'paged' for WP_Query() remains the same.

This is only true for a paginated single post/page and for static front page pagination. I've updated the codex with this information here:
http://codex.wordpress.org/Function_Reference/WP_Query#Pagination_Parameters

Was the codex wrong or did something change recently?

//NOTE: You should set get_query_var( 'page' ); if you want your query to work with pagination. Since Wordpress 3.0.2, you dget_query_var( 'page' ) instead of get_query_var( 'paged' ). The pagination parameter 'paged' for WP_Query() remains the same.

This is only true for a paginated single post/page and for static front page pagination. I've updated the codex with this information here:
http://codex.wordpress.org/Function_Reference/WP_Query#Pagination_Parameters

Was the codex wrong or did something change recently?

@luetkemj

This comment has been minimized.

Show comment
Hide comment
@luetkemj

luetkemj Sep 17, 2012

Thanks @keesiemeijer, I've actually been having issues pagination myself lately so this may be the problem. Gist has been updated.

Owner

luetkemj commented Sep 17, 2012

Thanks @keesiemeijer, I've actually been having issues pagination myself lately so this may be the problem. Gist has been updated.

@subharanjanm

This comment has been minimized.

Show comment
Hide comment
@subharanjanm

subharanjanm Oct 3, 2012

Is there any way to sort by meta_key where the meta_value contains date string in the format mm-dd-yyyy.

Is there any way to sort by meta_key where the meta_value contains date string in the format mm-dd-yyyy.

@wpsmith

This comment has been minimized.

Show comment
Hide comment
@wpsmith

wpsmith Dec 6, 2012

@luetkemj 'author' => 1,2,3, should be 'author' => '1,2,3',

wpsmith commented Dec 6, 2012

@luetkemj 'author' => 1,2,3, should be 'author' => '1,2,3',

@wpsmith

This comment has been minimized.

Show comment
Hide comment
@wpsmith

wpsmith Dec 11, 2012

'orderby' can now take 'post__in'.

wpsmith commented Dec 11, 2012

'orderby' can now take 'post__in'.

@Krucamper

This comment has been minimized.

Show comment
Hide comment
@Krucamper

Krucamper Dec 19, 2012

Thank you very much for all your help and useful

Thank you very much for all your help and useful

@ghost

This comment has been minimized.

Show comment
Hide comment
@ghost

ghost Feb 19, 2013

great post ;)

ghost commented Feb 19, 2013

great post ;)

@mi-ca

This comment has been minimized.

Show comment
Hide comment
@mi-ca

mi-ca Mar 6, 2013

You make my day.
And not only this one..
This gist is very helpful.

Thanks a lot @luetkemj

mi-ca commented Mar 6, 2013

You make my day.
And not only this one..
This gist is very helpful.

Thanks a lot @luetkemj

@stvwlf

This comment has been minimized.

Show comment
Hide comment
@stvwlf

stvwlf Mar 9, 2013

Just used 'post_parent' for the first time, to return child pages. It turns out you must also set 'post_type" => 'page' before it works. That is not well documented. It would be helpful to add that to the 'post_parent' comments.

stvwlf commented Mar 9, 2013

Just used 'post_parent' for the first time, to return child pages. It turns out you must also set 'post_type" => 'page' before it works. That is not well documented. It would be helpful to add that to the 'post_parent' comments.

@seamusO

This comment has been minimized.

Show comment
Hide comment
@seamusO

seamusO Mar 16, 2013

Is there a typo on line 168 - should "sentance" be "sentence"?
Thanks for the guide - it's exactly what I've being looking for.

seamusO commented Mar 16, 2013

Is there a typo on line 168 - should "sentance" be "sentence"?
Thanks for the guide - it's exactly what I've being looking for.

@luetkemj

This comment has been minimized.

Show comment
Hide comment
@luetkemj

luetkemj Mar 21, 2013

Gist updated.

Thanks to @charlietriplett, @wpsmith, and @stvwlf for keeping an eye on this thing.

If anyone notices anything I've missed or things that have been added since 3.5 let me know so I can keep this up to date!

Owner

luetkemj commented Mar 21, 2013

Gist updated.

Thanks to @charlietriplett, @wpsmith, and @stvwlf for keeping an eye on this thing.

If anyone notices anything I've missed or things that have been added since 3.5 let me know so I can keep this up to date!

@philipdowner

This comment has been minimized.

Show comment
Hide comment
@philipdowner

philipdowner Jul 26, 2013

Perhaps I'm overlooking it, but the meta_query array accepts a 'relation' key which can have a value of either 'AND' or 'OR'.

Perhaps I'm overlooking it, but the meta_query array accepts a 'relation' key which can have a value of either 'AND' or 'OR'.

@abhjiitpingale

This comment has been minimized.

Show comment
Hide comment
@abhjiitpingale

abhjiitpingale Nov 1, 2013

I want make relation between post query and meta query "OR". like post_type = "post" OR (meta_key = "key" AND meta_value = "value") so how can I do that please help me out

I want make relation between post query and meta query "OR". like post_type = "post" OR (meta_key = "key" AND meta_value = "value") so how can I do that please help me out

@michael-cannon

This comment has been minimized.

Show comment
Hide comment
@michael-cannon

michael-cannon Nov 19, 2013

@manifestcreative You're correct. In class WP_Meta_Query::__construct, a check for $meta_query['relation'] is made. AND is the default if none is set. The options are AND and OR.

@manifestcreative You're correct. In class WP_Meta_Query::__construct, a check for $meta_query['relation'] is made. AND is the default if none is set. The options are AND and OR.

@AkaHappyRoadGirl

This comment has been minimized.

Show comment
Hide comment
@AkaHappyRoadGirl

AkaHappyRoadGirl Dec 23, 2013

@luetkemj, I must say I'm your number one fan, this page is one of my most consulted. Thanks a lot!!!

@luetkemj, I must say I'm your number one fan, this page is one of my most consulted. Thanks a lot!!!

@Dimasmagadan

This comment has been minimized.

Show comment
Hide comment
@Dimasmagadan

Dimasmagadan Feb 11, 2014

this link (line 173)
//Not sure what these do. For more info see: http://codex.wordpress.org/Class_Reference/WP_Query#Post_Field_Parameters

should be changed to this
http://codex.wordpress.org/Class_Reference/WP_Query#Return_Fields_Parameter

What it does is it changes the format of returned result. Say, you can pass 'fields' => 'ids' and it will return just IDs of matching posts.

this link (line 173)
//Not sure what these do. For more info see: http://codex.wordpress.org/Class_Reference/WP_Query#Post_Field_Parameters

should be changed to this
http://codex.wordpress.org/Class_Reference/WP_Query#Return_Fields_Parameter

What it does is it changes the format of returned result. Say, you can pass 'fields' => 'ids' and it will return just IDs of matching posts.

@luetkemj

This comment has been minimized.

Show comment
Hide comment
@luetkemj

luetkemj Apr 16, 2014

Bunch of updates per @manifestcreative and @Dimasmagadan comments. Thanks!

Owner

luetkemj commented Apr 16, 2014

Bunch of updates per @manifestcreative and @Dimasmagadan comments. Thanks!

@luetkemj

This comment has been minimized.

Show comment
Hide comment
@luetkemj

luetkemj Apr 16, 2014

Tons of new updates. Bringing the query up to date with things added in 3.5, 3.7, and 3.9.

Holy wow, I was slacking... sorry about that.

Owner

luetkemj commented Apr 16, 2014

Tons of new updates. Bringing the query up to date with things added in 3.5, 3.7, and 3.9.

Holy wow, I was slacking... sorry about that.

@sephelps

This comment has been minimized.

Show comment
Hide comment
@sephelps

sephelps May 9, 2014

the line 'category_name' => 'staff', 'news', is invalid. Should just be one of those or an array, right?

sephelps commented May 9, 2014

the line 'category_name' => 'staff', 'news', is invalid. Should just be one of those or an array, right?

@luetkemj

This comment has been minimized.

Show comment
Hide comment
@luetkemj

luetkemj Jun 17, 2014

@sephelps - yep! that was busted. But it is supposed to be a string. You can display posts that have any of the named categories if you wrap the whole thing in a string, commas and all.

Alternately you can display posts that have "all" of the categories if you use a "+" instead of a ","

'staff,news' or 'staff+news',

Gist has been updated.
See this page for more details on the above:
http://codex.wordpress.org/Class_Reference/WP_Query#Category_Parameters

Owner

luetkemj commented Jun 17, 2014

@sephelps - yep! that was busted. But it is supposed to be a string. You can display posts that have any of the named categories if you wrap the whole thing in a string, commas and all.

Alternately you can display posts that have "all" of the categories if you use a "+" instead of a ","

'staff,news' or 'staff+news',

Gist has been updated.
See this page for more details on the above:
http://codex.wordpress.org/Class_Reference/WP_Query#Category_Parameters

@shokry055

This comment has been minimized.

Show comment
Hide comment
@shokry055

shokry055 Nov 22, 2014

thanks so much

thanks so much

@dgamboaestrada

This comment has been minimized.

Show comment
Hide comment
@dgamboaestrada

dgamboaestrada Jun 2, 2015

Thank you very much

Thank you very much

@JamesVanWaza

This comment has been minimized.

Show comment
Hide comment
@JamesVanWaza

JamesVanWaza Jun 11, 2015

Please add a comma at the end of line 14,

Please add a comma at the end of line 14,

@luetkemj

This comment has been minimized.

Show comment
Hide comment
@luetkemj

luetkemj Jun 12, 2015

@jgacuca567 - done - thanks for the catch

Owner

luetkemj commented Jun 12, 2015

@jgacuca567 - done - thanks for the catch

@brubrant

This comment has been minimized.

Show comment
Hide comment
@brubrant

brubrant Jul 20, 2015

@luetkemj thanks for this awesome Gist. I come here very often!

Just want to say that some pagination parameters are repeated...

@luetkemj thanks for this awesome Gist. I come here very often!

Just want to say that some pagination parameters are repeated...

@pageii

This comment has been minimized.

Show comment
Hide comment
@pageii

pageii Oct 14, 2015

@luetkemj Just want to say thanks for posting. It's very comprehensive and saved me tons.

pageii commented Oct 14, 2015

@luetkemj Just want to say thanks for posting. It's very comprehensive and saved me tons.

@s3rgiosan

This comment has been minimized.

Show comment
Hide comment
@s3rgiosan

s3rgiosan Oct 16, 2015

Hi @luetkemj, first of all thanks for this comprehensive list.

Param posts_per_page is duplicated and the first reference has a typo.
It should be Use 'posts_per_page'=-1 to show all posts..
The second reference is correct.

Hi @luetkemj, first of all thanks for this comprehensive list.

Param posts_per_page is duplicated and the first reference has a typo.
It should be Use 'posts_per_page'=-1 to show all posts..
The second reference is correct.

@luetkemj

This comment has been minimized.

Show comment
Hide comment
@luetkemj

luetkemj Nov 16, 2015

Thanks for the catch @brubrant and @s3rgiosan!

Owner

luetkemj commented Nov 16, 2015

Thanks for the catch @brubrant and @s3rgiosan!

@esemlabel

This comment has been minimized.

Show comment
Hide comment
@esemlabel

esemlabel Mar 17, 2016

Where is 'post_mime_type' filter?

Where is 'post_mime_type' filter?

@luetkemj

This comment has been minimized.

Show comment
Hide comment
@luetkemj

luetkemj May 9, 2016

I am no longer maintaining this gist. Anyone out there who wants to take this on let me know.

EDIT: This gist is now being maintained in this github repo Help wanted!

Owner

luetkemj commented May 9, 2016

I am no longer maintaining this gist. Anyone out there who wants to take this on let me know.

EDIT: This gist is now being maintained in this github repo Help wanted!

@khoipro

This comment has been minimized.

Show comment
Hide comment
@khoipro

khoipro Aug 16, 2016

Featured this gist on https://www.facebook.com/codemienphi/
@luetkemj Let me help you maintaince this gist. I really think it's helpful!

khoipro commented Aug 16, 2016

Featured this gist on https://www.facebook.com/codemienphi/
@luetkemj Let me help you maintaince this gist. I really think it's helpful!

@carminecappetti

This comment has been minimized.

Show comment
Hide comment
@carminecappetti

carminecappetti Jan 26, 2017

Hi all.

I've a question to you.

I use 'sentence' => true in my query_posts().

If I search for "paolo rossi" I get some results;
if I search for "prof. paolo rossi" I get some results;
if I search for "prof paolo rossi" I get NO results;
if I search for "rossi paolo" I get No results;

I need to use "Sentence" clausole because I don't want to show useless posts containing only "Rossi" (for example).

So, how to deal with it?
Is there a way to search ignoring punctuation or words order?

Hi all.

I've a question to you.

I use 'sentence' => true in my query_posts().

If I search for "paolo rossi" I get some results;
if I search for "prof. paolo rossi" I get some results;
if I search for "prof paolo rossi" I get NO results;
if I search for "rossi paolo" I get No results;

I need to use "Sentence" clausole because I don't want to show useless posts containing only "Rossi" (for example).

So, how to deal with it?
Is there a way to search ignoring punctuation or words order?

@Ryan4021

This comment has been minimized.

Show comment
Hide comment
@Ryan4021

Ryan4021 Feb 4, 2017

In the 'meta_query' section it shows:

'value' => 'blue' //(string/array) - Custom field value (Note: Array support is limited to a compare value of 'IN', 'NOT IN', 'BETWEEN', or 'NOT BETWEEN') Using WP < 3.9? Check out this page for details:

It should have a comma after 'blue' since it's not the last in the array item in the meta_query array.

See below for correction:

'value' => 'blue', //(string/array) - Custom field value (Note: Array support is limited to a compare value of 'IN', 'NOT IN', 'BETWEEN', or 'NOT BETWEEN') Using WP < 3.9? Check out this page for details:

Ryan4021 commented Feb 4, 2017

In the 'meta_query' section it shows:

'value' => 'blue' //(string/array) - Custom field value (Note: Array support is limited to a compare value of 'IN', 'NOT IN', 'BETWEEN', or 'NOT BETWEEN') Using WP < 3.9? Check out this page for details:

It should have a comma after 'blue' since it's not the last in the array item in the meta_query array.

See below for correction:

'value' => 'blue', //(string/array) - Custom field value (Note: Array support is limited to a compare value of 'IN', 'NOT IN', 'BETWEEN', or 'NOT BETWEEN') Using WP < 3.9? Check out this page for details:

@SalvaCrea

This comment has been minimized.

Show comment
Hide comment
@SalvaCrea

SalvaCrea Mar 29, 2017

Thank you, is very excellent

Thank you, is very excellent

@alkasingh19

This comment has been minimized.

Show comment
Hide comment
@alkasingh19

alkasingh19 Apr 10, 2017

Hi,
I have Implemented UI-mask date in my application, functionality not working in Grid when I click tab in cell to go on date cell.
using below template in directives -
template: '<input ui-mask="19/39/2999" ui-grid-editor  ui-mask-raw="false" only-Number ng-keypress="limitToValidDate($event)" placeholder="MM/DD/YYYY" />',
and I have created following cell template for grid column
var serviceFromDateTemplate = '

{{COL_FIELD}}>
';
can someone help me. on grid cell tab event directives seems not working. however it works when I click on cell but as the requirement is to function on Tab even of prev cell.

Thank you!
Alka Singh

Hi,
I have Implemented UI-mask date in my application, functionality not working in Grid when I click tab in cell to go on date cell.
using below template in directives -
template: '<input ui-mask="19/39/2999" ui-grid-editor  ui-mask-raw="false" only-Number ng-keypress="limitToValidDate($event)" placeholder="MM/DD/YYYY" />',
and I have created following cell template for grid column
var serviceFromDateTemplate = '

{{COL_FIELD}}>
';
can someone help me. on grid cell tab event directives seems not working. however it works when I click on cell but as the requirement is to function on Tab even of prev cell.

Thank you!
Alka Singh

@streeetlamp

This comment has been minimized.

Show comment
Hide comment
@streeetlamp

streeetlamp Jun 8, 2017

I've run into this gist so many times googling Query args, twice today. <3 Mark

I've run into this gist so many times googling Query args, twice today. <3 Mark

@notrealdev

This comment has been minimized.

Show comment
Hide comment
@notrealdev

notrealdev Oct 2, 2017

Hi, why 'category_name' => 'staff, news' not works for me? WP 4.8.2

Hi, why 'category_name' => 'staff, news' not works for me? WP 4.8.2

@yofisim

This comment has been minimized.

Show comment
Hide comment
@yofisim

yofisim Nov 6, 2017

This is genius, thanks!

yofisim commented Nov 6, 2017

This is genius, thanks!

@luetkemj

This comment has been minimized.

Show comment
Hide comment
@luetkemj

luetkemj Feb 10, 2018

This gist is now being maintained on github Help wanted!

Owner

luetkemj commented Feb 10, 2018

This gist is now being maintained on github Help wanted!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment