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