Installers Tables

| Overview

The L2-certified installers can now create Tables to visualise parameter data on the heatmap pages. 

A table allows a user to create customized tables 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 Tables 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.

| Add a Table

To add a table from the Facilisight site dashboard screen.

• Click Tables.

The tables section is displayed, as below.

• Click Add Table to add a table to the site dashboard page.

The tables created under different categories are listed under the corresponding options.

• Created by Me - Tables created and shared by the logged-in installer
• Shared by Others - Tables created and shared by other installers.

• Select the tables you wish to add to the heatmap page.

• Click elsewhere in the screen to exit the window.

You can visualize the selected table under the corresponding section in the heatmap page, as below.

| Types of Tables

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

• Tables created by me
• Tables shared by others

Table created by Me:

The Tables shared by me are the ones that are created by the signed-in users and shared with other users. This is visible to all Installers and Facilisight 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 is visible to all Installers and Facilisight users once shared.

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

| Create a Table

To create a new Table.

• Click Add Table, and  Click Create New Table to create a new table

The Table builder is displayed.

 Table Builder

The Table builder provides the user with options to search, select, and add points, 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

• 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.

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

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

• Click Add Parameter to add more parameters to the table

• Uncheck No Conditions & Click Add Conditions to add conditions to the newly added points.

• Enter the why and what for the table.

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

• Click Create New Table to confirm the table creation.

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

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 writing of the point added should happen when the write is carried out using the table writing capability.

For more application-specific table templates, refer to Table Templates

| Applying the Table for View on Site Dashboard

• 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 hierarchy 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.

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 self. 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 seonds 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.

Table View

| Predefined Tables for Overridden Points

The Predefined tables for the overridden points feature enable facility managers and support teams to quickly identify all writable points currently overridden, along with their active priority levels.

Key Capabilities:

Real-Time Override Visibility

• Displays all writable points currently under override
• Continuously updated to reflect the latest system state
• Supports hierarchical navigation (site → building → zone → device → point)

Priority-Level Intelligence

• Each overridden point includes its active priority level (1–16)
• Helps identify which control layer is enforcing the override
• Enables quick detection of conflicts between multiple control sources

Centralized Table

• Aggregates override data into a single, easy-to-view table
• Eliminates the need to manually inspect individual devices or points
• Provides a scalable view across large deployments