# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1373 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1374 --- ## [SQL Query Builder in Report Data Source is producing an invalid query](https://forum.inductiveautomation.com/t/sql-query-builder-in-report-data-source-is-producing-an-invalid-query/34056)
**Author:** [@Ali.Etezadkhah](https://forum.inductiveautomation.com/u/Ali.Etezadkhah)\ **Replies:** 12\ **Last updated:** [April 21, 2020, 5:13pm UTC](https://forum.inductiveautomation.com/t/sql-query-builder-in-report-data-source-is-producing-an-invalid-query/34056 "2020-04-21T17:13:25Z")
Hi, I’m trying to create a test report using data from a transaction group. When I use the SQL Query Builder and select the entire table, the query works fine. When I select specific columns using the Builder, I ge… --- ## [Bit in double integer](https://forum.inductiveautomation.com/t/bit-in-double-integer/34079)
**Author:** [@tom.wouters](https://forum.inductiveautomation.com/u/tom.wouters)\ **Replies:** 1\ **Last updated:** [April 21, 2020, 4:14pm UTC](https://forum.inductiveautomation.com/t/bit-in-double-integer/34079 "2020-04-21T16:14:40Z")
Dear experts, I have a window where i added a custom property to link to a data type. This data type consists of one “CMD” which is a doubleinteger DI0 to be precise. Now this window will be my main sequence example a… --- ## [New error opening windows?](https://forum.inductiveautomation.com/t/new-error-opening-windows/34073)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 3\ **Last updated:** [April 21, 2020, 4:03pm UTC](https://forum.inductiveautomation.com/t/new-error-opening-windows/34073 "2020-04-21T16:03:00Z")
I recently merged a Vision project with a Perspective project so they can share scripting modules. Now as of tihs morning after making this push, oddly enough the navigation in my Vision project is acting buggy - someti… --- ## [Perspective Conditional format on Table Row](https://forum.inductiveautomation.com/t/perspective-conditional-format-on-table-row/28478)
**Author:** [@rodrigo.mocca](https://forum.inductiveautomation.com/u/rodrigo.mocca)\ **Replies:** 3\ **Last updated:** [April 21, 2020, 1:24pm UTC](https://forum.inductiveautomation.com/t/perspective-conditional-format-on-table-row/28478 "2020-04-21T13:24:50Z")
Hi, I’m traying to display a table based on a Named Query, and change it background color based on a cell value, but I can’t find anything to do that. This is my table How can I change a row background color based … --- ## [Tag Scaling by End User](https://forum.inductiveautomation.com/t/tag-scaling-by-end-user/34072)
**Author:** [@melwadeya](https://forum.inductiveautomation.com/u/melwadeya)\ **Replies:** 0\ **Last updated:** [April 21, 2020, 12:55pm UTC](https://forum.inductiveautomation.com/t/tag-scaling-by-end-user/34072 "2020-04-21T12:55:50Z")
Hello, I am trying to add a checkbox that allows the end user to enable linear tag scaling. How is it possible on the tag editor? any help is greatly appreciated. Thanks. --- ## [Comments Panel Extension Function NameError: self is not defined](https://forum.inductiveautomation.com/t/comments-panel-extension-function-nameerror-self-is-not-defined/18544)
**Author:** [@bill.diblasi](https://forum.inductiveautomation.com/u/bill.diblasi)\ **Replies:** 4\ **Last updated:** [April 21, 2020, 11:52am UTC](https://forum.inductiveautomation.com/t/comments-panel-extension-function-nameerror-self-is-not-defined/18544 "2020-04-21T11:52:27Z")
I am defining the insertNote extension function for a Comments Panel, Ignition 7.9.7, and I am having trouble using the 'self' reference. The Comments Panel is in a template, and the problem is occurring while testing … --- ## [M-bus device to Ignition](https://forum.inductiveautomation.com/t/m-bus-device-to-ignition/34070)
**Author:** [@miculacristianradu](https://forum.inductiveautomation.com/u/miculacristianradu)\ **Replies:** 2\ **Last updated:** [April 21, 2020, 11:26am UTC](https://forum.inductiveautomation.com/t/m-bus-device-to-ignition/34070 "2020-04-21T11:26:36Z")
Hello guys, It is possible to connect a M-bus device, like a meter to Ignition? We need to put the data from the meter in our SCADA system, and when I try to add a new device I don’t see M-bus on the protocol list. Th… --- ## [Historical data replay](https://forum.inductiveautomation.com/t/historical-data-replay/34069)
**Author:** [@bpien](https://forum.inductiveautomation.com/u/bpien)\ **Replies:** 1\ **Last updated:** [April 21, 2020, 9:36am UTC](https://forum.inductiveautomation.com/t/historical-data-replay/34069 "2020-04-21T09:36:25Z")
Hello, I want to ask if Ignition have buil-in historical data replay function. I need to build displays which can show system states in past data. If not, I am open to any suggestion how to develop this function. I us… --- ## [Obtain Private Key from generated CSR](https://forum.inductiveautomation.com/t/obtain-private-key-from-generated-csr/34061)
**Author:** [@Andrew.Zebic](https://forum.inductiveautomation.com/u/Andrew.Zebic)\ **Replies:** 6\ **Last updated:** [April 21, 2020, 3:23am UTC](https://forum.inductiveautomation.com/t/obtain-private-key-from-generated-csr/34061 "2020-04-21T03:23:28Z")
Hi, We’re running a setup where we have a main and backup gateway, and we want both gateways to have SSL encryption with the same certificate. I will need the private key that Ignition auto-generates to be installed on … --- ## [Identity Provider option missing](https://forum.inductiveautomation.com/t/identity-provider-option-missing/30790)
**Author:** [@Dmart](https://forum.inductiveautomation.com/u/Dmart)\ **Replies:** 6\ **Last updated:** [April 21, 2020, 2:49am UTC](https://forum.inductiveautomation.com/t/identity-provider-option-missing/30790 "2020-04-21T02:49:50Z")
Hello, Using Version 8.0.6 I’m trying to setup my user authentication in my Perspective project but the “Identity Provider” drop-down is completely missing in my Project settings. I’ve gone through every Security sett… --- ## [Ignition 8: Yellow Background normal?](https://forum.inductiveautomation.com/t/ignition-8-yellow-background-normal/24258)
**Author:** [@pjgonzales](https://forum.inductiveautomation.com/u/pjgonzales)\ **Replies:** 11\ **Last updated:** [April 21, 2020, 2:44am UTC](https://forum.inductiveautomation.com/t/ignition-8-yellow-background-normal/24258 "2020-04-21T02:44:12Z")
Installed Ignition 8 and I’ve noticed that when I create a new View the background of the window is a corn-yellow color, even after I change the background color. When I launch the URL the background is the correct color… --- ## [Import tags with scalemode and alarms](https://forum.inductiveautomation.com/t/import-tags-with-scalemode-and-alarms/34044)
**Author:** [@AnthonyF](https://forum.inductiveautomation.com/u/AnthonyF)\ **Replies:** 7\ **Last updated:** [April 20, 2020, 11:06pm UTC](https://forum.inductiveautomation.com/t/import-tags-with-scalemode-and-alarms/34044 "2020-04-20T23:06:24Z")
Hi all, Trying to update a large number of tags that are configured with alarms, based off the configuration they had in the SCADA package we are converting from. I’ve already partially configured the alarms and need t… --- ## [\[BUG\]8.0.11-rc1 Numeric UDT parameters now appear as floats when used in OPC\_Item\_Path](https://forum.inductiveautomation.com/t/bug-8-0-11-rc1-numeric-udt-parameters-now-appear-as-floats-when-used-in-opc-item-path/33600)
**Author:** [@DaveD24](https://forum.inductiveautomation.com/u/DaveD24)\ **Replies:** 11\ **Last updated:** [April 20, 2020, 9:51pm UTC](https://forum.inductiveautomation.com/t/bug-8-0-11-rc1-numeric-udt-parameters-now-appear-as-floats-when-used-in-opc-item-path/33600 "2020-04-20T21:51:31Z")
After upgrading from 8.0.10 to 8.0.11-rc1 all OPC tags that use UDT numeric parameters fail with Config Error. Example: OPC\_ItemPath = \[{Driver\_Name}\]{Modbus\_Address}.HRUI{Modbus\_Offset+18452} With following Parameter… --- ## [Linked servers connection](https://forum.inductiveautomation.com/t/linked-servers-connection/34012)
**Author:** [@f1\_beto](https://forum.inductiveautomation.com/u/f1_beto)\ **Replies:** 6\ **Last updated:** [April 20, 2020, 7:45pm UTC](https://forum.inductiveautomation.com/t/linked-servers-connection/34012 "2020-04-20T19:45:02Z")
I try do database connections used Microsoft SQLServer JDBC Driver with linked servers of SQL SERVER 2012 EXPRESS but i can’t. --- ## [Remote gateway error status after renaming remote server](https://forum.inductiveautomation.com/t/remote-gateway-error-status-after-renaming-remote-server/34047)
**Author:** [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Replies:** 1\ **Last updated:** [April 20, 2020, 7:11pm UTC](https://forum.inductiveautomation.com/t/remote-gateway-error-status-after-renaming-remote-server/34047 "2020-04-20T19:11:49Z")
After renaming a remote server (okay, I fat-fingered it and had to rename it twice), I see a Defined\_NeverConected status on the old names. Is there any way I can get rid of them, as they technically don’t exist anymore? … --- ## [Change Log with Old Value](https://forum.inductiveautomation.com/t/change-log-with-old-value/33811)
**Author:** [@BryanB](https://forum.inductiveautomation.com/u/BryanB)\ **Replies:** 2\ **Last updated:** [April 20, 2020, 4:52pm UTC](https://forum.inductiveautomation.com/t/change-log-with-old-value/33811 "2020-04-20T16:52:16Z")
Hello, We have a new project (v8.0.10) that has the following requirement for a tag change log: Tag name Timestamp Username of who made change Old value New value This would be doing things like recording the old and… --- ## [Power table column translation](https://forum.inductiveautomation.com/t/power-table-column-translation/14704)
**Author:** [@brocha](https://forum.inductiveautomation.com/u/brocha)\ **Replies:** 4\ **Last updated:** [April 20, 2020, 4:32pm UTC](https://forum.inductiveautomation.com/t/power-table-column-translation/14704 "2020-04-20T16:32:24Z")
On the table component there is column translation in the table customizer, but where is the located for the power table? I am using a power table but I need to change an integer to text and have not found where the tra… --- ## [Browsercore problems continue](https://forum.inductiveautomation.com/t/browsercore-problems-continue/32947)
**Author:** [@weertske](https://forum.inductiveautomation.com/u/weertske)\ **Replies:** 8\ **Last updated:** [April 20, 2020, 3:09pm UTC](https://forum.inductiveautomation.com/t/browsercore-problems-continue/32947 "2020-04-20T15:09:42Z")
@PGriffith Paul, this a continuation of our discussion. Although 8.0.10-rc1 helped, there is an underlying problem with binding to an array of datasets. Whenever I bind to an array of datasets to pass data to a param in … --- ## [OPC-UA Connection Fault](https://forum.inductiveautomation.com/t/opc-ua-connection-fault/34043)
**Author:** [@Tom.S](https://forum.inductiveautomation.com/u/Tom.S)\ **Replies:** 1\ **Last updated:** [April 20, 2020, 1:55pm UTC](https://forum.inductiveautomation.com/t/opc-ua-connection-fault/34043 "2020-04-20T13:55:23Z")
I am relatively new to Ignition and was recently woken up to face this issue and was hopeful you could help me out here. In the OPC section of the web console the connection section, Connection -\> “Ignition OPC-UA Serve… --- ## [Attempting to open new session, but session already open for this thread](https://forum.inductiveautomation.com/t/attempting-to-open-new-session-but-session-already-open-for-this-thread/16154)
**Author:** [@abishur](https://forum.inductiveautomation.com/u/abishur)\ **Replies:** 5\ **Last updated:** [April 20, 2020, 1:54pm UTC](https://forum.inductiveautomation.com/t/attempting-to-open-new-session-but-session-already-open-for-this-thread/16154 "2020-04-20T13:54:18Z")
Using Ignition 7.9.2 Once a minute, every minute I get the following two errors in my log. I'm not sure what's creating them and from what I can tell each one says the exact same thing. Any ideas? PersistanceInterf… --- ## [Cannot coerce value into Dataset](https://forum.inductiveautomation.com/t/cannot-coerce-value-into-dataset/32808)
**Author:** [@informatica](https://forum.inductiveautomation.com/u/informatica)\ **Replies:** 15\ **Last updated:** [April 20, 2020, 12:09pm UTC](https://forum.inductiveautomation.com/t/cannot-coerce-value-into-dataset/32808 "2020-04-20T12:09:17Z")
Good afternoon. In Ignition 8.0.9, when I restart the server I see this error in logs.: Cannot coerce value '{“columns”:\[{“name”:“Fecha\_Hora\_Ejecucion\_Ciclo”,“type”:“java.util.Date”}, {“name”:“Segundos\_Duracion\_Ciclo”… --- ## [Alarm Count scripting](https://forum.inductiveautomation.com/t/alarm-count-scripting/34045)
**Author:** [@Abiodun.Martins](https://forum.inductiveautomation.com/u/Abiodun.Martins)\ **Replies:** 0\ **Last updated:** [April 20, 2020, 9:00am UTC](https://forum.inductiveautomation.com/t/alarm-count-scripting/34045 "2020-04-20T09:00:57Z")
Good Morning, How can i make my alarm count button on a popup to show the alarms of the selected system? --- ## [Report:Timeseries Chart](https://forum.inductiveautomation.com/t/report-timeseries-chart/33973)
**Author:** [@jingocv](https://forum.inductiveautomation.com/u/jingocv)\ **Replies:** 4\ **Last updated:** [April 20, 2020, 8:51am UTC](https://forum.inductiveautomation.com/t/report-timeseries-chart/33973 "2020-04-20T08:51:36Z")
Please Help Me!!! In the report module, I want to achieve an effect as shown in Figure 1st, but i have got the last one.When I use TimeSeries Chart , I choose pen Style as bar(But I didn’t find anywhere where the widt… --- ## [Equipment Scheduler DownTime Dates](https://forum.inductiveautomation.com/t/equipment-scheduler-downtime-dates/34022)
**Author:** [@john.furby](https://forum.inductiveautomation.com/u/john.furby)\ **Replies:** 0\ **Last updated:** [April 18, 2020, 12:50am UTC](https://forum.inductiveautomation.com/t/equipment-scheduler-downtime-dates/34022 "2020-04-18T00:50:30Z")
Resolved due to typos. Please delete --- ## [V7 Global Resource Change Log](https://forum.inductiveautomation.com/t/v7-global-resource-change-log/33649)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 6\ **Last updated:** [April 19, 2020, 10:04pm UTC](https://forum.inductiveautomation.com/t/v7-global-resource-change-log/33649 "2020-04-19T22:04:27Z")
v7.9.9 I’m looking to see what global resources have been edited in a log, similar to the project details log in the gateway webpage example below: Is something like this available for the global resources? --- ## [Alarm Status details](https://forum.inductiveautomation.com/t/alarm-status-details/34040)
**Author:** [@Abiodun.Martins](https://forum.inductiveautomation.com/u/Abiodun.Martins)\ **Replies:** 0\ **Last updated:** [April 19, 2020, 7:01pm UTC](https://forum.inductiveautomation.com/t/alarm-status-details/34040 "2020-04-19T19:01:45Z")
What specialized component would i use to get specific details of alarms of the motors i selected, if i have more than one motors and each motor has high and low alarm. --- ## [PERSPECTIVE XY Chart loading is slow and unable to save designer when bullets are enabled](https://forum.inductiveautomation.com/t/perspective-xy-chart-loading-is-slow-and-unable-to-save-designer-when-bullets-are-enabled/34037)
**Author:** [@guganathan.r](https://forum.inductiveautomation.com/u/guganathan.r)\ **Replies:** 3\ **Last updated:** [April 19, 2020, 5:42pm UTC](https://forum.inductiveautomation.com/t/perspective-xy-chart-loading-is-slow-and-unable-to-save-designer-when-bullets-are-enabled/34037 "2020-04-19T17:42:12Z")
Hi, I just tried to use xy chart from a SQL DB. As long as I maintain the series rendering as line without bullets, the chart loads faster without any issue. Whenever I enable bullets, system becomes too slow and design… --- ## [Momentary toggle two tags with one push button](https://forum.inductiveautomation.com/t/momentary-toggle-two-tags-with-one-push-button/34030)
**Author:** [@jgraham](https://forum.inductiveautomation.com/u/jgraham)\ **Replies:** 3\ **Last updated:** [April 19, 2020, 11:07am UTC](https://forum.inductiveautomation.com/t/momentary-toggle-two-tags-with-one-push-button/34030 "2020-04-19T11:07:56Z")
Is there a simple method to momentarily toggle two tags using a momentary PB (or other control component) or is a script necessary? --- ## [Renaming a folder](https://forum.inductiveautomation.com/t/renaming-a-folder/34023)
**Author:** [@SteveE](https://forum.inductiveautomation.com/u/SteveE)\ **Replies:** 2\ **Last updated:** [April 18, 2020, 8:40pm UTC](https://forum.inductiveautomation.com/t/renaming-a-folder/34023 "2020-04-18T20:40:23Z")
I'm using the code snippet from system.tag.move - Ignition User Manual 8.0 - Ignition Documentation This function will move a folder in a tag provider to a new folder Since both paths are at the same node, the "Old\_Fo… --- ## [New user alarm questions](https://forum.inductiveautomation.com/t/new-user-alarm-questions/34031)
**Author:** [@Ali.Etezadkhah](https://forum.inductiveautomation.com/u/Ali.Etezadkhah)\ **Replies:** 2\ **Last updated:** [April 19, 2020, 2:53am UTC](https://forum.inductiveautomation.com/t/new-user-alarm-questions/34031 "2020-04-19T02:53:38Z")
Hi, I have enabled alarms and history for tags in my UDT and see an alarm and timer icon in the Trait column of the Tag Browser, however, the icons do not show up for the instances based on the definition. In the ins… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1372) [Next page](https://forum.inductiveautomation.com/latest.md?page=1374)