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