# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=601 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 602 --- ## [Alarm and trend configuration lost when transferring UDT from edge to MQTT server](https://forum.inductiveautomation.com/t/alarm-and-trend-configuration-lost-when-transferring-udt-from-edge-to-mqtt-server/53491)
**Author:** [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\ **Replies:** 5\ **Last updated:** [August 2, 2023, 12:06am UTC](https://forum.inductiveautomation.com/t/alarm-and-trend-configuration-lost-when-transferring-udt-from-edge-to-mqtt-server/53491 "2023-08-02T00:06:26Z")
I tried to transfer all tags from Edge to Cloud Server via MQTT. The tags can be transferred together with its UDT, but the alarm and historian configured in the UDT are lost. Can anyone help to advise why and how it ca… --- ## [Testing Network Connection](https://forum.inductiveautomation.com/t/testing-network-connection/77259)
**Author:** [@MCC](https://forum.inductiveautomation.com/u/MCC)\ **Replies:** 2\ **Last updated:** [August 1, 2023, 11:31pm UTC](https://forum.inductiveautomation.com/t/testing-network-connection/77259 "2023-08-01T23:31:02Z")
The context is Ignition Edge 8.1 on Ubuntu linux. We have two copper Ethernet connections that take separate paths to connect to a central network. The path connected to one is preferred because it is faster. We want to… --- ## [Numlock in Ignition Vision Client on ubuntu](https://forum.inductiveautomation.com/t/numlock-in-ignition-vision-client-on-ubuntu/77254)
**Author:** [@Pat\_Korp](https://forum.inductiveautomation.com/u/Pat_Korp)\ **Replies:** 3\ **Last updated:** [August 1, 2023, 10:12pm UTC](https://forum.inductiveautomation.com/t/numlock-in-ignition-vision-client-on-ubuntu/77254 "2023-08-01T22:12:57Z")
Weird problem that I haven't been able to find the answer to. My ignition Edge (8.1.25) vision (11.1.25) instance on a particular computer running ubuntu 18 LTS does not completely honor the numlock status of the compute… --- ## [Perspective: Property change script on json returns QualifiedValues for all items](https://forum.inductiveautomation.com/t/perspective-property-change-script-on-json-returns-qualifiedvalues-for-all-items/41130)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 11\ **Last updated:** [August 1, 2023, 9:36pm UTC](https://forum.inductiveautomation.com/t/perspective-property-change-script-on-json-returns-qualifiedvalues-for-all-items/41130 "2023-08-01T21:36:11Z")
Not sure if this is intended or not, but I have an array property that contains objects (json) with two keys. I have a change script on it and I’m using currentValue.value to get the json as py objects, however i’ve foun… --- ## [Transaction groups Schedule (Day)](https://forum.inductiveautomation.com/t/transaction-groups-schedule-day/77089)
**Author:** [@Josue\_Cuadras](https://forum.inductiveautomation.com/u/Josue_Cuadras)\ **Replies:** 8\ **Last updated:** [August 1, 2023, 9:14pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-schedule-day/77089 "2023-08-01T21:14:42Z")
Is there a way to Schedule a transaction group executions day? --- ## [Certificate for system.net.httpGet()](https://forum.inductiveautomation.com/t/certificate-for-system-net-httpget/77238)
**Author:** [@bb\_ss](https://forum.inductiveautomation.com/u/bb_ss)\ **Replies:** 13\ **Last updated:** [August 1, 2023, 7:51pm UTC](https://forum.inductiveautomation.com/t/certificate-for-system-net-httpget/77238 "2023-08-01T19:51:26Z")
Hello, I am using system.net.httpGet() function to read data from server, When I have bypassCertValidation=True, I get the proper result. However when bypassCertValidation=False, I get exception \ **Author:** [@VIJAY\_S](https://forum.inductiveautomation.com/u/VIJAY_S)\ **Replies:** 3\ **Last updated:** [August 1, 2023, 7:28pm UTC](https://forum.inductiveautomation.com/t/auto-cursor-for-vision-windows-to-template/77204 "2023-08-01T19:28:53Z") Script-- window = system.gui.getWindow("Main\_View\_Trace") component = window.getComponent("Root Container.tpMainView.Text Field 3").requestFocus() #component.requestFocus() system.gui.getParentWindow(event).getCo… --- ## [Set one tag value to another tag's value on valueChanged event](https://forum.inductiveautomation.com/t/set-one-tag-value-to-another-tags-value-on-valuechanged-event/76682)
**Author:** [@ian.sebryk](https://forum.inductiveautomation.com/u/ian.sebryk)\ **Replies:** 30\ **Last updated:** [August 1, 2023, 7:19pm UTC](https://forum.inductiveautomation.com/t/set-one-tag-value-to-another-tags-value-on-valuechanged-event/76682 "2023-08-01T19:19:13Z")
we have a dataset tag whose value is from an MQTT broker. power goes out, value lost. we need to set a stored value and re-write it to the tag when it comes back online. we ALSO need to set it when the user changes th… --- ## [Multiple Alarm Pipelines Sharing One On-Call Roster](https://forum.inductiveautomation.com/t/multiple-alarm-pipelines-sharing-one-on-call-roster/76810)
**Author:** [@Icey\_Wang](https://forum.inductiveautomation.com/u/Icey_Wang)\ **Replies:** 6\ **Last updated:** [August 1, 2023, 7:17pm UTC](https://forum.inductiveautomation.com/t/multiple-alarm-pipelines-sharing-one-on-call-roster/76810 "2023-08-01T19:17:29Z")
I'm trying to generate several alarms via email. Can I use only one on-call roster for several alarm pipelines? --- ## [\[FEATURE\] Include gateway IP address and/or hostname in gwbk "backupinfo.xml" for information only](https://forum.inductiveautomation.com/t/feature-include-gateway-ip-address-and-or-hostname-in-gwbk-backupinfo-xml-for-information-only/77188)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 6\ **Last updated:** [August 1, 2023, 7:16pm UTC](https://forum.inductiveautomation.com/t/feature-include-gateway-ip-address-and-or-hostname-in-gwbk-backupinfo-xml-for-information-only/77188 "2023-08-01T19:16:04Z")
It would be incredibly useful to have the IP and/or hostname that a gwbk was taken from recorded in the backupinfo.xml included in the gwbk edit: as information only. E.g. \ \ **Author:** [@Shirshak\_Chhetri](https://forum.inductiveautomation.com/u/Shirshak_Chhetri)\ **Replies:** 6\ **Last updated:** [August 1, 2023, 9:49am UTC](https://forum.inductiveautomation.com/t/multistate-indicator-scripting/77175 "2023-08-01T09:49:03Z") if event.propertyName == 'Tag2' and event.newValue \> event.oldValue: event.source.state = 0 elif event.propertyName == 'Tag1' and event.newValue \> event.oldValue: event.source.state = 1 This is the script I'm using to… --- ## [What SQL permissions and/or tables are required to use Tag Historian?](https://forum.inductiveautomation.com/t/what-sql-permissions-and-or-tables-are-required-to-use-tag-historian/77233)
**Author:** [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Replies:** 6\ **Last updated:** [August 1, 2023, 5:48pm UTC](https://forum.inductiveautomation.com/t/what-sql-permissions-and-or-tables-are-required-to-use-tag-historian/77233 "2023-08-01T17:48:18Z")
I am working on a locked down system that doesn't allow users to CREATE tables in Microsoft SQL database. Is there documentation that details what SQL tables are required to run Tag Historian? A cursory glance at the man… --- ## [Using dict comprehension to append data](https://forum.inductiveautomation.com/t/using-dict-comprehension-to-append-data/77225)
**Author:** [@ian.sebryk](https://forum.inductiveautomation.com/u/ian.sebryk)\ **Replies:** 26\ **Last updated:** [August 1, 2023, 5:38pm UTC](https://forum.inductiveautomation.com/t/using-dict-comprehension-to-append-data/77225 "2023-08-01T17:38:32Z")
does Ignition not support comprehension? this isn't working, but it's valid code: # # 'value' is the entire dataset, we only want the assetName at this point # assetNames = {} py\_value = system.dataset.toPyDataSet(valu… --- ## [Logging out of perspective session with perspective.SessionInfo and perspective.logout](https://forum.inductiveautomation.com/t/logging-out-of-perspective-session-with-perspective-sessioninfo-and-perspective-logout/77171)
**Author:** [@Cameron\_Nickle](https://forum.inductiveautomation.com/u/Cameron_Nickle)\ **Replies:** 11\ **Last updated:** [August 1, 2023, 5:28pm UTC](https://forum.inductiveautomation.com/t/logging-out-of-perspective-session-with-perspective-sessioninfo-and-perspective-logout/77171 "2023-08-01T17:28:20Z")
Hi all, I'm currently working on a timer script that checks to see if the users that are logged into sessions exist in the database user-source and if they don't force a logout of that session. currently this is the co… --- ## [Linking tag to Alarm Pipeline](https://forum.inductiveautomation.com/t/linking-tag-to-alarm-pipeline/77234)
**Author:** [@Tom\_Chapman](https://forum.inductiveautomation.com/u/Tom_Chapman)\ **Replies:** 6\ **Last updated:** [August 1, 2023, 4:35pm UTC](https://forum.inductiveautomation.com/t/linking-tag-to-alarm-pipeline/77234 "2023-08-01T16:35:04Z")
Hi All, Having some difficulties connecting my tags to an alarm pipeline and looking for some ideas to fix Following the instructional video "alarm-pipeline-overview/8.1" and it says to use the notification tab within… --- ## [Raster Tile Using WebDev Mounted Folders](https://forum.inductiveautomation.com/t/raster-tile-using-webdev-mounted-folders/77227)
**Author:** [@Mike\_Huneycutt](https://forum.inductiveautomation.com/u/Mike_Huneycutt)\ **Replies:** 2\ **Last updated:** [August 1, 2023, 4:34pm UTC](https://forum.inductiveautomation.com/t/raster-tile-using-webdev-mounted-folders/77227 "2023-08-01T16:34:28Z")
Hey All, I couldn't seem to find good documentation on this, but I am attempting to use map in perspective and a custom raster tiles converted from jpg and then use WebDev Mounted Folders to host the tiles. Has anyone h… --- ## [Change service port in webdev module](https://forum.inductiveautomation.com/t/change-service-port-in-webdev-module/77235)
**Author:** [@italogustavoaraujo](https://forum.inductiveautomation.com/u/italogustavoaraujo)\ **Replies:** 2\ **Last updated:** [August 1, 2023, 4:18pm UTC](https://forum.inductiveautomation.com/t/change-service-port-in-webdev-module/77235 "2023-08-01T16:18:56Z")
It is possible to change the port of a service in the WebDev module, I know that by default it works in 8088, but I would like to change only the service in specific without changing the others. --- ## [Can I sum a columns value in a table with the reporting module](https://forum.inductiveautomation.com/t/can-i-sum-a-columns-value-in-a-table-with-the-reporting-module/76025)
**Author:** [@Neil\_Carty](https://forum.inductiveautomation.com/u/Neil_Carty)\ **Replies:** 4\ **Last updated:** [August 1, 2023, 3:58pm UTC](https://forum.inductiveautomation.com/t/can-i-sum-a-columns-value-in-a-table-with-the-reporting-module/76025 "2023-08-01T15:58:39Z")
I have a report that is using a SQL query and a nested query to populate a table. Is there a way to sum a columns value of the table in the Reporting Module? I know you can @value\*5@ but that is for each value returned … --- ## [Siemens OPC UA Stange Behavior](https://forum.inductiveautomation.com/t/siemens-opc-ua-stange-behavior/77215)
**Author:** [@Arnaud\_Declerck](https://forum.inductiveautomation.com/u/Arnaud_Declerck)\ **Replies:** 5\ **Last updated:** [August 1, 2023, 3:35pm UTC](https://forum.inductiveautomation.com/t/siemens-opc-ua-stange-behavior/77215 "2023-08-01T15:35:45Z")
Hi, We are using the Onboard OPC UA on a 1500 CPU. To avoid the limit of it we read data in struct and use derived tags to split that data. We see a behavior that sometime data are override to a previous state. Have … --- ## [Sometimes get 'broken' SQL binding on Vision window Numeric Text Box](https://forum.inductiveautomation.com/t/sometimes-get-broken-sql-binding-on-vision-window-numeric-text-box/77217)
**Author:** [@jeff.ryan](https://forum.inductiveautomation.com/u/jeff.ryan)\ **Replies:** 3\ **Last updated:** [August 1, 2023, 1:48pm UTC](https://forum.inductiveautomation.com/t/sometimes-get-broken-sql-binding-on-vision-window-numeric-text-box/77217 "2023-08-01T13:48:18Z")
Hello, Ignition 8.1.26, Vision, window, Numeric Text Box, bound to a SQL Query. Per this screen shot, attached pic, when the user invokes this form, it is often coming up 'red' with this 'broken link' error. All da… --- ## [Change PowerChart background colour depending on session theme](https://forum.inductiveautomation.com/t/change-powerchart-background-colour-depending-on-session-theme/77186)
**Author:** [@Mario\_Olivares](https://forum.inductiveautomation.com/u/Mario_Olivares)\ **Replies:** 4\ **Last updated:** [August 1, 2023, 1:44pm UTC](https://forum.inductiveautomation.com/t/change-powerchart-background-colour-depending-on-session-theme/77186 "2023-08-01T13:44:58Z")
Hello there everyone. I am trying to change the background of a PowerChart component depending if the session theme is "light" or "black". The idea is that when the theme is light the color would be #C0C0C0 and #555555 … --- ## [Control Techniques Drives?](https://forum.inductiveautomation.com/t/control-techniques-drives/77167)
**Author:** [@hhbauss](https://forum.inductiveautomation.com/u/hhbauss)\ **Replies:** 4\ **Last updated:** [August 1, 2023, 1:02pm UTC](https://forum.inductiveautomation.com/t/control-techniques-drives/77167 "2023-08-01T13:02:11Z")
Has anyone had any success connecting to a CT Drive and pull values? I have tried the Advanced Modbus Module (thinking I needed this because of 32 bit register values), and the standard Ignition Modbus TCP driver. I can … --- ## [How to evaluate string as script?](https://forum.inductiveautomation.com/t/how-to-evaluate-string-as-script/77087)
**Author:** [@Zach\_The](https://forum.inductiveautomation.com/u/Zach_The)\ **Replies:** 21\ **Last updated:** [August 1, 2023, 12:48pm UTC](https://forum.inductiveautomation.com/t/how-to-evaluate-string-as-script/77087 "2023-08-01T12:48:23Z")
In a component script, is there a way to evaluate a string as a line of the script? For example... system.db.runPrepUpdate(query, \[10\]) could be replaced with... i = 10 evaluate(stringFormat("system.db.runPrepUpdate… --- ## [How to auto start perspective project on windows pc?](https://forum.inductiveautomation.com/t/how-to-auto-start-perspective-project-on-windows-pc/67855)
**Author:** [@ANKIT\_BARAD](https://forum.inductiveautomation.com/u/ANKIT_BARAD)\ **Replies:** 2\ **Last updated:** [December 20, 2022, 9:15pm UTC](https://forum.inductiveautomation.com/t/how-to-auto-start-perspective-project-on-windows-pc/67855 "2022-12-20T21:15:19Z")
Is there any settings or script available for auto starting Ignition perspective project? --- ## [Alarm management center](https://forum.inductiveautomation.com/t/alarm-management-center/77199)
**Author:** [@maxime.guenet](https://forum.inductiveautomation.com/u/maxime.guenet)\ **Replies:** 1\ **Last updated:** [August 1, 2023, 9:43am UTC](https://forum.inductiveautomation.com/t/alarm-management-center/77199 "2023-08-01T09:43:27Z")
Hello, I searched, but you can confirm that there is no alarm center in the designer, where I can organize, modify or create them without having to browse tag after tag or UDT? If this is not the case, it would be a bi… --- ## [How to update plc tag value to sql server database in ignition](https://forum.inductiveautomation.com/t/how-to-update-plc-tag-value-to-sql-server-database-in-ignition/77142)
**Author:** [@Shashiraj\_P\_S](https://forum.inductiveautomation.com/u/Shashiraj_P_S)\ **Replies:** 12\ **Last updated:** [August 1, 2023, 5:31am UTC](https://forum.inductiveautomation.com/t/how-to-update-plc-tag-value-to-sql-server-database-in-ignition/77142 "2023-08-01T05:31:34Z")
How to access data from ms sql server to ignition perspective table --- ## [Unable to verify the certificate chain of trust](https://forum.inductiveautomation.com/t/unable-to-verify-the-certificate-chain-of-trust/77180)
**Author:** [@John\_Lee](https://forum.inductiveautomation.com/u/John_Lee)\ **Replies:** 0\ **Last updated:** [August 1, 2023, 2:25am UTC](https://forum.inductiveautomation.com/t/unable-to-verify-the-certificate-chain-of-trust/77180 "2023-08-01T02:25:55Z")
Hi, why below error message shows when config the web server ssl certificate? I created Server Certificate by my own CA certificate(self singed?), but when I drag and drop the CA certificate(der encoded) to the uploa… --- ## [Identity Provider Vision](https://forum.inductiveautomation.com/t/identity-provider-vision/44278)
**Author:** [@andytimc](https://forum.inductiveautomation.com/u/andytimc)\ **Replies:** 8\ **Last updated:** [August 1, 2023, 1:22am UTC](https://forum.inductiveautomation.com/t/identity-provider-vision/44278 "2023-08-01T01:22:10Z")
When I set my Identity provider as the logon source in ignition for my vision clients how do I use the security levels for security on the screen. In order to enable/disable buttons etc. I used to use the Roles in the us… --- ## [Adjust margin in a project with a heritable menu](https://forum.inductiveautomation.com/t/adjust-margin-in-a-project-with-a-heritable-menu/77173)
**Author:** [@Jair\_Lara](https://forum.inductiveautomation.com/u/Jair_Lara)\ **Replies:** 2\ **Last updated:** [July 31, 2023, 9:19pm UTC](https://forum.inductiveautomation.com/t/adjust-margin-in-a-project-with-a-heritable-menu/77173 "2023-07-31T21:19:24Z")
I am using a inheritable project with tree menu, the windows added are so near from the tree view nav. I want to move closer the window (right side) to the tree view navigation, and reduce the margin marked with red.… --- ## [Css exception handling](https://forum.inductiveautomation.com/t/css-exception-handling/74722)
**Author:** [@KIM\_SUNG\_HOO](https://forum.inductiveautomation.com/u/KIM_SUNG_HOO)\ **Replies:** 16\ **Last updated:** [July 31, 2023, 8:36pm UTC](https://forum.inductiveautomation.com/t/css-exception-handling/74722 "2023-07-31T20:36:51Z")
hi, I put the following code in the css file .pager-container div.page { background: #FFCCCC !important; color: #1010FF !important; } .pager-container div.page.active { background: #000000 !impo… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=600) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=602)