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.
0
votes
2answers
78 views
get Insert id for meta field
I'm in a situation where i also need to get the id of the inserted meta( meta_id for post meta and umeta_id for user meta)
For eg i add a user meta
...
0
votes
1answer
186 views
Meta query: get posts with value in a multidimensional array
I have a custom post type, Album, which has a custom field called 'tracklist'. Tracklist is a multidimensional array which contains a track title and track link, like so:
$tracklist = array(
[0] ...
0
votes
1answer
51 views
Meta query stopped working
The following query stopped working all of a sudden and I can't figure out why.
<?php
$today = date("Y/m/j");
query_posts(array(
'post_type' => array('events'),
'meta_key' => ...
0
votes
1answer
520 views
$wpdb query a post type within a specific taxonomy term while ordering posts by custom meta value?
I have a custom post type 'event', a custom meta field 'event_date' and a custom taxonomy 'locations'.
I want to query $wpdb to retrieve posts in this way
posts must be of the 'event' post type
...
0
votes
1answer
80 views
meta_query returning excluded result
I have a series of day slots per location, in a multicheckbox custom field. I have a search page where the user can select location, weekday desired, and activity type. Right now I just have 2 ...
0
votes
1answer
241 views
Excluding posts by meta, and also keeping posts without the meta
edit: Think I managed to figure it out, check the answer right under here, or click the following link:
http://wordpress.stackexchange.com/a/51175/15809
I've been trying to find a way to exclude ...
0
votes
2answers
861 views
Use have_posts() with array of post results retrieved by $wpdb->get_results
I don't know if I'm retarded, crazy or just plain genius or not, but I've decided to use tags as a way to link content site-wide (a big ol' many-to-many relationship website for archiving various ...
0
votes
2answers
588 views
How do I make a meta_query OR relation work? [closed]
Here's are wp_query args:
$args = array(
'post_type' => 'sportpages'
,'post_status' => 'publish'
,'posts_per_page' => 1000
,'post_parent' => 4738
,'meta_query' => ...
0
votes
1answer
560 views
filter custom post type by meta key in dashboard
I'm looking for a way to expand e customize more this topic
how to filter post listing (in WP dashboard posts listing) using a custom field (search functionnality)?
I've a custom post type in the ...
0
votes
1answer
70 views
Best way to sort estates and query them (for rent? yes/no. contains office space? yes/no)?
I´m building a real estate site where Estates is a custom post type. I want to be able to tick a checkbox or something similare on the edit page, where I can choose if the estate is for rent, if it ...
0
votes
1answer
207 views
Compare meta_query decimals not working right
I have a custom field named 'rating' that holds decimals from 1.0 to 10. I am trying use wp_query to get me all the posts with a rating of 8.0 to 10. What I have so far almost works perfectly but it ...
0
votes
1answer
209 views
Drag and Drop Metadata Menu Order
I'm not sure this has been answered previously..
I have a frontend form where the user fills out a form that has dynamic fields where they can add more fields if they choose to. The jquery names the ...
0
votes
1answer
199 views
Arrange Posts By Date In Order Of Closest To The Current Date
I have a list of events on a clients website that show in a sidebar. When viewing the homepage you see one event and if you're anywhere else on the site you see two events in the sidebar. I am ...
0
votes
1answer
185 views
Is it possible to compare the current time with a custom “start” and "end date
I need to be able to display a custom post type if the current date is between the start and end custom meta field dates. Here is my code so far, it seems to just be ignoring the query and displaying ...
0
votes
1answer
564 views
Search by meta_query
I am building a Wordpress site with an events feature. The events page was made with custom post types.
I want to make it possible for people to search/ filter events by dates. For example, they can ...
0
votes
1answer
229 views
How can I change my meta_query to SQL wpdb query?
I want to extract post related to 3 meta_data fields called bed_value, bath_value, rob_value the variable data is $bedrooms, $bathrooms, &rob, I got some confused with join and like structure. The ...
0
votes
1answer
386 views
meta_query displays all results and none, my query is wrong
I´ve read almost this articles but unfortunately my query is no working, I think i´m very close but could be so far away.
I´m trying to get metadata using a custom form with method get,
$rob = ...
0
votes
1answer
332 views
WP_Query not returning correct result with meta_query parameter
I've got the following loop on my index.php template:
<div id="new_on">
<?php
$args = array(
'meta_query' => array(
...
0
votes
1answer
196 views
How can I modify my meta_query to work with prices that are stored in the database that contain dollar signs and commas?
My goal is to return posts based on a specific price range using meta_query. The price in the admin that the user enters is a custom field, created using WPAlchemy. In the example below, the query ...
0
votes
1answer
251 views
WordPress & MySQL , problem with use many array in meta_query
I use this code for display custom posts :
$args = array(
'category__in' => $bookcat,
'meta_query' => array(
'relation' => 'OR',
array('key' => ...
0
votes
1answer
601 views
What's missing in this wp_query and meta_query
There is something missing because this is driving me crazy at the moment.
I'm using the wp_query with the following args.
$args = array(
'post_type' => 'project',
'post_status' ...
0
votes
1answer
162 views
How to “orderby” the first array in a meta_query that uses multiply keys?
My query is currently sorting by end date. How can I make it so it will sort by the start date?
$args = array ('post_type' => 'events',
'meta_query' => array(
...
0
votes
0answers
27 views
Search with meta_query and tax_query
I'm working on a little database for series based on wordpress. I've implemented a custom post type called "anime", some taxonomies (Genre, a_types..) and a lof of customfields. (based on acf). Now ...
0
votes
1answer
52 views
Checking if field is set before comparing with meta_query in query_posts?
I have a query set up to compare the start and end dates for some custom fields. The start date is required for the post; however, the end date is not. This causes some issues with the following:
...
0
votes
0answers
43 views
Pre Get Posts / Multiple Meta Keys / Orderby Single Key
Tried more than a few variances to enable my pre_get_posts callback function to display posts that possess one, or both, of 2 separate meta_keys, upon display to then orderby a single meta_key.
Here ...
0
votes
0answers
37 views
WP_Query - How to show last post from each meta value
I have a custom post type where I have testimonials which are all grouped by 6 industries (meta value).
On the post type archive page I would need to show the last testimonial from each of the 6 ...
0
votes
0answers
38 views
All in one event order by
Im using All in one event calendar. On my single event page I want to query some dates and sort them by start date. My query looks like this:
<?php $event = ...
0
votes
1answer
26 views
Filtering problem
I got the custom_post_type_data in which I store some variables when I make a new post. Variables likes Author, Price etc.
I implemented a filtering by author, so when you click on James (for ...
0
votes
2answers
124 views
LIKE %…% Meta Query
I have a serialized array as a meta value and I'm trying to run WP Query where it finds a specific value in the serialized array.
Here's an example of the serialized array field:
...
0
votes
0answers
52 views
Complicated Custom Post Type Query drill down, using meta query
I currently have defined a few custom post types.
a product category size
a product category
a product.
Inside my product, I hold and save meta data on a dropdown list of product categories. So ...
0
votes
1answer
161 views
WP_Query arguments: Loop through custom post type - get all entries except excluded meta_key?
Can't seem to find out what I'm doing wrong.
$args = array(
'post_type' => 'wr_event', // my custom post type
'posts_per_page' => -1, // show all posts
'meta_query' => array(
...
0
votes
1answer
211 views
get_users meta_query
I can't get meta_queries working correctly on get_users(). For the life of me can't figure out what I'm doing wrong.
$args = array(
'meta_query' =>
array(
...
0
votes
1answer
103 views
How to exlude posts that have certain meta_value?
I want to exclude some posts from the home page. So I want to use meta data, and filter all posts that are signed by meta_value=0.
Like this:
$args = array(
'posts_per_page'=>28,
'meta_query' ...
0
votes
1answer
107 views
loop through custom post-type with two meta_keys
I have a custom-post-type named my_project.
This post-type has two meta-boxes:
is_featured
is_featured_position
So essentially in my backend of the post-type I can set a checkbox for is_featured ...
0
votes
1answer
180 views
Custom query (author is post_author or meta co_author) with Pagenavi pagination
I need to create a custom query for the author archive (where the author is post_author OR is a meta co_author), and it have to work with WP Pagenavi.
The query is something like this (omitting $wpdb ...
0
votes
2answers
57 views
list or get meta_key where meta_value is 'something'
I'm trying to get with
get_user_meta
the meta_key where the meta_value is 'ive-read-this'
But I do not get the value. What should I do?
0
votes
2answers
792 views
Wp_query order by multiple custom fields?
I am learning WP_query and recently ran into a problem.
I need to do a query where i first filter trough one or more custom fields, which works great thanks to meta_query.
However, i also need it to ...
0
votes
2answers
72 views
Query author's posts & posts that have author's id as meta value
I am trying to get posts with an author's ID as a meta value in the author.php template using additional request parameter.
For example I want posts with john's ID as a meta value using a request ...
0
votes
2answers
487 views
meta_query with array as value
I am writing some php which allows users of my site to submit a form and query posts by their post_meta. Everything works fine except for one thing, I used advanced custom fields to create the ...
0
votes
1answer
412 views
search query within custom taxonomy term, post title and meta field
I want to create a search that does:
Search within my custom taxonomy - custom-tags
search the post title
search select meta field ?? dont know
search with custom post type - easy part
I looked ...
0
votes
1answer
82 views
Querying meta values within an array
Okay so I'm using the relationship field from Advanced Custom Fields against a custom post type. The relationship lists countries, when these are saved they are within a serialised array:
[country] ...
0
votes
3answers
74 views
Creating Custom Query
I've hit some sort of stumbling bock here, and I can't find my way over it.
I'm trying to craft a custom WP query that searches for posts by country of origin, selecting multiple countries at once.
...
0
votes
1answer
336 views
WP_Query display next custom post from today's date
I have a calendar plugin that uses custom posts types to create events. There are several custom fields that allow me to create various and seemingly unlimited post queries. The one I'm currently ...
0
votes
1answer
271 views
WP_Query orderby meta key/value suddely stopped working
I have code that has been working for a long time which when a user clicks a button to order database results by name/value, it gets the results via AJAX from a page that does all the querying.
I ...
0
votes
1answer
302 views
Difference between 'LIKE' and 'IN' in meta queries
You can use a variety of different comparison operators in meta queries, among which are 'LIKE', 'NOT LIKE', 'IN', and 'NOT IN'.
What is the difference in use between LIKE and IN?
Here's the ...
0
votes
1answer
702 views
Help With issue on pre_get_posts filter in taxonomy
I create a function to filter the taxonomy query with this code
add_action('pre_get_posts', 'custom_taxonomy_query');
$option_taxposts_per_page = get_option('tax_posts_per_page');
function ...
0
votes
2answers
305 views
Custom Post Type + Custom Meta Query Not Showing 2012 Posts
I created a custom "events" post type for a client that basically "hides" the post once it has expired (ie. the event already happened). The events are displayed in the order of the start date rather ...
0
votes
2answers
243 views
meta_query and strange orderby behaviour
this is my problem query, which picks all future or pending events.
Note that some posts only have _startdate without _enddate (1-day events).
$args = array(
'post_type'=> 'events',
'meta_query' ...
0
votes
2answers
545 views
Custom query looking at multiple custom fields and properly sorting
For the past two weeks I've been looking for a way to create a query in wordpress that returns all custom post types where a meta_key "mytype-expired" is NOT set to "yes" and then order the results by ...
-1
votes
1answer
83 views
294 Queries on Mainpage of Wordpress
I have 294 queries on my wordpress site. I checked using sql monitorand the maximum queries are to display count of a cities list custom field. Lets say there are 200 cities then 200 queries are ...
