# Sort does not work when users lack database permissions

**URL:** <https://community.fibery.io/t/sort-does-not-work-when-users-lack-database-permissions/9672>\
**Category:** Bugs & Issues\
**Created:** [September 24, 2025, 10:24pm UTC](https://community.fibery.io/t/sort-does-not-work-when-users-lack-database-permissions/9672 "2025-09-24T22:24:34Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![danielbmarsh](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/danielbmarsh/32/13104_2.png) [@danielbmarsh](https://community.fibery.io/u/danielbmarsh)\
**Post date:** [September 24, 2025, 10:24pm UTC](https://community.fibery.io/t/sort-does-not-work-when-users-lack-database-permissions/9672/1 "2025-09-24T22:24:34Z")

</div>

I am using assignment based permissions. I.E. a user only has access to entities they are assigned to.

When creating a list we are sorting by the state. However, the state is not sorted based on the order of the state. It is sorted by a custom field on the state.

When a user has access to the database as a whole, the sort works fine, however the when the user does not have access to the database the sort is not enforced.