Query Builder Search Optimization: Searching multiple fields in one line

[bronwyncombs]

From CSIRO:

A suggestion from a user whilst we wait to be able to change what tables/fields the simple search can look over:

Could we have an option in a query builder to "Search all fields" for each table? It would be a "contains" search and would help us search quickly for a note on a specimen that could be placed in several text fields.

Another very useful option would be to "Search all remarks fields" across a collection object - so have one query row that looks at the CO/Det/Prep/CE/locality etc. remarks fields.

This is a bit similar to our request to be able to do a text search on a formatted or aggregated view of a table.

This would benefit users trying to find records with a certain trait or remark. This reduces the number of columns to skim through in results, and would catch potentially missed records with that certain remark in a field not included by hand in the query.

For both requested capabilities, these options would require an operator field and text search value and could not be queried as 'All'. Both also present the question of returning multiple results and handling that display in the result cell. Additionally, we'd need to inform the user of which field contains the returned value in the results.

For "Search all remarks fields" there would need to be logic to determine and call upon all remarks fields related to the base table.

Existing requests/discussions mentioned:
#5564: Simple search fields should be configurable with a UI
#318: Cannot use query filters on formatted or aggregated table query lines

[nfshoobs]

I think it would be cool if you could manually configure the fields being searched in a line of the querybuilder, kind of like how typesearches can be customized for querycomboboxes. It would go a long way for user-friendliness for users who aren't as familiar with how relationships between tables work.