Sequenchel’s main screen displays tables and their contents. You can search in the tables for specific records and, if you have the correct permissions, you can edit the contents of those records.
You can use the fields on the right side to enter search criteria and thus filter your results. The results will be displayed on the left side of the screen.
If you have records on the left side, click on any of them to load the entire record into the fields on the right side. This will overwrite your search criteria.
When Sequenchel starts it will automatically select your default connection, table set and table for display. The fields (columns) of your table will be displayed on the right side of the screen. On the left side only those fields will be displayed that have been selected for this in the configuration. The configuration can be changed or updated at any time by your operator or administrator.
First, select the Connection, Table Set and Table you wish to work with.
The “Use TOP 1000” limits your search results to the first 1000 records. This will prevent the accidental retrieving of millions of records which might take a very long time. Unselect this if you want to retrieve all records.
“Reversed Sort Order” will reverse the default sort order of your request before the results are retrieved. In a logging table you will usually get the first (oldest) 1000 records where you might want the last (newest) 1000 records. The sort order is determined by the fields on the left side of the screen.
“(Re)Load Complete List” will retrieve records without any search criteria.
“(Re)Load Search Criteria will refresh all lookup lists. Those are the fields that have a Dropdown list and a refresh button. Reloading will clear the lists and fill them anew. Since most of the lists are refreshing automatically, you will not need this button very often.
You can enter text in any of the fields on the right to search for specific records. Your search text can be anywhere in the searched item. If you enter more than 1 word, separated by a space, every search word must be somewhere in the searched item. In the screenshot only values with “Thicor” AND “Prod” will be retrieved.
You can also enter comma separated values in the search field. If you use a comma the searched item must be an exact match for one of the values you enter. In the screenshot the exact values 12 AND/OR 13 will be retrieved.
If you click on a dropdown button, a search list will appear
With this list you can search for all possible/existing values for a specific field.
The list is by default limited to 1000 values, which provides a maximum of 50 pages with 20 items.
You can filter your results by typing a search text next to the dropdown button.
At the bottom of the search list you can select the First, Previous, Next or Last page in the collection. R/P is results per page. The default is 20. In between there is an indication on what page you are (page 2 of 50).
If you type a text in the search field, the field will be automatically updated.
Use the slider on the top right side, here marked in red, to determine if you want the searched item to start with your value (slide to the left), end with it (slide to the right) or have it somewhere in the text (put the slider in the middle, which is the default).
In the screenshot the slider has been moved to the left, limiting the results to anything that starts with the search text.
Select a value or click on the dropdown (up) button to close the search screen.
If you need to refresh the search list without typing any text, click on the Refresh button next to it.
you enter search text in any of the fields, it will turn blue, indicating this field will be used in the search. If you do not want this text to be used in the next search, click on the title (label) of the field to change the color.
Here “SQL Version Short” will not be used and no text has been entered. “SQL Version Text” will not be used, even though text has been entered because the label was clicked. “SQL Version Long” will be used and the search item must match the search value. “SQL License Type” will be used even though no text has been entered, because the label was clicked. This means that the field must be empty (empty string or DBNull) to show up in the search results.
The Clear button will clear all search text and reset the colors to neutral.
Export List to File will export the results to a file (XML or Excel). See the Reports manual for more details about exporting to file.
The buttons “New Item”, “Update Item” and “Delete Item” allow you to add to, update or delete records from the database. This feature is only useful in operation environments, not in a data warehouse. These are powerful options and should only be used by a DBA.
If you have created a search with several options, you can save that search for later use.
Enter a name in the “Saved Searches box and click on “Add/Update Search”. If you select a previously saved search, the search will be loaded and displayed on the left screen automatically, but not yet executed. You can change it first and next click on “Search”.
Select an existing search and click on “Delete Search” to remove it.