[seti page_title]Search Builder: criteria [calc] $CGI->{current_column} + 1[/calc][/seti] [set help_name]search_builder[/set] [set ui_class]Design[/set] [set display_class]type5[/set] [set icon_name]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_@ [form-session-id] [return-to]

[loop list="[value current_column]"]

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".
[/loop]

[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 [set Cancel][/set] [/button]

@_UI_STD_FOOTER_@