How to extract data from typeorm index array?

Question

PostgreSQL

Example for everyone

I have an array with user IDs
[1, 2, 3, 4] in my table.
Is it possible to extract information for each using typeorm?

Answer 1

Can. Documentation.
If these are just IDs without any connection, you can use In :

import {In} from "typeorm";

const users = await connection.getRepository(User).find({
    ids: In([1, 2, 3, 4])
})

If the users are related to another entity, relations: ["users"] can be specified .