Hi all, I’m wondering if someone could see my mistake I’m doing while creating a SUFFIX Index. I simplify the Doc to make the conversation a bit easier. Let’s assume the following Doc. { title: 'xxxx München', name: 'ccvvff München bbfdfg' location: { city: 'München' area: 'Bay…

Hi @schulte In create Index it needs to be `location`.`city` Inside back-ticks everything consider as IDENTIFIER/field it will not consider nested object. For nested objects needs separate back-ticks (or omit if no special characters present) for each field Doc1 {"location.city" : "SJC"} Doc2 {…

SUFFIXES on SubDocument

SQL++

schulte April 18, 2018, 7:51pm 3

Hi @vsr1,

ah yes sure.
I wasn’t able to see the wood for the trees.

Thank you, that obviously works.

Topic		Replies	Views
Index for SPLIT or SUFFIXES on nested field SQL++ query , index	3	962	April 21, 2021
Query does not hit index SQL++	15	1067	April 30, 2019
Index from SUFFIXES by whitespace SQL++ query , index	7	435	November 7, 2023
Indexing on Sub Document SQL++	5	2382	June 23, 2017
N1QL query having subquery not picking right index for subquery SQL++ query , n1ql , index	1	650	November 10, 2020

SUFFIXES on SubDocument

Related topics