# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=444 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 445 --- ## [Primary key on alarm\_event\_data](https://forum.inductiveautomation.com/t/primary-key-on-alarm-event-data/55414)
**Author:** [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\ **Replies:** 9\ **Last updated:** [April 8, 2024, 2:11pm UTC](https://forum.inductiveautomation.com/t/primary-key-on-alarm-event-data/55414 "2024-04-08T14:11:51Z")
Hello community! Using SQL Server, We are setting up data replication of alarm\_event\_data. It seems to be impossible because this table do not have a primary key. Is there a problem if I add a pk\_id autoincrement colu… --- ## [Overflow Error when attempting to use Find/Replace](https://forum.inductiveautomation.com/t/overflow-error-when-attempting-to-use-find-replace/88359)
**Author:** [@BCNoyes](https://forum.inductiveautomation.com/u/BCNoyes)\ **Replies:** 3\ **Last updated:** [April 8, 2024, 2:10pm UTC](https://forum.inductiveautomation.com/t/overflow-error-when-attempting-to-use-find-replace/88359 "2024-04-08T14:10:24Z")
I'm working on a project for a client and I'm having trouble using the search. The gateway is located remotely and being accessed via a VPN. I'm not familiar with the projects so I'm trying to search for where a script m… --- ## [Obtaining Component Path on Mouse Click Event](https://forum.inductiveautomation.com/t/obtaining-component-path-on-mouse-click-event/88494)
**Author:** [@Ujwal\_Wankhede](https://forum.inductiveautomation.com/u/Ujwal_Wankhede)\ **Replies:** 7\ **Last updated:** [April 8, 2024, 1:39pm UTC](https://forum.inductiveautomation.com/t/obtaining-component-path-on-mouse-click-event/88494 "2024-04-08T13:39:47Z")
I'm running a script triggered by a mouse click event and I'm seeking a more efficient way to obtain the component path within the script. Below is the script I'm using to retrieve the complete component path: def runAc… --- ## [Designer does not save project any longer](https://forum.inductiveautomation.com/t/designer-does-not-save-project-any-longer/88496)
**Author:** [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\ **Replies:** 3\ **Last updated:** [April 8, 2024, 12:35pm UTC](https://forum.inductiveautomation.com/t/designer-does-not-save-project-any-longer/88496 "2024-04-08T12:35:57Z")
Hi all, we are experiencing a weird Designer behavior (Ignition 8.1.34) while developing scripting functions in the global project, i.e. the project which is configured as the Gateway Scripting Project - we are 2 peopl… --- ## [JSON get/set sending cmd to the PLC (Siemens)](https://forum.inductiveautomation.com/t/json-get-set-sending-cmd-to-the-plc-siemens/88336)
**Author:** [@Michael\_Johannsen](https://forum.inductiveautomation.com/u/Michael_Johannsen)\ **Replies:** 12\ **Last updated:** [April 8, 2024, 12:09pm UTC](https://forum.inductiveautomation.com/t/json-get-set-sending-cmd-to-the-plc-siemens/88336 "2024-04-08T12:09:53Z")
Hi I have these two udts. They are pointing to the same PLC tag/udt. I using the same faceplate. The first udt is made like these: the bottom udt are using "document" and the each tag is Derived from the docum… --- ## [Periodical refresh of a tag history dataset](https://forum.inductiveautomation.com/t/periodical-refresh-of-a-tag-history-dataset/88490)
**Author:** [@Steve\_Booth](https://forum.inductiveautomation.com/u/Steve_Booth)\ **Replies:** 1\ **Last updated:** [April 8, 2024, 12:00pm UTC](https://forum.inductiveautomation.com/t/periodical-refresh-of-a-tag-history-dataset/88490 "2024-04-08T12:00:46Z")
I have time series chart with a series that is bound to a tag history dataset. Currently it updates on pull down event script 'onActionPerformed'. It is working fine, but I would like the chart to update every 5 second… --- ## [Report chart not working in nested query](https://forum.inductiveautomation.com/t/report-chart-not-working-in-nested-query/77994)
**Author:** [@John\_John](https://forum.inductiveautomation.com/u/John_John)\ **Replies:** 3\ **Last updated:** [April 8, 2024, 10:19am UTC](https://forum.inductiveautomation.com/t/report-chart-not-working-in-nested-query/77994 "2024-04-08T10:19:11Z")
I want to present the data as follows: Table 1 will show information about 'Equipment 1' along with 'Chart 1,' while Table 2 will display data about 'Equipment 2' along with 'Chart 2.' I have formulated nested queries fo… --- ## [How to change the scrollbar style in a XYChart component](https://forum.inductiveautomation.com/t/how-to-change-the-scrollbar-style-in-a-xychart-component/88488)
**Author:** [@Angelica\_Aguilar](https://forum.inductiveautomation.com/u/Angelica_Aguilar)\ **Replies:** 1\ **Last updated:** [April 8, 2024, 10:15am UTC](https://forum.inductiveautomation.com/t/how-to-change-the-scrollbar-style-in-a-xychart-component/88488 "2024-04-08T10:15:00Z")
Hello ! I'm working with the XYChart component and I would like to use the horizontal scrollbar but it is possible to make it smaller or change the color ? I want to make some styles changes, but don't know how.... I a… --- ## [Get date from week number](https://forum.inductiveautomation.com/t/get-date-from-week-number/88392)
**Author:** [@richard\_hamilton](https://forum.inductiveautomation.com/u/richard_hamilton)\ **Replies:** 7\ **Last updated:** [April 8, 2024, 7:19am UTC](https://forum.inductiveautomation.com/t/get-date-from-week-number/88392 "2024-04-08T07:19:43Z")
Hi folks, I am wanting to set a date picker according to the week number selected. I am able to get the week number from the date but struggling on how to go about this in reverse. I would like to select the first day… --- ## [Custom Tag Property in Alarm](https://forum.inductiveautomation.com/t/custom-tag-property-in-alarm/77869)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 6\ **Last updated:** [April 8, 2024, 3:49am UTC](https://forum.inductiveautomation.com/t/custom-tag-property-in-alarm/77869 "2024-04-08T03:49:53Z")
How do I access a custom tag property within the alarm configuration. For instance, a custom property "valveNum" (Integer) on a tag, I have the alarm message "VM"+{Manifold\_Number}+" Valve 1 Failed to Open" But I want… --- ## [Is there any way to get the disk usage ratio from machine where SQL server installed?](https://forum.inductiveautomation.com/t/is-there-any-way-to-get-the-disk-usage-ratio-from-machine-where-sql-server-installed/88486)
**Author:** [@Lion\_Sun](https://forum.inductiveautomation.com/u/Lion_Sun)\ **Replies:** 0\ **Last updated:** [April 8, 2024, 1:11am UTC](https://forum.inductiveautomation.com/t/is-there-any-way-to-get-the-disk-usage-ratio-from-machine-where-sql-server-installed/88486 "2024-04-08T01:11:46Z")
My ignition has a connection to a Microsoft SQL server. The ignition gateway and MS SQL server are installed in different machines. Is there any way to get the disk usage ratio from the machine where MS SQL server is ins… --- ## [Red Lion Messed up Big time](https://forum.inductiveautomation.com/t/red-lion-messed-up-big-time/87757)
**Author:** [@tmahaf](https://forum.inductiveautomation.com/u/tmahaf)\ **Replies:** 21\ **Last updated:** [April 8, 2024, 1:04am UTC](https://forum.inductiveautomation.com/t/red-lion-messed-up-big-time/87757 "2024-04-08T01:04:39Z")
Anyone know the conversion to get from the timestamps that are now coming in as Jan 1 1997 to March 22, 2024? I'm guessing its just seconds between the two dates? --- ## [How to run an external script?](https://forum.inductiveautomation.com/t/how-to-run-an-external-script/87108)
**Author:** [@Sasi\_Rai](https://forum.inductiveautomation.com/u/Sasi_Rai)\ **Replies:** 11\ **Last updated:** [April 7, 2024, 11:00pm UTC](https://forum.inductiveautomation.com/t/how-to-run-an-external-script/87108 "2024-04-07T23:00:25Z")
Hi All, New to Ignition and Python, and my first post here. I have a Python script that executes fine: it connects to an API, downloads the latest data and saves it as a .py file. The data is then displayed as a table … --- ## [BarcodeScannerInput Component](https://forum.inductiveautomation.com/t/barcodescannerinput-component/88483)
**Author:** [@Subin\_Adhikari](https://forum.inductiveautomation.com/u/Subin_Adhikari)\ **Replies:** 1\ **Last updated:** [April 7, 2024, 5:27pm UTC](https://forum.inductiveautomation.com/t/barcodescannerinput-component/88483 "2024-04-07T17:27:57Z")
Gurus, I can see the value on Session Event for the barcode scanner data but i am not receiving anything on the actual BarcodeScannerInput data prop. any guidelines ? note: i am not using prefix/suffix and i am usi… --- ## [NGROK Development](https://forum.inductiveautomation.com/t/ngrok-development/88480)
**Author:** [@Subin\_Adhikari](https://forum.inductiveautomation.com/u/Subin_Adhikari)\ **Replies:** 2\ **Last updated:** [April 7, 2024, 4:52pm UTC](https://forum.inductiveautomation.com/t/ngrok-development/88480 "2024-04-07T16:52:23Z")
Respected Gurus, I want to run the Ignition gateway through NGROK, in mobile Inductive Automation app its not working because you have to click in "VISIT SITE" before continuing so thats the reason the app is not able t… --- ## [How to put a UDT variable in a script](https://forum.inductiveautomation.com/t/how-to-put-a-udt-variable-in-a-script/88479)
**Author:** [@Ryan\_Crawford](https://forum.inductiveautomation.com/u/Ryan_Crawford)\ **Replies:** 2\ **Last updated:** [April 7, 2024, 3:16pm UTC](https://forum.inductiveautomation.com/t/how-to-put-a-udt-variable-in-a-script/88479 "2024-04-07T15:16:39Z")
Good Morning Everybody, I know this is been answered a few times but do have some trouble understanding, so apologies in advance. I need to read and write to UDT tags that I want to put into a script. The tags are unde… --- ## [Connenting a simulation with Ignition](https://forum.inductiveautomation.com/t/connenting-a-simulation-with-ignition/88473)
**Author:** [@Martin\_Noguerol](https://forum.inductiveautomation.com/u/Martin_Noguerol)\ **Replies:** 4\ **Last updated:** [April 7, 2024, 12:55pm UTC](https://forum.inductiveautomation.com/t/connenting-a-simulation-with-ignition/88473 "2024-04-07T12:55:07Z")
Hi! I´m a chemical engineer who works developing dynamic simulations. As a side project, I would like to connect a simple model (maybe a tank, pump and 2 valves) and try to command the simulation with ignition. I have … --- ## [How to handle dataset to Excel as a workbook?](https://forum.inductiveautomation.com/t/how-to-handle-dataset-to-excel-as-a-workbook/88471)
**Author:** [@denny\_jimenez](https://forum.inductiveautomation.com/u/denny_jimenez)\ **Replies:** 0\ **Last updated:** [April 6, 2024, 10:43pm UTC](https://forum.inductiveautomation.com/t/how-to-handle-dataset-to-excel-as-a-workbook/88471 "2024-04-06T22:43:53Z")
Hello! I have the following piece of code: aWb = system.dataset.toExcel(True, listSh, True, listNames) As per the Ignition documentation, aWb is an array representing an excel workbook, but I need it to be a workbook o… --- ## [Sparkline in Popup](https://forum.inductiveautomation.com/t/sparkline-in-popup/88457)
**Author:** [@Roman\_Rozenshteyn](https://forum.inductiveautomation.com/u/Roman_Rozenshteyn)\ **Replies:** 2\ **Last updated:** [April 6, 2024, 4:55pm UTC](https://forum.inductiveautomation.com/t/sparkline-in-popup/88457 "2024-04-06T16:55:56Z")
Hello all, I'm looking for a solution to create a trend inside one of my popups - direct rip-off from PlantPAx: I have a sparkline in a popup which doesn't seem to update when the popup is open. Is this a known issue… --- ## [Percentage exported CSV file](https://forum.inductiveautomation.com/t/percentage-exported-csv-file/88453)
**Author:** [@luisdavidof](https://forum.inductiveautomation.com/u/luisdavidof)\ **Replies:** 3\ **Last updated:** [April 6, 2024, 7:48am UTC](https://forum.inductiveautomation.com/t/percentage-exported-csv-file/88453 "2024-04-06T07:48:55Z")
In that same CSV, percentage values appear with different numbers. I imagine they have some very small scale that I cannot decipher like this: 10029121651553000. Which corresponds to a value very close to 1% according t… --- ## [Barcode Scanning with iPad camera](https://forum.inductiveautomation.com/t/barcode-scanning-with-ipad-camera/88440)
**Author:** [@Robert\_Garcher1](https://forum.inductiveautomation.com/u/Robert_Garcher1)\ **Replies:** 5\ **Last updated:** [April 6, 2024, 1:58am UTC](https://forum.inductiveautomation.com/t/barcode-scanning-with-ipad-camera/88440 "2024-04-06T01:58:13Z")
I'm looking to potentially use the perspective barcode scanning feature with an iPad camera. This works fine, but what I would like to do is potentially authenticate the user via this method. Each operator has a barcod… --- ## [Error executing script for event: propertyChange on component: Image 2](https://forum.inductiveautomation.com/t/error-executing-script-for-event-propertychange-on-component-image-2/88431)
**Author:** [@Joseph\_Puente](https://forum.inductiveautomation.com/u/Joseph_Puente)\ **Replies:** 6\ **Last updated:** [April 6, 2024, 1:02am UTC](https://forum.inductiveautomation.com/t/error-executing-script-for-event-propertychange-on-component-image-2/88431 "2024-04-06T01:02:17Z")
I'm getting this error when opening a window. I've inspceted "Image 2" and there isnt any properties associated with it that i can find. its just an image of piping. Below are the error details. Any help on resolving th… --- ## [UDT Tag Folder No Longer Appears In Data Type Instance Browse](https://forum.inductiveautomation.com/t/udt-tag-folder-no-longer-appears-in-data-type-instance-browse/88454)
**Author:** [@nlivingston](https://forum.inductiveautomation.com/u/nlivingston)\ **Replies:** 6\ **Last updated:** [April 6, 2024, 12:22am UTC](https://forum.inductiveautomation.com/t/udt-tag-folder-no-longer-appears-in-data-type-instance-browse/88454 "2024-04-06T00:22:47Z")
I've been using nested UDT folders for sorting UDT's by specific companies and locations since I have a variety of programs to manage. This hasn't been an issue until today when I created a new UDT folder in an existing … --- ## [Help Adjusting Row Height in Ignition Alarm Status Table](https://forum.inductiveautomation.com/t/help-adjusting-row-height-in-ignition-alarm-status-table/88450)
**Author:** [@GUILHERME\_MARTINS](https://forum.inductiveautomation.com/u/GUILHERME_MARTINS)\ **Replies:** 1\ **Last updated:** [April 5, 2024, 9:13pm UTC](https://forum.inductiveautomation.com/t/help-adjusting-row-height-in-ignition-alarm-status-table/88450 "2024-04-05T21:13:40Z")
Hello everyone, I'm new to Ignition and I'm facing a little issue. I'm trying to change the row height in an alarm status table, but so far I haven't been successful. If anyone has any experience with this and could gi… --- ## [Perspective drodown selected label](https://forum.inductiveautomation.com/t/perspective-drodown-selected-label/38723)
**Author:** [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Replies:** 3\ **Last updated:** [April 5, 2024, 8:28pm UTC](https://forum.inductiveautomation.com/t/perspective-drodown-selected-label/38723 "2024-04-05T20:28:54Z")
I want to get the selected label from a perspective dropdown. This post helped... But, if using showClearIcon and then clearing you will get stale data. Are there any better alternatives to getting the selected label… --- ## [Ignition Designer Host unreachable over WAN](https://forum.inductiveautomation.com/t/ignition-designer-host-unreachable-over-wan/88447)
**Author:** [@Aaron\_Bangle](https://forum.inductiveautomation.com/u/Aaron_Bangle)\ **Replies:** 1\ **Last updated:** [April 5, 2024, 8:24pm UTC](https://forum.inductiveautomation.com/t/ignition-designer-host-unreachable-over-wan/88447 "2024-04-05T20:24:49Z")
Hello, I have setup a small PC to run an ignition gateway and database. I have set it up with a static IP and have a wireless router connected to it that is not going to be connected to the internet. Also have the incom… --- ## [Carousel component taking foreground priority in a flex container](https://forum.inductiveautomation.com/t/carousel-component-taking-foreground-priority-in-a-flex-container/88375)
**Author:** [@hunterdg](https://forum.inductiveautomation.com/u/hunterdg)\ **Replies:** 6\ **Last updated:** [April 5, 2024, 7:47pm UTC](https://forum.inductiveautomation.com/t/carousel-component-taking-foreground-priority-in-a-flex-container/88375 "2024-04-05T19:47:58Z")
Can anyone help me understand how to prevent these underlying components from taking foreground priority? Blue button is at “top of z” (first component in the view) w/ negative offset to achieve overlay in flex containe… --- ## ["Notify with Timeout" project vision update mode](https://forum.inductiveautomation.com/t/notify-with-timeout-project-vision-update-mode/88051)
**Author:** [@mlindstrom](https://forum.inductiveautomation.com/u/mlindstrom)\ **Replies:** 5\ **Last updated:** [April 5, 2024, 5:22pm UTC](https://forum.inductiveautomation.com/t/notify-with-timeout-project-vision-update-mode/88051 "2024-04-05T17:22:50Z")
Vision projects have three update options; "Notify", "Push", or "None". "Push" is convenient for keeping all clients up to date all the time without having to click the "Project update available" banner on every single c… --- ## [Race condition question Transaction group vs change event script](https://forum.inductiveautomation.com/t/race-condition-question-transaction-group-vs-change-event-script/88258)
**Author:** [@Zach\_Larson](https://forum.inductiveautomation.com/u/Zach_Larson)\ **Replies:** 8\ **Last updated:** [April 5, 2024, 4:14pm UTC](https://forum.inductiveautomation.com/t/race-condition-question-transaction-group-vs-change-event-script/88258 "2024-04-05T16:14:12Z")
Can I do inserts from a transaction group and script resets on the same tags' change event scripts? Example: My workorder tag transaction group triggers the transaction group to collect my infeed value. My workorder t… --- ## [Combining Databases with Conditions](https://forum.inductiveautomation.com/t/combining-databases-with-conditions/88370)
**Author:** [@csilk](https://forum.inductiveautomation.com/u/csilk)\ **Replies:** 6\ **Last updated:** [April 5, 2024, 4:12pm UTC](https://forum.inductiveautomation.com/t/combining-databases-with-conditions/88370 "2024-04-05T16:12:53Z")
I have two databases that I am trying to combine into a single table. I am trying to accomplish what is shown in table "dbA + dbB": Basically, I would like "dbA + dbB" to populate based on the status in "dbB" equal to "… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=443) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=445)