You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have a posts collection with a localizedtitle field. In the Admin panel, I want to filter by the title. It works if the sortby is unset (it will sort by posts.id I think). If I sort by the title, the error occurs:
Error: Alias "posts_locales" is already used in this query
Reproduction Steps
Create a posts collection with a localizedtitle field
go to /admin/collections/posts
create a post record
enter to the search text input to filter by "title"
Sort by title
Adapters and Plugins
postgresAdapter using node-postgres driver
The text was updated successfully, but these errors were encountered:
lazidoca
changed the title
Search and sort by localized field does not work
Search and sort by localized field does not work: Error: Alias "XXX_locales" is already used in this query
Jul 3, 2024
Link to reproduction
No response
Payload Version
3.0.0-beta.57
Node Version
20 lts
Next.js Version
15 rc 0
Describe the Bug
I have a
posts
collection with a localizedtitle
field. In the Admin panel, I want to filter by the title. It works if the sortby is unset (it will sort by posts.id I think). If I sort by the title, the error occurs:Reproduction Steps
posts
collection with a localizedtitle
field/admin/collections/posts
Adapters and Plugins
postgresAdapter
usingnode-postgres
driverThe text was updated successfully, but these errors were encountered: