Admin Tool, Database Administration, Data Management, Web Administration

interactive | editorial | code | resource 
Demonstrations > Part 3
 

Part 3 - Advanced Searching

Advanced Searching

Here's an example of a search page for searching the orders table. Click View Advanced to see all the options.

Search
Enter Text:

Advanced
Order Date
Start Date
<July 2010>
MonTueWedThuFriSatSun
2829301234
567891011
12131415161718
19202122232425
2627282930311
2345678
End Date
<July 2010>
MonTueWedThuFriSatSun
2829301234
567891011
12131415161718
19202122232425
2627282930311
2345678
Customer Company
(Control-Click to select multiples,
or Shift-Click to select a list)
Employee
Product
(Control-Click to select multiples,
or Shift-Click to select a list)

Fuzzy Searches:

When fuzzy search is not checked, an exact match search is made. Only records that match every query item are returned.

When fuzzy search is checked, items are ranked according to how well they match the query. So, some records that only partially match a particular query will be returned. This can be useful if precise criteria for a search are not known.

Here is the code that defines this search page:

<Search>
    <QuickAdmin:Simple runat=server ID="Simple1">
        <QuickAdmin:Local LocalField=OrderID Runat=server />
        <QuickAdmin:One2Many Quotes=true LocalField=CustomerID ForeignTable=Customers ForeignKeyField=CustomerID ForeignDataField=CompanyName Runat=server />
    </QuickAdmin:Simple>
    <QuickAdmin:Advanced runat=server ID="Advanced1" >
        <QuickAdmin:LocalBetweenDateTwice Title="Order Date" Runat=server LocalField=OrderDate />
        <QuickAdmin:One2ManyListBox Quotes=true Title="Customer Company" Rows=7 SelectionMode=Multiple LocalField=CustomerID ForeignTable=Customers ForeignKeyField=CustomerID ForeignDataField=CompanyName Runat=server />
        <QuickAdmin:One2ManyCheckBoxList Title="Employee" RepeatColumns=4 LocalField=EmployeeID ForeignTable=Employees ForeignKeyField=EmployeeID ForeignDataField=Lastname Runat=server />
        <QuickAdmin:Many2ManyListBox Title="Product" Rows=10 SelectionMode=Multiple LocalField=OrderID IntermediateTable="Order Details" IntermediateLocalKey=OrderID IntermediateForeignKey=ProductID ForeignTable=Products ForeignKeyField=ProductID ForeignDataField=ProductName Runat=server />
    </QuickAdmin:Advanced>
</Search>

 
Demonstrations > Part 3