Tag Data Context (version 24)

The Tag Data Context function returns the following four fields for a set of tags: latest timestamp, latest value, latest quality, and oldest timestamp.

Input Range

A reference to a range of cells containing a list of tag names typically generated by the Tag List function. This range is automatically set to the cells that are pre-selected when the button for this function is selected. The range can be adjusted by editing the range or selecting a new range of cells then clicking the Set button. Adjusting the input range will automatically update the output location.

Show Headers

This option will display a heading for each Display Field included in the output.

Display Fields

If the Display Field name is checked, that field will be included in the output results. The order of the display field names determines the order in which they are outputted. To rearrange the order, click a field and then press the up/down buttons along the right side. You can also drag-and-drop fields to rearrange them.

Output Vertically

This option transposes the output columns and rows. If checked, the Tag Data Context fields and their contents will be listed vertically. This is useful if the Tag List is also vertical as the values can be aligned in the same row as their respective tag.

Output Location

This is the location where the output will be written to. It is the cell in the upper left corner of the result. The number of cells needed for the result will depend on the input parameters. The number of columns and rows returned is dependent on the number of tags and display fields. The default output location cell is set to the cell just below the left most cell of the input range (if the input range is horizontal) or just to the right of the top most cell of the input range (if the input range is vertical.)

When using input parameters referencing other cells, if the input cell changes it will automatically update the resulting data.

The Input Pane can be closed at any time by clicking on the X in the upper right corner. To re-open the Pane, click on the Canary Ribbon "Tag Data Context" button. If the cell containing an existing Canary function has the focus and the user selects the corresponding function button from the Canary Ribbon, the input controls in the Pane will be set according to the parameters of the Canary function.