Implemented Add a SEARCH ALL FIELDS

[donworth]

For some applications it would be handy to have the ability to search for a keyword in any field. A "all fields" could be added to the permissions for a table and could be added to either Quick Search or full Search.

 

[miktham]

Hi all

I am veey new to this app and my client need an similarity search single box to get search up all feilds

 

[Martin68]

A possible workaround used by myself: add a hidden database field which you fill with a hook or a trigger with the content of the possibly searched field values, allow only quickserach for this field....

 

[eugenio]

A possible workaround used by myself: add a hidden database field which you fill with a hook or a trigger with the content of the possibly searched field values, allow only quickserach for this field....

Interesting hack!

 

[miktham]

A possible workaround used by myself: add a hidden database field which you fill with a hook or a trigger with the content of the possibly searched field values, allow only quickserach for this field....

Wow can you help on this?

 

[eugenio]

Implemented in v12.5, released today. From the change log:

New OmniSearch feature: If Quick Search is disabled for all fields in a table, the OmniSearch form (a single-field, search-all textbox) will appear instead, allowing you to search across all compatible fields. Some new, related, config parameters ($enable_omnisearch_feature, $omnisearch_fields_to_include, $include_date_fields_omnisearch, $include_file_fields_omnisearch) are now available.

When you install DaDaBIK (or install a table/view), now by default none of the fields are included in the quick search form, so the OmniSearch field is displayed by default.

 

[TechSupport]

Hello Eugenio,

Thank you for implemented this feature, it is a massive time saver when searching multiple fields in a table.

Regards, Gary (TechSupport)