It does generate the stats but says that no indexes are used, this is a traversal query.

i am using select * from [nt:base] as a where isdescendantnode(a, '/content/project') and a.[email]='test@test.com'but it says

Here is the index xml <oak:index jcr:primaryType="nt:unstructured">        <email            jcr:primaryType="oak:QueryIndexDefinition"            info="Oak Index used for searching by email"            propertyNames="{Name}[email]"            reindex="{Boolean}false"            reindexCount="{Long}...

We have Lucene indexes at the same level and they are working fine. This one is a single property index.

Hello Everyone,I am trying to create a property index at the project level where the path would be content/project/oak:indexThe same index if kept in the default oak:index folder gets picked up for all the queries. But if i have it in the project folder it doesnt.Any idea why?Thank you so much!

Hello Everyone,We have three indexes with each indexing different properties and they are working perfectly for normal querying. But when i use suggest querySELECT [rep:suggest()] as suggestion FROM [nt:base] as s WHERE (ISDESCENDANTNODE(s,'/content/fai/us-products')) AND suggest('richard')It select...

I am able to get the results back. I also had to add lowercase filter for it to work. Thank you so much Jörg Hoh​.

Here is the JSON of the index"faiLiteratureIndex":{    "jcr:primaryType":"oak:QueryIndexDefinition",   "compatVersion":2,   "type":"lucene",   "async":"async",   "evaluatePathRestrictions":true,   "reindex":true,   "indexRules":{       "jcr:primaryType":"nt:unstructured",      "nt:base":{        ...

After i changed the node type, i had to add a tokenizer for the index to be reindexes.<analyzers jcr:primaryType="nt:unstructured">        <default            jcr:primaryType="nt:unstructured">            <filters jcr:primaryType="nt:unstructured">                <Synonym jcr:primaryType="nt:unstruc...

Nvm i had to delete the existing index for it to take the new node type. I will try adding the synonym now and see if it works and let you know.Thanks!