# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=666 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 667 --- ## [Gateway Projects Active Perspective Sessions](https://forum.inductiveautomation.com/t/gateway-projects-active-perspective-sessions/71508)
**Author:** [@melwadeya](https://forum.inductiveautomation.com/u/melwadeya)\ **Replies:** 3\ **Last updated:** [April 19, 2023, 3:15pm UTC](https://forum.inductiveautomation.com/t/gateway-projects-active-perspective-sessions/71508 "2023-04-19T15:15:44Z")
Hello, Using Ignition 8.1.20, is there a way to get tags that show all active perspective sessions for all projects (we have over 10 projects)? we need tags that provide information similar to what is available in the g… --- ## [Splitting one dataset structure into several Table components, is it possible?](https://forum.inductiveautomation.com/t/splitting-one-dataset-structure-into-several-table-components-is-it-possible/72631)
**Author:** [@Michal\_Goralczyk](https://forum.inductiveautomation.com/u/Michal_Goralczyk)\ **Replies:** 2\ **Last updated:** [April 19, 2023, 3:15pm UTC](https://forum.inductiveautomation.com/t/splitting-one-dataset-structure-into-several-table-components-is-it-possible/72631 "2023-04-19T15:15:26Z")
Hello, for better visualization of dataset in my Ignition interface I need to separate one dataset structure into several table components placed one after another. My dataset is large but the amount of information is v… --- ## [Ignition Crash (Fatal Error) with MSSQL Integrated Security](https://forum.inductiveautomation.com/t/ignition-crash-fatal-error-with-mssql-integrated-security/63143)
**Author:** [@y.parashchuk](https://forum.inductiveautomation.com/u/y.parashchuk)\ **Replies:** 18\ **Last updated:** [April 19, 2023, 3:15pm UTC](https://forum.inductiveautomation.com/t/ignition-crash-fatal-error-with-mssql-integrated-security/63143 "2023-04-19T15:15:04Z")
In a past I had an issue with Ignition 8.1.11 version with integrated security but I found move around which I specified here → SQL Server Database Connection with Integrated Security - #3 by y.parashchuk Today i need … --- ## [Capture output of notification block in pipeline for logging purposes](https://forum.inductiveautomation.com/t/capture-output-of-notification-block-in-pipeline-for-logging-purposes/72636)
**Author:** [@liam1](https://forum.inductiveautomation.com/u/liam1)\ **Replies:** 1\ **Last updated:** [April 19, 2023, 3:08pm UTC](https://forum.inductiveautomation.com/t/capture-output-of-notification-block-in-pipeline-for-logging-purposes/72636 "2023-04-19T15:08:30Z")
Hi everyone, I'm attempting to create an SMS logging function for the notification pipeline for all SMSs sent out. I want to log this information into a database. Is there a return object generated by the notification … --- ## [Automatic date time setter in XY chart](https://forum.inductiveautomation.com/t/automatic-date-time-setter-in-xy-chart/72560)
**Author:** [@Chowmya\_C](https://forum.inductiveautomation.com/u/Chowmya_C)\ **Replies:** 4\ **Last updated:** [April 19, 2023, 1:55pm UTC](https://forum.inductiveautomation.com/t/automatic-date-time-setter-in-xy-chart/72560 "2023-04-19T13:55:12Z")
How to make present date and time setter in X axis of XY chart. Since, I've used this code date = system.date.getDate(2023, 4, 18) print system.date.setTime(date, 1, 37, 44) It's showing error. --- ## [Perspective intermittently freezing up](https://forum.inductiveautomation.com/t/perspective-intermittently-freezing-up/72604)
**Author:** [@tcrucet](https://forum.inductiveautomation.com/u/tcrucet)\ **Replies:** 4\ **Last updated:** [April 19, 2023, 1:44pm UTC](https://forum.inductiveautomation.com/t/perspective-intermittently-freezing-up/72604 "2023-04-19T13:44:15Z")
I've been getting reports from operators of an Ignition Perspective project freezing up and requiring reboots of the client PCs running Worktstation to resolve it. I'm wondering if this could be related to: calling que… --- ## [Round corners XY Chart](https://forum.inductiveautomation.com/t/round-corners-xy-chart/72637)
**Author:** [@kaleb.s](https://forum.inductiveautomation.com/u/kaleb.s)\ **Replies:** 1\ **Last updated:** [April 19, 2023, 12:40pm UTC](https://forum.inductiveautomation.com/t/round-corners-xy-chart/72637 "2023-04-19T12:40:25Z")
Is there a way to round the corners of the background of an XY Chart in perspective? I know i can add a property to the actual bars i have on my XY Chart to round the tops but cant figure out how to actually round all f… --- ## [Not able to access file on network shared drive through Gateway event script](https://forum.inductiveautomation.com/t/not-able-to-access-file-on-network-shared-drive-through-gateway-event-script/72627)
**Author:** [@Rahul\_Bhakte1](https://forum.inductiveautomation.com/u/Rahul_Bhakte1)\ **Replies:** 3\ **Last updated:** [April 19, 2023, 12:36pm UTC](https://forum.inductiveautomation.com/t/not-able-to-access-file-on-network-shared-drive-through-gateway-event-script/72627 "2023-04-19T12:36:24Z")
I am trying to access the excel file which is kept on a server shared drive through gateway scheduled script. It gives me error as 'Access is denied' on Gateway script. But the good part is I am able to access the same f… --- ## [Display an alternate Image if ImagePath is invalid - Image Component - Vision](https://forum.inductiveautomation.com/t/display-an-alternate-image-if-imagepath-is-invalid-image-component-vision/72597)
**Author:** [@Nathan\_Guindon\_Duroc](https://forum.inductiveautomation.com/u/Nathan_Guindon_Duroc)\ **Replies:** 2\ **Last updated:** [April 19, 2023, 11:32am UTC](https://forum.inductiveautomation.com/t/display-an-alternate-image-if-imagepath-is-invalid-image-component-vision/72597 "2023-04-19T11:32:00Z")
Hey, I am trying to display an alternate image when the Image path is invalid. I haven't found a way to do this, Quality doesn't seem to change even if path is invalid. System.file.fileExists doesn't seem to work with Im… --- ## [Perspective Chart Quetsion](https://forum.inductiveautomation.com/t/perspective-chart-quetsion/72076)
**Author:** [@jiyoung\_hwang1](https://forum.inductiveautomation.com/u/jiyoung_hwang1)\ **Replies:** 3\ **Last updated:** [April 19, 2023, 11:13am UTC](https://forum.inductiveautomation.com/t/perspective-chart-quetsion/72076 "2023-04-19T11:13:32Z")
I want to create a trend like picture “1”. What kind of chart should I configure? And if you look at the top right of the picture "1", if you press the Year, Month, Week, Day, 6h, 1h buttons, you want to see the tren… --- ## [Logger not showing Gateway Scheduled Script running](https://forum.inductiveautomation.com/t/logger-not-showing-gateway-scheduled-script-running/70223)
**Author:** [@bwhite](https://forum.inductiveautomation.com/u/bwhite)\ **Replies:** 24\ **Last updated:** [February 23, 2023, 4:00pm UTC](https://forum.inductiveautomation.com/t/logger-not-showing-gateway-scheduled-script-running/70223 "2023-02-23T16:00:03Z")
I'm running this on my scheduled gateway script in Ignition 8.1, and it isn't showing in the logger. What am I doing wrong? def onScheduledEvent(): logger = system.util.logger("GatewayScript") logger.info('Email Repo… --- ## [Cursor shape on mouse-over](https://forum.inductiveautomation.com/t/cursor-shape-on-mouse-over/72515)
**Author:** [@Henk](https://forum.inductiveautomation.com/u/Henk)\ **Replies:** 6\ **Last updated:** [April 19, 2023, 7:21am UTC](https://forum.inductiveautomation.com/t/cursor-shape-on-mouse-over/72515 "2023-04-19T07:21:16Z")
A customer wants the cursor to change from an arrow to a hand for all clickable objects. This is easy to do in Ignition. However, if a template is placed over this object, the click action will be executed, but the curso… --- ## [Controling a valve through a faceplate](https://forum.inductiveautomation.com/t/controling-a-valve-through-a-faceplate/72524)
**Author:** [@Lukas\_De\_Cleen](https://forum.inductiveautomation.com/u/Lukas_De_Cleen)\ **Replies:** 11\ **Last updated:** [April 19, 2023, 7:04am UTC](https://forum.inductiveautomation.com/t/controling-a-valve-through-a-faceplate/72524 "2023-04-19T07:04:11Z")
Hey, I am trying to make a faceplate for a valve in perspective. I already manged to read values from my PLC, but when i make a button for opening or closing the valve i just doens't work. I work with parameters, i link … --- ## [Perspective Fancy CSS - Toggle switches](https://forum.inductiveautomation.com/t/perspective-fancy-css-toggle-switches/72623)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 0\ **Last updated:** [April 19, 2023, 6:03am UTC](https://forum.inductiveautomation.com/t/perspective-fancy-css-toggle-switches/72623 "2023-04-19T06:03:07Z")
I found these... I've tried to get button-10 into Perspective, but I'm struggling a bit... I scraped away all of the irrelevant stuff and added psc- to the start of all the classes that the HTML DOM components referen… --- ## [Temporarily enable DB connection](https://forum.inductiveautomation.com/t/temporarily-enable-db-connection/30414)
**Author:** [@cesrom](https://forum.inductiveautomation.com/u/cesrom)\ **Replies:** 4\ **Last updated:** [April 19, 2023, 12:50am UTC](https://forum.inductiveautomation.com/t/temporarily-enable-db-connection/30414 "2023-04-19T00:50:28Z")
Hello community, Recently a DBA asked me about a “live” connection to a database, and this was a connection I had set up on one of our gateways for testing purposes. Since I was not going to use it, I decided to disabl… --- ## [Mostly functioning SFC shows abortCause java.lang.Exception: compilation error in \ \ \](https://forum.inductiveautomation.com/t/mostly-functioning-sfc-shows-abortcause-java-lang-exception-compilation-error-in-td-tr-table/70193)
**Author:** [@Alexander\_Sherman](https://forum.inductiveautomation.com/u/Alexander_Sherman)\ **Replies:** 4\ **Last updated:** [April 19, 2023, 3:39am UTC](https://forum.inductiveautomation.com/t/mostly-functioning-sfc-shows-abortcause-java-lang-exception-compilation-error-in-td-tr-table/70193 "2023-04-19T03:39:17Z")
I have an SFC that runs for the most part (it fails when trying to run sequentially, due to this bug). Even when it is "working" it shows an abortCause in the Chart Monitoring window of java.lang.Exception: compilation e… --- ## [Perspective alarm status table wrapping](https://forum.inductiveautomation.com/t/perspective-alarm-status-table-wrapping/58449)
**Author:** [@ASF](https://forum.inductiveautomation.com/u/ASF)\ **Replies:** 3\ **Last updated:** [April 19, 2023, 3:19am UTC](https://forum.inductiveautomation.com/t/perspective-alarm-status-table-wrapping/58449 "2023-04-19T03:19:09Z")
I have a perspective alarm table in a narrow-ish side dock. Responsive mode is enabled so the alarms show up in the “card” style, but the display path is truncated with … Is there any way to force the Display Path to wr… --- ## [Perspective Alarm Journal](https://forum.inductiveautomation.com/t/perspective-alarm-journal/72613)
**Author:** [@jiyoung\_hwang1](https://forum.inductiveautomation.com/u/jiyoung_hwang1)\ **Replies:** 1\ **Last updated:** [April 19, 2023, 2:22am UTC](https://forum.inductiveautomation.com/t/perspective-alarm-journal/72613 "2023-04-19T02:22:20Z")
I want to use journal in perspective, but I don't know how to do it. Is there anything I need to connect in the designer? I really don't know how to get the alarms to appear in the journal. please let me know I'… --- ## [How to notify by email of the alarm configured as "any change" type](https://forum.inductiveautomation.com/t/how-to-notify-by-email-of-the-alarm-configured-as-any-change-type/72574)
**Author:** [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\ **Replies:** 2\ **Last updated:** [April 18, 2023, 10:40pm UTC](https://forum.inductiveautomation.com/t/how-to-notify-by-email-of-the-alarm-configured-as-any-change-type/72574 "2023-04-18T22:40:37Z")
There's a tag that I want to display alarm and notify by email whenever the value changes. I can setup the alarm type "Any Change" to display this alarm on alarm banner, but because this alarm will never be active, whic… --- ## [How to Print a Report From Client](https://forum.inductiveautomation.com/t/how-to-print-a-report-from-client/72162)
**Author:** [@CSWoodworth](https://forum.inductiveautomation.com/u/CSWoodworth)\ **Replies:** 6\ **Last updated:** [April 18, 2023, 10:13pm UTC](https://forum.inductiveautomation.com/t/how-to-print-a-report-from-client/72162 "2023-04-18T22:13:05Z")
I'm using ignition 7.9.19 with the goal of using a single button press to print a report from a client window. I've realized the system.report.executeAndDistribute function executes on the gateway, this wont work for me… --- ## [Vision Client Launcher Application for all users](https://forum.inductiveautomation.com/t/vision-client-launcher-application-for-all-users/51861)
**Author:** [@luis.duarte](https://forum.inductiveautomation.com/u/luis.duarte)\ **Replies:** 4\ **Last updated:** [April 18, 2023, 8:02pm UTC](https://forum.inductiveautomation.com/t/vision-client-launcher-application-for-all-users/51861 "2023-04-18T20:02:15Z")
Hi All, Is there a way to install a Vision Client Launcher application to all users? As of now all of my operators have to log in first, connect to the gateway, select a project, and download it when they first log in. … --- ## [Named Query Binding Latest Execution Timestamp](https://forum.inductiveautomation.com/t/named-query-binding-latest-execution-timestamp/72590)
**Author:** [@Rajiv\_Thapa](https://forum.inductiveautomation.com/u/Rajiv_Thapa)\ **Replies:** 7\ **Last updated:** [April 18, 2023, 7:58pm UTC](https://forum.inductiveautomation.com/t/named-query-binding-latest-execution-timestamp/72590 "2023-04-18T19:58:16Z")
I have a table on the dashboard which is populated through the named query binding. I have set up the polling to every 5 minutes. How can I view the timestamp of the latest execution of named query binding. --- ## [Tag Historian Query Aggregation Mode - Range](https://forum.inductiveautomation.com/t/tag-historian-query-aggregation-mode-range/72545)
**Author:** [@Ryan\_Allen](https://forum.inductiveautomation.com/u/Ryan_Allen)\ **Replies:** 1\ **Last updated:** [April 18, 2023, 7:23pm UTC](https://forum.inductiveautomation.com/t/tag-historian-query-aggregation-mode-range/72545 "2023-04-18T19:23:38Z")
Can anyone help me understand the following behavior when attempting to use the range aggregation mode in the reporting module with a tag historian query? The attached image is a comparison of the same data & time range,… --- ## [A boolean tag, to trigger the alarm on the rising edge](https://forum.inductiveautomation.com/t/a-boolean-tag-to-trigger-the-alarm-on-the-rising-edge/72551)
**Author:** [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\ **Replies:** 2\ **Last updated:** [April 18, 2023, 7:14pm UTC](https://forum.inductiveautomation.com/t/a-boolean-tag-to-trigger-the-alarm-on-the-rising-edge/72551 "2023-04-18T19:14:08Z")
Hi, I have configured a boolean tag, instead of using PLC, I want to use ignition alarm function to configure a alarm on the rising edge of the signal, means the alarm should be triggered when the signal is changing fro… --- ## [How to create a script to clear Database every day?](https://forum.inductiveautomation.com/t/how-to-create-a-script-to-clear-database-every-day/72575)
**Author:** [@tzbh1234](https://forum.inductiveautomation.com/u/tzbh1234)\ **Replies:** 3\ **Last updated:** [April 18, 2023, 7:06pm UTC](https://forum.inductiveautomation.com/t/how-to-create-a-script-to-clear-database-every-day/72575 "2023-04-18T19:06:33Z")
Hi, I have ignition 7.9.11, I want to create a script that checking every day which data exist in database at least one year or more and delete it. Which subject I need to read to work about it ? Thanks. --- ## [How can I close the authentication window after fail the password n times?](https://forum.inductiveautomation.com/t/how-can-i-close-the-authentication-window-after-fail-the-password-n-times/72599)
**Author:** [@li\_guo](https://forum.inductiveautomation.com/u/li_guo)\ **Replies:** 0\ **Last updated:** [April 18, 2023, 7:04pm UTC](https://forum.inductiveautomation.com/t/how-can-i-close-the-authentication-window-after-fail-the-password-n-times/72599 "2023-04-18T19:04:45Z")
How can I write scripts to close the authentication login window after login failed, and also close the e-sign popup which calls the authentication login window, and show alarm info for the login fail. thanks! --- ## [Is there a way to convert a png file to jpg?](https://forum.inductiveautomation.com/t/is-there-a-way-to-convert-a-png-file-to-jpg/72592)
**Author:** [@Adam\_Verellen](https://forum.inductiveautomation.com/u/Adam_Verellen)\ **Replies:** 4\ **Last updated:** [April 18, 2023, 6:33pm UTC](https://forum.inductiveautomation.com/t/is-there-a-way-to-convert-a-png-file-to-jpg/72592 "2023-04-18T18:33:06Z")
Has anyone been able to convert a png file to a jpg file in a gateway script? I'll update my post if I find something in the meantime. So far no luck. Thanks in advance. --- ## [Get Closest Historical Value - system.tag.queryTagHistory](https://forum.inductiveautomation.com/t/get-closest-historical-value-system-tag-querytaghistory/72409)
**Author:** [@alainia.spencer](https://forum.inductiveautomation.com/u/alainia.spencer)\ **Replies:** 1\ **Last updated:** [April 18, 2023, 6:05pm UTC](https://forum.inductiveautomation.com/t/get-closest-historical-value-system-tag-querytaghistory/72409 "2023-04-18T18:05:16Z")
I'm trying to use the system.tag.queryTagHistory to get the previous day's value that is closest to 1:00. Based on the history for this tag, I would expect to get a value of 22,927.033, however, there is nothing being r… --- ## [Ordered view.param object in Perspective](https://forum.inductiveautomation.com/t/ordered-view-param-object-in-perspective/72552)
**Author:** [@user66](https://forum.inductiveautomation.com/u/user66)\ **Replies:** 5\ **Last updated:** [April 18, 2023, 5:45pm UTC](https://forum.inductiveautomation.com/t/ordered-view-param-object-in-perspective/72552 "2023-04-18T17:45:56Z")
Hi all, I have a view param object to which I'm assigning key : value pairs in a script but I want to preserve the order in which the key : value were assigned like in orderedDict in python. Is there a possible way of … --- ## [HTTP Client Post Call](https://forum.inductiveautomation.com/t/http-client-post-call/70287)
**Author:** [@jfan](https://forum.inductiveautomation.com/u/jfan)\ **Replies:** 11\ **Last updated:** [April 18, 2023, 5:10pm UTC](https://forum.inductiveautomation.com/t/http-client-post-call/70287 "2023-04-18T17:10:46Z")
Hi All, I am pretty new to using the Post Call method to post data. While I tried to use the httpClient function to post a request on the Boomi server, I got the following error saying the existing connection is forcibl… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=665) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=667)