N1QL query not picking the correct index

I am trying to create a covering index where data is sorted by an element .
The index doesn’t seem to be working .
Can You please help with this

select ax, by, cz,ts
from csrt_test
where meta().id like ‘CX%’ and cz= ‘BBD’
limit 100

index -
CREATE INDEX index_test_sec_idx ON csrt_test(ax, by, cz,ts DESC) WHERE ((meta().id) like “CX%”) WITH { “num_replica”:1 }

Getting the following error -
“msg”: “No index available on keyspace csrt_test that matches your query. Use CREATE INDEX or CREATE PRIMARY INDEX to create an index, or check that your expected index is online.”,