# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1683 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1684 --- ## [Display a Tag Trend as default last 5 mins when dragged onto a mimic](https://forum.inductiveautomation.com/t/display-a-tag-trend-as-default-last-5-mins-when-dragged-onto-a-mimic/15340)
**Author:** [@AkikRanade](https://forum.inductiveautomation.com/u/AkikRanade)\ **Replies:** 0\ **Last updated:** [September 14, 2017, 2:36pm UTC](https://forum.inductiveautomation.com/t/display-a-tag-trend-as-default-last-5-mins-when-dragged-onto-a-mimic/15340 "2017-09-14T14:36:28Z")
When I drag any tag from my Tag Browser onto the mimic window, is there a way to have Sparkline Chart as an option to display the tag just like the LED label or Numeric Label. I know dragging a tag onto a chart component… --- ## [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 --- ## [Windows 10 - 4k Monitor Resolution](https://forum.inductiveautomation.com/t/windows-10-4k-monitor-resolution/10819)
**Author:** [@Zer0Cool91](https://forum.inductiveautomation.com/u/Zer0Cool91)\ **Replies:** 10\ **Last updated:** [September 13, 2017, 6:08pm UTC](https://forum.inductiveautomation.com/t/windows-10-4k-monitor-resolution/10819 "2017-09-13T18:08:43Z")
Hey guys, Recently got a new laptop with 4k resolution, problem is when I run the ignition designer, it's not being resized by Windows to be readable. For example, windows adjusts most apps to increase the size by wh… --- ## [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… --- ## [Java memory allocation problem](https://forum.inductiveautomation.com/t/java-memory-allocation-problem/15325)
**Author:** [@BHASKAR](https://forum.inductiveautomation.com/u/BHASKAR)\ **Replies:** 1\ **Last updated:** [September 13, 2017, 1:01pm UTC](https://forum.inductiveautomation.com/t/java-memory-allocation-problem/15325 "2017-09-13T13:01:53Z")
Hi, I am using Java 1.8.51 32 bit vesrion on Windows 7 and Ubuntu 16.04. Limitation of Java 32 bit is 1.6GB max... I want to run Ignition Clients with 4GB ram............ is there any way to change the memory usage lim… --- ## [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… --- ## [2 keyboards at the same time](https://forum.inductiveautomation.com/t/2-keyboards-at-the-same-time/15302)
**Author:** [@Silvia\_Fernandez](https://forum.inductiveautomation.com/u/Silvia_Fernandez)\ **Replies:** 0\ **Last updated:** [September 11, 2017, 4:21pm UTC](https://forum.inductiveautomation.com/t/2-keyboards-at-the-same-time/15302 "2017-09-11T16:21:26Z")
Hello, I have created a mobile application for an ipad, and every time I press an analog input , 2 keyboards appear at the same time. One of them it's a small popup and the other one is located on the bottom of the scree… --- ## [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, … --- ## [Indirect Tag with calc](https://forum.inductiveautomation.com/t/indirect-tag-with-calc/15290)
**Author:** [@antoniosantos\_ccb](https://forum.inductiveautomation.com/u/antoniosantos_ccb)\ **Replies:** 2\ **Last updated:** [September 9, 2017, 7:38pm UTC](https://forum.inductiveautomation.com/t/indirect-tag-with-calc/15290 "2017-09-09T19:38:03Z")
Hello. I need to convert temperature and I am using indirect tag. Is it possible to convert using calc ? ((Tank {1}/Tb\_Temperatura)-30)/2 What can I do to use indirect tag and show the tempurature converted? --- ## [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? --- ## [Template repeater Parameter](https://forum.inductiveautomation.com/t/template-repeater-parameter/15284)
**Author:** [@antoniosantos\_ccb](https://forum.inductiveautomation.com/u/antoniosantos_ccb)\ **Replies:** 1\ **Last updated:** [September 8, 2017, 7:29pm UTC](https://forum.inductiveautomation.com/t/template-repeater-parameter/15284 "2017-09-08T19:29:47Z")
Hello. The values of an integer parameter start by default at zero. When I put it to repeat 5 times for example it goes from 0 to 4 but I would like to show from 1 to 5 and the tags match. it's possible? --- ## [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… --- ## [@AsyncFunction not getting progress dialog](https://forum.inductiveautomation.com/t/asyncfunction-not-getting-progress-dialog/15273)
**Author:** [@ryan.minniear](https://forum.inductiveautomation.com/u/ryan.minniear)\ **Replies:** 0\ **Last updated:** [September 7, 2017, 5:50pm UTC](https://forum.inductiveautomation.com/t/asyncfunction-not-getting-progress-dialog/15273 "2017-09-07T17:50:29Z")
I am working with an RPC call that may potentially take longer than the 60 second timeout and so I am attempting to use @AsyncFunction to get around this. I have followed the doc here for "Tracking Progress on the Gatewa… --- ## [Hide a Table (NOT Power Table) Rows or set rows height](https://forum.inductiveautomation.com/t/hide-a-table-not-power-table-rows-or-set-rows-height/15221)
**Author:** [@antoniosantos\_ccb](https://forum.inductiveautomation.com/u/antoniosantos_ccb)\ **Replies:** 1\ **Last updated:** [September 7, 2017, 5:34pm UTC](https://forum.inductiveautomation.com/t/hide-a-table-not-power-table-rows-or-set-rows-height/15221 "2017-09-07T17:34:46Z")
Please I have a problem to resolve. How can I hide a Table rows or set row height to 0? Please help me! --- ## [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… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1682) [Next page](https://forum.inductiveautomation.com/latest.md?page=1684)