Expand my Community achievements bar.

ntBaseLucene index

Avatar

Level 4

Hi,

We are using search by fileName.

Example:

SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE('/etc/project/test') AND NAME() LIKE '%\_us'

Explain query display WARNINGThis query has characteristics that may cause performance issues when executed against large repositories.

I've adjusted ntBaseLucene index (Add indexNodeName= true on /oak:index/ntBaseLucene/indexRules/nt:base node.Using Oak Utilities : Index Definition Generator.

After such change:

+ Warning disappear and query is much faster

- Query stopping return results with escaping

Example:

SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE('/etc/project/test') AND NAME() LIKE '%\_us'

Return: No results.

SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE('/etc/project/test') AND NAME() LIKE '%_us'

Return: /etc/project/test/en_us

Does anyone know what's wrong here?

We are using AEM6.1 with SP1. OAK version 1.2.11

Thanks,

Alex

4 Replies

Avatar

Level 5

This Link will be helpful. I am seeing there is a problem in your Query to Escape.

Chapter 27. JCR Query Usecases

Avatar

Level 4

The problem is that before changes in oak index both queries were returned /etc/project/test/en_us

Avatar

Level 10

For those reading this thread and want to know more about Indexing - see Oak Lucene Indexes .