Skip to content

Instantly share code, notes, and snippets.

@jacobsenj

jacobsenj/select_problem.md

Last active June 2, 2016 11:53
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jacobsenj/95ed110ff621e458dc3a618e34b67716 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jacobsenj/95ed110ff621e458dc3a618e34b67716 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. jacobsenj revised this gist Jun 2, 2016. 1 changed file with 8 additions and 2 deletions.
    10 changes: 8 additions & 2 deletions select_problem.md
    View file
    Original file line number Diff line number Diff line change
    @@ -24,7 +24,10 @@ Works for default language, but not for german:
    }
    ```

    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;`
    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:

    @@ -51,4 +54,7 @@ Works in default and in german language:
    }
    ```

    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`
    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
    ```
  2. jacobsenj renamed this gist Jun 2, 2016. 1 changed file with 6 additions and 2 deletions.
    8 changes: 6 additions & 2 deletions Typoscript CONTENT select??? → select_problem.md
    View file
    Original file line number Diff line number Diff line change
    @@ -2,6 +2,7 @@ I'm trying to get the description of a sys_file_metadata entry by field file (sy

    Works for default language, but not for german:

    ```
    15 = CONTENT
    15 {
    wrap = <span class="news-img-caption">|</span>
    @@ -21,11 +22,13 @@ Works for default language, but not for german:
    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;
    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>
    @@ -46,5 +49,6 @@ Works in default and in german language:
    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
    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`
  3. jacobsenj revised this gist Jun 2, 2016. 1 changed file with 5 additions and 1 deletion.
    6 changes: 5 additions & 1 deletion Typoscript CONTENT select???
    View file
    Original file line number Diff line number Diff line change
    @@ -22,6 +22,8 @@ Works for default language, but not for german:
    }
    }

    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
    @@ -43,4 +45,6 @@ Works in default and in german language:
    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
  4. jacobsenj created this gist Jun 2, 2016.
    46 changes: 46 additions & 0 deletions Typoscript CONTENT select???
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,46 @@
    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;
    }
    }

    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;
    }
    }