Create index success but query not working

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

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: Couchbase SDKs

1 Like

@househippo

Thank you, have a nice work.