# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=928 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 929 --- ## [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… --- ## [Convert String to date](https://forum.inductiveautomation.com/t/convert-string-to-date/53302)
**Author:** [@etlikmilos](https://forum.inductiveautomation.com/u/etlikmilos)\ **Replies:** 16\ **Last updated:** [November 21, 2021, 3:18pm UTC](https://forum.inductiveautomation.com/t/convert-string-to-date/53302 "2021-11-21T15:18:20Z")
Hello So can you please help me? I have the date as a string in this formát : Fri Nov 19 2021 18:02:03 GMT+0100 (Středoevropský standardní čas) And I need date as the date. I try to parse for the date but I have a pr… --- ## [SFC Demo project](https://forum.inductiveautomation.com/t/sfc-demo-project/53315)
**Author:** [@Sourabh\_Ambildhuke](https://forum.inductiveautomation.com/u/Sourabh_Ambildhuke)\ **Replies:** 0\ **Last updated:** [November 21, 2021, 5:53am UTC](https://forum.inductiveautomation.com/t/sfc-demo-project/53315 "2021-11-21T05:53:43Z")
Hi everyone, can i get the demo project of SFC module for any small control process. --- ## [Ignition Maker Edition getting stuck when I am logging in?](https://forum.inductiveautomation.com/t/ignition-maker-edition-getting-stuck-when-i-am-logging-in/53313)
**Author:** [@tmahaf](https://forum.inductiveautomation.com/u/tmahaf)\ **Replies:** 1\ **Last updated:** [November 21, 2021, 3:30am UTC](https://forum.inductiveautomation.com/t/ignition-maker-edition-getting-stuck-when-i-am-logging-in/53313 "2021-11-21T03:30:21Z")
I’m not seeing anything in the logs - maybe someone can tell me what logging to turn to debug for this info? I have some port forwarding enabled so I can log into the perspective client through my dynamic dns. I can acc… --- ## [Virtual Key Pressend in Perspective](https://forum.inductiveautomation.com/t/virtual-key-pressend-in-perspective/53162)
**Author:** [@jespinmartin1](https://forum.inductiveautomation.com/u/jespinmartin1)\ **Replies:** 10\ **Last updated:** [November 20, 2021, 8:35pm UTC](https://forum.inductiveautomation.com/t/virtual-key-pressend-in-perspective/53162 "2021-11-20T20:35:05Z")
Is there a way to send a virtual key pressed in Perspective Session. Specifically “Ctrl”. The idea would be to select a checkbox as a virtual Ctrl --- ## [Perspective Flex Repeater - Add "spacing between instances" property](https://forum.inductiveautomation.com/t/perspective-flex-repeater-add-spacing-between-instances-property/52657)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 7\ **Last updated:** [November 20, 2021, 5:29pm UTC](https://forum.inductiveautomation.com/t/perspective-flex-repeater-add-spacing-between-instances-property/52657 "2021-11-20T17:29:01Z")
It’s very difficult to add spacing in between instances of a flex repeater without also adding a gap at the extremities against the bounding box. It would be great if there was a “spacing” prop that we could set to easil… --- ## [Ignition Min and Max Date From Dataset](https://forum.inductiveautomation.com/t/ignition-min-and-max-date-from-dataset/18499)
**Author:** [@john.keshecki](https://forum.inductiveautomation.com/u/john.keshecki)\ **Replies:** 9\ **Last updated:** [November 20, 2021, 2:26pm UTC](https://forum.inductiveautomation.com/t/ignition-min-and-max-date-from-dataset/18499 "2021-11-20T14:26:30Z")
Does anyone know an easy way to get the min and max date values from a dataset with multiple columns, one column is datetime? I'm using Ignition version 7.8.5. --- ## [Format Tag to Read 01 instead of 1](https://forum.inductiveautomation.com/t/format-tag-to-read-01-instead-of-1/53306)
**Author:** [@brandon222](https://forum.inductiveautomation.com/u/brandon222)\ **Replies:** 3\ **Last updated:** [November 20, 2021, 9:27am UTC](https://forum.inductiveautomation.com/t/format-tag-to-read-01-instead-of-1/53306 "2021-11-20T09:27:31Z")
Hi there, I have a tag which is a sec and another as a min. I have that binded into a multistate indicator so that I can read it together when a certain event happens. That all works great however when the second is say… --- ## [\[BUG-1287\] Edge tag provider missing](https://forum.inductiveautomation.com/t/bug-1287-edge-tag-provider-missing/20355)
**Author:** [@c-w-t](https://forum.inductiveautomation.com/u/c-w-t)\ **Replies:** 13\ **Last updated:** [November 20, 2021, 12:12am UTC](https://forum.inductiveautomation.com/t/bug-1287-edge-tag-provider-missing/20355 "2021-11-20T00:12:55Z")
I’ve installed an Edge Gateway that seems to be missing it’s default edge tag provider. I’m thinking it has to do with having restored a backup from another edge gateway, but can’t be sure. There are no settings in the… --- ## [Editing component/view properties using a text editor](https://forum.inductiveautomation.com/t/editing-component-view-properties-using-a-text-editor/53300)
**Author:** [@gdube](https://forum.inductiveautomation.com/u/gdube)\ **Replies:** 8\ **Last updated:** [November 19, 2021, 10:11pm UTC](https://forum.inductiveautomation.com/t/editing-component-view-properties-using-a-text-editor/53300 "2021-11-19T22:11:37Z")
Hi Devs, I’m coming from the world of traditional programmers (code), and I keep getting frustrated by various GUI issues while developing views. We can already export views, extract their zips, edit their json file, a… --- ## [Can't Open Project Window Due to Unsupported Component](https://forum.inductiveautomation.com/t/cant-open-project-window-due-to-unsupported-component/53301)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 4\ **Last updated:** [November 19, 2021, 9:13pm UTC](https://forum.inductiveautomation.com/t/cant-open-project-window-due-to-unsupported-component/53301 "2021-11-19T21:13:50Z")
I just installed Ignition 8.1.12 to test with, and I can’t open the main window for editing because it contains the Sepasoft Barcode Scanner component which isn’t supported by version 8. How can I remove the component … --- ## [Open Source Java](https://forum.inductiveautomation.com/t/open-source-java/53161)
**Author:** [@dturner](https://forum.inductiveautomation.com/u/dturner)\ **Replies:** 6\ **Last updated:** [November 19, 2021, 9:09pm UTC](https://forum.inductiveautomation.com/t/open-source-java/53161 "2021-11-19T21:09:13Z")
Does any documentation exist that shows how to remove Oracle’s Java and install Zulu or OpenJDK? I need to remove Oracle Java but do not know what all installing the other versions entails. I currently have Ignition ver… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=927) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=929)