Level 4

ntBaseLucene index

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Level 5

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

Level 4

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

Level 5

Hi Alex,

Did you change the query and tried it.

Sign up