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;