New AQL Function: V2C

New AQL Function: V2C

V2C

V2C converts a list of point values to a list of constants

Every AQL data point as an asset, a property and a value. The V2C function takes the value out of those points and turns it into a list of constants. 

This is often used when you have property values that contain the names of other assets that you want to query.

Example

Let's imagine that you have a number of different power distribution boards around your site, named DB1, DB2, DB3 etc. Each of these boards has a Power Use property. You've also got a smart machine - the Boggler - that knows the ID of the distribution board its been plugged into, which appears in ARDI as the Distribution Board property.

If we want to determine how much power the Boggler is using, we first need to find the name of the distribution board.
'Boggler' ASSET 'Distribution Board' PROPERTY VALUES
RESULT: [DATA POINT: Boggler Distribution Board = 'DB2']

This gets us the name of the distribution board - for example, DB2.

But right now the result is a data point. If we want to find out the power usage on distribution board two, we're going to need an asset. This is where we can use the V2C function.

'Boggler' ASSET 'Distribution Board' PROPERTY VALUES V2C ASSET 'Power Usage' PROPERTY VALUES
RESULT: [DATA POINT: Distribution Board DB2 Power Usage = '5.72A']

V2C takes the values we found and converts it into a constant list. It effectively turns our final query into ('DB2') ASSET 'Power Usage' PROPERTY VALUES

This way, we can follow single, or even complex chains of named assets in a single AQL query.

    • Related Articles

    • New AQL Function: P2A

      P2A P2A converts a list of points to a list of assets.  Every AQL data point as an asset, a property and a value. The P2A function takes the asset id out of those points and turns it into a list.  This can be used to ask for more information from an ...
    • Clearing your ARDI Cache

      How do I clear my ARDI-VE Cache? ARDI-VE maintains a cache of the content on your server - it keeps copies of your 3D models and textures on your local machine so you don't need to download them when you connect, saving a significant amount of time. ...
    • Finding your ARDI-VE Log Files

      How do I find my Log File for ARDI-VE? Every ARDI database and every PC is a little different - a unique mix of assets, hardware, software and security.  This means that every now and then, something doesn't work as expected. When this happens, ...
    • Aspentech IP21

      ARDI can connect to Aspentech IP21 using the new IP21 driver. This includes both a Live data driver, which extracts the most recent information out of the historian, and the Historical driver to be able to access points from history. Performance of ...
    • OPC-UA

      ARDI can connect to OPC-UA clients using the new OPCUA driver. Note that OPC-UA is only a live driver. Historical data access is not currently available. Performance Note The driver does take a while to establish the initial connection - it takes ...