[TYPO3-german] Re: sys_file join sys_file_metadata Abfrage

mr typo hamso92 at web.de
Mon Jan 26 17:57:09 CET 2015


Schon verbessert, aber immer noch keine Ausgabe (mal nur der relevante Teil):
    20 = CONTENT
    20 {   
      table = sys_category 
      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_category.sys_language_uid
        join = sys_category_record_mm ON sys_category_record_mm.uid_local = 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
      }
    } 


More information about the TYPO3-german mailing list