Page 10 - Unanet AE: Creating Analytic Models Using Query Builder

LESSON 2: BUILDING QUERIES IN THE QUERY

BUILDER APPLET

Learning Objectives

Summarize how to build queries using the Query Build applet.
• Identify the benefits of the Query Builder applet.
• Explain the role of the Datasets in the Query Builder utility.
• Define the components of the Query Builder.
• Summarize the functionality of SQL statements within Query Builder.
• Describe how to manage and edit a dashboard query.

Purpose and Benefits

The Query Builder applet provides you with a visual interface for constructing queries,
dynamically assembling them for application in Analytic Dashboard Designer and
Custom Reports modules.

Even if you're not proficient with SQL, this tool simplifies the process of building queries
and Analytic Models, making it accessible to all users.

Moreover, it permits the exporting of your query either as a .sql file or as an Analytic
Model directly within Unanet A/E. This exported query can then be utilized in the
Analytic Dashboard Designer and Custom Reports applets.

Datasets and Fields

Select a Dataset to produce a list of Available Fields within that dataset. Fields to be
used in the query are selected from the Available Fields list. Each query can only
reference one dataset.

• Datasets: Lists available data sets. Each data set contains a list of available
fields that can be selected for use in the query.
• Available Fields: Displays a list of fields per dataset. Fields can be filtered by
typing in the search box and selected for use in the query by checking the box
next to each field. Field descriptions are displayed at the bottom of the pane
when clicking the field.
• Clear Selected: Clears all sections made in the Datasets field list.

Lesson 2: Building Queries In The Query Builder Applet ©2023 Unanet. All rights reserved. 10