SoftwareBrothers/adminjs-mikroorm

Define UUID type for id column

woltob opened this issue · 0 comments

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!