I'm trying to get the description of a sys_file_metadata entry by field file (sys_langugage_uid = 0) for all languages. Default language is 0, german is 16.
Works for default language, but not for german:
15 = CONTENT
15 {
wrap = <span class="news-img-caption">|</span>
table = sys_file_metadata
select {
pidInList = root
selectFields = description
where.data = GP:fileid
where.intval = 1
where.dataWrap = file=|
}
insertData = 1
renderObj = TEXT
renderObj {
field = description
wrap = |
}
}
SQL:
SELECT description, sys_file_metadata.uid as uid, sys_file_metadata.pid as pid, sys_file_metadata.t3ver_state as t3ver_state FROM sys_file_metadata WHERE sys_file_metadata.pid IN (0) AND file=12270 AND sys_file_metadata.t3ver_state<=0 AND sys_file_metadata.pid<>-1;
Works in default and in german language:
15 = CONTENT
15 {
wrap = <span class="news-img-caption">|</span>
table = sys_file_metadata
select {
pidInList = root
selectFields = description,{TSFE:sys_language_uid} as sys_language_uid
selectFields.insertData = 1
where.data = GP:fileid
where.intval = 1
where.dataWrap = file=|
}
insertData = 1
renderObj = TEXT
renderObj {
field = description
wrap = |
}
}
SQL:
SELECT description,16 as sys_language_uid, sys_file_metadata.uid as uid, sys_file_metadata.pid as pid, sys_file_metadata.t3ver_state as t3ver_state FROM sys_file_metadata WHERE sys_file_metadata.pid IN (0) AND file=12270 AND sys_file_metadata.t3ver_state<=0 AND sys_file_metadata.pid<>-1