# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=661 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 662 --- ## [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. --- ## [system.tag.writeBlocking in Ignition Edge](https://forum.inductiveautomation.com/t/system-tag-writeblocking-in-ignition-edge/72809)
**Author:** [@Chris.Wyllie](https://forum.inductiveautomation.com/u/Chris.Wyllie)\ **Replies:** 11\ **Last updated:** [April 26, 2023, 8:43pm UTC](https://forum.inductiveautomation.com/t/system-tag-writeblocking-in-ignition-edge/72809 "2023-04-26T20:43:33Z")
Hi Guys, This is an Ignition Edge 8.1 with Perspective version 8.1.25 (b2023021409). I found out the hard way that in Edge systems all gateway and tag scoped scripting is disabled, but all client scoped scripting shoul… --- ## [Latest build broke the Project Comm Read/Write](https://forum.inductiveautomation.com/t/latest-build-broke-the-project-comm-read-write/63360)
**Author:** [@codersmurf](https://forum.inductiveautomation.com/u/codersmurf)\ **Replies:** 5\ **Last updated:** [April 26, 2023, 6:17pm UTC](https://forum.inductiveautomation.com/t/latest-build-broke-the-project-comm-read-write/63360 "2023-04-26T18:17:11Z")
8.1.19 ignores the Project Comm settings. I used to be able to run scripts to write to tags that were normally read only changing this setting, now I have to do all these changes by hand. --- ## [Another "Ignition service won't start" problem](https://forum.inductiveautomation.com/t/another-ignition-service-wont-start-problem/72876)
**Author:** [@Glenn\_Ziolkowski](https://forum.inductiveautomation.com/u/Glenn_Ziolkowski)\ **Replies:** 12\ **Last updated:** [April 26, 2023, 5:33pm UTC](https://forum.inductiveautomation.com/t/another-ignition-service-wont-start-problem/72876 "2023-04-26T17:33:07Z")
Version 8.1.20 on Windows Server 2022 Standard. Service is set for Automatic start. Delayed start doesn't help. Not sure where to go next. Wrapper.log snip attached. wrapper\_log\_042523.txt (32.8 KB) --- ## [Script to change the gateway device connection timeout](https://forum.inductiveautomation.com/t/script-to-change-the-gateway-device-connection-timeout/72929)
**Author:** [@codersmurf](https://forum.inductiveautomation.com/u/codersmurf)\ **Replies:** 7\ **Last updated:** [April 26, 2023, 4:57pm UTC](https://forum.inductiveautomation.com/t/script-to-change-the-gateway-device-connection-timeout/72929 "2023-04-26T16:57:14Z")
So our gateway is heavily overloaded. We were using a timeout of 60 seconds to each plc. I did a test and found out a 4 minute timeout fixed the issue. Now the problem is changing each of the thousands of devices with… --- ## [Store and Forward with SQL Bridge at Remote Location](https://forum.inductiveautomation.com/t/store-and-forward-with-sql-bridge-at-remote-location/72933)
**Author:** [@Jeremiah\_Brown1](https://forum.inductiveautomation.com/u/Jeremiah_Brown1)\ **Replies:** 1\ **Last updated:** [April 26, 2023, 4:25pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-with-sql-bridge-at-remote-location/72933 "2023-04-26T16:25:28Z")
Hello, I'm trying to figure out the best solution to store and forward SQL data at a remote site. The current system setup looks like this. Central site - Ignition Gateway with SQL bridge with transaction group pushing… --- ## [Visible chart according to dropdown selection in reports](https://forum.inductiveautomation.com/t/visible-chart-according-to-dropdown-selection-in-reports/72909)
**Author:** [@aman\_sharma](https://forum.inductiveautomation.com/u/aman_sharma)\ **Replies:** 1\ **Last updated:** [April 26, 2023, 3:18pm UTC](https://forum.inductiveautomation.com/t/visible-chart-according-to-dropdown-selection-in-reports/72909 "2023-04-26T15:18:13Z")
hi, i am creating a report which consist 3 charts(XY Chart, Bar chart). i have a dropdown in my window. i want to visible the chart as per dropdown selection. means when i select X bar chart in dropdown it must onl… --- ## [\[Feature-11590\] System.perspective.navigate() Lacks Option To Open New Tab](https://forum.inductiveautomation.com/t/feature-11590-system-perspective-navigate-lacks-option-to-open-new-tab/31636)
**Author:** [@pdellova](https://forum.inductiveautomation.com/u/pdellova)\ **Replies:** 9\ **Last updated:** [April 26, 2023, 3:14pm UTC](https://forum.inductiveautomation.com/t/feature-11590-system-perspective-navigate-lacks-option-to-open-new-tab/31636 "2023-04-26T15:14:55Z")
Hi, Is there a way to use the function system.perspective.navigate() to open a view in a new tab? documentation does not show the parameter to do this we try to search it in the JSON code of a view with a button event… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=660) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=662)