Define UUID type for id column
woltob opened this issue · 0 comments
woltob commented
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!