# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1622 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1623 --- ## [Save tag value once per week for annual production chart](https://forum.inductiveautomation.com/t/save-tag-value-once-per-week-for-annual-production-chart/18923)
**Author:** [@joeyjojoshabadu](https://forum.inductiveautomation.com/u/joeyjojoshabadu)\ **Replies:** 6\ **Last updated:** [July 24, 2018, 1:45pm UTC](https://forum.inductiveautomation.com/t/save-tag-value-once-per-week-for-annual-production-chart/18923 "2018-07-24T13:45:18Z")
Hi, At a power plant I have a tag from the PLC called MWH\_LAST\_WEEK. At 12:00:00AM on Mondays this value changes. When it changes I want to write it to a new SQL table I will create in the ignition database called WEEK… --- ## [Tags showing unknown quality](https://forum.inductiveautomation.com/t/tags-showing-unknown-quality/18946)
**Author:** [@harryzhou4498](https://forum.inductiveautomation.com/u/harryzhou4498)\ **Replies:** 1\ **Last updated:** [July 24, 2018, 1:28pm UTC](https://forum.inductiveautomation.com/t/tags-showing-unknown-quality/18946 "2018-07-24T13:28:26Z")
I have some tags that are showing unknown/bad quality. These issues occur for two of the same type of PLC (Allen Bradley MicroLogix). I’m not sure why this is occurring. I’ve tried refreshing the tags and importing new t… --- ## [Reading a Tags Value and invrementing it by 1](https://forum.inductiveautomation.com/t/reading-a-tags-value-and-invrementing-it-by-1/18945)
**Author:** [@jshaffer09](https://forum.inductiveautomation.com/u/jshaffer09)\ **Replies:** 1\ **Last updated:** [July 24, 2018, 12:35pm UTC](https://forum.inductiveautomation.com/t/reading-a-tags-value-and-invrementing-it-by-1/18945 "2018-07-24T12:35:15Z")
I am wanting to get a tags value and increment it by 1. This is what I have. It is going in to a table. I don't believe it is reading the tag value if submitSuccess ==1: oldData=system.tag.read("\[default\]Mobli… --- ## [Template repeater dataset](https://forum.inductiveautomation.com/t/template-repeater-dataset/18936)
**Author:** [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\ **Replies:** 2\ **Last updated:** [July 24, 2018, 12:22pm UTC](https://forum.inductiveautomation.com/t/template-repeater-dataset/18936 "2018-07-24T12:22:02Z")
Is it possible to create the Template Repeater dataset via a script at runtime? I'm going to be showing a variable number the templates based on a numerical textbox. I need to use the dataset type as I have two custom … --- ## [Logix Driver Bad Quality Tags](https://forum.inductiveautomation.com/t/logix-driver-bad-quality-tags/18944)
**Author:** [@dtamada](https://forum.inductiveautomation.com/u/dtamada)\ **Replies:** 2\ **Last updated:** [July 24, 2018, 12:15pm UTC](https://forum.inductiveautomation.com/t/logix-driver-bad-quality-tags/18944 "2018-07-24T12:15:14Z")
--- ## [Random bad data quality](https://forum.inductiveautomation.com/t/random-bad-data-quality/7583)
**Author:** [@Custom8](https://forum.inductiveautomation.com/u/Custom8)\ **Replies:** 11\ **Last updated:** [November 20, 2013, 1:31pm UTC](https://forum.inductiveautomation.com/t/random-bad-data-quality/7583 "2013-11-20T13:31:10Z")
Setup: Ignition server is version 7.6.3, Java OpenJDK version 1.7.0\_45, running on Scientific Linux 6.4. OPC UA is reading from 7 equipment units over Modbus/TCP. One unit - Woodward easyGen-3000 randomly looses data qu… --- ## [No tables listed MySQL 6.3](https://forum.inductiveautomation.com/t/no-tables-listed-mysql-6-3/18925)
**Author:** [@abishur](https://forum.inductiveautomation.com/u/abishur)\ **Replies:** 3\ **Last updated:** [July 24, 2018, 12:16am UTC](https://forum.inductiveautomation.com/t/no-tables-listed-mysql-6-3/18925 "2018-07-24T00:16:38Z")
When I open the DB Query Browser from the tools menu no tables are listed from any MySQL server when using the latest version of MySQL. I already had to install the latest JDBC driver and it is storing data corrected t… --- ## [New to Ignition, help me](https://forum.inductiveautomation.com/t/new-to-ignition-help-me/18931)
**Author:** [@sac](https://forum.inductiveautomation.com/u/sac)\ **Replies:** 7\ **Last updated:** [July 23, 2018, 11:34pm UTC](https://forum.inductiveautomation.com/t/new-to-ignition-help-me/18931 "2018-07-23T23:34:03Z")
Hey, I am new to ignition and trying to create a project. I am a developer who have experience in Java and AngularJS. Can anyone help me figure out what all I need to know before starting out a new project. There seem to… --- ## [Database Connection State Connecting](https://forum.inductiveautomation.com/t/database-connection-state-connecting/18823)
**Author:** [@khashey.ahmed](https://forum.inductiveautomation.com/u/khashey.ahmed)\ **Replies:** 5\ **Last updated:** [July 23, 2018, 9:32pm UTC](https://forum.inductiveautomation.com/t/database-connection-state-connecting/18823 "2018-07-23T21:32:13Z")
Hi All, I am having issues our database connection turns connecting from valid state as soon as we save the configuration(same config) or sometime suddenly even when we dont do anything(probably because of lost connect… --- ## [Time Weighted Average](https://forum.inductiveautomation.com/t/time-weighted-average/18926)
**Author:** [@abishur](https://forum.inductiveautomation.com/u/abishur)\ **Replies:** 3\ **Last updated:** [July 23, 2018, 9:08pm UTC](https://forum.inductiveautomation.com/t/time-weighted-average/18926 "2018-07-23T21:08:16Z")
This might be a better question for Stack Overflow, however I was curious if anyone here has ever delt with this issue. I have a client who wants to use a third party web-dashboard for viewing historical data. They ar… --- ## [Category bar chart - How to remove the gradient?](https://forum.inductiveautomation.com/t/category-bar-chart-how-to-remove-the-gradient/16477)
**Author:** [@brian.mcenulty](https://forum.inductiveautomation.com/u/brian.mcenulty)\ **Replies:** 2\ **Last updated:** [January 4, 2018, 6:07pm UTC](https://forum.inductiveautomation.com/t/category-bar-chart-how-to-remove-the-gradient/16477 "2018-01-04T18:07:37Z")
I have a chart component that I've configured a category chart on. The renderer is set to stacked bar. By default the bars have a gradient on them. I'd like to remove the gradient and just have flat colors. From what I'v… --- ## [Security Permissions on Public Client](https://forum.inductiveautomation.com/t/security-permissions-on-public-client/18921)
**Author:** [@byrnep](https://forum.inductiveautomation.com/u/byrnep)\ **Replies:** 4\ **Last updated:** [July 23, 2018, 6:05pm UTC](https://forum.inductiveautomation.com/t/security-permissions-on-public-client/18921 "2018-07-23T18:05:41Z")
So, one of the use cases for ignition in our plant is to replace an antiquated alarming system. The alarming system has a GUI overlay that runs on a public computer in the main control room. In the event of an alarm, … --- ## [Simple report email](https://forum.inductiveautomation.com/t/simple-report-email/18934)
**Author:** [@ikenna.nwaogu](https://forum.inductiveautomation.com/u/ikenna.nwaogu)\ **Replies:** 4\ **Last updated:** [July 23, 2018, 4:48pm UTC](https://forum.inductiveautomation.com/t/simple-report-email/18934 "2018-07-23T16:48:57Z")
I have been trying to send a report through email through a button even the simplest form hasn't worked. I dont get any error and that's the most annoying part of. Here is my simple code just as the manual system.repor… --- ## [Gateway ports separating](https://forum.inductiveautomation.com/t/gateway-ports-separating/18928)
**Author:** [@StepanenkoPaul](https://forum.inductiveautomation.com/u/StepanenkoPaul)\ **Replies:** 2\ **Last updated:** [July 23, 2018, 4:23pm UTC](https://forum.inductiveautomation.com/t/gateway-ports-separating/18928 "2018-07-23T16:23:56Z")
Is it possible to redirect the connection to the mobile client via a separate port other than the gateway port? For example: connection to the gateway execute via http://localhost:8088 and connection to the mobile client… --- ## [Button size in modal window](https://forum.inductiveautomation.com/t/button-size-in-modal-window/8952)
**Author:** [@DawidF](https://forum.inductiveautomation.com/u/DawidF)\ **Replies:** 2\ **Last updated:** [July 23, 2018, 3:16pm UTC](https://forum.inductiveautomation.com/t/button-size-in-modal-window/8952 "2018-07-23T15:16:08Z")
Hello, I create project for a touch screen. Can I set bigger button in modal windows like system.gui.confirm("") or system.gui.input(""). I know that i can create popup window but i wanna block other windows when… --- ## [System.opc.readvalue - Advanced properties](https://forum.inductiveautomation.com/t/system-opc-readvalue-advanced-properties/18932)
**Author:** [@oisin.gribben](https://forum.inductiveautomation.com/u/oisin.gribben)\ **Replies:** 0\ **Last updated:** [July 23, 2018, 10:55am UTC](https://forum.inductiveautomation.com/t/system-opc-readvalue-advanced-properties/18932 "2018-07-23T10:55:34Z")
Is it possible to retrieve the advanced properties of a device in a script. The properties I am looking to retrieve are displayed below. Current Script --- ## [Trend Pens Control Scroll Bar Not Accessible! only in mouse scroll](https://forum.inductiveautomation.com/t/trend-pens-control-scroll-bar-not-accessible-only-in-mouse-scroll/18874)
**Author:** [@choy](https://forum.inductiveautomation.com/u/choy)\ **Replies:** 7\ **Last updated:** [July 23, 2018, 1:16am UTC](https://forum.inductiveautomation.com/t/trend-pens-control-scroll-bar-not-accessible-only-in-mouse-scroll/18874 "2018-07-23T01:16:20Z")
In Designer I can Scroll Trend Pens Easily, While in Runtime only Mouse Scrolling which is very slow. I hope there is a fixed with this one, or is there some settings to do? --- ## [Store and Forward Settings](https://forum.inductiveautomation.com/t/store-and-forward-settings/14469)
**Author:** [@zacslade](https://forum.inductiveautomation.com/u/zacslade)\ **Replies:** 5\ **Last updated:** [July 21, 2018, 11:15pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-settings/14469 "2018-07-21T23:15:39Z")
A couple of questions about Store and Forward: This topic says that prior to 7.8 it was not advisable to set the Max Records higher than 50k. Is that fixed? And what is the new practical upper limit for Max Records? … --- ## [Alarm Pipelines - How to refresh alarm tag values in pipeline](https://forum.inductiveautomation.com/t/alarm-pipelines-how-to-refresh-alarm-tag-values-in-pipeline/17589)
**Author:** [@Travis](https://forum.inductiveautomation.com/u/Travis)\ **Replies:** 4\ **Last updated:** [July 20, 2018, 9:28pm UTC](https://forum.inductiveautomation.com/t/alarm-pipelines-how-to-refresh-alarm-tag-values-in-pipeline/17589 "2018-07-20T21:28:09Z")
Hi. I want to resend email notifications in an alarm pipeline with the alarm tag value in the Custom Subject after a delay until the alarm clears in the pipeline. I have no trouble getting the emails to resend using th… --- ## [Create a Template from an Existing Component](https://forum.inductiveautomation.com/t/create-a-template-from-an-existing-component/18908)
**Author:** [@ddurant](https://forum.inductiveautomation.com/u/ddurant)\ **Replies:** 0\ **Last updated:** [July 20, 2018, 12:54am UTC](https://forum.inductiveautomation.com/t/create-a-template-from-an-existing-component/18908 "2018-07-20T00:54:10Z")
Is there a way to create a template from an existing component? I tried creating a new template and pasting in my existing component which didn't work, and I don't see any property in my existing component that would le… --- ## [Sorting File Explorer?](https://forum.inductiveautomation.com/t/sorting-file-explorer/18910)
**Author:** [@dano38291](https://forum.inductiveautomation.com/u/dano38291)\ **Replies:** 2\ **Last updated:** [July 20, 2018, 5:00pm UTC](https://forum.inductiveautomation.com/t/sorting-file-explorer/18910 "2018-07-20T17:00:39Z")
Is there any to Sort File Explorer window so New Files show at the Top? It appears folders and oldest files appear at top for me currently? Maybe there's some secret syntax to embed into root directory or file filer t… --- ## [Button and Dropdown styling?](https://forum.inductiveautomation.com/t/button-and-dropdown-styling/18915)
**Author:** [@brian.mcenulty](https://forum.inductiveautomation.com/u/brian.mcenulty)\ **Replies:** 1\ **Last updated:** [July 20, 2018, 4:08pm UTC](https://forum.inductiveautomation.com/t/button-and-dropdown-styling/18915 "2018-07-20T16:08:53Z")
In the recent HMI Makeover blog posts (which are great by the way!), some of the components shown in the "after" versions of the screen use more modernly styled radio button, checkbox, and dropdown components. How were t… --- ## [Export Devices to CSV -Extra Properties](https://forum.inductiveautomation.com/t/export-devices-to-csv-extra-properties/18914)
**Author:** [@oisin.gribben](https://forum.inductiveautomation.com/u/oisin.gribben)\ **Replies:** 0\ **Last updated:** [July 20, 2018, 3:09pm UTC](https://forum.inductiveautomation.com/t/export-devices-to-csv-extra-properties/18914 "2018-07-20T15:09:56Z")
Is it possible to export all the devices on a gateway to a CSV with more properties included than the 4 returned in the system.device.listDevices funciton ? (eg. Port, MaxHoldingRegistersPerRequest, MaxInputRegistersP… --- ## [Distributing Project](https://forum.inductiveautomation.com/t/distributing-project/18912)
**Author:** [@craigb](https://forum.inductiveautomation.com/u/craigb)\ **Replies:** 1\ **Last updated:** [July 20, 2018, 2:45pm UTC](https://forum.inductiveautomation.com/t/distributing-project/18912 "2018-07-20T14:45:50Z")
Ladies, Gents. Whats the best method to distribute the project among colleagues for them to log into on their computer? We also want to share the project with clients. Currently for test purposes I give them the Host… --- ## [Comparing dataSets by unique id in one column](https://forum.inductiveautomation.com/t/comparing-datasets-by-unique-id-in-one-column/18895)
**Author:** [@waker1der](https://forum.inductiveautomation.com/u/waker1der)\ **Replies:** 3\ **Last updated:** [July 20, 2018, 2:35pm UTC](https://forum.inductiveautomation.com/t/comparing-datasets-by-unique-id-in-one-column/18895 "2018-07-20T14:35:12Z")
HI, part of my application I make a SELECT query from a datawarehouse table that i have read only access. I display the data in a power table and this query runs every 2 hours. I then want to take this data and writ… --- ## [Named Query Scalar Result](https://forum.inductiveautomation.com/t/named-query-scalar-result/18911)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 2\ **Last updated:** [July 20, 2018, 1:53pm UTC](https://forum.inductiveautomation.com/t/named-query-scalar-result/18911 "2018-07-20T13:53:59Z")
I have a named query that takes two parameters, the query returns a single value but is still a dataset. Whats the easiest way to get that value as a scalar value? --- ## [.executeAndDistribute vs .saveAsXls?](https://forum.inductiveautomation.com/t/executeanddistribute-vs-saveasxls/18738)
**Author:** [@dano38291](https://forum.inductiveautomation.com/u/dano38291)\ **Replies:** 1\ **Last updated:** [July 20, 2018, 1:33pm UTC](https://forum.inductiveautomation.com/t/executeanddistribute-vs-saveasxls/18738 "2018-07-20T13:33:39Z")
Hello, I have created a report and I pass it Client Tags in a Report Viewer component. I would like to automatically save a PDF and XLS file of this report with no user interaction. I have experimented with .executeA… --- ## [Printing Report with parameter inputs](https://forum.inductiveautomation.com/t/printing-report-with-parameter-inputs/18903)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 4\ **Last updated:** [July 20, 2018, 12:38pm UTC](https://forum.inductiveautomation.com/t/printing-report-with-parameter-inputs/18903 "2018-07-20T12:38:53Z")
I have a report that details the parts of an assembly. the parts are loaded onto a cart, but the cart can only hold so many parts. Thus each assembly has a maximum load quantity. when it is exceeded the order should b… --- ## [Problem in Bind Query](https://forum.inductiveautomation.com/t/problem-in-bind-query/18887)
**Author:** [@AlexandreFG](https://forum.inductiveautomation.com/u/AlexandreFG)\ **Replies:** 2\ **Last updated:** [July 20, 2018, 11:51am UTC](https://forum.inductiveautomation.com/t/problem-in-bind-query/18887 "2018-07-20T11:51:58Z")
'm having trouble editing my tables. I create a query in bind that works perfectly, when closing and opening the ignition I can not change nor even cancel the query, it generates the following error: Exception in thre… --- ## [Indirect limits for several moving analog indicators](https://forum.inductiveautomation.com/t/indirect-limits-for-several-moving-analog-indicators/18905)
**Author:** [@filipg](https://forum.inductiveautomation.com/u/filipg)\ **Replies:** 0\ **Last updated:** [July 19, 2018, 9:15pm UTC](https://forum.inductiveautomation.com/t/indirect-limits-for-several-moving-analog-indicators/18905 "2018-07-19T21:15:18Z")
I am using several moving analog indicators to monitor a cyclic process (9 stages) - so all limits for each moving indicator change 9 times per cycle. What is the best way to code this into the moving analog indicators… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1621) [Next page](https://forum.inductiveautomation.com/latest.md?page=1623)