# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=868 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 869 --- ## [Inserting into multiple tables with single query](https://forum.inductiveautomation.com/t/inserting-into-multiple-tables-with-single-query/57720)
**Author:** [@liam1](https://forum.inductiveautomation.com/u/liam1)\ **Replies:** 4\ **Last updated:** [March 28, 2022, 3:12pm UTC](https://forum.inductiveautomation.com/t/inserting-into-multiple-tables-with-single-query/57720 "2022-03-28T15:12:16Z")
I am trying insert values into two tables using a single query by wrapping the query in a transation. I created the following namedQuery BEGIN; INSERT INTO notifications\_users (user\_id,notification\_type,username) VA… --- ## [Is it possible to cache information for use between Perspective client sessions](https://forum.inductiveautomation.com/t/is-it-possible-to-cache-information-for-use-between-perspective-client-sessions/35493)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 16\ **Last updated:** [March 28, 2022, 2:31pm UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-cache-information-for-use-between-perspective-client-sessions/35493 "2022-03-28T14:31:02Z")
I haven't looked into this at all, but thought I'd ask. I want to be able to cache certain things in the client's device such as login information and other configuration they might customise so I can reload it the next … --- ## [PDF Viewer Issues - Missing Save button](https://forum.inductiveautomation.com/t/pdf-viewer-issues-missing-save-button/34886)
**Author:** [@MikeAMCO](https://forum.inductiveautomation.com/u/MikeAMCO)\ **Replies:** 7\ **Last updated:** [March 28, 2022, 2:30pm UTC](https://forum.inductiveautomation.com/t/pdf-viewer-issues-missing-save-button/34886 "2022-03-28T14:30:16Z")
I am having a problem with the PDF Viewer. The toolbar should like like this: As one can see from the reference material, the Save icon is visible. However, when I run the window in either the designer or client I ge… --- ## [ADS Beckhoff protocol](https://forum.inductiveautomation.com/t/ads-beckhoff-protocol/57706)
**Author:** [@alessandro\_candioli](https://forum.inductiveautomation.com/u/alessandro_candioli)\ **Replies:** 1\ **Last updated:** [March 28, 2022, 12:40pm UTC](https://forum.inductiveautomation.com/t/ads-beckhoff-protocol/57706 "2022-03-28T12:40:53Z")
Good morning, i try to do a project with PLC Beckhoff. can i use the ADS protocol to communicate with ignition? thank a lot --- ## [Power chart aggregate mode and average](https://forum.inductiveautomation.com/t/power-chart-aggregate-mode-and-average/57002)
**Author:** [@r.p](https://forum.inductiveautomation.com/u/r.p)\ **Replies:** 1\ **Last updated:** [March 28, 2022, 10:24am UTC](https://forum.inductiveautomation.com/t/power-chart-aggregate-mode-and-average/57002 "2022-03-28T10:24:28Z")
Can someone shed some light on how the average is calculated in Ignition's power chart? Because we see big discrepancies between the shown average and the average we calculate from an exported spreadsheet. I suspect… --- ## [Need help creating a counter in a Timer Gateway Event](https://forum.inductiveautomation.com/t/need-help-creating-a-counter-in-a-timer-gateway-event/57436)
**Author:** [@Josiah\_West](https://forum.inductiveautomation.com/u/Josiah_West)\ **Replies:** 10\ **Last updated:** [March 28, 2022, 7:41am UTC](https://forum.inductiveautomation.com/t/need-help-creating-a-counter-in-a-timer-gateway-event/57436 "2022-03-28T07:41:24Z")
I want to create a Gateway Event that will add 1 to the value of a memory tag every second when a certain tag is true. The end goal is to make it so that the Memory tag (MemTag1) will reset to 0 when it goes below 0 and… --- ## [\[FEATURE\] Perspective - Add functions to read/write custom session props via script](https://forum.inductiveautomation.com/t/feature-perspective-add-functions-to-read-write-custom-session-props-via-script/48806)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 4\ **Last updated:** [March 28, 2022, 12:44am UTC](https://forum.inductiveautomation.com/t/feature-perspective-add-functions-to-read-write-custom-session-props-via-script/48806 "2022-03-28T00:44:02Z")
Since custom session props now take the place of Vision Client tags, it would be useful to have script functions added to read and write to these as you would with tags (system.tag.read/write\*) For example: system.pers… --- ## [Save location of Trend files using the Ad-hoc](https://forum.inductiveautomation.com/t/save-location-of-trend-files-using-the-ad-hoc/57662)
**Author:** [@steven.gyllich](https://forum.inductiveautomation.com/u/steven.gyllich)\ **Replies:** 5\ **Last updated:** [March 27, 2022, 10:04pm UTC](https://forum.inductiveautomation.com/t/save-location-of-trend-files-using-the-ad-hoc/57662 "2022-03-27T22:04:34Z")
I am using Ad Hoc Trends in my Perspective project and was wondering if there is a way to set the default save location and open location for saving/reloading Trend configuration files to/from a folder? Currently when y… --- ## [Perspective: 2-tiered menu with Horizontal Menu component?](https://forum.inductiveautomation.com/t/perspective-2-tiered-menu-with-horizontal-menu-component/40122)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 4\ **Last updated:** [March 27, 2022, 9:18pm UTC](https://forum.inductiveautomation.com/t/perspective-2-tiered-menu-with-horizontal-menu-component/40122 "2022-03-27T21:18:52Z")
Not sure if i’m missing something obvious, but how would I create a 2-tiered navigation using the Horizontal Menu component? I.e. the 1st tier shouldn’t navigate, it will just set a custom property value to say which ta… --- ## [Embed VNC in Client](https://forum.inductiveautomation.com/t/embed-vnc-in-client/47110)
**Author:** [@BryanB](https://forum.inductiveautomation.com/u/BryanB)\ **Replies:** 9\ **Last updated:** [March 27, 2022, 7:42pm UTC](https://forum.inductiveautomation.com/t/embed-vnc-in-client/47110 "2022-03-27T19:42:36Z")
I’ve received a request to embed a VNC client in an Ignition Vision client (8.0.16). The purpose of this would be to monitor an OEM HMI (PanelView or similar on the same LAN) that is located in a different location on si… --- ## [Time Series Chart - Component error!](https://forum.inductiveautomation.com/t/time-series-chart-component-error/57661)
**Author:** [@Kaloyan\_Radomirov](https://forum.inductiveautomation.com/u/Kaloyan_Radomirov)\ **Replies:** 2\ **Last updated:** [March 27, 2022, 7:22pm UTC](https://forum.inductiveautomation.com/t/time-series-chart-component-error/57661 "2022-03-27T19:22:22Z")
Sometimes this happens What could be the problem and if no solution, how to make an automatic refresh? After refresh page chart works. Thanks --- ## [Upgrading Ignition to new server](https://forum.inductiveautomation.com/t/upgrading-ignition-to-new-server/57659)
**Author:** [@Stephen\_Pena](https://forum.inductiveautomation.com/u/Stephen_Pena)\ **Replies:** 5\ **Last updated:** [March 27, 2022, 6:11pm UTC](https://forum.inductiveautomation.com/t/upgrading-ignition-to-new-server/57659 "2022-03-27T18:11:26Z")
Hello, we currently have Ignition 7.9.14 on an old MS 2008 server and we recently purchased a MS 2019 server with better hardware. We installed Ignition 8.1.15 on the new server, and made a backup file of the 7.9.14 gate… --- ## [Igntion vision 8.1](https://forum.inductiveautomation.com/t/igntion-vision-8-1/57678)
**Author:** [@Esme\_Lopez](https://forum.inductiveautomation.com/u/Esme_Lopez)\ **Replies:** 8\ **Last updated:** [March 26, 2022, 7:13pm UTC](https://forum.inductiveautomation.com/t/igntion-vision-8-1/57678 "2022-03-26T19:13:31Z")
I have this: writeBytes(\[\\x01\]) If I write a byte in hexadecimal I should receive the same ,but why the response is 127. Can anyone tell me, please? --- ## [Text Box Transparent Background](https://forum.inductiveautomation.com/t/text-box-transparent-background/57677)
**Author:** [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Replies:** 2\ **Last updated:** [March 26, 2022, 10:09pm UTC](https://forum.inductiveautomation.com/t/text-box-transparent-background/57677 "2022-03-26T22:09:40Z")
I’m using Ignition Vision 7.9.10 is there a way for me to make the “Background” of a Text Field “TRANSPARENT”? --- ## [Users schedule including a parameter date](https://forum.inductiveautomation.com/t/users-schedule-including-a-parameter-date/15977)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 11\ **Last updated:** [March 26, 2022, 8:51pm UTC](https://forum.inductiveautomation.com/t/users-schedule-including-a-parameter-date/15977 "2022-03-26T20:51:33Z")
According to a parameter date, can we obtain all users with a schedule including this date ??? --- ## [Change Row Color in a Perspective Table On Selected Index From A Tag Change](https://forum.inductiveautomation.com/t/change-row-color-in-a-perspective-table-on-selected-index-from-a-tag-change/57663)
**Author:** [@SWilkerson](https://forum.inductiveautomation.com/u/SWilkerson)\ **Replies:** 2\ **Last updated:** [March 26, 2022, 9:17am UTC](https://forum.inductiveautomation.com/t/change-row-color-in-a-perspective-table-on-selected-index-from-a-tag-change/57663 "2022-03-26T09:17:54Z")
I am trying to convert some old FactoryTalk View ME screens into Perspective screens. Having only done vision screens in the past, I am trying to implement functionality similar to a multistate indicator in FactoryTalk … --- ## [Enabling and focusing a TextFeild on an event in Perspective](https://forum.inductiveautomation.com/t/enabling-and-focusing-a-textfeild-on-an-event-in-perspective/57646)
**Author:** [@user66](https://forum.inductiveautomation.com/u/user66)\ **Replies:** 5\ **Last updated:** [March 26, 2022, 9:10am UTC](https://forum.inductiveautomation.com/t/enabling-and-focusing-a-textfeild-on-an-event-in-perspective/57646 "2022-03-26T09:10:58Z")
I have a Disabled TextField component which should be enabled and on focus when I click on a button. The TextField becomes enabled but focus does not change on the first click. This is the script I have made: self.getS… --- ## [Dropdown Filters for Historical Chart](https://forum.inductiveautomation.com/t/dropdown-filters-for-historical-chart/57516)
**Author:** [@Robert\_Hrynciw](https://forum.inductiveautomation.com/u/Robert_Hrynciw)\ **Replies:** 6\ **Last updated:** [March 26, 2022, 8:30am UTC](https://forum.inductiveautomation.com/t/dropdown-filters-for-historical-chart/57516 "2022-03-26T08:30:47Z")
Hello. I have created a historical chart on my project. This chart will be used by leaders to see where an operator badges in. This chart has dropdowns tied to it that filter through Line, Workcenter, Name, Start Date an… --- ## [Edit (Remove Template Parameter)](https://forum.inductiveautomation.com/t/edit-remove-template-parameter/57664)
**Author:** [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Replies:** 4\ **Last updated:** [March 26, 2022, 1:50am UTC](https://forum.inductiveautomation.com/t/edit-remove-template-parameter/57664 "2022-03-26T01:50:08Z")
I can’t figure out how to remove a parameter from a template I have. Please see picture. I just want to remove the “SWSTATUS” parameter from the template. --- ## [queryTagHistory Performance Issue](https://forum.inductiveautomation.com/t/querytaghistory-performance-issue/57656)
**Author:** [@brian.mcenulty](https://forum.inductiveautomation.com/u/brian.mcenulty)\ **Replies:** 1\ **Last updated:** [March 26, 2022, 1:15am UTC](https://forum.inductiveautomation.com/t/querytaghistory-performance-issue/57656 "2022-03-26T01:15:14Z")
I’m working with a system that has tag history configured consistently in terms of the sample mode and the min and max time between samples. When using the system.tag.queryTagHistory() function, I’m trying to extract the… --- ## [UX confusion when creating new styles](https://forum.inductiveautomation.com/t/ux-confusion-when-creating-new-styles/57666)
**Author:** [@peter](https://forum.inductiveautomation.com/u/peter)\ **Replies:** 1\ **Last updated:** [March 25, 2022, 10:12pm UTC](https://forum.inductiveautomation.com/t/ux-confusion-when-creating-new-styles/57666 "2022-03-25T22:12:30Z")
This is for Perspective on 8.1.15 under Ubuntu I was just experimenting with creating perspective styles and the UI for doing this confused the hell out of me for a bit. Here is a screen shot of after I created my new … --- ## [SFC Question](https://forum.inductiveautomation.com/t/sfc-question/9468)
**Author:** [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\ **Replies:** 3\ **Last updated:** [March 25, 2022, 5:50pm UTC](https://forum.inductiveautomation.com/t/sfc-question/9468 "2022-03-25T17:50:34Z")
Hey guys, Can someone explain to me how the SFC module works in a redundant system? I would like to know what happens when a long running process is executing and the master gateway suddenly goes down. Are both the mas… --- ## [SQL Server & Trusted Connection](https://forum.inductiveautomation.com/t/sql-server-trusted-connection/1830)
**Author:** [@bryan\_cook](https://forum.inductiveautomation.com/u/bryan_cook)\ **Replies:** 10\ **Last updated:** [March 25, 2022, 5:17pm UTC](https://forum.inductiveautomation.com/t/sql-server-trusted-connection/1830 "2022-03-25T17:17:22Z")
How can I configure Ignition to connect to my SQL Server database using a trusted connection/SSPI? I'm looking for something similar to ... jdbc:sqlserver://localhost;integratedSecurity=true; ... I goofed around wit… --- ## [Have HTTP binding store as a tag value](https://forum.inductiveautomation.com/t/have-http-binding-store-as-a-tag-value/57614)
**Author:** [@Scott\_Taylor](https://forum.inductiveautomation.com/u/Scott_Taylor)\ **Replies:** 2\ **Last updated:** [March 25, 2022, 4:43pm UTC](https://forum.inductiveautomation.com/t/have-http-binding-store-as-a-tag-value/57614 "2022-03-25T16:43:19Z")
I have an HTTP binding that pulls a pressure value from an API. I’d like to store this value so I can save the data and display it on a chart. Ideally, if a tag can be created from it, then I can plot the tag values on … --- ## [Report Scripting system.db.runPrepUpdate with variable date to SQL Query](https://forum.inductiveautomation.com/t/report-scripting-system-db-runprepupdate-with-variable-date-to-sql-query/57642)
**Author:** [@Richard\_Tryon](https://forum.inductiveautomation.com/u/Richard_Tryon)\ **Replies:** 3\ **Last updated:** [March 25, 2022, 2:52pm UTC](https://forum.inductiveautomation.com/t/report-scripting-system-db-runprepupdate-with-variable-date-to-sql-query/57642 "2022-03-25T14:52:45Z")
I am struggling with using variable dates (based upon 1 week span from today-1 week ago). I tried the date format as both string and a value but no luck. If I enter in static date/time instead of using the ?, it works f… --- ## [Change the binding of another property in perspective](https://forum.inductiveautomation.com/t/change-the-binding-of-another-property-in-perspective/57640)
**Author:** [@jamesennis](https://forum.inductiveautomation.com/u/jamesennis)\ **Replies:** 3\ **Last updated:** [March 25, 2022, 4:23pm UTC](https://forum.inductiveautomation.com/t/change-the-binding-of-another-property-in-perspective/57640 "2022-03-25T16:23:07Z")
Is it possible to change the binding of a property on the change of another? Let’s say I have: 3 value properties: a: 1 b: 2 c: 3 A dropdown list with values: \[a,b,c\] A label which is bound to the dropdown list wit… --- ## [How to halt a script from executing until condition is met](https://forum.inductiveautomation.com/t/how-to-halt-a-script-from-executing-until-condition-is-met/57652)
**Author:** [@William\_R](https://forum.inductiveautomation.com/u/William_R)\ **Replies:** 5\ **Last updated:** [March 25, 2022, 4:22pm UTC](https://forum.inductiveautomation.com/t/how-to-halt-a-script-from-executing-until-condition-is-met/57652 "2022-03-25T16:22:13Z")
Hello all, I was wondering what the best practice is for halting a script from continuing to execute until a condition is met. Essentially, I have a timer script that is running and I don’t want the timer script to run… --- ## [Ignition Perspective Time Series Chart Component Error](https://forum.inductiveautomation.com/t/ignition-perspective-time-series-chart-component-error/57572)
**Author:** [@Nidal](https://forum.inductiveautomation.com/u/Nidal)\ **Replies:** 4\ **Last updated:** [March 25, 2022, 3:55pm UTC](https://forum.inductiveautomation.com/t/ignition-perspective-time-series-chart-component-error/57572 "2022-03-25T15:55:59Z")
Ignition Perspective (8.1.15) does not render a time series chart correctly unless the browser is refreshed multiple times, on the designer the chart does not show but instead you get a grey box with a component error, s… --- ## [Changing the initial user password from the Client application](https://forum.inductiveautomation.com/t/changing-the-initial-user-password-from-the-client-application/16615)
**Author:** [@UUTally](https://forum.inductiveautomation.com/u/UUTally)\ **Replies:** 4\ **Last updated:** [March 25, 2022, 3:41pm UTC](https://forum.inductiveautomation.com/t/changing-the-initial-user-password-from-the-client-application/16615 "2022-03-25T15:41:15Z")
We are using active directory for user authentication and setting an initial password for every user. Is there a way to make or force the user to change their initial password once they log for the first time to the clie… --- ## [Submit button on Signature Pad not working only on Windows Tablet](https://forum.inductiveautomation.com/t/submit-button-on-signature-pad-not-working-only-on-windows-tablet/56260)
**Author:** [@sanzio](https://forum.inductiveautomation.com/u/sanzio)\ **Replies:** 7\ **Last updated:** [March 25, 2022, 3:40pm UTC](https://forum.inductiveautomation.com/t/submit-button-on-signature-pad-not-working-only-on-windows-tablet/56260 "2022-03-25T15:40:25Z")
Ignition 8.1.0, Perspective I am attempting to run a script action on the onSignatureSubmitted event of a Signature Pad. The script action runs fine on my laptop (Dell Precision 7550). However, the submit signature bu… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=867) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=869)