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.

Sign up for GitHub

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

Jump to bottom

Define UUID type for id column #14

Open

woltob opened this issue Jul 25, 2022 · 0 comments

woltob commented Jul 25, 2022

Hi,

I am receiving an error while searching for entities by their id (uuid type column, postgres, using Mikro ORM =>v5.2).

The generated database query when filtering for IDs is

select "o0".* from "organization" as "o0" where "o0"."id" like '%9d6c5def-4a9b-4deb-8d38-6a5ae473edaa%' order by "o0"."id" asc limit 10 - operator does not exist: uuid ~~ unknown

So apparently adminjs thinks the id columns represented as uuids are strings and uses the like operator.

Is there any fix for this?
Thank you for your help.

Best!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment