# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=873 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 874 --- ## [Perspective Table Selected Data Only Shows Visible Data Columns](https://forum.inductiveautomation.com/t/perspective-table-selected-data-only-shows-visible-data-columns/57417)
**Author:** [@awaege1](https://forum.inductiveautomation.com/u/awaege1)\ **Replies:** 6\ **Last updated:** [March 21, 2022, 4:16pm UTC](https://forum.inductiveautomation.com/t/perspective-table-selected-data-only-shows-visible-data-columns/57417 "2022-03-21T16:16:23Z")
I am currently working on designing a queue management tool in which I am using the perspective table as an interface for the user to reorder rows, insert new ones, and delete existing ones. To allow for inserts and re-… --- ## [Real Time Trending](https://forum.inductiveautomation.com/t/real-time-trending/57400)
**Author:** [@Nicholas\_Houston](https://forum.inductiveautomation.com/u/Nicholas_Houston)\ **Replies:** 2\ **Last updated:** [March 21, 2022, 4:11pm UTC](https://forum.inductiveautomation.com/t/real-time-trending/57400 "2022-03-21T16:11:44Z")
What would cause a real time trend to suddenly start acting in this manner in the middle of the night? I have looked at the settings, audit logs, and tag collection rates and nothing was changed / modified. Any help with… --- ## [Translate alarm eventState in alarm notification message](https://forum.inductiveautomation.com/t/translate-alarm-eventstate-in-alarm-notification-message/52296)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 2\ **Last updated:** [March 21, 2022, 2:37pm UTC](https://forum.inductiveautomation.com/t/translate-alarm-eventstate-in-alarm-notification-message/52296 "2022-03-21T14:37:16Z")
In alarm notification message, we can use some format for time, but is it possible to translate the “event state” ? Example: At {eventTime|hh:mm:ss}, alarm "{name} - {label}" at "{displayPath}" transitioned to {eventSt… --- ## [Button mouseReleased action still works when button disabled](https://forum.inductiveautomation.com/t/button-mousereleased-action-still-works-when-button-disabled/57413)
**Author:** [@hewking32](https://forum.inductiveautomation.com/u/hewking32)\ **Replies:** 2\ **Last updated:** [March 21, 2022, 2:20pm UTC](https://forum.inductiveautomation.com/t/button-mousereleased-action-still-works-when-button-disabled/57413 "2022-03-21T14:20:41Z")
Hi Small thing but it bugs me - If button property “Enabled” is FALSE then the code behind does not execute but when the same code is behind mouse released event handler is executes regardless Enabled property. Is it no… --- ## [Query tags vs transaction manager vs system.db.runScalarQuery](https://forum.inductiveautomation.com/t/query-tags-vs-transaction-manager-vs-system-db-runscalarquery/57410)
**Author:** [@hewking32](https://forum.inductiveautomation.com/u/hewking32)\ **Replies:** 4\ **Last updated:** [March 21, 2022, 1:34pm UTC](https://forum.inductiveautomation.com/t/query-tags-vs-transaction-manager-vs-system-db-runscalarquery/57410 "2022-03-21T13:34:24Z")
hi I am trying to organize my understanding regarding topics mentioned in the title. Please feel free to comment and share your knowledge/understanding below topics 1 Query tags might be putting significant load on da… --- ## [Darker color expression not working](https://forum.inductiveautomation.com/t/darker-color-expression-not-working/57389)
**Author:** [@Gratliff](https://forum.inductiveautomation.com/u/Gratliff)\ **Replies:** 6\ **Last updated:** [March 21, 2022, 1:22pm UTC](https://forum.inductiveautomation.com/t/darker-color-expression-not-working/57389 "2022-03-21T13:22:40Z")
I have a label (or any other component) on which I’m binding the background color to an expression. The expression is darker(color(255,255,0)). Once I apply the binding, the following is shown as the value: java.awt.Co… --- ## [Printing Multiple Reports at Once](https://forum.inductiveautomation.com/t/printing-multiple-reports-at-once/18772)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 11\ **Last updated:** [July 10, 2018, 6:05pm UTC](https://forum.inductiveautomation.com/t/printing-multiple-reports-at-once/18772 "2018-07-10T18:05:29Z")
I have a button that will print the current report viewer, but I want to loop through and print all my reports with a single button push. This is what I've got currently without any luck. Thanks, reports = \['Optimi… --- ## [Perspective Horizontal Menu opening new tab instead of in existing](https://forum.inductiveautomation.com/t/perspective-horizontal-menu-opening-new-tab-instead-of-in-existing/57405)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 1\ **Last updated:** [March 21, 2022, 9:55am UTC](https://forum.inductiveautomation.com/t/perspective-horizontal-menu-opening-new-tab-instead-of-in-existing/57405 "2022-03-21T09:55:58Z")
It’s probably more a feature request, but I have a horizontal menu with a tab targetted to another gateway’s Perspective project, but this link opens in a new tab instead of the existing one. I have a link to each other’… --- ## [\[FEATURE\] Add warning to things that don't apply to inheritable/non-runnable projects](https://forum.inductiveautomation.com/t/feature-add-warning-to-things-that-dont-apply-to-inheritable-non-runnable-projects/57402)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 4\ **Last updated:** [March 21, 2022, 12:23am UTC](https://forum.inductiveautomation.com/t/feature-add-warning-to-things-that-dont-apply-to-inheritable-non-runnable-projects/57402 "2022-03-21T00:23:09Z")
I’ve just been tripped up (again) by gateway timer scripts set up in a global project that doesn’t run due to being in an unrunnable inheritable project. Can warnings please be added into places affected by this? Or eve… --- ## [Gateway Script unable to upload file to FTP server](https://forum.inductiveautomation.com/t/gateway-script-unable-to-upload-file-to-ftp-server/57340)
**Author:** [@mandeep\_gill](https://forum.inductiveautomation.com/u/mandeep_gill)\ **Replies:** 5\ **Last updated:** [March 20, 2022, 7:10pm UTC](https://forum.inductiveautomation.com/t/gateway-script-unable-to-upload-file-to-ftp-server/57340 "2022-03-20T19:10:23Z")
Hi I need some direction to identify the issue. Ignition Version 8.1.14 and OS windows server 2019 I am working with a script which is querying the data from tag history and create xml file and connect to FTP server a… --- ## [V7.x and V8.x Service Name conflict](https://forum.inductiveautomation.com/t/v7-x-and-v8-x-service-name-conflict/41525)
**Author:** [@sbrannen](https://forum.inductiveautomation.com/u/sbrannen)\ **Replies:** 4\ **Last updated:** [March 20, 2022, 4:45pm UTC](https://forum.inductiveautomation.com/t/v7-x-and-v8-x-service-name-conflict/41525 "2022-03-20T16:45:33Z")
Just a head's-up. Inductive changed the service name from "Ignition Gateway" in v7 to "Ignition" in v8. Unfortunately this conflicts with Dell Secure Red Cloak's hidden service name "Ignition". So if, as in our case, R… --- ## [\[FEATURE\] Display Project Saved timestamp in local time not gateway time](https://forum.inductiveautomation.com/t/feature-display-project-saved-timestamp-in-local-time-not-gateway-time/57399)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 9\ **Last updated:** [March 20, 2022, 12:56pm UTC](https://forum.inductiveautomation.com/t/feature-display-project-saved-timestamp-in-local-time-not-gateway-time/57399 "2022-03-20T12:56:05Z")
Currently this time is in gateway time. I’m working on a gateway in the US but am located in Australia so this makes it difficult for me to actually know what time it was last saved --- ## [How to purge the MySQL General Log file?](https://forum.inductiveautomation.com/t/how-to-purge-the-mysql-general-log-file/57393)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 3\ **Last updated:** [March 20, 2022, 12:10pm UTC](https://forum.inductiveautomation.com/t/how-to-purge-the-mysql-general-log-file/57393 "2022-03-20T12:10:11Z")
The MySQL general log has grown to 325 GB. I’m not going to read it all so I’d like to get my disk back. What’s the procedure for this? I presume that I’ll have to at least stop the MySQL service. Do I need to stop Igni… --- ## [Project design and configuration](https://forum.inductiveautomation.com/t/project-design-and-configuration/57148)
**Author:** [@Luke\_Abraams](https://forum.inductiveautomation.com/u/Luke_Abraams)\ **Replies:** 4\ **Last updated:** [March 19, 2022, 5:14pm UTC](https://forum.inductiveautomation.com/t/project-design-and-configuration/57148 "2022-03-19T17:14:19Z")
Hey everyone, just learning to use Ignition. I have some questions on the path I need to take for proper configuration/setup of a project I am working on. A lot of the project will be scripts, most will be event based … --- ## [Queries/sec by client](https://forum.inductiveautomation.com/t/queries-sec-by-client/57051)
**Author:** [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\ **Replies:** 3\ **Last updated:** [March 19, 2022, 9:47am UTC](https://forum.inductiveautomation.com/t/queries-sec-by-client/57051 "2022-03-19T09:47:55Z")
Good morning, I would like to ask you if there is any way to know the QueriesPerSec divided by client. Now I’m just displaying the total I read from the variable System \> Gateway \> Database. Thank you for the help! --- ## [How to trigger script on timestamp change](https://forum.inductiveautomation.com/t/how-to-trigger-script-on-timestamp-change/57361)
**Author:** [@Alistair\_Trout](https://forum.inductiveautomation.com/u/Alistair_Trout)\ **Replies:** 7\ **Last updated:** [March 19, 2022, 9:12am UTC](https://forum.inductiveautomation.com/t/how-to-trigger-script-on-timestamp-change/57361 "2022-03-19T09:12:51Z")
Hi Guys, So I’m trying to make a counter for a system I’m helping build - we’ve got 1D/2D scanners that take an image of a QR code, the scanner then sends this value to a tag on ignition as a string. Unfortunately the i… --- ## [Success message popup](https://forum.inductiveautomation.com/t/success-message-popup/57386)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 1\ **Last updated:** [March 19, 2022, 7:52am UTC](https://forum.inductiveautomation.com/t/success-message-popup/57386 "2022-03-19T07:52:04Z")
Is it possible to do something like this in Perspective? --- ## [Can not move container after copy and paste](https://forum.inductiveautomation.com/t/can-not-move-container-after-copy-and-paste/57380)
**Author:** [@andrews](https://forum.inductiveautomation.com/u/andrews)\ **Replies:** 3\ **Last updated:** [March 18, 2022, 9:58pm UTC](https://forum.inductiveautomation.com/t/can-not-move-container-after-copy-and-paste/57380 "2022-03-18T21:58:29Z")
Running 7.8.5 I copy and past a container to duplicate object and just change params. but i can not move the main container around the window, only the components inside. --- ## [Limits of system.util.sendMessage](https://forum.inductiveautomation.com/t/limits-of-system-util-sendmessage/57374)
**Author:** [@bradbarbin](https://forum.inductiveautomation.com/u/bradbarbin)\ **Replies:** 8\ **Last updated:** [March 18, 2022, 9:54pm UTC](https://forum.inductiveautomation.com/t/limits-of-system-util-sendmessage/57374 "2022-03-18T21:54:28Z")
Is there a known throughput limit for receiving messages to a single project with message handlers in Ignition? --- ## [Support for AWS Outpost and MSSQL RDS](https://forum.inductiveautomation.com/t/support-for-aws-outpost-and-mssql-rds/53633)
**Author:** [@sqlwalkermj](https://forum.inductiveautomation.com/u/sqlwalkermj)\ **Replies:** 2\ **Last updated:** [March 18, 2022, 8:52pm UTC](https://forum.inductiveautomation.com/t/support-for-aws-outpost-and-mssql-rds/53633 "2022-03-18T20:52:38Z")
Hello - I’m working with a client and wanted to see if anyone is running their architecture on an AWS Outpost, specifically with an MSSQL database backend. I noticed the Ignition Architecture documentation mentions supp… --- ## [Run Always expression processing sequence](https://forum.inductiveautomation.com/t/run-always-expression-processing-sequence/57366)
**Author:** [@cstatzer](https://forum.inductiveautomation.com/u/cstatzer)\ **Replies:** 9\ **Last updated:** [March 18, 2022, 8:50pm UTC](https://forum.inductiveautomation.com/t/run-always-expression-processing-sequence/57366 "2022-03-18T20:50:04Z")
Transaction group - Run-Always Expressions, sequence of processing I am trying to use the order of the processing of Items in the Run\_Always Expressions, but the it does not appear that the items are processing in order… --- ## [\[IGN-5736\] Perspective DateTimePicker AM/PM Bug](https://forum.inductiveautomation.com/t/ign-5736-perspective-datetimepicker-am-pm-bug/57370)
**Author:** [@Nikolai\_Wolterstorff](https://forum.inductiveautomation.com/u/Nikolai_Wolterstorff)\ **Replies:** 1\ **Last updated:** [March 18, 2022, 8:02pm UTC](https://forum.inductiveautomation.com/t/ign-5736-perspective-datetimepicker-am-pm-bug/57370 "2022-03-18T20:02:21Z")
Ignition version: 8.1.15 (b2022030114). With a Perspective DateTimePicker component, if you set props.value AM/PM opposite of what is currently displayed in the component, it doesn’t update the component and causes weir… --- ## [Table Group in Reporting](https://forum.inductiveautomation.com/t/table-group-in-reporting/57351)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 4\ **Last updated:** [March 18, 2022, 6:03pm UTC](https://forum.inductiveautomation.com/t/table-group-in-reporting/57351 "2022-03-18T18:03:56Z")
Hi I am using peer table group in reports I want to give some space between the 2 tables ( right now its touching each other) Is there are any way give some separation between the tables? I tired to figure but i co… --- ## [Accessing dynamically to components](https://forum.inductiveautomation.com/t/accessing-dynamically-to-components/57367)
**Author:** [@Manuel\_Lefebvre](https://forum.inductiveautomation.com/u/Manuel_Lefebvre)\ **Replies:** 3\ **Last updated:** [March 18, 2022, 4:36pm UTC](https://forum.inductiveautomation.com/t/accessing-dynamically-to-components/57367 "2022-03-18T16:36:58Z")
Hi, I want to modify the value of every numeric entry field of a container dynamically. For example, I have a container with 20 numeric entry fields and I want to set their value to 0 within a loop by pressing a button… --- ## [Launch a side project with main project resources](https://forum.inductiveautomation.com/t/launch-a-side-project-with-main-project-resources/57364)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 1\ **Last updated:** [March 18, 2022, 3:51pm UTC](https://forum.inductiveautomation.com/t/launch-a-side-project-with-main-project-resources/57364 "2022-03-18T15:51:07Z")
I have a main project onsite that has auto commit update for any saves. One of the clients only need to run windows that hardly ever change, although it would be great to have them automatically sync somehow with the ma… --- ## [Month in a query without month text](https://forum.inductiveautomation.com/t/month-in-a-query-without-month-text/53100)
**Author:** [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Replies:** 74\ **Last updated:** [March 18, 2022, 3:08pm UTC](https://forum.inductiveautomation.com/t/month-in-a-query-without-month-text/53100 "2022-03-18T15:08:38Z")
how do you get a column of your table to say the name of the month and the year for which some events happened? I want to display data in rows by the last six months so for the first column June 2021, July 2021...Novem… --- ## [\[BUG-15901\] JSON encoding and decoding a "Dataset" datatype property](https://forum.inductiveautomation.com/t/bug-15901-json-encoding-and-decoding-a-dataset-datatype-property/31617)
**Author:** [@haitham.sumrain](https://forum.inductiveautomation.com/u/haitham.sumrain)\ **Replies:** 12\ **Last updated:** [March 18, 2022, 3:00pm UTC](https://forum.inductiveautomation.com/t/bug-15901-json-encoding-and-decoding-a-dataset-datatype-property/31617 "2022-03-18T15:00:15Z")
I am trying to pass a value of “Dataset” type as a value in a dictionary which I need to store in a “String” format. Assume the following: dataset: variable of type “Dataset” dict = {‘set’ : dataset} To build the stri… --- ## [Error Java null key argument](https://forum.inductiveautomation.com/t/error-java-null-key-argument/57354)
**Author:** [@taguililla](https://forum.inductiveautomation.com/u/taguililla)\ **Replies:** 2\ **Last updated:** [March 18, 2022, 2:37pm UTC](https://forum.inductiveautomation.com/t/error-java-null-key-argument/57354 "2022-03-18T14:37:54Z")
Hello. We have the next error on Report viewer 12:14:53.320 \[AWT-EventQueue-0\] WARN reporting.Preview - Error generating preview java.util.concurrent.ExecutionException: java.lang.IllegalArgumentException: Null ‘ke… --- ## [Modbus Input register - Uncertain\_InitialValue](https://forum.inductiveautomation.com/t/modbus-input-register-uncertain-initialvalue/57360)
**Author:** [@William\_Oliver\_Foste](https://forum.inductiveautomation.com/u/William_Oliver_Foste)\ **Replies:** 1\ **Last updated:** [March 18, 2022, 1:05pm UTC](https://forum.inductiveautomation.com/t/modbus-input-register-uncertain-initialvalue/57360 "2022-03-18T13:05:56Z")
I have an issue reading modbus input register on a inverter configured ass follow: The OPC Item path i tried is: ns=1;s=\[INV13\]IR1 I also tried \[INV13\]IR1 However radzio and modbuspoll read correctly I think… --- ## [Remote server rejected web socket: Duplicate connection](https://forum.inductiveautomation.com/t/remote-server-rejected-web-socket-duplicate-connection/57155)
**Author:** [@taguililla](https://forum.inductiveautomation.com/u/taguililla)\ **Replies:** 3\ **Last updated:** [March 18, 2022, 11:22am UTC](https://forum.inductiveautomation.com/t/remote-server-rejected-web-socket-duplicate-connection/57155 "2022-03-18T11:22:08Z")
Hello. We have the next error on logs. We have a lost connection on Gateway Network, but the error talk about a duoble connection, but… there is an only connection. Could you help us? Thank you. Best regards. [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=872) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=874)