Hey Jan,
I assume you just need to display the properties (with the date/description), and you do not need to perform automatic processing and storage of the property changing. If this assumption is correct, then the following script should be a good starting point.
If there is a need for historical storage of these alarms, then you could leverage the 'DataChange' event and write a subscription which stores the property values to either a stream or a datatable.
Here is the aforementioned script. Please note, I used a custom dataShape called AlarmPropertiesDataShape which you would either have to create or change within the script.
// Create the result infotable from a custom datashape
// This datashape contains:
// CreateInfoTableFromDataShape(infoTableName:STRING("InfoTable"), dataShapeName:STRING):INFOTABLE(AlarmPropertiesDataShape)
var result = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({
infoTableName : "InfoTable",
dataShapeName : "AlarmPropertiesDataShape"
// Get the Property values with the time, value, and quality (VTQ)
// The VTQ results for each property is an infotable within each property column
// result: INFOTABLE dataShape: "undefined"
var propertiesVTQ = me.GetPropertyValuesVTQ();
// Loop through the infotable columns (the properties), and if it meets the criteria, add it to the result infotable.
var infotableColumns = Object.keys(propertiesVTQ.rows[0]);
for (var key in infotableColumns) {
columnName = String(infotableColumns[key]);
// propertiesVTQ (from GetPropertyValuesVTQ()) will always return a single row, so it is safe to reference that row using index 0.
// Since we have the column name, we can just use bracket notation to reference the specific column within that row ==> propertiesVTQ.rows[0][columnName]
// Additionally, we know that the value for this column is an infotable, so its single row can be referenced using the rows object: (propertiesVTQ.rows[0][columnName]).rows[0]
var vtqInfotableForProperty = (propertiesVTQ.rows[0][columnName]).rows[0];
// Within this vtq row, you will have a value, time and a quality.
// if the value is one, add the new row to your result infotable
if (vtqInfotableForProperty.value == 1) {
newRow.Name = columnName;
newRow.Value = vtqInfotableForProperty.value;
newRow.Time = vtqInfotableForProperty.time;
// Add the row to the infotable.
// Lastly, get the properties descriptions and perform an inner join on it against the result infotable.
// result: INFOTABLE dataShape: "PropertyDefinition"
var propertyDefinitions = me.GetPropertyDefinitions({
type: undefined /* STRING /</div><div>});</div><div><br></div><div>// Use the Intersect function to perform an inner join</div><div>// result: INFOTABLE</div><div>var result = Resources["InfoTableFunctions"].Intersect({</div><div><span class="Apple-tab-span" style="white-space: pre;"> </span>t2: propertyDefinitions / INFOTABLE /,</div><div><span class="Apple-tab-span" style="white-space: pre;"> </span>t1: result / INFOTABLE /,</div><div><span class="Apple-tab-span" style="white-space: pre;"> </span>joinColumns2: "name" / STRING /,</div><div> joinColumns1: "Name" / STRING -- note, this is case sensitive, and my datashape has "Name" defined, not 'name' /,</div><div><span class="Apple-tab-span" style="white-space: pre;"> </span>columns2: "description" / STRING /,</div><div><span class="Apple-tab-span" style="white-space: pre;"> </span>columns1: "Name,Value,Time" / STRING /,</div><div><span class="Apple-tab-span" style="white-space: pre;"> </span>joinType: "INNER" / STRING */
Lastly, I can send an export of this script in a Thing if you want a working version. Let me know.
