folder-detailfields-and

def parentFolderId = "komx:folder-PARENT_ID"
def keyText   = "komx:detail:FolderTextKey";   def valText = "TextA"
def keyNumber = "komx:detail:FolderNumberKey"; def valNumber = 7
def keyDate   = "Komx:detail:FolderDateKey";   def valDate = "2025-01-08T10:15:30"
String q = """
SELECT * FROM komx:folder
WHERE IN_FOLDER('${parentFolderId}')
AND ${keyText}='${valText}'
AND ${keyNumber}=${valNumber}
AND ${keyDate}=TIMESTAMP'${valDate}'
"""

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

folder-infolder-lt

// Query: IN_FOLDER + '<' (Datum, TIMESTAMP)
def parentFolderId = "komx:folder-PARENT_ID"
def property       = "cmis:creationDate"
def dateStr        = "2025-01-03T00:00:00"
String q = """
SELECT * FROM komx:folder
WHERE IN_FOLDER('${parentFolderId}')
AND ${property} < TIMESTAMP '${dateStr}'
"""

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

folder-infolder-lte

// Query: IN_FOLDER + '<=' (Datum, TIMESTAMP)
def parentFolderId = "komx:folder-PARENT_ID"
def property       = "cmis:lastModificationDate"
def dateStr        = "2025-01-03T00:00:00"
String q = """
SELECT * FROM komx:folder
WHERE IN_FOLDER('${parentFolderId}')
AND ${property} <= TIMESTAMP '${dateStr}'
"""

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

folder-intree

// Query: IN_TREE('<rootFolderId>')
def rootFolderId = "komx:folder-ROOT_ID"
String q = """
SELECT * FROM komx:folder
WHERE IN_TREE('${rootFolderId}')
"""
for (def hit : session.query(q, false)) {
    println hit.getPropertyValueByQueryName('cmis:name')
}

folder-objectid

// Query: Folder via cmis:objectId
def folderId = "komx:folder-ID"
String q = """
SELECT * FROM komx:folder
WHERE cmis:objectId='${folderId}'
"""
for (def hit : session.query(q, false)) {
    println hit.getPropertyValueByQueryName('cmis:name')
}