adminjs icon indicating copy to clipboard operation
adminjs copied to clipboard

Filter not working with adminjs sequelizer (Database is MSSQL)

Open rahulbhardwaj1721 opened this issue 1 year ago • 1 comments

We are using the below dependencies and found that few special character filtering not working with admin js sequelizer along with mssql db is integrated.

We received the message "No records There are no records in this resource" For example : My mail id is [email protected] and when we search with rahul keyword its work perfectly but when we include rahul. or complete [email protected] then no result found. Its always work in general string filter but when we use @ and dot then creates a problem. I just identify these two special character which is not working probably there are few more.

"@adminjs/bundler": "^1.1.0", "@adminjs/design-system": "^2.1.2", "@adminjs/express": "^4.1.0", "@adminjs/sequelize": "^2.1.4", "adminjs": "^5.7.3",

Please see the issue and make it working asap.

rahulbhardwaj1721 avatar Aug 03 '22 18:08 rahulbhardwaj1721

The final SQL query is generated by Sequelize, our adapters only convert AdminJS filters to a given ORM syntax. I've just checked on MySQL and Postgres database since we have some apps running with them and the filter looks to be working correctly.

However, if you think this is an issue with @adminjs/sequelize, please try to setup a repository that will allow us to reproduce the problem with minimal effort.

dziraf avatar Aug 04 '22 07:08 dziraf

Closing the issue due to lack of response. If it's still the problem please reopen it.

krzysztofstudniarek avatar Aug 16 '22 09:08 krzysztofstudniarek