# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1206 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1207 --- ## [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 --- ## [Changing the header background color in a Power Table in Ignition 7.9.10](https://forum.inductiveautomation.com/t/changing-the-header-background-color-in-a-power-table-in-ignition-7-9-10/40846)
**Author:** [@bob.cappelletti](https://forum.inductiveautomation.com/u/bob.cappelletti)\ **Replies:** 6\ **Last updated:** [March 11, 2021, 12:05pm UTC](https://forum.inductiveautomation.com/t/changing-the-header-background-color-in-a-power-table-in-ignition-7-9-10/40846 "2021-03-11T12:05:27Z")
I have created a Power Table and I want to change the header background color. I have tried some suggested scripts using the configureHeaderStyle, but am unable to get it to work? Thanks, see table below. --- ## [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… --- ## [Transaction Group Value Mode](https://forum.inductiveautomation.com/t/transaction-group-value-mode/23788)
**Author:** [@apgilber](https://forum.inductiveautomation.com/u/apgilber)\ **Replies:** 2\ **Last updated:** [March 11, 2021, 7:58am UTC](https://forum.inductiveautomation.com/t/transaction-group-value-mode/23788 "2021-03-11T07:58:01Z")
Hopefully someone can point out what I’m missing here. I have a standard transaction group with 20 some OPC items just for a test and it was storing everything as I expected. I wanted to see what changing the “Value Mo… --- ## [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? --- ## [8.1.4 Navigate to page URL on mouse up not accepting a property binding](https://forum.inductiveautomation.com/t/8-1-4-navigate-to-page-url-on-mouse-up-not-accepting-a-property-binding/44338)
**Author:** [@jaydavid97](https://forum.inductiveautomation.com/u/jaydavid97)\ **Replies:** 1\ **Last updated:** [March 11, 2021, 1:01am UTC](https://forum.inductiveautomation.com/t/8-1-4-navigate-to-page-url-on-mouse-up-not-accepting-a-property-binding/44338 "2021-03-11T01:01:48Z")
On mouse up I am navigating to a page, with the page URL bound to a property (which is a param for the view). This worked in 8.1.3, but in 8.1.4 when clicking the component no navigation takes place. When replacing the p… --- ## [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? --- ## [Allen-Bradley PLC upgrade](https://forum.inductiveautomation.com/t/allen-bradley-plc-upgrade/42764)
**Author:** [@Dan\_Bridgeman](https://forum.inductiveautomation.com/u/Dan_Bridgeman)\ **Replies:** 23\ **Last updated:** [March 10, 2021, 11:39pm UTC](https://forum.inductiveautomation.com/t/allen-bradley-plc-upgrade/42764 "2021-03-10T23:39:19Z")
I just learned that six of the Allen-Bradley PLCs on my system are being upgraded from an older firmware to v32. Is it possible to modify the existing connections to use the new Allen-Bradley Logix driver instead of the… --- ## [Project Scripting Library Lost On Designer Project Load?](https://forum.inductiveautomation.com/t/project-scripting-library-lost-on-designer-project-load/44277)
**Author:** [@wking](https://forum.inductiveautomation.com/u/wking)\ **Replies:** 2\ **Last updated:** [March 10, 2021, 11:02pm UTC](https://forum.inductiveautomation.com/t/project-scripting-library-lost-on-designer-project-load/44277 "2021-03-10T23:02:09Z")
Sometimes when I open a project. The scripting library in that project stops working at runtime. I have gotten into the habit of just saving the project when I open it. In this case, I can’t get it to work again. This w… --- ## [Edge gateway won't start with error java.lang.IllegalStateException: Could not read catapult properties](https://forum.inductiveautomation.com/t/edge-gateway-wont-start-with-error-java-lang-illegalstateexception-could-not-read-catapult-properties/44334)
**Author:** [@mleefers](https://forum.inductiveautomation.com/u/mleefers)\ **Replies:** 2\ **Last updated:** [March 10, 2021, 10:38pm UTC](https://forum.inductiveautomation.com/t/edge-gateway-wont-start-with-error-java-lang-illegalstateexception-could-not-read-catapult-properties/44334 "2021-03-10T22:38:35Z")
Hello, I am trying to start an 8.0.16 edge gateway and I am getting the following output in the wrapper.log file: STATUS | wrapper | 2021/03/11 14:08:30 | --\> Wrapper Started as Daemon STATUS | wrapper | 2021/03/11 … --- ## [How do I find out what my pop up ID is](https://forum.inductiveautomation.com/t/how-do-i-find-out-what-my-pop-up-id-is/44326)
**Author:** [@seanbuckley2698](https://forum.inductiveautomation.com/u/seanbuckley2698)\ **Replies:** 3\ **Last updated:** [March 10, 2021, 9:47pm UTC](https://forum.inductiveautomation.com/t/how-do-i-find-out-what-my-pop-up-id-is/44326 "2021-03-10T21:47:02Z")
How do I find out what mypopupID is? I am using this code system.perspective.openPopup('myPopupId', 'folder/myView', position = {'left':100,'top':100}) --- ## [Alarm Journal sort by Event Time](https://forum.inductiveautomation.com/t/alarm-journal-sort-by-event-time/44330)
**Author:** [@mbhagotra](https://forum.inductiveautomation.com/u/mbhagotra)\ **Replies:** 0\ **Last updated:** [March 10, 2021, 8:37pm UTC](https://forum.inductiveautomation.com/t/alarm-journal-sort-by-event-time/44330 "2021-03-10T20:37:37Z")
Hello, What’s the best way to sort the Alarm Journal (Vision) component entries based on Event Time (most recent event at the very top)? This is using version 8.1.3. Thanks! --- ## [Error column reference " " is ambiguous](https://forum.inductiveautomation.com/t/error-column-reference-is-ambiguous/44315)
**Author:** [@casian](https://forum.inductiveautomation.com/u/casian)\ **Replies:** 4\ **Last updated:** [March 10, 2021, 7:43pm UTC](https://forum.inductiveautomation.com/t/error-column-reference-is-ambiguous/44315 "2021-03-10T19:43:56Z")
Hi all, I’m using the script below on a property change event of a PLC tag and I get the error column reference “serialnumber” is ambiguous. Anybody know what that means? Thanks! if currentValue.value == True: la… --- ## [Table styling in perspective](https://forum.inductiveautomation.com/t/table-styling-in-perspective/44327)
**Author:** [@retinder.labana](https://forum.inductiveautomation.com/u/retinder.labana)\ **Replies:** 1\ **Last updated:** [March 10, 2021, 7:04pm UTC](https://forum.inductiveautomation.com/t/table-styling-in-perspective/44327 "2021-03-10T19:04:08Z")
I have created a table and I want to add red styling animation to each row that has status as “Bad” I was able to style it based on the 1st column but that styling got implemented to the entire table. How do I restrict … --- ## [Tag Problems Ignition 8.0.10](https://forum.inductiveautomation.com/t/tag-problems-ignition-8-0-10/34661)
**Author:** [@roger\_larson](https://forum.inductiveautomation.com/u/roger_larson)\ **Replies:** 3\ **Last updated:** [March 10, 2021, 5:09pm UTC](https://forum.inductiveautomation.com/t/tag-problems-ignition-8-0-10/34661 "2021-03-10T17:09:27Z")
Hi guys, We keep experiencing issues with derived tags and with UDT parameter changes in 8.0.10. We have derived tags that we know function inside of UDTs, and on occasion, these derived tags just straight up fail to t… --- ## [Perspective use of term in translation manager?](https://forum.inductiveautomation.com/t/perspective-use-of-term-in-translation-manager/41713)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 7\ **Last updated:** [March 10, 2021, 4:51pm UTC](https://forum.inductiveautomation.com/t/perspective-use-of-term-in-translation-manager/41713 "2021-03-10T16:51:32Z")
I try to translate some terms in perspective. For example, with the Table component, how to translate “Filter Table…” ? In the translation manager (with Ignore Capitalization settings) and Perspective project Locale… --- ## [Web dev sign in cookie](https://forum.inductiveautomation.com/t/web-dev-sign-in-cookie/44223)
**Author:** [@diat150](https://forum.inductiveautomation.com/u/diat150)\ **Replies:** 5\ **Last updated:** [March 10, 2021, 4:36pm UTC](https://forum.inductiveautomation.com/t/web-dev-sign-in-cookie/44223 "2021-03-10T16:36:02Z")
I have a mobile website developed using web-dev. Is there any way to control how long the session stays logged in? It seems to be somewhat erratic, but seems to mostly default to being much shorter than what I would like… --- ## [Can't find SVG file elements when I add one in Prespective](https://forum.inductiveautomation.com/t/cant-find-svg-file-elements-when-i-add-one-in-prespective/44311)
**Author:** [@abdelwahhab.m](https://forum.inductiveautomation.com/u/abdelwahhab.m)\ **Replies:** 1\ **Last updated:** [March 10, 2021, 4:04pm UTC](https://forum.inductiveautomation.com/t/cant-find-svg-file-elements-when-i-add-one-in-prespective/44311 "2021-03-10T16:04:22Z")
I can’t find elements for the SVG in Props Section. what did I miss? --- ## [How to share code in Ignition](https://forum.inductiveautomation.com/t/how-to-share-code-in-ignition/44303)
**Author:** [@patricia.mendez](https://forum.inductiveautomation.com/u/patricia.mendez)\ **Replies:** 1\ **Last updated:** [March 10, 2021, 4:01pm UTC](https://forum.inductiveautomation.com/t/how-to-share-code-in-ignition/44303 "2021-03-10T16:01:25Z")
Dear Experts, we are wondering how to share projects and code created by developers geographically distributed. Basically we are wondering if Ignition is interfaced in somehow with git. Thanks so much, Patricia --- ## [Sort the columns of a power table using scripting](https://forum.inductiveautomation.com/t/sort-the-columns-of-a-power-table-using-scripting/44264)
**Author:** [@lachguerabdallah](https://forum.inductiveautomation.com/u/lachguerabdallah)\ **Replies:** 3\ **Last updated:** [March 10, 2021, 3:24pm UTC](https://forum.inductiveautomation.com/t/sort-the-columns-of-a-power-table-using-scripting/44264 "2021-03-10T15:24:14Z")
Hello is it possible to sort the columns of a power table using scripting? thanks you --- ## [Logout by a button](https://forum.inductiveautomation.com/t/logout-by-a-button/44313)
**Author:** [@hieule221097](https://forum.inductiveautomation.com/u/hieule221097)\ **Replies:** 0\ **Last updated:** [March 10, 2021, 3:11pm UTC](https://forum.inductiveautomation.com/t/logout-by-a-button/44313 "2021-03-10T15:11:58Z")
I want to logout by a button but with the code system.security.logout() it doesn’t clear for me. [Previous page](https://forum.inductiveautomation.com/latest.md?page=1205) [Next page](https://forum.inductiveautomation.com/latest.md?page=1207)