filefolder-detailfields-and

def parentFolderId = "komx:folder-PARENT_ID"
def keyText   = "komx:detail:FileFolderTextKey";   def valText = "TextA"
def keyNumber = "komx:detail:FileFolderNumberKey"; def valNumber = 7
def keyDate   = "komx:detail:FileFolderDateKey";   def valDate = "2025-01-08T10:15:30"
String q = """
SELECT * FROM komx:fileFolder
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')
}

filefolder-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:fileFolder
WHERE IN_FOLDER('${parentFolderId}')
AND ${property} < TIMESTAMP '${dateStr}'
"""

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

filefolder-infolder-lte

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

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

filefolder-intree

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

filefolder-objectid

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