One way is to use the offset parameter in WP_Query, but it overrides the paged parameter according to the docs. Example formula for an offset with pagination: ‘posts_per_page’ => $posts_per_page, ‘offset’ => ( $paged – 1 ) * $posts_per_page + $offset_per_page, Example: Then for $posts_per_page as 4 and $offset_per_page as 5 we get the post … Read more
I resolved this by adding ‘post_status’ => ‘draft’ to the $args array, as below $args = array( ‘meta_query’ => array( array( ‘key’ => ‘sending_time’, ‘value’ => ‘on_registration’, ‘compare’ => ‘=’, ) ), ‘post_type’ => ‘_jq_notifications’, ‘posts_per_page’ => -1, ‘post_status’ => ‘draft’ ); The custom post type “_jq_notifications” default status was draft. The documentation here says … Read more
Blog post per page setting conflicting with custom WP_Query?
How to display multiple custom fields with the same meta_key in an ascending order?
This is not possible, you cannot query sub-values of serialised/structured data in post meta values. To fix this, you need to store the dates you want to query/filter by as separate post meta key/value pairs. Values need to be string/number/boolean whole values to be queried this way. They cannot be complex structures or sub-strings, such … Read more
Set multiple Post Terms in same Taxonomy
Serve specific “template” page at any URL that ends in its slug
How can I create ‘future’ and ‘past’ parameter for restAPI by filtering the CPT custom date field by greater than / less than current datetime?
Try: $arrPosts = $wpdb->get_results($sql); That said, note that there also is an API to get these two. See in particular: get_next_post() get_previous_post()
See this question and my answer there query_posts ->using meta_compare / where meta value is smaller or greater or equals… Basically for the purpose of meta comparison value is always treated as string, because it is passed as such to $wpdb->prepare() method.