|  Organizer Advantage HowTo/Help  |  Designer HowTo/Help  | 

Advantage Help > Main Window > Filter, Quick Search

Filter, Quick Search

Very often data administrators would like to execute repeated actions on the selected group of records. In Advantage you can define filter, save it, and then quickly activate it. The group of records is displayed and you can apply actions (review, print report, update, print labels, send emails ...)

For example in our business we enter customers who purchased our software into CUSTOMERS table, at the end of the week we prepare packages for clients who selected CDROM delivery. In the CUSTOMERS table we defined a filter PRINT=Y. The filter is executed, and for the displayed group of records we print shipping labels, shipping documents, and process shipments. This filter is easily accessible in the Quick Search / Filter box.

Example:
You can build simple or complex search queries (filters) in the Advanced Search toolbar section. In this example the loaned out items fitler (LoanedItems) is defined as LOANEDTO <> '' (LOANEDTO value is not empty).

• In the Quick Search/Filter (1) box select LoanedItems.
• Only loaned out library items are displayed. The librarian can review and process the list.
• Click Clear (2) to display all records.

Organizer Advantage, Simple Database Solutions

Organizer Advantage, Business Database Solutions

Organizer Advantage Free Service

Organizer Advantage Support

Database Blog:
Advantages of Database Software over Spreadsheet Applications
Firebird SQL Tutor
Custom Wine Inventory Database

Free Database Templates