# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=927 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 928 --- ## [Redundancy Issue: OPC tags values not syncing properly after redundancy failover](https://forum.inductiveautomation.com/t/redundancy-issue-opc-tags-values-not-syncing-properly-after-redundancy-failover/53400)
**Author:** [@guipinper](https://forum.inductiveautomation.com/u/guipinper)\ **Replies:** 0\ **Last updated:** [November 23, 2021, 6:35pm UTC](https://forum.inductiveautomation.com/t/redundancy-issue-opc-tags-values-not-syncing-properly-after-redundancy-failover/53400 "2021-11-23T18:35:37Z")
Hi, Our system is composed by 3 machines running Ignition 7.9.14. Two machines form the master+backup pair and the third one is used for monitoring related operations using the Gateway Network in read-only mode. We det… --- ## [Unable to connect to gateway](https://forum.inductiveautomation.com/t/unable-to-connect-to-gateway/53320)
**Author:** [@mandeep\_gill](https://forum.inductiveautomation.com/u/mandeep_gill)\ **Replies:** 6\ **Last updated:** [November 23, 2021, 6:09pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-gateway/53320 "2021-11-23T18:09:59Z")
Hi , I am currently using the ignition 8.1.11. I can launch the vision client on the same machine. but when i tried to access the gateway on other machine vision launcher keep on retrying the connection. Vision client l… --- ## [Is this an encoding problem?](https://forum.inductiveautomation.com/t/is-this-an-encoding-problem/53370)
**Author:** [@wangjun\_ming\_1996](https://forum.inductiveautomation.com/u/wangjun_ming_1996)\ **Replies:** 5\ **Last updated:** [November 23, 2021, 5:47pm UTC](https://forum.inductiveautomation.com/t/is-this-an-encoding-problem/53370 "2021-11-23T17:47:44Z")
I use another software to write python script and copy to Ignition. Then Ignition prompt Red wavy line. I don’t know what’s going on. Is this an encoding problem? I use UTF-8 encoding now. --- ## [Is it possible to check for a number parameter in named query?](https://forum.inductiveautomation.com/t/is-it-possible-to-check-for-a-number-parameter-in-named-query/53388)
**Author:** [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\ **Replies:** 16\ **Last updated:** [November 23, 2021, 5:44pm UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-check-for-a-number-parameter-in-named-query/53388 "2021-11-23T17:44:44Z")
Hello all, I am trying to check for a value in my named query and that value is an integer parameter. The parameter is called partNo The name query is where I am checking for the word SN and the parameter partNo integ… --- ## [Perspective Table rowIndex vs row](https://forum.inductiveautomation.com/t/perspective-table-rowindex-vs-row/39501)
**Author:** [@kgamble](https://forum.inductiveautomation.com/u/kgamble)\ **Replies:** 3\ **Last updated:** [November 23, 2021, 5:08pm UTC](https://forum.inductiveautomation.com/t/perspective-table-rowindex-vs-row/39501 "2021-11-23T17:08:32Z")
I have been looking in the documentation, and cant seem to find it, but what is the difference between rowIndex and row in the implicitly provided embedded view column parameters? --- ## [Can someone tell me a story here? Network problems, data latency, hope the image uploads!](https://forum.inductiveautomation.com/t/can-someone-tell-me-a-story-here-network-problems-data-latency-hope-the-image-uploads/53387)
**Author:** [@eric2](https://forum.inductiveautomation.com/u/eric2)\ **Replies:** 8\ **Last updated:** [November 23, 2021, 4:48pm UTC](https://forum.inductiveautomation.com/t/can-someone-tell-me-a-story-here-network-problems-data-latency-hope-the-image-uploads/53387 "2021-11-23T16:48:36Z")
Okay, if you can see the above image, can you tell me what this means? The information in the manual is insufficient to understand what is happening. I am trying to read a couple of UDTs. Within the UDT there is an … --- ## [Vision Power Table Footer](https://forum.inductiveautomation.com/t/vision-power-table-footer/53393)
**Author:** [@nicholas.robinson](https://forum.inductiveautomation.com/u/nicholas.robinson)\ **Replies:** 1\ **Last updated:** [November 23, 2021, 4:47pm UTC](https://forum.inductiveautomation.com/t/vision-power-table-footer/53393 "2021-11-23T16:47:49Z")
Does anyone have a trick up their sleeve for how to add a footer to the vision powr table? In the perspective table there is a convenient option where I can add whatever formula I want to sum up values in each column. T… --- ## [\[FEATURE\] Perspective Alt-Click to select components behind](https://forum.inductiveautomation.com/t/feature-perspective-alt-click-to-select-components-behind/47865)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 9\ **Last updated:** [November 23, 2021, 2:40pm UTC](https://forum.inductiveautomation.com/t/feature-perspective-alt-click-to-select-components-behind/47865 "2021-11-23T14:40:48Z")
I’m really missing this feature from Vision! It’s hard with performance issues with designing in Perspective trying to select the right objects and this feature would certainly help! https://ideas.inductiveautomation.co… --- ## [AES 256 bit Encryption /Decryption Using Scripting?](https://forum.inductiveautomation.com/t/aes-256-bit-encryption-decryption-using-scripting/53386)
**Author:** [@Shanmukharao.C](https://forum.inductiveautomation.com/u/Shanmukharao.C)\ **Replies:** 1\ **Last updated:** [November 23, 2021, 2:28pm UTC](https://forum.inductiveautomation.com/t/aes-256-bit-encryption-decryption-using-scripting/53386 "2021-11-23T14:28:01Z")
Hi, I need to encrypt a string using AES 256. Is there a way to do it within Ignition? --- ## [How can I show / hide the component column of the Perspective table at runtime?](https://forum.inductiveautomation.com/t/how-can-i-show-hide-the-component-column-of-the-perspective-table-at-runtime/53330)
**Author:** [@cesma2000](https://forum.inductiveautomation.com/u/cesma2000)\ **Replies:** 3\ **Last updated:** [November 23, 2021, 2:06pm UTC](https://forum.inductiveautomation.com/t/how-can-i-show-hide-the-component-column-of-the-perspective-table-at-runtime/53330 "2021-11-23T14:06:16Z")
Hi folks, I need to add a feature to my project, but I need some advice because I have been using this SW for less than a while. On the page, I use views to show data with the table component, the data to show in the ta… --- ## [Error on sending data to SQL](https://forum.inductiveautomation.com/t/error-on-sending-data-to-sql/53380)
**Author:** [@berkay.cinar](https://forum.inductiveautomation.com/u/berkay.cinar)\ **Replies:** 4\ **Last updated:** [November 23, 2021, 1:44pm UTC](https://forum.inductiveautomation.com/t/error-on-sending-data-to-sql/53380 "2021-11-23T13:44:17Z")
Hello, I was sending data to sql via tag change script below. It was working but somehow it stopped sending data to sql I check the script there is no error on the diagnostics. Script below; What do you think the reaso… --- ## [Error connection SQL Server database after upgrade Ignition](https://forum.inductiveautomation.com/t/error-connection-sql-server-database-after-upgrade-ignition/53281)
**Author:** [@stefano.sforna](https://forum.inductiveautomation.com/u/stefano.sforna)\ **Replies:** 2\ **Last updated:** [November 23, 2021, 12:45pm UTC](https://forum.inductiveautomation.com/t/error-connection-sql-server-database-after-upgrade-ignition/53281 "2021-11-23T12:45:53Z")
Goodmorning, I upgraded Ignition 8.1.5 to Ignition 8.1.12. After upgrade, I have error of connection to database SQL SERVER 2014. Before upgrade, database connection are ok. See photo for error. Why ??? --- ## [Want to search number from multiple flex repeater on 3 different screen](https://forum.inductiveautomation.com/t/want-to-search-number-from-multiple-flex-repeater-on-3-different-screen/53346)
**Author:** [@Anita.Shinde](https://forum.inductiveautomation.com/u/Anita.Shinde)\ **Replies:** 6\ **Last updated:** [November 23, 2021, 11:01am UTC](https://forum.inductiveautomation.com/t/want-to-search-number-from-multiple-flex-repeater-on-3-different-screen/53346 "2021-11-23T11:01:19Z")
Hi, I have screen containing multiple flex repeater and I want to search any number among 3 screens and the number should highlight. eg. Here I am searching 48 number, 1st It will search on 1st tab, if 48 number is not… --- ## [How to open popup view in specific other views from OPC tag change](https://forum.inductiveautomation.com/t/how-to-open-popup-view-in-specific-other-views-from-opc-tag-change/52394)
**Author:** [@berkay.cinar](https://forum.inductiveautomation.com/u/berkay.cinar)\ **Replies:** 3\ **Last updated:** [November 23, 2021, 9:04am UTC](https://forum.inductiveautomation.com/t/how-to-open-popup-view-in-specific-other-views-from-opc-tag-change/52394 "2021-11-23T09:04:02Z")
Hello, I have been trying to set a video to play from certain conditions on some of my perspective views. I was thinking to put these videos to popup views and call this views to popup only in the other views I want and… --- ## [View Security - Perspective Session Security and Security in Ignition 8.1.\*](https://forum.inductiveautomation.com/t/view-security-perspective-session-security-and-security-in-ignition-8-1/53352)
**Author:** [@PRAMANJ](https://forum.inductiveautomation.com/u/PRAMANJ)\ **Replies:** 2\ **Last updated:** [November 23, 2021, 6:35am UTC](https://forum.inductiveautomation.com/t/view-security-perspective-session-security-and-security-in-ignition-8-1/53352 "2021-11-23T06:35:29Z")
The IU topic View Security - Perspective Session Security (inductiveuniversity.com) shows a different popup menu on right clicking a view in the project browser window than what actually appears in the latest version 8.1… --- ## [Web Browser 'no supported operating system detected'](https://forum.inductiveautomation.com/t/web-browser-no-supported-operating-system-detected/53350)
**Author:** [@user62](https://forum.inductiveautomation.com/u/user62)\ **Replies:** 0\ **Last updated:** [November 22, 2021, 4:00pm UTC](https://forum.inductiveautomation.com/t/web-browser-no-supported-operating-system-detected/53350 "2021-11-22T16:00:00Z")
Hey there, I have an issue when deploying a screen that uses the web browser, it says “no supported operating system detected”. I read a bit on this, I currently am using Web Browser Module 3.9.12 with Ignition platform… --- ## [Ignition alarm page to display limited number of alarms](https://forum.inductiveautomation.com/t/ignition-alarm-page-to-display-limited-number-of-alarms/30039)
**Author:** [@Jeff.Lin2014](https://forum.inductiveautomation.com/u/Jeff.Lin2014)\ **Replies:** 9\ **Last updated:** [November 22, 2021, 9:30pm UTC](https://forum.inductiveautomation.com/t/ignition-alarm-page-to-display-limited-number-of-alarms/30039 "2021-11-22T21:30:17Z")
Hi all, I am currently working on an ignition SCADA project. The client wants to display both active alarms and alarm log under different pages, and he also wants to display only 50 latest alarms (both active and cleare… --- ## [Pull Alarms from a Named Query](https://forum.inductiveautomation.com/t/pull-alarms-from-a-named-query/53360)
**Author:** [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\ **Replies:** 0\ **Last updated:** [November 22, 2021, 8:48pm UTC](https://forum.inductiveautomation.com/t/pull-alarms-from-a-named-query/53360 "2021-11-22T20:48:34Z")
Is it possible to pull the alarms to the alarm status table or alarm journal from a named query? I want to be able to limit the alarms to the most recent 50 alarms. I could not find a way to do this except on the SQL si… --- ## [Vision Table Row Color](https://forum.inductiveautomation.com/t/vision-table-row-color/53356)
**Author:** [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\ **Replies:** 9\ **Last updated:** [November 22, 2021, 7:06pm UTC](https://forum.inductiveautomation.com/t/vision-table-row-color/53356 "2021-11-22T19:06:54Z")
Hello all, I am trying to change the row color of my vision table based on the value of the individual cells in my table. So for example, if orderno is equal to my tag value I want that row to change the color. I wro… --- ## [Named Queries vs. Stored Procedures](https://forum.inductiveautomation.com/t/named-queries-vs-stored-procedures/53351)
**Author:** [@bradbarbin](https://forum.inductiveautomation.com/u/bradbarbin)\ **Replies:** 8\ **Last updated:** [November 22, 2021, 6:56pm UTC](https://forum.inductiveautomation.com/t/named-queries-vs-stored-procedures/53351 "2021-11-22T18:56:10Z")
Looking for some guidance on best practices for querying/updating the database through Ignition. Before Ignition, we did almost every database update through stored procedures. Named queries seem to be the native “Ignit… --- ## [Export Report viewer report in Excel Format](https://forum.inductiveautomation.com/t/export-report-viewer-report-in-excel-format/53329)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 5\ **Last updated:** [November 22, 2021, 4:58pm UTC](https://forum.inductiveautomation.com/t/export-report-viewer-report-in-excel-format/53329 "2021-11-22T16:58:33Z")
Hi @PGriffith i am saving the report from report viewer I have using the script to save data in pdf and excel format = event.source.parent.getComponent('Dropdown\_Format').selectedStringValue window = system.gui.getWi… --- ## [Importing xlrd library for reading Excel files](https://forum.inductiveautomation.com/t/importing-xlrd-library-for-reading-excel-files/53332)
**Author:** [@g.cascales](https://forum.inductiveautomation.com/u/g.cascales)\ **Replies:** 4\ **Last updated:** [November 22, 2021, 3:09pm UTC](https://forum.inductiveautomation.com/t/importing-xlrd-library-for-reading-excel-files/53332 "2021-11-22T15:09:11Z")
Hi all! After reading and trying different solutions from the forum I am unable to do the following: I have an Excel file (with only one sheet) I want to read using an external python library (i.e. xlrd) and write the… --- ## [How to add a row to a dropdown?](https://forum.inductiveautomation.com/t/how-to-add-a-row-to-a-dropdown/53343)
**Author:** [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\ **Replies:** 4\ **Last updated:** [November 22, 2021, 2:32pm UTC](https://forum.inductiveautomation.com/t/how-to-add-a-row-to-a-dropdown/53343 "2021-11-22T14:32:17Z")
Hello All, I have a dropdown menu and its data is bound to a named query, now I want to manually add another row to this drop-down, but I can not find any solution for it. Manual suggested using a push-button and use sy… --- ## [SFC - Error Handling](https://forum.inductiveautomation.com/t/sfc-error-handling/53341)
**Author:** [@p.srikanth0707](https://forum.inductiveautomation.com/u/p.srikanth0707)\ **Replies:** 0\ **Last updated:** [November 22, 2021, 2:07pm UTC](https://forum.inductiveautomation.com/t/sfc-error-handling/53341 "2021-11-22T14:07:34Z")
Hi all, How to use this error handling in SFC, can we control the SFC with some errors/discrepancy logic to hold SFC? Regards, Srikanth P --- ## [How to pass value from Database (SQLite) to Internal Memory Tags](https://forum.inductiveautomation.com/t/how-to-pass-value-from-database-sqlite-to-internal-memory-tags/53166)
**Author:** [@p.srikanth0707](https://forum.inductiveautomation.com/u/p.srikanth0707)\ **Replies:** 9\ **Last updated:** [November 22, 2021, 2:01pm UTC](https://forum.inductiveautomation.com/t/how-to-pass-value-from-database-sqlite-to-internal-memory-tags/53166 "2021-11-22T14:01:42Z")
Hello all, Good Morning, Could you please help me how to pass the values from database table column values to Memory tags ? Appreciated for your quick response with the simple solutions Regards, Srikanth P --- ## [SFC - Step status monitorning](https://forum.inductiveautomation.com/t/sfc-step-status-monitorning/53339)
**Author:** [@p.srikanth0707](https://forum.inductiveautomation.com/u/p.srikanth0707)\ **Replies:** 0\ **Last updated:** [November 22, 2021, 1:58pm UTC](https://forum.inductiveautomation.com/t/sfc-step-status-monitorning/53339 "2021-11-22T13:58:22Z")
Hi, How to monitor the current step time ? not complete SFC time, I want to monitor running step time and also I would like to know the limitations to action. Regards, Srikanth P --- ## [Filter in table](https://forum.inductiveautomation.com/t/filter-in-table/53282)
**Author:** [@sahamed](https://forum.inductiveautomation.com/u/sahamed)\ **Replies:** 6\ **Last updated:** [November 22, 2021, 11:31am UTC](https://forum.inductiveautomation.com/t/filter-in-table/53282 "2021-11-22T11:31:49Z")
Hi, I am using the Tag Historian option to log the data. On the Table, using Tag History binding, we can able to show the logged data. I need to add a filter which needs to works like ‘WHERE’ clause in SQL query. Like … --- ## [How can a Perspective Table SubView not use default height of the subview?](https://forum.inductiveautomation.com/t/how-can-a-perspective-table-subview-not-use-default-height-of-the-subview/51000)
**Author:** [@321liftoff](https://forum.inductiveautomation.com/u/321liftoff)\ **Replies:** 2\ **Last updated:** [November 22, 2021, 9:55am UTC](https://forum.inductiveautomation.com/t/how-can-a-perspective-table-subview-not-use-default-height-of-the-subview/51000 "2021-11-22T09:55:12Z")
In EmbeddedView and FlexRepeater components, the options to “useDefaultViewWidth” and “useDefaultViewHeight” are included, enabling a designer to select false so the default height can be large for editing within the des… --- ## [Perspective view vertical scrollbar elimination](https://forum.inductiveautomation.com/t/perspective-view-vertical-scrollbar-elimination/53317)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 2\ **Last updated:** [November 22, 2021, 6:41am UTC](https://forum.inductiveautomation.com/t/perspective-view-vertical-scrollbar-elimination/53317 "2021-11-22T06:41:13Z")
Can anyone see why I have a vertical scollbar on this coordinate view? There is nothing in the view below the Deviation limit bottom border. Thanks. --- ## [Show progress bar during report loading](https://forum.inductiveautomation.com/t/show-progress-bar-during-report-loading/53293)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 27\ **Last updated:** [November 22, 2021, 12:14am UTC](https://forum.inductiveautomation.com/t/show-progress-bar-during-report-loading/53293 "2021-11-22T00:14:10Z")
Hi @PGriffith I have report viewer.. i am using to show report in table format .. i have script in button but that is in template. when i click the button its not showing any loading thing in the report viewer. so pl… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=926) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=928)