Couchbase Questions: Indexes

Have a Question? Get it answered by our community

acpadhi's picture
Asked 10 hours 19 min ago

Best way to get results - Sort by 2 columns, one in ascending and other in descending

Data structure :
{
"id": "2919220",
"country_code": "US",
"ascii_city_name": "downey",
"city_name": "Downey",
"region": "CA",
"population": "111862",
"latitude": "33.9400000",
"longitude": "-118.1316667",
"...

nks_mmm's picture
Asked 1 year 2 months ago
Latest activity 1 year 2 months ago

Simulating SQL BETWEEN quuery

Hi,
I am new to Couchabse/NoSQL. I have a use case where I need to migrate an app from MySQL to Couchbase.

In MySQL i have a table with columns like startNumber,endNumber,LocationId
I fire a query as below- all values are long numbers

SELECT LocationId FROM blocks...