QuerySurge Full Text Search

Versions: 8.0+

Versions:6.3+

QuerySurge Full Text Search For Asset Names, IDs, Tags, and Text Content

QuerySurge Full 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 Full Text Search is help you find specific assets that you've developed, as your QuerySurge projects mature.

The Search Interface

You can access full 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 Full 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 Full 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 QuerySurge's 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.

1. 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

   
   
   
2. 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

   
   
   
3. 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

   
   
   
4. 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

   
   
   
5. 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"

   
   
   
6. I want to search for QueryPairs containing a Snippet name (Snippet: ZCITY Filter)
   
   

   Search Terms	Asset Types	Search Fields
   "ZCITY Filter"

   
   
   
7. I want to search for a Snippet name, both in QueryPairs and on Snippets
   
   

   Search Terms	Asset Types	Search Fields
   "ZCITY Filter"

   
   
   
8. I want to search on a partial phrase in my QueryPairs’ query text
   
   

   Search Terms	Asset Types	Search Fields
   BILL*

   
   
   
9. 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

   
   
   
10. 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*

    
    
    
11. I want to search QueryPair and Snippet names for a specific asset name
    
    

    Search Terms	Asset Types	Search Fields
    "ZCITY - CITY"

    
    
    
12. I want to search QueryPair, Snippet and Staging Query asset types for a specific name
    
    

    Search Terms	Asset Types	Search Fields
    "ZCITY - CITY"

    
    
    
13. I want to search only QueryPairs and Test Suites for a specific asset name
    
    

    Search Terms	Asset Types	Search Fields
    "USR-1234"

    
    
    
14. I want to search QueryPair IDs for a specific ID
    
    

    Search Terms	Asset Types	Search Fields
    134

    
    
    
15. I want to search Test Suites that have a specific Asset Tag
    
    

    Search Terms	Asset Types	Search Fields
    Regression