Creating (Complex?) Custom Queries for Wordpress compatible with Visual Composer

0
votes

I'm struggling to make two custom queries for visual composer:

  1. a query which will display posts which are published with a date after today's date (have plugin which publishes future posts) in Ascending or descending order (whichever makes it show the soonest upcoming event first)

  2. a query which will display only posts which meet multiple category requirements (eg. categories 'upcoming' and 'class' or 'upcoming' and 'social'

Really, either of these should give me the results I want, but the first would be most convenient.

I can't for the life of me decipher the Codex's page on custom queries and figure out how to get them to work outside of the context of a php page, and in the context of the visual compose.

One thought I had is that perhaps I need to add a custom query to my functions.php that has a name, and then call the query with the variables from Visual Composer? Is that the right idea? How would I do such a thing/call the new query?

I've tried the following to satisfy #1 and it seems to have disregarded the query altogether and just displayed all the events:

[vc_basic_grid post_type="custom" grid_id="vc_gid:1473741223498-3776c0d3-292b-4" custom_query="WP_Query( ''showposts=20&monthnum=' . date_query( array( 'after', . NOW() . ) ) . '&order_by=date&order=DESC')"]

[vc_separator]

[vc_basic_grid post_type="custom" grid_id="vc_gid:1473741223504-67e7758b-8892-6" custom_query="$args = array(
'date_query' => array(
array(
'after' => NOW(),
'inclusive' => true,
),
),
'posts_per_page' => -1, 'order_by' => 'date', 'order' => 'ASC'
);
$query = new WP_Query( $args );"]

Would love some nudges in the right direction! Thank you :)

1
phpwordpressvisual-composer

1 Answers

0
votes

I did something similar not too long ago and used the following as far as the date & making sure it only pulled posts from "today" and in the future.

_EventStartDate=>$today

That was for pulling upcoming events for a custom post type. With that said, this code is for your scenario which is retrieving normal posts:

date=>$today

Here's my whole custom query that works to pull events but I'm stuck on trying to figure out how to pull from multiple categories as well:

post_type=tribe_events&tribe_events_cat=featured&post_status=publish&_EventStartDate=>$today&orderby=_EventStartDate&order=asc

Please follow up once you have a solution.