detailfields-and

def projectId = "komx:project-ID"
def keyText   = "komx:detail:DocumentTextKey";  	def valText   = "DocText"
def keyNumber = "komx:detail:DocumentNumberKey";  	def valNumber = 7
def keyDate   = "komx:detail:DocumentDateKey";		def valDate   = "2025-01-01T00:00:00"

String q = """
SELECT * FROM komx:document
WHERE IN_FOLDER('${projectId}')
AND ${keyText}='${valText}'
AND ${keyNumber}=${valNumber}
AND ${keyDate}=TIMESTAMP '${valDate}'
"""

for (def hit : session.query(q, false)) {
    println hit.getPropertyValueByQueryName('cmis:name')
}

infolder-equal

def projectId = "komx:project-ID"
def dateStr = "2025-01-01T00:00:00"
def property = "cmis:creationDate"

String q = "SELECT * FROM komx:document WHERE IN_FOLDER('${projectId}') AND ${property} = TIMESTAMP '${dateStr}'"


for (def hit : session.query(q, false)) {
    println hit.getPropertyValueByQueryName('cmis:name')
}

infolder-gte

def property = "cmis:lastModificationDate"
def projectId = "komx:project-ID"
def dateStr = "2025-01-01T10:00:00"

String q = """
SELECT * FROM komx:document
WHERE IN_FOLDER('${projectId}')
AND ${property} >= TIMESTAMP '${dateStr}'
"""

for (def hit : session.query(q, false)) {
    println hit.getPropertyValueByQueryName('cmis:name')
}

objectid

import org.apache.chemistry.opencmis.client.api.*
import org.apache.chemistry.opencmis.commons.enums.*

def documentId = "komx:document-ID"

String q = "SELECT * FROM komx:document WHERE cmis:objectId='${documentId}'"

for (def hit : session.query(q, false)) {
    println hit.getPropertyValueByQueryName('cmis:name')
}

uuid

def uuid = "DOCUMENT_UUID" // e.g. B1134315-2BF0-4A59-BEB2-2A259B8267C9

String q = "SELECT * FROM komx:document WHERE komx:uuid='${uuid}'"

for (def hit : session.query(q, false)) {
    println hit.getPropertyValueByQueryName('cmis:name')
}