Create a Query

Queries allow data to be exposed through the API to external systems such as BI tools, through a user defined format. They also form the basis of datasets, which can be used in our built in dashboarding tool.

To create a query you can use the query builder or the query editor interfaces. It is possible to start with the query builder then switch over to the query editor.

Query Builder

• [Update When UI Implemented]

Query Editor

• Switch to the query editor tab
• Every query must have a name, enter a name
• Enter the query syntax in SQL form

Query Editor Example

select o.objectname as FromObjectName, o2.objectname as ToObjectName, rt.relationshiptypename as RelationshipType
from object as o
inner join Relationship as r on r.fromobjectid = o.ObjectID
inner join RelationshipType as rt on rt.RelationshipTypeID = r.RelationshipTypeID
inner join Object as o2 on o2.ObjectID = r.ToObjectID

ReportingDB Structure