In my backend using nestjs + typeorm + postgresql I have a CustomRepository and want to repalce some plain sql queries.

This is what I have

const sqlQuery = `SELECT DISTINCT "myColumn" FROM "myTable"`
const sqlRes = await this.query(sqlQuery);

I am trying to get something like this

this.find({select:["myColumn"]}); // note the missing DISTINCT

But this is giving me the plete column but I want just the DISTINCT values.

I found a lot of weird createQueryBuilder().select(DISTINCT "myColumn" FROM "...... etc... solutions, which are not really giving my any benefit over my working solution.

In my backend using nestjs + typeorm + postgresql I have a CustomRepository and want to repalce some plain sql queries.

This is what I have

const sqlQuery = `SELECT DISTINCT "myColumn" FROM "myTable"`
const sqlRes = await this.query(sqlQuery);

I am trying to get something like this

this.find({select:["myColumn"]}); // note the missing DISTINCT

But this is giving me the plete column but I want just the DISTINCT values.

I found a lot of weird createQueryBuilder().select(DISTINCT "myColumn" FROM "...... etc... solutions, which are not really giving my any benefit over my working solution.

• javascript
• postgresql
• nestjs
• typeorm

Share Improve this question Follow edited Dec 2, 2021 at 13:56 Audwin Oyong 2,53133 gold badges1919 silver badges3636 bronze badges asked May 4, 2020 at 10:39 FuzzyTemperFuzzyTemper 78366 gold badges1010 silver badges2525 bronze badges 0

Add a ment  | 

2 Answers 2

Sorted by: Reset to default 6

You could do:

await getManager().createQueryBuilder('entity')
  .select('column')
  .distinct(true)
  .getRawMany();

For some reason getMany or getCount doesn't work for distinct. As 0xCAP said above:

await getManager().createQueryBuilder('entity')
  .select('column')
  .distinct(true)
  .getRawMany();

If you want to keep other columns (as your question), just use addSelect instead of select