# רישום משתמשים לפי קבוצה - שגיאה: חסר ערך FROM-clause עבור הטבלה "groups"

**URL:** <https://meta.discourse.org/t/listing-users-by-group-error-missing-from-clause-entry-for-table-groups/206618>\
**Category:** Product Support\
**Created:** [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:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![omarfilip](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/omarfilip/32/208019_2.png) [@omarfilip](https://meta.discourse.org/u/omarfilip)\
**Post date:** [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")

</div>

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.

 ![edit directory columns](https://global.discourse-cdn.com/meta/original/3X/5/8/58554c10bb157a8bdf2ba2f77fdd77a514ced58f.png)

 ![directory-columns](https://global.discourse-cdn.com/meta/original/3X/d/1/d1d02bf6e6f76b9059006f882719306c14a5f26d.jpeg)

---

_[View the full topic](https://meta.discourse.org/t/listing-users-by-group-error-missing-from-clause-entry-for-table-groups/206618)._