Build a Basic Search

A basic search allows you to find records based on several different criteria based on the fields and operators you choose in Search Criteria grid.

Refer to the following table for the steps needed to build a basic search with multiple criteria.

Step Procedure Related Information
Access the New Search Dialog Box
1
Open the Search dialog box:
  • From the Search List, click + New Search. The New Search dialog box displays with the Search Criteria grid.
  • From a lookup list, click Search. The New Search dialog box displays and includes a list of the records related to the lookup. Click the More Search Options link to open the New Search dialog box with the Search Criteria grid.
  • From the Reporting application, click the Reports tab, and click on report row in the Reports grid. The Saved Searches list appears. Click and select Search option from the Saved Searches list. The New Search dialog box displays and includes a list of the records related to the report.
  • From the Reporting application, click the Favorites tab, and select a favorite report in the list to run it.
New Search Dialog Box
Enter Search Criteria
2 Click the Add a Field button to add a new condition (row) to the Search Criteria grid. Add a Field to a Search
3 In the shaded portion of the Search Criteria grid, use the Field column to select a field to include in the search. (For example, Project Number or Employee Name.) The drop-down list includes both standard, and user-defined fields.

Type part of the field name or use the drop-down list to find a specific field. Fields in grids are organized under the grid name that appears in bold (for example, Employees.

In the search dialog for most applications, the first folder is expanded by default and other folders are collapsed. Click if you want to expand another folder to display all available fields within it. To close the lists, click Collapse All.

For projects only, you can search for a specific project level (project, phase, or task).

4 In the Operator field, select a comparative operator, such as "=" or "Contains".

The operators that display are based on the type of field selected. For example, an employee lookup has an operator for "is me" and a date field has an operator for "is today".

5 In the Add Value field, enter the value you want to include as the criteria.
6 Repeat Steps 2 through 5 to add conditions to the search.
Preview Search Results
7 If you do not see a list of matching results, click Show Preview to display the search results: The Search Results Grid displays a list of all records matching your search criteria. These records also display when you use the Select Searches List on the main form for a hub record or in the Records or Saved Searches list on the Reports tab or form for a specific report. Preview the Search Results
8 Some searches have a link to show the number of results. Click Show # of Results to display the total record count for the Results grid. This number is dynamic based on the criteria in the search. Preview the Search Results
9

To refine search result records in a search:

  • On the Search Results list, click the Apply All button to include all search result records that match the search criteria. Although all the record check boxes appear unchecked, all records in the Search Results list are automatically included in the search.
  • To select a subset of records, click the check box for each record that you want included in the search. Click Apply Selected (#) to include only the selected records that match the search criteria. Unchecked records will not appear in the record selection lists of the Hub or application associated with the records.

All records applied to the search are also available for export to a .CSV file.

Refine the Search Results
10 Click at the top right of the Search Results grid to expand the grid to full screen, allowing you to more easily view long lists of search results. Maximize the Search Results Preview
11 Click at the top right of the Search Results grid to export either all or a subset of search results to a .CSV file.

If you want to include or exclude other records, you must select a new subset of records and apply them to the search.

Export Search Records
12 Click at the top right of the Search Results grid to filter the search results based on the values you select in one or more columns. Filter Search Records
Save a Search
13 On the Actions bar, click Save Options to display the Save Options dialog box. Choose either Save to update an existing search, or Save As New Search to save a new search. Vantagepoint adds the search to the designated folder in the Select Searches list. Save a Search
14 To allow other users access to this search, click in the Save For field.

Depending on your search security rights, you can save for everyone (all security roles), your role, or specific security roles. If you do not have the security rights to save for others, then you can only save searches for yourself.

15 To add the search to one of the folder directories in the Select Searches list, click in the Add This Search To field. The Folder Options dialog box opens. You can either select an existing folder directory from the list or click + New Folder to create a new folder directory for the search. Organize Searches
16 Click Save Options to save the search. Vantagepoint adds the search to the designated folder in the Select Searches list.
Execute a Search
17 Click Apply All or Apply Selected (#) to execute the search, close the search dialog box, and return to the main form of the application. Vantagepoint displays the search records in the Find field of a Hub or application.

Depending on how you accessed the Search dialog box, you may be able to select either a single or multiple record(s) from the search list to return either one record or a subset of records.