[TYPO3-german] Re: sys_file join sys_file_metadata Abfrage

[mr typo]

Bin schon etwas weiter, Die Ausgabe der Datei aus einem bestimmten Ordner klappt schon, problem war das fehlende pidInList=root
Die Verschachtelung scheint aber nicht zu funktionieren, sieht jemand den Fehler?
lib.download = COA
lib.download {
  10 = CONTENT
  10 {
    table = sys_file_metadata
    select {
      pidInList = root,-1
      selectFields = sys_file.uid AS sysuid, sys_file.folder_hash, sys_file.identifier, sys_file_metadata.file, sys_file_metadata.title AS Dateiname
      languageField = sys_language_uid
      join = sys_file ON sys_file.uid = sys_file_metadata.file
      where = (folder_hash LIKE 'xxxxxxxxx')
      
      
    }
    renderObj = COA
    begin = 0
    renderObj {
      10 = TEXT
      10.field = identifier
      20 = TEXT
      20.value.dataWrap = _uid: {field:sysuid} <br />
    }
    20 = CONTENT
    20 {
      table = sys_category_record_mm
      select {       
        #pidInList = root,-1
        selectFields = sys_category_record_mm.uid_local, sys_category_record_mm.uid_foreign, sys_category_record_mm.tablenames, sys_category.uid, sys_category.title
        languageField = sys_language_uid
        #join = sys_category_record_mm ON sys_category_record_mm.uid_foreign = sys_category.uid
        #where.dataWrap = sys_category_record_mm.uid_foreign = {field:sysuid}
        #andWhere =  sys_category_record_mm.tablenames = 'sys_file_metadata'
      }
      renderObj = COA
      begin = 0
      renderObj {
        30 = TEXT
        30.field = title
        40 = TEXT
        40.field = uid_local
      }
    }
  }
}

Grüße,
Franz