# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1322 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1323 --- ## [OPC Quick Client and Designer](https://forum.inductiveautomation.com/t/opc-quick-client-and-designer/22035)
**Author:** [@mbrali00](https://forum.inductiveautomation.com/u/mbrali00)\ **Replies:** 0\ **Last updated:** [January 22, 2019, 12:36pm UTC](https://forum.inductiveautomation.com/t/opc-quick-client-and-designer/22035 "2019-01-22T12:36:41Z")
I connected Ignition to a OPC-DA Server but it is not working in Desgner. In Quick Client I can read Heartbeat (Status: GOOD\_DATA, Quality: Good) but when I try to read Heartbeat in Designer it is not working, there is … --- ## [CNCs G-code interpreting](https://forum.inductiveautomation.com/t/cncs-g-code-interpreting/22029)
**Author:** [@rrowe](https://forum.inductiveautomation.com/u/rrowe)\ **Replies:** 2\ **Last updated:** [January 22, 2019, 9:51am UTC](https://forum.inductiveautomation.com/t/cncs-g-code-interpreting/22029 "2019-01-22T09:51:49Z")
Has anyone worked with reading g code information off of a CNC controller in ignition (or something else that would allow me to pass it into ignition)? --- ## [Client startup message](https://forum.inductiveautomation.com/t/client-startup-message/22022)
**Author:** [@d.iannozzi](https://forum.inductiveautomation.com/u/d.iannozzi)\ **Replies:** 4\ **Last updated:** [January 22, 2019, 9:42am UTC](https://forum.inductiveautomation.com/t/client-startup-message/22022 "2019-01-22T09:42:52Z")
Hi All is there a way to replace the “login failed” message when a user that is not a member of the “required client roles” logs ? for example, show a message box “You are not allowed to login because not an operator” … --- ## [All "Update Query" checkboxes are enabled](https://forum.inductiveautomation.com/t/all-update-query-checkboxes-are-enabled/17867)
**Author:** [@Sanderd17](https://forum.inductiveautomation.com/u/Sanderd17)\ **Replies:** 21\ **Last updated:** [January 21, 2019, 9:03pm UTC](https://forum.inductiveautomation.com/t/all-update-query-checkboxes-are-enabled/17867 "2019-01-21T21:03:32Z")
Apparently, Ignition decided that I need “UPDATE Query” enabled on all UI fields that use an SQL binding (I’ve seen it on text fields, dropdown lists and checkboxes). Whenever I add a new GUI item, and define a query … --- ## [Absolute Path on Tag Import... Bug or Feature?](https://forum.inductiveautomation.com/t/absolute-path-on-tag-import-bug-or-feature/22024)
**Author:** [@sbrannen](https://forum.inductiveautomation.com/u/sbrannen)\ **Replies:** 2\ **Last updated:** [January 21, 2019, 6:11pm UTC](https://forum.inductiveautomation.com/t/absolute-path-on-tag-import-bug-or-feature/22024 "2019-01-21T18:11:13Z")
Greetings… Just wondering why an absolute path does not seem to work when importing tags. When I do a tag export, the resulting XML file has an empty path (below) and will import to the root folder… which is expected. … --- ## [Recipes on Ignition EDGE gateway](https://forum.inductiveautomation.com/t/recipes-on-ignition-edge-gateway/22005)
**Author:** [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Replies:** 7\ **Last updated:** [January 21, 2019, 5:27pm UTC](https://forum.inductiveautomation.com/t/recipes-on-ignition-edge-gateway/22005 "2019-01-21T17:27:11Z")
Does anybody have an idea, how to use/manage fairly simple recipes on the Ignition Edge gateway (where are no database connections and no transaction groups), installed on the panel PC (Win10) on the machine? The custom… --- ## [Serial Communication using barcode reader](https://forum.inductiveautomation.com/t/serial-communication-using-barcode-reader/22017)
**Author:** [@yishmael.lamay](https://forum.inductiveautomation.com/u/yishmael.lamay)\ **Replies:** 2\ **Last updated:** [January 21, 2019, 5:23pm UTC](https://forum.inductiveautomation.com/t/serial-communication-using-barcode-reader/22017 "2019-01-21T17:23:41Z")
I am trying to setup a serial data tap to read from a barcode scanner using the Serial Support Module, but I keep running into the Trial Expired error. Is there a full licensed version of this module somewhere? Or is the… --- ## [Dataset Expression Tag - Not populating](https://forum.inductiveautomation.com/t/dataset-expression-tag-not-populating/21970)
**Author:** [@andytimc](https://forum.inductiveautomation.com/u/andytimc)\ **Replies:** 12\ **Last updated:** [January 21, 2019, 2:25pm UTC](https://forum.inductiveautomation.com/t/dataset-expression-tag-not-populating/21970 "2019-01-21T14:25:48Z")
I’ve created an expression dataset tag to hold2 columns of data. I would like to populate this tag with the runscript expression. When i try to use runscript in the dataset tag expression window the tag shows a red X as… --- ## [Change background color of tag browse tree](https://forum.inductiveautomation.com/t/change-background-color-of-tag-browse-tree/22018)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 0\ **Last updated:** [January 21, 2019, 2:23pm UTC](https://forum.inductiveautomation.com/t/change-background-color-of-tag-browse-tree/22018 "2019-01-21T14:23:36Z")
Hi everyone Can someone help me to write script to change background color of tag browse tree? I find a post in forum for transparency of that but it seems there is bug with it. --- ## [Edge as a remote gateway and Update Rate](https://forum.inductiveautomation.com/t/edge-as-a-remote-gateway-and-update-rate/21972)
**Author:** [@rpulsifer](https://forum.inductiveautomation.com/u/rpulsifer)\ **Replies:** 4\ **Last updated:** [January 21, 2019, 1:27pm UTC](https://forum.inductiveautomation.com/t/edge-as-a-remote-gateway-and-update-rate/21972 "2019-01-21T13:27:02Z")
Continuing the discussion from Remote tag provider update rate setting: I have an Ignition Edge instance as a remote gateway to our main Ignition Gateway (cloud-based). Driven Scan classes et al, are all well and good -… --- ## [Property editor list](https://forum.inductiveautomation.com/t/property-editor-list/22013)
**Author:** [@jens1011](https://forum.inductiveautomation.com/u/jens1011)\ **Replies:** 1\ **Last updated:** [January 21, 2019, 10:41am UTC](https://forum.inductiveautomation.com/t/property-editor-list/22013 "2019-01-21T10:41:00Z")
when I am watching the videos of ignition, I see that they have a whole list of properties. while I only have 3 properties. how can i get that list of properties to? --- ## [How to reduce backup size?](https://forum.inductiveautomation.com/t/how-to-reduce-backup-size/21966)
**Author:** [@michael.mccabe](https://forum.inductiveautomation.com/u/michael.mccabe)\ **Replies:** 6\ **Last updated:** [January 21, 2019, 9:51am UTC](https://forum.inductiveautomation.com/t/how-to-reduce-backup-size/21966 "2019-01-21T09:51:56Z")
Morning folks, Was wondering whats is the best way to reduce a project size. I have a project at approx 60mb. I deleted unwanted windows and templates, thinking this would reduce Backup size but made no difference. A… --- ## [Help on email notification](https://forum.inductiveautomation.com/t/help-on-email-notification/21906)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 2\ **Last updated:** [January 19, 2019, 6:55am UTC](https://forum.inductiveautomation.com/t/help-on-email-notification/21906 "2019-01-19T06:55:50Z")
Hi I setup following alarm notification in igntion: Also I check the firewall and can telnet smtp.gmail.com 465 without problem. But after try to test an alarm email the status of Email Notification set to Error fr… --- ## [Table component getBackgroundAt example](https://forum.inductiveautomation.com/t/table-component-getbackgroundat-example/18073)
**Author:** [@rrowe](https://forum.inductiveautomation.com/u/rrowe)\ **Replies:** 8\ **Last updated:** [January 19, 2019, 12:58am UTC](https://forum.inductiveautomation.com/t/table-component-getbackgroundat-example/18073 "2019-01-19T00:58:52Z")
Does anyone have a script that I could use as a reference for the table component's getBackgroundAt extension function? --- ## [Extracting whole row of data from selected row in table](https://forum.inductiveautomation.com/t/extracting-whole-row-of-data-from-selected-row-in-table/21962)
**Author:** [@mriederer](https://forum.inductiveautomation.com/u/mriederer)\ **Replies:** 6\ **Last updated:** [January 18, 2019, 10:47pm UTC](https://forum.inductiveautomation.com/t/extracting-whole-row-of-data-from-selected-row-in-table/21962 "2019-01-18T22:47:47Z")
Is there an easy way to get the entire row of data from a table into a custom property? I feel like I’m missing something! First, I tried binding a dataset type property as: {Root Container.Power Table.data}\[{Root Cont… --- ## [FactoryTalk Batch](https://forum.inductiveautomation.com/t/factorytalk-batch/21983)
**Author:** [@damean.thomas](https://forum.inductiveautomation.com/u/damean.thomas)\ **Replies:** 0\ **Last updated:** [January 18, 2019, 7:19pm UTC](https://forum.inductiveautomation.com/t/factorytalk-batch/21983 "2019-01-18T19:19:32Z")
Has anyone had any luck using eprocedure in ignition. With the web module it loads up but i’m not able to log in. If not is there a way to call an internet explorer window and embed it into a an IA window to use eprocedu… --- ## [How to Access Power Table 'options' list from onCellEdited Extension Function?](https://forum.inductiveautomation.com/t/how-to-access-power-table-options-list-from-oncelledited-extension-function/21982)
**Author:** [@dano38291](https://forum.inductiveautomation.com/u/dano38291)\ **Replies:** 0\ **Last updated:** [January 18, 2019, 7:17pm UTC](https://forum.inductiveautomation.com/t/how-to-access-power-table-options-list-from-oncelledited-extension-function/21982 "2019-01-18T19:17:30Z")
I am setting up a ‘options’ list to drive a Drop Down on a Column of Power Table. I can access the newValue from the onCellEdited when I make a selection from Drop Down. But I really want the label of the (value, label) … --- ## [AD\_DB\_Hybrid Authenticates Successfully, but Login Fails for Manual and SSO Login](https://forum.inductiveautomation.com/t/ad-db-hybrid-authenticates-successfully-but-login-fails-for-manual-and-sso-login/21978)
**Author:** [@robert.mosher](https://forum.inductiveautomation.com/u/robert.mosher)\ **Replies:** 1\ **Last updated:** [January 18, 2019, 6:00pm UTC](https://forum.inductiveautomation.com/t/ad-db-hybrid-authenticates-successfully-but-login-fails-for-manual-and-sso-login/21978 "2019-01-18T18:00:04Z")
I am using an AD/Database Hybrid user source for the project and according to the logs, the AD authentication and user roles queries are successful, but the client will not log in. Both methods of logging in are failing:… --- ## [Client Menu Bar icon visibility](https://forum.inductiveautomation.com/t/client-menu-bar-icon-visibility/21944)
**Author:** [@dsui](https://forum.inductiveautomation.com/u/dsui)\ **Replies:** 3\ **Last updated:** [January 18, 2019, 4:53pm UTC](https://forum.inductiveautomation.com/t/client-menu-bar-icon-visibility/21944 "2019-01-18T16:53:35Z")
Is there a way with the Client Menu Bar to hide and show the icon for the individual item? In this case, I want a checkbox icon to only be visible if the state of a boolean tag is true. --- ## [Check if schedule is active](https://forum.inductiveautomation.com/t/check-if-schedule-is-active/21967)
**Author:** [@Sanderd17](https://forum.inductiveautomation.com/u/Sanderd17)\ **Replies:** 1\ **Last updated:** [January 18, 2019, 2:36pm UTC](https://forum.inductiveautomation.com/t/check-if-schedule-is-active/21967 "2019-01-18T14:36:24Z")
I wonder if there’s a better way to see if a user schedule is active inside a python script. Currently I have this script to get a timeline from a schedule, and see if it’s active. It works but it’s not elegant (way too… --- ## [Report : Stop escalation on Nested Queries with field conditional](https://forum.inductiveautomation.com/t/report-stop-escalation-on-nested-queries-with-field-conditional/21955)
**Author:** [@EricProvBRP](https://forum.inductiveautomation.com/u/EricProvBRP)\ **Replies:** 1\ **Last updated:** [January 18, 2019, 1:47pm UTC](https://forum.inductiveautomation.com/t/report-stop-escalation-on-nested-queries-with-field-conditional/21955 "2019-01-18T13:47:33Z")
I have a big report to generate and I want to call child query only when the value return by parent query is not “null”. Is it possible ? --- ## [Example of using a custom method](https://forum.inductiveautomation.com/t/example-of-using-a-custom-method/21883)
**Author:** [@Esn](https://forum.inductiveautomation.com/u/Esn)\ **Replies:** 9\ **Last updated:** [January 18, 2019, 7:39am UTC](https://forum.inductiveautomation.com/t/example-of-using-a-custom-method/21883 "2019-01-18T07:39:56Z")
Hi, Could I get an example or two of how to use the ‘custom method’ in component scripting? I can’t seem to grasp how to utilize it. My goal is to be able to drag-n-drop tags from a tag browser tree into a standard ta… --- ## [Alarm Indication](https://forum.inductiveautomation.com/t/alarm-indication/21616)
**Author:** [@alex.cordova.ee](https://forum.inductiveautomation.com/u/alex.cordova.ee)\ **Replies:** 3\ **Last updated:** [January 18, 2019, 3:18am UTC](https://forum.inductiveautomation.com/t/alarm-indication/21616 "2019-01-18T03:18:37Z")
I have a main screen that has several small banner displays with system names. They would be green if that system is ok, but turn red if the system has alarms. all my systems have different folders . In each folder… --- ## [Summation of all values within Tag Folder](https://forum.inductiveautomation.com/t/summation-of-all-values-within-tag-folder/21910)
**Author:** [@fred.berryman](https://forum.inductiveautomation.com/u/fred.berryman)\ **Replies:** 24\ **Last updated:** [January 17, 2019, 6:39pm UTC](https://forum.inductiveautomation.com/t/summation-of-all-values-within-tag-folder/21910 "2019-01-17T18:39:36Z")
I have several Tag Folders with multiple tags within. These tags are individually shown in a bar chart (ie one bar chart per tag folder). What I would like to do is take the summations of these individual tag folders and… --- ## [Error in cliente with MySQL](https://forum.inductiveautomation.com/t/error-in-cliente-with-mysql/21943)
**Author:** [@Sheko29](https://forum.inductiveautomation.com/u/Sheko29)\ **Replies:** 2\ **Last updated:** [January 17, 2019, 4:11pm UTC](https://forum.inductiveautomation.com/t/error-in-cliente-with-mysql/21943 "2019-01-17T16:11:16Z")
Hello, I’m having a problem with my client…let me explain… in the ignition designer I inserted a table binding to my server in mysql and i can visualize the properties we add in mysql… the problem begin when the client i… --- ## [SSO or straight up LDAP user source?](https://forum.inductiveautomation.com/t/sso-or-straight-up-ldap-user-source/21511)
**Author:** [@alfred\_dussault](https://forum.inductiveautomation.com/u/alfred_dussault)\ **Replies:** 8\ **Last updated:** [January 17, 2019, 3:07pm UTC](https://forum.inductiveautomation.com/t/sso-or-straight-up-ldap-user-source/21511 "2019-01-17T15:07:33Z")
I'm relatively new to Ignition, and this may be covered already in the forums, but I couldn't find a search function in the forums.. so We will be moving to 2 factor authentication with PKI cards in the near future, … --- ## [Database connection status stuck as "Connecting"](https://forum.inductiveautomation.com/t/database-connection-status-stuck-as-connecting/21888)
**Author:** [@brendan.curran](https://forum.inductiveautomation.com/u/brendan.curran)\ **Replies:** 3\ **Last updated:** [January 17, 2019, 2:07pm UTC](https://forum.inductiveautomation.com/t/database-connection-status-stuck-as-connecting/21888 "2019-01-17T14:07:45Z")
I was getting store and forward errors “Returning autogenerated keys is only supported for 8.2 and later servers” so I updated the JDBC drivers. Now when I check the Database connection status in the gateway it seems to … --- ## [Table with tags and their values](https://forum.inductiveautomation.com/t/table-with-tags-and-their-values/21882)
**Author:** [@emovspunk1996](https://forum.inductiveautomation.com/u/emovspunk1996)\ **Replies:** 5\ **Last updated:** [January 17, 2019, 1:04pm UTC](https://forum.inductiveautomation.com/t/table-with-tags-and-their-values/21882 "2019-01-17T13:04:34Z")
I am creating a table where it displays the tags and their values. I used a timer to refresh the contents of the table. I cant figure out how to append the values of the two scripting functions which are the system.tag.b… --- ## [Database Schema](https://forum.inductiveautomation.com/t/database-schema/21926)
**Author:** [@damean.thomas](https://forum.inductiveautomation.com/u/damean.thomas)\ **Replies:** 3\ **Last updated:** [January 17, 2019, 12:04pm UTC](https://forum.inductiveautomation.com/t/database-schema/21926 "2019-01-17T12:04:18Z")
What are the best practices for designing database schema for projects? Should there be one db schema for the entire project to contain alarms, historical, etc… or one schema for each area i.e. schema: alarms, historica… --- ## [Named Query - MySQL SET Variable Not Working](https://forum.inductiveautomation.com/t/named-query-mysql-set-variable-not-working/21895)
**Author:** [@hodgins.e](https://forum.inductiveautomation.com/u/hodgins.e)\ **Replies:** 4\ **Last updated:** [January 17, 2019, 10:39am UTC](https://forum.inductiveautomation.com/t/named-query-mysql-set-variable-not-working/21895 "2019-01-17T10:39:42Z")
Is it not possible SET a variable in a SQL query? This does not seem to work but works fine on my server directly. SELECT @foo :=1; SELECT @foo or SET @foo = 1; SELECT @foo [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1321) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1323)