I’m restricted to using 4.5.1 for now and new to Couchbase N1QL but am having a problem getting the following query to work without a Primary Index. I want to use secondary indexes but am not sure what indexes I should create for this statement to work.
select CODE, CODE_NAME,
PRIMARY, SNUM, SHORTENED_NAME,
from default where UPPER(CODE) like ‘P%’ or UPPER(SNUM) like ‘P%’ or UPPER(CODE_NAME) like ‘P%’
or UPPER(SHORTENED_NAME) like ‘P%’
Any suggestions are appreciated