# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1394 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1395 --- ## [Adjust date column in a table](https://forum.inductiveautomation.com/t/adjust-date-column-in-a-table/16853)
**Author:** [@pjgonzales](https://forum.inductiveautomation.com/u/pjgonzales)\ **Replies:** 0\ **Last updated:** [February 2, 2018, 5:02pm UTC](https://forum.inductiveautomation.com/t/adjust-date-column-in-a-table/16853 "2018-02-02T17:02:33Z")
I have a table pulling tag history for a few tags at 2am every morning. The problem is that the data values are actually for the previous days totals. I need to find a way to adjust the t\_stamp column by -24 hours so it … --- ## [Dataset Conversion Issue](https://forum.inductiveautomation.com/t/dataset-conversion-issue/16843)
**Author:** [@S007](https://forum.inductiveautomation.com/u/S007)\ **Replies:** 2\ **Last updated:** [February 2, 2018, 3:52pm UTC](https://forum.inductiveautomation.com/t/dataset-conversion-issue/16843 "2018-02-02T15:52:25Z")
Hi, I'm grabbing dataset off a table with changeable number of columns but one row. First column is always time\_stamp and rest are integer values. Trying to grab the five highest values and put in a new table. At the ver… --- ## [Timer function that works gloabally(gateway)](https://forum.inductiveautomation.com/t/timer-function-that-works-gloabally-gateway/16849)
**Author:** [@jbb5310](https://forum.inductiveautomation.com/u/jbb5310)\ **Replies:** 3\ **Last updated:** [February 2, 2018, 3:28pm UTC](https://forum.inductiveautomation.com/t/timer-function-that-works-gloabally-gateway/16849 "2018-02-02T15:28:25Z")
I have a timer component that runs based upon a tag Boolean and displays it onto the screen. My problem is that I would like the timer to be synchronized throughout the project. So I guess a gateway script of some sort w… --- ## [Ignition 7.9.6 Installation Issue](https://forum.inductiveautomation.com/t/ignition-7-9-6-installation-issue/16802)
**Author:** [@jim.warren](https://forum.inductiveautomation.com/u/jim.warren)\ **Replies:** 5\ **Last updated:** [February 2, 2018, 1:29pm UTC](https://forum.inductiveautomation.com/t/ignition-7-9-6-installation-issue/16802 "2018-02-02T13:29:24Z")
I have installed Java 8 64-bit and am still getting a pop up, while attempting the Ignition install, that states that Setup was unable to locate Java 8. Any direction on this? --- ## [MQTT / IIOT discussions](https://forum.inductiveautomation.com/t/mqtt-iiot-discussions/12230)
**Author:** [@R.Alamsha](https://forum.inductiveautomation.com/u/R.Alamsha)\ **Replies:** 5\ **Last updated:** [February 2, 2018, 5:36am UTC](https://forum.inductiveautomation.com/t/mqtt-iiot-discussions/12230 "2018-02-02T05:36:50Z")
Is it possible to download and merge datalogs from a remote telemetry RTU into the Ignition historian database using MQTT module?. If NOT, what's the alternative solution?. I did some deep research into Cirrus Link MQT… --- ## [Easy Chart ignoring values](https://forum.inductiveautomation.com/t/easy-chart-ignoring-values/16840)
**Author:** [@Nick.christensen](https://forum.inductiveautomation.com/u/Nick.christensen)\ **Replies:** 1\ **Last updated:** [February 1, 2018, 6:06pm UTC](https://forum.inductiveautomation.com/t/easy-chart-ignoring-values/16840 "2018-02-01T18:06:34Z")
I have an easy chart that is tracking thermocouple data for parts in an oven. Frequently the parts are removed and the thermocouples are unplugged causing there values to go to 770. What i would like to do is have the ea… --- ## [Force httpGet to make call from gateway?](https://forum.inductiveautomation.com/t/force-httpget-to-make-call-from-gateway/16833)
**Author:** [@Ehren](https://forum.inductiveautomation.com/u/Ehren)\ **Replies:** 3\ **Last updated:** [February 1, 2018, 3:38pm UTC](https://forum.inductiveautomation.com/t/force-httpget-to-make-call-from-gateway/16833 "2018-02-01T15:38:22Z")
I have a situation where the gateway has internet access however my clients will not. It seems the system.net.httpGet() function makes requests directly from the client. Is it possible to 'funnel' the system.net.http… --- ## [system.db.runPrepUpdate() problems "Unknown to Unknown"](https://forum.inductiveautomation.com/t/system-db-runprepupdate-problems-unknown-to-unknown/8411)
**Author:** [@miketob](https://forum.inductiveautomation.com/u/miketob)\ **Replies:** 3\ **Last updated:** [February 1, 2018, 3:10pm UTC](https://forum.inductiveautomation.com/t/system-db-runprepupdate-problems-unknown-to-unknown/8411 "2018-02-01T15:10:14Z")
Hello, I think the issue reported in this post is still unsolved. When you use system.db.runPrepUpdate() with numeric parameters might get an error like this: This is happening to me with a MS SL Server 2008 R2 datab… --- ## [Styling in Ignition](https://forum.inductiveautomation.com/t/styling-in-ignition/16838)
**Author:** [@Sanderd17](https://forum.inductiveautomation.com/u/Sanderd17)\ **Replies:** 1\ **Last updated:** [February 1, 2018, 2:09pm UTC](https://forum.inductiveautomation.com/t/styling-in-ignition/16838 "2018-02-01T14:09:06Z")
I'm wondering if there's a good way to create a style for all sorts of different components in Ignition. I've found this post on the forums, where it's shown you can create DataSets with style information, and bind it … --- ## [Event Trend, Easy Chart](https://forum.inductiveautomation.com/t/event-trend-easy-chart/16834)
**Author:** [@Jayden](https://forum.inductiveautomation.com/u/Jayden)\ **Replies:** 3\ **Last updated:** [February 1, 2018, 2:04pm UTC](https://forum.inductiveautomation.com/t/event-trend-easy-chart/16834 "2018-02-01T14:04:58Z")
Hi All, I'm trying to setup an easy chart to only display pen data when a particular event has occurred. My pens are Pens: -pH -Temperature Event (only display data when this event is true): -Valve Open There mu… --- ## [Edge on ARM issues](https://forum.inductiveautomation.com/t/edge-on-arm-issues/12857)
**Author:** [@weertske](https://forum.inductiveautomation.com/u/weertske)\ **Replies:** 3\ **Last updated:** [February 1, 2018, 9:04am UTC](https://forum.inductiveautomation.com/t/edge-on-arm-issues/12857 "2018-02-01T09:04:55Z")
Still testing on beta1. I apologize if this was corrected on RC1 Easy chart does not seem to be working. After setting up history on a tag and dropping the tag on the chart, the chart does not show data. Makes me wonde… --- ## [Auto resize columns on initialization for alarm status table?](https://forum.inductiveautomation.com/t/auto-resize-columns-on-initialization-for-alarm-status-table/16836)
**Author:** [@brian.mcenulty](https://forum.inductiveautomation.com/u/brian.mcenulty)\ **Replies:** 0\ **Last updated:** [February 1, 2018, 7:12am UTC](https://forum.inductiveautomation.com/t/auto-resize-columns-on-initialization-for-alarm-status-table/16836 "2018-02-01T07:12:02Z")
The alarm status table has a handy feature allowing the columns to be auto-resized when you right click on the header and choose that option. Is there a way to have this auto resizing done automatically when the table is… --- ## [Pounds/Minute Graph](https://forum.inductiveautomation.com/t/pounds-minute-graph/16832)
**Author:** [@jdiaz5](https://forum.inductiveautomation.com/u/jdiaz5)\ **Replies:** 1\ **Last updated:** [February 1, 2018, 4:57am UTC](https://forum.inductiveautomation.com/t/pounds-minute-graph/16832 "2018-02-01T04:57:09Z")
I am trying to make a pounds per minute graph but I am having difficulty grabbing the total pounds at the current time then subtracting it from the total pounds 1-minute ago. Does anyone one have any way to doing this or… --- ## [Easy Chart - Stack Bar Graphs](https://forum.inductiveautomation.com/t/easy-chart-stack-bar-graphs/16807)
**Author:** [@john.furby](https://forum.inductiveautomation.com/u/john.furby)\ **Replies:** 2\ **Last updated:** [January 31, 2018, 11:48pm UTC](https://forum.inductiveautomation.com/t/easy-chart-stack-bar-graphs/16807 "2018-01-31T23:48:37Z")
Is it possible to get an easy chart to do stacks? Or do you have a to use the regular bar chart? --- ## [How to get half of a dataset with expression](https://forum.inductiveautomation.com/t/how-to-get-half-of-a-dataset-with-expression/16828)
**Author:** [@zacslade](https://forum.inductiveautomation.com/u/zacslade)\ **Replies:** 2\ **Last updated:** [January 31, 2018, 8:36pm UTC](https://forum.inductiveautomation.com/t/how-to-get-half-of-a-dataset-with-expression/16828 "2018-01-31T20:36:13Z")
Hi all, I've got a display with a dataset parameter. I'd like to cut the dataset in half and show it in two tables using the expression language, if possible. (so half of the rows are on the left, and the other half of… --- ## [Display formatted text](https://forum.inductiveautomation.com/t/display-formatted-text/16820)
**Author:** [@rudi.putzeys](https://forum.inductiveautomation.com/u/rudi.putzeys)\ **Replies:** 2\ **Last updated:** [January 31, 2018, 2:36pm UTC](https://forum.inductiveautomation.com/t/display-formatted-text/16820 "2018-01-31T14:36:15Z")
Hi all, we have rich text formatted text stored in a SQL-DB. The text is stored by another programm. Is there any possibility to display this text (formatted) in Ignition without the rtf-code? This is how it looks now… --- ## [Adding multiple tags based on condition](https://forum.inductiveautomation.com/t/adding-multiple-tags-based-on-condition/16813)
**Author:** [@Micky.Franks](https://forum.inductiveautomation.com/u/Micky.Franks)\ **Replies:** 1\ **Last updated:** [January 31, 2018, 12:41pm UTC](https://forum.inductiveautomation.com/t/adding-multiple-tags-based-on-condition/16813 "2018-01-31T12:41:02Z")
I have about 140 UDTs that I want to add all the tags in the UDT based on the condition of another tag in the UDT. Each tag has a grade from 0-5 and I want to get the some of all the totalTare that are grade 1, 2, 3 etc… --- ## [Dropdowns in multi monitor setup](https://forum.inductiveautomation.com/t/dropdowns-in-multi-monitor-setup/16806)
**Author:** [@Mr.K001](https://forum.inductiveautomation.com/u/Mr.K001)\ **Replies:** 2\ **Last updated:** [January 31, 2018, 9:20am UTC](https://forum.inductiveautomation.com/t/dropdowns-in-multi-monitor-setup/16806 "2018-01-31T09:20:52Z")
Hi guys, I was wondering if this is an Ignition issue or Java issue, when you are using 2 monitors and have client open in your second monitor and use a dropdown or calendar dropdown it opens up in the main monitor, its … --- ## [Custom Menu Navigation Help](https://forum.inductiveautomation.com/t/custom-menu-navigation-help/16815)
**Author:** [@EDoepke](https://forum.inductiveautomation.com/u/EDoepke)\ **Replies:** 3\ **Last updated:** [January 31, 2018, 2:46am UTC](https://forum.inductiveautomation.com/t/custom-menu-navigation-help/16815 "2018-01-31T02:46:46Z")
I am working on my very 1st Ignition project! I have a popup window with buttons to link to the various full screen displays. I am trying to create a Template with two parameters: WindowToShow and ButtonLabel (both Str… --- ## [MQTT modules faulting after install](https://forum.inductiveautomation.com/t/mqtt-modules-faulting-after-install/16814)
**Author:** [@user1](https://forum.inductiveautomation.com/u/user1)\ **Replies:** 1\ **Last updated:** [January 30, 2018, 11:59pm UTC](https://forum.inductiveautomation.com/t/mqtt-modules-faulting-after-install/16814 "2018-01-30T23:59:34Z")
Hey, looking to test out MQTT and downloaded the modules to install on the gateway and edge. On the Gateway i get faults for the MQTT Distributor and MQTT Engine. On the Edge i get faults for the MQTT Engine and MQTT … --- ## [Changing Username to connect to Oracle Express DB? Breaks Historical Logging](https://forum.inductiveautomation.com/t/changing-username-to-connect-to-oracle-express-db-breaks-historical-logging/16782)
**Author:** [@dano38291](https://forum.inductiveautomation.com/u/dano38291)\ **Replies:** 3\ **Last updated:** [January 30, 2018, 5:59pm UTC](https://forum.inductiveautomation.com/t/changing-username-to-connect-to-oracle-express-db-breaks-historical-logging/16782 "2018-01-30T17:59:27Z")
Hello, I have a Ignition Test VM connecting to an Oracle Express Install in same VM. I could get Historian to log data using the "system" user. I created a new user "ignition" using Oracle SQL Developer(kinda like MS S… --- ## [Weird Error Message writing to tag](https://forum.inductiveautomation.com/t/weird-error-message-writing-to-tag/16803)
**Author:** [@nsnyder](https://forum.inductiveautomation.com/u/nsnyder)\ **Replies:** 6\ **Last updated:** [January 30, 2018, 5:29pm UTC](https://forum.inductiveautomation.com/t/weird-error-message-writing-to-tag/16803 "2018-01-30T17:29:39Z")
I am new to ignition and was hoping I could get a little help with a problem I ran into. I am writing to multiple client tags from a table based on the selected row from an actionPreformed function on a button. This w… --- ## [New Stored procedure group doesn't browse oracle stored procedure](https://forum.inductiveautomation.com/t/new-stored-procedure-group-doesnt-browse-oracle-stored-procedure/16799)
**Author:** [@francesco.conti](https://forum.inductiveautomation.com/u/francesco.conti)\ **Replies:** 1\ **Last updated:** [January 30, 2018, 4:52pm UTC](https://forum.inductiveautomation.com/t/new-stored-procedure-group-doesnt-browse-oracle-stored-procedure/16799 "2018-01-30T16:52:08Z")
Hi, today we are using the trial version of Ignition 7.9.6 to test some use case and decide if develop our scada. We are trying to call a stored procedure in designer from Transaction Group/New Stored procedure group … --- ## [Bcc Function in system.net.sendEmail Not Working](https://forum.inductiveautomation.com/t/bcc-function-in-system-net-sendemail-not-working/16798)
**Author:** [@cmaynes](https://forum.inductiveautomation.com/u/cmaynes)\ **Replies:** 1\ **Last updated:** [January 30, 2018, 4:46pm UTC](https://forum.inductiveautomation.com/t/bcc-function-in-system-net-sendemail-not-working/16798 "2018-01-30T16:46:09Z")
The Bcc and Cc functionalities do not seem to be working in this method: system.net.sendEmail --- ## [Multi monitor wrong axis precedence](https://forum.inductiveautomation.com/t/multi-monitor-wrong-axis-precedence/12334)
**Author:** [@TESTHOMAS](https://forum.inductiveautomation.com/u/TESTHOMAS)\ **Replies:** 6\ **Last updated:** [January 30, 2018, 12:19pm UTC](https://forum.inductiveautomation.com/t/multi-monitor-wrong-axis-precedence/12334 "2018-01-30T12:19:28Z")
When we open two windows on a second desktop, the docking order differs from the primary desktop. It seems that the "axis precedence" from the project settings is not applied to secondary desktops. --- ## [Dealing with very large datasets](https://forum.inductiveautomation.com/t/dealing-with-very-large-datasets/16788)
**Author:** [@mrogers](https://forum.inductiveautomation.com/u/mrogers)\ **Replies:** 2\ **Last updated:** [January 30, 2018, 1:04am UTC](https://forum.inductiveautomation.com/t/dealing-with-very-large-datasets/16788 "2018-01-30T01:04:37Z")
I remember at one point I saw something here or somewhere online about what to do if you have a very large dataset (hundreds of thousands of rows, a couple columns). I am working out something in a vision window that wil… --- ## [system.util.getLogger() and the .info() method](https://forum.inductiveautomation.com/t/system-util-getlogger-and-the-info-method/16693)
**Author:** [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Replies:** 11\ **Last updated:** [January 29, 2018, 8:53pm UTC](https://forum.inductiveautomation.com/t/system-util-getlogger-and-the-info-method/16693 "2018-01-29T20:53:46Z")
I just noticed in a customer log that calling the info() method, which doesn't accept the parameter substitutions that the infof() method uses, delegates to the infof() method. Which means it blows up if the given strin… --- ## [7.9.5 Alarm Source Filter Wildcard Not Working](https://forum.inductiveautomation.com/t/7-9-5-alarm-source-filter-wildcard-not-working/16055)
**Author:** [@hamlinjr](https://forum.inductiveautomation.com/u/hamlinjr)\ **Replies:** 11\ **Last updated:** [January 29, 2018, 6:35pm UTC](https://forum.inductiveautomation.com/t/7-9-5-alarm-source-filter-wildcard-not-working/16055 "2018-01-29T18:35:46Z")
Hey all, I'm having an issue with a wildcard (\*) filter not working in the source filter of my Alarm Status Table, and not working in the Path of a system.alarm.queryStatus script. Incidentally the issue is NOT affecting… --- ## [Tag initialization date](https://forum.inductiveautomation.com/t/tag-initialization-date/16783)
**Author:** [@Vince](https://forum.inductiveautomation.com/u/Vince)\ **Replies:** 0\ **Last updated:** [January 29, 2018, 4:53pm UTC](https://forum.inductiveautomation.com/t/tag-initialization-date/16783 "2018-01-29T16:53:23Z")
Hi everyone, I would like to have a date tag that contain the moment of it's own initialization. Any ideas? --- ## [Webdev - caching, Gzip?](https://forum.inductiveautomation.com/t/webdev-caching-gzip/16251)
**Author:** [@oscar.salcedo](https://forum.inductiveautomation.com/u/oscar.salcedo)\ **Replies:** 2\ **Last updated:** [January 29, 2018, 2:29pm UTC](https://forum.inductiveautomation.com/t/webdev-caching-gzip/16251 "2018-01-29T14:29:30Z")
Hi all, Wondering if there is a way to enable caching and/or Gzip compression for REST Webdev calls? I would think that those are enabled at the Web Server level, but do we have access to those settings? Thanks, Os… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1393) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1395)