# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=484 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 485 --- ## [Retrigger Alarm Upon Value Change](https://forum.inductiveautomation.com/t/retrigger-alarm-upon-value-change/84944)
**Author:** [@Juddson\_Raia](https://forum.inductiveautomation.com/u/Juddson_Raia)\ **Replies:** 1\ **Last updated:** [February 12, 2024, 11:35pm UTC](https://forum.inductiveautomation.com/t/retrigger-alarm-upon-value-change/84944 "2024-02-12T23:35:09Z")
I am attempting to retrigger an alarm that is linked to an opc tag. I have this expression inside the label of the alarm: "LHRR 130R1 Drum is " + {\[default\]PLC/167 Rear Door LH/Zone\_2\_3/130R1\_Overview/Sealer Counts/LHRR… --- ## [SECS Demo project, sending S2F41](https://forum.inductiveautomation.com/t/secs-demo-project-sending-s2f41/84880)
**Author:** [@Jefferson\_Pan](https://forum.inductiveautomation.com/u/Jefferson_Pan)\ **Replies:** 1\ **Last updated:** [February 12, 2024, 10:48pm UTC](https://forum.inductiveautomation.com/t/secs-demo-project-sending-s2f41/84880 "2024-02-12T22:48:05Z")
Hi! Currently i'm using the SECS Demo project to simulate a host with my equipment, I would like to test out S2F41 and I was wondering if it was possible for me to add the functionality to send S2F41 to my equipment. --- ## [BACNet module update](https://forum.inductiveautomation.com/t/bacnet-module-update/85595)
**Author:** [@nicholas.gutt](https://forum.inductiveautomation.com/u/nicholas.gutt)\ **Replies:** 2\ **Last updated:** [February 12, 2024, 9:46pm UTC](https://forum.inductiveautomation.com/t/bacnet-module-update/85595 "2024-02-12T21:46:29Z")
I have an Ignition gateway v8.1.17 with BACNet driver v2.1.17 installed. Can anyone tell me if I can install BACNet driver v2.1.37 on my 8.1.17 gateway and expect the driver to function properly? I am interested in upd… --- ## [Best way to make 100+ randomly named OPC tags in Ignition](https://forum.inductiveautomation.com/t/best-way-to-make-100-randomly-named-opc-tags-in-ignition/85589)
**Author:** [@Basel\_Hassan](https://forum.inductiveautomation.com/u/Basel_Hassan)\ **Replies:** 2\ **Last updated:** [February 12, 2024, 9:32pm UTC](https://forum.inductiveautomation.com/t/best-way-to-make-100-randomly-named-opc-tags-in-ignition/85589 "2024-02-12T21:32:03Z")
I was wondering what the best way to make 100+ randomly named OPC tags would be. I know what folders to place them under. At the moment, I'm just copy pasting a completed tag with the specific configurations I would like… --- ## [Dataset Parameters into Report's Table](https://forum.inductiveautomation.com/t/dataset-parameters-into-reports-table/85590)
**Author:** [@Colin\_Quinn](https://forum.inductiveautomation.com/u/Colin_Quinn)\ **Replies:** 3\ **Last updated:** [February 12, 2024, 9:24pm UTC](https://forum.inductiveautomation.com/t/dataset-parameters-into-reports-table/85590 "2024-02-12T21:24:15Z")
Hello, I am trying to build a table within a perspective report based on a query I am running outside of the report. Here are the parameters I am passing in to the report, where report\_info is the results of a named que… --- ## [How to call a stored procedure in a named query MSSQL](https://forum.inductiveautomation.com/t/how-to-call-a-stored-procedure-in-a-named-query-mssql/47844)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 2\ **Last updated:** [February 12, 2024, 9:17pm UTC](https://forum.inductiveautomation.com/t/how-to-call-a-stored-procedure-in-a-named-query-mssql/47844 "2024-02-12T21:17:03Z")
I have a stored procedure with one string parameter. I have tried the following: exec mySproc :s – results in “incorrect syntax near ‘:’ exec mySproc @s = :s – results in “incorrect syntax near ‘:’ exec mySproc ‘:s’… --- ## [\[FEATURE\] Add ability to add Icon and styling to Perspective Dropdown items](https://forum.inductiveautomation.com/t/feature-add-ability-to-add-icon-and-styling-to-perspective-dropdown-items/73823)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 13\ **Last updated:** [February 12, 2024, 8:36pm UTC](https://forum.inductiveautomation.com/t/feature-add-ability-to-add-icon-and-styling-to-perspective-dropdown-items/73823 "2024-02-12T20:36:02Z")
I'd like to be able to add an icon (with position: left, centre?, right) with colour / styling into the items of a dropdown menu list. I have a dropdown list where an operator can select items to produce. If the item ha… --- ## [\[SOLVED\] How would I color individual dropdown labels? Or how would I add an icon to each?](https://forum.inductiveautomation.com/t/solved-how-would-i-color-individual-dropdown-labels-or-how-would-i-add-an-icon-to-each/79364)
**Author:** [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Replies:** 7\ **Last updated:** [February 12, 2024, 8:34pm UTC](https://forum.inductiveautomation.com/t/solved-how-would-i-color-individual-dropdown-labels-or-how-would-i-add-an-icon-to-each/79364 "2024-02-12T20:34:21Z")
I have a Perspective drop-down component with multiple options (value / label pairs). Is there a way to change the background color of a particular option based off of the label? For example, if I have a label "Workstati… --- ## [Where do/should Gateway Scripts live with respect to an inherited project structure?](https://forum.inductiveautomation.com/t/where-do-should-gateway-scripts-live-with-respect-to-an-inherited-project-structure/83460)
**Author:** [@sherman](https://forum.inductiveautomation.com/u/sherman)\ **Replies:** 21\ **Last updated:** [February 12, 2024, 8:22pm UTC](https://forum.inductiveautomation.com/t/where-do-should-gateway-scripts-live-with-respect-to-an-inherited-project-structure/83460 "2024-02-12T20:22:38Z")
I have the inheritence structure base\_script inherited by base\_sfc inherited by project0\_base which is then inherited by both project0\_dev and project0\_staging. It is a mess. But the reason I have done this is because I … --- ## [\[BUG\] Postgre getKey error returning uuid key](https://forum.inductiveautomation.com/t/bug-postgre-getkey-error-returning-uuid-key/79458)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 17\ **Last updated:** [February 12, 2024, 7:48pm UTC](https://forum.inductiveautomation.com/t/bug-postgre-getkey-error-returning-uuid-key/79458 "2024-02-12T19:48:18Z")
Using getKey=True with system.db.runPrepUpdate where the key field is a uuid type returns an error: Caused by: org.postgresql.util.PSQLException: Cannot convert the column of type UUID to requested type int. Is there a… --- ## [SQL getKey Returning Wrong Column](https://forum.inductiveautomation.com/t/sql-getkey-returning-wrong-column/69795)
**Author:** [@Chris.Hawkey](https://forum.inductiveautomation.com/u/Chris.Hawkey)\ **Replies:** 7\ **Last updated:** [February 12, 2024, 7:52pm UTC](https://forum.inductiveautomation.com/t/sql-getkey-returning-wrong-column/69795 "2024-02-12T19:52:37Z")
Hello, I am attempting to use the system.db.runPrepUpdate() function with the getKey parameter set to True. However I notice the SQL server is returning a column that is not actually the primary key. This could be due… --- ## [runPrepUpdate getKey returning wrong value](https://forum.inductiveautomation.com/t/runprepupdate-getkey-returning-wrong-value/73478)
**Author:** [@Chad\_Putnam](https://forum.inductiveautomation.com/u/Chad_Putnam)\ **Replies:** 7\ **Last updated:** [February 12, 2024, 7:51pm UTC](https://forum.inductiveautomation.com/t/runprepupdate-getkey-returning-wrong-value/73478 "2024-02-12T19:51:07Z")
Hello All, I am running a very simple insert query that should return the identity key from a MSSql server. When I run the query below, and print the results I get a incrementing values (1316134921, 1316134922, 13161349… --- ## [Reject Count Math issue](https://forum.inductiveautomation.com/t/reject-count-math-issue/85578)
**Author:** [@jason\_kensett](https://forum.inductiveautomation.com/u/jason_kensett)\ **Replies:** 2\ **Last updated:** [February 12, 2024, 7:48pm UTC](https://forum.inductiveautomation.com/t/reject-count-math-issue/85578 "2024-02-12T19:48:51Z")
I have a machine that has 3 infeed lanes for product at a steady rate. It packages the product into 500 per and stacks on a pallet. The issue I am having is the reject math is all over the place. It stacks 3 or 4 at a t… --- ## [Do query functions using getKey=True support MSSQL uniqueidentifier data type?](https://forum.inductiveautomation.com/t/do-query-functions-using-getkey-true-support-mssql-uniqueidentifier-data-type/85415)
**Author:** [@tim.hinrichsen](https://forum.inductiveautomation.com/u/tim.hinrichsen)\ **Replies:** 4\ **Last updated:** [February 12, 2024, 7:38pm UTC](https://forum.inductiveautomation.com/t/do-query-functions-using-getkey-true-support-mssql-uniqueidentifier-data-type/85415 "2024-02-12T19:38:43Z")
Hi All, It appears that when using the runPrepUpdate() (and the named query equivalents) function and setting getKey to True that MSSQL uniqueidentifier primary key columns are not returned unlike bigint identifiers. Wi… --- ## [Hilscher Modbus TCP module](https://forum.inductiveautomation.com/t/hilscher-modbus-tcp-module/85322)
**Author:** [@Thomas\_Salisbury](https://forum.inductiveautomation.com/u/Thomas_Salisbury)\ **Replies:** 60\ **Last updated:** [February 12, 2024, 7:24pm UTC](https://forum.inductiveautomation.com/t/hilscher-modbus-tcp-module/85322 "2024-02-12T19:24:28Z")
I am needing some advice to point me in the right direction. I have a hilscher CAN BUS to modbus adapter, the manufacture of the machine has provided the device, as well as setup the modbus addressing. It is address I'… --- ## [Image not rotating around anchor correctly](https://forum.inductiveautomation.com/t/image-not-rotating-around-anchor-correctly/85574)
**Author:** [@ian.sebryk](https://forum.inductiveautomation.com/u/ian.sebryk)\ **Replies:** 0\ **Last updated:** [February 12, 2024, 6:00pm UTC](https://forum.inductiveautomation.com/t/image-not-rotating-around-anchor-correctly/85574 "2024-02-12T18:00:46Z")
running Designer 8.1.27. i notice that, despite setting the anchor correctly, the image still rotates around an unknown point. witness: you can clearly see where the anchor is (50%, 28.5%) BUT the actual point o… --- ## [propertyChange does not work for me](https://forum.inductiveautomation.com/t/propertychange-does-not-work-for-me/85556)
**Author:** [@Miguel\_Cimildoro](https://forum.inductiveautomation.com/u/Miguel_Cimildoro)\ **Replies:** 10\ **Last updated:** [February 12, 2024, 4:50pm UTC](https://forum.inductiveautomation.com/t/propertychange-does-not-work-for-me/85556 "2024-02-12T16:50:30Z")
I have a customProperty called counter that increments every second I want that when it reaches 10sec, it closes the page... what am I doing wrong? if event.propertyName == 'counter': if event.newValue == 10:… --- ## [Perspective Single Sign On with AD](https://forum.inductiveautomation.com/t/perspective-single-sign-on-with-ad/85546)
**Author:** [@Dhiren\_Gohil](https://forum.inductiveautomation.com/u/Dhiren_Gohil)\ **Replies:** 3\ **Last updated:** [February 12, 2024, 4:34pm UTC](https://forum.inductiveautomation.com/t/perspective-single-sign-on-with-ad/85546 "2024-02-12T16:34:08Z")
Hi , Greetings of the Day I want to implement Single Sign On in Perspective . I have Created AD for User& Roles , Iam able to fetch & See all the Users & Roles from the Active Directory . Iam using Ignition IDP . I … --- ## [Block Transaction Group with Trigger](https://forum.inductiveautomation.com/t/block-transaction-group-with-trigger/85569)
**Author:** [@Valerio\_Mantini](https://forum.inductiveautomation.com/u/Valerio_Mantini)\ **Replies:** 0\ **Last updated:** [February 12, 2024, 4:33pm UTC](https://forum.inductiveautomation.com/t/block-transaction-group-with-trigger/85569 "2024-02-12T16:33:00Z")
Hi everybody, I'm trying to create a Block transaction group triggered by a tag "active". Since any tag from the block Items is not visible in the "Trigger on item" menu, I've added it in the "Basic OPC/Group items. T… --- ## [Export to CSV every hour](https://forum.inductiveautomation.com/t/export-to-csv-every-hour/85545)
**Author:** [@Molnar\_Bence](https://forum.inductiveautomation.com/u/Molnar_Bence)\ **Replies:** 8\ **Last updated:** [February 12, 2024, 4:30pm UTC](https://forum.inductiveautomation.com/t/export-to-csv-every-hour/85545 "2024-02-12T16:30:40Z")
Hi everyone, I have simple table in the vision. And I would like that this table save every hour in CSV. I can do this in button, but I want this automatically in every hour. Can you help me about this? If you ne… --- ## [Designer session disconnecting](https://forum.inductiveautomation.com/t/designer-session-disconnecting/85565)
**Author:** [@Zayne\_Luker](https://forum.inductiveautomation.com/u/Zayne_Luker)\ **Replies:** 1\ **Last updated:** [February 12, 2024, 4:27pm UTC](https://forum.inductiveautomation.com/t/designer-session-disconnecting/85565 "2024-02-12T16:27:58Z")
Hello all, I keep having trouble with my Ignition Designer crashing randomly. When I check the logs, I see a Log labeled as "DesignSession" with a message "WebSocket disconnected from session". Is this a problem with t… --- ## [\[Bug\] Random tooltips when hovering over code](https://forum.inductiveautomation.com/t/bug-random-tooltips-when-hovering-over-code/85350)
**Author:** [@Alvaro\_Rodriguez](https://forum.inductiveautomation.com/u/Alvaro_Rodriguez)\ **Replies:** 4\ **Last updated:** [February 12, 2024, 4:26pm UTC](https://forum.inductiveautomation.com/t/bug-random-tooltips-when-hovering-over-code/85350 "2024-02-12T16:26:33Z")
There are this random popup/tootlips that appear when hovering above some word in code. They more often than not have nothing to do with the actual code that is written, and seem to only check the first letters (up to th… --- ## [Join different database connections 2024](https://forum.inductiveautomation.com/t/join-different-database-connections-2024/85563)
**Author:** [@Zach\_Larson](https://forum.inductiveautomation.com/u/Zach_Larson)\ **Replies:** 1\ **Last updated:** [February 12, 2024, 4:13pm UTC](https://forum.inductiveautomation.com/t/join-different-database-connections-2024/85563 "2024-02-12T16:13:46Z")
I saw a 2016 post saying you can't join across different database connections. Both are MS SQL. So I need to request a table be replicated/duplicate it myself? Or is there a good solution I don't know about? --- ## [\[BUG\] Using the Designer on a Mac](https://forum.inductiveautomation.com/t/bug-using-the-designer-on-a-mac/85547)
**Author:** [@louagejasper](https://forum.inductiveautomation.com/u/louagejasper)\ **Replies:** 10\ **Last updated:** [February 12, 2024, 3:58pm UTC](https://forum.inductiveautomation.com/t/bug-using-the-designer-on-a-mac/85547 "2024-02-12T15:58:57Z")
Hi all, As a lifetime Windows user, I've recently been trying out my workflow on a mac. After a couple of months of mac-usage, I'm impressed to see every part of my workflow being improved, except for 1, most important … --- ## [Using scirpt in derived tag](https://forum.inductiveautomation.com/t/using-scirpt-in-derived-tag/85553)
**Author:** [@Patrick\_Stave](https://forum.inductiveautomation.com/u/Patrick_Stave)\ **Replies:** 3\ **Last updated:** [February 12, 2024, 3:44pm UTC](https://forum.inductiveautomation.com/t/using-scirpt-in-derived-tag/85553 "2024-02-12T15:44:51Z")
I have created a derived tag with datatype Dataset. The script marked returns a dataset. The read expression has no effect the way it is configured right now. How can i format the read expression so that the return va… --- ## [How does system.alarm.queryJournal() query for "source"?](https://forum.inductiveautomation.com/t/how-does-system-alarm-queryjournal-query-for-source/85165)
**Author:** [@Brandon\_Peterson](https://forum.inductiveautomation.com/u/Brandon_Peterson)\ **Replies:** 6\ **Last updated:** [February 12, 2024, 3:34pm UTC](https://forum.inductiveautomation.com/t/how-does-system-alarm-queryjournal-query-for-source/85165 "2024-02-12T15:34:48Z")
I haven't been able to find precise details on what the path and source parameters are actually querying against. I want to be exact in my tag alarm queries, because some tag paths are subsets of others (have similar nam… --- ## [IPSCADA / IDP 680-6100 Modems](https://forum.inductiveautomation.com/t/ipscada-idp-680-6100-modems/85487)
**Author:** [@dnsfontenot](https://forum.inductiveautomation.com/u/dnsfontenot)\ **Replies:** 9\ **Last updated:** [February 12, 2024, 2:54pm UTC](https://forum.inductiveautomation.com/t/ipscada-idp-680-6100-modems/85487 "2024-02-12T14:54:13Z")
Hello all! Is anyone using IPSCADA or connecting to IDP 680 or 6100 series satellite modems? I am currently using Ignition internal Modbus driver connected to IPSCADA for Modbus RTU over TCP driver. I am able to get d… --- ## [How to access to property inside template repeater](https://forum.inductiveautomation.com/t/how-to-access-to-property-inside-template-repeater/85393)
**Author:** [@marco\_alvarez](https://forum.inductiveautomation.com/u/marco_alvarez)\ **Replies:** 2\ **Last updated:** [February 12, 2024, 2:26pm UTC](https://forum.inductiveautomation.com/t/how-to-access-to-property-inside-template-repeater/85393 "2024-02-12T14:26:25Z")
I need to change a parameter inside a template that is inside a template repeater templates = system.gui.getParentWindow(event).getRootContainer().getComponent('Template Repeater').getComponents() for template in templa… --- ## [Setup SSL - Install Certificate help](https://forum.inductiveautomation.com/t/setup-ssl-install-certificate-help/85548)
**Author:** [@Shivam\_Mathur](https://forum.inductiveautomation.com/u/Shivam_Mathur)\ **Replies:** 3\ **Last updated:** [February 12, 2024, 1:27pm UTC](https://forum.inductiveautomation.com/t/setup-ssl-install-certificate-help/85548 "2024-02-12T13:27:56Z")
Hello, I am trying to setup SSL (https) on the ignition gateway server, following these instructions: Secure Communication (SSL / TLS) - Ignition User Manual 8.1 - Ignition Documentation The file I received from "Issue… --- ## [Database pens in easy chart](https://forum.inductiveautomation.com/t/database-pens-in-easy-chart/85543)
**Author:** [@Elias\_Ghadbane](https://forum.inductiveautomation.com/u/Elias_Ghadbane)\ **Replies:** 2\ **Last updated:** [February 12, 2024, 1:09pm UTC](https://forum.inductiveautomation.com/t/database-pens-in-easy-chart/85543 "2024-02-12T13:09:27Z")
i'm attempting to bind indirect database pens in the easy chart component using a parameter dataset in the root container of my popup and play in "TABLE\_NAME" on cell update,The popup should display the data history of… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=483) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=485)