Support

Account

Home Forums ACF PRO How to use WP_Query or search multiple user field

Helping

How to use WP_Query or search multiple user field

  • Hi, I have a custom post type named : course , and I add a ACF field name: liked_user type: user, multiple:true

    I want to ask how to search the user`s (id = 2) all liked posts?

    thanks

    {
        "key": "group_5a5457efb569d",
        "title": "Course",
        "fields": [
            {
                "key": "field_5a5457f85a52f",
                "label": "Liked User",
                "name": "liked_user",
                "type": "user",
                "instructions": "",
                "required": 0,
                "conditional_logic": 0,
                "wrapper": {
                    "width": "",
                    "class": "",
                    "id": ""
                },
                "role": "",
                "allow_null": 0,
                "multiple": 1
            }
        ],
        "location": [
            [
                {
                    "param": "post_type",
                    "operator": "==",
                    "value": "asena_course"
                }
            ]
        ],
        "menu_order": 0,
        "position": "normal",
        "style": "default",
        "label_placement": "top",
        "instruction_placement": "label",
        "hide_on_screen": "",
        "active": 1,
        "description": "",
        "modified": 1515477054
    }
  • Hi. I have done something similar. I added a field to regular posts where a user can be selected. This is used to ‘mention’ a certain user. On their profile I retrieve the posts again in which they got mentioned.

    See https://internationaldownhillfederation.org/member/emily-pross/
    Halfway down. User is mentioned in these posts.
    What you’re looking at is an author.php archive so this is a separate query because a user is mentioned in those posts, they didn’t write it.

    My profile shows both mentioned and posts I wrote.

    So here we go 🙂

    First of all, Can you add only 1 user per post ??? Looks like it (I can be wrong). Why not make a repeater out of that field with 1 sub field; which is user.

    My field is called tagged_riders.
    This is a repeater with 1 sub-field (member).
    Member is a user object field.

    /**
     * Get posts in which user is mentioned
     * @param bool $user_id
     *
     * @return bool|array
     */
    function get_user_mentions( $user_id = false ) {
        
        if ( false == $user_id ) {
            return false;
        }
    
        global $wpdb;
        $rows = $wpdb->get_results( $wpdb->prepare(
            "
                SELECT *
                FROM {$wpdb->prefix}postmeta
                WHERE meta_key LIKE %s
                AND meta_value = %s
                ", 'tagged_riders_%_member', // meta_name: $ParentName_$RowNumber_$ChildName
            $user_id ) );
        
        if ( $rows ) {
            $post_ids = array();
            foreach ( $rows as $row ) {
                $post_ids[] = intval( $row->post_id );
            }
    
            return $post_ids;
        
        }
        
        return false;
    
    }

    Keep in mind my fields are called tagged_riders with a subfield member. You need to change these to fit your needs.

    Get all post_ids like this: get_user_mentions( $user_id ), where $user_id is the ID you want to check.

    The results is an array of post_ids in which the user liked.

    Hope this helps.

Viewing 2 posts - 1 through 2 (of 2 total)

The topic ‘How to use WP_Query or search multiple user field’ is closed to new replies.