# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=576 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 577 --- ## [Issue with vision scripting and SQL queries](https://forum.inductiveautomation.com/t/issue-with-vision-scripting-and-sql-queries/78748)
**Author:** [@Surya\_Chandra\_Mohan](https://forum.inductiveautomation.com/u/Surya_Chandra_Mohan)\ **Replies:** 2\ **Last updated:** [September 5, 2023, 12:31pm UTC](https://forum.inductiveautomation.com/t/issue-with-vision-scripting-and-sql-queries/78748 "2023-09-05T12:31:01Z")
Hello, I am trying to insert data into the table and there is user\_id in the table. I am selecting username from dropdown and the id of that username should be entered into the table but when inserting, the user\_id is e… --- ## [Remote Tag Providers - Error reading from Edge to main server](https://forum.inductiveautomation.com/t/remote-tag-providers-error-reading-from-edge-to-main-server/78598)
**Author:** [@Learner\_Ignition](https://forum.inductiveautomation.com/u/Learner_Ignition)\ **Replies:** 4\ **Last updated:** [September 5, 2023, 12:29pm UTC](https://forum.inductiveautomation.com/t/remote-tag-providers-error-reading-from-edge-to-main-server/78598 "2023-09-05T12:29:29Z")
Hi, I had configure Outgoing Connection gateway network in Edge Gateway server for reading the data from Edge Gateway to Main Gateway. In Main Gateway, status is Connected and Running and I am able to see the tags in T… --- ## [\[BUG\] Database Query Browser evaporates your edit changes if not in read/write mode](https://forum.inductiveautomation.com/t/bug-database-query-browser-evaporates-your-edit-changes-if-not-in-read-write-mode/78708)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 4\ **Last updated:** [September 5, 2023, 12:27pm UTC](https://forum.inductiveautomation.com/t/bug-database-query-browser-evaporates-your-edit-changes-if-not-in-read-write-mode/78708 "2023-09-05T12:27:55Z")
If you've made changes to a table's cell values within this tool and press OK to accept the changes but you don't have the designer in read/write mode, an error tells you that your changes can't be made due to the wrong … --- ## [Email Notifications](https://forum.inductiveautomation.com/t/email-notifications/78739)
**Author:** [@Sameer\_Ambegaonkar](https://forum.inductiveautomation.com/u/Sameer_Ambegaonkar)\ **Replies:** 7\ **Last updated:** [September 5, 2023, 12:26pm UTC](https://forum.inductiveautomation.com/t/email-notifications/78739 "2023-09-05T12:26:44Z")
Trying to setup alarm email notification for MS outlook. Refer screenshots. Test mail is unsuccessful. Appreciate help if anybody done this before. Regards, Sameer --- ## [How to update PLC tag value into SQL Database every 15 minutes](https://forum.inductiveautomation.com/t/how-to-update-plc-tag-value-into-sql-database-every-15-minutes/78746)
**Author:** [@Shashiraj\_P\_S](https://forum.inductiveautomation.com/u/Shashiraj_P_S)\ **Replies:** 6\ **Last updated:** [September 5, 2023, 12:21pm UTC](https://forum.inductiveautomation.com/t/how-to-update-plc-tag-value-into-sql-database-every-15-minutes/78746 "2023-09-05T12:21:51Z")
Hi, I want to update plc Tag value from table which is captured from PLC device to sql database every 15 minutes how to do it? below is the sample table screenshot data which is captured from PLC --- ## [Network monitoring dashboard](https://forum.inductiveautomation.com/t/network-monitoring-dashboard/50360)
**Author:** [@sathianandan.dharmas](https://forum.inductiveautomation.com/u/sathianandan.dharmas)\ **Replies:** 2\ **Last updated:** [September 5, 2023, 11:56am UTC](https://forum.inductiveautomation.com/t/network-monitoring-dashboard/50360 "2023-09-05T11:56:05Z")
Hi All I’m trying to build a network monitoring dashboard more or like this I have a lot of devices that serve as different ignition gateways, from within my company’s network I can ping all these devices but it wou… --- ## [Automatically move the cursor to text input field](https://forum.inductiveautomation.com/t/automatically-move-the-cursor-to-text-input-field/78745)
**Author:** [@Soundararajans\_S](https://forum.inductiveautomation.com/u/Soundararajans_S)\ **Replies:** 3\ **Last updated:** [September 5, 2023, 8:36am UTC](https://forum.inductiveautomation.com/t/automatically-move-the-cursor-to-text-input-field/78745 "2023-09-05T08:36:41Z")
Am having button on my main perspective view, when I press the button, pop-up will open. In that pop-up I have a text field. Now am manually place the cursor to type something. Instead of that, when the pop-up is open, i… --- ## [Adding a document from my computer to a shared disk with perspective](https://forum.inductiveautomation.com/t/adding-a-document-from-my-computer-to-a-shared-disk-with-perspective/78729)
**Author:** [@marianjel\_11](https://forum.inductiveautomation.com/u/marianjel_11)\ **Replies:** 6\ **Last updated:** [September 4, 2023, 6:05pm UTC](https://forum.inductiveautomation.com/t/adding-a-document-from-my-computer-to-a-shared-disk-with-perspective/78729 "2023-09-04T18:05:12Z")
I had a document control project in the Vision module, which I need to change to perspective, the main functionality is to take a PDF document from any computer and save it in a folder in a shared disk in the "C:", igni… --- ## [Tag writing conflict](https://forum.inductiveautomation.com/t/tag-writing-conflict/78601)
**Author:** [@Adarsh\_K](https://forum.inductiveautomation.com/u/Adarsh_K)\ **Replies:** 4\ **Last updated:** [September 4, 2023, 6:04pm UTC](https://forum.inductiveautomation.com/t/tag-writing-conflict/78601 "2023-09-04T18:04:36Z")
Hi, I have a counter tag for which I will be incrementing the values . Problem is I will be doing this action in tag change of gateway script. as all tags triggered simultaneously , this is causing write conflict and d… --- ## [Siemens HMI rebuild](https://forum.inductiveautomation.com/t/siemens-hmi-rebuild/78711)
**Author:** [@grzegorz.kaczmarczyk](https://forum.inductiveautomation.com/u/grzegorz.kaczmarczyk)\ **Replies:** 3\ **Last updated:** [September 4, 2023, 1:58pm UTC](https://forum.inductiveautomation.com/t/siemens-hmi-rebuild/78711 "2023-09-04T13:58:00Z")
Company wants to rebuild one Siemens HMI panel. They don’t have a project for it, so we will have to create it. The model of the panel is Siemens TP1900 Comfort with Windows and the numer of signals is about 50-100. Whi… --- ## [Filtering dataset](https://forum.inductiveautomation.com/t/filtering-dataset/78719)
**Author:** [@sebastien\_ng](https://forum.inductiveautomation.com/u/sebastien_ng)\ **Replies:** 14\ **Last updated:** [September 4, 2023, 1:16pm UTC](https://forum.inductiveautomation.com/t/filtering-dataset/78719 "2023-09-04T13:16:38Z")
Hello , I have an Tag dataset OF WECAM like : Column1 is ID of webcam. What I want is, when I click on an webcam for exemple webcam ID = 11 I want obtain a dataset like: Column2 is zone where webbcam is located --- ## [How to Decrypt SHA1 Passwords](https://forum.inductiveautomation.com/t/how-to-decrypt-sha1-passwords/78700)
**Author:** [@yiotis](https://forum.inductiveautomation.com/u/yiotis)\ **Replies:** 4\ **Last updated:** [September 4, 2023, 11:59am UTC](https://forum.inductiveautomation.com/t/how-to-decrypt-sha1-passwords/78700 "2023-09-04T11:59:21Z")
Hello. I am using the below example to encrypt my password and store it in my database. How do I decrypt it? If I query the the password from the database, how do I decrypt it? Thanks. from com.inductiveautomation.igni… --- ## [Change view Docked View depending on viewport height](https://forum.inductiveautomation.com/t/change-view-docked-view-depending-on-viewport-height/78694)
**Author:** [@Mario\_Olivares](https://forum.inductiveautomation.com/u/Mario_Olivares)\ **Replies:** 6\ **Last updated:** [September 4, 2023, 10:48am UTC](https://forum.inductiveautomation.com/t/change-view-docked-view-depending-on-viewport-height/78694 "2023-09-04T10:48:06Z")
Greeting everyone, I am trying to change the view of an embedded view located on a docked view using a custom parameter on the component, but I can't make it to work. As you can see on the screenshot, i have a principa… --- ## [\[BUG\] Alter Dock Resetting Parameters on other open Docks](https://forum.inductiveautomation.com/t/bug-alter-dock-resetting-parameters-on-other-open-docks/78713)
**Author:** [@liam1](https://forum.inductiveautomation.com/u/liam1)\ **Replies:** 0\ **Last updated:** [September 4, 2023, 7:58am UTC](https://forum.inductiveautomation.com/t/bug-alter-dock-resetting-parameters-on-other-open-docks/78713 "2023-09-04T07:58:34Z")
I have two docks, one of the left and one on the right. They have different dock-id's. Left side dock has the id of menu ,right dock has the id of MES. When the right dock is open and I click to open a configuration w… --- ## [If this is not a language supported by Ignition](https://forum.inductiveautomation.com/t/if-this-is-not-a-language-supported-by-ignition/78703)
**Author:** [@jiyoung\_hwang1](https://forum.inductiveautomation.com/u/jiyoung_hwang1)\ **Replies:** 4\ **Last updated:** [September 4, 2023, 7:29am UTC](https://forum.inductiveautomation.com/t/if-this-is-not-a-language-supported-by-ignition/78703 "2023-09-04T07:29:19Z")
Hello. What should I do if it's not a language supported by Ignition in a situation where I get information using a script from the perspective of Ignition? --- ## [Perform SwitchUser By Programmatically Settings the UserSource](https://forum.inductiveautomation.com/t/perform-switchuser-by-programmatically-settings-the-usersource/78699)
**Author:** [@yiotis](https://forum.inductiveautomation.com/u/yiotis)\ **Replies:** 2\ **Last updated:** [September 4, 2023, 1:22am UTC](https://forum.inductiveautomation.com/t/perform-switchuser-by-programmatically-settings-the-usersource/78699 "2023-09-04T01:22:58Z")
Hello. Is there a way to perform a "system.security.switchUser" against a specific "user source" ? I have 2 users sources labeled "UserSource1" and "UserSource2" In some situations I want the operator to login by supplyi… --- ## [PDFViewer and VideoPlayer not working](https://forum.inductiveautomation.com/t/pdfviewer-and-videoplayer-not-working/78698)
**Author:** [@Wendy\_Minai1](https://forum.inductiveautomation.com/u/Wendy_Minai1)\ **Replies:** 5\ **Last updated:** [September 4, 2023, 12:10am UTC](https://forum.inductiveautomation.com/t/pdfviewer-and-videoplayer-not-working/78698 "2023-09-04T00:10:12Z")
Has anyone tried to configure the VideoPlayer or PDFViewer in the recent past? If so, how did you make them work? I am using the Web Dev file resource feature but all its showing me is failed to load PDF file. --- ## [Convert Named query into an array](https://forum.inductiveautomation.com/t/convert-named-query-into-an-array/78696)
**Author:** [@John\_Morgan1](https://forum.inductiveautomation.com/u/John_Morgan1)\ **Replies:** 3\ **Last updated:** [September 3, 2023, 7:46pm UTC](https://forum.inductiveautomation.com/t/convert-named-query-into-an-array/78696 "2023-09-03T19:46:03Z")
https://docs.inductiveautomation.com/display/DOC80/Script+Transform I have found this Doc but I don't know why It doesn't work for me. I want to display database values (time series) into apex chart so I had to bind the… --- ## [How to add new rows to a table using Ignition's Pespective Text Field Component](https://forum.inductiveautomation.com/t/how-to-add-new-rows-to-a-table-using-ignitions-pespective-text-field-component/78685)
**Author:** [@Wendy\_Minai](https://forum.inductiveautomation.com/u/Wendy_Minai)\ **Replies:** 5\ **Last updated:** [September 2, 2023, 2:41am UTC](https://forum.inductiveautomation.com/t/how-to-add-new-rows-to-a-table-using-ignitions-pespective-text-field-component/78685 "2023-09-02T02:41:34Z")
I have an empty SQL table called Plt65\_Supply\_Room. I want to create a user interface such that people can add new rows into my table. How can i manage this? Below code it what I have on my Configure events srcipt sec… --- ## [Can Deadband for tag be exported to MQTT?](https://forum.inductiveautomation.com/t/can-deadband-for-tag-be-exported-to-mqtt/77943)
**Author:** [@ian.sebryk](https://forum.inductiveautomation.com/u/ian.sebryk)\ **Replies:** 1\ **Last updated:** [September 1, 2023, 10:54pm UTC](https://forum.inductiveautomation.com/t/can-deadband-for-tag-be-exported-to-mqtt/77943 "2023-09-01T22:54:43Z")
we have a sensor tag that we can read/set value for via MQTT. we also want to change/set the Deadband for that tag. here's a snapshot of what i'm looking at: (and, yes, i know value is set to String instead of Float;… --- ## [Need technical details behind mapping shared drives](https://forum.inductiveautomation.com/t/need-technical-details-behind-mapping-shared-drives/78681)
**Author:** [@karnick](https://forum.inductiveautomation.com/u/karnick)\ **Replies:** 3\ **Last updated:** [September 1, 2023, 10:36pm UTC](https://forum.inductiveautomation.com/t/need-technical-details-behind-mapping-shared-drives/78681 "2023-09-01T22:36:07Z")
We have a system in place called Windream which essentially emulates a windows share. I am being told that this system is being upgraded to a version that no longer supports older operating systems such as Windows 7, so … --- ## [Gateway side script scopes and lifetimes between different events](https://forum.inductiveautomation.com/t/gateway-side-script-scopes-and-lifetimes-between-different-events/78675)
**Author:** [@johnSP](https://forum.inductiveautomation.com/u/johnSP)\ **Replies:** 3\ **Last updated:** [September 1, 2023, 10:29pm UTC](https://forum.inductiveautomation.com/t/gateway-side-script-scopes-and-lifetimes-between-different-events/78675 "2023-09-01T22:29:56Z")
To preface i have read a lot of the forums and re-read the documentation every time i encounter this. I dont think i've come across this exact scenario mentioned, but am seeking a better understanding of a gateway side's… --- ## [UDT configuration lost](https://forum.inductiveautomation.com/t/udt-configuration-lost/71361)
**Author:** [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\ **Replies:** 4\ **Last updated:** [September 1, 2023, 8:59pm UTC](https://forum.inductiveautomation.com/t/udt-configuration-lost/71361 "2023-09-01T20:59:54Z")
Hi, I've just experienced a scary event! On Friday I left my Ignition project up and running, no Windows, no Ignition Service restart in the meanwhile. Today my UDT instances showed up with a weird warning sign, saying t… --- ## [Creating Pipe Color Changes in a Circuit](https://forum.inductiveautomation.com/t/creating-pipe-color-changes-in-a-circuit/78665)
**Author:** [@Nathan\_Heck](https://forum.inductiveautomation.com/u/Nathan_Heck)\ **Replies:** 16\ **Last updated:** [September 1, 2023, 7:33pm UTC](https://forum.inductiveautomation.com/t/creating-pipe-color-changes-in-a-circuit/78665 "2023-09-01T19:33:01Z")
Hello, I'm trying to have the pipe color change for flow path based on valve positions, and if pump is running. I can make the custom property for color change based on tag value, but it's only for certain circuits. I w… --- ## [Default view instead of adding tags manually?](https://forum.inductiveautomation.com/t/default-view-instead-of-adding-tags-manually/78642)
**Author:** [@PPickett](https://forum.inductiveautomation.com/u/PPickett)\ **Replies:** 2\ **Last updated:** [September 1, 2023, 6:47pm UTC](https://forum.inductiveautomation.com/t/default-view-instead-of-adding-tags-manually/78642 "2023-09-01T18:47:33Z")
I would like to display a few tags by default to the user. I am using the Powerchart component. I can click on the browse button and add my tags but I would like to have these tags display by default right when I enter t… --- ## [I am having the same issue but with the devices (CompactLogix both firmware v21+ and 20 and prior) that are connected to cell modem private network](https://forum.inductiveautomation.com/t/i-am-having-the-same-issue-but-with-the-devices-compactlogix-both-firmware-v21-and-20-and-prior-that-are-connected-to-cell-modem-private-network/78644)
**Author:** [@prashants](https://forum.inductiveautomation.com/u/prashants)\ **Replies:** 3\ **Last updated:** [September 1, 2023, 2:41pm UTC](https://forum.inductiveautomation.com/t/i-am-having-the-same-issue-but-with-the-devices-compactlogix-both-firmware-v21-and-20-and-prior-that-are-connected-to-cell-modem-private-network/78644 "2023-09-01T14:41:36Z")
Continuing the discussion from ControlLogix Connection problems: ABControlLogixTransportPool 31Aug2023 15:48:19 \[BoulderRidgeLS\] Reseting CIP connection for transaction ID of 8214 TimeoutDaemon 31Aug2023 15:48:1… --- ## [Client Menu Bar](https://forum.inductiveautomation.com/t/client-menu-bar/8230)
**Author:** [@jmoniz](https://forum.inductiveautomation.com/u/jmoniz)\ **Replies:** 2\ **Last updated:** [September 1, 2023, 2:41pm UTC](https://forum.inductiveautomation.com/t/client-menu-bar/8230 "2023-09-01T14:41:33Z")
I have an issue where if I disconnect an open client from the network, upon reconnecting to the network the client menu bar greys out and cannot be selected. Everything else in the client window updates properly. This n… --- ## [Carriage return in a perspective cells](https://forum.inductiveautomation.com/t/carriage-return-in-a-perspective-cells/78674)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 2\ **Last updated:** [September 1, 2023, 2:13pm UTC](https://forum.inductiveautomation.com/t/carriage-return-in-a-perspective-cells/78674 "2023-09-01T14:13:44Z")
can we force a carriage return in a perspective Table cell ? --- ## [Base64 in export of Store&Forward quarantined item](https://forum.inductiveautomation.com/t/base64-in-export-of-store-forward-quarantined-item/15656)
**Author:** [@maidamar](https://forum.inductiveautomation.com/u/maidamar)\ **Replies:** 15\ **Last updated:** [September 1, 2023, 1:54pm UTC](https://forum.inductiveautomation.com/t/base64-in-export-of-store-forward-quarantined-item/15656 "2023-09-01T13:54:45Z")
Hi there: In my gateway there is a quarantined item under Store&Forward. When I try to export it to see the data and try to correct the query (as per Inductive University / Databases In Ignition / About Store And Forward… --- ## [Unexpected behavior of email notifications](https://forum.inductiveautomation.com/t/unexpected-behavior-of-email-notifications/78440)
**Author:** [@Michal\_Goralczyk](https://forum.inductiveautomation.com/u/Michal_Goralczyk)\ **Replies:** 3\ **Last updated:** [September 1, 2023, 1:46pm UTC](https://forum.inductiveautomation.com/t/unexpected-behavior-of-email-notifications/78440 "2023-09-01T13:46:13Z")
Hello, I have set up email notifications using a script. They trigger using the schadule method on the gateway at specific times. Below is what it looks like: def onScheduledEvent(): subject = "Sample\_string" body… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=575) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=577)