First of all, you run register_post_type on init and register_taxonomy on after_setup_theme which is called after init. This means your custom taxonomy will not be available when registering the post type. I would suggest you remove the taxonomies keyword from the register_post_type arguments array, and just register the taxonomy manually afterwards. In your example code … Read more
WP_Query::reset_postdata() sets the global post variable ($GLOBALS[‘post’] === $post) to the current post in the loop of the current WP_Query instance. public function reset_postdata() { if ( ! empty( $this->post ) ) { $GLOBALS[‘post’] = $this->post; $this->setup_postdata( $this->post ); } } What that means is that, if you run a custom query on a page, … Read more
Below is the query I found somewhere and was going through it. The purpose of query is to sort the posts based on taxonomy. So, I am sharing the code so it might help you understand the use of posts_clauses. function color_clauses_mike( $clauses, $query ) { global $wpdb; if ( isset( $query->query[‘orderby’] ) && ‘color’ … Read more
I got curious about the SQL way of finding all posts without any attachments. Method #1 – Sub query with NOT IN Here’s my first attempt to construct such a query: global $wpdb; $sql = ” SELECT p1.ID, p1.post_title FROM {$wpdb->posts} p1 WHERE p1.post_type=”post” AND p1.post_status=”publish” AND p1.ID NOT IN ( SELECT DISTINCT p2.post_parent FROM … Read more
Sorry for answering my own question but it may help some other devs too. I created this additional filter ‘json_query_var-meta_query’that returns the necessary arguments. function adjustQrry($data){ $args = array(); $args[‘relation’] = ‘AND’; foreach ($data as $key=>$value) { if ( ‘relation’ === $key ) { $args[‘relation’] = $data[‘relation’]; } if ( substr($key, 0, 3) === ‘key’ … Read more
We can filter the posts_where clause of the generated SQL to also return the parent post/page and not just the parent’s children. Here we will set our own custom argument called wpse_include_parent, which, when set to true, will alter the generated SQL accordingly. All we need to do inside our posts_where filter is to check … Read more
Did you check what part of is_front_page() is causing it to return false? I could reproduce the problem by following the setup from the trac ticket. In my case inside this function the call to is_page() was returning false. I guess this is due to using $wp_query->set() for page_id and is_page is only causing the … Read more
There is no need to do an overrated amount of queries to accomplish this. you can still use only one query, the_posts filter and some PHP to sort your code as needed. I take that this is a custom query from what I read in your question, so we can do the following: First, we … Read more
I am updating my complete answer based on your clarification in the comment below. I hope this helps: <div class=”entry-content”> <h2>Documents written by this writer</h2> <?php /* * Query posts for a relationship value. * This method uses the meta_query LIKE to match the string “123” to the database value a:1:{i:0;s:3:”123″;} (serialized array) */ $documents … Read more
If you hook your localize script function to wp_enqueue_scripts, then you will have access to the global $post variable. As long as you pick a hook at or after ‘wp’ you should have access to the global $post. <?php add_action(‘wp_enqueue_scripts’, ‘YOUR_NAME_scripts’); function YOUR_NAME_scripts() { wp_enqueue_script(‘YOUR_NAME-js’); global $post; $params = array( ‘site_url’ => site_url(), ‘admin_ajax_url’ => … Read more