Refers to a mechanism built into the WP_Query class for querying the database for post data, including pages and CPTs, based upon post meta data.
9
votes
5answers
4k views
meta_query with meta values as serialize arrays
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. For whatever reason I decided to code the meta boxes in ...
7
votes
2answers
266 views
meta_query sorting by 2 keys
I need to sort (custom) posts by 2 custom field values...
custom field name 1: is_sponsored [ value can either be 1 or 0 ]
custom field name 2: sfp_date [ timestamp aka current post date in seconds ...
6
votes
1answer
3k views
Meta_query compare operator explanation
I noticed that there are bunch of operator can be use for compare in meta_query.
However, I am not quite sure what operator I should use, it is somehow confusing like = and LIKE operator.
I would ...
6
votes
1answer
6k views
How to query_posts using meta_query to orderby meta_key AND have a secondary sort by date?
I've been troubleshooting an issue over the past few days and keep going in circles. Could really use a fresh pair of eyes to help me answer this question...
So I'm working with a wordpress site ...
5
votes
2answers
427 views
Complex meta query with 3 keys
I think the problem essentially relates to sql query structure and I am not an expert....
I need to search for posts (custom post type) by 2 parameters:
pd_city
pd_country
Please note that ...
4
votes
1answer
2k views
Using meta_query, how can i filter by a custom field and order by another one?
With the following code (in functions.php) my posts (of CPT event) are ordered by _end_date instead of _start_date. What's the proper solution to this as of WP 3.1.3? Of course I'd like to avoid using ...
4
votes
1answer
403 views
how to show posts that are missing a meta_value
How can I build a query to find posts that DO NOT contain a certain meta key or meta value?
for example:
query_posts( array(
'meta_query' => array(
array( 'key' => 'feature', ...
4
votes
1answer
204 views
Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
I've registered custom rewrite rules and query_vars to use for displaying a list of events based on ISO date format. For example when a user requests the URL, http://site.com/by-date/2013-04-04/, my ...
3
votes
2answers
649 views
SELECT max(meta_value) FROM wp_postmeta WHERE meta_key='price'… stops working when value is over 999
Overview: I am not trying to return a post. I simply want the single highest value for a particular meta_value across all posts... just the value itself.
Details: I have added a custom meta_key ...
3
votes
2answers
43 views
Best practice - Meta Query vs. post_clauses for “left join” ordering
Moreso a psuedo-code question than actual code. I have some custom post meta attached to attachments, and created a list table column for this meta. The meta is either 1, or null (not set), but I am ...
3
votes
2answers
318 views
Query between two meta keys
I feel like I'm extremely close on this one but the query keeps on showing up empty. Basically, I'm trying to query the custom values between two dates. Records should be returned if the start date is ...
3
votes
1answer
1k views
WP_Query with checkbox meta_query
I have posted this on StackOverflow too, not sure if that's allowed - if not let me know and I'll remove one (I don't want to look like I'm spamming). Anyway....
I have a custom post type and have ...
3
votes
3answers
2k views
Fail to compare dates in meta_query
This is the piece of code I use to get event posts whom date metadata is newer than today :
<?php
query_posts( array(
'post_type' => 'concerts',
'meta_key' => ...
3
votes
1answer
174 views
Is there a way to do multiple ordering on a multiple meta_query?
I'm experimenting with searches and multiple criterias and ordering. Let's say we have a real estate site, all posts have 2 custom fields (price and surface), and we want the visitor to be able to ...
3
votes
4answers
393 views
Using meta query ('meta_query') with a search query ('s')
Trying to build a search that not only searches the defaults (title, content etc) but also a specific custom field.
My current query:
$args = array(
'post_type' => 'post',
's' => $query,
...
2
votes
4answers
1k views
meta_query for keys that aren't yet set
I'm trying to query for a custom post type for a gallery system. I have a checkbox to set a gallery as a "featured" gallery (set up through More Fields plugin) - if this is checked then the meta value ...
2
votes
1answer
711 views
Using custom meta_query with relation not working as expected
I am trying to create a query to pull future events only. It was working great until the client requested the ability to add date ranges--so the event will either have a start date only, OR a start ...
2
votes
2answers
31 views
Sorting: custom query with orderby meta_value_num THEN by title
i try to run a custom post type query to match following criteria:
sort movies first by year in descending order,
after that ("inside" the year order) by title alphabetically.
desired output:
...
2
votes
1answer
137 views
Using database meta_values to calculate new post order using pre_get_posts or a 'request' hook
UPDATE: I have worked out my implementation of the selected answer at the bottom of this post.
I'm implementing a sorting algorithm based on Reddit's hotness algorithm, in addition to a time-decay ...
2
votes
1answer
146 views
Order by meta_key with two meta_queries
This should be simple, but I just can't pinned down a good example of the correct syntax to do this.
I want to order by the specified meta_key with two meta_queries. The problem is query_posts ...
2
votes
1answer
440 views
Nested meta_query with multiple relation keys
I am curious whether Wordpress is able to run nested meta_query, with each having different relation keys? As of Wordpress 3.0, tax_query is able to perform this function; I'm wondering whether this ...
2
votes
3answers
119 views
meta_query results not the same with and without spaces
I have a meta_query that gets all the items with a price range between 2 variables. My problem is that 10 000 is not the same as 10000. How can I fix this?
I have been googling but I'n not sure what ...
2
votes
1answer
232 views
How can I query all users who registered today?
I'm trying to use meta_query to return all users that have registered today :
$args = array(
'meta_query' => array(
array(
'key' => 'user_registered',
...
2
votes
1answer
1k views
Querying custom post type with 2 custom fields (date-range)
I've searched WP Codex and StackExchange and gotten some clues, but I can't get this query working. I have 2 custom fields associated with each exhibition in Y-m-d format: exstart-date being the start ...
2
votes
1answer
43 views
XOR functionality for meta_query
I'm trying to resolve the problem with event displaying.
An event has its start and end dates, written in meta. For example, event starts on (dmY) 03.04.2013 and ends up on 08.04.2013. Using WP_query ...
2
votes
1answer
129 views
order by meta_value serialized array
Hi I'm trying to pull posts using the wp query. Just one problem--I am trying to sort the posts alphabetically by a certain meta_value. Thing is that this meta_value is a serialized array. Is there an ...
2
votes
2answers
137 views
What is an efficient way to query based on post_meta?
The problem I am having is when I allow users to filter posts it overpowers the database and things run extremely slow. I am unsure what the best way to query posts using meta values is. My site has a ...
2
votes
1answer
280 views
Meta_query with relation 'OR' killing server CPU
function get_nb_offres( $typeOffre ) {
global $type_bien_correspondances;
$args = array(
'post_type' => 'annonces',
'meta_query' => array(
'relation' => ...
1
vote
2answers
450 views
WP_Query not working as expected for attachments and custom meta_query
If I use get_posts() like so I get a number of results with the value 1 for the my_key meta_key:
$posts = get_posts(
array(
'post_type' => 'attachment',
'meta_key' => ...
1
vote
1answer
209 views
WP_Query() show posts that end later than today
I have a query as follows:
$wp_query = new WP_Query( 'meta_key' => 'end_date', 'meta_value' => 'today', 'meta_compare' => '>=', 'post_type=vehicle' );
I want to show only those posts of ...
1
vote
2answers
156 views
How do I find if a page has a template?
So I'm doing a query like this:
$the_query = new WP_Query( array( 'meta_key' => 'homepage', 'meta_value' => 'yes',
'post_type' => 'page', 'orderby' => 'modified', 'posts_per_page' ...
1
vote
1answer
361 views
Filtering by Post Meta Custom Fields - Performance
I could use some advise on how to structure my data for performance. I have a custom post type with a lot of custom meta data stored in the wp_postmeta table as a serialized array under one meta key ...
1
vote
2answers
172 views
Multiple Values stored as array in Meta Query
I'm a little confused as to best practise for saving multi-select values in meta fields.
Assuming
<select multiple name="_casestudypost[]">
is my form field
if I store ...
1
vote
1answer
191 views
How can I combine meta_query queries?
I'm trying to build combined meta_query queries but they don't work.
Any ideas how I can implement queries like the example below?
Thanks, Hinnerk
Array
(
[relation] => AND
[0] => ...
1
vote
1answer
923 views
Plugin that would allow WordPress Authors to “follow” other Authors and query “Activity Info” from that
I have a WordPress blog that is all user based Authors that submit content and such. Currently in the site, you can view other authors profiles but basically just view their content from the ...
1
vote
2answers
480 views
Archives for custom post type based on a “date” meta value
I've got an "Event" custom post type. Each post has a meta field for the actual event date, which cannot be the posts's publish date, as most all the event dates will be in the future.
With that, I'm ...
1
vote
2answers
345 views
Nested Queries using meta_query
I'm trying to build a query that lists posts of a custom type with specific custom field values. Then I need to list children of each of those posts within the post, and those children also need to be ...
1
vote
2answers
662 views
meta_query, number comparison, not quite working as it should
I have a wp_query that gets all custom post types in ascending order from today, to list some events on a site of mine. While this works fine:
$args = array( 'post_type' => 'events',
...
1
vote
1answer
491 views
I can't set meta_key in my custom post type query
I've created a custom post, events, and saved the meta data event_year to each event. I'm trying to get a year's event archive. When I go the the following URL, the meta_key and meta_value are not ...
1
vote
1answer
112 views
Custom query with DECIMAL(5,2)
I want to know if there is a way to DECIMAL (5,2) instead of DECIMAL in meta_query
1
vote
3answers
545 views
Get Posts shortcode plugin and meta_query?
I'm using Get Posts plugin to list posts with post type "project". I want to filter the list by two custom fields: year (ex. 2006) and state (ex. Completed). I added meta_query to the plugin's ...
1
vote
1answer
43 views
Perform query with meta_value date
I am trying to perform a query on a custom-type post using the value of a custom field.
This field contains a string date: dd.mm.yyyy.
The post type name is 'event'
The custom field name is ...
1
vote
1answer
184 views
wordpress get meta value by meta key
How to get the meta value by meta key
I want to get the value by the meta key.
This is what I have tried so far:
$args = array(
'post_type' => 'post',
'post_status' => 'publish',
...
1
vote
1answer
90 views
How to stop wp_postmeta from being called on archive and search pages?
Currently, when I load a search or result page, it queries the wp_postmeta table which is leading to the page taking ages to load. I realise this is a result of this table being huge (70k rows), and ...
1
vote
1answer
314 views
WP_Query filter and order by meta ordering by wrong joined table
I'm trying to both filter and order a Wordpress query using the meta_value, however the ORDER BY part of the query seems to be working on the wrong table.
The query params here are:
array(12) {
...
1
vote
1answer
591 views
WP_Query last five posts, simply ordered by meta_value
I can't believe I'm asking this question. It feels like such a simple method, yet I've poured over the WP pages and dozens of similar questions to no avail, so here it is...
I've got a WP_Query with ...
1
vote
1answer
1k views
Meta Query with AND & OR?
I'm trying to do some filtering for some posts in WP_Query, but I can't seem to get the right condition. Basically what I wanna do, is get posts that have the custom field event_data (sorted by this ...
1
vote
1answer
234 views
Pull a post based on a meta value in a custom post type
I'm trying to display a post, from a custom post type based on a meta value in that post type, in this case a checkbox that says "if this is checked show it on the front page.
Usually I write a ...
1
vote
1answer
1k views
How to create a wp_query that contains both meta_query and tax_query
I have a wp_query that works great but I can't have both a meta query and a tax_query in it.
<?php
$event_query = new WP_Query(
array(
'post_type' => 'event', // ...
1
vote
2answers
50 views
Optional Meta Query
I have places stored as posts in WP's posts table.
I am doing some geo-locating using Geo Data Store (http://wordpress.org/plugins/geo-data-store/). This is working great for me, as I can currently ...
