#91772Show hidden records does not work as expected.
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` ASCReviews 0
No change resolves or names this issue in its commit message, and no comment links one.