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] => )

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

federicopalma created an issue. See original summary.

DamienMcKenna’s picture

Project: Views (for Drupal 7) » Drupal core
Version: 8.x-3.x-dev » 8.6.x-dev
Component: user data » views.module

Views was moved into core in D8, so I'm moving the issue over to its issue queue.

msankhala’s picture

@federicopalma Can you please provide steps to reproduce this issue?

ankitjain28may’s picture

@federicopalma Yes, I am unable to reproduce this error, It would be great if you provide steps to reproduce this bug.

SKAUGHT’s picture

Priority: Critical » Minor

using 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.

SKAUGHT’s picture

Priority: Minor » Normal
bdlangton’s picture

Status: Active » Closed (cannot reproduce)

Also not reproducible by me. Closing, but please open back up if you are able to list out steps to reproduce.