7.5

Table Of Contents

The SQLSearch Panel is used to give

much more control and power while

creating a search query. It is

assumed that some knowledge of

SQLQueries is available to the user

before he attempts to use this tab.

To search using the SQLtab:

1. Enter your SQLquery in the

SQLQuery box

2. Click Search to execute the

query.

The default search query for an

Access Search Database (which

returns all PDFs in the database)is

this:

SELECT DISTINCTROW Table_

PDF.PDF_ID, Table_PDF.Doc_ID,

Table_PDF.Path_ID, Table_

PDF.PDF_Name, Table_PDF.Number_Pages, Table_PDF.Creation_Date FROM Table_PDF WHERE ( 1 = 1 ) GROUP BY Table_

PDF.PDF_ID, Table_PDF.Doc_ID, Table_PDF.Path_ID, Table_PDF.PDF_Name, Table_PDF.Number_Pages, Table_PDF.Cr-

eation_Date ORDER BY Table_PDF.Doc_ID , Table_PDF.Creation_Date

The Search Results Panel

The Search Results Panel displays the results for any search that is made from The Search Panel.

Set User Options

You can set a number of user options in PlanetPress Search. With the exception of two user options, Use default profile (in

Program startup options) and Database access for new profiles (in Search options), all user options apply to the cur-

rently loaded search profile and are saved with it. Each time you load a search profile, the user options settings adjust to

reflect those of the newly loaded profile.

Note that if the file containing the search profile is read-only, you cannot save any of the modifications you make to the user

options settings. In this case, any changes you make to the user options settings are available only until you load a different

profile or exit PlanetPress Search. It is common to make search profiles read-only in a network installation. See "Database

Considerations in a Network Installation" (page 42).

Here are the user options available in this dialog:

Program startup options tab

l Select document: Select the document that appears in the Select document box in the Search Configuration area of

the PlanetPress Search Program window by default when PlanetPress Search loads this search profile. Select None if

you do not want PlanetPress Search to display any document when it loads this search profile. This option applies only

The PlanetPress Search Program