# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1415 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1416 --- ## [Stored procedure group parameter parse error](https://forum.inductiveautomation.com/t/stored-procedure-group-parameter-parse-error/15336)
**Author:** [@richardNZ15](https://forum.inductiveautomation.com/u/richardNZ15)\ **Replies:** 1\ **Last updated:** [September 13, 2017, 10:42pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-group-parameter-parse-error/15336 "2017-09-13T22:42:32Z")
I have set up a very simple stored procedure in HeidiSQL to update a value in a row based on a single input parameter. CREATE DEFINER=\`ignition\`@\`%\` PROCEDURE \`ProofTestFailure\`(IN \`SerialNumParam\` BIGINT) LANGUAGE SQL… --- ## [Block group / expression item](https://forum.inductiveautomation.com/t/block-group-expression-item/6170)
**Author:** [@Pat](https://forum.inductiveautomation.com/u/Pat)\ **Replies:** 3\ **Last updated:** [September 13, 2017, 9:25pm UTC](https://forum.inductiveautomation.com/t/block-group-expression-item/6170 "2017-09-13T21:25:42Z")
Is it possible to use an expression item's value as a value in a block group item? It seems the only possible values for a block item is OPC, SQLTag, or Static. :neutral\_face: --- ## [Check if utd tag has string value and change the color of the label](https://forum.inductiveautomation.com/t/check-if-utd-tag-has-string-value-and-change-the-color-of-the-label/15309)
**Author:** [@jbb5310](https://forum.inductiveautomation.com/u/jbb5310)\ **Replies:** 7\ **Last updated:** [September 13, 2017, 8:19pm UTC](https://forum.inductiveautomation.com/t/check-if-utd-tag-has-string-value-and-change-the-color-of-the-label/15309 "2017-09-13T20:19:44Z")
I would like to know if there is a script that checks if a utd tag (string) is not null and then change the color of a label based on whether the tag has a string or not --- ## [UDT Inherited Override Scan Class not Saving](https://forum.inductiveautomation.com/t/udt-inherited-override-scan-class-not-saving/15330)
**Author:** [@matt.hays](https://forum.inductiveautomation.com/u/matt.hays)\ **Replies:** 0\ **Last updated:** [September 13, 2017, 2:31pm UTC](https://forum.inductiveautomation.com/t/udt-inherited-override-scan-class-not-saving/15330 "2017-09-13T14:31:49Z")
I have a child UDT and clicked the General Scan Class override by mistake. Now I want to "un-override" it but when clicking Apply or OK, this doesn't seem to save the setting. Is anyone else seeing this? Similar problem… --- ## [System.security.username](https://forum.inductiveautomation.com/t/system-security-username/15316)
**Author:** [@jbb5310](https://forum.inductiveautomation.com/u/jbb5310)\ **Replies:** 2\ **Last updated:** [September 12, 2017, 3:44pm UTC](https://forum.inductiveautomation.com/t/system-security-username/15316 "2017-09-12T15:44:18Z")
I want to be able to grab the username of the logged in person and display it on as a text label --- ## [Report Controls](https://forum.inductiveautomation.com/t/report-controls/15311)
**Author:** [@jason\_reinhard](https://forum.inductiveautomation.com/u/jason_reinhard)\ **Replies:** 1\ **Last updated:** [September 12, 2017, 3:09pm UTC](https://forum.inductiveautomation.com/t/report-controls/15311 "2017-09-12T15:09:11Z")
Hello! There are a few things I'd like to ideally do with a report but not sure how. Is there a way to make a table column sortable via clicking on its' header? Is there a way to insert a control such as a button into… --- ## [Ignition tags and MS. Excel](https://forum.inductiveautomation.com/t/ignition-tags-and-ms-excel/10514)
**Author:** [@Mr.K001](https://forum.inductiveautomation.com/u/Mr.K001)\ **Replies:** 6\ **Last updated:** [September 12, 2017, 3:07pm UTC](https://forum.inductiveautomation.com/t/ignition-tags-and-ms-excel/10514 "2017-09-12T15:07:40Z")
Hi guys, so i'd like to know if it is possible to be able to compare a tag value on ignition with an excel sheet to get another value. the part number coming from the PLC needs to be compared to a excel sheet and be able… --- ## [Calendar customizing](https://forum.inductiveautomation.com/t/calendar-customizing/15279)
**Author:** [@wokenup](https://forum.inductiveautomation.com/u/wokenup)\ **Replies:** 2\ **Last updated:** [September 12, 2017, 5:06am UTC](https://forum.inductiveautomation.com/t/calendar-customizing/15279 "2017-09-12T05:06:31Z")
Hi guys, I'm trying to configure a calendar component for selection data from the past. It works OK however when you select a future date, it shows an error due to no data stored in DB. I tried scripting in calendar comp… --- ## [Designer Wont Launch](https://forum.inductiveautomation.com/t/designer-wont-launch/15197)
**Author:** [@Jayden](https://forum.inductiveautomation.com/u/Jayden)\ **Replies:** 4\ **Last updated:** [September 12, 2017, 2:29am UTC](https://forum.inductiveautomation.com/t/designer-wont-launch/15197 "2017-09-12T02:29:45Z")
Hi everyone, I'm having issues with the designer not opening on multiple clients. The only place I can get it to work is on the server itself. When clicking the "Launch Designer" button, the Java splash screen is disp… --- ## [OPC DCOM write error](https://forum.inductiveautomation.com/t/opc-dcom-write-error/15204)
**Author:** [@roshanbhosale](https://forum.inductiveautomation.com/u/roshanbhosale)\ **Replies:** 1\ **Last updated:** [September 11, 2017, 1:31pm UTC](https://forum.inductiveautomation.com/t/opc-dcom-write-error/15204 "2017-09-11T13:31:34Z")
Hi, everyone I am facing the following problem when trying to write to the MFX's MCO1OPC server. I am getting following error in log file. What may be the cause of such issue? INFO | jvm 1 | 2017/08/30 16:17:58 … --- ## [Clearing an Alarm for a machine that has been turned off](https://forum.inductiveautomation.com/t/clearing-an-alarm-for-a-machine-that-has-been-turned-off/15299)
**Author:** [@jbb5310](https://forum.inductiveautomation.com/u/jbb5310)\ **Replies:** 0\ **Last updated:** [September 11, 2017, 1:11pm UTC](https://forum.inductiveautomation.com/t/clearing-an-alarm-for-a-machine-that-has-been-turned-off/15299 "2017-09-11T13:11:47Z")
I am having a issue with "orphan alarms". A alarm that has been set to active but never clearing due to the machine being turned off. I am wondering if there is a why to 1) force an active alarm to clear by anyone with … --- ## [Connect to the ignition server remotely](https://forum.inductiveautomation.com/t/connect-to-the-ignition-server-remotely/15298)
**Author:** [@mpoulsen921](https://forum.inductiveautomation.com/u/mpoulsen921)\ **Replies:** 5\ **Last updated:** [September 11, 2017, 12:30pm UTC](https://forum.inductiveautomation.com/t/connect-to-the-ignition-server-remotely/15298 "2017-09-11T12:30:12Z")
Hi, I have a question regarding connecting to a gateway remotely. Let me clarify this with what I have done so far. I have a windows computer running the gateway on port 8080. The computer is hooked up to a router a… --- ## [SQL query working in query browser, not as a binding](https://forum.inductiveautomation.com/t/sql-query-working-in-query-browser-not-as-a-binding/15291)
**Author:** [@Plantformance](https://forum.inductiveautomation.com/u/Plantformance)\ **Replies:** 5\ **Last updated:** [September 10, 2017, 1:19pm UTC](https://forum.inductiveautomation.com/t/sql-query-working-in-query-browser-not-as-a-binding/15291 "2017-09-10T13:19:12Z")
Hey guys I have the following query SELECT param\_code as name, "station\_forCanvas" as template, 200+200\*COS(PI()\*param\_angle/180.0) as x, 200+200\*SIN(PI()\*param\_angle/180.0) as y, 50 as width, 50 as height, … --- ## [Bar labels on a chart in report](https://forum.inductiveautomation.com/t/bar-labels-on-a-chart-in-report/15283)
**Author:** [@wg1](https://forum.inductiveautomation.com/u/wg1)\ **Replies:** 2\ **Last updated:** [September 8, 2017, 7:36pm UTC](https://forum.inductiveautomation.com/t/bar-labels-on-a-chart-in-report/15283 "2017-09-08T19:36:57Z")
Hello, i have a bar chart in which scripting has been enabled to change the bar color based on the value (barRenderer). Does anyone know how to make the bar label visible through the script? --- ## [Problem with SQL Query in a Tag change script](https://forum.inductiveautomation.com/t/problem-with-sql-query-in-a-tag-change-script/15244)
**Author:** [@Enginiosys](https://forum.inductiveautomation.com/u/Enginiosys)\ **Replies:** 4\ **Last updated:** [September 8, 2017, 7:38am UTC](https://forum.inductiveautomation.com/t/problem-with-sql-query-in-a-tag-change-script/15244 "2017-09-08T07:38:42Z")
Good evening all, We are actually facing some difficulties to put an SQL query inside a Tag change Script. We are actually having an error message looking like : .......", line 7, in valueChanged at com.inductiveauto… --- ## [Client Performance Strategy](https://forum.inductiveautomation.com/t/client-performance-strategy/15272)
**Author:** [@robert1](https://forum.inductiveautomation.com/u/robert1)\ **Replies:** 3\ **Last updated:** [September 8, 2017, 3:53am UTC](https://forum.inductiveautomation.com/t/client-performance-strategy/15272 "2017-09-08T03:53:30Z")
Hello- This is going to be a fairly vague question (sorry) but I'm curious if anyone could give me some general strategies for building clients using "advanced" features and a lot of SQL queries that run more efficient… --- ## [Power Table column width binding](https://forum.inductiveautomation.com/t/power-table-column-width-binding/14213)
**Author:** [@maidamar](https://forum.inductiveautomation.com/u/maidamar)\ **Replies:** 11\ **Last updated:** [September 7, 2017, 11:04pm UTC](https://forum.inductiveautomation.com/t/power-table-column-width-binding/14213 "2017-09-07T23:04:38Z")
Dear all: I have two power tables shown on screen, one above and one below. The data shown in both is similar (as in they share the same column names). What I would like to be able to do is to resize the columns of one t… --- ## [Reports - Row Versioning with parameters](https://forum.inductiveautomation.com/t/reports-row-versioning-with-parameters/15275)
**Author:** [@patrick.maltais](https://forum.inductiveautomation.com/u/patrick.maltais)\ **Replies:** 2\ **Last updated:** [September 7, 2017, 7:47pm UTC](https://forum.inductiveautomation.com/t/reports-row-versioning-with-parameters/15275 "2017-09-07T19:47:05Z")
I would like to hide some rows based on an option passed as a parameter to the report. Lets say I have a parameter named "showType2" and the this option is controlled from the calling window and passed to the Report Vi… --- ## [Pydataset returns â following value](https://forum.inductiveautomation.com/t/pydataset-returns-a-following-value/15229)
**Author:** [@cja7928](https://forum.inductiveautomation.com/u/cja7928)\ **Replies:** 2\ **Last updated:** [September 7, 2017, 7:14pm UTC](https://forum.inductiveautomation.com/t/pydataset-returns-a-following-value/15229 "2017-09-07T19:14:49Z")
the following code returns â at the end of the string. If I strip off the last character it doesnt strip the â it strips the last character from my desired value and the â remains. can anyone tell me what im doing wron… --- ## [SPC Control Capability chart in report](https://forum.inductiveautomation.com/t/spc-control-capability-chart-in-report/15180)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 1\ **Last updated:** [September 7, 2017, 4:46pm UTC](https://forum.inductiveautomation.com/t/spc-control-capability-chart-in-report/15180 "2017-09-07T16:46:30Z")
I am using the SPC module to collect samples of this tag. I would like to make 2 graphs in the reporting module. The first would be like this script and I am looking to show upper set limits and lower set limits too. Th… --- ## [Why does the font in my designer and clients look so bad?](https://forum.inductiveautomation.com/t/why-does-the-font-in-my-designer-and-clients-look-so-bad/15268)
**Author:** [@iamthebull](https://forum.inductiveautomation.com/u/iamthebull)\ **Replies:** 1\ **Last updated:** [September 7, 2017, 10:27am UTC](https://forum.inductiveautomation.com/t/why-does-the-font-in-my-designer-and-clients-look-so-bad/15268 "2017-09-07T10:27:25Z")
I just installed ignition on Ubuntu 16.04.3. The font in the designer and clients looks horrible. Can I change this somehow? Ignition 7.9.4 openjdk version “1.8.0\_131” --- ## [View Quarantined Data in Store and Forward 7.8](https://forum.inductiveautomation.com/t/view-quarantined-data-in-store-and-forward-7-8/15257)
**Author:** [@marc.smith](https://forum.inductiveautomation.com/u/marc.smith)\ **Replies:** 4\ **Last updated:** [September 6, 2017, 11:15pm UTC](https://forum.inductiveautomation.com/t/view-quarantined-data-in-store-and-forward-7-8/15257 "2017-09-06T23:15:13Z")
Hi all, I'm having an issue with a Historical Tag database at the moment. It was working fine till this morning when I then looked at the store and forward information about found a lot of data Quarantined. I retried… --- ## [Alarm Pipeline (Stuck)](https://forum.inductiveautomation.com/t/alarm-pipeline-stuck/15029)
**Author:** [@bfearnow](https://forum.inductiveautomation.com/u/bfearnow)\ **Replies:** 1\ **Last updated:** [September 6, 2017, 10:19pm UTC](https://forum.inductiveautomation.com/t/alarm-pipeline-stuck/15029 "2017-09-06T22:19:37Z")
I have an alarm pipeline that is continuously sending out blank messages. The message I want it to send is on the tag’s alarm properties. It works fine for a while and then quits. On the gateway I get the following: C… --- ## [Controllogix PLC comments](https://forum.inductiveautomation.com/t/controllogix-plc-comments/15265)
**Author:** [@phayes057](https://forum.inductiveautomation.com/u/phayes057)\ **Replies:** 1\ **Last updated:** [September 6, 2017, 9:40pm UTC](https://forum.inductiveautomation.com/t/controllogix-plc-comments/15265 "2017-09-06T21:40:05Z")
With controllogix PLC firmware 24 and higher, rung comments are stored in the PLC memory. Is it possible to browse these comments with the OPC browser in Designer? --- ## [java.nio.channels.UnresolvedAddressException](https://forum.inductiveautomation.com/t/java-nio-channels-unresolvedaddressexception/15263)
**Author:** [@iamthebull](https://forum.inductiveautomation.com/u/iamthebull)\ **Replies:** 1\ **Last updated:** [September 6, 2017, 7:23pm UTC](https://forum.inductiveautomation.com/t/java-nio-channels-unresolvedaddressexception/15263 "2017-09-06T19:23:56Z")
I just installed ubuntu 16.04.3 on my desktop and moved ignition over. I am using a third party OPC server (Siemens Simatic Net V14) on a virtual machine (virtualbox) and I have that now running on the new installation. … --- ## [How would I implement a loading icon for a bar chart running a sql statement](https://forum.inductiveautomation.com/t/how-would-i-implement-a-loading-icon-for-a-bar-chart-running-a-sql-statement/15249)
**Author:** [@jbb5310](https://forum.inductiveautomation.com/u/jbb5310)\ **Replies:** 7\ **Last updated:** [September 6, 2017, 2:44pm UTC](https://forum.inductiveautomation.com/t/how-would-i-implement-a-loading-icon-for-a-bar-chart-running-a-sql-statement/15249 "2017-09-06T14:44:00Z")
I understand that there is a loadingproperties for the easy chart which is great but I would like to know if there is one for the different graphs. I am using a bar graph to visually depict the number of alarms per day f… --- ## [Vertical Pipe Segments](https://forum.inductiveautomation.com/t/vertical-pipe-segments/15262)
**Author:** [@tenyard](https://forum.inductiveautomation.com/u/tenyard)\ **Replies:** 2\ **Last updated:** [September 6, 2017, 2:09pm UTC](https://forum.inductiveautomation.com/t/vertical-pipe-segments/15262 "2017-09-06T14:09:56Z")
I am just starting out with Ignition and I see in the manuals that the provided Pipe Segments can either be horizontal or vertical. From what I can see, I can only create horizontal pipes and I do not have an option to r… --- ## [Powertable - row selection based on cursor's click / move](https://forum.inductiveautomation.com/t/powertable-row-selection-based-on-cursors-click-move/15243)
**Author:** [@szcz](https://forum.inductiveautomation.com/u/szcz)\ **Replies:** 4\ **Last updated:** [September 5, 2017, 11:21pm UTC](https://forum.inductiveautomation.com/t/powertable-row-selection-based-on-cursors-click-move/15243 "2017-09-05T23:21:46Z")
Hello Ignition wizards, I’d kindly like to ask you for help regarding PowerTable. What would be the most ultimate coolest thing: As cursor is being moved across the PowerTable, the rows of the powertable would change co… --- ## [Problem on Report Viewer Save as PDF (Saves 0 Bytes) HELP!](https://forum.inductiveautomation.com/t/problem-on-report-viewer-save-as-pdf-saves-0-bytes-help/15224)
**Author:** [@caritoel27](https://forum.inductiveautomation.com/u/caritoel27)\ **Replies:** 4\ **Last updated:** [September 5, 2017, 11:03pm UTC](https://forum.inductiveautomation.com/t/problem-on-report-viewer-save-as-pdf-saves-0-bytes-help/15224 "2017-09-05T23:03:39Z")
Hi, I write about a problem I am having with saving Report with Report Viewer. It saves with First I thought it was the type of font, but it is not. I have 2 timeseries chart on the report, Then I observed that if I de… --- ## [propertyChange event on componentRunning overhead](https://forum.inductiveautomation.com/t/propertychange-event-on-componentrunning-overhead/15256)
**Author:** [@brian.mcenulty](https://forum.inductiveautomation.com/u/brian.mcenulty)\ **Replies:** 3\ **Last updated:** [September 5, 2017, 9:47pm UTC](https://forum.inductiveautomation.com/t/propertychange-event-on-componentrunning-overhead/15256 "2017-09-05T21:47:13Z")
I'm curious when creating a propertyChange component script that is triggered from the "componentRunning" property, how often is this script executed and what are the possible ramifications from doing this when it comes … [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1414) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1416)