Deltek Vantagepoint Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Validate a SQL Where Clause Search

Use the Check SQL feature to validate the SQL statement(s) in a SQL Where Clause query before you generate the search. Some of the more common examples of invalid SQL statements include misspellings of keywords, incorrect order of SQL syntax and commands, and misuse of quotation marks.

Prerequisites: Create a new search or open an existing search.

To validate SQL Where Clause syntax:

  1. Open the Search dialog box:
    • From the Saved Search control () at the top of the active hub or application form, click to display the Saved Searches and Record Selection panes. At the bottom of the Saved Searches pane, click + New Search to display the New Search dialog box.
    • 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 then click on a report row in the Reports grid. The Saved Searches list appears. Click and select the Search option from the 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 then select a favorite report in the list to run it.
  2. On the Search dialog box, select the Advanced Settings toggle to access the additional fields that are needed to create a SQL Where Clause search.
  3. On the Actions bar, click Other Actions and then select SQL Where Clause.
  4. On the SQL Where Clause dialog box, click the Check SQL button to run the SQL checker and validate the SQL statements for the query.
    If your SQL statement is invalid, you receive a brief error message that explains why the SQL statement is invalid or inaccurate so that you can correct it.