Filter by ACF Field Value #6

der-lukas · 2015-12-19T23:03:03Z

Hey! Thanks for this great plugin!

I already had a look at the other issues here, but still can't get it to work...

I want to get all the posts from the CPT "calendar" with a specific ACF-Field Value.

Would it be possible to request it like this:
".../wp-json/wp/v2/calendar/?meta_key=land&meta_value=de-AT"

Thanks in advance!

Lukas

airesvsg · 2015-12-20T04:09:19Z

Hi @der-lukas,
add the code below in your functions.php.

Register the queries vars:

add_filter( 'rest_query_vars', function( $valid_vars ) {
    return array_merge( $valid_vars, array( 'meta_query', 'meta_key', 'meta_value' ) );
} );

Adding parameters to filter:

add_filter( 'rest_post_query', function( $args, $request ) {
    $key   = $request->get_param( 'meta_key' );
    $value = $request->get_param( 'meta_value' );

    if ( 'land' == $key && ! empty( $value ) ) {
        $args['meta_query'] = array(
            array(
                'key'     => $key,
                'value'   => $value,
                'compare' => '=',
            )
        );      
    }

    return $args;
}, 10, 2 );

Cheers

der-lukas · 2015-12-20T10:07:53Z

Awesome! Thank you so much!

airesvsg · 2015-12-20T16:15:09Z

@der-lukas if you want a most friendly url, like: /wp-json/wp/v2/calendar/?land=de-AT. You can do this:

add_filter( 'rest_query_vars', function ( $valid_vars ) {
    return array_merge( $valid_vars, array( 'land', 'meta_query' ) );
} );

add_filter( 'rest_post_query', function( $args, $request ) {
    $land   = $request->get_param( 'land' );

    if ( ! empty( $land ) ) {
        $args['meta_query'] = array(
            array(
                'key'     => 'land',
                'value'   => $land,
                'compare' => '=',
            )
        );      
    }

    return $args;
}, 10, 2 );

der-lukas · 2015-12-21T07:51:24Z

Oh, that's perfect! This way it's also possible to use multiple filters! :) Thanks!

airesvsg · 2015-12-21T13:32:17Z

😄 👍

danilopaulinodasilva · 2018-01-22T12:56:58Z

This is not working for multiple filters :(

I'm trying to /wp-json/wp/v2/posts/?city=SP&state=SP
And /wp-json/acf/v3/posts/?city=SP&state=SP

Have tried duplicate the function also pass an array in multiple points of it, nothing have worked. :/

airesvsg · 2018-01-22T13:14:26Z

Hello @danilopaulinodasilva,

I'm not give support for this version, please up to date for the most recent version in the link below.

https://github.com/airesveg/acf-to-rest-api

Thanks

danilopaulinodasilva · 2018-01-22T13:16:13Z

Hello,

But...I'm using the last version (3.1.0) already?

Oh, sorry I'm talking about this thread: airesvsg/acf-to-rest-api#123

I'll comment in the right place, sorry :)

mkchetan25 · 2020-04-21T03:28:04Z

@airesvsg
I'm new to wordpress and using "ACF to REST" plugin and have a post_type in relation. Here is the schema:

[
    {
        "id": 1848,
        "date": "2020-04-20T18:08:45",
        "date_gmt": "2020-04-20T18:08:45",
        "guid": {
            "rendered": "http://localhost/wordpress/?post_type=state&#038;p=1848"
        },
        "modified": "2020-04-20T18:08:45",
        "modified_gmt": "2020-04-20T18:08:45",
        "slug": "karnataka",
        "status": "publish",
        "type": "state",
        "link": "http://localhost/wordpress/state/karnataka/",
        "title": {
            "rendered": "Karnataka"
        },
        "content": {
            "rendered": "",
            "protected": false
        },
        "featured_media": 0,
        "template": "",
        "acf": {
            "state": "karnataka",
            "country": [
                {
                    "ID": 1832,
                    "post_author": "1",
                    "post_date": "2020-04-17 11:02:42",
                    "post_date_gmt": "2020-04-17 11:02:42",
                    "post_content": "",
                    "post_title": "India",
                    "post_excerpt": "",
                    "post_status": "publish",
                    "comment_status": "closed",
                    "ping_status": "closed",
                    "post_password": "",
                    "post_name": "india",
                    "to_ping": "",
                    "pinged": "",
                    "post_modified": "2020-04-17 11:02:43",
                    "post_modified_gmt": "2020-04-17 11:02:43",
                    "post_content_filtered": "",
                    "post_parent": 0,
                    "guid": "http://localhost/wordpress/?post_type=countries&#038;p=1832",
                    "menu_order": 0,
                    "post_type": "countries",
                    "post_mime_type": "",
                    "comment_count": "0",
                    "filter": "raw"
                }
            ]
        },
        "_links": {
            "self": [
                {
                    "href": "http://localhost/wordpress/wp-json/wp/v2/state/1848"
                }
            ],
            "collection": [
                {
                    "href": "http://localhost/wordpress/wp-json/wp/v2/state"
                }
            ],
            "about": [
                {
                    "href": "http://localhost/wordpress/wp-json/wp/v2/types/state"
                }
            ],
            "wp:attachment": [
                {
                    "href": "http://localhost/wordpress/wp-json/wp/v2/media?parent=1848"
                }
            ],
            "curies": [
                {
                    "name": "wp",
                    "href": "https://api.w.org/{rel}",
                    "templated": true
                }
            ]
        }
    }
]

Though, I added the filter in functions.php to filter by ACF field "country", doesn't work for me.

add_filter( 'rest_query_vars', function( $valid_vars ) {
    return array_merge( $valid_vars, array( 'meta_query', 'meta_key', 'meta_value' ) );
} );

add_filter( 'rest_state_query', function( $args, $request ) {
    $key   = $request->get_param( 'meta_key' );
    $value = $request->get_param( 'meta_value' );

    if ( 'country' == $key && ! empty( $value ) ) {
        $args['meta_query'] = array(
            array(
                'key'     => $key,
                'value'   => $value,
                'compare' => '=',
            )
        );
    }

    return $args;
}, 10, 2 );

==================================
Query: wp-json/wp/v2/state?meta_key=country&meta_value=India
Can you please help me on this?

Shafran123 · 2020-11-16T11:55:48Z

@airesvsg
I'm new to wordpress and using "ACF to REST" plugin and have a post_type in relation. Here is the schema:

[
    {
        "id": 1848,
        "date": "2020-04-20T18:08:45",
        "date_gmt": "2020-04-20T18:08:45",
        "guid": {
            "rendered": "http://localhost/wordpress/?post_type=state&#038;p=1848"
        },
        "modified": "2020-04-20T18:08:45",
        "modified_gmt": "2020-04-20T18:08:45",
        "slug": "karnataka",
        "status": "publish",
        "type": "state",
        "link": "http://localhost/wordpress/state/karnataka/",
        "title": {
            "rendered": "Karnataka"
        },
        "content": {
            "rendered": "",
            "protected": false
        },
        "featured_media": 0,
        "template": "",
        "acf": {
            "state": "karnataka",
            "country": [
                {
                    "ID": 1832,
                    "post_author": "1",
                    "post_date": "2020-04-17 11:02:42",
                    "post_date_gmt": "2020-04-17 11:02:42",
                    "post_content": "",
                    "post_title": "India",
                    "post_excerpt": "",
                    "post_status": "publish",
                    "comment_status": "closed",
                    "ping_status": "closed",
                    "post_password": "",
                    "post_name": "india",
                    "to_ping": "",
                    "pinged": "",
                    "post_modified": "2020-04-17 11:02:43",
                    "post_modified_gmt": "2020-04-17 11:02:43",
                    "post_content_filtered": "",
                    "post_parent": 0,
                    "guid": "http://localhost/wordpress/?post_type=countries&#038;p=1832",
                    "menu_order": 0,
                    "post_type": "countries",
                    "post_mime_type": "",
                    "comment_count": "0",
                    "filter": "raw"
                }
            ]
        },
        "_links": {
            "self": [
                {
                    "href": "http://localhost/wordpress/wp-json/wp/v2/state/1848"
                }
            ],
            "collection": [
                {
                    "href": "http://localhost/wordpress/wp-json/wp/v2/state"
                }
            ],
            "about": [
                {
                    "href": "http://localhost/wordpress/wp-json/wp/v2/types/state"
                }
            ],
            "wp:attachment": [
                {
                    "href": "http://localhost/wordpress/wp-json/wp/v2/media?parent=1848"
                }
            ],
            "curies": [
                {
                    "name": "wp",
                    "href": "https://api.w.org/{rel}",
                    "templated": true
                }
            ]
        }
    }
]

Though, I added the filter in functions.php to filter by ACF field "country", doesn't work for me.

add_filter( 'rest_query_vars', function( $valid_vars ) {
    return array_merge( $valid_vars, array( 'meta_query', 'meta_key', 'meta_value' ) );
} );

add_filter( 'rest_state_query', function( $args, $request ) {
    $key   = $request->get_param( 'meta_key' );
    $value = $request->get_param( 'meta_value' );

    if ( 'country' == $key && ! empty( $value ) ) {
        $args['meta_query'] = array(
            array(
                'key'     => $key,
                'value'   => $value,
                'compare' => '=',
            )
        );
    }

    return $args;
}, 10, 2 );

==================================
Query: wp-json/wp/v2/state?meta_key=country&meta_value=India
Can you please help me on this?

same issue for me

airesvsg closed this as completed Dec 20, 2015

airesvsg added the help wanted label Dec 20, 2015

pakoArtal mentioned this issue Feb 26, 2016

Filter by ACF Field Value airesvsg/acf-to-rest-api#13

Closed

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Filter by ACF Field Value #6

Filter by ACF Field Value #6

der-lukas commented Dec 19, 2015

airesvsg commented Dec 20, 2015

der-lukas commented Dec 20, 2015

airesvsg commented Dec 20, 2015

der-lukas commented Dec 21, 2015

airesvsg commented Dec 21, 2015

danilopaulinodasilva commented Jan 22, 2018

airesvsg commented Jan 22, 2018 •

edited

Loading

danilopaulinodasilva commented Jan 22, 2018 •

edited

Loading

mkchetan25 commented Apr 21, 2020 •

edited

Loading

Shafran123 commented Nov 16, 2020

Though, I added the filter in functions.php to filter by ACF field "country", doesn't work for me.

Filter by ACF Field Value #6

Filter by ACF Field Value #6

Comments

der-lukas commented Dec 19, 2015

airesvsg commented Dec 20, 2015

der-lukas commented Dec 20, 2015

airesvsg commented Dec 20, 2015

der-lukas commented Dec 21, 2015

airesvsg commented Dec 21, 2015

danilopaulinodasilva commented Jan 22, 2018

airesvsg commented Jan 22, 2018 • edited Loading

danilopaulinodasilva commented Jan 22, 2018 • edited Loading

mkchetan25 commented Apr 21, 2020 • edited Loading

Though, I added the filter in functions.php to filter by ACF field "country", doesn't work for me.

Shafran123 commented Nov 16, 2020

Though, I added the filter in functions.php to filter by ACF field "country", doesn't work for me.

airesvsg commented Jan 22, 2018 •

edited

Loading

danilopaulinodasilva commented Jan 22, 2018 •

edited

Loading

mkchetan25 commented Apr 21, 2020 •

edited

Loading