Query Builders

A Query Builder allows you to build Queries through the use of one or more independently created Clauses. Each Query Builder is dynamic and provides specific options based on the purpose of the Query you are building.

CSM provides Users with three types of Query Builders:

  1. Stored Query Builder: The Stored Query Builder allows you to create a Search Group and save it to the database as a Search Group (saved search).
  2. Quick Search Query Builder: The Quick Search Query Builder allows you to create a Quick Search.
  3. Custom Query Builder: The Custom Query Builder allows you to create an exclusive search that finds all records meeting a unique criteria.

Query Builders can be found in the following locations:

Automation Processes

  Stored Query Builder Quick Search Query Builder Custom Query Builder
Simple Action/Event OK    
Threshold-based OK   OK
Visual workflow OK   OK

External Tables

  Stored Query Builder Quick Search Query Builder Custom Query Builder
Administrator>Database>Import External Data>Filter OK    

Knowledge

  Stored Query Builder Quick Search Query Builder Custom Query Builder
Knowledge Source OK    

One-Step Actions

  Stored Query Builder Quick Search Query Builder Custom Query Builder
Condition Page OK    

Quick Search

  Stored Query Builder Quick Search Query Builder Custom Query Builder
Quick Search Pane   OK  
Task Pane Quick Search   OK  

Reporting

  Stored Query Builder Quick Search Query Builder Custom Query Builder
Existing Report OK    
Wizard (Search Group Page) OK    

Search Groups

  Stored Query Builder Quick Search Query Builder Custom Query Builder
Business Objects     OK

Scheduler

  Stored Query Builder Quick Search Query Builder Custom Query Builder
Portal Credentials OK    

Widgets

  Stored Query Builder Quick Search Query Builder Custom Query Builder
Action Catalog Widget     OK
Chart Widget OK   OK
Filter Widget OK   OK
Gauge Widget OK   OK
Matrix Widget OK   OK
Search Results List Widget OK   OK
Search Widget     OK
© Copyright 2018 Cherwell Software, LLC. All rights reserved.