All topics

Mapping Windows External Groups to Canary Group v24

We've installed a new v24 Canary server and I'd like to know if there is a way to map our existing Windows Groups to Canary Groups in Identity ahead of time? I was able to map one that I belong to,…

• Answered

Restrict Data Type in Data Entry Control

Is there a way to restrict values entered into a Data entry Control? For instance, I only want people to put a 0 or a 1.

Search Filter in MQTT Tags Working Correctly?

It seems to be ignoring slashes and auto-wildcard on spaces. You can see in this screenshot the tag path search does not match correctly. "BESSs/BESS 6/" seems to be converted to "*BESSs*BESS*6*"

Duration a Tag is Greater than a value

Hello, I am trying to create a calculation that will tell me the total time in the last 24 hours when a tag has a value greater than a set value (example 50) Has anyone done this already?…

EventTable Download Option

Hi, I have created some event calculation and made some Event Properties to be calculated when the event trigger. Is there any option to send the event report to client with event property data.…

• Answered

Need help with simple script to change IsVisible property

I am looking for some help with a simple script to set the IsVisible property of a Symbol. For instance, let's say The source of the Symbol1 is set to a value box (ValueBox1),…

SQL connection issue for tag attributes in views configuration

I have a test installation with data in a SQL database that is already sending time-series data through the SQL collector. I'm trying to connect to the same DB in the Views configuration to pick up…

Pass Asset Type up to Dependent View

We have 2 business units, each with their own slightly different View. Then we have a 3rd View that combines them. From my testing, if I create an Asset Rule in a View,…

Possible to Correct Timestamps?

One of our sites had an issue where it wasn't syncing to our NTP server properly for a few days so all our data for those days is in UTC time instead of local.…

Rollup calculation syntax

I'm trying to create a rollup calculation but I don't really understand he syntax and I can't find any examples. I have a virtual view with these asset types: one Company, with multiple Sites,…

• Answered

Events Table Optimization

We are trying to optimize performance of the Events and Event Properties table, is it advisable to add Indexing and table partitions to achieve this?

Quality of PreviousValue

Is there a way to get the quality of the PreviousValue of a tag in Calc and Events. I try to use Quality('PreviousValue('[tag]')'), but I get an error for this.

All valueboxes in a row getting time from a datetimepicker

Hi Today I have datetimepickers scripted towards valueboxes in a grid. One datetimepicker for each row in the grid. The grid as it is today is 7 columns and 20 rows.…

Backfill To vs Remove Old Data

How are Backfill To and Remove Old Data related? Below are the definitions from the documentation. So Backfill To will be leveraged anytime the calc is saved or the calc service is started up?…

Asset hierarchy definition help

I have a dataset populated by a CSV collector and I am trying to create a virtual view to put the tags into an asset hierarchy. The tag names are of the form CsvTag.<site>.…

• Answered

Request to share their experience working with Canary vs. GE Proficy or other historians.

Dear All, Could you please share your experience in using Canary to replace GE Proficy or in place of it? What made you to choose Canary and how is the experience so far?

• Answered

Calculations stuck in Backfilling

I have several calculations that are stuck in 'Backfilling' and never go to Live Mode. This obviously means calculations that depend on them can't start.…

• Answered

UFL collector fails to start

I have installed the UFL collector, following https://helpcenter.canarylabs.com/t/m1y8gkj/how-to-configure-the-csv-collector-version-24 but after installation, the install folder looks different:…

• Answered