'<assetid>' ASSET '<propertyname>' PROPERTY VALUES
This function returns the value of propertyname for the asset assetid.
This function returns all of the properties that are available for the asset. Note that these are properties and not points - they won't contain the actual values.
This function returns all of the points that are available for the asset, which in turn give you the values.
'<assetid>' ASSET '<relationshipname>' RELATIONSHIP 'down' RELATED
This function returns a list of assets that are downstream from assetid along relationshipname.
'<assetid>' ASSET ('Temperature','Status') PROPERTY POINTS
This script gets values for both Temperature and Status from assetid.
('<assetida>','<assetidb>') ASSET 'Temperature' PROPERTY POINTS { “range”: “today” } GETHISTORY
This function gets the temperature history for both assetida and assetidb for today.
'<assetid>' ASSET MEDIA 'name' '*isolation*' FILTERMAP
This gets a list of all media items on assetid that has a 'name' that includes the text 'isolation'.
'<assetid>' ASSET {“Table”: “<tablename>”} GETTABLE
Gets table entries from the specified connected tables for a specific asset.
NOTE: It might be simpler to use API functions for this call - it is provided as an example of a complex query that builds a program rather than a simple query
This returns every direct relationship an asset has with its neighbours.
Note that each relationship and direction is returned as a separate stack item, so they can be easily identified.
'<assetid>' ASSET 'asset' SET RELS 'rels' SET [ 'asset' GET SWAP 'ddown' RELATED 'index' GET ' downstream' CONCAT NAME ] EACH EAT 'rels' GET [ 'asset' GET SWAP 'dup' RELATED 'index' GET ' upstream' CONCAT NAME ] EACH EAT 'rels' GET
See specific examples for more.