SEARCH SCREENS:
DBIZ Search screens all follow a similar format. You will firstly
be presented with 4 drop downs and a "Search" button. The drop downs contain the fields
available to search on. You may use any number of drop downs for your search criteria.
No matter how loose your search criteria is, for example such as specifying no criteria
at all, pressing the "Search" button will not return all records in the database.
Search screens only display a certain number of records per screen as configured for the currently logged in employee (see
Employee Screen Help).
Subsequent data can be retrieved by paging through records.
Copy to clipboard:
Most DBIZ search screens enable this functionality. It copies the search result to the clipboard. To use it follow these
steps:
- Retrieve data by pressing the search button
- Click the
icon. This copies the search result to the clipboard in a format compatible with Microsoft Excel
- Open Microsoft Excel
- Right Click on a cell
- Choose Paste
- The data previously retrieved in DBIZ will now appear in your Excel Worksheet
LIKE Operator:
The LIKE operator enables pattern matching, below are the wild cards available and
a few examples.
|
Wildcard character
|
Description
|
Example
|
|
%
|
Any string of zero or more characters.
|
WHERE title LIKE '%computer%' finds all book titles with the word 'computer' anywhere
in the book title.
|
|
_ (underscore)
|
Any single character.
|
WHERE au_fname LIKE '_ean' finds all four-letter first names that end with ean (Dean,
Sean, and so on).
|
|
[ ]
|
Any single character within the specified range ([a-f]) or set ([abcdef]).
|
WHERE au_lname LIKE '[C-P]arsen' finds author last names ending with arsen and starting
with any single character between C and P, for example Carsen, Larsen, Karsen, and
so on.
|
|
[^]
|
Any single character not within the specified range ([^a-f]) or set ([^abcdef]).
|
WHERE au_lname LIKE 'de[^l]%' all author last names starting with de and where the
following letter is not l.
|