Attribute array: Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 6: Line 6:


==Excel and TQL==
==Excel and TQL==
Specific entries in the Attribute array can be accessed via TQL, using the [[TQL#Arrays|INDEX clause]]. This allows for the creation of [[Excel]]s for [[indicator]]s and [[panel]]s which make use of a list of values. If an Attribute array is queried without an INDEX clause,the query returns the value at index "0". If an INDEX clause is used, but the index does not exist (e.g. INDEX 5 but the list only has 3 entries), "0" is returned.
Specific entries in the Attribute array can be accessed via [[TQL]], using the [[TQL#Arrays|INDEX clause]]. This allows for the creation of [[Excel]]s for [[indicator]]s and [[panel]]s which make use of a list of values. If an Attribute array is queried without an INDEX clause,the query returns the value at index "0". If an INDEX clause is used, but the index does not exist (e.g. INDEX 5 but the list only has 3 entries), "0" is returned.
 
==Notes==
* TQL update statements can set attributes to arrays of values.
* Session events, such as AREA_SET_ATTRIBUTE, can only set an attribute to a single value.

Revision as of 14:24, 8 January 2020

This article is a stub.

An Attribute array is an Attribute with mutiple values. In most use-cases, each Attribute only has a single numeric value. However, it is possible to assign a list of values to any Attribute.

An Attribute can be set to a list of values by entering the desired numeric values separated by spaces. The first entry is the leftmost value, and the last entry is the rightmost value. The list of values is 0-indexed, meaning the first entry is identified by the value 0. The second value is identified by the value 1, etc.

Excel and TQL

Specific entries in the Attribute array can be accessed via TQL, using the INDEX clause. This allows for the creation of Excels for indicators and panels which make use of a list of values. If an Attribute array is queried without an INDEX clause,the query returns the value at index "0". If an INDEX clause is used, but the index does not exist (e.g. INDEX 5 but the list only has 3 entries), "0" is returned.

Notes

  • TQL update statements can set attributes to arrays of values.
  • Session events, such as AREA_SET_ATTRIBUTE, can only set an attribute to a single value.