Skip to content

Instantly share code, notes, and snippets.

@jacobsenj
Last active June 2, 2016 11:53
Show Gist options
  • Save jacobsenj/95ed110ff621e458dc3a618e34b67716 to your computer and use it in GitHub Desktop.
Save jacobsenj/95ed110ff621e458dc3a618e34b67716 to your computer and use it in GitHub Desktop.
Typoscript CONTENT select???

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 = |&nbsp;
    }
}

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 = |&nbsp;
    }
}

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment