Searching for a Record

You have some control over how you search for a record in DBS-based services.

Open CygNet Explorer and double-click the Site name in the service hierarchy to view the services contained in your site. Click a Service name in the service hierarchy (or double-click a Service name in the service pane) to view its contents in the service pane, and then right-click in the service pane to access the context menu.

From the context menu, you can choose Select Search to select a search index, or you can choose Jump To to search the service database based on particular data items and search values you supply. You can also select Hide Database Key to not display database key values in your results.

See DBS-Based Services in the Services section for more information about services that are considered DBS-based.

Selecting an Index

You can select the search index for record searches in DBS-based services (except the ACS, DDS, and MSS) using the following procedure. The index determines the hierarchy of data items by which to view the service records. Database records are then displayed in CygNet Explorer according to the selected index.

To Select or Change the Search Index

1. In CygNet Explorer, select a service in the Service Hierarchy to display its contents in the service pane.
2. In the service pane, right-click to access the context menu, and then click Select Search to access the Select Search dialog box.

   

3. In the Select Search dialog box, select an appropriate index by which to search, and then click OK.
4. Records will be sorted and displayed in the service pane according to the selected index.

Also see Indexes as Views for tips on optimizing ODBC queries using index tables.

Searching the Database

Once the index is selected, you can search for records in the database of any DBS-based service (except the DDS and MSS) using the following procedure. Records are then displayed in CygNet Explorer based on your specified search values, and using the specified search index.

To Search the Database for Records

1. In CygNet Explorer, right-click in the service pane to access the context menu and then click Jump To (or press Ctrl+J) to access the Jump to Key dialog box.

   

2. The fields in the Jump To Key dialog box are listed sequentially, based on the selected index. Icons indicate one of the following statuses for each field name listed.

   • A green arrow icon indicates the search item field name that is currently selected. By default, even for subsequent selections, this icon always appears next to the first item in the list. When you make subsequent search item selections, the arrow will move to the currently selected item.
   • A green check icon indicates search item field names that have previously had search values assigned.
   • A red 'X' icon indicates search item field names that have not yet had search values assigned.

   Note: If you initially want to search based on an item other than the first item listed, first change the index.

3. Select the Field Name to search. Begin with the first field name listed for which the search value is undefined, and continue sequentially.

   Note: The fields are hierarchical in the order listed. If you skip a field in the Field Name list, the field’s value will be assumed to be null. A red 'X' icon remains next to the skipped item to indicate that it has no search value assigned.

4. Type a search value into the Modify Value text box to assign a search value for the selected Field Name.
5. Click OK to jump to the first matching record for the specified value. If you return to the Jump to Key dialog box, the Search Value you entered will appear in the list as the search value for its corresponding field name.
6. Repeat steps 1 - 5 for each sequential search item field name, or to change a previously searched value.