Sample Queries

SELECT * FROM public.assets WHERE name like 'testasset-37%' OR name like 'testtraining-%' OR name = 'test-13 on "asset-1"';

SELECT * FROM public.assets WHERE name IN ('testasset-37 on "test-1"','testtraining-01 on "test-1"','asset-13 on "test-1"');

SSELECT * FROM timeseries WHERE externalId LIKE 'ext%';

select * from timeseries where name = '<timeseriesName>'

SELECT * FROM public.timeseries_datapoints WHERE timeseriesid = <timeseriesid>; SELECT * FROM public.timeseries_datapoints WHERE externalid = '<externalid>';

select * from public.timeseries_datapoints where (externalid= '<externalid>' AND isstring = '<boolean>' ) OR ( timestamputc BETWEEN '2024-08-26 08:30:49.039' and '2024-05-26 08:30:49.039' AND valuenumeric > 100)

select * from public.timeseries join public.assets on public.timeseries.assetId = public.assets.id;

SELECT NOW(); SELECT NOW() - INTERVAL 1 hour; SELECT CURRENT_TIMESTAMP(); SELECT CURRENT_TIMESTAMP() - INTERVAL 1 hour;

SELECT id, type, createdTime, lastUpdatedTime, externalId, assetId, name, description, dataSetId FROM public.sequences;

SELECT * FROM public.relationships WHERE sourceType = 'asset';

[SELECT * FROM public.dataset WHERE externalId LIKE 'prefix%';]

SELECT * FROM public.events WHERE (description LIKE 'P%' OR externalId = 'f8b2de96-39bd-46c7-9c88-bbb949e0e9b2') AND datasetId = 3701037531680276;

SELECT d.id, d.name FROM public.datasets d JOIN public.datasets p ON d.externalid = p.externalid;

SELECT * FROM public.labels WHERE externalid != 'SisterInstance.SIL.SILVariable' OR (name ='Optix Alarm' AND description='viola')

SELECT * FROM public.Files WHERE (source = 'FTDM' AND dataSetId > 23457689) OR (mimeType = 'image/jpeg' AND dataSetId < 543000056769245 );

SELECT * from datamodelling.spaces;

SELECT COUNT(*) AS total spaces FROM datamodelling.spaces;

SELECT DATE(createdtime) AS creation_date, COUNT(*)FROM SpacesGROUP BY DATE(createdtime)ORDER BY creation_date DESC;

SELECT * FROM datamodelling.spaces WHERE isglobal = true AND isglobal = false;

SELECT COUNT(*) AS total datamodels FROM datamodelling.datamodels;

SELECT * FROM datamodelling.datamodelsWHERE description IS NULLOR isglobal = false;

SELECT LOWER(space) FROM datamodeling.datamodels;

SELECT * FROM datamodelling.datamodels WHERE description = 'ggreyer';

SELECT name FROM datamodeling.views order by name desc;

SELECT space, name, externalidFROM datamodels.containers;

SELECT *FROM datamodels.containersWHERE LENGTH(usedfor) > (SELECT AVG(LENGTH(usedfor)) FROM datamodels.containers);

SELECT externalid, COUNT(*) AS occurrencesFROM datamodels.containersGROUP BY externalidHAVING COUNT(*) > 1;

SELECT name FROM datamodeling.views order by name desc;

SELECT Countofcarnivores FROM animals.testexternalid_mammals ORDER BY Countofcarnivores ASC;

SELECT CAST(createdTime AS DATE) AS creation_date, COUNT(*) AS views_created FROM datamodeling.views GROUP BY CAST(createdTime AS DATE) ORDER BY creation_date;

SELECT * FROM animals.testexternalid_mammals WHERE DOB BETWEEN '2025-08-08' AND '2026-08-09';