Expand my Community achievements bar.

fulltext not working in 6.5

Avatar

Level 1

Hi,

I need to search by a keywords such "esp" in dam:assets in a specific property

I tried use like operation, but i need search with case sentive and accents

My query:

path=/content/dam/nos/
type=dam:Asset

fulltext.relPath=jcr:content/data/master/@countryName
fulltext=esp*

p.limit=-1

 

I created a index damAssetLucene-8-custom-1 with this propery:

<countryName
                      jcr:primaryType="nt:unstructured"
                      name="jcr:content/data/master/countryName"
                      analyzed ="{Boolean}true"
                      index="{Boolean}true"
                      nodeScopeIndex="{Boolean}true"
                      propertyIndex="{Boolean}true"
                      useInSpellcheck="{Boolean}true"
                      useInSuggest="{Boolean}true"/>
 
My log of AEM debug extension
 

QUERY: /jcr:root/content/dam/nos//element(*, dam:Asset)[(jcr:contains(jcr:content/data/master/@countryName, 'esp*'))]

PLAN: [dam:Asset] as [a] /* lucene:damAssetLucene-8-custom-1(/oak:index/damAssetLucene-8-custom-1) +full:jcr:content/data/master/countryName:esp* +:ancestors:/content/dam/nos ft:(jcr:content/data/master/countryName:"esp*") where (contains([a].[jcr:content/data/master/countryName], 'esp*')) and (isdescendantnode([a], [/content/dam/nos])) */

 

But the query no returns anything, and i have two nodes with this propery and values are Espanha and Éspanha

 

Also i added analyser to custom index,

   <analyzers jcr:primaryType="nt:unstructured">
            <default jcr:primaryType="nt:unstructured">
                <filters jcr:primaryType="nt:unstructured">
                    <ASCIIFolding jcr:primaryType="nt:unstructured"/>
                </filters>
                <tokenizer
                    jcr:primaryType="nt:unstructured"
                    name="Standard"/>
            </default>
        </analyzers>
2 Replies

Avatar

Community Advisor

@Ricaoliveira Have you tried with case-sensitive options such as fulltext=Esp*?

Avatar

Level 2

I have similar problem. I think that could be a issue withe query builder fulltext and content fragments. Because if you test it without relPath works but when specify a relpath to a custom property does not work.

did you solve it with some workaround?