All the interfaces of ZeBAze were entirely designed to be extremely simple to use and give you a quick and easy understanding of the different features offered to query your database.

After you connect ZeBAze to your database and select the data table that you want to query, three main interfaces allow you to define your search criteria and set the search engine, to either display the results on your screen or write them back into your database.


  Number & Date Criteria

This interface allows you to define search criteria for number or date fields and contains an interactive table with 7 columns, each row representing the criteria of a specific field.

Several popup windows help you to define some of the search criteria and a Tools button allows you to reorganize or modify the table.

The red columns (2 to 4) represent the ranking criteria and allow you to define best, importance and scale values for several fields. ZeBAze will query your database and return the database rows that are the closest to your preferences.

The blue columns (5 to 7) represent the constraint criteria and allow you to define minimum & maximum values, define a list of values to match or not to match, and even use regular expressions to create more advanced search criteria.

   


  Text & Boolean Criteria

This interface allows you to define search criteria for text or boolean fields and contains a main menu (left side), from which to select a field and display its specific criteria sub-interface (right side).

ZeBAze proposes you a unique process for boolean fields and two different kinds for text fields, presented as follows :

The first text process, very easy to use, allows you to define two lists of words (or sentences) that you want and do not want to find inside the value of a text field. ZeBAze will only return the database rows in which the field's value contains at least one of the good words and none of the bad words.

The second text process, more powerful and complex, allows you to create a combination of several regular expressions with the help of a table in which each double-column row is an AND NOT operator and all rows are linked with an OR operator. ZeBAze will only return the database rows in which the field's value matches the final combination of regular expressions.

   


  Search Engine Settings

This interface contains 2 sub-interfaces, to use depending on whether you want to display the search results on your screen or write them back into your database.

The Display sub-interface allows you to select which fields you want to display and how many results you want. A click on the Start Display Process button will open a popup window with real-time information about the search engine's progression and your search results will be displayed in a new window.

The Write sub-interface allows you to select a primary key, define the name and default value of the new field and define how many results you want to write. A click on the Start Write Process button will open a popup window with real-time information about the search engine's progression and the writing of the search results in the newly created field (column) of your database.

   


  Search Results

If you want to display the search results on your screen, they will be presented as a data table in a new window, in which a menu bar offers you several options to sort, modify or print the search results.

Each column of the table represents one of your database's fields (selected in the previous Display interface) and each line represents one of your database's rows.

Each column's header contains its field's name, and its background color represents the type of search criteria : red if ranking (with or without constraint), blue if only constraint and gray if none.

If any of your fields has a ranking value, a column with no header will be added to the left side of the table (as in the following example). The numbers written in red in this column represent the final ranking position of each row, in comparison with your search preferences.