2

I want use Distinct Query in OrientDb. Any one have idea about that how to apply that but i want Distinct Query Builder.

Oriento Query

I know that : SELECT DISTINCT(name) FROM City

but I want something like that Query Builder : db.select().distinct(name).from(City)

//Right Select Query Builder
db.select().from('City').where({status: 'true'}).all()    

AND

how to apply object in below Query ?

  var abc = {Country : 'India'};
  'SELECT DISTINCT(name) FROM City where' + abc ; 
Dário
  • 2,002
  • 1
  • 18
  • 28
Gunjan Patel
  • 2,342
  • 4
  • 24
  • 45

1 Answers1

2

You probably want something like

db.select('distinct(name)').from('City').column('name').all()

codemix
  • 672
  • 6
  • 4