Search Selection Buttons

The three Search Selection Dots, (Search By User Defined Query, Search By Custom Fields Only, Add to Query Above) allow you to select your method of search. "Search By User Defined Query" makes the upper portion of the window active, allowing you to search any of the standard fields for your desired terms. "Search By Custom Fields Only" should be checked if you wish to search within custom fields (a.k.a. Details). "Add to Query Above" will allow you to search both the standard and custom fields together.

Database Field

To execute a search, you must first select the field you wish to search in. The fields you will find in this dropdown list are the same fields that appear on the main screen (or in the Details window if you are doing a Custom Fields search). After selecting the field you want to search, move on to the Operator Selector.

Operator Selector

This box allows you to select the method by which your selected Database Field must match the Requested Value. You may ask PCRecruiter to find a Requested Value in the Database Field that is: Like/Not Like the search term, Greater/Less Than the search term, equal to the search term, or simply whether the Database Field is null or not (empty, or filled in).

Requested Value

Enter the value you wish to search the Database Field for in this box. PCRecruiter will then seek out this term in the Database Field you have selected, and display the results based on your chosen Operator. PCRecruiter will automatically search for all forms of the word (a search for "bo" would find 'boy', 'bob' etc.). If you wish to search for terms ending in a particular way, use an asterisk (*) as your wild card... for example, if your Requested Value was " *der ", your results would include "Snyder", "Mooders", "Rendering" etc.

Add Criteria (And)

Once you have set your Search Category, Operator, and Requested Value, you must click here to add the search term to the total search query. When clicked, the search term you pieced together will appear in the Query View area. You may then select new values for the Search Category, Operator, and Requested Value boxes, and click "Add Criteria (And)" again to define more parameters. Using this button will cause the PCRecruiter search feature to look for records that fit ALL of your search terms. If you wish to limit your search to one term OR another, but NOT both, then use the Add Criteria (Or) button.

Add Criteria (Or)

Once you have set your Search Category, Operator, and Requested Value, you must click here to add the search term to the total search query. When clicked, the search term you pieced together will appear in the Query View area. You may then select new values for the Search Category, Operator, and Requested Value boxes, and click "Add Criteria (Or)" again to define more parameters. Using this button will cause the PCRecruiter search feature to look for records that fit the current term OR the others, but not BOTH. If you wish to search for the current term AND the others, use the Add Criteria (And)) button.

Order By (Asc/Desc)

Use these buttons to specify how your search results are presented: in alphabetically ascending (A-Z) or descending (Z-A) order.

Clear

Click here to remove all terms from the Query View.

Query View

This area will display the Search Query as terms are added to it using the Add Criteria (And)/Add Criteria (Or) buttons.

Standard Choices List

Use this button to select a Requested Value from a list of the values that have been previously entered for this Custom Field.

Help Button

Click here launch your web browser to the Help Documentation.

Print/Fax

Click here to Print or Fax the results of your search.

OK Button

Click here to exit the search window. The search will remain within the window for later use. You may use the search created here to limit searches in the main Search Screens by using the Copy button in the Advanced Search area of the Names, Companies, or Job Order Search Screens.

Cancel Button

Click here to abort the current Query Search.

Open/Save Search

Once you have created a Query, you can save it for later re-opening and re-use. This does not mean the results will be saved, but rather the search terms themselves will be, so that you can re-perform the search including newly added records in the results.

Exit

Select this option to close PCRecruiter.

Export to File

This command will allow you to export the results of your search to a Comma Separated Variables (.csv) file. CSV is the standard import/export format for database information.

Limit

Use these selections to limit the results of your search to the contents of a rollup list (name or company) or to 'recent contacts'. The 'recent contacts' search will limit the results to records that have no activities entered before or after a specified date This may be useful in purging or archiving the database. Note that 'recent contacts' searches will be more time consuming than a standard search.