Count custom post type based on two meta data

Question

I am trying to count my custom post type called 'appointments' that match two meta data values .

The meta data keys are 'location' and 'timestamp'

So in english my query is: How many appointments are scheduled at Location at Time

How can this be done?

Answer 1

$args = array(
    'post_type'  => 'appointments',
    'meta_query' => array(
        'relationship' => 'AND',
        array(
            'key'   => 'location',
            'value' => $place //set this somewhere
        ),
        array(
            'key'   => 'timestamp',
            'value' => $time //set this somewhere
        )
    )
);
$posts = new WP_Query( $args );

Docs: WP_Query

You have the flexibility to add just about anything else you need to that, for example, post_status.