Tagged Questions
1
vote
1answer
38 views
WP_query posts closest to todays date
I have written an wp query which I would like to order in a bit of a complicated way. Some posts have a meta value 'the_date' which is an end date for the post. I would like to order posts in date and ...
0
votes
0answers
26 views
Custom WP_Query for WordPress Search Results with meta_query
I am using a custom query to generate my search results. The code I am using works perfectly without the meta_query variables in my arguments array.
I am trying to compare multiple custom fields with ...
0
votes
1answer
50 views
Custom query with category exclusion and post-meta “whitelist”
I have two widgets, one shows News while the other shows everything except News (We'll call the second one Blog). The blog portion is currently working correctly.
The News posts are either ...
0
votes
1answer
70 views
Select from wp_post and multiple meta_value from wp_postmeta
My lack of SQL skills has stopped me in my tracks here.
I'm trying to select post_id, post_title and two postmeta values - the first has the meta_key of 'search_country' and the second a meta_key of ...
0
votes
1answer
55 views
How can I sort posts by the date and a custom meta field?
I have custom meta field that I use for the post rating.
So I want to display posts by the date and the rating, but only for the posts that have specific rating.
For example, I want to display posts ...
1
vote
1answer
521 views
Query all posts where a meta key does not exist
I am trying to get a query to retrieve all the posts where a specific meta_key does not exist and then create it.
I am having problems finding those posts as the query I am testing does not seem to ...
0
votes
1answer
162 views
How to insert multiple postmeta values with one query?
I have a custom script/plugin I am using for myself that creates a post along with some postmeta information. Right now, I have multiple $wpdb->insert, but I would like to condense this down into ...
0
votes
1answer
191 views
WP_Query meta compare must include ALL array values
I am allowing users to query posts using a form with checkboxes. I want the posts to be filtered by the checkboxes but instead of showing all posts that include the ANY of the meta values selected I ...
1
vote
1answer
205 views
is there a way to show the the post title after the image?
Trying to show the post title after the image in the main blog page and single page, I have tried to edit the content.php but unable to achive the result I need, which is basiscally
IMAGE
TITLE
META ...
1
vote
0answers
78 views
How to increase load time of an archive/search page (WP_Query)
I'm currently looking at why the archive and search pages take so long to use, and have found that the bulk of processing time is spent on the query_posts that is called before the template has even ...
2
votes
2answers
128 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
2answers
84 views
Author Page Custom Query WHERE author OR [post meta value] OR [post meta value]
I am currently trying to perform a custom query on the authors page (author.php). I have two custom fields for posts that I want to query against (post_photographer and post_videographer).
What I am ...
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
2answers
455 views
How Do I Use WP_Query to Run This Database Query as Search Result?
I have created a search box with a drop down box of 4 options to customize the search:
A general default search, no filter
A custom search according to the post title for a custom post type only.
A ...
0
votes
1answer
151 views
Pull post meta with post_query?
I'm building a custom index loop that just uses query_posts at the moment.
The issue is that inside The Loop, I have to then query for the post meta data (with get_post_meta), which I believe has ...
1
vote
1answer
1k views
How do I use wp_query for WordPress search?
I would like to create a custom search form to search posts based on the values of about 4 custom fields. I tried using wp_query to achieve this but so far my biggest problem is that the I don't get ...
1
vote
2answers
439 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' => ...
0
votes
1answer
43 views
Adjust query on single
I am building an event manager. One of the template files I have is events-single.php which displays single events. At the bottom of this I have next and previous events using next_post_link and ...
1
vote
1answer
549 views
order by numeric value for meta value
I have read countless posts on ordering data by numeric value ( as opposed to string - it i have a numeric meta value and it gets ordered like this 1 11 12 2 233 etc as opposed to the way i want it
I ...
1
vote
3answers
2k views
Custom URl parameter
i have Wp blog that need to receive a custom paramter on category page for filter the posts like my rule.
For example:
http://mysite.com/category/teste?myvar=ABC
How can I get the myvar from ...
1
vote
1answer
288 views
orderby in custom WP Query does not work
I have this query:
$new = new WP_Query(array('post_type'=>'support','order'=>'DESC', 'meta_key'=>'post_views_count', 'orderby'=> 'meta_value_num', 'posts_per_page'=>'20'));
the ...
0
votes
1answer
357 views
search serialised meta_value for date value?
i've saved and array of 'open days' as a serialised array in a meta value.
I was hoping i could then just search this field for the selected dates but i can't seem to create a match.
serialised = ...
1
vote
1answer
183 views
Metadata Query when storing data as array possible?
Suppose I store all my post meta data in an array like
$meta = array(
'img' => '',
'caption' => ''
);
update_post_meta($post->ID, 'theme_banner', $meta);
Can I query posts where ...
2
votes
1answer
936 views
meta_query: using BETWEEN with floats and/or casting to DECIMAL
Each post has a lat/lng value attached to it via postmeta. I'm trying to grab all posts within a bounding lat/lng value. Here's the get_posts query:
$posts = get_posts(array(
'posts_per_page' ...
1
vote
2answers
2k views
Wordpress Orderby Numeric Value Not Working
I am trying to get all products from the wpsc-product post type and then display them by a custom meta field called release_date_year. However, it doesn't appear to be ordering my posts by this custom ...
7
votes
4answers
8k views
How can I show posts only if meta_value is not empty
Three people have already tried to solve this, and we're coming up nil. I want to show only posts that have a value in the meta_key 'featured_image'.
So... if 'featured_image' is not empty, show the ...
2
votes
3answers
3k views
WP_Query, custom sort and custom filter
Is it possible using WP_Query to return a filtered list of items based on the following criteria set? I seem to be struggling as there are numerous queries against custom fields.
Select all posts ...
1
vote
1answer
639 views
Custom wp_query time filter on meta_value
My goal is to only show posts with opening hours after business hours, for a given day. So, e.g. I have a (custom) post with following meta_key and meta_value:
meta_key = 'monday, meta_value = '14:00 ...
0
votes
1answer
596 views
How should I use posts_where to change meta_value from a string to integer?
How should I use posts_where to change meta_value from a string to integer?
