TYPO3 Core

Bug #91772

Updated by Markus Gehrig almost 4 years ago

h1. User Story 

 Our customer wants to check new content elements in the frontend before publishing. So he sets the elements to hidden and wants to show it with the admin panel. In Version 8 LTS this works without a problem. But in Version 9 LTS the hidden records are not shown.  

 h1. Fronted End: 

 !https://forge.typo3.org/attachments/download/35334/Bildschirmfoto%202020-07-09%20um%2011.45.54.png! !Bildschirmfoto 2020-07-09 um 11.45.54.png! 

 h1. TypoScript: 

 The implementation in the TypoScript looks like this: 

 <pre> 
     20 = CONTENT 
     20 { 
         table = tt_content 
         select { 
             includeRecordsWithoutDefaultTranslation = 1 
             orderBy = sorting 
             where = {#colPos}={register:colPos} 
             where.insertData = 1 
             pidInList.data = register:pageUid 
             pidInList.override.data = register:contentFromPid 
         } 
         renderObj{ 
             stdWrap{ 
                 dataWrap = {register:elementWrap} 
                 required = 1 
             } 
         } 
         stdWrap { 
             dataWrap = {register:wrap} 
             required = 1 
         } 
     } 

 </pre> 

 h1. SQL: 

 The SQL in the Admin Panel looks like this. Watch for the hidden = 0 in the where clause.   

 <pre><code class="sql"> 
 SELECT * FROM `tt_content` WHERE ((`tx_gridelements_container` = :dcValue1) AND (`colPos` <> :dcValue2) AND (`pid` = :dcValue3) AND (`tx_gridelements_columns` IN (:dcValue4)) AND (`sys_language_uid` IN (:dcValue5))) AND ((`tt_content`.`deleted` = 0) AND ((`tt_content`.`t3ver_state` <= 0) AND (`tt_content`.`pid` <> -1)) AND (`tt_content`.`hidden` = 0) AND (`tt_content`.`starttime` <= 1594284300) AND ((`tt_content`.`endtime` = 0) OR (`tt_content`.`endtime` > 1594284300)) AND ((`tt_content`.`fe_group` IS NULL) OR (`tt_content`.`fe_group` = '') OR (`tt_content`.`fe_group` = '0') OR (FIND_IN_SET('0', `tt_content`.`fe_group`)) OR (FIND_IN_SET('-1', `tt_content`.`fe_group`)))) ORDER BY `sorting` ASC 
 </code></pre> 

Back