Project

General

Profile

Actions

Bug #91772

closed

Show hidden records does not work as expected.

Added by Markus Gehrig over 3 years ago. Updated over 3 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
AdminPanel
Target version:
-
Start date:
2020-07-09
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
9
PHP Version:
7.2
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

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.

Fronted End:

TypoScript:

The implementation in the TypoScript looks like this:

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

SQL:

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

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

Files


Related issues 1 (0 open1 closed)

Is duplicate of TYPO3 Core - Bug #91083: Preview setting "showHiddenRecords" in the admin panel does not work.ClosedChristian Eßl2020-04-17

Actions
Actions

Also available in: Atom PDF