I want to create indexes and search it using NIQL like query . i found one example on docs in which only one attribute is searching which works fine for me too but i dont know how to search multiple arritbutes using like query and i dont want to search this using FTS i am already using that too. h…

CREATE INDEX ix1 ON default(DISTINCT ARRAY (DISTINCT SUFFIXES(LOWER(f))) FOR f IN [first_name,last_name] END) WHERE (type = "customer"); SELECT first_name, last_name FROM default WHERE type = "customer" AND ANY f IN [first_name,last_name] SATISFIES (ANY v IN SUFFIXES(LOWER(f)) SATISFIES v LIK…

N1ql like query indexes

SQL++

muhammad_ibrahim February 27, 2020, 10:41pm 3

Thank you so much

Topic		Replies	Views
N1QL for like queries SQL++	4	19951	May 21, 2017
N1QL query - for LIKE statement - Index SQL++ n1ql	1	822	August 24, 2020
N1QL query taking more time to execute SQL++	6	882	October 24, 2018
Slow N1QL performance on covered queries SQL++ query , n1ql , index	5	2152	August 8, 2017
LIKE operator in N1ql query not working SQL++	1	1583	January 10, 2019

N1ql like query indexes

Related topics