#87610Filelist Search - Add constraint to avoid searching of records marked as missing.
Description
The filelist search now fetches all records except deleted and hidden on a matching string.It should avoid searching for records marked as missing, since those fetched missing records leads to Folder not found or File not found Exceptions like in the following screenshot.
As a work around i just added the ‘missing = 0’ constraint at the end of findBySearchWordInMetaData() in TYPO3\CMS\Core\Resource\Index\FileIndexRepository class
$queryBuilder->andWhere(
$queryBuilder->expr()->eq($sysFileTableName.'.missing', $queryBuilder->createNamedParameter(0, \PDO::PARAM_INT))
);
$result = $queryBuilder->execute();
$fileRecords = [];
If this workaround feels sensible can someone please push it to the gerrit review?