Create index success but query not working

query
n1ql

#1

Hi everyone,

– Index –
CREATE INDEX Siparisler ON Test2(cariHesapKodu,tarih DESC) WHERE (fisNo is not null) WITH({“index_type” : “forestdb”})

But query not working or query result not coming.

Select * From Test2 Where fisNo IS NOT NULL AND cariHesapKodu="" ORDER BY tarih DESC LIMIT 20 OFFSET 0


#2

what does the EXPLAIN say.

EXPLAIN Select * From Test2 Where fisNo IS NOT NULL AND cariHesapKodu="" ORDER BY tarih DESC LIMIT 20 OFFSET 0

Source: http://developer.couchbase.com/documentation/server/current/n1ql/n1ql-language-reference/explain.html


#3

@househippo

Thank you, have a nice work.