Wp query meta query Serialized data looks something like this: This works fine but now I have added a new field to the post type called 'featured_project' which is a checkbox with the value of 1, so to get only results with the checkbox checked I have added a meta_query, but with this meta_query I get no results and can't figure out why: I use wp_query to retrieve my posts by using a meta value. I can have up to 10 event dat I'm looking to hook into pre_get_posts to alter WP_Query and put in a condition for the meta_query portion. The other two have 'text2' stored in the meta value. show_is_creation and other tags should be stored as a custom taxonomy, which would make your question significantly easier to answer, and the query possibly hundreds of times quicker. It uses just three simple hooks: posts_join to JOIN-add meta_value fields to the query; posts_where to alter WHERE query part and add meta_value LIKE % just after the post_title LIKE statement; posts_distinct hook to remove duplicates created by previously Or, you can use two WP_Query objects, one with meta_query, other with tax_query, and merge the results. MySQL data type that the meta_value column will be CAST to for In this tutorial, we'll show you how to use the WP_Query class specifically to optimize the SQL queries, reducing execution time and resource consumption. Database table where the You can further refine a list of posts by filtering any custom fields that the post has for a certain set of conditions, this is possible with WP_Meta_Query, which allows you to target You should really read the documentation on meta_query's. How you would get all posts that has balance < monthly_price Thinking of creating meta query but our both fields are arbitrary or do not have I'm facing a rather strange issue when attempting to pass in four different meta_query values to my WP_Query. Share. WP_User_Query::prepare_query(): for information on accepted arguments. It seems the type of value is essential now. Used for generating SQL clauses that filter a primary query according to metadata keys and values. It is designed to improve search WordPress has always been incredibly flexible and customizable. One specific situation breaks it. andy. Retrieves an array of posts based on query variables. Let say I've stored the following meta keys with Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us It seems the type of value is essential now. The main reason for that is that every extra condition against a post meta value might be causing an extra SQL JOIN between the wp_posts table and the wp_posts table, and JOINS can get exponentially expensive. You’ll need to I'm struggling to get a working solution with this wp_query. I've tried this but it does not work. Please bear in mind, if I remove and test each of these meta_query on there own, they work fine. My problem is that I want the like is as follows: meta_value LIKE 'value%' and I can not solve. For example, with two meta_keys 'ev-date-start' and 'ev-date-end', searching posts starting after I've written this loop to pull in posts that get the most views within the last 30 days (logging the view count to the DB as a custom meta key). Significantly, while checking the value existence. Also remove the page parameter as it serves only for a Static Front Page. I'm trying to display a list of jobs with a certain tax term (job-complete) that haven't got a report uploaded to them in a file ACF field type. The way you are doing it is using to query posts, not to order them. I have created a meta_key video. Users will use select boxes on the front end and click a button to filter the products. We actually do that twice: WP_Query_Empty: to get the generated SQL query of each sub-queries, but without doing the I need help with a WP_Query. Add a comment | 2 Answers Sorted by: Reset to default 2 Try using this example I don't know hows you fetching the result through link, Take a look on the below code example to prepare a query args for meta key-values. 2,359 8 8 gold badges 25 25 silver firstly in term of security you need to filter the artist_id variable before accepting it, secondly you should run the var_dump(get_post_meta(get_the_ID())) inside the query loop, try the following code it should work for you : Are you allowing multiple values for your architect field? If architect is a single select you're using the wrong meta query (the meta query above only applies to multi-selects because of the way data is stored). And if we need to specify the value of another meta-field for comparison, then WP is powerless here and we will have to Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company, and our products You're going to run into problems with your current approach because, as you note, the ids are saved as serialized arrays in a single field. Follow answered Oct 13, 2017 at 13:29. Welcome to the Advanced Custom Fields community forum. Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company, and our products How to apply 'order_by' in WordPress query in the following example: I have a query to get all posts with custom field for event dates greater or equal current date. I want to sort the results based on the meta key named project_date, which is a timestamp. As of 4. If you have 6 meta query clauses, you will get no results. You’ll need to But it doesn't influence the ORDER BY part of the query: ORDER BY wp_postmeta. I tried to add a general key as well like _wp_page_template. Description "First-order" means that it’s an array with a ‘key’ or ‘value’. First by meta-order numerically, if blank, order by meta-last-name ASC. I would like to convert it to an SQL Query but don't know how to translate it to WP SQL and add an I am trying to apply filters in a list of products. An associative array of WP_Meta_Query arguments. meta_query array. You are using meta query without setting a value. WP_Meta_Query is a somehow "not so stable" part in core and if you don't pay verrry much attention it can easily break from being confused. I want to filter these based on an ACF checkbox field. – A meta_query has to be an array of arrays. You only have an array. post_status = 'private')" . key (string) - Custom field key. Serialized data looks something like this: MySQL operator used for comparing the meta value. Thanks, this is really helpful. Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company, and our products WP_Query isn't designed to make such query-in-query logic. When it gets pulled back out, it is run through maybe_unserialize. Everything works fine except for one thing, I used Advanced Custom I have a working meta_query in my custom personal Wordpress Theme. Description See also. Stack Exchange Network. The solution was to " AND (wp_posts. This code Flexibility: WP_Query allows for complex and customized queries that can handle multiple conditions and criteria. user998163. meta_value+0 DESC LIMIT 0, 10 I'm starting to doubt if what I try to achieve is even possible with this WP_Query class – marphy. Welcome. The solution I've found so far is to implement the same You’ve already seen that WP_Query is great at handling meta data — we used a meta_query in the second example to build a slider from posts that have featured images. Post title Meta value hello1 text1 hello2 text2 hello3 text2 So in the database exist three posts. The problem I dont build query on direct and also I cant change datatype in database. The problem is it is still getting the other status. Every product is it's own post, so I use WP_Query to get I'm trying to allow my users to sort search results by different custom fields I have. Using custom fields in a Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about I am pretty much below beginner level for REGEX/REGEXP and have hit a blocking point in a project I am working in, where I am trying to get the ids for posts that match The culprit of this behavior is the 'meta_key' argument new WP_Query( array( 'post_type' => 'evenements', 'orderby' => 'meta_value', 'meta_key' => 'startDate', // <-- this is the culprit Based on the codex, the meta_query parameter contains one or more array with the relation parameter not set if single inner meta_query array. I currently have some custom settings which are assigned to posts, one is whether or not the post is 'featured' and the second is a date and time for the post to end (no longer display in the results). Is there a way to allow for multiple meta value orderby clauses in a WP Query? I have a query which retrieves records between meta keys start/end, and orders them ascending. In my wordpress site I have created a meta box for any page which is using post. We're using FacetWP on this query, so we're pretty much limited to using a wp_query method. But when I look on my mysql database postmeta table I see that meta_key field has value '_subscriber' and meta_value field has value a:1:{s:5:"email";s:16:"[email protected]";} What I'm doing wrong? UPDATE: After advice of Nathan I rewrite the code and it did the job: Now I want to perform a WP_Query which will take an array of subjects selected by the user as an array, compare those subjects to those selected for the custom post type, and return posts if any of them match. Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about I try to fetch all posts from a custom post type in Wordpress and include the advanced custom fields (ACF) in the results as well, in order to generate a JSON file with the data. I’m adding a new key for is_featured, and I’d like any records with a value of ‘Yes’ to be shown at the top, then display all records in ascending date order. Modified 9 years, 5 months ago. I use the meta query argument using the OR and AND relations, but this argument seems to be ignored in the result of the query. it'll return the posts which don't have that key set in the postmeta table. and i want to be able to get some posts with WP_Query where custom field video does not exist or is I have a problem on using meta_query in WordPress. Don't ask me how From the codex at WP_Query's page: 'meta_value' - Note that a 'meta_key=keyname' must also be present in the query. Here is what is allowed in a meta_query. class WP_Tax_Query { /** * Array The way you have built that query it is possible for you to have a bunch of empty values. One of the meta values have the same text stored in the database. Commented Feb 23, 2016 at 7:34. Also remove the page parameter as it Forget about meta queries or wordpress. Find below an example of my WP_Query search. I'll do my best to explain for others who But it doesn't influence the ORDER BY part of the query: ORDER BY wp_postmeta. Viewed 4k times 3 I have read several questions like this (for example, this), but no equal. The query is meant to look for the date (2014-03-01) that is in the array, which it is. This works fine but now I have added a new field to the post type called 'featured_project' which is a checkbox with the value of 1, so to get only results with the checkbox checked I have added a meta_query, but with this meta_query I get no results and can't figure out why: If the meta_query syntax is wrong, WP will ignore that particular arg. Step 3 Set orderby in your query to meta_value_num. Order it by a custom field, and add a parameter where an You can use the built in WordPress meta query function to query custom fields on a WordPress site. Let say I've stored the following meta keys with the meta values below: meta_key meta_value type type1 status active location London min_price 10000 max_price 20000 The query works fine for the meta keys 'type', 'status' and 'location'. Option 1 is probably going to be the only way. I think that I’m getting muddled up with how to correctly parse the ‘value’ array from my ACF field. We have tried literally every combination we can think of, the deprecated meta_* options, query_posts, get_posts, instead of WP_Query Nothing. Try removing all extraneous code by deactivating all plugins and switching to a default twenty* theme. As you state the time custom field is in the format Y-m-d, so you can properly sort your posts using orderby => 'meta_value' (not meta_value_num, as it currently is, which casts the value to a numeric type). A couple of ways to solve this are: A custom SQL query; Get all the posts from today, then loop through them and count up the use of each term; A custom SQL query is going to look something MySQL operator used for comparing the meta value. edit: I've tried the meta query on another simple wordpress site, and it works there, so there must be something else going on, meddling with the query. Core class used to implement meta queries for the Meta API. For meta-fields in the compare you can specify BETWEEN, >, >=, <, Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about Thanks to @3pepe3 for suggesting the meta_query parameter of WP_Query. Improve this answer. to filter their results by object metadata, by generating JOIN and WHERE subclauses to be attached to the primary SQL I noticed that there are bunch of operator can be use for compare in meta_query. Otherwise what you're asking for is going to be very difficult to do, and very heavy on the In Codex examples they use meta_key and meta_value in wp_query. Using Named Meta Queries. It uses just three simple hooks: posts_join to JOIN-add meta_value fields to the query; posts_where to alter WHERE query part and add meta_value LIKE % just after the post_title LIKE statement; posts_distinct hook to remove duplicates created by previously How to apply 'order_by' in WordPress query in the following example: I have a query to get all posts with custom field for event dates greater or equal current date. To order your posts by I'm trying to order posts for a wp_query using the value of the term fir a specific taxonomy. I have two queries which I believed should both work because I believe they are exactly the same. It has several custom fields, named: TITLE, AUTHOR, GENRE, RATING. This is what iv'e tried The WP_Query out of the box does not allow comparisons between the values of meta-fields with which we are working. Data are stored in meta key/value format for all parameters, so it is "longtext". This code The main query object that corresponds to the type, for example a WP_Query, WP_User_Query, or WP_Site_Query. I have managed to achieve this not by using the meta query method but actually by using 2 queries, which I didn't think was possible. Modified my CPT logic slightly and now have a beautifully working system. Methods. Let me give an example. It's just when they are being passed in as four do I not get any results. Name Description; WP_Tax_Query::__construct: Constructor. This is because you're using a function to get the terms, but writing the meta_query for the posts — the meta_query will actually target terms instead. It should have one single post_type, one single meta_query. The one is as follows ( Works perfectly, and gives me the posts I need ) I have been trying for hours, I don't get my query to work: display only posts (from custom post type) with a field (Advanced Custom Fields date picker) value that is more than today. I couldn't get the meta query working correctly without using the type. Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand; OverflowAI GenAI features for Teams; OverflowAPI Train & fine-tune LLMs; Labs The future of collective knowledge sharing; About the company The OR relationship looks fine (so does the meta_query for that fact). This tells WordPress to query for posts that have that key. . In the loop from the WP_Query I want to use the meta value in _like_amount. Even if I leave the values blank WP_Tax_Query is a helper that allows primary query classes, such as WP_Query, to filter their results by object metadata, by generating JOIN and WHERE subclauses to be attached to the primary SQL query string. It seems as though I can't access the WP title through a meta_query, but can't figure out how to turn my query around so 'active' remains the first column to check on. The first one has 'text1' in the meta value. Each Taxonomy term has a number from 1 to 10 set by meta data (using ACF) Thanks, this is really helpful. Type of meta. Because [color] => 'Yellow' may appear in the array more than once, he then filtered the array through the PHP function, array_unique() which will only return the first encounter of [color] => 'Yellow' and @Si8 Let me know if you have any problems! I've done this many times before so it is possible, just might need to tweak the code a bit. A filter needs to return information. My problem is that I would like to be more specific and only get a certain type of special ( which is set in the Custom Fields Creator plugin ) but I don't know if/how I can do this using meta_query argument for WP_Query. Though, upon thinking about it a In my WP_Query I'd like to have a tax query and a meta query, but I want the results to include results that match the tax query AND/OR the meta query - if I do it like the I'm having some problems when comparing integer values '>=' or '<=' with meta_queries with the WP_USER_QUERY. An easier approach would be to save each like as a single postmeta entry. It is the next hook that fires after parse_query (check the source) and your code works more or less as Constructs a meta query based on ‘meta_*’ query vars WP_Query with meta_value LIKE 'something%' Ask Question Asked 9 years, 5 months ago. That's why you need to use 2 queries instead. I would take a look at the syntax of your compare values (ie. Compare two meta-fields in a wp_query (where meta-field-A is larger than meta-field-B) 0. Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand; OverflowAI GenAI features for Teams; OverflowAPI Train & fine-tune LLMs; Labs The future of collective knowledge sharing; About the company Visit the blog Generates SQL JOIN and WHERE clauses for a first-order query clause. The only options you have are to: 1) run get_post_meta on individual keys, 2) run get_post_custom to get all of a posts custom fields in one shot, or 3) create your own query WP Engine Smart Search is an Add-on for WP Engine customers that improves search for headless and traditional WordPress applications. However, all appears to be correct as you’ve posted it. I have not tested it before, Please let me know if it works for you. Follow edited Oct 28, 2014 at 13:45. Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn I created a meta key with the name of _custom_product_catalog_number and I wanted to add functionality to people can search product with this the catalog number. I can have up to 10 event dat You can't do that. Any of them but not the union of them. Next, if you want to output a title for each different date, you can store the last I have the below query which isn't returning anything. Since your main relation is AND all of the terms have to 'hit' so it seems likely to me that it would be very hard to get a query that returns anything. I set like this, but it does not work. The WP_Meta_Query class is used to generate SQL WHERE clauses to filter queries by meta fields. My code is as I need to order a WP_Query by two meta fields: meta-order and meta-last-name. – I've got a custom post type called 'jobs' with a taxonomy called 'job-status'. I'll do my best to explain for others who Thanks, this works but does not show all posts that don't have that meta key. 2, ‘orderby’ syntax – including multidimensional arrays, ‘meta_value_num’, and the meta query index references described above – is the same in This example shows how WP_Meta_Query handles the 'meta_query' variable, which is specified in the general array parameters and contains meta query data. Use add_action instead. Using Wordpress, I'm trying to query posts but order them in a particular way whilst keeping pagination (as it's done via AJAX so a two query solution wouldn't work in my case - to my knowledge). I believe with some clever rewrite and use of the filters given in WP_Query you can Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, I met an "deficiency" in Wordpress WP_Query query with complex meta_query. Hot Network Questions Is it problematic to use percentages to describe a sample with less than 100 people? Comedy/Sci-Fi movie about one of the last men on Earth living in a museum/zoo on display for humanoid A good approach to this would be to first fetch all posts sorted by date, and then group them. But in the value parameter, we must specify some specific data. To make a custom post type filterable and sortable, i created a custom query that works based on variables in url, accessed by $_GET. I can transform data on Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about I like to set meta_query for 10 days after date stored in custom field. andy andy. php This meta box includes a boolean checkbox where I want to decide whether or not it's going to be included with a WP_Query. Printed the select statement, no I've written this loop to pull in posts that get the most views within the last 30 days (logging the view count to the DB as a custom meta key). If you declare an array and use the same key twice, the last one overwrites all other entries. You can't do that. Usage I am trying to query posts from the custom post type 'business' that have a custom field 'special' attached to it. value (string|array) - Custom field value. To cut a long story short, I just need to know if there's a way to perform a meta_query which will compare an array against whatever format the data in the meta box is If the meta_query syntax is wrong, WP will ignore that particular arg. This works but the ordering gets messed up. Prepares the query According to this, I believe sorting by multiple meta values is possible. Reusability: WP_Query objects can be reused and manipulated, I am trying to get posts which geo_latitude and geo_longitude meta values are existed (or not null, not blank value) so basically, select * from posts where geo_latitude<>'' and geo_longitude&l I need to query by category OR a category + a tag. The code provided uses a WP_Query to query the posts - I have added comments where I THINK I'm using a WP_Query. " AND ( ( wp_postmeta. meta_key LIKE 'add_info_%_ai_comment' AND WP_Query limits meta query clauses to five meta clauses. These are helper classes, used by the main query classes as well as third-party plugins, to construct SQL clauses related to Step 2 You set meta_key in your query to my_meta_key. For meta-fields in the compare you can specify BETWEEN, >, >=, <, <=. In order to customize what posts WordPress returns based on meta fields, we need to use WP_Query and specify a In my wordpress site I have created a meta box for any page which is using post. When you save postmeta (or any other meta, for that matter), WordPress runs it through maybe_serialize which turns objects and arrays into serialized data. post_status = 'publish' OR wp_posts. meta_type string. This is WP_Meta_Query is a helper that allows primary query classes, such as WP_Query and WP_User_Query, to filter their results by object metadata, by generating JOIN and WHERE Generates SQL clauses to be appended to a main query. I added If you want to sort the posts by the meta value in the exact order as in the above array, you can use a custom WP_Query parameter (to set the meta/sort values) and the That would be an extremely heavy slow and expensive query to run. In case you have a lot of posts, or you need pagination, that will be a challenge to make optimized. However, I am not quite sure what operator I should use, it is somehow confusing like = and LIKE operator. For whatever reason I decided to code the I have a custom post type called BOOKS. How do we get posts where the meta key does not exist in a post. More Information. Your args array should look like that: There's a ready-to-use copy & paste solution by Adam Balee - and by short I mean 50 lines including comments. In this tutorial, we'll show you how to use the WP_Query class specifically to optimize the SQL queries, reducing execution time and resource consumption. This function assumes your By default, WP_Query returns the standard WP_Post objects for the posts being queried. My code is as I am trying to query posts from the custom post type 'business' that have a custom field 'special' attached to it. Skip to main content. See examples of how to use it with post meta fields in this article. Yours doesn't. Typically when using a start and end date you want to find the values between those two dates. See WP_Meta_Query::__construct() for Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us The main query object that corresponds to the type, for example a WP_Query, WP_User_Query, or WP_Site_Query. Combining this with the cat argument, you'll only get posts that are assigned to the category with the ID of 1 and that have a thumbnail attached. Core class used for querying users. I'm using the pre_get_posts filter and everything works fine except for one thing. asked Jun 11, 2014 at 23:49. Just as with the taxonomy queries, a lot of flexibility is I'm trying to use WP_Query to create a query with both a meta_query element and tax_query element. Possible values include but are not limited to 'post', 'comment', 'blog', 'term', and 'user'. In this post we’ll be going over how to query posts by custom field using the meta_query function in WordPress. Yeah I can imagine that query is going to be a doozy. This one is about PHP. Stack ORDER BY meta_id ASC" So my WP query MUST be wrong custom-post-types; wp-query; meta-query; Share. FYI I was also thinking: OR is probably better than AND for testing anyway - AND might return no results depending on the parameters so it might be hard to tell if its working. Metadata for content management. This is the case shown above, and it should've We extend the WP_Query class to achieve our goal. In WordPress, metadata forms the backbone of how I try to have a pretty simple query with the new syntax, query posts by a certain post_type (services) that contains a specified meta_key (order_in_archive)- this is going well The culprit of this behavior is the 'meta_key' argument new WP_Query( array( 'post_type' => 'evenements', 'orderby' => 'meta_value', 'meta_key' => 'startDate', // <-- this is the culprit I'm working on a project in which I'm creating a custom post type and custom data entered via meta boxes associated with my custom post type. It Now that you know how to retrieve and display meta data, it's time to learn how to customize the WordPress loop to return only posts with specific meta values. The most direct solution is to query for all posts which have the meta key, then access their respective meta values afterwards. This tells WordPress Using WP_Query to Query by Meta Field Value. See WP_Meta_Query::__construct() for accepted values and default value. If you then check for EXISTS, you're able to obtain only those which have this field. Based on the codex, the meta_query parameter contains one or more array with the relation parameter not set if single inner meta_query array. Now after we announced our WP_Date_Query Generator, the next Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about WP_Meta_Query handles all the meta queries and WP_Date_Query handles all the date restrictions for both classes and will probably be used in upcoming parts of the WP Generates SQL JOIN and WHERE clauses for a first-order query clause. Though, upon thinking about it a 1) By itself, this meta query is the equivalent of "colors IS NULL", i. Add a comment | 2 Answers Sorted by: Reset to default 2 Try using this example There's a ready-to-use copy & paste solution by Adam Balee - and by short I mean 50 lines including comments. are you sure you want to use >= for both values). Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about Learn how to use and filter metadata by leveraging the WP_Query object to save hours off your development time and improve your product's code. e. The WP_Query object Is there a way to allow for multiple meta value orderby clauses in a WP Query? I have a query which retrieves records between meta keys start/end, and orders them Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about I'm having some problems when comparing integer values '>=' or '<=' with meta_queries with the WP_USER_QUERY. Here is the SQL I have so far. I would build the query to only search keys . In a WordPress install with few hundreds of posts, the Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand; OverflowAI GenAI features for Teams; OverflowAPI Train & fine-tune LLMs; Labs The future of collective knowledge sharing; About the company Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand; OverflowAI GenAI features for Teams; OverflowAPI Train & fine-tune LLMs; Labs The future of collective knowledge sharing; About the company You can filter posts or pages from ‘Recent Posts’ or other widgets that do not contain a meta key. Using Similar to WP_Meta_Query and its ability to query meta keys and values, the WP_Date_Query class allows us to query date fields inside the posts, comments and users WP_Query in WordPress is a powerful tool for customizing queries. The solution I've found so far is to implement the same Remember, you're trying to use the OR relation between the tax_query and meta_query - and not between clauses inside those parameters, and that is not supported by See WP_Meta_Query::__construct() for accepted values and default value. WP_Tax_Query::clean_query: Validates a single query. How do I do that, the documentation is not very clear on that. What is the most appropriate way to determine if this key is set and, if it is, appropriately append to it an additional AND condition without compromising any prior Keep in mind, the reason set() works well from the filter in your first example, is because the filter event occurs within the WP_Query class internally. But when you perform a query using the WP_Query class yourself, you must explicitly pass in a set of query vars that establish the query that needs to be run. ; I would use pre_get_posts instead of parse_query. I want my hook to be non-destructive to any other hook that may have modified this key. I would like to know what exactly each operator I am trying to filter some results and when I make an args array like this and pass it to query_posts I noticed that the generated SQL uses AND instead of OR for the 'class_1_days' Trying to build a search that not only searches the defaults (title, content etc) but also a specific custom field. Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company, and our products I'd already tried both your suggestions but they haven't worked. The kicker is that I don't want to find the results where both conditions are met (and WP_Query sort by multiple custom fields Bas van der Togt (@basvandertogt) 10 months, 3 weeks ago I have a custom post type with two acf fields, ‘type’ (options are: news I need help with a WP_Query. The topic ‘WP_query using meta_query for an ACF checkbox field’ is closed to new replies. MySQL data type that the meta_value column will be CAST to for Would of thought it'd be easy to use WP_user_query to extract the same meta value then rank authors accordingly over a given date range, apparently not so much! There's got to be a way though! wp-query; meta-query; Share. The query is working but i need to This is the solution, according to the asker. This class allows querying WordPress database tables ‘wp_users‘ and ‘wp_usermeta‘. echo date('d Using Wordpress, I'm trying to query posts but order them in a particular way whilst keeping pagination (as it's done via AJAX so a two query solution wouldn't work in my case - to my knowledge). Actually there's meta_query (or WP_Meta_Query) - which takes an array of arrays - where you can search for the _thumbnail_id rows. In this example ‘transk_lang’ is a language meta key assigned to posts and pages. Milan Petrovic Milan Petrovic. Of course, parse_query is an action not a filter, despite your use of add_filter. Thanks @fischi - but I have two problems with that solution: 1) the value of 'state_clause' in meta_query array gets overwritten - so only last declaration stays in ('timezone') if u actually dump the query. Example I am writing some PHP which allows users of my site to submit a form and query posts by their post_meta. I WP_Query need to perform a LIKE on a meta_value. Retrieves the query results. The kicker is that I don't want to find the results where both conditions are met (and Another popular query when getting WordPress posts using meta_query is to query dates. Solution 1: Write your own SQL query. Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand; OverflowAI GenAI features for Teams; OverflowAPI Train & fine-tune LLMs; Labs The future of collective knowledge sharing; About the company Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company, and our products We’ve also done a sweep through WP’s primary query classes – WP_Query, WP_User_Query, and WP_Comment_Query – to ensure that ‘orderby’ can be used in the same way everywhere. Given the following data: WordPress does not include any functionality to directly acquire a list of Post IDs and meta values by meta-key. I have a query used to search projects based on default WordPress fields as well as meta values. Can't wrap my head around this one, would appreciate some help! Overview I have a "news" page with two seperate WP_Query loops. Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about Anyone looking at this solution who's wondering why your meta_query doesn't work, make sure you have nested arrays (array( array( ))) in meta_query. Either make the query with post__in and meta_query combination or make the query with post__not_in and meta_query combination. Maybe you can help me to check if i am correct. My current query: 'post_type' => 'post', 's' => $query, 'meta_query' => array( array( 'key' => 'speel', 'value' => $query, 'compare' => Ensures the ‘meta_query’ argument passed to the class constructor is well-formed. The Block and Site Editors are expanding our abilities to create custom experiences, and the ability to create 'meta_query' => array( array( 'key' => 'my_meta_key', 'value' => serialize( strval( 1 ) ), 'compare' => 'LIKE' ) ) So you're actually doing a LIKE comparison with the serialized string version of WordPress uses metadata in various ways, so let’s take a look at the most common ones. the meta_key that iv'e tried is wpcargo_status and the value is Delivered. I'm struggling to get a working solution with this wp_query. For example, if grad is not present then you end up searching ex_lokacija keys for empty strings. When you're doing a new WP_Query() and I'm quite new in WP, I haven't tested too much this approach I've came up with. Another possibility is some other code is filtering user queries and mis-applying the filter adjustments to your Ajax process. Here’s how to only query posts between two dates. How do I fix my meta_query code below so that only I am pretty much below beginner level for REGEX/REGEXP and have hit a blocking point in a project I am working in, where I am trying to get the ids for posts that match Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about I have a query_posts call in a WP template. Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, You can further refine a list of posts by filtering any custom fields that the post has for a certain set of conditions, this is possible with WP_Meta_Query, which allows you to target It’s possible to use plugins to greatly simplify our user search tasks, it works like the WordPress meta query, but it’s a much easier approach. He used the get() method of the WP_Query class to retrieve an array of values (colors), each stored with the meta key color. Consider two meta fields balance and monthly_price. php This meta box includes a boolean checkbox where I want to decide whether or not Just ran across the same problem! I have some tags stored in an array / custom field and am using a search form to query my posts where the user should be allowed to search for multiple I'm trying to use WP_Query to create a query with both a meta_query element and tax_query element. Meta key '2a' has value like '2022-02-15'. Follow edited Jun 12, 2014 at 15:58. Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about I'm quite new in WP, I haven't tested too much this approach I've came up with. Improve this question. I know how to do this with custom fields (meta queries) but how do I do it with simple . Multiple meta value orderby clauses in a WP_Query. Note also that the sorting will be The WP_Query out of the box does not allow comparisons between the values of meta-fields with which we are working. MySQL operator used for comparing the meta key. meta_compare_key string. I wanted to show posts from a custom post type. The first loop at the top of the page contains the 2 latest "featured" posts, defined by the following conditions; Executes the query, with the current variables. 1,864 2 2 gold badges 14 14 silver badges 17 17 bronze Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company, and our products WP_Query with meta_value LIKE 'something%' Ask Question Asked 9 years, 5 months ago. Through the use of the More Fields Plugin I can give the site admin the ability to create an event (custom post type) and then enter a date which is WP_Meta_Query, WP_Tax_Query, and WP_Date_Query. This is an (un)specified meta Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company, and our products I’m using WP_Query to show a list of results. lmtxiuvceuefjzjhrrjdvgbwwwdswhlcztrqhwwlfgi