XPath query ignoring the (sort by @jcr:score )

Thanks... I'll do that!

Regards,

-N

Hi Scott,

Thanks for the good pointers, I did some reading on OAK indexes and came up with the following index definition:

/oak:index/vuDocumentsIndex (oak:QueryIndexDefinition) - compatVersion = 2 - type = "lucene" - async = "async" - evaluatePathRestrictions = true + indexRules (nt:unstructured) + cq:Page (nt:unstructured) + properties + template - propertyIndex = true - name = "jcr:content/cq:template" + docExists - propertyIndex = true - name = "jcr:content/st-documentNode/docExist" + docSusp - propertyIndex = true - name = "jcr:content/st-documentNode/susDisp" + docName - name = "jcr:content/st-documentNode/documentName" - analyzed = true + theNodeProps - name = ".*" - isRegexp = true - nodeScopeIndex = true

I was hoping to get the following XPath Query to use the index:

/jcr:root/content/st/vu/en//element(*, cq:Page)[(jcr:content/@cq:template = '/apps/st/templates/vu/exceptionpage' or jcr:content/@cq:template = '/apps/st/templates/vu/manualpage' or jcr:content/@cq:template = '/apps/st/templates/vu/guidelinepage' or jcr:content/@cq:template = '/apps/st/templates/vu/formpage' or jcr:content/@cq:template = '/apps/st/templates/vu/bulletinpage' or jcr:content/@cq:template = '/apps/st/templates/vu/realstatepraticespage') and jcr:content/st-documentNode/@docExist = 'true' and (jcr:contains(jcr:content/st-documentNode/documentName, 'ALTA') or jcr:contains(., 'ALTA'))] order by @jcr:score descending

Few challenges I have:

1. The index never finishes building. When I go to http://localhost:4502/libs/granite/operations/content/diagnosis/tool.html/_granite_oakindexmanager# the reindex column shows "spinning rectangles" (even after instance restart). in a ~30 seconds a popup shows Reindex Checking time out for : vuDocumentsIndex.Page refresh shows "spinning rectangles" again and the message pops up again. It appears query never finished building.
2. The query performance tool : (http://localhost:4502/libs/granite/operations/content/diagnosis/tool.html/_granite_queryperformance) shows in the Indexes Used section that "No index was used" and "A full text index was used". At this point I can attribute this to Issue number 1.

Where possible I'm going wrong? Any help is appreciated.

Regards.

-N

Just an update:

Managed to create/reindex the query: 

/oak:index/vuDocumentsIndex

Here is the final version:

/oak:index/vuDocuments (oak:QueryIndexDefinition) - compatVersion = 2 - type = "lucene" - async = "async" - evaluatePathRestrictions = true - queryPaths = ["/content/st/vu/en"] - includedPaths = ["/content/st/vu/en"] + indexRules (nt:unstructured) + cq:Page (nt:unstructured) + properties + template - propertyIndex = true - name = "jcr:content/cq:template" + docExists - propertyIndex = true - name = "jcr:content/st-documentNode/docExist" + docSusp - propertyIndex = true - name = "jcr:content/st-documentNode/susDisp" + docName - name = "jcr:content/st-documentNode/documentName" - analyzed = true + theNodeProps - name = ".*" - isRegexp = true - nodeScopeIndex = true

It appears that the value of the async property had an extra space i.e. "async ". Fixing that, plus adding includePaths and queryPaths seems to resolve issue 1.

But I still have issue 2 - the query does not utilize the index. Any ideas?

Regards,

-N