# Ignition

**URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=758

[Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md)

**Page:** 759

---

## [Load Balancer SSL issues](https://forum.inductiveautomation.com/t/load-balancer-ssl-issues/65612)

<div class="topic-metadata">

**Author:** [@cvanremoortel](https://forum.inductiveautomation.com/u/cvanremoortel)\
**Replies:** 2\
**Last updated:** [October 26, 2022, 10:13pm UTC](https://forum.inductiveautomation.com/t/load-balancer-ssl-issues/65612 "2022-10-26T22:13:55Z")

</div>

Our customer has set up a load balancer between a Perspective gateway in an IDMZ and their corporate network. The LB receives traffic on 443 and forwards to the gateway at port 8088. Projects that do not have security e…

---

## [Add date and time value into email containing html](https://forum.inductiveautomation.com/t/add-date-and-time-value-into-email-containing-html/65728)

<div class="topic-metadata">

**Author:** [@michael.black](https://forum.inductiveautomation.com/u/michael.black)\
**Replies:** 2\
**Last updated:** [October 26, 2022, 9:22pm UTC](https://forum.inductiveautomation.com/t/add-date-and-time-value-into-email-containing-html/65728 "2022-10-26T21:22:46Z")

</div>

I am sending an email containing a few html tables and have some sentences in html included in the email before the tables. I want to include current time and date formatted and then inserted into my html code. How wou…

---

## [\[Repository\] Gateway Utilities](https://forum.inductiveautomation.com/t/repository-gateway-utilities/65623)

<div class="topic-metadata">

**Author:** [@kgamble](https://forum.inductiveautomation.com/u/kgamble)\
**Replies:** 1\
**Last updated:** [October 26, 2022, 9:13pm UTC](https://forum.inductiveautomation.com/t/repository-gateway-utilities/65623 "2022-10-26T21:13:50Z")

</div>

I started putting together some reusable scripts, and I thought I would share with the community. This project contains some utilities that can help in the development and administration of some Ignition projects. I a…

---

## [Tag Historical data - frequency and duration of tag values](https://forum.inductiveautomation.com/t/tag-historical-data-frequency-and-duration-of-tag-values/65667)

<div class="topic-metadata">

**Author:** [@Zach\_Stewart](https://forum.inductiveautomation.com/u/Zach_Stewart)\
**Replies:** 16\
**Last updated:** [October 26, 2022, 9:09pm UTC](https://forum.inductiveautomation.com/t/tag-historical-data-frequency-and-duration-of-tag-values/65667 "2022-10-26T21:09:20Z")

</div>

Here is the dilemma... I am pulling data from PLC for a state code for example...1002 = RN-High...3038 = DN - Servo Machine Open Selector...etc I created an expression tag using switch statements to give the descriptio…

---

## [Nested Query Tag Historian Report - Returning First Row](https://forum.inductiveautomation.com/t/nested-query-tag-historian-report-returning-first-row/65727)

<div class="topic-metadata">

**Author:** [@alainia.spencer](https://forum.inductiveautomation.com/u/alainia.spencer)\
**Replies:** 6\
**Last updated:** [October 26, 2022, 8:50pm UTC](https://forum.inductiveautomation.com/t/nested-query-tag-historian-report-returning-first-row/65727 "2022-10-26T20:50:19Z")

</div>

I'm working on building a report to export tag history values for a given time frame. When I run the report, only the first line shows up, however, if I look at the preview, I can see the timestamps and history. What am …

---

## [Passing a nested UDT 'parent data type' as a parameter to create dynamic children UDTs](https://forum.inductiveautomation.com/t/passing-a-nested-udt-parent-data-type-as-a-parameter-to-create-dynamic-children-udts/45836)

<div class="topic-metadata">

**Author:** [@tmahaffey](https://forum.inductiveautomation.com/u/tmahaffey)\
**Replies:** 2\
**Last updated:** [October 26, 2022, 7:52pm UTC](https://forum.inductiveautomation.com/t/passing-a-nested-udt-parent-data-type-as-a-parameter-to-create-dynamic-children-udts/45836 "2022-10-26T19:52:41Z")

</div>

I think this should work. I have a nested UDT. The parent UDT has a param called “Station\_Path”, and I copied the path of the UDT I want into the value for this param. But, the tag browser doesn’t jive, it just gives me …

---

## [Unable to catch exception in java.lang.Thread](https://forum.inductiveautomation.com/t/unable-to-catch-exception-in-java-lang-thread/65712)

<div class="topic-metadata">

**Author:** [@kgamble](https://forum.inductiveautomation.com/u/kgamble)\
**Replies:** 5\
**Last updated:** [October 26, 2022, 7:06pm UTC](https://forum.inductiveautomation.com/t/unable-to-catch-exception-in-java-lang-thread/65712 "2022-10-26T19:06:05Z")

</div>

I have been messing with this for a while, and can't seem to figure out what I am missing. I am trying to catch exceptions in a pool of async threads, so that I can handle them appropriately. Unfortunately no mater wha…

---

## [Make soft plot using Power Chart](https://forum.inductiveautomation.com/t/make-soft-plot-using-power-chart/65716)

<div class="topic-metadata">

**Author:** [@Jesus\_Perez](https://forum.inductiveautomation.com/u/Jesus_Perez)\
**Replies:** 3\
**Last updated:** [October 26, 2022, 7:03pm UTC](https://forum.inductiveautomation.com/t/make-soft-plot-using-power-chart/65716 "2022-10-26T19:03:28Z")

</div>

HI, im trying to plat some signal using power chart but i see like steps since i am using the basis cuve mode, please i need to graph the start and stop of and engine

---

## [sendMessage from transform script in perspective](https://forum.inductiveautomation.com/t/sendmessage-from-transform-script-in-perspective/65635)

<div class="topic-metadata">

**Author:** [@user66](https://forum.inductiveautomation.com/u/user66)\
**Replies:** 5\
**Last updated:** [October 26, 2022, 4:06pm UTC](https://forum.inductiveautomation.com/t/sendmessage-from-transform-script-in-perspective/65635 "2022-10-26T16:06:44Z")

</div>

Hi all, I'm trying to use system.perspective.sendMessage() from transform script that is made from property binding on component. I'm unable to call the messageHandler after several attempts. I'm I doing something wron…

---

## [Write a value to Master UDT Parameter](https://forum.inductiveautomation.com/t/write-a-value-to-master-udt-parameter/37234)

<div class="topic-metadata">

**Author:** [@suram-in](https://forum.inductiveautomation.com/u/suram-in)\
**Replies:** 5\
**Last updated:** [October 26, 2022, 3:00pm UTC](https://forum.inductiveautomation.com/t/write-a-value-to-master-udt-parameter/37234 "2022-10-26T15:00:27Z")

</div>

Hi All, I am using Ignition Version 8.0.15. I want to write a Value to a Master UDT parameter from a Tag. Thanks in Advance, Suresh

---

## [system.dataset.filterColumns](https://forum.inductiveautomation.com/t/system-dataset-filtercolumns/65707)

<div class="topic-metadata">

**Author:** [@theo](https://forum.inductiveautomation.com/u/theo)\
**Replies:** 7\
**Last updated:** [October 26, 2022, 2:40pm UTC](https://forum.inductiveautomation.com/t/system-dataset-filtercolumns/65707 "2022-10-26T14:40:06Z")

</div>

Hi all, I want to filter my dataset by using a dropdown list in a binding script the problem is when get the value from my dropdown list and I do the filter on the dataset it gave me an error the dataset : dataset…

---

## [Webdev example project](https://forum.inductiveautomation.com/t/webdev-example-project/65690)

<div class="topic-metadata">

**Author:** [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\
**Replies:** 1\
**Last updated:** [October 26, 2022, 1:56pm UTC](https://forum.inductiveautomation.com/t/webdev-example-project/65690 "2022-10-26T13:56:53Z")

</div>

Hi, I am interested in using webdev module to develop some customized webpages. I still want to use ignition tag database, ignition web server, basically I would like to fully utilize ignition gateway as backend, but w…

---

## [Table Props Pager Params: selectedOption?, optionsIndex?](https://forum.inductiveautomation.com/t/table-props-pager-params-selectedoption-optionsindex/56932)

<div class="topic-metadata">

**Author:** [@Sean\_Tesch](https://forum.inductiveautomation.com/u/Sean_Tesch)\
**Replies:** 3\
**Last updated:** [October 26, 2022, 1:30pm UTC](https://forum.inductiveautomation.com/t/table-props-pager-params-selectedoption-optionsindex/56932 "2022-10-26T13:30:12Z")

</div>

Hello, Within the Pager property params, I don’t see any params for options such as: ‘selectedOption’ or ‘optionIndex’. Is there any way to access the values for said example param(s) or any workarounds to get the va…

---

## [Delete value on the tag dataset](https://forum.inductiveautomation.com/t/delete-value-on-the-tag-dataset/65653)

<div class="topic-metadata">

**Author:** [@sebastien\_ng](https://forum.inductiveautomation.com/u/sebastien_ng)\
**Replies:** 11\
**Last updated:** [October 26, 2022, 1:06pm UTC](https://forum.inductiveautomation.com/t/delete-value-on-the-tag-dataset/65653 "2022-10-26T13:06:22Z")

</div>

if I want to remove the number 20 for example in the dataset of type 4x1 NameColumn 30 20 12 10 I use this line of code: dsDevice = self.view.params.listZoneDesservies # dataset dsDevice = system.dataset.deleteRo…

---

## [CTE's in Ignition SQL Queries throwing update errors](https://forum.inductiveautomation.com/t/ctes-in-ignition-sql-queries-throwing-update-errors/65685)

<div class="topic-metadata">

**Author:** [@Hayes\_Bentley](https://forum.inductiveautomation.com/u/Hayes_Bentley)\
**Replies:** 3\
**Last updated:** [October 26, 2022, 1:03pm UTC](https://forum.inductiveautomation.com/t/ctes-in-ignition-sql-queries-throwing-update-errors/65685 "2022-10-26T13:03:33Z")

</div>

Is there limited functionality writing SQL queries using CTE's? Whenever I use CTE's, Ignition thinks I am trying to run an update statement, when in actuality I am trying to access data in my CTE. Thanks!

---

## [AWS s3 bucket data to Ignition](https://forum.inductiveautomation.com/t/aws-s3-bucket-data-to-ignition/65703)

<div class="topic-metadata">

**Author:** [@Benjamin\_Goethler](https://forum.inductiveautomation.com/u/Benjamin_Goethler)\
**Replies:** 1\
**Last updated:** [October 26, 2022, 1:01pm UTC](https://forum.inductiveautomation.com/t/aws-s3-bucket-data-to-ignition/65703 "2022-10-26T13:01:26Z")

</div>

Hi Inductive Automation, I am a bit lost on how to get data from my AWS S3 bucket into Ignition, such that I can make a dashboard of the data inside Ignition. Anyone knows a guide or can point me in the direction of so…

---

## [Drag and drop from Tree View to List](https://forum.inductiveautomation.com/t/drag-and-drop-from-tree-view-to-list/65479)

<div class="topic-metadata">

**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\
**Replies:** 3\
**Last updated:** [October 26, 2022, 10:06am UTC](https://forum.inductiveautomation.com/t/drag-and-drop-from-tree-view-to-list/65479 "2022-10-26T10:06:42Z")

</div>

Hi, I am trying to drag and drop from tree view to list example image Script i am using in tree view in mouse pressed from java.awt.dnd import DragSource,DragGestureListener from java.awt.dnd import DragSourceListe…

---

## [Gateway User Review](https://forum.inductiveautomation.com/t/gateway-user-review/65695)

<div class="topic-metadata">

**Author:** [@julien.rouillard](https://forum.inductiveautomation.com/u/julien.rouillard)\
**Replies:** 2\
**Last updated:** [October 26, 2022, 7:47am UTC](https://forum.inductiveautomation.com/t/gateway-user-review/65695 "2022-10-26T07:47:03Z")

</div>

Hello, I would like to implement a user access review on our ignition gateways. Is there any way to display, extract or interface the full list of users with their roles? Thank you Regards Julien Rouillard

---

## [Perspective xy chart scroll](https://forum.inductiveautomation.com/t/perspective-xy-chart-scroll/51892)

<div class="topic-metadata">

**Author:** [@gfeiten](https://forum.inductiveautomation.com/u/gfeiten)\
**Replies:** 5\
**Last updated:** [October 26, 2022, 6:54am UTC](https://forum.inductiveautomation.com/t/perspective-xy-chart-scroll/51892 "2022-10-26T06:54:10Z")

</div>

I would like a chart to display the last 7 days of data, with the ability to scroll further back in time. I am guessing this is what the scrollBars property is for? If I am wasting my time please let me know, otherwise…

---

## [Mouse enter event in Numeric text field](https://forum.inductiveautomation.com/t/mouse-enter-event-in-numeric-text-field/65562)

<div class="topic-metadata">

**Author:** [@Dharani\_T](https://forum.inductiveautomation.com/u/Dharani_T)\
**Replies:** 10\
**Last updated:** [October 26, 2022, 6:09am UTC](https://forum.inductiveautomation.com/t/mouse-enter-event-in-numeric-text-field/65562 "2022-10-26T06:09:03Z")

</div>

Hi, I would like to have a screen in which user can select a process and then a popup appears in which user can enter the target qty for today and tomorrow. Script used in Upload screen (vision window open event): tm…

---

## [UDT parameters writing at runtime (bulk tag editing)](https://forum.inductiveautomation.com/t/udt-parameters-writing-at-runtime-bulk-tag-editing/19952)

<div class="topic-metadata">

**Author:** [@Andrew\_P](https://forum.inductiveautomation.com/u/Andrew_P)\
**Replies:** 9\
**Last updated:** [October 26, 2022, 4:36am UTC](https://forum.inductiveautomation.com/t/udt-parameters-writing-at-runtime-bulk-tag-editing/19952 "2022-10-26T04:36:32Z")

</div>

Is there any way to programatically change UDT parameters that belong to UDTs within parent UDTs? I have tried system.tag.editTags but i am pretty sure this has a bug for this specific circumstance based on my testing, …

---

## [Perspective Custom style attributes](https://forum.inductiveautomation.com/t/perspective-custom-style-attributes/65687)

<div class="topic-metadata">

**Author:** [@David\_Stone](https://forum.inductiveautomation.com/u/David_Stone)\
**Replies:** 2\
**Last updated:** [October 26, 2022, 1:58am UTC](https://forum.inductiveautomation.com/t/perspective-custom-style-attributes/65687 "2022-10-26T01:58:31Z")

</div>

Is there any way of adding custom CSS values to a style in Perspective? We are constantly having to individually add a value and key pair to the style section of an object. "vector-effect": "non-scaling-stroke" Obviou…

---

## [Named Query renaming from "Query\_Name" to "Query\_Name (1)"](https://forum.inductiveautomation.com/t/named-query-renaming-from-query-name-to-query-name-1/65498)

<div class="topic-metadata">

**Author:** [@Joel\_Farley](https://forum.inductiveautomation.com/u/Joel_Farley)\
**Replies:** 2\
**Last updated:** [October 25, 2022, 11:22pm UTC](https://forum.inductiveautomation.com/t/named-query-renaming-from-query-name-to-query-name-1/65498 "2022-10-25T23:22:01Z")

</div>

Seen this happen a couple of times (8.1.19), not sure what could have caused it. Only noticed when the binding that was looking for it broke. Has anyone else had this happen as well? Thanks

---

## [\[BUG\] Power Chart filtered tag browser start path takes ~1min to find results](https://forum.inductiveautomation.com/t/bug-power-chart-filtered-tag-browser-start-path-takes-1min-to-find-results/65492)

<div class="topic-metadata">

**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Replies:** 2\
**Last updated:** [October 25, 2022, 10:55pm UTC](https://forum.inductiveautomation.com/t/bug-power-chart-filtered-tag-browser-start-path-takes-1min-to-find-results/65492 "2022-10-25T22:55:09Z")

</div>

v8.1.21 I've set a tag browser start path, and it takes almost a minute (51.4s) in a client and the designer for any results to actually show up. I've set the config.tagBrowserStartPath as histprov:SQLServer:/drv:\<ga…

---

## [Expression binding referencing tab index only working after tab is changed](https://forum.inductiveautomation.com/t/expression-binding-referencing-tab-index-only-working-after-tab-is-changed/65644)

<div class="topic-metadata">

**Author:** [@ASF](https://forum.inductiveautomation.com/u/ASF)\
**Replies:** 4\
**Last updated:** [October 25, 2022, 10:27pm UTC](https://forum.inductiveautomation.com/t/expression-binding-referencing-tab-index-only-working-after-tab-is-changed/65644 "2022-10-25T22:27:55Z")

</div>

I have a view which contains (among other things), two embedded views. I will refer to the view as the "host" view for lack of a better term. The first embedded view has in it a tab container, and an output parameter cal…

---

## [SQL CTE Not Returning Results](https://forum.inductiveautomation.com/t/sql-cte-not-returning-results/36942)

<div class="topic-metadata">

**Author:** [@cmaynes](https://forum.inductiveautomation.com/u/cmaynes)\
**Replies:** 3\
**Last updated:** [October 25, 2022, 10:08pm UTC](https://forum.inductiveautomation.com/t/sql-cte-not-returning-results/36942 "2022-10-25T22:08:37Z")

</div>

I have the following query to my database. The query returns a result set with a few rows in SSMS, but no rows are returned in Ignition. Thoughts? q = \\ """ WITH Hierarchy (PersonId, Username, LastName, FirstName, AD…

---

## [OPC Disconnects and long read/write periods](https://forum.inductiveautomation.com/t/opc-disconnects-and-long-read-write-periods/65545)

<div class="topic-metadata">

**Author:** [@Tyler\_Earl](https://forum.inductiveautomation.com/u/Tyler_Earl)\
**Replies:** 40\
**Last updated:** [October 25, 2022, 9:40pm UTC](https://forum.inductiveautomation.com/t/opc-disconnects-and-long-read-write-periods/65545 "2022-10-25T21:40:25Z")

</div>

Brief backstory: About 4 years ago we developed an MES system using Ignition. It was developed solely by one guy, who is not with our company anymore. Within the past 2-3 months we've been having lots of problems with O…

---

## [Corrupted SMS notifications, odd blend of notification content for different events, across different pipelines and rosters](https://forum.inductiveautomation.com/t/corrupted-sms-notifications-odd-blend-of-notification-content-for-different-events-across-different-pipelines-and-rosters/65535)

<div class="topic-metadata">

**Author:** [@tyler.bennett](https://forum.inductiveautomation.com/u/tyler.bennett)\
**Replies:** 1\
**Last updated:** [October 25, 2022, 9:12pm UTC](https://forum.inductiveautomation.com/t/corrupted-sms-notifications-odd-blend-of-notification-content-for-different-events-across-different-pipelines-and-rosters/65535 "2022-10-25T21:12:09Z")

</div>

Has anyone else heard of or dealt with strange corruption of Twilio SMS event notifications? Ignition v8.1.18 Twilio Integration and Alarm Notification module Our preliminary investigation suggests that some notificat…

---

## [Ignition - an audit journal](https://forum.inductiveautomation.com/t/ignition-an-audit-journal/65104)

<div class="topic-metadata">

**Author:** [@Alex\_Verba](https://forum.inductiveautomation.com/u/Alex_Verba)\
**Replies:** 2\
**Last updated:** [October 25, 2022, 8:33pm UTC](https://forum.inductiveautomation.com/t/ignition-an-audit-journal/65104 "2022-10-25T20:33:24Z")

</div>

Hello everyone! Please, help how to activate an audit journal which reflects administrator actions in the system. For example, who and when changed the users roles, tags settings and so on. I found only a solurion whic…

---

## [How complex can an expression tag practically be?](https://forum.inductiveautomation.com/t/how-complex-can-an-expression-tag-practically-be/60229)

<div class="topic-metadata">

**Author:** [@justin.brzozoski](https://forum.inductiveautomation.com/u/justin.brzozoski)\
**Replies:** 13\
**Last updated:** [October 25, 2022, 8:02pm UTC](https://forum.inductiveautomation.com/t/how-complex-can-an-expression-tag-practically-be/60229 "2022-10-25T20:02:00Z")

</div>

We have a lot of sensors being pulled in from modbus and reported over Sparkplug via (unfortunately intermittent) cellular connections. We want to monitor how many are getting actual modbus errors and haven’t just fallen…

[Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=757)

[Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=759)
