Oak Index Definition Generator
Generates an index definition for a given set of queries
Queries
#Paste your queries here SELECT * FROM [dam:Asset] AS a WHERE a.[jcr:content/metadata/status] = 'published' ORDER BY a.[jcr:content/metadata/jcr:lastModified] DESC # There can be multiple queries added here and index generated would cover all # of them SELECT * FROM [dam:Asset] WHERE CONTAINS([mimetype], 'text/plain') # You can also include xpath queries /jcr:root/content/dam/element(*, dam:Asset)[@valid]
Back
Text
JSON
XML
- compatVersion = 2 - async = "async" - queryPaths = [/content/dam] - includedPaths = [/content/dam] - jcr:primaryType = oak:QueryIndexDefinition - evaluatePathRestrictions = true - type = "lucene" + indexRules + dam:Asset + properties + valid - name = "valid" - propertyIndex = true - notNullCheckEnabled = true + mimetype - name = "mimetype" - analyzed = true + lastModified - name = "jcr:content/metadata/jcr:lastModified" - ordered = true + status - name = "jcr:content/metadata/status" - propertyIndex = true
{ "compatVersion": 2, "async": "async", "queryPaths": [ "/content/dam" ], "includedPaths": [ "/content/dam" ], "jcr:primaryType": "oak:QueryIndexDefinition", "evaluatePathRestrictions": true, "type": "lucene", "indexRules": { "jcr:primaryType": "nt:unstructured", "dam:Asset": { "jcr:primaryType": "nt:unstructured", "properties": { "jcr:primaryType": "nt:unstructured", "valid": { "name": "valid", "propertyIndex": true, "jcr:primaryType": "nt:unstructured", "notNullCheckEnabled": true }, "mimetype": { "name": "mimetype", "analyzed": true, "jcr:primaryType": "nt:unstructured" }, "lastModified": { "name": "jcr:content/metadata/jcr:lastModified", "ordered": true, "jcr:primaryType": "nt:unstructured" }, "status": { "name": "jcr:content/metadata/status", "propertyIndex": true, "jcr:primaryType": "nt:unstructured" } } } } }