Bug #91772
closedShow hidden records does not work as expected.
0%
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
Updated by Markus Gehrig almost 4 years ago
- Subject changed from Verborgene Datensätze anzeigen does not work as expected. to Show hidden records does not work as expected.
Updated by Kurt Gusbeth almost 4 years ago
I can confirm, that hidden records (elements of an extension) are not displayed even with the Admin Panel.
The feature "show hidden records" worked in version 9.5.14, but this feature is not working anymore in version 9.5.19.
This must be a bug in a newer TYPO3 version.
Updated by Chris Müller almost 4 years ago
- Is duplicate of Bug #91083: Preview setting "showHiddenRecords" in the admin panel does not work. added
Updated by Christian Eßl over 3 years ago
- Status changed from New to Resolved
Applied in changeset b5ef37599da49d2657a6a9f8f4e60fc9bfc8985b.