QuerySurge Text Search For Asset Names, IDs, Tags, and Text Content
QuerySurge Text Search supports searching of the following QuerySurge assets:
- QueryPairs
- Reusable Query Snippets
- Staging Queries
- Test Suites
Searches can be conducted on the following Search Fields:
- Query Text
- Asset Name
- Asset ID
- Asset Tag
The idea of Text Search is help you find specific assets that you've developed, as your QuerySurge projects mature.
The Search Interface
You can access text search simply by typing in the Simple Search box in the upper center/right of the QuerySurge web page, or via the Design Library menu, under Text Search.
If you use the menu item, the Search Interface gives you the ability to make your search much more specific than the Search box, which just offers a generic asset search. However you start your search, results are presented in the Search tab, which gives full access to all Search tools.
Search Setup
The Search syntax uses an indexed search on one or more fields, with the option of utilizing a number of operators to enhance the search capabilities. QuerySurge supports four operators, as outlined in the table below.
| Operator | Description |
| + | Matching records must contain words prefixed with this operator. Note, only the prefix notation is supported (i.e., +supported v. unsupported+). |
| - | Matching records must not contain words prefixed with this operator. Note, only the prefix notation is supported (i.e., -supported v. unsupported-). |
| * | A wildcard representing zero or more characters. Note, only the suffix notation is supported (i.e., supported* v. *unsupported). |
| "" | A word or phrase enclosed in double quotes forces an exact match. |
In addition to the syntax restrictions noted above, search operators cannot be used consecutively. Search terms including consecutive operators, such as +-, -+, +*, and -*, are not supported.
This syntax allows for the creation of simple and more elaborate searches alike, while allowing you to limit the scope of your search to specific QuerySurge Asset Types and Search Fields.
QuerySurge Asset Types that are currently supported for Text Search are:
- QueryPairs
- Reusable Query Snippets
- Staging Queries
- Test Suites
Searchable Field types are currently:
- Query Text
- Asset Names
- Asset ID
- Asset Tags
So, for example, if you wanted to search only the query text of QueryPairs, in the Asset Types dropdown, you would select and in the Search Fields, you would select the
option. You can make any combinations of these options to fit your search needs.
Search Examples
In order to provide an easy entry into using the QuerySurge Full Text Search feature, we list a number of common search use cases along with the search syntax and setup for the search. It is important to note that the examples presented here are all based on the QuerySurge Tutorial assets.
Note: Search examples shown here are all based on the QuerySurge Tutorial assets, with the exception of Asset Tags. Tutorial assets are not tagged by default during installation.
I want to search my QueryPairs for those whose query text contains two specific terms (e.g. both table names IDPURCHASER and BILL_CITY)
Search Terms Asset Types Search Fields +IDPURCHASER +BILL_CITY I want to search my QueryPairs and Snippets for those whose query text contains two specific terms (e.g. table names IDPURCHASER and BILL_CITY)
Search Terms Asset Types Search Fields +IDPURCHASER +BILL_CITY I want to search my QueryPairs for those whose query text contains a term and omits a different term (e.g. must contain IDPURCHASER and cannot contain BILL_CITY)
Search Terms Asset Types Search Fields +IDPURCHASER -BILL_CITY I want to search my QueryPairs for those whose query text contains either one term or a another term (e.g. table names IDPURCHASER or BILL_CITY)
Search Terms Asset Types Search Fields IDPURCHASER BILL_CITY I want to search my QueryPairs for those whose query text contains a specific phrase (and exactly that phrase) (e.g. IDPURCHASER as source_id)
Search Terms Asset Types Search Fields "IDPURCHASER as source_id" I want to search for QueryPairs containing a Snippet name (Snippet: ZCITY Filter)
Search Terms Asset Types Search Fields "ZCITY Filter" I want to search for a Snippet name, both in QueryPairs and on Snippets
Search Terms Asset Types Search Fields "ZCITY Filter" I want to search on a partial phrase in my QueryPairs’ query text
Search Terms Asset Types Search Fields BILL* I want to search my QueryPairs' query text for those with a required term OR those with an different optional term
Search Terms Asset Types Search Fields +IDPURCHASER BILL_CITY I want to search all asset names for a particular partial name (recall that only post-fix * usage is supported)
Search Terms Asset Types Search Fields ZCITY* I want to search QueryPair and Snippet names for a specific asset name
Search Terms Asset Types Search Fields "ZCITY - CITY" I want to search QueryPair, Snippet and Staging Query asset types for a specific name
Search Terms Asset Types Search Fields "ZCITY - CITY" I want to search only QueryPairs and Test Suites for a specific asset name
Search Terms Asset Types Search Fields "USR-1234" I want to search QueryPair IDs for a specific ID
Search Terms Asset Types Search Fields 134 I want to search Test Suites that have a specific Asset Tag
Search Terms Asset Types Search Fields Regression I want to search Mappings that have a specific Field Value
Search Terms Asset Types Search Fields Regression