# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=840 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 841 --- ## [Perspective Tree - restore tree expansion after self.refreshBinding("props.items")](https://forum.inductiveautomation.com/t/perspective-tree-restore-tree-expansion-after-self-refreshbinding-props-items/59779)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 6\ **Last updated:** [May 20, 2022, 6:29am UTC](https://forum.inductiveautomation.com/t/perspective-tree-restore-tree-expansion-after-self-refreshbinding-props-items/59779 "2022-05-20T06:29:24Z")
Ignition V8.1.15 I need to refresh the tree to eliminate the branch if it is now empty or add a new branch if one has been created. The problem is that the tree collapses so the user has to navigate the tree again. Th… --- ## [Perspective table binding in narrow mode](https://forum.inductiveautomation.com/t/perspective-table-binding-in-narrow-mode/59233)
**Author:** [@ASF](https://forum.inductiveautomation.com/u/ASF)\ **Replies:** 3\ **Last updated:** [May 19, 2022, 10:49pm UTC](https://forum.inductiveautomation.com/t/perspective-table-binding-in-narrow-mode/59233 "2022-05-19T22:49:20Z")
I have a named query that returns a single row of batch data, e.g.: ID: ABC123 Description: My Batch WeightSP: 100 WeightPV: 101 Status: Complete …and I would like to display it in a table, looking just like it does ab… --- ## [Ignition Query Alarm Journal causing gateway crash](https://forum.inductiveautomation.com/t/ignition-query-alarm-journal-causing-gateway-crash/59769)
**Author:** [@liam1](https://forum.inductiveautomation.com/u/liam1)\ **Replies:** 9\ **Last updated:** [May 19, 2022, 9:38pm UTC](https://forum.inductiveautomation.com/t/ignition-query-alarm-journal-causing-gateway-crash/59769 "2022-05-19T21:38:09Z")
Hi all, When running the system.alarm.queryJournal() function the gateway’s memory starts to fill up , which then leads to the gateway crashing. Is there a performant way to use this function in order to stop this fro… --- ## [Change Script on View Param works in Preview but not in Client](https://forum.inductiveautomation.com/t/change-script-on-view-param-works-in-preview-but-not-in-client/59753)
**Author:** [@nicholas.robinson](https://forum.inductiveautomation.com/u/nicholas.robinson)\ **Replies:** 5\ **Last updated:** [May 19, 2022, 9:34pm UTC](https://forum.inductiveautomation.com/t/change-script-on-view-param-works-in-preview-but-not-in-client/59753 "2022-05-19T21:34:20Z")
I have a tag change script on a view param that looks like this: Param (end time in millis) Change Script endMillis = currentValue.value end = system.date.fromMillis(endMillis) # make the range to the most rece… --- ## [Buttons on Perspective Views not working](https://forum.inductiveautomation.com/t/buttons-on-perspective-views-not-working/59490)
**Author:** [@Steve\_L](https://forum.inductiveautomation.com/u/Steve_L)\ **Replies:** 12\ **Last updated:** [May 19, 2022, 7:40pm UTC](https://forum.inductiveautomation.com/t/buttons-on-perspective-views-not-working/59490 "2022-05-19T19:40:50Z")
We have an Ignition system running v8.1.4 with a Perspective client running in a Firefox window in Kiosk mode on a keyboardless, touch screen running Windows 10. The system runs fine most of the time, however, somethin… --- ## [Report Text Box Overflow](https://forum.inductiveautomation.com/t/report-text-box-overflow/59795)
**Author:** [@csilk](https://forum.inductiveautomation.com/u/csilk)\ **Replies:** 2\ **Last updated:** [May 19, 2022, 7:01pm UTC](https://forum.inductiveautomation.com/t/report-text-box-overflow/59795 "2022-05-19T19:01:09Z")
I am working on creating a report and I have a text box that could have multiple different lines of information, it could be 1 line of text or it could be 300 lines of text. I have the text area’s behavior set to ‘Grow R… --- ## [\[SOLVED\] Text field component](https://forum.inductiveautomation.com/t/solved-text-field-component/59750)
**Author:** [@Esmeralda\_Lopez](https://forum.inductiveautomation.com/u/Esmeralda_Lopez)\ **Replies:** 14\ **Last updated:** [May 19, 2022, 6:15pm UTC](https://forum.inductiveautomation.com/t/solved-text-field-component/59750 "2022-05-19T18:15:09Z")
Hello, I want to change the value of a tag to display in a label , how can I do that ? Like set or update for another word : Connected = ready --- ## [8.1.17 Redundancy Change](https://forum.inductiveautomation.com/t/8-1-17-redundancy-change/59536)
**Author:** [@brandon1](https://forum.inductiveautomation.com/u/brandon1)\ **Replies:** 4\ **Last updated:** [May 19, 2022, 5:45pm UTC](https://forum.inductiveautomation.com/t/8-1-17-redundancy-change/59536 "2022-05-19T17:45:04Z")
Quote from the 8.1.17 blog: Redundancy Failover to a redundant node is now allowed if the nodes have different platform versions, which allows attached clients to remain connected to at least one node during a redundan… --- ## [Access to a shared folder to rename a file that ask for a login](https://forum.inductiveautomation.com/t/access-to-a-shared-folder-to-rename-a-file-that-ask-for-a-login/59692)
**Author:** [@rigoberto.reyes](https://forum.inductiveautomation.com/u/rigoberto.reyes)\ **Replies:** 2\ **Last updated:** [May 19, 2022, 5:33pm UTC](https://forum.inductiveautomation.com/t/access-to-a-shared-folder-to-rename-a-file-that-ask-for-a-login/59692 "2022-05-19T17:33:34Z")
Hi there. Recently, I already crated a script to read and rename a remote file (IP address 10.1.2.26), it is possible to read it, but is not possible to rename it , because the remote folder is protected and login is ne… --- ## [Query Internal Tag Historian](https://forum.inductiveautomation.com/t/query-internal-tag-historian/59749)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 11\ **Last updated:** [May 19, 2022, 4:13pm UTC](https://forum.inductiveautomation.com/t/query-internal-tag-historian/59749 "2022-05-19T16:13:41Z")
How do I query the internal tag historian SQLite database, if possible? I have tag history enabled for a flow and would like to use a query to do a summation of the last 7 days’ final flows. What is the internal .db fil… --- ## [\[IGN-6089\]Binding map transform output type expression](https://forum.inductiveautomation.com/t/ign-6089-binding-map-transform-output-type-expression/59790)
**Author:** [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Replies:** 4\ **Last updated:** [May 19, 2022, 4:13pm UTC](https://forum.inductiveautomation.com/t/ign-6089-binding-map-transform-output-type-expression/59790 "2022-05-19T16:13:18Z")
I am playing around with a binding and using map transform. I changed the output type from value to expression and entered an expression of: if({\[Sample\_Tags\]myTag}, 'something', 'somethingElse') If I apply and hit OK… --- ## [Simulate an Enter Key Press](https://forum.inductiveautomation.com/t/simulate-an-enter-key-press/59756)
**Author:** [@rwalters1](https://forum.inductiveautomation.com/u/rwalters1)\ **Replies:** 2\ **Last updated:** [May 19, 2022, 4:05pm UTC](https://forum.inductiveautomation.com/t/simulate-an-enter-key-press/59756 "2022-05-19T16:05:11Z")
Ignition Vision: I have a popup screen with a button that closes the popup window and sets the focus on a text field in the main window- This functions as expected- Once the focus is set, I would also like to have a si… --- ## [Setting Perspective Inactivity Time to 0](https://forum.inductiveautomation.com/t/setting-perspective-inactivity-time-to-0/59787)
**Author:** [@jacob.ramirez](https://forum.inductiveautomation.com/u/jacob.ramirez)\ **Replies:** 1\ **Last updated:** [May 19, 2022, 3:48pm UTC](https://forum.inductiveautomation.com/t/setting-perspective-inactivity-time-to-0/59787 "2022-05-19T15:48:00Z")
If you set the perspective inactivity timer to 0, does that mean it will never timeout? --- ## [Passing dates to named queries](https://forum.inductiveautomation.com/t/passing-dates-to-named-queries/59739)
**Author:** [@Dustin\_VanKeuren](https://forum.inductiveautomation.com/u/Dustin_VanKeuren)\ **Replies:** 16\ **Last updated:** [May 19, 2022, 3:36pm UTC](https://forum.inductiveautomation.com/t/passing-dates-to-named-queries/59739 "2022-05-19T15:36:45Z")
I have a simple named query that has two datetime parameters, StartDate and EndDate. The query just calls a stored procedure, passing in the two dates. Testing the named query in the builder returns what I would expect… --- ## [Integer Array Tags](https://forum.inductiveautomation.com/t/integer-array-tags/59789)
**Author:** [@dion.botha](https://forum.inductiveautomation.com/u/dion.botha)\ **Replies:** 1\ **Last updated:** [May 19, 2022, 3:14pm UTC](https://forum.inductiveautomation.com/t/integer-array-tags/59789 "2022-05-19T15:14:30Z")
Hi All, I have 2 memory tags for a ASRS system. One is of all the container ids and one is of all the container ids that are empty. I would like another memory tag that will give me all the container ids that are not em… --- ## [Way to view the raw SQL of a query binding?](https://forum.inductiveautomation.com/t/way-to-view-the-raw-sql-of-a-query-binding/59674)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 21\ **Last updated:** [May 19, 2022, 3:12pm UTC](https://forum.inductiveautomation.com/t/way-to-view-the-raw-sql-of-a-query-binding/59674 "2022-05-19T15:12:40Z")
Just had an issue where I had to optimize a window. After searching through every component/root container property that had a query binding, I was able to remove a couple of redundant queries by putting them into a sin… --- ## [Gateway Startup Issue](https://forum.inductiveautomation.com/t/gateway-startup-issue/59757)
**Author:** [@tom\_douglas](https://forum.inductiveautomation.com/u/tom_douglas)\ **Replies:** 5\ **Last updated:** [May 19, 2022, 3:03pm UTC](https://forum.inductiveautomation.com/t/gateway-startup-issue/59757 "2022-05-19T15:03:22Z")
Not sure what is keeping the Gateway from starting up. And don’t see a wrapper log generated. --- ## [Changing Easy Chart Pen from a template](https://forum.inductiveautomation.com/t/changing-easy-chart-pen-from-a-template/59782)
**Author:** [@Benjamin\_Kimes1](https://forum.inductiveautomation.com/u/Benjamin_Kimes1)\ **Replies:** 2\ **Last updated:** [May 19, 2022, 2:29pm UTC](https://forum.inductiveautomation.com/t/changing-easy-chart-pen-from-a-template/59782 "2022-05-19T14:29:56Z")
I am trying to make an HOA for motors for my company. I have made a template that when it is clicked automatically fills a popup window with all the correct information (Motor Number, Amps, etc). I have been unable to … --- ## [Client event not working](https://forum.inductiveautomation.com/t/client-event-not-working/59773)
**Author:** [@mootez\_bh](https://forum.inductiveautomation.com/u/mootez_bh)\ **Replies:** 2\ **Last updated:** [May 19, 2022, 11:44am UTC](https://forum.inductiveautomation.com/t/client-event-not-working/59773 "2022-05-19T11:44:20Z")
in trying to run the script below on a tag change event: trigger = system.tag.readBlocking(\["\[CC\_OEE\]TrumpfTags/2267/TruLaser (L52)\_A1230E0148/Machine/Flag"\])\[0\].value date = system.tag.readBlocking(\["\[CC\_OEE\]TrumpfTag… --- ## [\[Bug-2419\] Perspective URL Params do not update page on subsequent changes](https://forum.inductiveautomation.com/t/bug-2419-perspective-url-params-do-not-update-page-on-subsequent-changes/46461)
**Author:** [@AnthonyF](https://forum.inductiveautomation.com/u/AnthonyF)\ **Replies:** 20\ **Last updated:** [May 19, 2022, 10:12am UTC](https://forum.inductiveautomation.com/t/bug-2419-perspective-url-params-do-not-update-page-on-subsequent-changes/46461 "2022-05-19T10:12:32Z")
Updated our gateway to v8.1.5 the other day and since then passing parameters through a view URL seems to be broken. It was working prior to the update. Anyone else seeing this issue? Edit: Further testing indicates th… --- ## [Reporting module - RMXString: Couldn't find font for char](https://forum.inductiveautomation.com/t/reporting-module-rmxstring-couldnt-find-font-for-char/59492)
**Author:** [@francisco.carmona](https://forum.inductiveautomation.com/u/francisco.carmona)\ **Replies:** 2\ **Last updated:** [May 19, 2022, 10:08am UTC](https://forum.inductiveautomation.com/t/reporting-module-rmxstring-couldnt-find-font-for-char/59492 "2022-05-19T10:08:50Z")
Hi all, We are getting some warnings when creating (excel) reports that include Chinese characters. It seems the font cannot be found. The reports are created fine, so we are just wondering if we should just ignore the… --- ## [Using a Windows VM system-assigned managed identity to access Azure SQL/MS SQL from Ignition](https://forum.inductiveautomation.com/t/using-a-windows-vm-system-assigned-managed-identity-to-access-azure-sql-ms-sql-from-ignition/59774)
**Author:** [@aravindan.s](https://forum.inductiveautomation.com/u/aravindan.s)\ **Replies:** 0\ **Last updated:** [May 19, 2022, 8:43am UTC](https://forum.inductiveautomation.com/t/using-a-windows-vm-system-assigned-managed-identity-to-access-azure-sql-ms-sql-from-ignition/59774 "2022-05-19T08:43:00Z")
Hello All , We are running our Ignition on Azure VM , and we want to make DB connection to MS SQL which is also hosted in cloud . Using SQL authentication based connection is not recommended by our client ,so we are… --- ## [Orphaned UDT Error](https://forum.inductiveautomation.com/t/orphaned-udt-error/10458)
**Author:** [@jreynolds](https://forum.inductiveautomation.com/u/jreynolds)\ **Replies:** 6\ **Last updated:** [May 19, 2022, 3:02am UTC](https://forum.inductiveautomation.com/t/orphaned-udt-error/10458 "2022-05-19T03:02:36Z")
I'm not sure what is causing this error and I don't know how to fix it. RootContainer.PT is a UDT property on the root container java.lang.Exception: Cannot assign orphaned UDT instance to a component property: Root… --- ## [How to test whether a tag has alarms configured?](https://forum.inductiveautomation.com/t/how-to-test-whether-a-tag-has-alarms-configured/59744)
**Author:** [@tyler.bennett](https://forum.inductiveautomation.com/u/tyler.bennett)\ **Replies:** 4\ **Last updated:** [May 19, 2022, 2:27am UTC](https://forum.inductiveautomation.com/t/how-to-test-whether-a-tag-has-alarms-configured/59744 "2022-05-19T02:27:30Z")
What is the best way to determine whether a tag has any alarms configured (active or not), given a tag path passed as a parameter? I’m trying to show (or hide) an alarm indicator graphic (embedded view) dependent on whet… --- ## [Template canvas set gap to 0](https://forum.inductiveautomation.com/t/template-canvas-set-gap-to-0/59752)
**Author:** [@richardNZ15](https://forum.inductiveautomation.com/u/richardNZ15)\ **Replies:** 6\ **Last updated:** [May 18, 2022, 11:43pm UTC](https://forum.inductiveautomation.com/t/template-canvas-set-gap-to-0/59752 "2022-05-18T23:43:59Z")
Hi there, I’m trying to use the Template Canvas Layout Positioning mode to put a few templates in a row. Its a fairly simple application, there will only be one row of components, only two different templates will be u… --- ## [Using tag data quality to set tag value](https://forum.inductiveautomation.com/t/using-tag-data-quality-to-set-tag-value/59329)
**Author:** [@coiceclimber](https://forum.inductiveautomation.com/u/coiceclimber)\ **Replies:** 23\ **Last updated:** [May 18, 2022, 10:41pm UTC](https://forum.inductiveautomation.com/t/using-tag-data-quality-to-set-tag-value/59329 "2022-05-18T22:41:51Z")
Hello, I am using Red Lion OPC connection to read and display the speed of a ski lift. The speed value controls the background color of lines, text labels and numeric labels. Obviously the ski lift must be powered up … --- ## [Runtime Schedule](https://forum.inductiveautomation.com/t/runtime-schedule/59745)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 4\ **Last updated:** [May 18, 2022, 9:50pm UTC](https://forum.inductiveautomation.com/t/runtime-schedule/59745 "2022-05-18T21:50:46Z")
Hi, I am trying to build a schedule UI with three text fields/pop up shift selectors. Underneath the UI I would like to have a string of the format start1Time AM - end1Time PM , start2Time etc… Right now I have a good … --- ## [Vision client hangs when on VPN connection or at an alternate company site](https://forum.inductiveautomation.com/t/vision-client-hangs-when-on-vpn-connection-or-at-an-alternate-company-site/59751)
**Author:** [@batman01793](https://forum.inductiveautomation.com/u/batman01793)\ **Replies:** 2\ **Last updated:** [May 18, 2022, 9:50pm UTC](https://forum.inductiveautomation.com/t/vision-client-hangs-when-on-vpn-connection-or-at-an-alternate-company-site/59751 "2022-05-18T21:50:33Z")
When I am on site and connected via Wi-Fi or Ethernet I have zero issues vision client works fine. If I am at another plant or using VPN to remote in to the network my vision client hangs (clock stops and pause restarts… --- ## [No Displaypath with system.alarm.queryJournal?](https://forum.inductiveautomation.com/t/no-displaypath-with-system-alarm-queryjournal/12839)
**Author:** [@abishur](https://forum.inductiveautomation.com/u/abishur)\ **Replies:** 4\ **Last updated:** [May 18, 2022, 8:53pm UTC](https://forum.inductiveautomation.com/t/no-displaypath-with-system-alarm-queryjournal/12839 "2022-05-18T20:53:29Z")
I am trying to view the alarm journal and limit its results to just the most 5 recent entries. I didn’t see an option for that on the official alarm journal object so I wrote a script that would query the alarm journal … --- ## [Alarm journal refresh and registers](https://forum.inductiveautomation.com/t/alarm-journal-refresh-and-registers/59738)
**Author:** [@Esmeralda\_Lopez](https://forum.inductiveautomation.com/u/Esmeralda_Lopez)\ **Replies:** 12\ **Last updated:** [May 18, 2022, 8:43pm UTC](https://forum.inductiveautomation.com/t/alarm-journal-refresh-and-registers/59738 "2022-05-18T20:43:58Z")
How can I prevent the alarms from being recorded by themselves? they only need to be registered by the user to appear in the alarm journal, but If the alarms are not registered yet, they should stay in the alarm status t… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=839) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=841)