# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1181 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1182 --- ## [Clear out date and time fields](https://forum.inductiveautomation.com/t/clear-out-date-and-time-fields/45887)
**Author:** [@csanyia](https://forum.inductiveautomation.com/u/csanyia)\ **Replies:** 1\ **Last updated:** [April 21, 2021, 8:35pm UTC](https://forum.inductiveautomation.com/t/clear-out-date-and-time-fields/45887 "2021-04-21T20:35:41Z")
I’m using Vision and MySQL. DateTime fields are populated and saved to the MySQL database. As new Rows are being populated depending, the Time and Date fields are empty, showing on ignitions end, which is perfect. Howe… --- ## [Launching Vision Client: ExceptionInInitializerError: null](https://forum.inductiveautomation.com/t/launching-vision-client-exceptionininitializererror-null/45882)
**Author:** [@S1ack](https://forum.inductiveautomation.com/u/S1ack)\ **Replies:** 6\ **Last updated:** [April 21, 2021, 8:05pm UTC](https://forum.inductiveautomation.com/t/launching-vision-client-exceptionininitializererror-null/45882 "2021-04-21T20:05:55Z")
Gateway is 8.1.2 On a customer’s site, their workstation, connects to gateway, downloads vision client launcher (Edge browser). Launch. Select project (the only project) ExceptionInInitializerError: null My laptop gets… --- ## [Ignition dealing with power outage](https://forum.inductiveautomation.com/t/ignition-dealing-with-power-outage/45876)
**Author:** [@ignitionfan1](https://forum.inductiveautomation.com/u/ignitionfan1)\ **Replies:** 4\ **Last updated:** [April 21, 2021, 7:55pm UTC](https://forum.inductiveautomation.com/t/ignition-dealing-with-power-outage/45876 "2021-04-21T19:55:02Z")
Hello community, We have recently purchased an Edge device (windows 10 pro) that is running an Ignition project and storing data into a MS SQL database. We are concerned that the project, database, or OS might get corr… --- ## [Style class not working on Icon](https://forum.inductiveautomation.com/t/style-class-not-working-on-icon/45866)
**Author:** [@retinder.labana](https://forum.inductiveautomation.com/u/retinder.labana)\ **Replies:** 3\ **Last updated:** [April 21, 2021, 7:42pm UTC](https://forum.inductiveautomation.com/t/style-class-not-working-on-icon/45866 "2021-04-21T19:42:27Z")
Im trying to fill the warning icon red by calling the Warning class I created I added color to the right property but the color is not changing If you are calling it through classes are you suppose to add color to… --- ## [Save information when returning to a previous state](https://forum.inductiveautomation.com/t/save-information-when-returning-to-a-previous-state/45834)
**Author:** [@antonio.sanchez](https://forum.inductiveautomation.com/u/antonio.sanchez)\ **Replies:** 7\ **Last updated:** [April 21, 2021, 7:18pm UTC](https://forum.inductiveautomation.com/t/save-information-when-returning-to-a-previous-state/45834 "2021-04-21T19:18:18Z")
Hello everybody I have a tag with a variable data 1 or 2 it depends on the case that is presented, and I require that the information be saved in my database when it changes from a state 2 to 1 if currentValue.value \> … --- ## [SQL custom queries and Ignition performance in general](https://forum.inductiveautomation.com/t/sql-custom-queries-and-ignition-performance-in-general/45865)
**Author:** [@sathianandan.dharmas](https://forum.inductiveautomation.com/u/sathianandan.dharmas)\ **Replies:** 2\ **Last updated:** [April 21, 2021, 7:13pm UTC](https://forum.inductiveautomation.com/t/sql-custom-queries-and-ignition-performance-in-general/45865 "2021-04-21T19:13:33Z")
Hi All I’m starting to re-evaluate my thoughts on custom queries/ named queries and thinking if I should switch over to using stored procedures instead. The main concern is having a high CPU (40 - 50%) and Memory usage … --- ## [What's in your nginx conf?](https://forum.inductiveautomation.com/t/whats-in-your-nginx-conf/45881)
**Author:** [@wking](https://forum.inductiveautomation.com/u/wking)\ **Replies:** 0\ **Last updated:** [April 21, 2021, 7:08pm UTC](https://forum.inductiveautomation.com/t/whats-in-your-nginx-conf/45881 "2021-04-21T19:08:23Z")
Playing around with a maker setup on docker compose. Does anyone have a solid Nginx conf file they can share? This is mine. But, I can’t get the designer to render it yet. I haven’t got it to attach to the SSL port yet… --- ## [Alarm Notification Pipeline Selection Gone](https://forum.inductiveautomation.com/t/alarm-notification-pipeline-selection-gone/45757)
**Author:** [@jramirez3](https://forum.inductiveautomation.com/u/jramirez3)\ **Replies:** 4\ **Last updated:** [April 21, 2021, 6:45pm UTC](https://forum.inductiveautomation.com/t/alarm-notification-pipeline-selection-gone/45757 "2021-04-21T18:45:08Z")
Has anyone ever lost the option to add an alarm notification pipeline to their tag in the alarm configuration like in the image below? Its very odd, i have never seen this and this just happened today, or at least I jus… --- ## [Ignition Demo - Designer Launch Error](https://forum.inductiveautomation.com/t/ignition-demo-designer-launch-error/45878)
**Author:** [@kcoulter](https://forum.inductiveautomation.com/u/kcoulter)\ **Replies:** 0\ **Last updated:** [April 21, 2021, 6:24pm UTC](https://forum.inductiveautomation.com/t/ignition-demo-designer-launch-error/45878 "2021-04-21T18:24:38Z")
When I try to open the Vision Demo I get this error: --- ## [SQL Timeout slow query](https://forum.inductiveautomation.com/t/sql-timeout-slow-query/15057)
**Author:** [@EricFrancoeur](https://forum.inductiveautomation.com/u/EricFrancoeur)\ **Replies:** 7\ **Last updated:** [April 21, 2021, 5:53pm UTC](https://forum.inductiveautomation.com/t/sql-timeout-slow-query/15057 "2021-04-21T17:53:48Z")
Hi, I have this issue: WARN com.inductiveautomation.ignition.client.gateway\_interface.GatewayConnectionManager - Connection to Gateway lost, due to exception. com.inductiveautomation.ignition.client.gateway\_interface.… --- ## [View PDF without Web Dev](https://forum.inductiveautomation.com/t/view-pdf-without-web-dev/45873)
**Author:** [@jwilliams](https://forum.inductiveautomation.com/u/jwilliams)\ **Replies:** 0\ **Last updated:** [April 21, 2021, 5:53pm UTC](https://forum.inductiveautomation.com/t/view-pdf-without-web-dev/45873 "2021-04-21T17:53:30Z")
Using Perspective is there any way to view a PDF without the Web Dev module? I’ve seen a script here that uses system.file.openFile to open specific files. # This code would prompt the user to open a file of type 'pdf'… --- ## [Print many pages only by one button with a template](https://forum.inductiveautomation.com/t/print-many-pages-only-by-one-button-with-a-template/45847)
**Author:** [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\ **Replies:** 1\ **Last updated:** [April 21, 2021, 4:22pm UTC](https://forum.inductiveautomation.com/t/print-many-pages-only-by-one-button-with-a-template/45847 "2021-04-21T16:22:33Z")
I have design a software for the warehouse to print deliver paper for customer. There is a column is ‘Selected’ ,if this column is 1, my logic will send my power table’s Sales order to a templates then print, like … --- ## [Report Failure - Gateway Exception](https://forum.inductiveautomation.com/t/report-failure-gateway-exception/45843)
**Author:** [@stephen.jones](https://forum.inductiveautomation.com/u/stephen.jones)\ **Replies:** 1\ **Last updated:** [April 21, 2021, 4:19pm UTC](https://forum.inductiveautomation.com/t/report-failure-gateway-exception/45843 "2021-04-21T16:19:15Z")
Entering ‘design mode’ of an ignition report i have a several minute ‘loading’ delay, then the following error is raised (full details also below), ExecutionException: com.inductiveautomation.ignition.client.gateway\_… --- ## [HTML Report inside body of email](https://forum.inductiveautomation.com/t/html-report-inside-body-of-email/30873)
**Author:** [@ajrowe](https://forum.inductiveautomation.com/u/ajrowe)\ **Replies:** 6\ **Last updated:** [April 21, 2021, 3:28pm UTC](https://forum.inductiveautomation.com/t/html-report-inside-body-of-email/30873 "2021-04-21T15:28:18Z")
Is it possible, and are there scripting examples, to create an emailed HTML report with the report in body of the email instead of as an attachment? --- ## [Timeout Function called with InvokeAsynchronous](https://forum.inductiveautomation.com/t/timeout-function-called-with-invokeasynchronous/45862)
**Author:** [@benjamin.sperl](https://forum.inductiveautomation.com/u/benjamin.sperl)\ **Replies:** 2\ **Last updated:** [April 21, 2021, 3:01pm UTC](https://forum.inductiveautomation.com/t/timeout-function-called-with-invokeasynchronous/45862 "2021-04-21T15:01:01Z")
I have a screen which uses the system.tag.queryTagHistory inside of a function invoked using InvokeAsynchronous. If the user selects a long time range with many tags, sometimes it can take up to a minute to finish execut… --- ## [SQL Server Index Fragmentation and Ad Hoc Queries](https://forum.inductiveautomation.com/t/sql-server-index-fragmentation-and-ad-hoc-queries/45858)
**Author:** [@jcaudle](https://forum.inductiveautomation.com/u/jcaudle)\ **Replies:** 2\ **Last updated:** [April 21, 2021, 2:36pm UTC](https://forum.inductiveautomation.com/t/sql-server-index-fragmentation-and-ad-hoc-queries/45858 "2021-04-21T14:36:52Z")
I have noticed a relatively high fragmentation level and rate of fragmentation in the automatically generated Ignition database for tag history. I have not noticed a performance impact in the apps, yet. Tuning Questions… --- ## [Vision client ne opened on a tablet?](https://forum.inductiveautomation.com/t/vision-client-ne-opened-on-a-tablet/45856)
**Author:** [@trishadx](https://forum.inductiveautomation.com/u/trishadx)\ **Replies:** 2\ **Last updated:** [April 21, 2021, 12:11pm UTC](https://forum.inductiveautomation.com/t/vision-client-ne-opened-on-a-tablet/45856 "2021-04-21T12:11:57Z")
Hi all I have a project made for vision client. Customers want to be able to open it on a tablet. I know that if this was created on perspective that this would be no problem but Vision provided more functionality for m… --- ## [Accessing Tag History for Further Manipulation before Displaying](https://forum.inductiveautomation.com/t/accessing-tag-history-for-further-manipulation-before-displaying/45793)
**Author:** [@shanaka](https://forum.inductiveautomation.com/u/shanaka)\ **Replies:** 2\ **Last updated:** [April 21, 2021, 10:25am UTC](https://forum.inductiveautomation.com/t/accessing-tag-history-for-further-manipulation-before-displaying/45793 "2021-04-21T10:25:34Z")
Hi All, I’m pretty new to Ignition. I have a requirement to access tag history where we store voltage values, calculate averages and show them as a chart. I know you can drag and drop historical tags onto a chart contro… --- ## [Add CSS3 transition animation for markup in map](https://forum.inductiveautomation.com/t/add-css3-transition-animation-for-markup-in-map/45830)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 0\ **Last updated:** [April 20, 2021, 8:38pm UTC](https://forum.inductiveautomation.com/t/add-css3-transition-animation-for-markup-in-map/45830 "2021-04-20T20:38:06Z")
Hi, Does anyone know any trick to use CSS3 transition animation for moving markup and point in perspective map component? I want when I feed new lat and lng for a markup, it move smoothly with transition to new positio… --- ## [Perspective Forbidden Access](https://forum.inductiveautomation.com/t/perspective-forbidden-access/45839)
**Author:** [@tohhy-pm17](https://forum.inductiveautomation.com/u/tohhy-pm17)\ **Replies:** 1\ **Last updated:** [April 21, 2021, 4:57am UTC](https://forum.inductiveautomation.com/t/perspective-forbidden-access/45839 "2021-04-21T04:57:53Z")
Hi guys. I already create the new roles and assign to the particular users but my Ignition only accept Administrators Roles login. When I try to use different roles to access to the system it shows the errors of Acce… --- ## [Ignition Perspective 8.1.2: TextArea Component Preview/Display mode rendering](https://forum.inductiveautomation.com/t/ignition-perspective-8-1-2-textarea-component-preview-display-mode-rendering/45835)
**Author:** [@mudbay](https://forum.inductiveautomation.com/u/mudbay)\ **Replies:** 2\ **Last updated:** [April 21, 2021, 2:54am UTC](https://forum.inductiveautomation.com/t/ignition-perspective-8-1-2-textarea-component-preview-display-mode-rendering/45835 "2021-04-21T02:54:28Z")
This rendering issue using Perspective took me by surprise as other components (i.e. Labels) seem to “inherit” styles that are compatible with the environment styles and themes, but I am struggling with getting the TextA… --- ## [Perspective Set focus in Field of a Specific Instance of a FlexRepeater](https://forum.inductiveautomation.com/t/perspective-set-focus-in-field-of-a-specific-instance-of-a-flexrepeater/45828)
**Author:** [@francois.morin](https://forum.inductiveautomation.com/u/francois.morin)\ **Replies:** 2\ **Last updated:** [April 20, 2021, 11:44pm UTC](https://forum.inductiveautomation.com/t/perspective-set-focus-in-field-of-a-specific-instance-of-a-flexrepeater/45828 "2021-04-20T23:44:05Z")
I have a FlexRepeater repeating a row template containing 3 TextField. The list of instances is bound to a database. For each Field change event, a validation procedure is run and if it is ok, the focus is set to the n… --- ## [Ignition Perspective 8.1.2: Security - How to access the User Security Path?](https://forum.inductiveautomation.com/t/ignition-perspective-8-1-2-security-how-to-access-the-user-security-path/45833)
**Author:** [@mudbay](https://forum.inductiveautomation.com/u/mudbay)\ **Replies:** 0\ **Last updated:** [April 20, 2021, 10:21pm UTC](https://forum.inductiveautomation.com/t/ignition-perspective-8-1-2-security-how-to-access-the-user-security-path/45833 "2021-04-20T22:21:55Z")
Is there a way of accessing the user path with Perspective IdP security through scripts or other methods? Example path below might be: Public\\Authenticated\\Roles\\IdP\_Engineers --- ## [Concept & Design Planning](https://forum.inductiveautomation.com/t/concept-design-planning/45824)
**Author:** [@tyler.robertson](https://forum.inductiveautomation.com/u/tyler.robertson)\ **Replies:** 3\ **Last updated:** [April 20, 2021, 10:23pm UTC](https://forum.inductiveautomation.com/t/concept-design-planning/45824 "2021-04-20T22:23:13Z")
Hi there, I wanted to ask if anyone felt free to share, especially from Ignition service suppliers, what platform or process do you use for designing concepts to show your customers (mine are internal) ? I started with … --- ## [Working with trend data](https://forum.inductiveautomation.com/t/working-with-trend-data/9844)
**Author:** [@pjgonzales](https://forum.inductiveautomation.com/u/pjgonzales)\ **Replies:** 4\ **Last updated:** [April 20, 2021, 10:07pm UTC](https://forum.inductiveautomation.com/t/working-with-trend-data/9844 "2021-04-20T22:07:52Z")
My customer is upgrading to Ignition from Citect (an old, old version of Citect). On the Citect trend screen there is a button for displaying the min, max and average of all the pens on the trend object. They would like … --- ## [Creating relative OPC tag UDT / templates](https://forum.inductiveautomation.com/t/creating-relative-opc-tag-udt-templates/45783)
**Author:** [@frank.carney](https://forum.inductiveautomation.com/u/frank.carney)\ **Replies:** 2\ **Last updated:** [April 20, 2021, 10:03pm UTC](https://forum.inductiveautomation.com/t/creating-relative-opc-tag-udt-templates/45783 "2021-04-20T22:03:12Z")
I am working to understand how to create relative OPC tags. I have a server layout that defines an object like this: module name – parameters — parameter value ---- parameter attributes There can be any number of … --- ## [Named Queries changes not updating](https://forum.inductiveautomation.com/t/named-queries-changes-not-updating/45429)
**Author:** [@jcaudle](https://forum.inductiveautomation.com/u/jcaudle)\ **Replies:** 1\ **Last updated:** [April 20, 2021, 9:36pm UTC](https://forum.inductiveautomation.com/t/named-queries-changes-not-updating/45429 "2021-04-20T21:36:02Z")
I’m seeing some strange behavior with Named Queries. I made a Named Query, Saved the project, Ran the query, Made Changes to the Named Query, Saved the project, now I’m getting errors running the pervious named query ins… --- ## [Capturing Twilio ApiException](https://forum.inductiveautomation.com/t/capturing-twilio-apiexception/45823)
**Author:** [@justin.brzozoski](https://forum.inductiveautomation.com/u/justin.brzozoski)\ **Replies:** 4\ **Last updated:** [April 20, 2021, 8:52pm UTC](https://forum.inductiveautomation.com/t/capturing-twilio-apiexception/45823 "2021-04-20T20:52:31Z")
Occasionally our system sends a SMS using Twilio to a number that fails for a persistent reason like a wrong number or the recipient having sent a “STOP” message back to us (which Twilio nicely manages for us). We would… --- ## [Private Key From Ignition CSR](https://forum.inductiveautomation.com/t/private-key-from-ignition-csr/34145)
**Author:** [@juan](https://forum.inductiveautomation.com/u/juan)\ **Replies:** 3\ **Last updated:** [April 20, 2021, 7:57pm UTC](https://forum.inductiveautomation.com/t/private-key-from-ignition-csr/34145 "2021-04-20T19:57:56Z")
I need to generate a private key pair to create a java keystore in order to enable TLS on my MQTT distributor module. I have my Certificate from godaddy, but I do not have my private key. How do I obtain this from ign… --- ## [HART protocol to Ignition Gateway](https://forum.inductiveautomation.com/t/hart-protocol-to-ignition-gateway/43206)
**Author:** [@OkiePC](https://forum.inductiveautomation.com/u/OkiePC)\ **Replies:** 8\ **Last updated:** [April 20, 2021, 7:27pm UTC](https://forum.inductiveautomation.com/t/hart-protocol-to-ignition-gateway/43206 "2021-04-20T19:27:01Z")
We’re starting a job to replace a Lookout Direct system with Ignition. The old system has a driver in KEPDirect that reads HART data from a transmitter right into the Lookout tag objects. The new server will have a ser… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1180) [Next page](https://forum.inductiveautomation.com/latest.md?page=1182)