Wordpress Query Attachments with ACF field

Question

I'm trying to return all the images within the media library that have a custom field with the value of True.

For some reason nothing is being returned, this is what I have so far:

function showPainted() {
    $query_images_args = array(
        'post_type'      => 'attachment',
        'post_mime_type' => 'image',
        'post_status'    => 'inherit',
        'posts_per_page' => - 1,
        'meta_key'      => 'show_on_painted_page',
        'meta_value'    => '1'
    );

    $query_images = new WP_Query( $query_images_args );
    $images = array();
    foreach ( $query_images->posts as $image ) {
        $images[] = wp_get_attachment_url( $image->ID );
    }

    print_r($images);
}
add_shortcode( 'showPainted', 'showPainted' );

Can anyone help me with this one?

`print_r($query_images)` and check the results. – Gufran Hasan Sep 13 '18 at 09:21 — Gufran Hasan, Sep 13 '18 at 09:21

Gufran Hasan · Answer 1 · 2018-09-13T09:49:39.383

2

Please change your query agrs as:

$query_images_args = array(
            'post_type'      => 'attachment',
            //'post_mime_type' => 'image',
            'post_status'    => 'any',
            'posts_per_page' => -1,
            'meta_key'      => 'show_on_painted_page',
            'meta_value'    => true
        );

        $query_images = new WP_Query( $query_images_args );

edited Sep 13 '18 at 09:49

answered Sep 13 '18 at 09:26

Gufran Hasan

8,910
7
38
51

Unfortunately, this hasn't worked, it's still returning nothing. – WebDevB Sep 13 '18 at 09:45
Did you print this as `print_r($query_images)`? – Gufran Hasan Sep 13 '18 at 09:46
Yea, ` [post_count] => 0` – WebDevB Sep 13 '18 at 09:47
check meta_key `show_on_painted_page` in database postmeta table that meta_value is 1 or true and then pass that value in your query. – Gufran Hasan Sep 13 '18 at 09:55

score 0 · Answer 2 · answered Sep 13 '18 at 09:29

Try something like this:

$query_images_args = array(
    'post_type'         => 'attachment',
    'post_mime_type'    => 'image',
    'post_status'       => 'inherit',
    'posts_per_page'    => - 1,
    'meta_key'          => 'show_on_painted_page',
    'meta_query'        => array(
        array(
            'key'       => 'show_on_painted_page',
            'value'     => 1,
            'compare'   => '='
        ),
    ),
);

Check https://codex.wordpress.org/Class_Reference/WP_Query for more informations.

Unfortunately, this hasn't worked, it's still returning nothing. — WebDevB, Sep 13 '18 at 09:45

Wordpress Query Attachments with ACF field

2 Answers2