# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1048 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1049 --- ## [Database Faulted](https://forum.inductiveautomation.com/t/database-faulted/44474)
**Author:** [@jd1](https://forum.inductiveautomation.com/u/jd1)\ **Replies:** 0\ **Last updated:** [March 15, 2021, 3:40pm UTC](https://forum.inductiveautomation.com/t/database-faulted/44474 "2021-03-15T15:40:50Z")
Over the weekend our clients IT department updated the SQL server that we use for ignition. When I came in this morning I got the following error “The connection to the host {server name}, named instance {server name} f… --- ## [Confused about Quick Start navigation scheme](https://forum.inductiveautomation.com/t/confused-about-quick-start-navigation-scheme/44452)
**Author:** [@peter](https://forum.inductiveautomation.com/u/peter)\ **Replies:** 3\ **Last updated:** [March 15, 2021, 2:05pm UTC](https://forum.inductiveautomation.com/t/confused-about-quick-start-navigation-scheme/44452 "2021-03-15T14:05:32Z")
I’m trying to follow the logic in the navigations scheme for the “Ignition-101” page of the Quick Start project. I’m missing something, and I’m sure its simple. The navigation section view is located at: /ignition-101… --- ## [Easy chart error (mode Mark)](https://forum.inductiveautomation.com/t/easy-chart-error-mode-mark/44462)
**Author:** [@lachguerabdallah](https://forum.inductiveautomation.com/u/lachguerabdallah)\ **Replies:** 2\ **Last updated:** [March 15, 2021, 1:43pm UTC](https://forum.inductiveautomation.com/t/easy-chart-error-mode-mark/44462 "2021-03-15T13:43:43Z")
I have a weird problem with the easy chart component, when I put it in mark mode, the thoughts appear with thwith the same name always --- ## [Sqlt\_data {variable} t\_stamp](https://forum.inductiveautomation.com/t/sqlt-data-variable-t-stamp/44397)
**Author:** [@OscarLucas](https://forum.inductiveautomation.com/u/OscarLucas)\ **Replies:** 8\ **Last updated:** [March 15, 2021, 12:54pm UTC](https://forum.inductiveautomation.com/t/sqlt-data-variable-t-stamp/44397 "2021-03-15T12:54:50Z")
Hello, how can I make a query that search in all registers? Should i make a variable for year and month? --- ## [Filtering Time range in SQL Query](https://forum.inductiveautomation.com/t/filtering-time-range-in-sql-query/44395)
**Author:** [@OscarLucas](https://forum.inductiveautomation.com/u/OscarLucas)\ **Replies:** 3\ **Last updated:** [March 15, 2021, 6:48am UTC](https://forum.inductiveautomation.com/t/filtering-time-range-in-sql-query/44395 "2021-03-15T06:48:33Z")
Hello I would like to filter the data in a period of time. I suppose that the failure is coming from the dateFormat i try dateFormat(toDate( "2003-9-14 8:00:00" ), "yyyy-MM-dd 00:00:00" ) but it dosent work. --- ## [Message from Flex Repeater view is reaching message handler before the parameter binding](https://forum.inductiveautomation.com/t/message-from-flex-repeater-view-is-reaching-message-handler-before-the-parameter-binding/44448)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 3\ **Last updated:** [March 15, 2021, 3:44am UTC](https://forum.inductiveautomation.com/t/message-from-flex-repeater-view-is-reaching-message-handler-before-the-parameter-binding/44448 "2021-03-15T03:44:58Z")
I have a Flex Repeater component with each view consisting of a Checkbox component. Flex repeater \[ \] Option 1 \[x\] Option 2 \[x\] Option 3 \[ \] Option 4 The Checkbox view has a bi-directional binding to th… --- ## [What are "array eval" key in boolean array UDTs?](https://forum.inductiveautomation.com/t/what-are-array-eval-key-in-boolean-array-udts/44454)
**Author:** [@bradley.falzon](https://forum.inductiveautomation.com/u/bradley.falzon)\ **Replies:** 0\ **Last updated:** [March 15, 2021, 2:53am UTC](https://forum.inductiveautomation.com/t/what-are-array-eval-key-in-boolean-array-udts/44454 "2021-03-15T02:53:42Z")
I’ve just created a UDT to store some of our PLC alarm status flags which are just integers with each bit referencing a different alarm. I’ve imported these paths as Boolean Array and can manipulate it relatively OK. B… --- ## [Ignition 8.1.2: SSL Certificates Installation](https://forum.inductiveautomation.com/t/ignition-8-1-2-ssl-certificates-installation/44449)
**Author:** [@mudbay](https://forum.inductiveautomation.com/u/mudbay)\ **Replies:** 0\ **Last updated:** [March 14, 2021, 10:03pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-2-ssl-certificates-installation/44449 "2021-03-14T22:03:12Z")
Hoping the community may be able to provide some experience with SSL Certificates in Ignition Gateway and tell me what I have overlooked in my workflow. Full disclosure, I am not an expert of SSL Certificates and attemp… --- ## [Trouble creating database connection w/ Ignition v7.3.9](https://forum.inductiveautomation.com/t/trouble-creating-database-connection-w-ignition-v7-3-9/44444)
**Author:** [@jpdoyle](https://forum.inductiveautomation.com/u/jpdoyle)\ **Replies:** 15\ **Last updated:** [March 14, 2021, 8:55pm UTC](https://forum.inductiveautomation.com/t/trouble-creating-database-connection-w-ignition-v7-3-9/44444 "2021-03-14T20:55:02Z")
Hoping someone can help. I’ve been trying to restore my client’s Ignition instance for the last couple days. It is version 7.3.9 and is running on Windows Server 2016. The database is MS SQL Express. I have worked throug… --- ## [Easy Chart - Unit Conversion on Tag History](https://forum.inductiveautomation.com/t/easy-chart-unit-conversion-on-tag-history/44419)
**Author:** [@BryanB](https://forum.inductiveautomation.com/u/BryanB)\ **Replies:** 8\ **Last updated:** [March 14, 2021, 4:08pm UTC](https://forum.inductiveautomation.com/t/easy-chart-unit-conversion-on-tag-history/44419 "2021-03-14T16:08:42Z")
I’m seeing if it is possible to trend different units using an Easy Chart. For example, I have a tag (pressure in ‘psi’) that is stored in the historian. I have a request to be able to display the trend history in other … --- ## [Unstable data from to ControlLogix](https://forum.inductiveautomation.com/t/unstable-data-from-to-controllogix/44440)
**Author:** [@michael.mccabe](https://forum.inductiveautomation.com/u/michael.mccabe)\ **Replies:** 4\ **Last updated:** [March 14, 2021, 1:07pm UTC](https://forum.inductiveautomation.com/t/unstable-data-from-to-controllogix/44440 "2021-03-14T13:07:55Z")
Hi folks, Currently have a project where I am reading Boolean values from a PLC to ignition and based alarms on there states. Using ignition 8.1.1 I am trying to poll these at 200ms but have tested by pushing out to 1… --- ## [Display values above bars on XY chart in Perspective?](https://forum.inductiveautomation.com/t/display-values-above-bars-on-xy-chart-in-perspective/26399)
**Author:** [@Joseph.Gardner](https://forum.inductiveautomation.com/u/Joseph.Gardner)\ **Replies:** 2\ **Last updated:** [March 13, 2021, 9:27am UTC](https://forum.inductiveautomation.com/t/display-values-above-bars-on-xy-chart-in-perspective/26399 "2021-03-13T09:27:22Z")
I can not seem to find a way to display the exact values above the bars on an XY chart. Is this not a feature yet in Perspective? As far as I know, this is possible in Vision. --- ## [Format date time text for x-axis on XY Chart](https://forum.inductiveautomation.com/t/format-date-time-text-for-x-axis-on-xy-chart/44430)
**Author:** [@alex.narvais](https://forum.inductiveautomation.com/u/alex.narvais)\ **Replies:** 0\ **Last updated:** [March 13, 2021, 1:21am UTC](https://forum.inductiveautomation.com/t/format-date-time-text-for-x-axis-on-xy-chart/44430 "2021-03-13T01:21:43Z")
How can I format the date time text on the xy-chart, because I’m having overlapping issues between the date and time. The format I’m using is “M/d/yyyy HH:mm:ss” and I’d like to stick with this format. Adding some type … --- ## [Automatically Updating Web Dev](https://forum.inductiveautomation.com/t/automatically-updating-web-dev/44407)
**Author:** [@kghali](https://forum.inductiveautomation.com/u/kghali)\ **Replies:** 16\ **Last updated:** [March 12, 2021, 9:33pm UTC](https://forum.inductiveautomation.com/t/automatically-updating-web-dev/44407 "2021-03-12T21:33:12Z")
Hello, I am using the Reports module to update a pdf report every hour. I am also using a Perspective page with a button to open the pdf file which is stored in the Web Dev module. I want the Web Dev to update the file … --- ## [Perspective table query](https://forum.inductiveautomation.com/t/perspective-table-query/44423)
**Author:** [@suryawanshinr2011](https://forum.inductiveautomation.com/u/suryawanshinr2011)\ **Replies:** 2\ **Last updated:** [March 12, 2021, 7:15pm UTC](https://forum.inductiveautomation.com/t/perspective-table-query/44423 "2021-03-12T19:15:24Z")
I am using perspective table, in that table i assigned named query, which is one of the sql database table, which has a records. in that table there are two timestamps columns called as “In\_time” and “Out\_time” table wo… --- ## [Row selector mouseClicked Scripting Issue](https://forum.inductiveautomation.com/t/row-selector-mouseclicked-scripting-issue/11412)
**Author:** [@Kstofcho](https://forum.inductiveautomation.com/u/Kstofcho)\ **Replies:** 1\ **Last updated:** [March 12, 2021, 7:04pm UTC](https://forum.inductiveautomation.com/t/row-selector-mouseclicked-scripting-issue/11412 "2021-03-12T19:04:56Z")
Hello, I am attempting to use the mouseClicked event handler within scripting on the row selector component. Initially, it appeared to never run the script. Turns out, it only runs if you click in the border (see thick r… --- ## [Will creating multiple Database connections allow me to configure multiple Tag Historian Pruning options?](https://forum.inductiveautomation.com/t/will-creating-multiple-database-connections-allow-me-to-configure-multiple-tag-historian-pruning-options/44410)
**Author:** [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Replies:** 9\ **Last updated:** [March 12, 2021, 7:02pm UTC](https://forum.inductiveautomation.com/t/will-creating-multiple-database-connections-allow-me-to-configure-multiple-tag-historian-pruning-options/44410 "2021-03-12T19:02:55Z")
I have created 2 database connections to my database SQLEXPRESS. By default this creates two Tag Historian connections also. I can configure one of the Historians to prune data after 3 months and the other historian to n… --- ## [Paintable Canvas Question](https://forum.inductiveautomation.com/t/paintable-canvas-question/44421)
**Author:** [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\ **Replies:** 2\ **Last updated:** [March 12, 2021, 6:59pm UTC](https://forum.inductiveautomation.com/t/paintable-canvas-question/44421 "2021-03-12T18:59:32Z")
We have some graphics that are generated through the paintable canvas, and I want to be able to respond to a click event when the user clicks on what has been painted in the canvas. Basically I’m creating a rectangle an… --- ## [Grid option for Time Series Chart and time picker for range for Time Series Chart in Perspective](https://forum.inductiveautomation.com/t/grid-option-for-time-series-chart-and-time-picker-for-range-for-time-series-chart-in-perspective/44420)
**Author:** [@tadeja.saje](https://forum.inductiveautomation.com/u/tadeja.saje)\ **Replies:** 0\ **Last updated:** [March 12, 2021, 6:17pm UTC](https://forum.inductiveautomation.com/t/grid-option-for-time-series-chart-and-time-picker-for-range-for-time-series-chart-in-perspective/44420 "2021-03-12T18:17:10Z")
Hello! Is available xy grid option for Time Series Chart in Perspective Ignition? Is possible make script to have date picker for range for Time Series Chart in Perspective. For our users is more practical date picker… --- ## [Expression Script to check animate box in style customizer](https://forum.inductiveautomation.com/t/expression-script-to-check-animate-box-in-style-customizer/44413)
**Author:** [@david.smith](https://forum.inductiveautomation.com/u/david.smith)\ **Replies:** 9\ **Last updated:** [March 12, 2021, 6:23pm UTC](https://forum.inductiveautomation.com/t/expression-script-to-check-animate-box-in-style-customizer/44413 "2021-03-12T18:23:40Z")
Is there some way to be able to check the animate check box in the style customizer via a script? --- ## [Publish Service Error](https://forum.inductiveautomation.com/t/publish-service-error/44418)
**Author:** [@ryanastiefes](https://forum.inductiveautomation.com/u/ryanastiefes)\ **Replies:** 1\ **Last updated:** [March 12, 2021, 5:37pm UTC](https://forum.inductiveautomation.com/t/publish-service-error/44418 "2021-03-12T17:37:09Z")
Ignition 7.7.10 Current Console Errors: WARN 9:30:34 AM PublishService Returning ServiceFault for request: \[PublishRequest requestHandle=74871032\]. StatusCode=StatusCode\[Severity=Bad, Subcode=Bad\_NoSubscription\] … --- ## [Component Creation](https://forum.inductiveautomation.com/t/component-creation/44403)
**Author:** [@hossam.abdalrahman](https://forum.inductiveautomation.com/u/hossam.abdalrahman)\ **Replies:** 9\ **Last updated:** [March 12, 2021, 5:32pm UTC](https://forum.inductiveautomation.com/t/component-creation/44403 "2021-03-12T17:32:21Z")
Hello, Is there a way to create a new component in a window using scripting ? Thanks --- ## [SQL Server Partial Resultset](https://forum.inductiveautomation.com/t/sql-server-partial-resultset/44408)
**Author:** [@adnaram](https://forum.inductiveautomation.com/u/adnaram)\ **Replies:** 2\ **Last updated:** [March 12, 2021, 5:30pm UTC](https://forum.inductiveautomation.com/t/sql-server-partial-resultset/44408 "2021-03-12T17:30:25Z")
Hi, We use microsoft SQL server and ignition 7.9.17. We have a stored procedure that return immediately a partial resultset and the complete result a few seconds later. There is an example below. I use system.db.runQue… --- ## [How to identify number of users on X view in the browser at a time](https://forum.inductiveautomation.com/t/how-to-identify-number-of-users-on-x-view-in-the-browser-at-a-time/44417)
**Author:** [@retinder.labana](https://forum.inductiveautomation.com/u/retinder.labana)\ **Replies:** 0\ **Last updated:** [March 12, 2021, 5:30pm UTC](https://forum.inductiveautomation.com/t/how-to-identify-number-of-users-on-x-view-in-the-browser-at-a-time/44417 "2021-03-12T17:30:17Z")
I know you can get a list on users that are currently logged in to the session through script and filter is based on browser to narrow down who is logged into the browser. I wanted to know if it be possible to narrow th… --- ## [Ignition and Maple System](https://forum.inductiveautomation.com/t/ignition-and-maple-system/37883)
**Author:** [@mjohnson](https://forum.inductiveautomation.com/u/mjohnson)\ **Replies:** 1\ **Last updated:** [March 12, 2021, 3:40pm UTC](https://forum.inductiveautomation.com/t/ignition-and-maple-system/37883 "2021-03-12T15:40:20Z")
I am using Ignition Edge as a MQTT publisher, Ignition Gateway as the MQTT broker, and I want to use a Maple system as a MQTT Client. Using MQTTfx as a tester I can see the info at the Broker. Having issues connecting … --- ## [If function in mysql query](https://forum.inductiveautomation.com/t/if-function-in-mysql-query/44399)
**Author:** [@kuderskyys](https://forum.inductiveautomation.com/u/kuderskyys)\ **Replies:** 6\ **Last updated:** [March 12, 2021, 3:17pm UTC](https://forum.inductiveautomation.com/t/if-function-in-mysql-query/44399 "2021-03-12T15:17:36Z")
Hey guys! Can someone help me out? I have a problem with if function in mysql query (I want to create something like a switch) SELECT concat(COUNT(\*)) FROM {Root Container.NumberOfNumber 1.Table} if ({Root Contain… --- ## [How to compare string in expression language](https://forum.inductiveautomation.com/t/how-to-compare-string-in-expression-language/44390)
**Author:** [@Premnath.K](https://forum.inductiveautomation.com/u/Premnath.K)\ **Replies:** 7\ **Last updated:** [March 12, 2021, 11:48am UTC](https://forum.inductiveautomation.com/t/how-to-compare-string-in-expression-language/44390 "2021-03-12T11:48:40Z")
Is there a way to compare to strings in an expression language? I just want to compare my local ip in the system network tag to specific ip in string format and enable/disable a button in vision based on the result. --- ## [Connection to S7-1200 running Ignition Edge on Raspberry PI 4](https://forum.inductiveautomation.com/t/connection-to-s7-1200-running-ignition-edge-on-raspberry-pi-4/44368)
**Author:** [@electricworks48](https://forum.inductiveautomation.com/u/electricworks48)\ **Replies:** 5\ **Last updated:** [March 12, 2021, 10:07am UTC](https://forum.inductiveautomation.com/t/connection-to-s7-1200-running-ignition-edge-on-raspberry-pi-4/44368 "2021-03-12T10:07:11Z")
Hi All i have the Raspberry Pi 4 4gb Running the following OS PRETTY\_NAME=“Raspbian GNU/Linux 10 (buster)” NAME=“Raspbian GNU/Linux” VERSION\_ID=“10” VERSION=“10 (buster)” VERSION\_CODENAME=buster ID=raspbian ID\_LI… --- ## [Help on connecting to mysql and redundancy gateway on another computer](https://forum.inductiveautomation.com/t/help-on-connecting-to-mysql-and-redundancy-gateway-on-another-computer/44363)
**Author:** [@trishadx](https://forum.inductiveautomation.com/u/trishadx)\ **Replies:** 4\ **Last updated:** [March 12, 2021, 10:02am UTC](https://forum.inductiveautomation.com/t/help-on-connecting-to-mysql-and-redundancy-gateway-on-another-computer/44363 "2021-03-12T10:02:19Z")
Hi guys, I have a networking issue as computer networks isnt my strongest subject. I have 3 desktops in my structure where 1 is the master, 1 is the redundancy and another as my historian where I keep it all on mysql. … --- ## [\[BUG\] Power Chart Tags Fail when aggregateMode = Average](https://forum.inductiveautomation.com/t/bug-power-chart-tags-fail-when-aggregatemode-average/44394)
**Author:** [@matthew.gollasch](https://forum.inductiveautomation.com/u/matthew.gollasch)\ **Replies:** 0\ **Last updated:** [March 12, 2021, 8:15am UTC](https://forum.inductiveautomation.com/t/bug-power-chart-tags-fail-when-aggregatemode-average/44394 "2021-03-12T08:15:40Z")
1. The behavior you unexpectedly encountered - The Perspective Power Chart displays no pen data in the Chart or in the Pen Control panel if any of the configured pens have an aggregateMode = Average and that pen’s value… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1047) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1049)