Skip to main content

Build and Run Queries

Build a Query​

You can build a query directly in Alloy Studio using its drag-and-drop environment, Query Builder. To create a query, right-click any class with mapped data and drag-and-drop the fields you want to the central panel. To execute the query, click play.

Create a Query​

Coming soon.

Test Querying your Data model​

Coming soon.

Core Features​

Class Explorer​

Coming soon.

Function Explorer​

The function explorer shows you all the functions you have defined and lets you drag and drop to selected panels in the query builder including the derviation projection columns.

Function Explorer

Parameters​

Parameters are variables assigned to your query. They are dynamic in nature and can change for each execution.

Add a parameter

Constants​

Constants are static values set to a variable name that can be leveraged within your query. They remain the same for ALL executions.

Add a constant

Add a constant for milestone value

Filter​

Coming soon.

Milestoning​

Milestoning

Watermark​

You can add a watermark to your query through the advanced options tab. If a watermark is present, a waterdrop icon will appear on the top left of your query and you can also edit your watermark by clicking that icon.

Watermark

Fetch Structure - Tabular Data Structure​

Projection Columns​

Coming soon.

Post Filter​

You may add a filter that will be applied to your Tabular Data Structure Columns that were defined through the projection panel by adding a post-filter.

Post Filter Post Filter on aggregation OLAP with Post Filter

OLAP​

OLAP lets you add window columns to your query. See:

Create Simple OLAP OLAP Modal OLAP with Post Filter

Result Modifiers​

Coming soon.

Fetch Structure - Graph Fetch​

Coming soon.

Open an Existing Query​

Coming soon.

Edit a Service Query​

Coming soon.

Executing Queries​

Query Data as of Specific Dates and Times​

Coming soon.

Apply operations, transformations, and calculations to your datasets in the Query Editor​

Coming soon.

Execute With Parameters​

Execute Params Export Params With Enums

Export Data​

Once you are content with your data, you can also export to other types. For now we support exporting your query results to CSV.

Export CSV

Export CSV

More​