Bug: Member directory admin filtering not possible with choices callback feature

@mvereijken

Make a User Registration with Home City Amsterdam and you can select Amsterdam in the City dropdown. The City dropdown is based on actaul Registrations in your DB.

@missveronicatv

Do you mean that only options are shown that have results?

I don’t think this is the problem as it works correctly in the frontend filters and when registering. In addition, there are various accounts that are linked to, for example, Amsterdam

Update: It seems that disabling setting ‘parent option’ in the city custom field fixes the problems. Is there a downside to deactivating this setting?

Unfortunately, this causes the filter options to no longer work properly. All cities are now shown instead of the cities within the selected country. I have tried to convert the PHP function in such a way that all cities are always shown within WP-admin, but unfortunately without success. Could a plugin maker advise me on how to fix this?

@mvereijken

What meta_key name are you using for the country names?

@missveronicatv the meta_key I use: location_country

Hello @mvereijken

Sorry for the late answer. Try to add this hook (please change the metakey here to your city metakey – ‘location_city’ === $attrs[‘metakey’] ):

add_filter( 'um_member_directory_filter_select_options_sorted', 'custom_um_member_directory_filter_select_options_sorted', 10, 2 );
function custom_um_member_directory_filter_select_options_sorted( $options, $attrs ){
    if ( 'location_city' === $attrs['metakey'] ){
	    if ( ! empty( $attrs['custom_dropdown_options_source'] ) && ! empty( $attrs['parent_dropdown_relationship'] ) ) {
            global $wpdb;
		    $values_array = $wpdb->get_col(
			    $wpdb->prepare(
				    "SELECT DISTINCT meta_value
								FROM $wpdb->usermeta
								WHERE meta_key = %s AND
									  meta_value != ''",
				    $attrs['metakey']
			    )
		    );

		    if ( ! empty( $values_array ) && in_array( $attrs['type'], array( 'select', 'multiselect', 'checkbox', 'radio' ) ) ) {
			    $values_array = array_map( 'maybe_unserialize', $values_array );
			    $temp_values = array();
			    foreach ( $values_array as $values ) {
				    if ( is_array( $values ) ) {
					    $temp_values = array_merge( $temp_values, $values );
				    } else {
					    $temp_values[] = $values;
				    }
			    }

			    $values_array = array_unique( $temp_values );
		    }

		    $options = UM()->fields()->get_options_from_callback( $attrs, $attrs['type'] );
		    $options = array_intersect_key( array_map( 'trim', $options ), array_flip( $values_array ) );
	    }
    }

    return $options;
}

Regards.

Hi @mvereijken

This thread has been inactive for a while so we’re going to go ahead and mark it Resolved.

Please feel free to re-open this thread if any other questions come up and we’d be happy to help. ??

Regards