Query - discovery - 23.1

Spectrum Discovery Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Discovery
Version
23.1
Language
English
Product name
Spectrum Discovery
Title
Spectrum Discovery Guide
Topic type
How Do I
Overview
Reference
First publish date
2007
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T17:21:58.768552

Spectrum Discovery provides the Query application for creating, executing, and exporting queries that allow the technical users to create the 'queries' and the business users to execute and export the 'queries' where they can export the query results and use the data to generate various reports easily, with little technical know-how. It allows you to build complex SQL queries via an intuitive Visual Query Builder interface to help you construct complex database queries. Our Query application regulates access to both technical and business users via Security control in the Management Console. The technical users are required to have CRUD rights, whereas the business users are required to have the execute rights to export the queries.

The Query application also allows you to:
  • Manage the list of queries on the home page. Based on your privileges, you can create, edit, view, delete, or run the queries.
  • Define parameters for your query to act upon the resultset of the query dynamically.
  • Export the complete set of data fetched from the query in .csv or .txt format to your desired location.
  • Schedule the queries to run automatically at your scheduled time intervals.