const compositions = await createQueryBuilder(Composition, 'composition')
                   .addSelect('DISTINCT composition.idComposition')
                   .leftJoinAndSelect('composition.vehicleType', 'vehicleType')
                   .leftJoinAndSelect('vehicleType.factory', 'factory')
                   .leftJoin('composition.load', 'load')
                   .leftJoinAndSelect('compositions.plaques', 'plaques')
                   .where(`composition.status <> 1 AND ${filterAndSearchOptions.where} ORDER BY ${filterAndSearchOptions.orderBy} ${filterAndSearchOptions.direction}${filterAndSearchOptions.pagination}`,
                       filterAndSearchOptions.params)
                   .getMany();

License plates named (plaques) are cars. A composition has at least two associated plates. When in the where step "fetch 2 rows only" it brings a record with only two plates. If I pass "fetch 1 rows only" it brings the same record with only one plate.

because of the left join

If I pass the same command but with repository, all works less the ordenation tha has must be dynamic

could you please make a gist with this code example?
https://gist.github.com/

Of course!

I will do at night!

Now Im at job..

as you wish

Thanks by the time..

u r welcome)

Добрый день, как сделать коннект к ораклу через TNS?

Заранее спасибо

Не нашел где прописывать TNS

пример из докуентации oracledb работает

Ошибка:  Error: ORA-12154: TNS:could not resolve the connect identifier specified

connectString: 'TWO',

Нашел решение

Hello