Important: The following only works for WooCommerce versions less than 3.0. For a more up-to-date answer please see the other answer by kalle. WooCommerce save this data as metadata so you’ll need to run a Meta Query against the name _visibility. Something like: ‘meta_query’ => array( array( ‘key’ => ‘_visibility’, ‘value’ => ‘hidden’, ‘compare’ => … Read more
I created a plugin which does something similar (called Multisite Post Display https://wordpress.org/plugins/multisite-post-reader/ ) . It displays posts from all multisite sub-sites. The code in there might be helpful for what you are doing. You are welcome to dig into it and use the code to help with your project. (After all, I used other … Read more
To be able to use the comments template in your loops, add global $withcomments; $withcomments = true;
According to https://codex.wordpress.org/Class_Reference/WP_Query#Order_.26_Orderby_Parameters you want to specify it similar to the following code example: $args = array( ‘orderby’ => array( ‘title’ => ‘DESC’, ‘menu_order’ => ‘ASC’ ) ); $query = new WP_Query( $args ); This is supported from WordPress 4.0. For custom fields (post meta) you will need an added meta query, as detailed on … Read more
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