Forming Queries

Queries are placed in Layer files in sections denoted with a <query> tag. Each query tag must also be named so that it can be referred to in a pipeline step.

Example query:

<query name="myquery">
SELECT * FROM MYTABLE
</query>

In the above example, the query is named ‘myquery’ and contains inline SQL.

Using Filters and User Attributes and Queries

White Label Data supports creating multiple Personas(/docs/users-personas/personas) as well as Page Filters. Both of these create attributes (aka variables) that you can use within your SQL queries. To denote a filter or user-attribute, include the filter name or attribute name between {{ and }} within your SQL statement. The value of these filters or attributes will get substituted with the actual value when the visualiation is rendered.

Query Rendering

Introduction

Configuring Your App

Users and Personas

Understanding Layers

Composing HTML Pages

Adding Page Filters

Embedding iFrames

Creating Native Visualizations

Advanced Features

Forming Queries

Using Filters and User Attributes and Queries