When i'm goingo to add Roles(The roles the user has.) in filter criteria the system return the following error:
Column not found: 1054 Unknown column 'user__roles.roles' in 'where clause': SELECT COUNT(*) AS expression FROM (SELECT 1 AS expression FROM {users_field_data} users_field_data LEFT JOIN {user__roles} user__roles ON users_field_data.uid = user__roles.entity_id WHERE (users_field_data.default_langcode = :db_condition_placeholder_0) AND (users_field_data.uid != :db_condition_placeholder_1) AND (user__roles.roles LIKE :db_condition_placeholder_2 ESCAPE '\\')) subquery; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => 0 [:db_condition_placeholder_2] => )
Comment | File | Size | Author |
---|---|---|---|
Screenshot-2018-2-22 Aziende da approvare (User).png | 16.45 KB | federicopalma |
Comments
Comment #2
DamienMcKennaViews was moved into core in D8, so I'm moving the issue over to its issue queue.
Comment #3
msankhala CreditAttribution: msankhala as a volunteer and at Srijan | A Material+ Company commented@federicopalma Can you please provide steps to reproduce this issue?
Comment #4
ankitjain28may CreditAttribution: ankitjain28may as a volunteer and at Google Summer of Code commented@federicopalma Yes, I am unable to reproduce this error, It would be great if you provide steps to reproduce this bug.
Comment #5
SKAUGHTusing simplytest.me with 8.5r1.
i've looked at /admin/people (which is a view page). Added a role through normal UI. The exposed filter works as expected, no pdo column notices.
Comment #6
SKAUGHTComment #7
bdlangton CreditAttribution: bdlangton commentedAlso not reproducible by me. Closing, but please open back up if you are able to list out steps to reproduce.