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
<March 2010>
MonTueWedThuFriSatSun
22232425262728
1234567
891011121314
15161718192021
22232425262728
2930311234
End Date
<March 2010>
MonTueWedThuFriSatSun
22232425262728
1234567
891011121314
15161718192021
22232425262728
2930311234
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