# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=883 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 884 --- ## [\[SOLVED\] Is there a property available to modify the width of the PieChart in ring mode?](https://forum.inductiveautomation.com/t/solved-is-there-a-property-available-to-modify-the-width-of-the-piechart-in-ring-mode/56687)
**Author:** [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Replies:** 5\ **Last updated:** [March 2, 2022, 3:58pm UTC](https://forum.inductiveautomation.com/t/solved-is-there-a-property-available-to-modify-the-width-of-the-piechart-in-ring-mode/56687 "2022-03-02T15:58:56Z")
I have this code running on a PieChart. It makes my PieChart look like this: Is there a similar property in java that allows me to modify the thickness of the ring? Is there a way to view all properties available t… --- ## [Issue in table row delete perspective](https://forum.inductiveautomation.com/t/issue-in-table-row-delete-perspective/56721)
**Author:** [@manjuyadav95.m](https://forum.inductiveautomation.com/u/manjuyadav95.m)\ **Replies:** 1\ **Last updated:** [March 2, 2022, 3:17pm UTC](https://forum.inductiveautomation.com/t/issue-in-table-row-delete-perspective/56721 "2022-03-02T15:17:19Z")
I have created a view with delete icon and rendered it as view in 1st col of the table …row is getting deleted by clicking on it and I have written code on onEditCellStart but after 2 r 3 delete or sometimes single click… --- ## [Converting dropdown list dataset to JSON efficiently](https://forum.inductiveautomation.com/t/converting-dropdown-list-dataset-to-json-efficiently/56709)
**Author:** [@Robert\_Hrynciw](https://forum.inductiveautomation.com/u/Robert_Hrynciw)\ **Replies:** 3\ **Last updated:** [March 2, 2022, 3:05pm UTC](https://forum.inductiveautomation.com/t/converting-dropdown-list-dataset-to-json-efficiently/56709 "2022-03-02T15:05:07Z")
Hello. This is my second forum post. I have a table which shows a dataset with a return format to JSON to allow onCellEditCommit to change the operators Skill Level on the job. There is also dropdowns used to add new ope… --- ## [Query help entry shifts joining transaction shifts](https://forum.inductiveautomation.com/t/query-help-entry-shifts-joining-transaction-shifts/56684)
**Author:** [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Replies:** 5\ **Last updated:** [March 2, 2022, 2:18pm UTC](https://forum.inductiveautomation.com/t/query-help-entry-shifts-joining-transaction-shifts/56684 "2022-03-02T14:18:09Z")
some people are manually entering A, B, C, D A and B are to match shift 1 C and D are to match shift 2 When I wrote my query, I had and table1.shiftID=table2.shift Now though, can I say : join left ...........and t… --- ## [Symbol factory mirror horizontal to perspective](https://forum.inductiveautomation.com/t/symbol-factory-mirror-horizontal-to-perspective/37395)
**Author:** [@giuseppe.teobaldo](https://forum.inductiveautomation.com/u/giuseppe.teobaldo)\ **Replies:** 12\ **Last updated:** [March 2, 2022, 2:02pm UTC](https://forum.inductiveautomation.com/t/symbol-factory-mirror-horizontal-to-perspective/37395 "2022-03-02T14:02:36Z")
Hi I’m developing an application with perspective version 8.0.12. I need your support on 2 points in particular. 1- I can’t understand how I can perform a horizontal / vertical mirror of the images uploaded by the symbo… --- ## [Perspective alarm acknowledge location/area info](https://forum.inductiveautomation.com/t/perspective-alarm-acknowledge-location-area-info/56716)
**Author:** [@RC23](https://forum.inductiveautomation.com/u/RC23)\ **Replies:** 0\ **Last updated:** [March 2, 2022, 1:17pm UTC](https://forum.inductiveautomation.com/t/perspective-alarm-acknowledge-location-area-info/56716 "2022-03-02T13:17:59Z")
Hi there, What is the best method to extract the info (if exists) that tells from which session an alarm is acknowledged? --- ## [Select multiple plots in legend on time series chart](https://forum.inductiveautomation.com/t/select-multiple-plots-in-legend-on-time-series-chart/56253)
**Author:** [@andreas](https://forum.inductiveautomation.com/u/andreas)\ **Replies:** 2\ **Last updated:** [March 2, 2022, 7:08am UTC](https://forum.inductiveautomation.com/t/select-multiple-plots-in-legend-on-time-series-chart/56253 "2022-03-02T07:08:04Z")
Anyone knows if it is possible to select multiple plots with the legend in a time series chart? Would have been nice to select/highlight e.g. two out of three plots etc. Seems like it is only possible to select one at … --- ## [How to make a totalizer?](https://forum.inductiveautomation.com/t/how-to-make-a-totalizer/52935)
**Author:** [@Alex\_King](https://forum.inductiveautomation.com/u/Alex_King)\ **Replies:** 9\ **Last updated:** [March 2, 2022, 6:27am UTC](https://forum.inductiveautomation.com/t/how-to-make-a-totalizer/52935 "2022-03-02T06:27:26Z")
I have an OPC float tag that is displaying a GPM reading from a flow meter. I want to create a totalizer for the GPM and make it reset to 0 when a different tag becomes true. Any ideas? --- ## [java.sql.Timestamp value can't be added to dataset](https://forum.inductiveautomation.com/t/java-sql-timestamp-value-cant-be-added-to-dataset/54850)
**Author:** [@ShaneH](https://forum.inductiveautomation.com/u/ShaneH)\ **Replies:** 22\ **Last updated:** [March 2, 2022, 2:00am UTC](https://forum.inductiveautomation.com/t/java-sql-timestamp-value-cant-be-added-to-dataset/54850 "2022-03-02T02:00:06Z")
Perspective 8.1.13 We have a gateway script that creates a dataset using system.dataset.toDataSet(). The data is a collection of values from DB queries, including some date/time values. Recently, after updating to 8.1… --- ## [Alarm Displaypath/Label binding help](https://forum.inductiveautomation.com/t/alarm-displaypath-label-binding-help/56660)
**Author:** [@Josh\_Jar](https://forum.inductiveautomation.com/u/Josh_Jar)\ **Replies:** 5\ **Last updated:** [March 2, 2022, 12:56am UTC](https://forum.inductiveautomation.com/t/alarm-displaypath-label-binding-help/56660 "2022-03-02T00:56:21Z")
Hi All, I am working on upgrading an existing application to Ignition. I have a high number of Boolean Tags which I would like to set up Alarming on. These tags have been exported out of the old system, manipulated in … --- ## [Touchscreen Mode on bound tag property on popup](https://forum.inductiveautomation.com/t/touchscreen-mode-on-bound-tag-property-on-popup/56656)
**Author:** [@david.bath](https://forum.inductiveautomation.com/u/david.bath)\ **Replies:** 6\ **Last updated:** [March 1, 2022, 11:03pm UTC](https://forum.inductiveautomation.com/t/touchscreen-mode-on-bound-tag-property-on-popup/56656 "2022-03-01T23:03:16Z")
I have noticed a problem with Touchscreen mode on a Text Field on a Popup in Vision When the on-screen keyboard is used to edit the text field, the value in the text field is updated, but the underlying bound property i… --- ## [Gateway crashing when trying to open serial port](https://forum.inductiveautomation.com/t/gateway-crashing-when-trying-to-open-serial-port/48847)
**Author:** [@kevin.keefe](https://forum.inductiveautomation.com/u/kevin.keefe)\ **Replies:** 12\ **Last updated:** [March 1, 2022, 10:22pm UTC](https://forum.inductiveautomation.com/t/gateway-crashing-when-trying-to-open-serial-port/48847 "2022-03-01T22:22:43Z")
Hi I’m having an issue with a system that I’m playing around with. I’m trying to read from a serial port via a tag change gateway script, but every time i try to open it the gateway is crashing. Gateway version 8.1.7 (… --- ## [Move Table Rows Up/Down](https://forum.inductiveautomation.com/t/move-table-rows-up-down/56683)
**Author:** [@Dee\_Duncan](https://forum.inductiveautomation.com/u/Dee_Duncan)\ **Replies:** 3\ **Last updated:** [March 1, 2022, 8:58pm UTC](https://forum.inductiveautomation.com/t/move-table-rows-up-down/56683 "2022-03-01T20:58:03Z")
Hello, I am using a power table component which is connected to a database table. Is there a way to move selected rows up and down using buttons? Thanks --- ## [Alarm Pipeline Mass Event Suppression](https://forum.inductiveautomation.com/t/alarm-pipeline-mass-event-suppression/56676)
**Author:** [@Dee\_Duncan](https://forum.inductiveautomation.com/u/Dee_Duncan)\ **Replies:** 2\ **Last updated:** [March 1, 2022, 8:16pm UTC](https://forum.inductiveautomation.com/t/alarm-pipeline-mass-event-suppression/56676 "2022-03-01T20:16:40Z")
Hello, Does anyone have an idea as to how i could suppress events in my alarm pipelines? For example, When a system power failure occurs, i receive 10+ alarms related to that power failure. This results in several al… --- ## [2 State Toggle Button not functioning properly](https://forum.inductiveautomation.com/t/2-state-toggle-button-not-functioning-properly/56664)
**Author:** [@Aaron\_Ross](https://forum.inductiveautomation.com/u/Aaron_Ross)\ **Replies:** 3\ **Last updated:** [March 1, 2022, 5:10pm UTC](https://forum.inductiveautomation.com/t/2-state-toggle-button-not-functioning-properly/56664 "2022-03-01T17:10:34Z")
The Problem: I am using multiple 2 state toggle buttons, and all of them are functioning unexpectedly. When opening the window containing my 2 state toggles, their Current State property is given an incorrect value resu… --- ## [Running SQL update query in webdev module](https://forum.inductiveautomation.com/t/running-sql-update-query-in-webdev-module/56541)
**Author:** [@Prerak\_patel](https://forum.inductiveautomation.com/u/Prerak_patel)\ **Replies:** 3\ **Last updated:** [March 1, 2022, 4:22pm UTC](https://forum.inductiveautomation.com/t/running-sql-update-query-in-webdev-module/56541 "2022-03-01T16:22:03Z")
Hello, I am trying to run system.db.runUpdateQuery() in Webdev doPost module. But when I execute the code by sending data to URL, then it gives me following error. \[## HTTP ERROR 500 java.lang.Exception: java.lang.Excep… --- ## [User Friendly Tag History Graph](https://forum.inductiveautomation.com/t/user-friendly-tag-history-graph/49524)
**Author:** [@jd1](https://forum.inductiveautomation.com/u/jd1)\ **Replies:** 10\ **Last updated:** [March 1, 2022, 4:11pm UTC](https://forum.inductiveautomation.com/t/user-friendly-tag-history-graph/49524 "2022-03-01T16:11:49Z")
I appreciate the efforts that have been put into the Perspective PowerChart. It does make graphing tag history data much easier than any other chart component. I am running into a bit of a usability snag with it thought… --- ## [Primary button vs secondary button](https://forum.inductiveautomation.com/t/primary-button-vs-secondary-button/56649)
**Author:** [@joe.miller](https://forum.inductiveautomation.com/u/joe.miller)\ **Replies:** 3\ **Last updated:** [March 1, 2022, 4:08pm UTC](https://forum.inductiveautomation.com/t/primary-button-vs-secondary-button/56649 "2022-03-01T16:08:26Z")
the component tree for persepctive has many new/redone components. Some of them have multiple versions, including the Button component. It has Primary and Seconday. The mouse-over gives the same exact description for … --- ## [Setting A Value From A Template In A Template Repeater](https://forum.inductiveautomation.com/t/setting-a-value-from-a-template-in-a-template-repeater/56671)
**Author:** [@gmiroclosa](https://forum.inductiveautomation.com/u/gmiroclosa)\ **Replies:** 1\ **Last updated:** [March 1, 2022, 3:26pm UTC](https://forum.inductiveautomation.com/t/setting-a-value-from-a-template-in-a-template-repeater/56671 "2022-03-01T15:26:59Z")
Hi, On a Template Repeater I could, by scripting, get some properties of the elements: listElems= event.source.parent.getComponent(‘TemplateRepeaterDataset’).getLoadedTemplates() for id in listStations: aux = id.getP… --- ## [Accessing components inside a template repeater](https://forum.inductiveautomation.com/t/accessing-components-inside-a-template-repeater/26564)
**Author:** [@dtr019](https://forum.inductiveautomation.com/u/dtr019)\ **Replies:** 1\ **Last updated:** [March 1, 2022, 2:54pm UTC](https://forum.inductiveautomation.com/t/accessing-components-inside-a-template-repeater/26564 "2022-03-01T14:54:50Z")
Hi, I am using a template repeater to display one of my longer main windows (as it gives me scroll bars instead of resizing my components) but now I am having trouble accessing the power table component inside the templa… --- ## [Output parameter from table subView](https://forum.inductiveautomation.com/t/output-parameter-from-table-subview/56667)
**Author:** [@riwan.elansari](https://forum.inductiveautomation.com/u/riwan.elansari)\ **Replies:** 2\ **Last updated:** [March 1, 2022, 2:43pm UTC](https://forum.inductiveautomation.com/t/output-parameter-from-table-subview/56667 "2022-03-01T14:43:46Z")
Hello, I’m trying to pass parameter from a column subview to the table (The component in the subview is a dropDown and i want to get the dropdown’s selected value). Does anybody knows a way to achieve this ? Thanx ! … --- ## [Tree in perspective, multiselect label](https://forum.inductiveautomation.com/t/tree-in-perspective-multiselect-label/56661)
**Author:** [@manjuyadav95.m](https://forum.inductiveautomation.com/u/manjuyadav95.m)\ **Replies:** 3\ **Last updated:** [March 1, 2022, 10:46am UTC](https://forum.inductiveautomation.com/t/tree-in-perspective-multiselect-label/56661 "2022-03-01T10:46:35Z")
I need the selectionData prop’s value to be filled when selected from tree as selectionData prop’s itemPath does… see attached screenshot job1 is passed by triggering event from onItemClicked self.props.selectionData… --- ## [Request Focus in Perspective Table Search Bar](https://forum.inductiveautomation.com/t/request-focus-in-perspective-table-search-bar/56542)
**Author:** [@dustin.cooper](https://forum.inductiveautomation.com/u/dustin.cooper)\ **Replies:** 15\ **Last updated:** [March 1, 2022, 8:20am UTC](https://forum.inductiveautomation.com/t/request-focus-in-perspective-table-search-bar/56542 "2022-03-01T08:20:48Z")
Hello there - I’m trying to figure out if it is possible to request focus on the table search (filter) bar from a button event script. I cant request focus easily enough on the table, and my search button already tog… --- ## [system.gui.getParentWindow(event) in perspecive](https://forum.inductiveautomation.com/t/system-gui-getparentwindow-event-in-perspecive/56558)
**Author:** [@manjuyadav95.m](https://forum.inductiveautomation.com/u/manjuyadav95.m)\ **Replies:** 9\ **Last updated:** [March 1, 2022, 7:45am UTC](https://forum.inductiveautomation.com/t/system-gui-getparentwindow-event-in-perspecive/56558 "2022-03-01T07:45:15Z")
this system.gui.getParentWindow(event) return window’sname right? I want to achieve this in perspective…Plz help --- ## [Does component Alarm Status Table not have a property for total alarms?](https://forum.inductiveautomation.com/t/does-component-alarm-status-table-not-have-a-property-for-total-alarms/56641)
**Author:** [@BVong](https://forum.inductiveautomation.com/u/BVong)\ **Replies:** 2\ **Last updated:** [March 1, 2022, 3:24am UTC](https://forum.inductiveautomation.com/t/does-component-alarm-status-table-not-have-a-property-for-total-alarms/56641 "2022-03-01T03:24:41Z")
I didn’t like the overhead that came along with the filterAlarm event. I ended up going with the the conditions property to a source that will populate the alarms status table. This works and will update the label next t… --- ## [Mysql data base connection](https://forum.inductiveautomation.com/t/mysql-data-base-connection/56645)
**Author:** [@Ray\_Guthrie](https://forum.inductiveautomation.com/u/Ray_Guthrie)\ **Replies:** 3\ **Last updated:** [February 28, 2022, 10:57pm UTC](https://forum.inductiveautomation.com/t/mysql-data-base-connection/56645 "2022-02-28T22:57:30Z")
I get a faulted status when I create mySQL data base. see description as follows:java.sql.SQLException: Cannot create PoolableConnectionFactory (Access denied for user ‘admin’@‘localhost’ (using password: YES)) at org.… --- ## [Pulling controllogix Rslogix5000 tag based alarms into Ignition](https://forum.inductiveautomation.com/t/pulling-controllogix-rslogix5000-tag-based-alarms-into-ignition/56622)
**Author:** [@Viet\_Le](https://forum.inductiveautomation.com/u/Viet_Le)\ **Replies:** 4\ **Last updated:** [February 28, 2022, 9:53pm UTC](https://forum.inductiveautomation.com/t/pulling-controllogix-rslogix5000-tag-based-alarms-into-ignition/56622 "2022-02-28T21:53:39Z")
I saw a topic some time last year about pulling the tag based alarm from compactlogix about which the forum basically said it’s not possible. A year gone by now, and with 30 + of controllogix systems coming up in our pro… --- ## [PI OPC DA Server and OSI PI Buffer Subsystem on Ignition servers](https://forum.inductiveautomation.com/t/pi-opc-da-server-and-osi-pi-buffer-subsystem-on-ignition-servers/56635)
**Author:** [@Tawnya\_Hennesy](https://forum.inductiveautomation.com/u/Tawnya_Hennesy)\ **Replies:** 2\ **Last updated:** [February 28, 2022, 7:12pm UTC](https://forum.inductiveautomation.com/t/pi-opc-da-server-and-osi-pi-buffer-subsystem-on-ignition-servers/56635 "2022-02-28T19:12:45Z")
Has anyone used the PI OPC DA Server, configured as a DA OPC Connection on an Ignition redundant pair, to read/write to an OSI PI Collective? If so, did you install/enable the PI Buffer Subsystem on the Ignition servers? … --- ## [Named Queries as .sql](https://forum.inductiveautomation.com/t/named-queries-as-sql/56638)
**Author:** [@kgamble](https://forum.inductiveautomation.com/u/kgamble)\ **Replies:** 1\ **Last updated:** [February 28, 2022, 7:10pm UTC](https://forum.inductiveautomation.com/t/named-queries-as-sql/56638 "2022-02-28T19:10:34Z")
Hey I am about to do an update to an application and realized that at some point named queries were switched to .sql files instead of binaries (woohoo!) I was just curious, what version did this happen in? --- ## [Duplicate Alarm Events in Pipelines](https://forum.inductiveautomation.com/t/duplicate-alarm-events-in-pipelines/55939)
**Author:** [@Dee\_Duncan](https://forum.inductiveautomation.com/u/Dee_Duncan)\ **Replies:** 3\ **Last updated:** [February 28, 2022, 6:27pm UTC](https://forum.inductiveautomation.com/t/duplicate-alarm-events-in-pipelines/55939 "2022-02-28T18:27:34Z")
Is anyone else having issues with duplicate alarm events occurring in alarm pipelines? The issue occurs when remote tag providers are utilized. Every alarm event that is routed to a pipeline is duplicated. Was wonder… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=882) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=884)