# Listing users by group - ERROR: missing FROM-clause entry for table "groups"
**URL:** https://meta.discourse.org/t/listing-users-by-group-error-missing-from-clause-entry-for-table-groups/206618
**Category:** Support
**Created:** [October 21, 2021, 5:02am UTC](https://meta.discourse.org/t/listing-users-by-group-error-missing-from-clause-entry-for-table-groups/206618 "2021-10-21T05:02:32Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@omarfilip](https://meta.discourse.org/u/omarfilip)
#### Post date: [October 21, 2021, 5:02am UTC](https://meta.discourse.org/t/listing-users-by-group-error-missing-from-clause-entry-for-table-groups/206618/1 "2021-10-21T05:02:32Z")
When I filter users by group, the list still shows all users, not the selected group, and this error is shown in the log:
```plaintext
ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: missing FROM-clause entry for table "groups"
LINE 1: ..._2' WHERE "directory_items"."period_type" = 4 AND "groups"."...
```
> **info**
>
> ```plaintext
> ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: missing FROM-clause entry for table "groups"
> LINE 1: ..._2' WHERE "directory_items"."period_type" = 4 AND "groups"."...
> ^
> )
> app/controllers/directory_items_controller.rb:75:in `index'
> app/controllers/application_controller.rb:397:in `block in with_resolved_locale'
> app/controllers/application_controller.rb:397:in `with_resolved_locale'
> lib/middleware/omniauth_bypass_middleware.rb:71:in `call'
> lib/content_security_policy/middleware.rb:12:in `call'
> lib/middleware/anonymous_cache.rb:356:in `call'
> config/initializers/100-quiet_logger.rb:23:in `call'
> config/initializers/100-silence_logger.rb:31:in `call'
> lib/middleware/enforce_hostname.rb:23:in `call'
> lib/middleware/request_tracker.rb:187:in `call'
>
> ```
> **backtrace**
>
> ```plaintext
> rack-mini-profiler (2.3.3) lib/patches/db/pg.rb:72:in `exec_params'
> rack-mini-profiler (2.3.3) lib/patches/db/pg.rb:72:in `exec_params'
> activerecord (6.1.4.1) lib/active_record/connection_adapters/postgresql_adapter.rb:672:in `block (2 levels) in exec_no_cache'
> activesupport (6.1.4.1) lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
> activesupport (6.1.4.1) lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
> activesupport (6.1.4.1) lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
> activerecord (6.1.4.1) lib/active_record/connection_adapters/postgresql_adapter.rb:671:in `block in exec_no_cache'
> activerecord (6.1.4.1) lib/active_record/connection_adapters/abstract_adapter.rb:696:in `block (2 levels) in log'
> activesupport (6.1.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'
> activesupport (6.1.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
> activesupport (6.1.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
> activesupport (6.1.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
> activesupport (6.1.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
> activerecord (6.1.4.1) lib/active_record/connection_adapters/abstract_adapter.rb:695:in `block in log'
> activesupport (6.1.4.1) lib/active_support/notifications/instrumenter.rb:24:in `instrument'
> activerecord (6.1.4.1) lib/active_record/connection_adapters/abstract_adapter.rb:687:in `log'
> activerecord (6.1.4.1) lib/active_record/connection_adapters/postgresql_adapter.rb:670:in `exec_no_cache'
> activerecord (6.1.4.1) lib/active_record/connection_adapters/postgresql_adapter.rb:649:in `execute_and_clear'
> activerecord (6.1.4.1) lib/active_record/connection_adapters/postgresql/database_statements.rb:53:in `exec_query'
> activerecord (6.1.4.1) lib/active_record/connection_adapters/abstract/database_statements.rb:532:in `select'
> activerecord (6.1.4.1) lib/active_record/connection_adapters/abstract/database_statements.rb:69:in `select_all'
> activerecord (6.1.4.1) lib/active_record/connection_adapters/abstract/query_cache.rb:101:in `block in select_all'
> activerecord (6.1.4.1) lib/active_record/connection_adapters/abstract/query_cache.rb:118:in `block in cache_sql'
> activesupport (6.1.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'
> activesupport (6.1.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
> activesupport (6.1.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
> activesupport (6.1.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
> activesupport (6.1.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
> activerecord (6.1.4.1) lib/active_record/connection_adapters/abstract/query_cache.rb:109:in `cache_sql'
> activerecord (6.1.4.1) lib/active_record/connection_adapters/abstract/query_cache.rb:101:in `select_all'
> activerecord (6.1.4.1) lib/active_record/relation/calculations.rb:308:in `block in execute_simple_calculation'
> activerecord (6.1.4.1) lib/active_record/relation.rb:861:in `skip_query_cache_if_necessary'
> activerecord (6.1.4.1) lib/active_record/relation/calculations.rb:308:in `execute_simple_calculation'
> activerecord (6.1.4.1) lib/active_record/relation/calculations.rb:269:in `perform_calculation'
> activerecord (6.1.4.1) lib/active_record/relation/calculations.rb:144:in `calculate'
> activerecord (6.1.4.1) lib/active_record/relation/calculations.rb:51:in `count'
> app/controllers/directory_items_controller.rb:75:in `index'
> plugins/discourse-locations/lib/users_map.rb:23:in `index'
> actionpack (6.1.4.1) lib/action_controller/metal/basic_implicit_render.rb:6:in `send_action'
> actionpack (6.1.4.1) lib/abstract_controller/base.rb:228:in `process_action'
> actionpack (6.1.4.1) lib/action_controller/metal/rendering.rb:30:in `process_action'
> actionpack (6.1.4.1) lib/abstract_controller/callbacks.rb:42:in `block in process_action'
> activesupport (6.1.4.1) lib/active_support/callbacks.rb:117:in `block in run_callbacks'
> app/controllers/application_controller.rb:397:in `block in with_resolved_locale'
> i18n (1.8.10) lib/i18n.rb:314:in `with_locale'
> app/controllers/application_controller.rb:397:in `with_resolved_locale'
> activesupport (6.1.4.1) lib/active_support/callbacks.rb:126:in `block in run_callbacks'
> activesupport (6.1.4.1) lib/active_support/callbacks.rb:137:in `run_callbacks'
> actionpack (6.1.4.1) lib/abstract_controller/callbacks.rb:41:in `process_action'
> actionpack (6.1.4.1) lib/action_controller/metal/rescue.rb:22:in `process_action'
> actionpack (6.1.4.1) lib/action_controller/metal/instrumentation.rb:34:in `block in process_action'
> activesupport (6.1.4.1) lib/active_support/notifications.rb:203:in `block in instrument'
> activesupport (6.1.4.1) lib/active_support/notifications/instrumenter.rb:24:in `instrument'
> activesupport (6.1.4.1) lib/active_support/notifications.rb:203:in `instrument'
> actionpack (6.1.4.1) lib/action_controller/metal/instrumentation.rb:33:in `process_action'
> actionpack (6.1.4.1) lib/action_controller/metal/params_wrapper.rb:249:in `process_action'
> activerecord (6.1.4.1) lib/active_record/railties/controller_runtime.rb:27:in `process_action'
> actionpack (6.1.4.1) lib/abstract_controller/base.rb:165:in `process'
> actionview (6.1.4.1) lib/action_view/rendering.rb:39:in `process'
> rack-mini-profiler (2.3.3) lib/mini_profiler/profiling_methods.rb:111:in `block in profile_method'
> actionpack (6.1.4.1) lib/action_controller/metal.rb:190:in `dispatch'
> actionpack (6.1.4.1) lib/action_controller/metal.rb:254:in `dispatch'
> actionpack (6.1.4.1) lib/action_dispatch/routing/route_set.rb:50:in `dispatch'
> actionpack (6.1.4.1) lib/action_dispatch/routing/route_set.rb:33:in `serve'
> actionpack (6.1.4.1) lib/action_dispatch/journey/router.rb:50:in `block in serve'
> actionpack (6.1.4.1) lib/action_dispatch/journey/router.rb:32:in `each'
> actionpack (6.1.4.1) lib/action_dispatch/journey/router.rb:32:in `serve'
> actionpack (6.1.4.1) lib/action_dispatch/routing/route_set.rb:842:in `call'
> lib/middleware/omniauth_bypass_middleware.rb:71:in `call'
> rack (2.2.3) lib/rack/tempfile_reaper.rb:15:in `call'
> rack (2.2.3) lib/rack/conditional_get.rb:27:in `call'
> rack (2.2.3) lib/rack/head.rb:12:in `call'
> actionpack (6.1.4.1) lib/action_dispatch/http/permissions_policy.rb:22:in `call'
> lib/content_security_policy/middleware.rb:12:in `call'
> lib/middleware/anonymous_cache.rb:356:in `call'
> rack (2.2.3) lib/rack/session/abstract/id.rb:266:in `context'
> rack (2.2.3) lib/rack/session/abstract/id.rb:260:in `call'
> actionpack (6.1.4.1) lib/action_dispatch/middleware/cookies.rb:689:in `call'
> actionpack (6.1.4.1) lib/action_dispatch/middleware/callbacks.rb:27:in `block in call'
> activesupport (6.1.4.1) lib/active_support/callbacks.rb:98:in `run_callbacks'
> actionpack (6.1.4.1) lib/action_dispatch/middleware/callbacks.rb:26:in `call'
> actionpack (6.1.4.1) lib/action_dispatch/middleware/actionable_exceptions.rb:18:in `call'
> actionpack (6.1.4.1) lib/action_dispatch/middleware/debug_exceptions.rb:29:in `call'
> actionpack (6.1.4.1) lib/action_dispatch/middleware/show_exceptions.rb:33:in `call'
> logster (2.9.7) lib/logster/middleware/reporter.rb:43:in `call'
> railties (6.1.4.1) lib/rails/rack/logger.rb:37:in `call_app'
> railties (6.1.4.1) lib/rails/rack/logger.rb:28:in `call'
> config/initializers/100-quiet_logger.rb:23:in `call'
> config/initializers/100-silence_logger.rb:31:in `call'
> actionpack (6.1.4.1) lib/action_dispatch/middleware/remote_ip.rb:81:in `call'
> request_store (1.5.0) lib/request_store/middleware.rb:19:in `call'
> actionpack (6.1.4.1) lib/action_dispatch/middleware/request_id.rb:26:in `call'
> lib/middleware/enforce_hostname.rb:23:in `call'
> rack (2.2.3) lib/rack/method_override.rb:24:in `call'
> actionpack (6.1.4.1) lib/action_dispatch/middleware/executor.rb:14:in `call'
> rack (2.2.3) lib/rack/sendfile.rb:110:in `call'
> actionpack (6.1.4.1) lib/action_dispatch/middleware/host_authorization.rb:92:in `call'
> rack-mini-profiler (2.3.3) lib/mini_profiler/profiler.rb:393:in `call'
> message_bus (3.3.6) lib/message_bus/rack/middleware.rb:61:in `call'
> lib/middleware/request_tracker.rb:187:in `call'
> railties (6.1.4.1) lib/rails/engine.rb:539:in `call'
> railties (6.1.4.1) lib/rails/railtie.rb:207:in `public_send'
> railties (6.1.4.1) lib/rails/railtie.rb:207:in `method_missing'
> rack (2.2.3) lib/rack/urlmap.rb:74:in `block in call'
> rack (2.2.3) lib/rack/urlmap.rb:58:in `each'
> rack (2.2.3) lib/rack/urlmap.rb:58:in `call'
> unicorn (6.0.0) lib/unicorn/http_server.rb:634:in `process_client'
> unicorn (6.0.0) lib/unicorn/http_server.rb:732:i
>
> ```
> **env**
>
> |hostname|gaoa-discourse-app|
>
> ```plaintext
> |---|---|
> |process_id|26534|
> |application_version|a9d6b2380230a0ee497f4fd993b4c42107f1f75e|
> |HTTP_HOST|forum. **********.com|
> |REQUEST_URI|/directory_items?period=weekly&order=Aircraft&group=current_members&user_field_ids=2%7C36%7C37|
> |REQUEST_METHOD|GET|
> |HTTP_USER_AGENT|Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/95.0.4638.54 Safari/537.36|
> |HTTP_ACCEPT|application/json, text/javascript, */*; q=0.01|
> |HTTP_REFERER|https://forum. **********.com/u?group=advanced_aero&order=Aircraft|
> |HTTP_X_FORWARDED_FOR|63.224.250.126|
> |HTTP_X_REAL_IP|63.224.250.126|
> |username|omarf|
> |time|9:41 pm|
> |params||
> |period|weekly|
> |order|Aircraft|
> |group|current_members|
> |user_field_ids|2|36|37|
>
> ```
The directory columns contain 4 custom user text fields and `/u` goes to our Users Map provided by the [Locations](https://meta.discourse.org/t/locations-plugin/69742) plugin.
This also happens in safe-mode.
---
### Author:  [@Falco](https://meta.discourse.org/u/Falco)
#### Post date: [October 21, 2021, 1:45pm UTC](https://meta.discourse.org/t/listing-users-by-group-error-missing-from-clause-entry-for-table-groups/206618/2 "2021-10-21T13:45:19Z")
Can you reproduce this after rebuilding without the locations plugin?
---
### Author:  [@omarfilip](https://meta.discourse.org/u/omarfilip)
#### Post date: [October 21, 2021, 3:40pm UTC](https://meta.discourse.org/t/listing-users-by-group-error-missing-from-clause-entry-for-table-groups/206618/3 "2021-10-21T15:40:55Z")
Yes, same behavior after rebuilding without Locations:
```plaintext
ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: missing FROM-clause entry for table "groups"
LINE 1: ..._2' WHERE "directory_items"."period_type" = 4 AND "groups"."...
^
)
```
---
### Author:  [@omarfilip](https://meta.discourse.org/u/omarfilip)
#### Post date: [October 21, 2021, 3:49pm UTC](https://meta.discourse.org/t/listing-users-by-group-error-missing-from-clause-entry-for-table-groups/206618/4 "2021-10-21T15:49:04Z")
I’ve narrowed it down:
When I reset Edit Directory Columns to default, it works as expected, but when I reorder the columns and include my custom user fields, the issue is reproduced.
