#83813No search for sys_file_metadata
Description
AT TCA you can find defined search fields for the meta data of files, but you can not find files searching for meta data.
sys_file: 'searchFields' => 'name, type, mime_type, sha1'
sys_file_metadata: 'searchFields' => 'file,title,description,alternative'Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.
History 3
-
Guido Schmechel commented 04/21/18, 20:27
-
Riccardo De Contardi commented and changed description 06/18/18, 16:43
I’ve corrected the description from
> AT TCA you can find defined search fields for the meta data of files, but you can find files searching for meta data.
to
> AT TCA you can find defined search fields for the meta data of files, but you can not find files searching for meta data.
-
Susanne Moog commented and changed status
NewClosed 03/25/20, 20:40Yes, this is wanted behaviour. The search uses the list module to display results and that reacts to the configuration of which tables to display – if you remove the hide table from TCA those records are actually found. I’m going to close the issue now, as this is not a bug. However, if someone wants to implement an addition to the search to be able to search and display files (and metadata) in a separate view, please feel free to do so.
Some research (current master)
File: Search/LiveSearch/LiveSearch.php
findByGlobalTableList() checks all given tables. “if no access for the table (read or write) or table is hidden, skip this table“
sys_file_metadata has the option hideTable = true and this table is skipped.
*To clarify*
Is this a wanted behavior for sys_tables?