# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=658 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 659 --- ## [\[bug: IGN-2719\] 8.1.5 - Reporting - Simple table visibility not working when using dynamic data key](https://forum.inductiveautomation.com/t/bug-ign-2719-8-1-5-reporting-simple-table-visibility-not-working-when-using-dynamic-data-key/47358)
**Author:** [@srb](https://forum.inductiveautomation.com/u/srb)\ **Replies:** 5\ **Last updated:** [April 27, 2023, 9:21pm UTC](https://forum.inductiveautomation.com/t/bug-ign-2719-8-1-5-reporting-simple-table-visibility-not-working-when-using-dynamic-data-key/47358 "2023-04-27T21:21:10Z")
Hi, I’m having an issue with Simple table not hiding. I’m using the same data key to hide time series chart and other objects which seem to work fine. In the below example, the rectangle hides when I don’t select a filt… --- ## [Freeopcua library having issues with overloaded ignition opcua server](https://forum.inductiveautomation.com/t/freeopcua-library-having-issues-with-overloaded-ignition-opcua-server/72987)
**Author:** [@codersmurf](https://forum.inductiveautomation.com/u/codersmurf)\ **Replies:** 8\ **Last updated:** [April 27, 2023, 9:19pm UTC](https://forum.inductiveautomation.com/t/freeopcua-library-having-issues-with-overloaded-ignition-opcua-server/72987 "2023-04-27T21:19:35Z")
So I have an app I wrote using freeopcua. It's been working fine for years. We know our server is extremely overloaded and working to scale out. The app now is getting no replies back from the server when trying to tr… --- ## [Using checkbox to resize Graph and Make Table Disappear using Flex Container](https://forum.inductiveautomation.com/t/using-checkbox-to-resize-graph-and-make-table-disappear-using-flex-container/72996)
**Author:** [@Cesar\_Jimenez](https://forum.inductiveautomation.com/u/Cesar_Jimenez)\ **Replies:** 2\ **Last updated:** [April 27, 2023, 8:32pm UTC](https://forum.inductiveautomation.com/t/using-checkbox-to-resize-graph-and-make-table-disappear-using-flex-container/72996 "2023-04-27T20:32:28Z")
Hello Everyone! I am new to the python/perspective world and need a tad bit of help. As by the title of my topic, I am trying to enlarge a graph and make a table invisible whenever a checkbox is selected giving the grap… --- ## [MinMax not consistent with queryTagHistory](https://forum.inductiveautomation.com/t/minmax-not-consistent-with-querytaghistory/72984)
**Author:** [@Shawn\_Rieger](https://forum.inductiveautomation.com/u/Shawn_Rieger)\ **Replies:** 2\ **Last updated:** [April 27, 2023, 8:17pm UTC](https://forum.inductiveautomation.com/t/minmax-not-consistent-with-querytaghistory/72984 "2023-04-27T20:17:13Z")
When I make a request using queryTagHistory and set aggregation mode to MinMax, the order or min and max are not consistent. As you can see in the export below, in some timestamps the Max value is first, in others Min i… --- ## [Diagnostic Page Vision](https://forum.inductiveautomation.com/t/diagnostic-page-vision/72982)
**Author:** [@gpellicelli](https://forum.inductiveautomation.com/u/gpellicelli)\ **Replies:** 2\ **Last updated:** [April 27, 2023, 7:40pm UTC](https://forum.inductiveautomation.com/t/diagnostic-page-vision/72982 "2023-04-27T19:40:05Z")
Hello, My client wants a direct diagnostic page on the Scada. I did everything I thought was going to help, but now it's asking for 3 more statuses on storage and transfer (Total Quarantined, Total Dropped, and Aggregat… --- ## [Error with custom method call from context menu](https://forum.inductiveautomation.com/t/error-with-custom-method-call-from-context-menu/72908)
**Author:** [@Matthias\_Wuest](https://forum.inductiveautomation.com/u/Matthias_Wuest)\ **Replies:** 3\ **Last updated:** [April 27, 2023, 7:30pm UTC](https://forum.inductiveautomation.com/t/error-with-custom-method-call-from-context-menu/72908 "2023-04-27T19:30:07Z")
I have a button component to perform different actions using the context menu, but have encountered a problem with calling custom methods on the same component. Editor version is 8.1.25 (b2023021409) To open the menu on… --- ## [Advice on a Generalized view](https://forum.inductiveautomation.com/t/advice-on-a-generalized-view/72976)
**Author:** [@Gabriel\_Schwinghamme](https://forum.inductiveautomation.com/u/Gabriel_Schwinghamme)\ **Replies:** 2\ **Last updated:** [April 27, 2023, 5:40pm UTC](https://forum.inductiveautomation.com/t/advice-on-a-generalized-view/72976 "2023-04-27T17:40:26Z")
Hello, Is there a way to make a view that is generalized for many different devices where (assuming all other tag names are the same) you can input the device name on an event and have the view pop up and be used for th… --- ## [Query Database based on date instead of t\_stamp in Ignition Tag Historian database](https://forum.inductiveautomation.com/t/query-database-based-on-date-instead-of-t-stamp-in-ignition-tag-historian-database/72894)
**Author:** [@Babla\_Bogam](https://forum.inductiveautomation.com/u/Babla_Bogam)\ **Replies:** 3\ **Last updated:** [April 27, 2023, 4:12pm UTC](https://forum.inductiveautomation.com/t/query-database-based-on-date-instead-of-t-stamp-in-ignition-tag-historian-database/72894 "2023-04-27T16:12:05Z")
Hello, I wanted to write a sql query (Microsoft Sql Server) against the Ignition Tag Historian database and Table sqlt\_data\_X\_2023\_XX. The table has the tag values and t\_stamp (which is milliseconds). How can I query bas… --- ## [Sqlt\_data\_x\_x\_x Table Keep Changing of Name Making Sql Querry Invalid](https://forum.inductiveautomation.com/t/sqlt-data-x-x-x-table-keep-changing-of-name-making-sql-querry-invalid/72975)
**Author:** [@Emile\_Laplante](https://forum.inductiveautomation.com/u/Emile_Laplante)\ **Replies:** 1\ **Last updated:** [April 27, 2023, 3:52pm UTC](https://forum.inductiveautomation.com/t/sqlt-data-x-x-x-table-keep-changing-of-name-making-sql-querry-invalid/72975 "2023-04-27T15:52:10Z")
Hi, I plot tag history on charts in vision. I use a sql querry to check if there is data in the data base to show or not the graph. There is the sql querry : SELECT COUNT(\*) as test FROM sqlt\_data\_1\_2023\_04 But it … --- ## [Get database name (or schema) from a db connection](https://forum.inductiveautomation.com/t/get-database-name-or-schema-from-a-db-connection/72966)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 10\ **Last updated:** [April 27, 2023, 3:40pm UTC](https://forum.inductiveautomation.com/t/get-database-name-or-schema-from-a-db-connection/72966 "2023-04-27T15:40:36Z")
is there a simple way by scripting to get database name (or schema) from a db connection perhaps getDatabaseProductName() from the JDBC underlying connection ? --- ## [Inverter Simulator](https://forum.inductiveautomation.com/t/inverter-simulator/72973)
**Author:** [@msrobin](https://forum.inductiveautomation.com/u/msrobin)\ **Replies:** 1\ **Last updated:** [April 27, 2023, 3:39pm UTC](https://forum.inductiveautomation.com/t/inverter-simulator/72973 "2023-04-27T15:39:56Z")
Has anyone developed a Simulator for inverters such as a PV inverter? Trying to do some testing so I am looking at building one but wanted to see if anyone had already developed one first. I searched the forum but can'… --- ## [Standard Deviation Bug/Error?](https://forum.inductiveautomation.com/t/standard-deviation-bug-error/72974)
**Author:** [@Skylar\_Sabo](https://forum.inductiveautomation.com/u/Skylar_Sabo)\ **Replies:** 3\ **Last updated:** [April 27, 2023, 3:32pm UTC](https://forum.inductiveautomation.com/t/standard-deviation-bug-error/72974 "2023-04-27T15:32:40Z")
Hello Ignition Forums, Not sure what's going on here but trying to calculate the standard deviation of a column of numbers from our db. In this case, we are returned with this All the numbers that the standard deviat… --- ## [SQL DB Licensng?](https://forum.inductiveautomation.com/t/sql-db-licensng/72972)
**Author:** [@Lei\_Qu](https://forum.inductiveautomation.com/u/Lei_Qu)\ **Replies:** 1\ **Last updated:** [April 27, 2023, 3:12pm UTC](https://forum.inductiveautomation.com/t/sql-db-licensng/72972 "2023-04-27T15:12:42Z")
Dear experts, I just installed the license keys for my Ignition servers. I found that my SQL DB connection is broken after the license activation. Do I need a license for SQL DB connection? Thanks. Lei --- ## [Perspective struggle with 3 dependent dropdowns](https://forum.inductiveautomation.com/t/perspective-struggle-with-3-dependent-dropdowns/72962)
**Author:** [@hewking32](https://forum.inductiveautomation.com/u/hewking32)\ **Replies:** 6\ **Last updated:** [April 27, 2023, 3:04pm UTC](https://forum.inductiveautomation.com/t/perspective-struggle-with-3-dependent-dropdowns/72962 "2023-04-27T15:04:37Z")
Hi All I would like to have 3 dependent dropdowns ie. first dropdown allows selection from the dataset from the db, then second dropdown filters further based on selection from the first dropdown - same applies to dropd… --- ## [Ignition 7.9.21 and Java 1.8.0\_201 Database Connection](https://forum.inductiveautomation.com/t/ignition-7-9-21-and-java-1-8-0-201-database-connection/72577)
**Author:** [@jdelgado](https://forum.inductiveautomation.com/u/jdelgado)\ **Replies:** 4\ **Last updated:** [April 27, 2023, 3:01pm UTC](https://forum.inductiveautomation.com/t/ignition-7-9-21-and-java-1-8-0-201-database-connection/72577 "2023-04-27T15:01:35Z")
Hi Guys, I know this issue might be related to the TLS but I search the forum and I cannot find the java.security file on the Ignition install folder maybe someone can point me to the solutions. I also added the trustS… --- ## [Redundancy Backup with Database Faulted](https://forum.inductiveautomation.com/t/redundancy-backup-with-database-faulted/72035)
**Author:** [@paull](https://forum.inductiveautomation.com/u/paull)\ **Replies:** 1\ **Last updated:** [April 27, 2023, 2:26pm UTC](https://forum.inductiveautomation.com/t/redundancy-backup-with-database-faulted/72035 "2023-04-27T14:26:54Z")
Ran into a situation that left us stuck. One of our sites had a hard drive failure on the Master Ignition Server. It transferred everything over to backup without issue. While working to troubleshoot, we had to reboot t… --- ## [Power table not catching right click in onMousePressed?](https://forum.inductiveautomation.com/t/power-table-not-catching-right-click-in-onmousepressed/72963)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 9\ **Last updated:** [April 27, 2023, 1:42pm UTC](https://forum.inductiveautomation.com/t/power-table-not-catching-right-click-in-onmousepressed/72963 "2023-04-27T13:42:06Z")
I have a power table that a user wants to be able to double right click on a cell to trigger opening up a window related to the record. Right now I can't seem to catch the right click at all, but left clicks come throug… --- ## [Launch Perspective session using System username and password](https://forum.inductiveautomation.com/t/launch-perspective-session-using-system-username-and-password/72956)
**Author:** [@kavya\_shree](https://forum.inductiveautomation.com/u/kavya_shree)\ **Replies:** 3\ **Last updated:** [April 27, 2023, 1:14pm UTC](https://forum.inductiveautomation.com/t/launch-perspective-session-using-system-username-and-password/72956 "2023-04-27T13:14:03Z")
Hi Team, I am working on Perspective mode. My requirement is when I launch the session I want to enter the system login user name and system password. I don't to enter Ignition user name and password. I tried with Iden… --- ## [Siemens S7 PLCs and PLC OPC UA Server](https://forum.inductiveautomation.com/t/siemens-s7-plcs-and-plc-opc-ua-server/72886)
**Author:** [@Shea\_Molthen](https://forum.inductiveautomation.com/u/Shea_Molthen)\ **Replies:** 4\ **Last updated:** [April 27, 2023, 12:58pm UTC](https://forum.inductiveautomation.com/t/siemens-s7-plcs-and-plc-opc-ua-server/72886 "2023-04-27T12:58:20Z")
I've done quite a bit of digging and still coming up short. In the PLC, I have Function Blocks and the instances create Instance Data Blocks. Each IDB consists of ~50 tags. In Ignition, my path would look : \[PLC\_3\]nsu=… --- ## [Help with Teams notification](https://forum.inductiveautomation.com/t/help-with-teams-notification/66695)
**Author:** [@Jamie\_Dukelow](https://forum.inductiveautomation.com/u/Jamie_Dukelow)\ **Replies:** 11\ **Last updated:** [April 27, 2023, 12:56pm UTC](https://forum.inductiveautomation.com/t/help-with-teams-notification/66695 "2023-04-27T12:56:10Z")
I have attempted to set up a button in Ignition to test out sending a message to MS Teams. I followed the example here Sending Ignition notifications to Microsoft Teams. I am not a programmer, so I got stuck at the par… --- ## [Full Windows AD Setup](https://forum.inductiveautomation.com/t/full-windows-ad-setup/72246)
**Author:** [@Christianto\_Hermawan](https://forum.inductiveautomation.com/u/Christianto_Hermawan)\ **Replies:** 2\ **Last updated:** [April 27, 2023, 12:29pm UTC](https://forum.inductiveautomation.com/t/full-windows-ad-setup/72246 "2023-04-27T12:29:05Z")
Hi Team, We're using Ignition 8.1 and new into this. We're trying to connect our Ignition to our Windows Active Directory for user & role management. We can get all user for specific AD Groups and its Group name as ou… --- ## [Help setting dynamic plot marker color](https://forum.inductiveautomation.com/t/help-setting-dynamic-plot-marker-color/72884)
**Author:** [@Isabela\_Babcock](https://forum.inductiveautomation.com/u/Isabela_Babcock)\ **Replies:** 6\ **Last updated:** [April 27, 2023, 11:35am UTC](https://forum.inductiveautomation.com/t/help-setting-dynamic-plot-marker-color/72884 "2023-04-27T11:35:18Z")
Hello, I am new to Designer and looking to have a scatter plot chart with different color markers based on a specific value. Consider dataset d1: Currently, it returns two values: a timestamp and a reading value Thos… --- ## [Displaying large number of rows in Perspective Table](https://forum.inductiveautomation.com/t/displaying-large-number-of-rows-in-perspective-table/72952)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 1\ **Last updated:** [April 27, 2023, 6:24am UTC](https://forum.inductiveautomation.com/t/displaying-large-number-of-rows-in-perspective-table/72952 "2023-04-27T06:24:16Z")
I need to display ~10,000 rows in a table in a Perspective Table. Every time I try to however, the page crashes... I have props.virtualised set to true. Is there actually anything I can do to resolve this...? other than… --- ## [Dropdown return value](https://forum.inductiveautomation.com/t/dropdown-return-value/72910)
**Author:** [@saravanan\_Manickam](https://forum.inductiveautomation.com/u/saravanan_Manickam)\ **Replies:** 2\ **Last updated:** [April 27, 2023, 5:22am UTC](https://forum.inductiveautomation.com/t/dropdown-return-value/72910 "2023-04-27T05:22:15Z")
Here I have a dropdown for that data I have fetch from the database so the output is dataset....for that I have converted into label and value by script on transform while rederiving the data I the label data do… --- ## [\[BUG-6567\]8.1.20 Bug with Numeric Entry Field on iPad](https://forum.inductiveautomation.com/t/bug-6567-8-1-20-bug-with-numeric-entry-field-on-ipad/63568)
**Author:** [@danieltalbot](https://forum.inductiveautomation.com/u/danieltalbot)\ **Replies:** 5\ **Last updated:** [April 27, 2023, 2:04am UTC](https://forum.inductiveautomation.com/t/bug-6567-8-1-20-bug-with-numeric-entry-field-on-ipad/63568 "2023-04-27T02:04:58Z")
Giving focus to a numeric entry field doesn’t open the onscreen keyboard in Ignition 8.1.20 UNLESS the spinner is enabled. Tried in Safari and in the Perspective app. Using iPadOS 15.6.1 --- ## [Client Launchers List View Preference](https://forum.inductiveautomation.com/t/client-launchers-list-view-preference/41774)
**Author:** [@ryanjmclaughlin](https://forum.inductiveautomation.com/u/ryanjmclaughlin)\ **Replies:** 4\ **Last updated:** [April 26, 2023, 11:25pm UTC](https://forum.inductiveautomation.com/t/client-launchers-list-view-preference/41774 "2023-04-26T23:25:01Z")
I like the new “list” view in the Designer/Vision launchers. It works much better for us with a lot of entries. However, I’m finding there is no preference tied to it and it does not persist across launches… something… --- ## [Custom parameter UDT Vision Designer](https://forum.inductiveautomation.com/t/custom-parameter-udt-vision-designer/72926)
**Author:** [@rfolkes](https://forum.inductiveautomation.com/u/rfolkes)\ **Replies:** 2\ **Last updated:** [April 26, 2023, 10:27pm UTC](https://forum.inductiveautomation.com/t/custom-parameter-udt-vision-designer/72926 "2023-04-26T22:27:13Z")
Ignition 8.x Vision - I have a popup window with a UDT as a custom property. Everything working as it should in client, but I haven't been able to figure out how to get it to link while in the designer. With other c… --- ## [queryTagHistory returning 0 for timestamps with "On Change" setting](https://forum.inductiveautomation.com/t/querytaghistory-returning-0-for-timestamps-with-on-change-setting/51925)
**Author:** [@user6](https://forum.inductiveautomation.com/u/user6)\ **Replies:** 3\ **Last updated:** [April 26, 2023, 9:53pm UTC](https://forum.inductiveautomation.com/t/querytaghistory-returning-0-for-timestamps-with-on-change-setting/51925 "2023-04-26T21:53:01Z")
I have some tags that are being logged with the “On Change” sampling mode with a minimum sample time of 1s. As we would need the data for each tag at every second, the tag history was pulled into a CSV file with the use … --- ## [Mobile Finger UI](https://forum.inductiveautomation.com/t/mobile-finger-ui/72605)
**Author:** [@Dan\_Mor](https://forum.inductiveautomation.com/u/Dan_Mor)\ **Replies:** 2\ **Last updated:** [April 26, 2023, 9:29pm UTC](https://forum.inductiveautomation.com/t/mobile-finger-ui/72605 "2023-04-26T21:29:53Z")
Hi, does ignition 7.9.3 vision has a option for mobile clients where you can scroll and move around with your finger instead of the uncomfortable side bars? Thanks in advanced, Best regards, Daniel --- ## [Make a window pop-up after pressing a button for X seconds](https://forum.inductiveautomation.com/t/make-a-window-pop-up-after-pressing-a-button-for-x-seconds/72696)
**Author:** [@Eneko\_Suarez](https://forum.inductiveautomation.com/u/Eneko_Suarez)\ **Replies:** 3\ **Last updated:** [April 26, 2023, 9:03pm UTC](https://forum.inductiveautomation.com/t/make-a-window-pop-up-after-pressing-a-button-for-x-seconds/72696 "2023-04-26T21:03:48Z")
We are designing a front on Ignition Vision and we would like to make the user press the button for X seconds to enter the settings window. How could we make it? Thanks. [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=657) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=659)