[seti page_title]Search wizard: criteria [calc] $CGI->{current_column} + 1[/calc][/seti] [set help_name]search_builder[/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]

[loop list="[value current_column]"] [/loop]
Search table [if !value current_column] [value search_table] [else] [/else] [/if] [if !value current_column] Since this is the first specification in the search, it must be based on your current table. Use Back to change the table. [else] The search must be based on one or more tables. Since you have already specified one criteria, you can do a test on an external database table that shares the same key as your search table. For example, to select an SKU that has a quantity 10 price less than $100, you can enter the "pricing" table and search for amounts less than $100. [/else] [/if]
Search field You can search one specific field for a value. If you don't select a field, a full-text search will be done on all fields of the database record.
Search operation You can use any number of search comparisons. Bear in mind that equal to means exactly that; you should use regular expression match if you want to search for contained text.
Search for This is what you are searching for.
Case sensitive If a text search, you can specify to match case-sensitively.
Word/partial word If you select partial, a search for "bread" would match "breadbasket" and "bread". If you select whole words, it would only match "bread".
Match beginning Determines whether you must match the beginning of a search field.

By default, a search for of "bread" would match both "rye bread" and "bread bowl". If you select match beginning, it would only match "bread bowl".

[button text="Cancel"] saved_search= mv_todo=return [return-to click] [/button]    [button text="<-- Back"] mv_nextpage=__UI_BASE__/search_wizard.html [/button][loop list=` my $tmp; return if $Values->{num_columns} < 2; return join " ", 1 .. $Values->{num_columns}; `]    [button text="Criteria [loop-code]"] current_column=[calc] $CGI->{current_column} = $Values->{current_column} = [loop-code] - 1; [/calc] mv_nextpage=__UI_BASE__/search_wizard2.html [/button][/loop]    [button text="Narrow further"] current_column=[calc] $CGI->{current_column} = ++$Values->{current_column}; [/calc] mv_data_table=[value search_table] mv_nextpage=__UI_BASE__/search_wizard2.html [/button]    [button text="Next -->"] mv_data_table=[value search_table] mv_nextpage=__UI_BASE__/search_wizard3.html [/button]

@_UI_STD_FOOTER_@