# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1538 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1539 --- ## [Tag Historian questions](https://forum.inductiveautomation.com/t/tag-historian-questions/23861)
**Author:** [@Vena.Cava](https://forum.inductiveautomation.com/u/Vena.Cava)\ **Replies:** 0\ **Last updated:** [April 4, 2019, 7:43pm UTC](https://forum.inductiveautomation.com/t/tag-historian-questions/23861 "2019-04-04T19:43:34Z")
Hey there, New to ignition, do you need the tag historian module to trend tags on easy chart, and display an alarm history page? seems like you do but I just wanted to double check? --- ## [Export To XLS problem ignition 7.9.7](https://forum.inductiveautomation.com/t/export-to-xls-problem-ignition-7-9-7/23837)
**Author:** [@alo.go](https://forum.inductiveautomation.com/u/alo.go)\ **Replies:** 0\ **Last updated:** [April 3, 2019, 10:47pm UTC](https://forum.inductiveautomation.com/t/export-to-xls-problem-ignition-7-9-7/23837 "2019-04-03T22:47:35Z")
Hello everybody! I have a problem, When I try to export a report to an xls file (right button in my report \> save as XLS), the order of the columns is changed. The headers remain in place, but the data does not. For exa… --- ## [Alert Summary vs Alarm Status Table Components](https://forum.inductiveautomation.com/t/alert-summary-vs-alarm-status-table-components/23855)
**Author:** [@MikeAllgood](https://forum.inductiveautomation.com/u/MikeAllgood)\ **Replies:** 8\ **Last updated:** [April 4, 2019, 6:54pm UTC](https://forum.inductiveautomation.com/t/alert-summary-vs-alarm-status-table-components/23855 "2019-04-04T18:54:42Z")
A customer has a screen that has an Alert Summary Table on it, but I don’t see that component in the designer. The Ignition version is 7.9.9. I don’t find any documentation for the Alert Summary component either. I’m gu… --- ## [\[FEATURE-13462, 13463\] Gauge Customization](https://forum.inductiveautomation.com/t/feature-13462-13463-gauge-customization/23617)
**Author:** [@BumbleBeeTuna](https://forum.inductiveautomation.com/u/BumbleBeeTuna)\ **Replies:** 1\ **Last updated:** [April 4, 2019, 6:14pm UTC](https://forum.inductiveautomation.com/t/feature-13462-13463-gauge-customization/23617 "2019-04-04T18:14:05Z")
It would be handy for us if we had the ability to all of the following (or just item 5): outer axis additions Gauge.props.outerAxis.tickMarks.showValues # show/hide tick mark values on the outer axis Gauge.props.outerA… --- ## [Chart Abnormality](https://forum.inductiveautomation.com/t/chart-abnormality/23847)
**Author:** [@carolineuchoa.estuda](https://forum.inductiveautomation.com/u/carolineuchoa.estuda)\ **Replies:** 2\ **Last updated:** [April 4, 2019, 4:43pm UTC](https://forum.inductiveautomation.com/t/chart-abnormality/23847 "2019-04-04T16:43:00Z")
Hello, My Historical Chart is presenting some peaks that should not be there (as image below). The data is correct, but the chart just don’t seem to work correctly. It was not happening before. Anyone knows what that co… --- ## [Ignition EDGE and Industrial-grade Raspberry](https://forum.inductiveautomation.com/t/ignition-edge-and-industrial-grade-raspberry/14287)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 10\ **Last updated:** [April 4, 2019, 4:21pm UTC](https://forum.inductiveautomation.com/t/ignition-edge-and-industrial-grade-raspberry/14287 "2019-04-04T16:21:43Z")
Ignition EDGE + Raspbian + Industrial-grade Raspberry (compute module 3). It seem to be possible ! I wrote a quick article for it on my blog : --- ## [How to 'reference cells' in Report Table?](https://forum.inductiveautomation.com/t/how-to-reference-cells-in-report-table/23854)
**Author:** [@tbdaigle](https://forum.inductiveautomation.com/u/tbdaigle)\ **Replies:** 2\ **Last updated:** [April 4, 2019, 4:16pm UTC](https://forum.inductiveautomation.com/t/how-to-reference-cells-in-report-table/23854 "2019-04-04T16:16:05Z")
What would be the suggested method for performing arithmetic on two values that are in different rows and, perhaps, columns of a table in the Reporting Module? --- ## [Invalid Column Name When Calculating Initial Variable Value](https://forum.inductiveautomation.com/t/invalid-column-name-when-calculating-initial-variable-value/23853)
**Author:** [@EEdmondson](https://forum.inductiveautomation.com/u/EEdmondson)\ **Replies:** 1\ **Last updated:** [April 4, 2019, 3:29pm UTC](https://forum.inductiveautomation.com/t/invalid-column-name-when-calculating-initial-variable-value/23853 "2019-04-04T15:29:19Z")
DECLARE @Total\_Good\_Percent AS float = ((Total\_Good\_Parts / Total\_Parts)\*100) The above is the function I’m trying to get to work. However, when I run the query it says that “Total\_Good\_Parts” is an invalid column name.… --- ## [Write the value to the tag!](https://forum.inductiveautomation.com/t/write-the-value-to-the-tag/23845)
**Author:** [@war\_vortex](https://forum.inductiveautomation.com/u/war_vortex)\ **Replies:** 0\ **Last updated:** [April 4, 2019, 10:17am UTC](https://forum.inductiveautomation.com/t/write-the-value-to-the-tag/23845 "2019-04-04T10:17:22Z")
Hi Write the value to the tag. Is it correct? private GatewayContext gatewayContext; public TagUtil(GatewayContext gatewayContext) { this.gatewayContext = gatewayContext; } public void write(String tagPath, Object … --- ## [Duplicate a table row that is linked to another table with foriegn keys](https://forum.inductiveautomation.com/t/duplicate-a-table-row-that-is-linked-to-another-table-with-foriegn-keys/23834)
**Author:** [@bellm](https://forum.inductiveautomation.com/u/bellm)\ **Replies:** 8\ **Last updated:** [April 4, 2019, 3:23pm UTC](https://forum.inductiveautomation.com/t/duplicate-a-table-row-that-is-linked-to-another-table-with-foriegn-keys/23834 "2019-04-04T15:23:28Z")
Our customer has asked if we could add a copy button to our recipe screen. What they want is to select a row and press a copy button to duplicate that row and all the coat info. I have attached a screen shot of the scree… --- ## [CodeSys OPC Server Error](https://forum.inductiveautomation.com/t/codesys-opc-server-error/23849)
**Author:** [@mczaldivar](https://forum.inductiveautomation.com/u/mczaldivar)\ **Replies:** 0\ **Last updated:** [April 4, 2019, 2:03pm UTC](https://forum.inductiveautomation.com/t/codesys-opc-server-error/23849 "2019-04-04T14:03:03Z")
Hello, I am trying to connect to my codesys OPC server without success so far. I am using the Ignition OPC-COM and use Matrikon’s Explorer to verify that i can read tags and its works. Follow the log java.lang.Illegal… --- ## [\[BUG\] Decimal separator in numeric input field behaves wrong for non-english locales](https://forum.inductiveautomation.com/t/bug-decimal-separator-in-numeric-input-field-behaves-wrong-for-non-english-locales/23361)
**Author:** [@chi](https://forum.inductiveautomation.com/u/chi)\ **Replies:** 3\ **Last updated:** [April 3, 2019, 9:24am UTC](https://forum.inductiveautomation.com/t/bug-decimal-separator-in-numeric-input-field-behaves-wrong-for-non-english-locales/23361 "2019-04-03T09:24:05Z")
In the vision designer’s preview mode, the numeric text field behaves wrong if the systems locale uses a comma as decimal separator. There is also a different behaviour when a project language is new added. Ignition: b… --- ## [Huge tables in Tag Historian](https://forum.inductiveautomation.com/t/huge-tables-in-tag-historian/23846)
**Author:** [@wofoster](https://forum.inductiveautomation.com/u/wofoster)\ **Replies:** 0\ **Last updated:** [April 4, 2019, 11:07am UTC](https://forum.inductiveautomation.com/t/huge-tables-in-tag-historian/23846 "2019-04-04T11:07:31Z")
Hi all: I have an issue with a huge database of tag historian with Millions of registers. I am trying to find the the root cause of this huge tables . I suspect some History scanclass can has any bad setup. In this cas… --- ## [MySQL JDBC driver 5.1 can not be installed - Missing required files](https://forum.inductiveautomation.com/t/mysql-jdbc-driver-5-1-can-not-be-installed-missing-required-files/23812)
**Author:** [@chi](https://forum.inductiveautomation.com/u/chi)\ **Replies:** 2\ **Last updated:** [April 4, 2019, 8:24am UTC](https://forum.inductiveautomation.com/t/mysql-jdbc-driver-5-1-can-not-be-installed-missing-required-files/23812 "2019-04-04T08:24:50Z")
I tried to install the latest V5 MySQL JDBC driver 5.1.47. After clicking ‘save changes’ there is a message Successfully updated JDBC Driver "MySQL" but the status shows ‘Missing required files’. In the gateway, the onl… --- ## [Get the screen-relative coordinates of an open popup Window](https://forum.inductiveautomation.com/t/get-the-screen-relative-coordinates-of-an-open-popup-window/23842)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 0\ **Last updated:** [April 4, 2019, 4:28am UTC](https://forum.inductiveautomation.com/t/get-the-screen-relative-coordinates-of-an-open-popup-window/23842 "2019-04-04T04:28:53Z")
If I have a popup window open, how would I get its screen-relative coordinates? I’m after something identical to using system.gui.convertPointToScreen(…) for components on a window. I need something like: window = sys… --- ## [Mobile phone close/lock causes gateway message popups](https://forum.inductiveautomation.com/t/mobile-phone-close-lock-causes-gateway-message-popups/23742)
**Author:** [@NorthPoint](https://forum.inductiveautomation.com/u/NorthPoint)\ **Replies:** 1\ **Last updated:** [April 4, 2019, 1:44am UTC](https://forum.inductiveautomation.com/t/mobile-phone-close-lock-causes-gateway-message-popups/23742 "2019-04-04T01:44:28Z")
Is there any way to either control the popups that say that the gateway is lost and is back, or better yet, is there a way to keep the session running in the background, in the browser or in the mobile client? People co… --- ## [Named Query hangs](https://forum.inductiveautomation.com/t/named-query-hangs/23439)
**Author:** [@Tim](https://forum.inductiveautomation.com/u/Tim)\ **Replies:** 4\ **Last updated:** [April 3, 2019, 11:02pm UTC](https://forum.inductiveautomation.com/t/named-query-hangs/23439 "2019-04-03T23:02:07Z")
I’m seeing named queries hanging in the gateway active query status screen when the client calling window is closed before the query results are returned. They will remain under the active query heading until manually c… --- ## [\[Bug-13452\]Progress Bar background color](https://forum.inductiveautomation.com/t/bug-13452-progress-bar-background-color/23824)
**Author:** [@Walt](https://forum.inductiveautomation.com/u/Walt)\ **Replies:** 1\ **Last updated:** [April 3, 2019, 9:38pm UTC](https://forum.inductiveautomation.com/t/bug-13452-progress-bar-background-color/23824 "2019-04-03T21:38:16Z")
When making the progress bar background color transparent, it appears white with a gray border. The gray border seems to be part of the background as it gets covered up when the bar fills. The border property for the co… --- ## [Launch designer straight into a project](https://forum.inductiveautomation.com/t/launch-designer-straight-into-a-project/20126)
**Author:** [@mrogers](https://forum.inductiveautomation.com/u/mrogers)\ **Replies:** 9\ **Last updated:** [April 3, 2019, 9:15pm UTC](https://forum.inductiveautomation.com/t/launch-designer-straight-into-a-project/20126 "2019-04-03T21:15:51Z")
Just a quick question, is it possible to make the designer launcher .jnlp open straight into a given project? I don't usually deal with multiple projects on the same gateway so it'd be nice if I could just skip that step… --- ## [Get dataset row into namedquery to make a tuple duplicate, typed error](https://forum.inductiveautomation.com/t/get-dataset-row-into-namedquery-to-make-a-tuple-duplicate-typed-error/23820)
**Author:** [@jose.pablo.arguello](https://forum.inductiveautomation.com/u/jose.pablo.arguello)\ **Replies:** 2\ **Last updated:** [April 3, 2019, 9:15pm UTC](https://forum.inductiveautomation.com/t/get-dataset-row-into-namedquery-to-make-a-tuple-duplicate-typed-error/23820 "2019-04-03T21:15:31Z")
Hello. I get error: TypeError: cannot concatenate ‘str’ and ‘int’ objects Im trying to place an insert in a database, using a existing dataset row, like this: dataset=system.db.runQuery(“SELECT \* FROM lista\_de\_pedido … --- ## [Weird issue with report script data source (dataset)](https://forum.inductiveautomation.com/t/weird-issue-with-report-script-data-source-dataset/23826)
**Author:** [@paul.bouillon](https://forum.inductiveautomation.com/u/paul.bouillon)\ **Replies:** 1\ **Last updated:** [April 3, 2019, 9:06pm UTC](https://forum.inductiveautomation.com/t/weird-issue-with-report-script-data-source-dataset/23826 "2019-04-03T21:06:05Z")
Hi All, Trying to understand why I’m only getting a single row returned from my datasource created by script… Essentially, I am trying to sum the rows of my nested query, so that I can display a pie chart – was trying … --- ## [Ignition Store are Forward](https://forum.inductiveautomation.com/t/ignition-store-are-forward/23830)
**Author:** [@greggry.demark](https://forum.inductiveautomation.com/u/greggry.demark)\ **Replies:** 1\ **Last updated:** [April 3, 2019, 8:54pm UTC](https://forum.inductiveautomation.com/t/ignition-store-are-forward/23830 "2019-04-03T20:54:04Z")
Hello, I am trying to determine if the “Store and Forward” function would be appropriate for my application. I have a PLC based process where every two minutes I need to write less than 12 records to my database. In t… --- ## [\[Bug-13343\]System.util.retarget bug](https://forum.inductiveautomation.com/t/bug-13343-system-util-retarget-bug/23684)
**Author:** [@cwaddoups](https://forum.inductiveautomation.com/u/cwaddoups)\ **Replies:** 18\ **Last updated:** [April 3, 2019, 6:56pm UTC](https://forum.inductiveautomation.com/t/bug-13343-system-util-retarget-bug/23684 "2019-04-03T18:56:59Z")
It seems there is a bug using system.util.retarget on a remote vision client. I have two projects on the same gateway and a menu bar script that reads system.util.retarget(‘project name’). This works as long as the cli… --- ## [Syncing Gateway clock to PLC clock](https://forum.inductiveautomation.com/t/syncing-gateway-clock-to-plc-clock/12279)
**Author:** [@Mr.K001](https://forum.inductiveautomation.com/u/Mr.K001)\ **Replies:** 11\ **Last updated:** [April 3, 2019, 6:27pm UTC](https://forum.inductiveautomation.com/t/syncing-gateway-clock-to-plc-clock/12279 "2019-04-03T18:27:17Z")
Hi Guys, for some weird reason the PLC that we use to get all the data for Ignition keeps drifting off about a second every day or two. What I figured was try to sync the gateway time to the PLC time manually so I create… --- ## [Shared script runs in console but not as Gateway event script](https://forum.inductiveautomation.com/t/shared-script-runs-in-console-but-not-as-gateway-event-script/23799)
**Author:** [@rpulsifer](https://forum.inductiveautomation.com/u/rpulsifer)\ **Replies:** 8\ **Last updated:** [April 3, 2019, 6:04pm UTC](https://forum.inductiveautomation.com/t/shared-script-runs-in-console-but-not-as-gateway-event-script/23799 "2019-04-03T18:04:18Z")
I developed this script in the script console and it runs just as I want it to, BUT saving it as a Shared script function and calling it from a tag-change Gateway event script I get the screwy-est error: line 41 in cal… --- ## [SProcCall params](https://forum.inductiveautomation.com/t/sproccall-params/23823)
**Author:** [@apurdy](https://forum.inductiveautomation.com/u/apurdy)\ **Replies:** 0\ **Last updated:** [April 3, 2019, 5:32pm UTC](https://forum.inductiveautomation.com/t/sproccall-params/23823 "2019-04-03T17:32:40Z")
Is there a way to access the params in the SProcCall? Here’s my conundrum… When I make a stored procedure call, I also want to print out the input parameters for operator knowledge as well as log the inputs. We have sev… --- ## [Getting a specific time frame from tag historian](https://forum.inductiveautomation.com/t/getting-a-specific-time-frame-from-tag-historian/23815)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 9\ **Last updated:** [April 3, 2019, 5:31pm UTC](https://forum.inductiveautomation.com/t/getting-a-specific-time-frame-from-tag-historian/23815 "2019-04-03T17:31:13Z")
I am working on a project that has a many tags being recorded using Tag Historian. End result of what I want is for there to be a button to be clicked twice - once to start and once to stop. I record the timestamp of t… --- ## [\[Fixed\]New Nightly Published](https://forum.inductiveautomation.com/t/fixed-new-nightly-published/22851)
**Author:** [@joe.friedrich](https://forum.inductiveautomation.com/u/joe.friedrich)\ **Replies:** 9\ **Last updated:** [April 3, 2019, 5:18pm UTC](https://forum.inductiveautomation.com/t/fixed-new-nightly-published/22851 "2019-04-03T17:18:08Z")
Looks like a new nightly has not been published. I didn’t see an announcement, so I figured I would post it here. --- ## [Reporting Bar Graph Using Part of my Dataset as a Legend](https://forum.inductiveautomation.com/t/reporting-bar-graph-using-part-of-my-dataset-as-a-legend/23817)
**Author:** [@EEdmondson](https://forum.inductiveautomation.com/u/EEdmondson)\ **Replies:** 0\ **Last updated:** [April 3, 2019, 3:42pm UTC](https://forum.inductiveautomation.com/t/reporting-bar-graph-using-part-of-my-dataset-as-a-legend/23817 "2019-04-03T15:42:08Z")
My bar graph in my report is using most of my data to populate the bars of the graph (as it should) but then it leaves out one column from my named query that I want displayed and it puts the value in the graph legend. W… --- ## [Power Table Data Historical Start/End Date binding not updating in runtime](https://forum.inductiveautomation.com/t/power-table-data-historical-start-end-date-binding-not-updating-in-runtime/23816)
**Author:** [@andytimc](https://forum.inductiveautomation.com/u/andytimc)\ **Replies:** 0\ **Last updated:** [April 3, 2019, 3:36pm UTC](https://forum.inductiveautomation.com/t/power-table-data-historical-start-end-date-binding-not-updating-in-runtime/23816 "2019-04-03T15:36:40Z")
I have a pop-up window which shows a tag history trend and a table of datapoints for the same tag. The table start Date and End Date Bindings are tied to the Easy Chart Start Date and End Date bindings. However, in runti… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1537) [Next page](https://forum.inductiveautomation.com/latest.md?page=1539)