Hi ,
I have configured Lucene Full Text Index for /etc/commerce/products/geometrixx-outdoors and here is configuration -
{"jcr:primaryType":"oak:QueryIndexDefinition","compatVersion":2,"type":"lucene","async":"async","reindex":false,"reindexCount":7,"indexRules":{"jcr:primaryType":"nt:unstructured","nt:unstructured":{"jcr:primaryType":"nt:unstructured","properties":{"jcr:primaryType":"nt:unstructured","cqcommerceType":{"jcr:primaryType":"nt:unstructured","nodeScopeIndex":true,"useInSuggest":true,"propertyIndex":true,"useInSpellcheck":true,"name":"nt:unstructured/cq:commerceType","type":"String"}}}}}
While execution of following query: /jcr:root/etc/commerce/products/geometrixx_x002d_outdoors//*[@cq:commerceType='product'] using Explain query , I am getting No indexes were used. This is a traversal query.
Please find the attach file for more details and let me know if I have missed anything.
Thanks,
Debal
Solved! Go to Solution.
Views
Replies
Total Likes
Hi debal,
Make sure you have the patch https://issues.apache.org/jira/browse/OAK-3156 Or
use nt:base instead of nt:unstructered.
Thanks,
Views
Replies
Total Likes
Hi debal,
Make sure you have the patch https://issues.apache.org/jira/browse/OAK-3156 Or
use nt:base instead of nt:unstructered.
Thanks,
Views
Replies
Total Likes
Hi,
Thanks for your input. I have used Oak Index Definition Generator and it gave me relevant output for /jcr:root/etc/commerce/products/geometrixx_x002d_outdoors//*[@cq:commerceType='product']
Output-
- evaluatePathRestrictions = true
- compatVersion = 2
- type = "lucene"
- async = "async"
- jcr:primaryType = oak:QueryIndexDefinition
+ indexRules
+ nt:base (as you suggested)
+ properties
+ commerceType
- name = "cq:commerceType"
- propertyIndex = true
Now, its working and I am getting
Thanks,
Debal
Views
Replies
Total Likes