# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=599 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 600 --- ## [Comment Panel with nested SQL](https://forum.inductiveautomation.com/t/comment-panel-with-nested-sql/77424)
**Author:** [@kamiel\_naeye](https://forum.inductiveautomation.com/u/kamiel_naeye)\ **Replies:** 3\ **Last updated:** [August 4, 2023, 1:14pm UTC](https://forum.inductiveautomation.com/t/comment-panel-with-nested-sql/77424 "2023-08-04T13:14:45Z")
hi, I have a question about nesting multiple query tables into one. I followed the manual for the 3 table configuration and it works with 2 tables Notes and users. But now i want to add the 3rth table adding the possibi… --- ## [Tag counts from gateway status page](https://forum.inductiveautomation.com/t/tag-counts-from-gateway-status-page/77423)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 1\ **Last updated:** [August 4, 2023, 12:50pm UTC](https://forum.inductiveautomation.com/t/tag-counts-from-gateway-status-page/77423 "2023-08-04T12:50:41Z")
I just wrote a script utilising the tag report function to summarise the tags at a site, and am seeing significant differences between the numbers produced by the reporting tool and by the numbers in the "realtime provid… --- ## [Project Browser Collapsing on Project Save](https://forum.inductiveautomation.com/t/project-browser-collapsing-on-project-save/9351)
**Author:** [@jimmylooo](https://forum.inductiveautomation.com/u/jimmylooo)\ **Replies:** 10\ **Last updated:** [August 4, 2023, 12:24pm UTC](https://forum.inductiveautomation.com/t/project-browser-collapsing-on-project-save/9351 "2023-08-04T12:24:34Z")
Very annoying that the project browser collapses the tree when ever you save the project. Would be very nice if this did not happen. Can this be fixed? Thanks! --- ## [Ignition Perspective HttpGet Locking File](https://forum.inductiveautomation.com/t/ignition-perspective-httpget-locking-file/77402)
**Author:** [@Brad\_Gilliam](https://forum.inductiveautomation.com/u/Brad_Gilliam)\ **Replies:** 5\ **Last updated:** [August 4, 2023, 12:22pm UTC](https://forum.inductiveautomation.com/t/ignition-perspective-httpget-locking-file/77402 "2023-08-04T12:22:52Z")
Hello, I am trying to read a text file from the Gateway server and then parse that text file to then dynamic set some image path that are also located on the server. Currently I'm using system.net.httpGet where the URL… --- ## [Bounds issue with Numeric Text Field/ Bounds do not work in Vision client](https://forum.inductiveautomation.com/t/bounds-issue-with-numeric-text-field-bounds-do-not-work-in-vision-client/77419)
**Author:** [@Gregor\_Hocevar](https://forum.inductiveautomation.com/u/Gregor_Hocevar)\ **Replies:** 14\ **Last updated:** [August 4, 2023, 10:53am UTC](https://forum.inductiveautomation.com/t/bounds-issue-with-numeric-text-field-bounds-do-not-work-in-vision-client/77419 "2023-08-04T10:53:02Z")
I would like to use the out-of-bounds function in the ignition SCADA. This function is working in the Ignition Designer Launcher but not in the Vision Client Launcher. Does someone have an idea where the problem is? … --- ## [Converting a dataset with system.dataset.toDataSet changes date to integer](https://forum.inductiveautomation.com/t/converting-a-dataset-with-system-dataset-todataset-changes-date-to-integer/77326)
**Author:** [@r123](https://forum.inductiveautomation.com/u/r123)\ **Replies:** 14\ **Last updated:** [August 4, 2023, 9:31am UTC](https://forum.inductiveautomation.com/t/converting-a-dataset-with-system-dataset-todataset-changes-date-to-integer/77326 "2023-08-04T09:31:16Z")
I'd like the date to be something like "2023-07-21T02:00:00Z" in the dataset. At first I thought it needed to be converted like this but that caused errors like it already was. import datetime your\_timestamp = 16909122… --- ## [MS Azure IDP Help](https://forum.inductiveautomation.com/t/ms-azure-idp-help/51467)
**Author:** [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\ **Replies:** 7\ **Last updated:** [August 4, 2023, 9:06am UTC](https://forum.inductiveautomation.com/t/ms-azure-idp-help/51467 "2023-08-04T09:06:22Z")
Setting up my first non Ignition IDP for a project. The customer is using the Azure SAML IDP. Ignition version is 8.1.7 We have everything setup in the gateway, and when I test the login from the gateway I get the fol… --- ## [Auth Identity Provider - Invalid cookie header: "Set-Cookie](https://forum.inductiveautomation.com/t/auth-identity-provider-invalid-cookie-header-set-cookie/77331)
**Author:** [@Learner\_Ignition](https://forum.inductiveautomation.com/u/Learner_Ignition)\ **Replies:** 3\ **Last updated:** [August 4, 2023, 8:13am UTC](https://forum.inductiveautomation.com/t/auth-identity-provider-invalid-cookie-header-set-cookie/77331 "2023-08-04T08:13:16Z")
Hi, I am trying Auth as Identity Provider, Configure everything in Identity provider and in project properties set security to Auth identity provider and perspective permission set to Authenticated. When I do test logi… --- ## [Error While launching the vission,](https://forum.inductiveautomation.com/t/error-while-launching-the-vission/77427)
**Author:** [@Adarsh\_Shelar](https://forum.inductiveautomation.com/u/Adarsh_Shelar)\ **Replies:** 2\ **Last updated:** [August 4, 2023, 6:48am UTC](https://forum.inductiveautomation.com/t/error-while-launching-the-vission/77427 "2023-08-04T06:48:49Z")
HI all, This Following error is getting the while Launching the Vision Client Application so what are Possible way to Resolve this Issue? Thank you :dizzy: --- ## [Voice Alarm Module Register](https://forum.inductiveautomation.com/t/voice-alarm-module-register/77412)
**Author:** [@LEI\_ZHU](https://forum.inductiveautomation.com/u/LEI_ZHU)\ **Replies:** 1\ **Last updated:** [August 4, 2023, 3:00am UTC](https://forum.inductiveautomation.com/t/voice-alarm-module-register/77412 "2023-08-04T03:00:03Z")
Can we use other communication system to register Voice Alarm Module besides cisco CUCM? And how can voice module support other languages such as Japanese and Chinese (We have factorys there)？ --- ## [Converting a dataset into a JSON file format for the flex repeater](https://forum.inductiveautomation.com/t/converting-a-dataset-into-a-json-file-format-for-the-flex-repeater/77391)
**Author:** [@Mike\_Zylla](https://forum.inductiveautomation.com/u/Mike_Zylla)\ **Replies:** 20\ **Last updated:** [August 4, 2023, 1:27am UTC](https://forum.inductiveautomation.com/t/converting-a-dataset-into-a-json-file-format-for-the-flex-repeater/77391 "2023-08-04T01:27:10Z")
Hello, I have a dataset that i am first pulling from SQL, adding a column from a tag read, and then sorting. I want to get this into the Flex Repeater on perspective to allow it to show a view for every piece of equipm… --- ## [User Schedules with Active Directory](https://forum.inductiveautomation.com/t/user-schedules-with-active-directory/33017)
**Author:** [@dan123](https://forum.inductiveautomation.com/u/dan123)\ **Replies:** 10\ **Last updated:** [August 3, 2023, 9:16pm UTC](https://forum.inductiveautomation.com/t/user-schedules-with-active-directory/33017 "2023-08-03T21:16:46Z")
Starting a new topic, because this one has been out there for a few years now with no solution. How are user schedules defined with an Active Directory user source? When looking at ‘manage users’ there is a field for ‘… --- ## [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 … [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=598) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=600)