# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1049 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1050 --- ## [Report Components visibility option](https://forum.inductiveautomation.com/t/report-components-visibility-option/44393)
**Author:** [@Premnath.K](https://forum.inductiveautomation.com/u/Premnath.K)\ **Replies:** 0\ **Last updated:** [March 12, 2021, 7:46am UTC](https://forum.inductiveautomation.com/t/report-components-visibility-option/44393 "2021-03-12T07:46:47Z")
I am using a cross tab for showing the day-wise data for a month in a cumulative manner in reports, I could not accommodate the entire 30 days data in one cross tab so split it into two cross tab like days 1 to 15 and da… --- ## [Perspective XY Chart Y-Axis format](https://forum.inductiveautomation.com/t/perspective-xy-chart-y-axis-format/44353)
**Author:** [@pascal](https://forum.inductiveautomation.com/u/pascal)\ **Replies:** 2\ **Last updated:** [March 12, 2021, 7:24am UTC](https://forum.inductiveautomation.com/t/perspective-xy-chart-y-axis-format/44353 "2021-03-12T07:24:08Z")
Hi there, I have a little formatting problem with XY Chart in Perspective. I’m using Ignition 8.0.16. On a XY Chart, i have set my Y-Axis value format to #,###. I use a french locale so normally, when i launch a sessio… --- ## [Unable to hide columns in Perspective Table](https://forum.inductiveautomation.com/t/unable-to-hide-columns-in-perspective-table/44349)
**Author:** [@DougSN](https://forum.inductiveautomation.com/u/DougSN)\ **Replies:** 4\ **Last updated:** [March 12, 2021, 3:43am UTC](https://forum.inductiveautomation.com/t/unable-to-hide-columns-in-perspective-table/44349 "2021-03-12T03:43:05Z")
I must be doing something wrong here, but I don’t see what it is. I have a column view in Perspective, and a Table component with a named query on the data binding. There are several UUID columns that I need to be in the… --- ## [Just Curious if its possible](https://forum.inductiveautomation.com/t/just-curious-if-its-possible/44156)
**Author:** [@toddayers](https://forum.inductiveautomation.com/u/toddayers)\ **Replies:** 3\ **Last updated:** [March 12, 2021, 3:16am UTC](https://forum.inductiveautomation.com/t/just-curious-if-its-possible/44156 "2021-03-12T03:16:40Z")
Right now our supervisors are using attendance sheets that have been created using excel. They pull up these sheets and print them off each day to provide to the coordinators to check off which employees are at work for … --- ## [Json viewer tools](https://forum.inductiveautomation.com/t/json-viewer-tools/44384)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 4\ **Last updated:** [March 12, 2021, 1:25am UTC](https://forum.inductiveautomation.com/t/json-viewer-tools/44384 "2021-03-12T01:25:29Z")
I use notepad++ a lot for viewing tag Json with the plugins ‘JSTool’ and ‘JSON Viewer’ which are great for the most part, however when you’re viewing a large number of tags and trying to use find to search for specific t… --- ## [Ignition Perspective Demo App, IIoT Stack Light Video Feed](https://forum.inductiveautomation.com/t/ignition-perspective-demo-app-iiot-stack-light-video-feed/44340)
**Author:** [@jrankin](https://forum.inductiveautomation.com/u/jrankin)\ **Replies:** 2\ **Last updated:** [March 11, 2021, 11:45pm UTC](https://forum.inductiveautomation.com/t/ignition-perspective-demo-app-iiot-stack-light-video-feed/44340 "2021-03-11T23:45:33Z")
Hello, Could someone at IA turn the Ignition Perspective Demo App, IIoT Stack Light Video Feed camera back on? It currently shows a red dotted line around the image. I like to use this in my automation-related classes … --- ## [Driven Scan Class Complete Notification](https://forum.inductiveautomation.com/t/driven-scan-class-complete-notification/44377)
**Author:** [@CJVR](https://forum.inductiveautomation.com/u/CJVR)\ **Replies:** 2\ **Last updated:** [March 11, 2021, 10:34pm UTC](https://forum.inductiveautomation.com/t/driven-scan-class-complete-notification/44377 "2021-03-11T22:34:50Z")
We are setting up a tag as an array with 6000 elements that will read an array from a PLC when instructed to. We were thinking of using a separate scan class for the tag, making it driven, setting one shot to true, and u… --- ## [Help with an error message](https://forum.inductiveautomation.com/t/help-with-an-error-message/44343)
**Author:** [@Ali.Etezadkhah](https://forum.inductiveautomation.com/u/Ali.Etezadkhah)\ **Replies:** 3\ **Last updated:** [March 11, 2021, 8:53pm UTC](https://forum.inductiveautomation.com/t/help-with-an-error-message/44343 "2021-03-11T20:53:47Z")
Hi, How do I get more information about an error like this? Every time I navigate to this page, I get this error message, but it doesn’t give me any useful information to track down the cause of it. I have not set any… --- ## [Modify / Disable entries in Easy Chart Popup](https://forum.inductiveautomation.com/t/modify-disable-entries-in-easy-chart-popup/44373)
**Author:** [@tobiasatats](https://forum.inductiveautomation.com/u/tobiasatats)\ **Replies:** 0\ **Last updated:** [March 11, 2021, 6:04pm UTC](https://forum.inductiveautomation.com/t/modify-disable-entries-in-easy-chart-popup/44373 "2021-03-11T18:04:13Z")
Hi, I’d like to remove the "Save as… " and “Print” options from the Popup right on the easy chart. Any Ideas / possiblity for that? I found only these guys here, which will do the same as the properties right on the ea… --- ## [View the wrapper.log File in a Client or Designer](https://forum.inductiveautomation.com/t/view-the-wrapper-log-file-in-a-client-or-designer/10156)
**Author:** [@nmudge](https://forum.inductiveautomation.com/u/nmudge)\ **Replies:** 7\ **Last updated:** [March 11, 2021, 5:55pm UTC](https://forum.inductiveautomation.com/t/view-the-wrapper-log-file-in-a-client-or-designer/10156 "2021-03-11T17:55:19Z")
The Perfect Abstractions development team recently released an Ignition project that enables people to easily see the wrapper.log file in a client or designer. This project solves the problem of not having remote access… --- ## [Removing Non-ASCII Characters](https://forum.inductiveautomation.com/t/removing-non-ascii-characters/44367)
**Author:** [@alexfediw](https://forum.inductiveautomation.com/u/alexfediw)\ **Replies:** 1\ **Last updated:** [March 11, 2021, 4:34pm UTC](https://forum.inductiveautomation.com/t/removing-non-ascii-characters/44367 "2021-03-11T16:34:02Z")
Hello, I am trying to display a string that I get from a tag. The displayed value is appearing like the picture included: I am trying to remove the trailing characters using: split({tagName},’\[^\\x00-\\x7F\]’)\[0\] But … --- ## [Cannot concatenate 'unicode' and 'int' objects : Error](https://forum.inductiveautomation.com/t/cannot-concatenate-unicode-and-int-objects-error/44366)
**Author:** [@seanbuckley2698](https://forum.inductiveautomation.com/u/seanbuckley2698)\ **Replies:** 6\ **Last updated:** [March 11, 2021, 4:11pm UTC](https://forum.inductiveautomation.com/t/cannot-concatenate-unicode-and-int-objects-error/44366 "2021-03-11T16:11:19Z")
When trying to give the body of an email I have the following code... system.net.sendEmail(smtpProfile="SendInBlue", fromAddr="notification@ticketingsystemfyp.com", subject="Request Submission Confirmation", body="Hello… --- ## [Reset configuration](https://forum.inductiveautomation.com/t/reset-configuration/44365)
**Author:** [@lachguerabdallah](https://forum.inductiveautomation.com/u/lachguerabdallah)\ **Replies:** 2\ **Last updated:** [March 11, 2021, 3:57pm UTC](https://forum.inductiveautomation.com/t/reset-configuration/44365 "2021-03-11T15:57:57Z")
hello Is there a way to get the instances back to the same udt configuration? thanks you --- ## [Is it possible to color fill certain cells in a Reporting table or Crosstab?](https://forum.inductiveautomation.com/t/is-it-possible-to-color-fill-certain-cells-in-a-reporting-table-or-crosstab/44336)
**Author:** [@framebuilder](https://forum.inductiveautomation.com/u/framebuilder)\ **Replies:** 2\ **Last updated:** [March 11, 2021, 3:37pm UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-color-fill-certain-cells-in-a-reporting-table-or-crosstab/44336 "2021-03-11T15:37:52Z")
Ignition 8.0.16 Is it possible to add any logic to Reporting components that allow color coding of cells in a table, simple table, or crosstab? For instance, we want to populate table with a dataset of integers but col… --- ## [\[SOLVED\] How to get PyRows to work in 8.0.16](https://forum.inductiveautomation.com/t/solved-how-to-get-pyrows-to-work-in-8-0-16/39961)
**Author:** [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Replies:** 5\ **Last updated:** [March 11, 2021, 3:37pm UTC](https://forum.inductiveautomation.com/t/solved-how-to-get-pyrows-to-work-in-8-0-16/39961 "2021-03-11T15:37:30Z")
Good morning, This webpage has a new section titled PyRow. I am trying to run the example given but am getting an error in the script console. Can someone help me understand why? https://docs.inductiveautomation.com/di… --- ## [Alarms event in remote tag provider not sended to AlarmJournal](https://forum.inductiveautomation.com/t/alarms-event-in-remote-tag-provider-not-sended-to-alarmjournal/43558)
**Author:** [@avg](https://forum.inductiveautomation.com/u/avg)\ **Replies:** 2\ **Last updated:** [March 11, 2021, 3:25pm UTC](https://forum.inductiveautomation.com/t/alarms-event-in-remote-tag-provider-not-sended-to-alarmjournal/43558 "2021-03-11T15:25:53Z")
Hello, everybody! I’ve got a project with two providers: One default local provider. One remote provider setup via a Gateway Connection with a secondary Ignition Gateway. I’ve got different alarms defined in remote p… --- ## [Communications & Scripting Query](https://forum.inductiveautomation.com/t/communications-scripting-query/44332)
**Author:** [@colin.bonner](https://forum.inductiveautomation.com/u/colin.bonner)\ **Replies:** 5\ **Last updated:** [March 11, 2021, 2:55pm UTC](https://forum.inductiveautomation.com/t/communications-scripting-query/44332 "2021-03-11T14:55:38Z")
So lets say I decide to monitor how long a falling temperature takes to drop below a predefined value by using a while loop as shown: An event script will kick this off as it knows that the temperature is about to start… --- ## [Remote Audit over Gateway Network](https://forum.inductiveautomation.com/t/remote-audit-over-gateway-network/44328)
**Author:** [@tim.schultz](https://forum.inductiveautomation.com/u/tim.schultz)\ **Replies:** 2\ **Last updated:** [March 11, 2021, 2:43pm UTC](https://forum.inductiveautomation.com/t/remote-audit-over-gateway-network/44328 "2021-03-11T14:43:02Z")
I have two gateways, both running 8.1.2. They are successfully connected via gateway network. I set up the centralized server (the incoming connection side of gateway network) with an ‘internal’ audit profile, and the … --- ## [Mysql connection fault between 2 desktops pc's help](https://forum.inductiveautomation.com/t/mysql-connection-fault-between-2-desktops-pcs-help/43994)
**Author:** [@trishadx](https://forum.inductiveautomation.com/u/trishadx)\ **Replies:** 8\ **Last updated:** [March 3, 2021, 10:16am UTC](https://forum.inductiveautomation.com/t/mysql-connection-fault-between-2-desktops-pcs-help/43994 "2021-03-03T10:16:58Z")
Hi guys I’ve got a network of 3 desktop PC’s all connected via a switch with ethernet cables. They are all on the same default gateway “192.168.0.3” and all of the same network " 192.168.0.xxx". 1 will be the primary PC… --- ## [View() expression function where clause not working](https://forum.inductiveautomation.com/t/view-expression-function-where-clause-not-working/44361)
**Author:** [@gfeiten](https://forum.inductiveautomation.com/u/gfeiten)\ **Replies:** 3\ **Last updated:** [March 11, 2021, 2:16pm UTC](https://forum.inductiveautomation.com/t/view-expression-function-where-clause-not-working/44361 "2021-03-11T14:16:30Z")
I’ve been starting to use pturmel’s view() function to filter data from a tag dataset. In short I have one broad query that supplies data for numerous table objects in perspective. I’m trying to avoid having each table… --- ## [SQL Server Browser Conflicts With Ignition Gateway](https://forum.inductiveautomation.com/t/sql-server-browser-conflicts-with-ignition-gateway/44318)
**Author:** [@IAI\_Colin](https://forum.inductiveautomation.com/u/IAI_Colin)\ **Replies:** 5\ **Last updated:** [March 10, 2021, 7:09pm UTC](https://forum.inductiveautomation.com/t/sql-server-browser-conflicts-with-ignition-gateway/44318 "2021-03-10T19:09:50Z")
I’m following the steps to connect a Microsoft SQL 2019 Express data base to Ignition and I’ve been having an issue with the Ignition Gateway and SQL Server Browser. When I enable SQL Server browser as per the instructi… --- ## [Delete Gateway Connection](https://forum.inductiveautomation.com/t/delete-gateway-connection/44360)
**Author:** [@deon.korb](https://forum.inductiveautomation.com/u/deon.korb)\ **Replies:** 0\ **Last updated:** [March 11, 2021, 1:30pm UTC](https://forum.inductiveautomation.com/t/delete-gateway-connection/44360 "2021-03-11T13:30:25Z")
I have a Gateway connection that was automatically created back when the Allow Proxy setting was on by default. Now I cannot find where and to delete this connection. How do I delete this proxied connection? All I can t… --- ## [How can I limit the dragging line to the edge of my project area](https://forum.inductiveautomation.com/t/how-can-i-limit-the-dragging-line-to-the-edge-of-my-project-area/44357)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 2\ **Last updated:** [March 11, 2021, 1:28pm UTC](https://forum.inductiveautomation.com/t/how-can-i-limit-the-dragging-line-to-the-edge-of-my-project-area/44357 "2021-03-11T13:28:45Z")
Hi i am using a Line and i am dragging in it window. but i want limit the dragging at edge of the window please let me know how to limit dragging near to edge of the window --- ## [Failed to write data into SQL](https://forum.inductiveautomation.com/t/failed-to-write-data-into-sql/44296)
**Author:** [@kartik.i](https://forum.inductiveautomation.com/u/kartik.i)\ **Replies:** 2\ **Last updated:** [March 11, 2021, 10:15am UTC](https://forum.inductiveautomation.com/t/failed-to-write-data-into-sql/44296 "2021-03-11T10:15:49Z")
Hello, I have an observation today that the Ignition was unable to write the data into the database table I have attached below a wrapper log for this issue could anyone tell why this happened. E \[c.i.i.g.a.DatasourceA… --- ## [MQTT Server's UDT Properties not updated](https://forum.inductiveautomation.com/t/mqtt-servers-udt-properties-not-updated/44351)
**Author:** [@yin.cheng](https://forum.inductiveautomation.com/u/yin.cheng)\ **Replies:** 0\ **Last updated:** [March 11, 2021, 8:22am UTC](https://forum.inductiveautomation.com/t/mqtt-servers-udt-properties-not-updated/44351 "2021-03-11T08:22:03Z")
Hi All I am using MQTT transmission module on a gateway, and MQTT Distribution+Engine modules on the main server. I have various UDTs created on my gateway, with numerous parameters & alarm display path configured thro… --- ## [Testing httpPost and encrypted communication](https://forum.inductiveautomation.com/t/testing-httppost-and-encrypted-communication/44249)
**Author:** [@Neo](https://forum.inductiveautomation.com/u/Neo)\ **Replies:** 5\ **Last updated:** [March 11, 2021, 6:18am UTC](https://forum.inductiveautomation.com/t/testing-httppost-and-encrypted-communication/44249 "2021-03-11T06:18:58Z")
We need to send the data to another system via rest API. This data need to be encrypted. I understand we can use system.net.httpPost function to send the data in json format. Is this correct? For encryption, installing… --- ## [Detect Lost connection to Gateway](https://forum.inductiveautomation.com/t/detect-lost-connection-to-gateway/44123)
**Author:** [@rrebro](https://forum.inductiveautomation.com/u/rrebro)\ **Replies:** 2\ **Last updated:** [March 11, 2021, 2:46am UTC](https://forum.inductiveautomation.com/t/detect-lost-connection-to-gateway/44123 "2021-03-11T02:46:31Z")
I would like to be able to detect when the connection between Ignition and the PLC is lost, on the PLC end. So I can notify the operator. What is the best way to do this? --- ## [\[System\]Mobile/Location](https://forum.inductiveautomation.com/t/system-mobile-location/26913)
**Author:** [@Robert.giles](https://forum.inductiveautomation.com/u/Robert.giles)\ **Replies:** 8\ **Last updated:** [March 11, 2021, 1:18am UTC](https://forum.inductiveautomation.com/t/system-mobile-location/26913 "2021-03-11T01:18:45Z")
In the tag browser: \[System\]Mobile/Location Looks like GPS info should populate these tags. From where? How? --- ## [COGNEX Insight Images and Overlays on Paintable Canvas](https://forum.inductiveautomation.com/t/cognex-insight-images-and-overlays-on-paintable-canvas/26933)
**Author:** [@djones](https://forum.inductiveautomation.com/u/djones)\ **Replies:** 4\ **Last updated:** [March 11, 2021, 12:37am UTC](https://forum.inductiveautomation.com/t/cognex-insight-images-and-overlays-on-paintable-canvas/26933 "2021-03-11T00:37:56Z")
There are several posts about displaying Cognex images and overlays on the ignition screen. There are a few people selling modules and there is the popular web module that can display the SVG itself. We have used the web… --- ## [Undo Truncate Database](https://forum.inductiveautomation.com/t/undo-truncate-database/44129)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 38\ **Last updated:** [March 10, 2021, 11:41pm UTC](https://forum.inductiveautomation.com/t/undo-truncate-database/44129 "2021-03-10T23:41:17Z")
Is there any way to undo a truncate command issued by the Ignition database browser? Is there any cached data that could be retrieved? [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1048) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1050)