# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=596 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 597 --- ## [Ignition Reporting Module Help](https://forum.inductiveautomation.com/t/ignition-reporting-module-help/77393)
**Author:** [@Nicholas\_Houston](https://forum.inductiveautomation.com/u/Nicholas_Houston)\ **Replies:** 7\ **Last updated:** [August 3, 2023, 8:45pm UTC](https://forum.inductiveautomation.com/t/ignition-reporting-module-help/77393 "2023-08-03T20:45:24Z")
I'm looking to print a report for each row in a query dataset. I can't seem to figure out how to do this. The only way i've been able to accomplish it is by passing a parameter into the report with a popup screen and the… --- ## [Alarm Pipeline Associated Data in Script Block](https://forum.inductiveautomation.com/t/alarm-pipeline-associated-data-in-script-block/25997)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 3\ **Last updated:** [July 31, 2023, 6:37pm UTC](https://forum.inductiveautomation.com/t/alarm-pipeline-associated-data-in-script-block/25997 "2023-07-31T18:37:30Z")
Here is an example from my script block. deviceID = ????? Param={“SensorNo”:deviceID} system.report.executeAndDistribute(path="Maintenance/Vibration", project="MMLuvata2", parameters=Param, action= "email", actionSet… --- ## [Change Power Chart Data Depending on Dropdown Value](https://forum.inductiveautomation.com/t/change-power-chart-data-depending-on-dropdown-value/77380)
**Author:** [@Mario\_Olivares](https://forum.inductiveautomation.com/u/Mario_Olivares)\ **Replies:** 3\ **Last updated:** [August 3, 2023, 7:22pm UTC](https://forum.inductiveautomation.com/t/change-power-chart-data-depending-on-dropdown-value/77380 "2023-08-03T19:22:47Z")
Hello there everyone, I have been trying and I was wondering if it could be possible for the data displayed on a Power Chart to change depending of the selected option on a Dropdown Menu. The view design would be the fo… --- ## [Monitor OPC UA connection over time](https://forum.inductiveautomation.com/t/monitor-opc-ua-connection-over-time/77392)
**Author:** [@Liliya\_Boyadjieva](https://forum.inductiveautomation.com/u/Liliya_Boyadjieva)\ **Replies:** 0\ **Last updated:** [August 3, 2023, 6:42pm UTC](https://forum.inductiveautomation.com/t/monitor-opc-ua-connection-over-time/77392 "2023-08-03T18:42:18Z")
Our gateway is on version 8.1.17. Lately we've had an issue where a few tags that are supposed to always be latched on fall to 0 momentarily throughout the day and trigger an alarm. Tag History is enabled for those tags … --- ## [Loading Label/Bar](https://forum.inductiveautomation.com/t/loading-label-bar/77369)
**Author:** [@agriner](https://forum.inductiveautomation.com/u/agriner)\ **Replies:** 7\ **Last updated:** [August 3, 2023, 6:39pm UTC](https://forum.inductiveautomation.com/t/loading-label-bar/77369 "2023-08-03T18:39:18Z")
I have a table with a dataset that takes a while to build. There's not a great way to make the dataset load faster so I want to at least inform the user that it's loading. I created a 'Loading' label to appear at the beg… --- ## [Expression binding timer that counts up](https://forum.inductiveautomation.com/t/expression-binding-timer-that-counts-up/77381)
**Author:** [@pbg](https://forum.inductiveautomation.com/u/pbg)\ **Replies:** 2\ **Last updated:** [August 3, 2023, 6:15pm UTC](https://forum.inductiveautomation.com/t/expression-binding-timer-that-counts-up/77381 "2023-08-03T18:15:13Z")
Hi, I want a timer that counts upwards in the format minutes:seconds where seconds counts to 60 then resets to 00, 01, 02 and so on and minutes counts on indefinitely. I use two params, a startTime and currentTime. Right… --- ## [Cant see the tag set in the Set Tag Value script builder](https://forum.inductiveautomation.com/t/cant-see-the-tag-set-in-the-set-tag-value-script-builder/77382)
**Author:** [@fabiano.moreira.amar](https://forum.inductiveautomation.com/u/fabiano.moreira.amar)\ **Replies:** 2\ **Last updated:** [August 3, 2023, 6:03pm UTC](https://forum.inductiveautomation.com/t/cant-see-the-tag-set-in-the-set-tag-value-script-builder/77382 "2023-08-03T18:03:00Z")
I have a drop down list in a template, that shows me that it has a script in the project browser. I right click, go to scripting and see this message: This script was generated automatically by the tag set script builde… --- ## [Out of memory errors](https://forum.inductiveautomation.com/t/out-of-memory-errors/77378)
**Author:** [@elijah.roberts](https://forum.inductiveautomation.com/u/elijah.roberts)\ **Replies:** 9\ **Last updated:** [August 3, 2023, 5:18pm UTC](https://forum.inductiveautomation.com/t/out-of-memory-errors/77378 "2023-08-03T17:18:32Z")
Hello, I am working on a project and everything has been going fine the past month or so. I am running Ignition on a Docker instance and while I was in the designer last night everything started freezing up and my client… --- ## [Gateway script not inserting records in my table](https://forum.inductiveautomation.com/t/gateway-script-not-inserting-records-in-my-table/77305)
**Author:** [@Wendy\_Minai](https://forum.inductiveautomation.com/u/Wendy_Minai)\ **Replies:** 5\ **Last updated:** [August 3, 2023, 5:11pm UTC](https://forum.inductiveautomation.com/t/gateway-script-not-inserting-records-in-my-table/77305 "2023-08-03T17:11:35Z")
I am tring to insert records for previous\_efficiency into my table but only one row which is Twister 1 is inserting into the table. Is there something wrong Iam doing? if system.tag.readBlocking("\[default\]zzzTimezzz/Tw… --- ## [Saving excel file from script console and vision](https://forum.inductiveautomation.com/t/saving-excel-file-from-script-console-and-vision/77368)
**Author:** [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Replies:** 5\ **Last updated:** [August 3, 2023, 5:06pm UTC](https://forum.inductiveautomation.com/t/saving-excel-file-from-script-console-and-vision/77368 "2023-08-03T17:06:27Z")
ccc = \['a', 'b', 'c', 'd', 'g', 'k', 'm'\] fruits = \[\['apple', 'banana', 'cherry', 'date', 'grape', 'kiwi', 'mango'\]\] print ( str(len(ccc)) + ' ' + str(len(fruits))) datasetOut2 = system.dataset.toDataSet(ccc, fruit… --- ## [Trigger Report on Central Gateway from Edge Client](https://forum.inductiveautomation.com/t/trigger-report-on-central-gateway-from-edge-client/77044)
**Author:** [@Taylor\_Nankervis1](https://forum.inductiveautomation.com/u/Taylor_Nankervis1)\ **Replies:** 2\ **Last updated:** [August 3, 2023, 4:59pm UTC](https://forum.inductiveautomation.com/t/trigger-report-on-central-gateway-from-edge-client/77044 "2023-08-03T16:59:28Z")
Hello all, I am trying to find a clean way to execute the generation of a report on a central gateway server from a trigger originating from an Edge client project. All the data that will be used for the report is store… --- ## [Power chart pen control](https://forum.inductiveautomation.com/t/power-chart-pen-control/60932)
**Author:** [@NII](https://forum.inductiveautomation.com/u/NII)\ **Replies:** 9\ **Last updated:** [August 3, 2023, 4:35pm UTC](https://forum.inductiveautomation.com/t/power-chart-pen-control/60932 "2023-08-03T16:35:49Z")
Is there a way to prevent pen control from expanding? --- ## [Can a NamedQuery be embedded in another NamedQuery?](https://forum.inductiveautomation.com/t/can-a-namedquery-be-embedded-in-another-namedquery/77371)
**Author:** [@stan.cook](https://forum.inductiveautomation.com/u/stan.cook)\ **Replies:** 7\ **Last updated:** [August 3, 2023, 4:29pm UTC](https://forum.inductiveautomation.com/t/can-a-namedquery-be-embedded-in-another-namedquery/77371 "2023-08-03T16:29:52Z")
I have a named query "P" which produces a list of people. I want another query "W" which will produce a list of tasks that are owned by anyone in the list produced by query P. The P query is complicated enough that I d… --- ## [Gateway Time showing Client Time](https://forum.inductiveautomation.com/t/gateway-time-showing-client-time/77376)
**Author:** [@mcolson1590](https://forum.inductiveautomation.com/u/mcolson1590)\ **Replies:** 1\ **Last updated:** [August 3, 2023, 3:49pm UTC](https://forum.inductiveautomation.com/t/gateway-time-showing-client-time/77376 "2023-08-03T15:49:25Z")
Below is a screen shot I took showing the CurrentDateTime for a gateway. On the left is from a VNC session which I'm running designer directly on the Linux PC with the gateway installed (Ignition 8.1). On the right is … --- ## [411 Error using httpClient](https://forum.inductiveautomation.com/t/411-error-using-httpclient/77375)
**Author:** [@Brad\_Coble](https://forum.inductiveautomation.com/u/Brad_Coble)\ **Replies:** 4\ **Last updated:** [August 3, 2023, 3:42pm UTC](https://forum.inductiveautomation.com/t/411-error-using-httpclient/77375 "2023-08-03T15:42:27Z")
Hy, I am trying to retrieve XML data from a REST API. I am trying this via the script console. However, I am always getting a 411. The API documents tell me to use a POST and to pass in the username and password via pa… --- ## [system.db.runPrepQuery - Argument Syntax](https://forum.inductiveautomation.com/t/system-db-runprepquery-argument-syntax/59408)
**Author:** [@rwalters1](https://forum.inductiveautomation.com/u/rwalters1)\ **Replies:** 5\ **Last updated:** [August 3, 2023, 3:19pm UTC](https://forum.inductiveautomation.com/t/system-db-runprepquery-argument-syntax/59408 "2023-08-03T15:19:57Z")
Ignition / Vision: I have a Stored Function (PostgreSQL) that accepts an array of integers- The function executes as expected when called from pgAdmin as follows: SELECT \* FROM public.downtime\_record(1, 1000, ‘05/10/20… --- ## [How should I be calling database queries (INSERT) from tag changes events?](https://forum.inductiveautomation.com/t/how-should-i-be-calling-database-queries-insert-from-tag-changes-events/77327)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 5\ **Last updated:** [August 3, 2023, 2:10pm UTC](https://forum.inductiveautomation.com/t/how-should-i-be-calling-database-queries-insert-from-tag-changes-events/77327 "2023-08-03T14:10:57Z")
I know tag change event scripts shouldn't run for longer than a handful of ms, so direct database queries are out of the question. But what other methods should I use to call database queries, specifically INSERT stateme… --- ## [Datetime with T](https://forum.inductiveautomation.com/t/datetime-with-t/77321)
**Author:** [@Babla\_Bogam](https://forum.inductiveautomation.com/u/Babla_Bogam)\ **Replies:** 12\ **Last updated:** [August 3, 2023, 2:05pm UTC](https://forum.inductiveautomation.com/t/datetime-with-t/77321 "2023-08-03T14:05:32Z")
I am sending an API request to an external app. The API is returning an object with a date property that is a string in the format for example - 2023-08-02T23:05:52.187 I am not able to convert that datetime to a local … --- ## [PTZ Outdoor Camera that will work with Perspective](https://forum.inductiveautomation.com/t/ptz-outdoor-camera-that-will-work-with-perspective/77365)
**Author:** [@dhananjay\_vichare](https://forum.inductiveautomation.com/u/dhananjay_vichare)\ **Replies:** 0\ **Last updated:** [August 3, 2023, 1:50pm UTC](https://forum.inductiveautomation.com/t/ptz-outdoor-camera-that-will-work-with-perspective/77365 "2023-08-03T13:50:03Z")
One of our clients want to remotely monitor their plant premises for intrusions. Hence we would like to suggest camera which will work with Perspective. Could anyone help me to suggest solution with PTZ Outdoor Camera t… --- ## [Count Numbers of popup open on a view](https://forum.inductiveautomation.com/t/count-numbers-of-popup-open-on-a-view/77274)
**Author:** [@sebastien\_ng](https://forum.inductiveautomation.com/u/sebastien_ng)\ **Replies:** 4\ **Last updated:** [August 3, 2023, 8:28am UTC](https://forum.inductiveautomation.com/t/count-numbers-of-popup-open-on-a-view/77274 "2023-08-03T08:28:22Z")
Hello, I have a view where I have many webcams. The PopupId is diferent for each webcam. When I click on each webcam, a popup is open. The problem is if I click on 10 webcams, that is mean 10 popup will be open. But w… --- ## [Changing Power Chart Pen Legend Style Properties](https://forum.inductiveautomation.com/t/changing-power-chart-pen-legend-style-properties/77323)
**Author:** [@Dhrupal\_Patel](https://forum.inductiveautomation.com/u/Dhrupal_Patel)\ **Replies:** 0\ **Last updated:** [August 3, 2023, 1:12am UTC](https://forum.inductiveautomation.com/t/changing-power-chart-pen-legend-style-properties/77323 "2023-08-03T01:12:26Z")
I am having trouble locating the exact property only to change the font color for the pen legend. Whenever I inspect the style it seems to default to the project's default light-cool theme. How can I override this chart … --- ## [Disable auto gateway start on MacOS?](https://forum.inductiveautomation.com/t/disable-auto-gateway-start-on-macos/77319)
**Author:** [@pdixon](https://forum.inductiveautomation.com/u/pdixon)\ **Replies:** 3\ **Last updated:** [August 2, 2023, 10:07pm UTC](https://forum.inductiveautomation.com/t/disable-auto-gateway-start-on-macos/77319 "2023-08-02T22:07:49Z")
How do I not autostart the Ignition gateway on MacOS? I saw the Java service was a big impact on memory and CPU. I traced the processes and found it was Ignition running the Java service: I do not always use the Ig… --- ## [How can I toggle a Boolean tag when String changes in the Text Field?](https://forum.inductiveautomation.com/t/how-can-i-toggle-a-boolean-tag-when-string-changes-in-the-text-field/77315)
**Author:** [@Shirshak\_Chhetri](https://forum.inductiveautomation.com/u/Shirshak_Chhetri)\ **Replies:** 12\ **Last updated:** [August 2, 2023, 9:54pm UTC](https://forum.inductiveautomation.com/t/how-can-i-toggle-a-boolean-tag-when-string-changes-in-the-text-field/77315 "2023-08-02T21:54:41Z")
Hello, I have been trying to get the value of a Boolean Tag to turn on momentarily when String changes in the text field. I have tried out couple scripts on property change handler of the Text Field but none seem to work… --- ## [Catching exception in webdev doPost](https://forum.inductiveautomation.com/t/catching-exception-in-webdev-dopost/77318)
**Author:** [@wpmccormick](https://forum.inductiveautomation.com/u/wpmccormick)\ **Replies:** 4\ **Last updated:** [August 2, 2023, 9:48pm UTC](https://forum.inductiveautomation.com/t/catching-exception-in-webdev-dopost/77318 "2023-08-02T21:48:52Z")
I have a try/except block inside a for loop on a doPost. A named query is executed for each element inside the loop. If there is an exception, I catch it and continue to try the next element. Since the try/except is in… --- ## [Time Series Chart doesn't update value](https://forum.inductiveautomation.com/t/time-series-chart-doesnt-update-value/77317)
**Author:** [@Mario\_Olivares](https://forum.inductiveautomation.com/u/Mario_Olivares)\ **Replies:** 4\ **Last updated:** [August 2, 2023, 9:37pm UTC](https://forum.inductiveautomation.com/t/time-series-chart-doesnt-update-value/77317 "2023-08-02T21:37:56Z")
Hello there everyone, Lately I have been experiencing some problems with the Time Series Chart. The thing is, that the data of the chart doesn't update, even if the tag that has been binded to clearly updates. For inst… --- ## [Making use of the MongoDB connector and the data type "class java.util.ArrayList" efficiently](https://forum.inductiveautomation.com/t/making-use-of-the-mongodb-connector-and-the-data-type-class-java-util-arraylist-efficiently/76973)
**Author:** [@Johnathan\_Garcia](https://forum.inductiveautomation.com/u/Johnathan_Garcia)\ **Replies:** 9\ **Last updated:** [August 2, 2023, 9:07pm UTC](https://forum.inductiveautomation.com/t/making-use-of-the-mongodb-connector-and-the-data-type-class-java-util-arraylist-efficiently/76973 "2023-08-02T21:07:50Z")
I will start off and say that I am a novice at scripting, in general. We recently purchased a license for Ignition 8.1 and we have great big plans for it but first, we must crawl before we can run. With that being said,… --- ## [Alarm Journal not working on every client](https://forum.inductiveautomation.com/t/alarm-journal-not-working-on-every-client/76846)
**Author:** [@Thomas\_Gastaldi](https://forum.inductiveautomation.com/u/Thomas_Gastaldi)\ **Replies:** 3\ **Last updated:** [August 2, 2023, 8:41pm UTC](https://forum.inductiveautomation.com/t/alarm-journal-not-working-on-every-client/76846 "2023-08-02T20:41:57Z")
Hello to everyone, I have a problem with the journal component. I use that inside three different scada projects. Same alarm journal and same components. I noticed that if I place it inside one of the three projects th… --- ## [Perspective - Table Columns with Sub Keys](https://forum.inductiveautomation.com/t/perspective-table-columns-with-sub-keys/77310)
**Author:** [@j.israelsen](https://forum.inductiveautomation.com/u/j.israelsen)\ **Replies:** 6\ **Last updated:** [August 2, 2023, 8:24pm UTC](https://forum.inductiveautomation.com/t/perspective-table-columns-with-sub-keys/77310 "2023-08-02T20:24:31Z")
Utilizing Perspective, let's say I have data in the following form (an array of dictionaries with sub-dictionaries): \[ { "value1": "value", "sub\_dict": { "value2": "value", "value3": "value" } }, { "value1": "… --- ## [Address mapping for DL05 PLC](https://forum.inductiveautomation.com/t/address-mapping-for-dl05-plc/25905)
**Author:** [@kdans](https://forum.inductiveautomation.com/u/kdans)\ **Replies:** 13\ **Last updated:** [August 2, 2023, 8:13pm UTC](https://forum.inductiveautomation.com/t/address-mapping-for-dl05-plc/25905 "2023-08-02T20:13:42Z")
I have a DL05 PLC that I would like to add to my OPC UA Devices. I was hoping to get some help with address mapping as I am very new to Ignition and using PLCs. This is what I have setup so far… I am still looking for … --- ## [Designer Default Settings](https://forum.inductiveautomation.com/t/designer-default-settings/77219)
**Author:** [@James\_Summers](https://forum.inductiveautomation.com/u/James_Summers)\ **Replies:** 3\ **Last updated:** [August 2, 2023, 7:48pm UTC](https://forum.inductiveautomation.com/t/designer-default-settings/77219 "2023-08-02T19:48:28Z")
HI Everyone Does anyone know if there is a way to change the default step duration time for custom style animation? I want stuff to blink for 500 ms. It would be so much easier if I could just change this once instead … [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=595) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=597)