How to filter views results based on entity reference field

Question

I use Drupal 7 and entityreference module. I have a content type with a entity refenrece field to users called field_users_referenced.

So I created a view with views module and list nodes of thats content type. I want to order this views result based on field_users_referenced.

when I add field_users_referenced field on filter fields, and set it for exposed filter , after type a field_users_referenced value on thats field, have no any result.

I do not want to filter field_users_referenced with select box, I want to type value on exposed filter field and order results.

please help me.

Answer 1

Advance View Settings -> Add Relationship -> Select Entity Reference Field

Then in filters -> add Filter-> Select field from the respective entity.

Thanks

Answer 2

In Drupal 8, you can do one of the following. These are in order from more recommended to less recommended:

1. Apply the latest core patch from Generalize TaxonomyIndexTid filter to be available for all entity reference fields (unless it's been committed by the time you're reading this),
2. Use the Entity Reference Exposed Filters module, or
3. Follow the instructions in Entity reference filter with Drupal 8, which require custom code.

Answer 3

You have to add your entity reference field as a relation to the view, and then you can use the fields from the User entity type in you filter section and configure it/them as you please.

Answer 4

Based on of the @Colan solution. Add the following Patch to your composer.json file

"extra": {
    "patches": {
        "drupal/core": {
            "View Entity Reference Field" : "https://www.drupal.org/files/issues/2019-12-24/drupal-generalize-taxonomyindextid-filter-2429699-277.patch"
        }
    }
}

then run composer install and Rebuild the cache.

Answer 5

There is another way for Drupal8. Try using the verf module