Tables

| Overview

A Table is a simple and better view of the status and details of a system/building/zone. It can define and display parameters at different levels of a system/building/zone, and further help in easy management and troubleshooting

A Table Viewer allows a user to create customized tables, which enable them to:

• View the statuses of zones/systems.
• Overview of a system/zone.
• Establish comparisons between systems/zones.
• Faster troubleshooting of any discrepancies in a system/zone.

The advantages of a Table are:

• Hassle-free configuration for support users and easy views for Facilisight users
• More Haystack flexibility through the usage of tags.
• User-friendly approach through editable parameter names.

The Tables share a common framework within a common framework system. For more information on Common Framework please refer to the Common Framework for Tools.

| Accessing the Table Creation

To access the Table Viewer from the Internal Portal

• Log into the Internal portal.
• Select the building in scope.

The site overview page is displayed.

• Select the Table dropdown to display the Tables option.

• Click Add Table.

| Types of Tables

The Tables are categorized into three types depending on visibility. They are as follows:

• Created by me
• Shared by others.

Table Created by Me:

Tables created by me are the ones that are created by the signed-in users and shared with other users. This is visible to all Internal and ClimaVision users once shared.

Tables Shared by Others:

The Tables shared by others are the ones that are created by other users as shared tables. This as well is visible to all Internal and ClimaVision users once shared.

The Table section displays any table created and enabled already for the site as below.

| Creating a Table

• Click on the Add Table option.

Note: Already created tables under the personal, shared by me, and shared by others displays as below

• Click on Create New Table to create a new table.

The Table builder is displayed.

Note: Once Tables have been created, they are listed in alphabetical order in the table list.

Table Builder

The table builder provides the user with options to search, select, and add points, add why and what description and conditions on point values, and define the visualized value. 

The following table explains the various fields displayed on the page: 

Add Points

The points filtered using the tags are all auto selected. with the point name being a combination of the tags used to filter, as below.

• Use the edit icon to edit the point name as per the requirement.

Define Condition

• Uncheck the No Conditions and Click Add Condition to add conditions to the points selected and define the point as below.

Note: You can add up to 40 conditions and 100 parameters as below.

• Click the Palette option to select a color for the point condition and definition.

• Select the module data that you want to calculate for the specific point. Module data can be individual, an average, highest, or lowest for a point.

Select:

•  
  • Individual Module Data - To apply the filter condition for individual module-level data in a zone.
  • Highest Module Data - To apply the filter condition for the highest of all the module data in a zone.
  • Average Module Data -To apply the filter condition for the average of all the module data.
  • Lowest Module Data - To apply the filter condition for the lowest of the module data.

• Select the No Condition checkbox if no condition is to be applied to a point.

Repeat the above steps and add more required points to the table.

Repeat the steps to add conditions to add conditions to the newly added points.

Note: It is a best practice to leave the point name at the combination of the tags, which will be a refernce for the other users to replicate or reuse the query.

• Click Create a New Table to confirm the table.

The table is created with a success message. The table is available for enabling in the table dropdown menu under the type of  table it was created as.

For more application specific table templates refer to Table Templates

Enabling Write Capability for Points Added

The write functionality for added points allows users to view and write values at different levels in a priority array based on selection. It also allows for bulk edit of values for a parameter.

• Select the check box Enable Write at Level to make the point added writable.
• Select the priority level at which the write of the point added should happen when the write is carried out using the table writing capability.

| Applying the Table for View on Site Overview

• Check / Select the tables from the list to apply it for viewing in the site dashboard.

| Creating Physical Points using Custom Query 

Custom query builder can be used to create a zone physical points table as shown below:

The available physical points can be observed for currently available device types like SmartNode, HelioNode, SmartStat, and HyperStat.

It should be noted that heirarchy does not work for physical points when custom query is used.

| Editing a Table

The parameters in a table can be modified according to the required data to be captured for the devices included for a zone or a system.

• Click on the Gear icon for an existing table.
• Click Edit table option to display an existing table. 

Or 

• Click on the edit icon from the tables list to further edit the table.

A warning message window pops up as shown below, with information about the number of sites using the table and the consequences of editing the table.

• Click Continue to edit.

The Edit table window opens for edits. 

• Make the necessary changes.
• Click Update table to add the updated parameters to the table.

• Click Create a New table to copy the changes to a new table.

• Click Cancel to cancel any changes made to the table.

The  table is updated successfully.

Note: Only a personal Table or a table created by me can be edited to make any specific changes. Editing a table is not applicable to  Table shared by others.

| Export, Transpose, View Conditions & Remove from View

• Click on the Gear icon in the  table menu to download and export the table.

The table can be exported in Excel & PNG formats.

Transpose

A Table can be transposed to view the parameters in a row-to-column or column-to-row format.

• Click on the Gear icon in the table menu to transpose a table.

Remove Table from View

• Uncheck the table to remove it from the view.

Note: Once a table is removed from view, it can be viewed again by clicking the checkbox against the table dropdown.

| Deleting a Table

A table can only be deleted if created by the user. This is applicable only to the tables created by me and the Personal tables.

Note: A user cannot delete a  table shared by others.

• Click the edit icon from the table list for the table that needs to be deleted.

• Click Delete to delete the Table.

A warning message window pops up as shown below, with information about the number of sites using the table and the consequences of deleting the table.

• Click Delete to confirm deletion.

| Table Hierarchy View

The hierarchy view is a feature in the table that enables the user to visualize the information in the table in a hierarchical manner.

• Enable the Hierarchy radio button for the same as below.

Note: For custom query tables where tables have a combination of parameters corresponding to zone/system/building, a hierarchy will not be available.

| Bulk Edit Writable Parameters

The tables also provide the capability to bulk edit the writable parameters when writable parameters are added to a  table.

It is also capable of defining any parameter as a writable parameter, as shown in the sections above.

This capability would let support users easily edit writeable parameters from the  table at once, rather than from the other section in the internal portal many times.

This is enabled by a paradigm similar to what was used in the site explorer tool of the portal.

• Select the check box View Priority Array & Edit Parameter Value, to view the writeable parameters, and their priority array information.

Once the check box is selected all the applicable writable parameters in the table display an edit icon as above. For the tuner parameters, the priority array information is displayed. 

• Click the edit icon next to a writable parameter to access the writable parameter bulk edit window. as below.

The writable parameter bulk edit window provides the user with the following capabilities.

• Fill in the value change you wish to write for the parameter in the value field.
• Enter the duration for which you want the change in value to be valid for, in the hours, minutes, and seconds fields.
• Select a particular parameter to push the value change to,

Or

• Select multiple parameters to push the value change to.

• Click Update to confirm the writable parameter value change.

The override confirmation window pops up.

• Click Override to confirm the change.

The update successful message is displayed, and the writable parameter value change is reflected in the table as below.

Note:

• For certain parameters like conditioning mode, schedule status, valid input is to be given to avoid CCU crashes. There are no validations in place with respect to the value input for a parameter.
• Priority array tables would be cleared if the user provides null values or provides values for a specified duration.

| Examples

Example 1: 75F - App and Firmware Versions Tracker

A shared table created to monitor the CCU App and Firmware Versions.

Filter for Bundle App Points

Filter Query: (bundle and version and diag)

Filter for CCU App Points

Filter Query: (( app or migration) and  bundle and version and diag)

Filter for Home App Points

Filter Query: (home and version and diag)

Filter for Remote App Points

Filter Query: ((remoteAccess and home and diag) or (domainName==@remoteAccessAppVersion))

Filter for BACnet App Points

Filter Query: (bacnet and version and diag)

Filter for Firmware Version Points

Filter Query: firmware and version 

Table View

Example 2: Zone Damper Details

A shared table created to monitor Zone Damper Details.

Filter for Damper Feedback Points

Filter Tags: dab and domainName

Filter for Damper Normalized Position Points

Filter Tags: damper and normalized and order

Filter for Damper Base Position Points

Filter Tags: damper and base and order

Filter for Minimum Damper Cooling Points

Filter Tags: min and damper and cooling

Filter for Maximum Damper Cooling Points

Filter Tags: max and damper and cooling

Filter for Current Temperature Points

Filter Tags: temp and space

Filter for Cooling Desired Temperature Points

Filter Tags: desired and temp and cooling

Filter for Temperature Offset Points

Filter Tags: offset and dab and domainName

Table View

Example 3: Firmware OTA Status

A shared table created to monitor OTA status updates.

Filter for OTA Status Points

Filter Tags: ota and status

Conditions are based on the enums for the OTA status points.