This question is a follow up to a question I recently asked. I’ve implemented what seemed to be the only solution, and it seems to work (YAY!). I just need to verify that: This is really the only way to modify the query to match with a match to the (post_title OR post_content OR any … Read more
I have looked at many posts and questions regarding searches for custom meta, but I want to search for posts and include those if the search query matches an author name. I have come up with the following code but it is not working. For some reason, it returns posts with status “revision” First, I … Read more
Some of my posts (not all) have a price as a meta key/value. Today I use the pre_get_posts action so that my users can search for prices that are between a certain value. This is the code that I’m using today, and it’s working. add_action(‘pre_get_posts’, ‘my_search_price’); function my_search_price( $query ) { if ($query->get(‘maxprice’) != “” … Read more
I’m creating a function that displays the most viewed posts and would like to be able to show posts based on how old they are. Modifying the query is not really a problem. But since I can’t pass any arguments to the function I can’t modify the “-30 days” part. function print_stuff($args) { add_filter( ‘posts_where’, … Read more
I’m storing posts, a user follows in a custom table that has the columns id, post_id and user_id. To fetch posts that a user follows I have extended the WP_Query as follows: class WP_Query_Posts_User_Follows extends WP_Query { function __construct($args=array()) { if ( !empty($args[‘followed_by’]) ) { $this->followed_by = $args[‘followed_by’]; add_filter(‘posts_where’, array($this, ‘posts_where’)); } parent::query($args); } function … Read more
This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center. Closed 9 years … Read more
Hi I’m working on a store locator. I have a custom post “clinics” where I save clinic details (address,.., lat, lng). Each time I publish a new clinic I save post_id, lat and lng also in a custom table “lat_lng_post”. I’m able to search clinics within a specific distance using filter post_where in this way: … Read more
I’m almost there on this one. On functions.php i have this: function base_home_product_post_type( $query ) { if($query->is_search() && $_POST[‘box’] == ‘sku’) { $query->query_vars[‘post_type’] = ‘product’; $query->query_vars[‘meta_key’] = ‘sku’; $query->query_vars[‘meta_value’] = $query->query_vars[‘s’]; return; } } add_action(‘pre_get_posts’, ‘base_home_product_post_type’, 1); And it does what it’s told. Searches for the search string on the meta_key ‘sku’. Problem here is … Read more
I want to know which filter hook I should use that performs faster. I did try both several times and I noticed that posts_search is a bit faster than using the combination of posts_where and posts_join What is your take on this? 1 Answer 1 All of these hooks are called in a similar fashion … Read more
I am running into one issue with pre_get_post filter. Actually I have 4 post types. Post, Pages, Events, and Venue. I created one custom field called city for event and venue post type. When creating custom field I have one option to select post type on which I want to display that custom field. Now, … Read more
