Work with SQL Where Clause Searches
Use the Advanced Settings options to access additional features for creating SQL Where Clause searches. You can select AND/OR operators, group multiple conditions, nest the groupings, clear search conditions, rebuild SQL Where Clause queries, and view a search as plain text.
You must have the appropriate security role access to SQL Where Clause searches. If you have questions, contact your system administrator.
Videos
Title | Description |
---|---|
Learn how to perform basic searches. |
|
Learn how to create advanced searches, including how to use conditions to filter the scope of the results. |
- Related Topics:
- Build a SQL Where Clause Search
Build SQL Where Clause searches to find records or compare data across multiple hubs, applications, and databases. - SQL Where Clause Search Tokens
SQL Where Clause Search tokens are the basic syntactical units of a SQL query, which comprise keywords, identifiers, strings, and other commands. When you build a SQL Where Clause query, you should use only the tokens allowed in Vantagepoint to ensure the successful execution of your SQL Where Clause search. - 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. - Save a SQL Where Clause Search
You can save new or updated SQL Where Clause searches to the Searches list for reuse. You can also create folder directories to organize your searches.
Parent Topic: How to...