-
-
Notifications
You must be signed in to change notification settings - Fork 2.8k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Spatie Translatable Listing column searchable exception in sql query when searching #9649
Comments
similar to #7537 |
I did some debugging and found this c89f86b PR #8784 search_collation always return null on mysql
to make it work it should've been 'collation' instead of 'search_collation'
I dont know why it's 'search_collation' maybe postgres ? I never used it before 😄 |
Hello, But to address the issue (until it is resolved by the package), I performed the search query independently, as follows:
|
please look @ my pull request #9732 this fixed the issue for me |
Package
filament/filament
Package Version
v3.0.95
Laravel Version
v10.31.0
Livewire Version
v3.1.0
PHP Version
PHP 8.2.9
Problem description
When you search a translatable column I get the following error
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'json_extract(title, "$.en")' in 'where clause'
Expected behavior
it should be like
Steps to reproduce
just visit
http://json-column.test/admin/posts?tableSearch=AA
Reproduction repository
https://github.com/dev3k/json-column
Relevant log output
No response
The text was updated successfully, but these errors were encountered: