Project

General

Profile

Actions
Copy link

Bug #84949

closed

TS select join rewrite FROM to ON

Added by Loon Buster almost 6 years ago. Updated about 4 years ago.

Status:
Rejected
Priority:
Must have
Assignee:
-
Category:
Frontend
Target version:
-
Start date:
2018-12-12
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
8
PHP Version:
Tags:
TS SELECT JOIN
Complexity:
Is Regression:
Sprint Focus:

Description

hello.

that works perfect in 6.x and 7.x;


   # $xxx.xxx.xxx is just the uid from the page i want my content f.e. 12 or 114 etc

   tmp.lang.stdWrap.cObject = COA
   tmp.lang.stdWrap.cObject {

      10=TEXT
      10.value < config.sys_language_uid
      10.wrap    = |,{$language.defaultuid}
   }

   test = CONTENT
   test {
      table = tt_content
      select {

         pidInList = {$xxx.xxx.xxx}

         join.stdWrap.cObject = COA
         join.stdWrap.cObject {

            10=TEXT
            10.value = (SELECT sys_language_uid FROM `tt_content` WHERE (pid=
            12=TEXT
            12.value = {$xxx.xxx.xxx})AND(sys_language_uid IN (
            15=TEXT
            15.value < tmp.lang
            20= TEXT
            20.value = ) AND deleted=0 AND hidden=0) ORDER BY FIELD(sys_language_uid,
            25=TEXT
            25.value < tmp.lang
            30= TEXT
            30.value = ) LIMIT 1) AS tab2 ON (tt_content.sys_language_uid = tab2.sys_language_uid)
         }
      where = (colPos=0)
      orderBy = tt_content.sorting
      languageField = 0
   }

now in 8.x ts ignored perfectly :(

.loon

Actions
Copy link

Also available in: Atom PDF