# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1386 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1387 --- ## [Running two different queries based on client time of day](https://forum.inductiveautomation.com/t/running-two-different-queries-based-on-client-time-of-day/17430)
**Author:** [@cagibson](https://forum.inductiveautomation.com/u/cagibson)\ **Replies:** 2\ **Last updated:** [March 20, 2018, 7:28pm UTC](https://forum.inductiveautomation.com/t/running-two-different-queries-based-on-client-time-of-day/17430 "2018-03-20T19:28:31Z")
There are two SQL scrips I have and they are to be ran depending on what time of day (e.i. 18:00 to 23:59, and 00:00 to 18:00). I have a Table object that can only take one SQL Query for the Data property binding. I'm tr… --- ## [Data type esctructure](https://forum.inductiveautomation.com/t/data-type-esctructure/17394)
**Author:** [@edwingoth](https://forum.inductiveautomation.com/u/edwingoth)\ **Replies:** 5\ **Last updated:** [March 20, 2018, 4:12pm UTC](https://forum.inductiveautomation.com/t/data-type-esctructure/17394 "2018-03-20T16:12:42Z")
Hi, can you help me? I need to write about the value of an alarm based on the activation of another alarm, I am working with one (newexpresiontag), in the option of “Expersion” I am writing the status of the alarm. B… --- ## [Status chart getToolTipText custom string](https://forum.inductiveautomation.com/t/status-chart-gettooltiptext-custom-string/17434)
**Author:** [@vanko25](https://forum.inductiveautomation.com/u/vanko25)\ **Replies:** 1\ **Last updated:** [March 20, 2018, 11:13am UTC](https://forum.inductiveautomation.com/t/status-chart-gettooltiptext-custom-string/17434 "2018-03-20T11:13:44Z")
Hi all, I am trying to return a custom tooltip on my statuschart with the following piece of code in the getToolTipText() extension function but it does return the default tool tip. import system startDate = system.… --- ## [Button template dynamic border](https://forum.inductiveautomation.com/t/button-template-dynamic-border/17420)
**Author:** [@sbrannen](https://forum.inductiveautomation.com/u/sbrannen)\ **Replies:** 2\ **Last updated:** [March 20, 2018, 10:34am UTC](https://forum.inductiveautomation.com/t/button-template-dynamic-border/17420 "2018-03-20T10:34:05Z")
Good day all... I think my issue is simple. I have a button template that I am trying to dynamically set the border property based on template custom properties, but so far it's not working and not making much sense (… --- ## [Identify label text limits](https://forum.inductiveautomation.com/t/identify-label-text-limits/17423)
**Author:** [@cmason](https://forum.inductiveautomation.com/u/cmason)\ **Replies:** 4\ **Last updated:** [March 20, 2018, 7:50am UTC](https://forum.inductiveautomation.com/t/identify-label-text-limits/17423 "2018-03-20T07:50:04Z")
I’m wanting to figure out when the text in a label is being truncated because it is too long. I see that when this happens a set of periods are displayed on the trailing end, as shown in the picture. I’m wondering if I c… --- ## [Alarm Active Tag Event Script](https://forum.inductiveautomation.com/t/alarm-active-tag-event-script/17285)
**Author:** [@Ben\_Sladden1](https://forum.inductiveautomation.com/u/Ben_Sladden1)\ **Replies:** 3\ **Last updated:** [March 20, 2018, 12:49am UTC](https://forum.inductiveautomation.com/t/alarm-active-tag-event-script/17285 "2018-03-20T00:49:43Z")
We have recently upgraded to 7.9.6 and some of our existing alarm active/cleared/ack scripts have started to fail. It appears that the alarm event object no longer has a id parameter. example: putting print "zzzzzzz… --- ## [Storing Data to Historical Database with Custom Timestamp](https://forum.inductiveautomation.com/t/storing-data-to-historical-database-with-custom-timestamp/17415)
**Author:** [@brad.sampson](https://forum.inductiveautomation.com/u/brad.sampson)\ **Replies:** 3\ **Last updated:** [March 19, 2018, 7:35pm UTC](https://forum.inductiveautomation.com/t/storing-data-to-historical-database-with-custom-timestamp/17415 "2018-03-19T19:35:03Z")
Hello, I am trying to store sample data from a continuous process and I would like to trend these sample results along side historical OPC tags (temp, press, ect.). My problem is that I need these values to be time sta… --- ## [Transaction Group Max limit](https://forum.inductiveautomation.com/t/transaction-group-max-limit/17406)
**Author:** [@roshanbhosale](https://forum.inductiveautomation.com/u/roshanbhosale)\ **Replies:** 5\ **Last updated:** [March 19, 2018, 6:07pm UTC](https://forum.inductiveautomation.com/t/transaction-group-max-limit/17406 "2018-03-19T18:07:57Z")
HI, I would like to know the max.limit of transaction groups that can be defined in ignition 7.8.4 version, having the license of SQL-Bridge module. --- ## [Count alarma active](https://forum.inductiveautomation.com/t/count-alarma-active/17418)
**Author:** [@edwingoth](https://forum.inductiveautomation.com/u/edwingoth)\ **Replies:** 0\ **Last updated:** [March 19, 2018, 4:29pm UTC](https://forum.inductiveautomation.com/t/count-alarma-active/17418 "2018-03-19T16:29:58Z")
Hi. I need to add the number of times that a larm was active during a period of time of work, that is if the alarm was activated 10 times in the day, I want to count those times and write that value in a new tag. --- ## [Java 9 Released](https://forum.inductiveautomation.com/t/java-9-released/15465)
**Author:** [@ryanjmclaughlin](https://forum.inductiveautomation.com/u/ryanjmclaughlin)\ **Replies:** 7\ **Last updated:** [March 19, 2018, 3:47pm UTC](https://forum.inductiveautomation.com/t/java-9-released/15465 "2018-03-19T15:47:38Z")
So, Java 9 is out! I usually figure Ignition is on top of all the new things, but it appears there is no support for Java 9 yet (lots of launch errors). I assume the suggestion is to stay on Java 8 at this time? Is 7.… --- ## [Component property to check security disable events status](https://forum.inductiveautomation.com/t/component-property-to-check-security-disable-events-status/17392)
**Author:** [@JMicky](https://forum.inductiveautomation.com/u/JMicky)\ **Replies:** 1\ **Last updated:** [March 19, 2018, 2:36pm UTC](https://forum.inductiveautomation.com/t/component-property-to-check-security-disable-events-status/17392 "2018-03-19T14:36:36Z")
Hi, Does anyone know of a component property that reflects the components security disable events status? I have a container that opens a pop-up control window when clicked. If the user does not have permissions to c… --- ## [Find if machine ran in last hour Tag Historian](https://forum.inductiveautomation.com/t/find-if-machine-ran-in-last-hour-tag-historian/17414)
**Author:** [@vanko25](https://forum.inductiveautomation.com/u/vanko25)\ **Replies:** 2\ **Last updated:** [March 19, 2018, 12:55pm UTC](https://forum.inductiveautomation.com/t/find-if-machine-ran-in-last-hour-tag-historian/17414 "2018-03-19T12:55:22Z")
Hello all, I am trying to find if a machine ran in the last hour. So even if it is off now but it has ran in the last hour I am looking at getting Boolean true. I am looking at the historian of my Boolean status bit wi… --- ## [Template random resize](https://forum.inductiveautomation.com/t/template-random-resize/17412)
**Author:** [@Claus\_Nielsen](https://forum.inductiveautomation.com/u/Claus_Nielsen)\ **Replies:** 0\ **Last updated:** [March 19, 2018, 9:40am UTC](https://forum.inductiveautomation.com/t/template-random-resize/17412 "2018-03-19T09:40:53Z")
Is there some document describing how to set the layout inside a template to make the resize behave as expected, both when resized in the designer and when the window size changes in the client? Never had any problems se… --- ## [Query against another object dataset](https://forum.inductiveautomation.com/t/query-against-another-object-dataset/10219)
**Author:** [@tdornbush](https://forum.inductiveautomation.com/u/tdornbush)\ **Replies:** 5\ **Last updated:** [March 17, 2018, 7:52pm UTC](https://forum.inductiveautomation.com/t/query-against-another-object-dataset/10219 "2018-03-17T19:52:20Z")
Thanks for all the help I've gotten already by browsing the forum, but I couldn't find an answer to this one: Is there a way to run a query or otherwise access the data in a dataset that is displayed in a table? I ha… --- ## [SQL Query Binding question](https://forum.inductiveautomation.com/t/sql-query-binding-question/17395)
**Author:** [@Brian](https://forum.inductiveautomation.com/u/Brian)\ **Replies:** 2\ **Last updated:** [March 16, 2018, 7:44pm UTC](https://forum.inductiveautomation.com/t/sql-query-binding-question/17395 "2018-03-16T19:44:15Z")
I have a label's text field bound to a SQL query. The query is below: select recipe\_running from furnace\_loads where id = {Root Container.Equipment Schedule.selectedEvent} The id value is being supplied by a compon… --- ## [Full Featured Easy Chart / User Configuration Saving](https://forum.inductiveautomation.com/t/full-featured-easy-chart-user-configuration-saving/17390)
**Author:** [@mcarritt1](https://forum.inductiveautomation.com/u/mcarritt1)\ **Replies:** 8\ **Last updated:** [March 16, 2018, 6:38pm UTC](https://forum.inductiveautomation.com/t/full-featured-easy-chart-user-configuration-saving/17390 "2018-03-16T18:38:21Z")
Hi, before I do all the work I thought I might ask if anyone would like to share with me a full featured chart page? Looking to enable customization for the user for things like pen style, subplot, tagname, etc. with thi… --- ## [Tree View - Drag and drop function](https://forum.inductiveautomation.com/t/tree-view-drag-and-drop-function/17391)
**Author:** [@dhananjay\_vichare](https://forum.inductiveautomation.com/u/dhananjay_vichare)\ **Replies:** 0\ **Last updated:** [March 16, 2018, 12:30pm UTC](https://forum.inductiveautomation.com/t/tree-view-drag-and-drop-function/17391 "2018-03-16T12:30:46Z")
Ignition 7.9.4 and Java 1.8.0\_161-b12 We are using Ignition’s Tree View component and trying to implement drag and drop functionality in same tree view. Our requirement is to pick a step from one location and move to ot… --- ## [Template repeater with Dataset behaviour to update SQL table](https://forum.inductiveautomation.com/t/template-repeater-with-dataset-behaviour-to-update-sql-table/17336)
**Author:** [@vanko25](https://forum.inductiveautomation.com/u/vanko25)\ **Replies:** 2\ **Last updated:** [March 16, 2018, 11:35am UTC](https://forum.inductiveautomation.com/t/template-repeater-with-dataset-behaviour-to-update-sql-table/17336 "2018-03-16T11:35:12Z")
Hi all, I am currently experimenting with the Template repeater. I have set my template and the template behaviour to Dataset which pulls data from a table in my SQL server. It displays the templates ok but when I try t… --- ## [Template internal UDT](https://forum.inductiveautomation.com/t/template-internal-udt/17388)
**Author:** [@Claus\_Nielsen](https://forum.inductiveautomation.com/u/Claus_Nielsen)\ **Replies:** 2\ **Last updated:** [March 16, 2018, 9:56am UTC](https://forum.inductiveautomation.com/t/template-internal-udt/17388 "2018-03-16T09:56:54Z")
Having a few templates where I 'group' some properties by using a dataset, however I stumbled upon a post here, somewhere I can't find right now, indicating UDT types can be used as internal properties and accessed direc… --- ## [Setting up bound value on chart](https://forum.inductiveautomation.com/t/setting-up-bound-value-on-chart/17372)
**Author:** [@Mel](https://forum.inductiveautomation.com/u/Mel)\ **Replies:** 5\ **Last updated:** [March 16, 2018, 6:42am UTC](https://forum.inductiveautomation.com/t/setting-up-bound-value-on-chart/17372 "2018-03-16T06:42:46Z")
Is it possible to have a separate script for having a lower and upper bound value on chart while it has current value of scatter came from dataset query. For example here in my data, I have my scatter plot in the chart … --- ## [Recommended SIP to Cellular Gateways?](https://forum.inductiveautomation.com/t/recommended-sip-to-cellular-gateways/17370)
**Author:** [@jmartell](https://forum.inductiveautomation.com/u/jmartell)\ **Replies:** 2\ **Last updated:** [March 16, 2018, 12:17am UTC](https://forum.inductiveautomation.com/t/recommended-sip-to-cellular-gateways/17370 "2018-03-16T00:17:37Z")
One of our customers wants to have a fallback option for voice alarm notification at a remote site. Does anyone have a good recommendations for a SIP Cellular Gateway? I've used the Grandstream SIP to POTS gateways bef… --- ## [Transaction Group - Output to a Queue](https://forum.inductiveautomation.com/t/transaction-group-output-to-a-queue/17383)
**Author:** [@mark.om](https://forum.inductiveautomation.com/u/mark.om)\ **Replies:** 0\ **Last updated:** [March 15, 2018, 10:50pm UTC](https://forum.inductiveautomation.com/t/transaction-group-output-to-a-queue/17383 "2018-03-15T22:50:02Z")
Hello Is it possible to configure a transaction group to save data to a queue such as RabbitMQ or other? Thanks Mark --- ## [MAI Binding trouble](https://forum.inductiveautomation.com/t/mai-binding-trouble/17382)
**Author:** [@mrogers](https://forum.inductiveautomation.com/u/mrogers)\ **Replies:** 3\ **Last updated:** [March 15, 2018, 10:26pm UTC](https://forum.inductiveautomation.com/t/mai-binding-trouble/17382 "2018-03-15T22:26:37Z")
I'm trying to create a sort of automatic Moving Analog Indicator and if you've worked with them, then you know that pretty much for all non-range high, range low and process values you can just delete the number in there… --- ## [Unable to Launch Application On Startup](https://forum.inductiveautomation.com/t/unable-to-launch-application-on-startup/16720)
**Author:** [@brandon1](https://forum.inductiveautomation.com/u/brandon1)\ **Replies:** 5\ **Last updated:** [March 15, 2018, 9:17pm UTC](https://forum.inductiveautomation.com/t/unable-to-launch-application-on-startup/16720 "2018-03-15T21:17:28Z")
Hello, I have enabled my application to startup automatically when the computer does a reboot. The problem is, the Ignition service has not had enough time to start and the client causes a popup to appear that says th… --- ## [Need help either scaling an OPC write or invokingAsyc a system.tag.writeSync](https://forum.inductiveautomation.com/t/need-help-either-scaling-an-opc-write-or-invokingasyc-a-system-tag-writesync/17369)
**Author:** [@Brian](https://forum.inductiveautomation.com/u/Brian)\ **Replies:** 1\ **Last updated:** [March 15, 2018, 8:13pm UTC](https://forum.inductiveautomation.com/t/need-help-either-scaling-an-opc-write-or-invokingasyc-a-system-tag-writesync/17369 "2018-03-15T20:13:06Z")
I have a bit of code that I was using to ensure one OPC parameter in a PLC was set properly before another was set. I had had (extremely rare) problems in the past with the network write failing on the first system.tag.… --- ## [Select Cells in JTable](https://forum.inductiveautomation.com/t/select-cells-in-jtable/17376)
**Author:** [@cmaynes](https://forum.inductiveautomation.com/u/cmaynes)\ **Replies:** 0\ **Last updated:** [March 15, 2018, 3:50pm UTC](https://forum.inductiveautomation.com/t/select-cells-in-jtable/17376 "2018-03-15T15:50:24Z")
Select cells in a JTable using Robot, taking into account that we may need to scroll to make some cells visible. I have already seen the following solution, but this does not solve the scrolling problem. --- ## [Text Size in Designer: java with high DPI](https://forum.inductiveautomation.com/t/text-size-in-designer-java-with-high-dpi/17375)
**Author:** [@Scott.Hann](https://forum.inductiveautomation.com/u/Scott.Hann)\ **Replies:** 1\ **Last updated:** [March 15, 2018, 3:31pm UTC](https://forum.inductiveautomation.com/t/text-size-in-designer-java-with-high-dpi/17375 "2018-03-15T15:31:58Z")
– edit Problem has to do running java on a monitor with high DPI. I found my solution here: windows 10 - How do I run Java apps upscaled on a high-DPI display? - Super User Windows 10 Solution: find your installation… --- ## [TCP device driver connection issues](https://forum.inductiveautomation.com/t/tcp-device-driver-connection-issues/17373)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 0\ **Last updated:** [March 15, 2018, 10:10am UTC](https://forum.inductiveautomation.com/t/tcp-device-driver-connection-issues/17373 "2018-03-15T10:10:15Z")
I have configured the TCP driver to monitor a checkweigher which spits out a data string at 3 s intervals when running. The connection status keeps changing from Good to Not Connected. In an attempt to debug the comms I… --- ## [Copy Gateway Performance tags to PLC every second](https://forum.inductiveautomation.com/t/copy-gateway-performance-tags-to-plc-every-second/17367)
**Author:** [@brian.kehn](https://forum.inductiveautomation.com/u/brian.kehn)\ **Replies:** 5\ **Last updated:** [March 15, 2018, 9:56am UTC](https://forum.inductiveautomation.com/t/copy-gateway-performance-tags-to-plc-every-second/17367 "2018-03-15T09:56:42Z")
Hi IA. What is the best way to copy "disk utilization" or other Gateway Performance tags to OPC tags? The only way I know of is with global \[shared\] script and "system.tag.write()", somehow calling the script every secon… --- ## [Label Datasets Exported to Excel](https://forum.inductiveautomation.com/t/label-datasets-exported-to-excel/17351)
**Author:** [@cmaynes](https://forum.inductiveautomation.com/u/cmaynes)\ **Replies:** 5\ **Last updated:** [March 14, 2018, 10:50pm UTC](https://forum.inductiveautomation.com/t/label-datasets-exported-to-excel/17351 "2018-03-14T22:50:03Z")
How can I label the datasets I export to excel? [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1385) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1387)