ARDI Documentation - sql

JOIN

anonymous@undisclosed.example.com (Anonymous) — Thu, 18 Dec 2025 22:50:17 +0000

JOIN In ARDI SQL queries, the JOIN select property doesn't join queries - it instead joins ASSETS via their relationships. It takes the form of 'JOIN ON '. So for example, the below query... SELECT 'Speed' FROM 'Machine' JOIN 'Location' ON 'down'

RAW

anonymous@undisclosed.example.com (Anonymous) — Thu, 18 Dec 2025 22:50:17 +0000

RAW The command 'RAW' immediately after the SELECT instructs ARDI to return raw sample data, rather than trying to interpolate it.

RECENT

anonymous@undisclosed.example.com (Anonymous) — Thu, 18 Dec 2025 22:50:17 +0000

RECENT The RECENT filter is used to restrict the time range to a span relative to the current time. The syntax is RECENT() The span is a human-readable string describing the span of time. For example, '1 day', '7 days', '30 minutes' are all valid values.

SAMPLES

anonymous@undisclosed.example.com (Anonymous) — Thu, 18 Dec 2025 22:50:17 +0000

SAMPLES This keyword restricts the total number of records returned. SAMPLES 100 will result in a query of only 100 samples. Note that the response is not guaranteed to be that number of samples. In some cases the ARDI driver might ignore the instruction, in others the results might be padded with additional values (returning 102 rather than 100 records),

SELECT

anonymous@undisclosed.example.com (Anonymous) — Thu, 18 Dec 2025 22:50:17 +0000

SELECT Syntax The query should be in the form of... SELECT [RAW] FROM [ WHERE [SPAN x] [SAMPLES x]] Where asset and property names contain spaces, you should enclose your name in single quotes.

SPAN

anonymous@undisclosed.example.com (Anonymous) — Thu, 18 Dec 2025 22:50:17 +0000

SPAN Unless you're making a RAW request, your query will return interpolated data, giving you the average values across windows of time. Using SPAN, you can control the size of the time window. Time is measured in seconds, so SPAN 120 will ensure that there is 120 seconds (2 minutes) between each sample in your results.

ARDI SQL Addon

anonymous@undisclosed.example.com (Anonymous) — Thu, 18 Dec 2025 22:50:17 +0000

ARDI SQL Addon The ARDI SQL addon provides a simple and more familiar way for people to access tables of ARDI data. It's designed for people who want to get quick and easy access to ARDI data and are already familiar with SQL, and who don't need the extra capabilities of AQL.