[seti page_title]Search wizard[/seti] [set help_name]search_builder[/set] [set ui_class]Design[/set] [set icon_name]admin/icon_config.gif[/set] [seti name=tables][list-databases][/seti] [seti meta_header] [perl table="[scratch tables]"] my @tables = split /\s+/, $Scratch->{tables}; my $out; for(@tables) { $tables{$_} = [ $Db{$_}->columns() ]; } $out = " EOF [/perl] [/seti] [calc] $Config->{NoSearch} = ''; [/calc] @_UI_STD_HEAD_@
[return-to]

Search Table The search must be based on a table, by default the main items table.

NOTE: It is possible to search multiple tables in Interchange, but that is not supported by this wizard.
Search locality For full-text searches, it is usually better to search the text file source of the database (create at [page __UI_BASE__/genexport]Direct table export[/page]). When using SQL databases, the coordinated field-based searches are much faster when the first search term is "equals to".
Search Template The results of the search are sent to a page template, by default [calc]$Config->{Special}{results};[/calc].

If you select a page, it should have the [search-region] area necessary to read and build the search.

Page size You can limit the number of results per page, and use the template [more-list] to page between matches. The default is 50.
Unique only Normally one search result is returned for every matching record. If you wish to eliminate duplicate result returns, you can use this.
Allow full expressions Normally characters are searched for literally, i.e. a period will match a period. If you wish to use the power of Perl regular expressions in your matching criteria, select Yes. Bear in mind that some things you enter may not behave just as you might think they will; see perldoc perlre for a complete description of what Perl regular expressions are.
[button text="Cancel"] [return-to click] [/button]    [button text="Next -->"] mv_nextpage=__UI_BASE__/search_wizard2 [/button]

@_UI_STD_FOOTER_@