# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1782 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1783 --- ## [Bar Chart, Conditional Color](https://forum.inductiveautomation.com/t/bar-chart-conditional-color/10233)
**Author:** [@bfearnow](https://forum.inductiveautomation.com/u/bfearnow)\ **Replies:** 2\ **Last updated:** [July 16, 2015, 5:55pm UTC](https://forum.inductiveautomation.com/t/bar-chart-conditional-color/10233 "2015-07-16T17:55:08Z")
This is probably a stupid question, but is it possible in a bar chart to have the color of each individual entry change based on its value? For example anything over 85 is green and anything under 85 is red? Thanks i… --- ## [Expression Binding not submitting](https://forum.inductiveautomation.com/t/expression-binding-not-submitting/10231)
**Author:** [@alewayhar](https://forum.inductiveautomation.com/u/alewayhar)\ **Replies:** 2\ **Last updated:** [July 16, 2015, 1:33pm UTC](https://forum.inductiveautomation.com/t/expression-binding-not-submitting/10231 "2015-07-16T13:33:03Z")
I'm writing a little script that will hide the acknowledge button on an alarm status table if a user is logged in and does not have the right credentials. Below is my code. if ({\[System\]Client/User/RolesString} = Admi… --- ## [Use OPC-UA to connect to factory DCS as a MODBUS server](https://forum.inductiveautomation.com/t/use-opc-ua-to-connect-to-factory-dcs-as-a-modbus-server/10230)
**Author:** [@steven.elam](https://forum.inductiveautomation.com/u/steven.elam)\ **Replies:** 2\ **Last updated:** [July 16, 2015, 2:39am UTC](https://forum.inductiveautomation.com/t/use-opc-ua-to-connect-to-factory-dcs-as-a-modbus-server/10230 "2015-07-16T02:39:23Z")
We are developing an Ignition project that controls a piece of equipment and needs to connect to the factory's DCS system as a MODBUS server (aka slave). We are trying to use OPC-UA, but as I understand it, it always wa… --- ## [Populating Tags with Values from a Stored Procedure](https://forum.inductiveautomation.com/t/populating-tags-with-values-from-a-stored-procedure/10225)
**Author:** [@CJVR](https://forum.inductiveautomation.com/u/CJVR)\ **Replies:** 4\ **Last updated:** [July 15, 2015, 5:10pm UTC](https://forum.inductiveautomation.com/t/populating-tags-with-values-from-a-stored-procedure/10225 "2015-07-15T17:10:08Z")
I have a stored procedure that takes a parameter input and returns 10 values. I want to put these values into 10 tags. I see the following ways to do this: Create 10 SQL tags and write a SQL statement that returns one… --- ## [MySQL Linux Backup Script](https://forum.inductiveautomation.com/t/mysql-linux-backup-script/10172)
**Author:** [@cody.tamaki](https://forum.inductiveautomation.com/u/cody.tamaki)\ **Replies:** 1\ **Last updated:** [July 15, 2015, 9:19am UTC](https://forum.inductiveautomation.com/t/mysql-linux-backup-script/10172 "2015-07-15T09:19:00Z")
I've written the following script to backup the last closed historical partition and assosiated data tables for the Ignition historian on Linux. You can schedule this with cron tab and store the backups on a remote wind… --- ## [String manipulation in scripts](https://forum.inductiveautomation.com/t/string-manipulation-in-scripts/10218)
**Author:** [@lcs226](https://forum.inductiveautomation.com/u/lcs226)\ **Replies:** 2\ **Last updated:** [July 14, 2015, 3:56pm UTC](https://forum.inductiveautomation.com/t/string-manipulation-in-scripts/10218 "2015-07-14T15:56:40Z")
I am wondering if I am loosing my mind? Cannot get this to work \[color=#0080FF\]import app, system keyCode = '020-250' #system.tag.getTagValue('\[Client\]Tracking/AccessCode') length = len(keyCode) print "" print "Key… --- ## [queryTagHistory Slow Data Transfer](https://forum.inductiveautomation.com/t/querytaghistory-slow-data-transfer/10213)
**Author:** [@jwb04001](https://forum.inductiveautomation.com/u/jwb04001)\ **Replies:** 1\ **Last updated:** [July 13, 2015, 7:37pm UTC](https://forum.inductiveautomation.com/t/querytaghistory-slow-data-transfer/10213 "2015-07-13T19:37:22Z")
Hi, I need to query a large amount of historical data. I'm using the queryTagHistory function in order to get the data in the proper format. Historical\_dataset = system.tag.queryTagHistory(paths, startDate, endDate… --- ## [EasyChart object attributes](https://forum.inductiveautomation.com/t/easychart-object-attributes/10216)
**Author:** [@Chris\_Taylor](https://forum.inductiveautomation.com/u/Chris_Taylor)\ **Replies:** 2\ **Last updated:** [July 13, 2015, 5:55pm UTC](https://forum.inductiveautomation.com/t/easychart-object-attributes/10216 "2015-07-13T17:55:41Z")
I know that the easy chart has all sorts of data available for scripting e.g. I can get a list of tagpaths using easyChart = event.source.parent.getComponent("Easy Chart") system.dataset.toPyDataSet(easyChart.tagPens… --- ## [Inductive University](https://forum.inductiveautomation.com/t/inductive-university/10215)
**Author:** [@JoeJansen](https://forum.inductiveautomation.com/u/JoeJansen)\ **Replies:** 1\ **Last updated:** [July 13, 2015, 4:06pm UTC](https://forum.inductiveautomation.com/t/inductive-university/10215 "2015-07-13T16:06:19Z")
Is anyone else trying to go through the courses? I’ve had a couple videos with the sound cutting out, a few quiz questions that are ambiguous, etc. The problem I have now though is in the “Understanding Tags” topic. T… --- ## [Cant toggle to preview mode](https://forum.inductiveautomation.com/t/cant-toggle-to-preview-mode/10204)
**Author:** [@ella\_ramos](https://forum.inductiveautomation.com/u/ella_ramos)\ **Replies:** 3\ **Last updated:** [July 13, 2015, 2:08pm UTC](https://forum.inductiveautomation.com/t/cant-toggle-to-preview-mode/10204 "2015-07-13T14:08:17Z")
Here is the stack race of error. Exception in thread "AWT-EventQueue-2" java.lang.NullPointerException at com.inductiveautomation.factorypmi.application.components.PMIComboBox.getTranslatedData(PMIComboBox.java:261) … --- ## [Easy Chart show same tag history twice](https://forum.inductiveautomation.com/t/easy-chart-show-same-tag-history-twice/10201)
**Author:** [@Chris\_Taylor](https://forum.inductiveautomation.com/u/Chris_Taylor)\ **Replies:** 6\ **Last updated:** [July 13, 2015, 2:02pm UTC](https://forum.inductiveautomation.com/t/easy-chart-show-same-tag-history-twice/10201 "2015-07-13T14:02:43Z")
What I'd like to do is to drag and drop a tag with history on to an easychart and show the trend, (simples) but I'd like to show that same tag history with an offset. For example a 12 hours of tank level trend form yest… --- ## [Browse client and system tags](https://forum.inductiveautomation.com/t/browse-client-and-system-tags/10210)
**Author:** [@zeus](https://forum.inductiveautomation.com/u/zeus)\ **Replies:** 3\ **Last updated:** [July 13, 2015, 7:42am UTC](https://forum.inductiveautomation.com/t/browse-client-and-system-tags/10210 "2015-07-13T07:42:08Z")
Hi to all as we already know Ignition provides a quick way to browse tags by using the function: "browseTags" and "browseTagSimple". I just discovered that these functions are able to browse only the tag related to a tag… --- ## [dateArithmetic](https://forum.inductiveautomation.com/t/datearithmetic/10209)
**Author:** [@steven\_hargraves](https://forum.inductiveautomation.com/u/steven_hargraves)\ **Replies:** 3\ **Last updated:** [July 13, 2015, 4:31am UTC](https://forum.inductiveautomation.com/t/datearithmetic/10209 "2015-07-13T04:31:40Z")
Hello All When I use the dateArithmetic function I get the msg ... 'dateArithmetic is not defined' Any help appreciated. Thx Steve Hargraves --- ## [Referencing a Data Type structue in a script](https://forum.inductiveautomation.com/t/referencing-a-data-type-structue-in-a-script/10212)
**Author:** [@eric129](https://forum.inductiveautomation.com/u/eric129)\ **Replies:** 6\ **Last updated:** [July 11, 2015, 7:51pm UTC](https://forum.inductiveautomation.com/t/referencing-a-data-type-structue-in-a-script/10212 "2015-07-11T19:51:07Z")
Say I have a Data Type defined, "MyData", which has three tags in it, Name, Date, Size. I have an instance of that type called "MyComplexTag". Is it possible in a script to read the base tag and then reference the su… --- ## [Looking for Touch Panel to run Ignition](https://forum.inductiveautomation.com/t/looking-for-touch-panel-to-run-ignition/10140)
**Author:** [@MoisesZV](https://forum.inductiveautomation.com/u/MoisesZV)\ **Replies:** 2\ **Last updated:** [July 11, 2015, 5:01pm UTC](https://forum.inductiveautomation.com/t/looking-for-touch-panel-to-run-ignition/10140 "2015-07-11T17:01:37Z")
Hi, I'm looking for a touch panel, install Ignition and mysql and run it, or the other option is launch Ignition through a web browser on applet mode. Can you tell me what kind of touch panel can run ignition? I don't … --- ## [Controllogix BOOL tag appears as folder in OPC browser](https://forum.inductiveautomation.com/t/controllogix-bool-tag-appears-as-folder-in-opc-browser/9249)
**Author:** [@dmoon](https://forum.inductiveautomation.com/u/dmoon)\ **Replies:** 1\ **Last updated:** [July 10, 2015, 3:34pm UTC](https://forum.inductiveautomation.com/t/controllogix-bool-tag-appears-as-folder-in-opc-browser/9249 "2015-07-10T15:34:33Z")
Version: Ignition 7.6.4 I added half a dozen boolean tags today to a Controllogix PLC which I’ve had successfully connected to Ignition for nearly 2 years. I’m browsing around 16600 tags and actively using maybe 100-20… --- ## [Column Selectors](https://forum.inductiveautomation.com/t/column-selectors/10198)
**Author:** [@mikehill100](https://forum.inductiveautomation.com/u/mikehill100)\ **Replies:** 1\ **Last updated:** [July 10, 2015, 1:23pm UTC](https://forum.inductiveautomation.com/t/column-selectors/10198 "2015-07-10T13:23:34Z")
Hello everybody! Quick question: I have two similar tables with different aggregate grouping on a screen in v 7.5.4 and it would be great if I could use one column selector to select the columns on both tables. Doe… --- ## [V7.8](https://forum.inductiveautomation.com/t/v7-8/10211)
**Author:** [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Replies:** 1\ **Last updated:** [July 10, 2015, 12:09pm UTC](https://forum.inductiveautomation.com/t/v7-8/10211 "2015-07-10T12:09:25Z")
Any release date for V7.8? As announced at last year's ICC , i am looking forward to the updated reporting module that does not require client window to be open to generate a report. --- ## [Client Computers](https://forum.inductiveautomation.com/t/client-computers/10121)
**Author:** [@CJVR](https://forum.inductiveautomation.com/u/CJVR)\ **Replies:** 6\ **Last updated:** [July 10, 2015, 2:00am UTC](https://forum.inductiveautomation.com/t/client-computers/10121 "2015-07-10T02:00:55Z")
As we start to deploy Ignition I am going to need a number of touchscreen enabled all-in-one computers on the floor. Does anyone have any suggestions on brand/config? Thanks, --- ## [Set column values dataset](https://forum.inductiveautomation.com/t/set-column-values-dataset/10208)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 3\ **Last updated:** [July 9, 2015, 9:45pm UTC](https://forum.inductiveautomation.com/t/set-column-values-dataset/10208 "2015-07-09T21:45:02Z")
I have a script that will set a dataset that is populated by running queries. starting with query 1: day = "some date" resultsPy1 = system.db.runQuery(query1) resultsData1 = system.dataset.toDataSet(… --- ## [Tag value color change](https://forum.inductiveautomation.com/t/tag-value-color-change/10207)
**Author:** [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Replies:** 0\ **Last updated:** [July 9, 2015, 7:14pm UTC](https://forum.inductiveautomation.com/t/tag-value-color-change/10207 "2015-07-09T19:14:45Z")
Mr.K001, you locked your topic, another method is using the style customizer driven by the value to change colours: --- ## [Tag binding to a different window](https://forum.inductiveautomation.com/t/tag-binding-to-a-different-window/10205)
**Author:** [@Mr.K001](https://forum.inductiveautomation.com/u/Mr.K001)\ **Replies:** 2\ **Last updated:** [July 9, 2015, 2:16pm UTC](https://forum.inductiveautomation.com/t/tag-binding-to-a-different-window/10205 "2015-07-09T14:16:44Z")
Hi, So what I’m doing is I have a popup box(separate window) with some check boxes in it and I like to bind those boxes to the visibility property of some buttons in another window but I can only bind properties to of th… --- ## [Ignition Gateway (7.7.2) clientlauncher Problem](https://forum.inductiveautomation.com/t/ignition-gateway-7-7-2-clientlauncher-problem/9901)
**Author:** [@dlaki](https://forum.inductiveautomation.com/u/dlaki)\ **Replies:** 7\ **Last updated:** [July 8, 2015, 11:25pm UTC](https://forum.inductiveautomation.com/t/ignition-gateway-7-7-2-clientlauncher-problem/9901 "2015-07-08T23:25:01Z")
Hi everyone, I have this Ignition Gateway 7.7.2 installed in my local system. This version requires to have java 8 version installed. When I tried to launch my application using 'clientlauncher' it didn't showed. I sus… --- ## [Tag value color change](https://forum.inductiveautomation.com/t/tag-value-color-change/10202)
**Author:** [@Mr.K001](https://forum.inductiveautomation.com/u/Mr.K001)\ **Replies:** 1\ **Last updated:** [July 8, 2015, 7:48pm UTC](https://forum.inductiveautomation.com/t/tag-value-color-change/10202 "2015-07-08T19:48:48Z")
It's me again!! :smiley: I'd like to have color of a tag number change to red if that value is negative and green if the value is positive. would this be an expression thing or scripting? something like if({Root Con… --- ## [Dropdown menu Issue](https://forum.inductiveautomation.com/t/dropdown-menu-issue/10169)
**Author:** [@Mr.K001](https://forum.inductiveautomation.com/u/Mr.K001)\ **Replies:** 25\ **Last updated:** [July 8, 2015, 6:34pm UTC](https://forum.inductiveautomation.com/t/dropdown-menu-issue/10169 "2015-07-08T18:34:40Z")
So I have a data table and one column is shift column and i have A and B in there. I made my drop down then created a String in the custom property of the dropdown then i binded it to the table using this expression SEL… --- ## [Opening pages using dropdown](https://forum.inductiveautomation.com/t/opening-pages-using-dropdown/10197)
**Author:** [@Mr.K001](https://forum.inductiveautomation.com/u/Mr.K001)\ **Replies:** 4\ **Last updated:** [July 8, 2015, 3:30pm UTC](https://forum.inductiveautomation.com/t/opening-pages-using-dropdown/10197 "2015-07-08T15:30:26Z")
I would like to be able to open some pages using a drop down menu, created a drop down and in data set viewer, added the name of the pages and gave them a value, now I assume I need to use scripting under drop down compo… --- ## [OPC Connections using PLC Emulators](https://forum.inductiveautomation.com/t/opc-connections-using-plc-emulators/10199)
**Author:** [@Aspeceg](https://forum.inductiveautomation.com/u/Aspeceg)\ **Replies:** 4\ **Last updated:** [July 8, 2015, 2:25pm UTC](https://forum.inductiveautomation.com/t/opc-connections-using-plc-emulators/10199 "2015-07-08T14:25:29Z")
Good Afternoon, After going over this for a couple hours I've hit a wall. I'm relatively new to Ignition but I understand the basics of Gateway and OPC Connections. I'm trying to configure a connection like the fol… --- ## [Open Window in background and Print it](https://forum.inductiveautomation.com/t/open-window-in-background-and-print-it/10187)
**Author:** [@dhananjay\_vichare](https://forum.inductiveautomation.com/u/dhananjay_vichare)\ **Replies:** 3\ **Last updated:** [July 7, 2015, 3:14pm UTC](https://forum.inductiveautomation.com/t/open-window-in-background-and-print-it/10187 "2015-07-07T15:14:49Z")
I had created some reports like hourly, Daily and Monthly. Now I want to print thses reports on scheduled time. Like Hourly report will be automatically print on every hour and Daily report on every end of the day or Sta… --- ## [Can't Publish New Mouseover Text](https://forum.inductiveautomation.com/t/cant-publish-new-mouseover-text/10100)
**Author:** [@system](https://forum.inductiveautomation.com/u/system)\ **Replies:** 2\ **Last updated:** [July 5, 2015, 4:15am UTC](https://forum.inductiveautomation.com/t/cant-publish-new-mouseover-text/10100 "2015-07-05T04:15:34Z")
This is very easy but apparently I can't figure it out. I'm having a strange problem publishing new mouseover text. I'm using graphics from Symbol Factory instead of most of the built-in constructs for things like butt… --- ## [MySQL Exception Handling](https://forum.inductiveautomation.com/t/mysql-exception-handling/10195)
**Author:** [@ella\_ramos](https://forum.inductiveautomation.com/u/ella_ramos)\ **Replies:** 0\ **Last updated:** [July 4, 2015, 3:05am UTC](https://forum.inductiveautomation.com/t/mysql-exception-handling/10195 "2015-07-04T03:05:26Z")
How do something like this in Ignition? How do you handle MySQL related errors, like duplicate entries? import mysql.connector try: cnx = mysql.connector.connect(user='scott', database='employees') cursor = cnx.cu… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1781) [Next page](https://forum.inductiveautomation.com/latest.md?page=1783)