Project

General

Profile

Actions

Bug #84949

closed

TS select join rewrite FROM to ON

Added by Loon Buster over 6 years ago. Updated over 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 #1

Updated by Wouter Wolters over 6 years ago

  • Target version deleted (8.7.13)
Actions #2

Updated by Loon Buster over 6 years ago

  • Priority changed from Should have to Must have

very interesting to see how nobody here is responsible for it - so why somebody change it in that senseless way? maybe this person have no idea from subquery :|

annoying.

Actions #3

Updated by Loon Buster over 6 years ago

  • Category changed from TypoScript to Frontend
Actions #4

Updated by balli Halli almost 6 years ago

  • Start date changed from 2018-05-08 to 2018-12-12
  • Tags set to TS SELECT JOIN

Any news on this?
I am facing the same problem and therefore I can't update my installation.

Actions #5

Updated by Susanne Moog over 4 years ago

  • Status changed from New to Needs Feedback

Hey,

can you post the query you expected this to result in and the query that is actually generated? In general, a join in probably not the right place for the subselect you want to add here.

Actions #6

Updated by Loon Buster over 4 years ago

Susanne Moog wrote:

Hey,

can you post the query you expected this to result in and the query that is actually generated? In general, a join in probably not the right place for the subselect you want to add here.

..well; no.

i developed a workaround and now, after last 2 years, t3v8 is outdated. so why i should waste my time to find any bugs?

.loon

Actions #7

Updated by Susanne Moog over 4 years ago

  • Status changed from Needs Feedback to Rejected

Ok.

Actions

Also available in: Atom PDF