project-detailfields-and

def parentFolderId = "PARENT_FOLDER_ID"
def keyText   = "komx:detail:ProjectTextKey";   def valText = "TextA"
def keyNumber = "komx:detail:ProjectNumberKey"; def valNumber = 7
def keyDate   = "komx:detail:ProjectDateKey";   def valDate = "2025-01-08T10:15:30"
String q = """
SELECT * FROM komx:project
WHERE IN_FOLDER('${parentFolderId}')
AND ${keyText}='${valText}'
AND ${keyNumber}=${valNumber}
AND ${keyDate}=TIMESTAMP'${valDate}'
"""
def items = session.query(q, false).toList()
println "Treffer: ${items.size()}"

project-infolder-lt

// Query: drei Detailfelder mit AND (komx:project)
def parentFolderId = "komx:folder-PARENT_ID"
def keyText   = "ProjectTextKey";   def valText = "TextA"
def keyNumber = "ProjectNumberKey"; def valNumber = 7
def keyDate   = "ProjectDateKey";   def valDate = "2025-01-08T10:15:30"
String q = """
SELECT * FROM komx:project
WHERE IN_FOLDER('${parentFolderId}')
AND komx:detail:${keyText}='${valText}'
AND komx:detail:${keyNumber}=${valNumber}
AND komx:detail:${keyDate}='${valDate}'
"""

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

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

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

project-intree

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

project-objectid

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