Help on Form Query

DESCRIPTION:
The form query window is used to construct a query using a pre-defined form which is set up by your TOPIC database administrator.  The fields which appear in the form query window represent the information you wish to locate in documents contained in your TOPIC database.  The information you enter as a question is called a query definition.  

The form query window consists of two panes.  The upper pane contains the form query template, which includes three field types:  database fields, ad hoc text fields, and topic fields.  The lower pane contains the Results List, which is used to display a list of retrieved documents associated with the query.  A control panel separates the two panes in the form query window, and contains the Retrieved indicator, the Merge indicator, and the Processed bar.  Once a retrieval is started, the cursor is automatically positioned at the top of the Results List.

To scroll this window to see more text, use the Arrow keys.

To close this window, use the Esc key.

ENTERING A QUERY:
To enter a query definition in the form query window, use the Tab key to position the cursor in the edit box next to each field to be used in the form query template.  The Require box next to each field is used to indicate that you want TOPIC to retrieve only those documents which have the field value specified; documents that do not have the field value are not selected.  To check the Require box, use the Tab key to position the cursor in the checkbox, then use the Space bar to check the box.  One or more fields can be used to specify the query information to be used in a retrieval.  TOPIC performs a more precise retrieval, depending on how many fields contain information, and depending on whether the Require box has been checked for a field.

Database fields are used to specify document information that TOPIC matches against data stored in fields in the database, such as a date or a document by a specific author.  For example, you may wish to locate all documents which have a specific date.  To use a database field named DATE, enter the desired date in the DATE field in the form query template.

Ad hoc text fields are used to enter text, such as words and phrases, that TOPIC matches against documents stored in the database.  For example, you may wish to locate all documents which contain the word "earnings." To use an ad hoc text field named TEXT, enter the word or phrase in the TEXT field.

Topic fields are used to enter topic names as defined in the TOPIC database.  For example, you may wish to locate all documents which contain the topic oil-companies.  To use a topic field named TOPIC, enter the topic name in the TOPIC field.  If you wish to enter two or more topic names, separate each topic name with a comma.

OPERATORS can be used with your query definition to indicate the relationship between the information you enter in form query fields.  The operators which can be included with your query definition are as follows:

For Ad hoc text and Topic Fields:
Leaf Operators:  WORD, STEM, SOUNDEX, and WILDCARD
Proximity Operators: PHRASE, SENTENCE, and PARAGRAPH
Concept Operators:  AND, OR, and ACCRUE
Boolean Operators:  ANY and ALL

For Database Fields:
Relational Operators:  EQUAL (=), GREATER THAN (>), GREATER THAN OR EQUAL TO (>=), LESS THAN (<), LESS THAN OR EQUAL TO (<=), THROUGH, and CONTAINS

When entering the operators AND, OR, and relational operators which use symbols, such as EQUAL (=), enter the symbol to represent the operator. For example, if you wish to locate all documents written by the author named Smith, and the AUTHOR filter field has been defined by your TOPIC database administrator, enter "= smith" in the AUTHOR filter field.  When entering the AND and OR operators, enter the operator name.  For example, if your TOPIC database administrator has defined an ad hoc text field, and you wish to locate documents containing the words "future" or "estimate", enter "future OR estimate" in the ad hoc text field.  Operators can be entered in all uppercase, mixed-case, or all lowercase.

When entering other operators, such as leaf operators, proximity operators, boolean operators, and ACCRUE, enter the operator name surrounded by angle brackets.  For example, to enter the PARAGRAPH operator with the phrase "white house" and the word "bush", enter the following :  "white house <PARAGRAPH> bush".


MODIFIERS can be used with certain operators to alter their behavior when your query definition is used in a retrieval.  The modifiers which can be included in your query definition are MANY, NOT, and CASE.  Modifiers are entered following the operator, as in "computer-companies <AND> <NOT> ibm".  When entering the NOT modifier, you do not need to enter the angle brackets around the modifier name.  When entering the MANY and CASE modifier names, you must enter angle brackets surrounding the modifier name.  Modifiers can be entered in all uppercase, mixed-case, or all lowercase.

For a complete description of how these operators work and how to define them in your query definition, refer to the TOPIC User's Guide for PCs and Terminals.

STARTING A SEARCH:
Once you have entered your query definition, you can start a search by pressing the Enter/Return key, or by selecting the "Start Retrieval" option of the Query menu. As documents are retrieved which meet your query definition, they appear in the Results List in the lower portion of the form query window.

MERGING RESULTS:
If you select the Auto-merge Partitioned Retrievals option for the query, TOPIC
automatically merged partitioned retrievals as they become available.  If this
query option is not selected for your query, you can perform a merge on demand to merge newly-available partitioned retrievals.  To merge partitioned retrievals on demand, you can select the "Merge Results" option from the Query menu.
  
For more information on selecting query options and merging retrieval results, refer to the TOPIC User's Guide for PCs and Terminals.

VIEWING RESULTS:
To select a retrieved document which appears in the Results List, use the Arrow keys to position the pointer over the desired document, then use the Space bar to select it.  To open the selected document, press the Enter/Return key.  The document is then displayed within a document window, which can be scrolled up or down.  You can display several documents at a time in separate document windows by using the Window menu to return to the original form query, then selecting another document to be opened.

SORTING RESULTS:
When your retrieved documents appear in the Results List, usually they are ranked by their score (their relevance to your query definition).  The ranking appears in descending sequence, meaning that the retrieved documents which are most relevant to your query definition appear at the top of the list, and those which are less relevant appear farther down the list.  The score appears as a numeric field, and is included with each retrieved document.

You can specify that your retrieved documents are sorted against a field other than the score field.  To specify another sorting order, select the "Sort" option from the View menu to display the Sort dialog box.  The Sort dialog box lists the current sort order by field in the Available Fields list.  To change the sort order in effect, use the Tab key and Arrow keys to position the cursor on a listed field, then use the Space bar to select it.  To move the selected field to the Sort By list, use the Tab key to position the cursor on the Move >> indicator, then use the Space bar.  You can also change the sort order from descending sequence to ascending sequence.  

To store your preferred sort order for the active query's future retrievals, press the Enter/Return key.  To re-sort the retrieval results and store the preferred sort order for the active query's future retrievals, use the Tab key to position the cursor on the Re-sort option, then press the Enter/Return key.

DELETING A DOCUMENT:
As you review documents in the Results List after performing a retrieval, you may want to selectively remove some from the Results List to make it more manageable.  TOPIC provides two options for deleting documents:  Clear and Delete.  These options perform two different functions, as described below.

Clear: The "Clear" option is used to clear one or more documents from the Results List.  When documents are cleared, they will not appear again for the query you are currently using, but they remain in the TOPIC database so they can be searched over using another query definition.   To clear a document, use the Arrow keys and Space bar to highlight the desired document in the Results List to be cleared, then select the "Clear" option from the Edit menu.

Delete:  The "Delete" option is used to delete one or more documents from the Results List as well as from your TOPIC database.  When documents are deleted, they will not be included in retrieval results for any other query definition.  Note that when you delete a document, it cannot be viewed by any other TOPIC user.  To delete a document, use the Arrow keys and Space bar to highlight the desired document in the Results List to be deleted, then select the "Delete" option in the Edit menu.

SAVING A QUERY:
To save a query for future use, select the "Save Query" option of the File menu.  The query is saved using the name that appears in the upper portion of the query window, and is automatically appended with a .qry suffix.

If you use the "Save Query" option to save a query that you have already named, TOPIC assumes that you want to save the revised query under the same name, and will overwrite the existing query.  To save a revised query under another name, use the "Save As ..." option of the File menu, then complete the information specified within the dialog box.