How can I have is null condition in typeorm find options?

sql where-clause typeorm typeorm-activerecord

user4092086 · Oct 23, 2017 · Viewed 18k times · Source

In my queries I'm using typeorm find option, How can I have IS NULL condition in the where clause?

Answer

Another way is you can use IsNull() function, for example:

import { IsNull } from "typeorm";
return await getRepository(User).findOne({
    where: { 
      username: IsNull()
    }
});