# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=664 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 665 --- ## [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… --- ## [Range aggregation Mode return wrong result](https://forum.inductiveautomation.com/t/range-aggregation-mode-return-wrong-result/27334)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 4\ **Last updated:** [April 18, 2023, 5:09pm UTC](https://forum.inductiveautomation.com/t/range-aggregation-mode-return-wrong-result/27334 "2023-04-18T17:09:38Z")
Hello I history water volume every 10 second and try to get hourly water usage by using Range aggregation mode (Volmax - Volmin). I set the sample size = interval = 1 hour, so the result would be a series of 1 hour reco… --- ## [Search function on perspective dashboard page](https://forum.inductiveautomation.com/t/search-function-on-perspective-dashboard-page/72571)
**Author:** [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Replies:** 5\ **Last updated:** [April 18, 2023, 3:27pm UTC](https://forum.inductiveautomation.com/t/search-function-on-perspective-dashboard-page/72571 "2023-04-18T15:27:43Z")
To make a search function work, like the search on the website Android Police for example, I make a table of all my pages with a link column, and a column with descriptions that can be searched? Then I use prepupdate to… --- ## [How to programatically create alarm notification URL for acknowledging](https://forum.inductiveautomation.com/t/how-to-programatically-create-alarm-notification-url-for-acknowledging/72562)
**Author:** [@r.p](https://forum.inductiveautomation.com/u/r.p)\ **Replies:** 4\ **Last updated:** [April 18, 2023, 1:28pm UTC](https://forum.inductiveautomation.com/t/how-to-programatically-create-alarm-notification-url-for-acknowledging/72562 "2023-04-18T13:28:26Z")
We need to programatically create alarm notification URLs like: example.com/web/ack/6JO4vpqcjMmoW4nQzm0s28abO1LuHcK7MnT-FwlOVpwv without using the notification block in the alarm pipeline but using scripting because we… --- ## [Popup Generic Template](https://forum.inductiveautomation.com/t/popup-generic-template/72538)
**Author:** [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\ **Replies:** 13\ **Last updated:** [April 18, 2023, 12:41pm UTC](https://forum.inductiveautomation.com/t/popup-generic-template/72538 "2023-04-18T12:41:01Z")
Good day. I am looking at creating a general template for a popup that i can use multiple times over. I have a base view created that looks something like this: I would like to be able to select one of larger squares… --- ## [Check-sheet Development in Perspective](https://forum.inductiveautomation.com/t/check-sheet-development-in-perspective/72565)
**Author:** [@Rohit\_Mehar](https://forum.inductiveautomation.com/u/Rohit_Mehar)\ **Replies:** 2\ **Last updated:** [April 18, 2023, 11:32am UTC](https://forum.inductiveautomation.com/t/check-sheet-development-in-perspective/72565 "2023-04-18T11:32:25Z")
Hello There, I am developing the check-sheet in my project as shown below, where it contain some static data which is never gonna change(marked in yellow) and some data operator need to put (marked blue). All this data… --- ## [Bars distance in XY Chart](https://forum.inductiveautomation.com/t/bars-distance-in-xy-chart/54914)
**Author:** [@shabir.ahmed](https://forum.inductiveautomation.com/u/shabir.ahmed)\ **Replies:** 5\ **Last updated:** [April 18, 2023, 10:32am UTC](https://forum.inductiveautomation.com/t/bars-distance-in-xy-chart/54914 "2023-04-18T10:32:23Z")
Hi Experts, I have set my XY-Chart to Bar Graph, its showing Bars correctly while Y axis is consumption and X-axis is Week number. When I have added multiple series to display as Bars, the distance between bars is signi… --- ## [Possible bug, cannot change font color of labels (XY Chart)](https://forum.inductiveautomation.com/t/possible-bug-cannot-change-font-color-of-labels-xy-chart/32271)
**Author:** [@thuffman](https://forum.inductiveautomation.com/u/thuffman)\ **Replies:** 3\ **Last updated:** [April 18, 2023, 7:29am UTC](https://forum.inductiveautomation.com/t/possible-bug-cannot-change-font-color-of-labels-xy-chart/32271 "2023-04-18T07:29:28Z")
I have been running into some issues with the XY chart when it comes to changing the font color of some labels that I have configured to display above a bar graph. I have tried changing the text color with the style sel… --- ## [Perspective XH CHART Question 2](https://forum.inductiveautomation.com/t/perspective-xh-chart-question-2/72558)
**Author:** [@jiyoung\_hwang1](https://forum.inductiveautomation.com/u/jiyoung_hwang1)\ **Replies:** 3\ **Last updated:** [April 18, 2023, 6:59am UTC](https://forum.inductiveautomation.com/t/perspective-xh-chart-question-2/72558 "2023-04-18T06:59:24Z")
As shown in the attached file, I want to reduce the interval between blue and green in the graph. How can I do that? --- ## [First time user architecture (RPI + Ignition)](https://forum.inductiveautomation.com/t/first-time-user-architecture-rpi-ignition/72492)
**Author:** [@SamSevens](https://forum.inductiveautomation.com/u/SamSevens)\ **Replies:** 4\ **Last updated:** [April 18, 2023, 4:43am UTC](https://forum.inductiveautomation.com/t/first-time-user-architecture-rpi-ignition/72492 "2023-04-18T04:43:11Z")
Hi Everyone, First time poster, and I'm a mid career professional in IT/OT. I'm starting to better understand ignition, and hear so many great things, so I'm trying to wedge it into a project at work. I work in a small… --- ## [Working with docker containers](https://forum.inductiveautomation.com/t/working-with-docker-containers/60332)
**Author:** [@louagejasper](https://forum.inductiveautomation.com/u/louagejasper)\ **Replies:** 9\ **Last updated:** [April 17, 2023, 9:43pm UTC](https://forum.inductiveautomation.com/t/working-with-docker-containers/60332 "2023-04-17T21:43:27Z")
Hi, We’ve been using Ignition to run in a container environment for a while now, without too many docker related issues. I do remember to have read something that IA would have to make some changes to the licensing, bu… --- ## [Uploading a quarantine file - "This site can’t be reached"](https://forum.inductiveautomation.com/t/uploading-a-quarantine-file-this-site-can-t-be-reached/72544)
**Author:** [@Troy](https://forum.inductiveautomation.com/u/Troy)\ **Replies:** 3\ **Last updated:** [April 17, 2023, 9:16pm UTC](https://forum.inductiveautomation.com/t/uploading-a-quarantine-file-this-site-can-t-be-reached/72544 "2023-04-17T21:16:43Z")
When I upload a quarantine.xml file that I pulled earlier, I redirect to a page that says, "This site can’t be reached. The connection was reset." I'd upload the xml file here, but the tag paths have brand IDs and it's … --- ## [Order of execution and the effect of Navigation upon it](https://forum.inductiveautomation.com/t/order-of-execution-and-the-effect-of-navigation-upon-it/72529)
**Author:** [@Alex\_Leech](https://forum.inductiveautomation.com/u/Alex_Leech)\ **Replies:** 2\ **Last updated:** [April 17, 2023, 9:15pm UTC](https://forum.inductiveautomation.com/t/order-of-execution-and-the-effect-of-navigation-upon-it/72529 "2023-04-17T21:15:01Z")
Hi all, Firstly, this does work, however, I dont understand why! I have a 'On Click' script on a object that is designed to set a session prop called 'TabSet' to a number, then change the page. The destination page has… --- ## [Value Changed script doesn't execute](https://forum.inductiveautomation.com/t/value-changed-script-doesnt-execute/72473)
**Author:** [@rfolkes](https://forum.inductiveautomation.com/u/rfolkes)\ **Replies:** 6\ **Last updated:** [April 17, 2023, 8:59pm UTC](https://forum.inductiveautomation.com/t/value-changed-script-doesnt-execute/72473 "2023-04-17T20:59:20Z")
8.1.22 I have a tag event script. I have the tag set to change every 30 sec if(dateExtract(Now(1000),"second")\<30,1,0) that part is working and tag is changing value I have tag change script below. If I copy eit… --- ## [Create right and left click event on the same Object (Ignition Designer)](https://forum.inductiveautomation.com/t/create-right-and-left-click-event-on-the-same-object-ignition-designer/72475)
**Author:** [@nbautomation](https://forum.inductiveautomation.com/u/nbautomation)\ **Replies:** 3\ **Last updated:** [April 17, 2023, 8:44pm UTC](https://forum.inductiveautomation.com/t/create-right-and-left-click-event-on-the-same-object-ignition-designer/72475 "2023-04-17T20:44:50Z")
Hi, I'm trying to open different windows(pop-up) on the same object, but I can not see how to make difference between left click event (Event Handlers/Mouse/mouseClicked) and right click event. I could saw script was ge… --- ## [\[ SOLVED \]Report viewer max number of pages](https://forum.inductiveautomation.com/t/solved-report-viewer-max-number-of-pages/72540)
**Author:** [@Esmeralda\_Lopez](https://forum.inductiveautomation.com/u/Esmeralda_Lopez)\ **Replies:** 7\ **Last updated:** [April 17, 2023, 8:43pm UTC](https://forum.inductiveautomation.com/t/solved-report-viewer-max-number-of-pages/72540 "2023-04-17T20:43:42Z")
Hello everyone, I got this error in the console, just for the report viewer. But I want to know if there is any option to increase the number of pages java.util.concurrent.ExecutionException: java.lang.IllegalStateExcep… --- ## [1st Arg Can't be Coerced to Java.Util.Date](https://forum.inductiveautomation.com/t/1st-arg-cant-be-coerced-to-java-util-date/72537)
**Author:** [@Daniel\_Wade](https://forum.inductiveautomation.com/u/Daniel_Wade)\ **Replies:** 8\ **Last updated:** [April 17, 2023, 7:45pm UTC](https://forum.inductiveautomation.com/t/1st-arg-cant-be-coerced-to-java-util-date/72537 "2023-04-17T19:45:36Z")
I know this is going to be something simple, but I'm running my head into a wall. I'm just trying to get the seconds between a date and now() and I get "1st Arg Can't be Coerced to Java.Util.Date" error in the script con… --- ## [Sticky Binding Values (my attempt to recreate Alarm Status marquee functionality)](https://forum.inductiveautomation.com/t/sticky-binding-values-my-attempt-to-recreate-alarm-status-marquee-functionality/72037)
**Author:** [@Chris\_McPherson](https://forum.inductiveautomation.com/u/Chris_McPherson)\ **Replies:** 2\ **Last updated:** [April 17, 2023, 6:49pm UTC](https://forum.inductiveautomation.com/t/sticky-binding-values-my-attempt-to-recreate-alarm-status-marquee-functionality/72037 "2023-04-17T18:49:42Z")
Hi All, I am trying to do a label binding to recreate the functionality of the marquee mode of the vision alarm status in Perspective 8.1.25 My issue is that what is being displayed is inconsistent with the Dataset (i.… --- ## [Out parameters of a view not updated](https://forum.inductiveautomation.com/t/out-parameters-of-a-view-not-updated/70579)
**Author:** [@AGOSTINO\_SCLAUZERO](https://forum.inductiveautomation.com/u/AGOSTINO_SCLAUZERO)\ **Replies:** 4\ **Last updated:** [April 17, 2023, 5:03pm UTC](https://forum.inductiveautomation.com/t/out-parameters-of-a-view-not-updated/70579 "2023-04-17T17:03:41Z")
I created a perspective view with nothing but a TextField. The view has a param called "MyOutParm" that is set as an output param \*\*and is bound to the TextField's text property. I called the view I've just created … --- ## [Perspective TimeSeriesChart Legend](https://forum.inductiveautomation.com/t/perspective-timeserieschart-legend/72477)
**Author:** [@CTavakoli](https://forum.inductiveautomation.com/u/CTavakoli)\ **Replies:** 3\ **Last updated:** [April 17, 2023, 3:21pm UTC](https://forum.inductiveautomation.com/t/perspective-timeserieschart-legend/72477 "2023-04-17T15:21:34Z")
Is there a way to partially hide Legend for Perspective TimeSeriesChart component? I was hoping to be able to keep them on for a certain plot and hide them for the other plots, --- ## [Having trouble with {eventState} in custom alarm message expression](https://forum.inductiveautomation.com/t/having-trouble-with-eventstate-in-custom-alarm-message-expression/72406)
**Author:** [@CBandurski](https://forum.inductiveautomation.com/u/CBandurski)\ **Replies:** 11\ **Last updated:** [April 17, 2023, 2:06pm UTC](https://forum.inductiveautomation.com/t/having-trouble-with-eventstate-in-custom-alarm-message-expression/72406 "2023-04-17T14:06:09Z")
I might be missing something dumb, but I'm a bit perplexed... I'm trying to get a simple if statement to work in my custom alarm message. if({eventState} = "Active", "Some Message", "Some Other Message") // this is neve… --- ## [\[BUG-7524\]Tag Browser - Ctrl+drag does not work as expected?](https://forum.inductiveautomation.com/t/bug-7524-tag-browser-ctrl-drag-does-not-work-as-expected/50755)
**Author:** [@johannes.bo](https://forum.inductiveautomation.com/u/johannes.bo)\ **Replies:** 0\ **Last updated:** [September 9, 2021, 8:39am UTC](https://forum.inductiveautomation.com/t/bug-7524-tag-browser-ctrl-drag-does-not-work-as-expected/50755 "2021-09-09T08:39:39Z")
Ignition 8.1.9 I expect to copy a tag or udt when holding ctrl-key and dragging with mouse pointer Copy is NOT performed Instead a move is performed -without the expected confirmation dialog Proposal: adopt ms win… --- ## [Error Executing system.db.execSProcCall() Gateway Script](https://forum.inductiveautomation.com/t/error-executing-system-db-execsproccall-gateway-script/72521)
**Author:** [@Robert\_Hrynciw](https://forum.inductiveautomation.com/u/Robert_Hrynciw)\ **Replies:** 14\ **Last updated:** [April 17, 2023, 12:35pm UTC](https://forum.inductiveautomation.com/t/error-executing-system-db-execsproccall-gateway-script/72521 "2023-04-17T12:35:44Z")
Good morning! I am having problems with my gateway script giving off random errors every now and then under the following error code: com.inductiveautomation.ignition.common.script.JythonExecException: Traceback (most r… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=663) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=665)