# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1209 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1210 --- ## [Dealing with Nulls in Report Table](https://forum.inductiveautomation.com/t/dealing-with-nulls-in-report-table/32349)
**Author:** [@kaushik.shah](https://forum.inductiveautomation.com/u/kaushik.shah)\ **Replies:** 0\ **Last updated:** [February 17, 2020, 7:49pm UTC](https://forum.inductiveautomation.com/t/dealing-with-nulls-in-report-table/32349 "2020-02-17T19:49:15Z")
I have a Report Table which looks something like this : The information is fetched from database which also includes Null values. When I try to put some summary calculations on it, such as Maximum, it gives me \ … --- ## [\[SOLVED\] Format SQL Query results inside a power table](https://forum.inductiveautomation.com/t/solved-format-sql-query-results-inside-a-power-table/32345)
**Author:** [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Replies:** 5\ **Last updated:** [February 17, 2020, 7:40pm UTC](https://forum.inductiveautomation.com/t/solved-format-sql-query-results-inside-a-power-table/32345 "2020-02-17T19:40:11Z")
I have a power table with the following query: SELECT MachineName, MachineStatus, MachineTag, DateAdded FROM Table ORDER BY DateAdded DESC; Date Added shows up in a typical format YYYY-MM-DD HH:MM:SS but is there a way… --- ## [Help combining two datasets based on Condition](https://forum.inductiveautomation.com/t/help-combining-two-datasets-based-on-condition/32339)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 4\ **Last updated:** [February 17, 2020, 6:28pm UTC](https://forum.inductiveautomation.com/t/help-combining-two-datasets-based-on-condition/32339 "2020-02-17T18:28:07Z")
The first dataset, ds1, has several columns, the first column is ‘user’. I have a second dataset, ds2, that has two columns \[‘premp#’,‘prname’\]. I want to add a column to ds1 where it inserts the correct employee numb… --- ## [Window not loading completely?](https://forum.inductiveautomation.com/t/window-not-loading-completely/32312)
**Author:** [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Replies:** 1\ **Last updated:** [February 17, 2020, 1:16pm UTC](https://forum.inductiveautomation.com/t/window-not-loading-completely/32312 "2020-02-17T13:16:51Z")
I have a windows that (On first time loading does not load completely.) But everytime it is loaded there after works as expected? --- ## [Need to tell if client is running on same machine as gateway](https://forum.inductiveautomation.com/t/need-to-tell-if-client-is-running-on-same-machine-as-gateway/32314)
**Author:** [@Dmart](https://forum.inductiveautomation.com/u/Dmart)\ **Replies:** 8\ **Last updated:** [February 16, 2020, 9:07pm UTC](https://forum.inductiveautomation.com/t/need-to-tell-if-client-is-running-on-same-machine-as-gateway/32314 "2020-02-16T21:07:27Z")
I have a main customer that I have finally got to switch over to Ignition for HMI use. (yay!) Currently running Ignition Edge 7.9.13. These are installed on a PC touch panel (gateway and client.) I have a client event… --- ## [Gateway SingleConnectionDatasource errors preventing normal operation](https://forum.inductiveautomation.com/t/gateway-singleconnectiondatasource-errors-preventing-normal-operation/23062)
**Author:** [@richardNZ15](https://forum.inductiveautomation.com/u/richardNZ15)\ **Replies:** 11\ **Last updated:** [February 16, 2020, 7:22pm UTC](https://forum.inductiveautomation.com/t/gateway-singleconnectiondatasource-errors-preventing-normal-operation/23062 "2020-02-16T19:22:22Z")
I am getting tons of errors in the Diagnostics logs relating to the following: Caused by: java.sql.SQLException: Connection is locked. Datasource only allows one connection at a time. More information was logged to the … --- ## [OnStartup Timer \[Perspective\]](https://forum.inductiveautomation.com/t/onstartup-timer-perspective/32151)
**Author:** [@jaspinall](https://forum.inductiveautomation.com/u/jaspinall)\ **Replies:** 6\ **Last updated:** [February 15, 2020, 10:03pm UTC](https://forum.inductiveautomation.com/t/onstartup-timer-perspective/32151 "2020-02-15T22:03:38Z")
Hello There, Would anyone be able to tell me how I could accomplish the following: I would like a component on my page to only become visible 5 seconds after the page has been loaded. Is there a way to do this? Many … --- ## [On startup setting values in FlexRepeater](https://forum.inductiveautomation.com/t/on-startup-setting-values-in-flexrepeater/32305)
**Author:** [@weertske](https://forum.inductiveautomation.com/u/weertske)\ **Replies:** 0\ **Last updated:** [February 15, 2020, 9:26pm UTC](https://forum.inductiveautomation.com/t/on-startup-setting-values-in-flexrepeater/32305 "2020-02-15T21:26:14Z")
I have a number of checkboxes that are within a FlexRepeater. The instances are created by a script. When the user first loads the view, I want all the checkboxes checked (selected). I am handling this via a delayed onSt… --- ## [\[SOLVED\] BACnet, OPC-UA and booleans!](https://forum.inductiveautomation.com/t/solved-bacnet-opc-ua-and-booleans/31788)
**Author:** [@fpsileno](https://forum.inductiveautomation.com/u/fpsileno)\ **Replies:** 4\ **Last updated:** [February 15, 2020, 7:19pm UTC](https://forum.inductiveautomation.com/t/solved-bacnet-opc-ua-and-booleans/31788 "2020-02-15T19:19:51Z")
Hi! We have a test setup, where an Ignition 8.x talks to an OPC-UA server (TANI Industries), which talk to some BACnet devices. Everything appears functional, with only one anomaly: the tags that are set as boolean on … --- ## [Ignition images: http://localhost/imagename](https://forum.inductiveautomation.com/t/ignition-images-http-localhost-imagename/32288)
**Author:** [@csanyia](https://forum.inductiveautomation.com/u/csanyia)\ **Replies:** 3\ **Last updated:** [February 15, 2020, 12:02am UTC](https://forum.inductiveautomation.com/t/ignition-images-http-localhost-imagename/32288 "2020-02-15T00:02:44Z")
I have a ton of images that i use with ignition, setting the file path appears to be using my PC to utilize. I installed a webserver on the ignition server and would effectively like to use it as an image repository tha… --- ## [Ingnition connected with ControlLogix V32](https://forum.inductiveautomation.com/t/ingnition-connected-with-controllogix-v32/32297)
**Author:** [@andrespumacayogomez](https://forum.inductiveautomation.com/u/andrespumacayogomez)\ **Replies:** 2\ **Last updated:** [February 14, 2020, 11:47pm UTC](https://forum.inductiveautomation.com/t/ingnition-connected-with-controllogix-v32/32297 "2020-02-14T23:47:00Z")
Hi everybody, I have to connect a ControlLogix Revision 32 with the ignition V7.9.10, i used the OPC UA server in the gateway page. My problem, I configured all the features in the page, and at moment when i go to the i… --- ## [Bug in 8.0.8, expedited 8.0.9 release](https://forum.inductiveautomation.com/t/bug-in-8-0-8-expedited-8-0-9-release/32296)
**Author:** [@Paul.Scott](https://forum.inductiveautomation.com/u/Paul.Scott)\ **Replies:** 0\ **Last updated:** [February 14, 2020, 9:54pm UTC](https://forum.inductiveautomation.com/t/bug-in-8-0-8-expedited-8-0-9-release/32296 "2020-02-14T21:54:07Z")
Hi folks. We found a notable bug in 8.0.8 after release. As a result, we’re in the process of building 8.0.9 installers, which contains a fix for the bug. Ignition 8.0.9 should be available later today, or soon after. T… --- ## [Changing Color or Enable/Disable Individual Tabs on Navigation Tab Strip Dynamically](https://forum.inductiveautomation.com/t/changing-color-or-enable-disable-individual-tabs-on-navigation-tab-strip-dynamically/32295)
**Author:** [@BillS](https://forum.inductiveautomation.com/u/BillS)\ **Replies:** 0\ **Last updated:** [February 14, 2020, 8:42pm UTC](https://forum.inductiveautomation.com/t/changing-color-or-enable-disable-individual-tabs-on-navigation-tab-strip-dynamically/32295 "2020-02-14T20:42:43Z")
Hello, We defined a 2 tier navigation structure utilizing the Tab Strip component configured with Navigation Mode set to Swap Window. Each level of navigation is contained in it’s own window. The sub navigation window… --- ## [Number of Active Alarms Query](https://forum.inductiveautomation.com/t/number-of-active-alarms-query/32294)
**Author:** [@jaspinall](https://forum.inductiveautomation.com/u/jaspinall)\ **Replies:** 2\ **Last updated:** [February 14, 2020, 8:39pm UTC](https://forum.inductiveautomation.com/t/number-of-active-alarms-query/32294 "2020-02-14T20:39:26Z")
Hello There, Is there anyway to write a query to return the number of active alarms inside of a tag folder path? Many Thanks --- ## [Raspberry Pi Frame Buffer](https://forum.inductiveautomation.com/t/raspberry-pi-frame-buffer/32276)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 1\ **Last updated:** [February 14, 2020, 7:20pm UTC](https://forum.inductiveautomation.com/t/raspberry-pi-frame-buffer/32276 "2020-02-14T19:20:37Z")
I have some RPi’s running an Ignition client and every thing looks good except when you use the help menu. For example, if you open the diagnostics window it is larger than the 7" display. Using the touchscreen you can… --- ## [Cell Formatting - Table in Reporting Module](https://forum.inductiveautomation.com/t/cell-formatting-table-in-reporting-module/32290)
**Author:** [@kaushik.shah](https://forum.inductiveautomation.com/u/kaushik.shah)\ **Replies:** 0\ **Last updated:** [February 14, 2020, 7:10pm UTC](https://forum.inductiveautomation.com/t/cell-formatting-table-in-reporting-module/32290 "2020-02-14T19:10:37Z")
Hello, I have the table as below in the Reporting Module, What I am looking to do is change the font color of the cell if the value is out of spec ! Any Idea ? Thanks --- ## [Tag Value Delta Calculation](https://forum.inductiveautomation.com/t/tag-value-delta-calculation/32221)
**Author:** [@Chris.Hawkey](https://forum.inductiveautomation.com/u/Chris.Hawkey)\ **Replies:** 8\ **Last updated:** [February 14, 2020, 6:35pm UTC](https://forum.inductiveautomation.com/t/tag-value-delta-calculation/32221 "2020-02-14T18:35:25Z")
Hello all, I am attempting to create a tag that will represent the change in an OPC tags value over the previous 60 seconds. I have flirted with a few ideas on how to do this, but have run into some potential issues wit… --- ## [Docked Alarm Status Table not covering entire Page?](https://forum.inductiveautomation.com/t/docked-alarm-status-table-not-covering-entire-page/32286)
**Author:** [@jaspinall](https://forum.inductiveautomation.com/u/jaspinall)\ **Replies:** 0\ **Last updated:** [February 14, 2020, 5:57pm UTC](https://forum.inductiveautomation.com/t/docked-alarm-status-table-not-covering-entire-page/32286 "2020-02-14T17:57:22Z")
Hello There, We are currently experimenting with the Alarm Status Table in a docked view and I notice that it doesn’t completely cover the page. It seems that when visible it covers about 85% of the page with 15% showin… --- ## [Alarms in UDTs - Binding Associated Data to Tags](https://forum.inductiveautomation.com/t/alarms-in-udts-binding-associated-data-to-tags/30098)
**Author:** [@cody.abbott](https://forum.inductiveautomation.com/u/cody.abbott)\ **Replies:** 7\ **Last updated:** [February 14, 2020, 5:41pm UTC](https://forum.inductiveautomation.com/t/alarms-in-udts-binding-associated-data-to-tags/30098 "2020-02-14T17:41:59Z")
I have a fairly complex alarming scheme. We are using notification pipelines to page the appropriate department when a piece of machinery goes down. The operator has to select the downtime reason code, and I am using scr… --- ## [Perspective Alarm Status Table (Hiding or Moving Settings/Filter Buttons)](https://forum.inductiveautomation.com/t/perspective-alarm-status-table-hiding-or-moving-settings-filter-buttons/32285)
**Author:** [@jaspinall](https://forum.inductiveautomation.com/u/jaspinall)\ **Replies:** 0\ **Last updated:** [February 14, 2020, 5:32pm UTC](https://forum.inductiveautomation.com/t/perspective-alarm-status-table-hiding-or-moving-settings-filter-buttons/32285 "2020-02-14T17:32:56Z")
Hello There, Is it possible to Hide the Settings/Filter button in the Alarm Status Table? Or, is it possible to move them to the left hand side rather than the right? I am using Alarm Status Table in a Flex View and whe… --- ## [Trouble auto-selecting on a dropdown who's options are based on parent dropdown?](https://forum.inductiveautomation.com/t/trouble-auto-selecting-on-a-dropdown-whos-options-are-based-on-parent-dropdown/32284)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 1\ **Last updated:** [February 14, 2020, 5:27pm UTC](https://forum.inductiveautomation.com/t/trouble-auto-selecting-on-a-dropdown-whos-options-are-based-on-parent-dropdown/32284 "2020-02-14T17:27:53Z")
I have a dropdown Customers and a dropdown Locations. Locations dropdown options are based on what is selected in the customers dropdown. I wanted to make it so that if the lcoations dropdown only had two options (A ‘S… --- ## [Passing parameter to popup window with perspective.openPopup](https://forum.inductiveautomation.com/t/passing-parameter-to-popup-window-with-perspective-openpopup/32283)
**Author:** [@preston.j.williams](https://forum.inductiveautomation.com/u/preston.j.williams)\ **Replies:** 1\ **Last updated:** [February 14, 2020, 5:19pm UTC](https://forum.inductiveautomation.com/t/passing-parameter-to-popup-window-with-perspective-openpopup/32283 "2020-02-14T17:19:08Z")
I am trying to open a popup window with system.perspective.openPopup. The popup window has a PARAM passed in called Date that comes from previous window This works if I pass the parameter using the “traditional” method… --- ## [Stored Procedure Error](https://forum.inductiveautomation.com/t/stored-procedure-error/32265)
**Author:** [@kfells](https://forum.inductiveautomation.com/u/kfells)\ **Replies:** 5\ **Last updated:** [February 14, 2020, 4:10pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-error/32265 "2020-02-14T16:10:33Z")
Hello, I am getting the following error while executing a stored procedure call. Can not insert Null into the identity column. The procedure call worked before, but I am not sure how to fix the issue. Traceback (most… --- ## [Change the background color of a tooltip (XY Chart)](https://forum.inductiveautomation.com/t/change-the-background-color-of-a-tooltip-xy-chart/32272)
**Author:** [@thuffman](https://forum.inductiveautomation.com/u/thuffman)\ **Replies:** 0\ **Last updated:** [February 14, 2020, 3:38pm UTC](https://forum.inductiveautomation.com/t/change-the-background-color-of-a-tooltip-xy-chart/32272 "2020-02-14T15:38:29Z")
I have been trying to find a way to change the background color of tooltips in the XY chart. I have tried to change the property for self.props.series\[0\].tooltip.background.color to different colors but it seems to have… --- ## [Gateway Network Vulnerability in 7.9.x](https://forum.inductiveautomation.com/t/gateway-network-vulnerability-in-7-9-x/32266)
**Author:** [@c-w-t](https://forum.inductiveautomation.com/u/c-w-t)\ **Replies:** 2\ **Last updated:** [February 14, 2020, 3:33pm UTC](https://forum.inductiveautomation.com/t/gateway-network-vulnerability-in-7-9-x/32266 "2020-02-14T15:33:12Z")
Given the recent updates in version 8 patching vulnerabilities in gateway security, do we need to be concerned about the same vulnerabilities in 7.9.x versions? Specifically with gateway network connections per the lat… --- ## [Difference between '~' and 'default' for tag path?](https://forum.inductiveautomation.com/t/difference-between-and-default-for-tag-path/32267)
**Author:** [@dan123](https://forum.inductiveautomation.com/u/dan123)\ **Replies:** 0\ **Last updated:** [February 14, 2020, 2:59pm UTC](https://forum.inductiveautomation.com/t/difference-between-and-default-for-tag-path/32267 "2020-02-14T14:59:22Z")
Noticed some weird behavior when dragging tags to the easy chart – it sets the tag path to ‘\[~\]tag\_name’ instead of ‘\[default\]tag\_name’. I’m allowing the user to save custom trends, so I’m later referencing the tag path… --- ## [Shared varible in Template Repeater](https://forum.inductiveautomation.com/t/shared-varible-in-template-repeater/32262)
**Author:** [@Toobor](https://forum.inductiveautomation.com/u/Toobor)\ **Replies:** 3\ **Last updated:** [February 14, 2020, 2:29pm UTC](https://forum.inductiveautomation.com/t/shared-varible-in-template-repeater/32262 "2020-02-14T14:29:56Z")
Hi, I was wondering if it is possible to have a shared varible between instances of templates when using Template Repeater? In my case I have created a button in a template with lable-name as input. I have then used Te… --- ## [Tag Browser Options missing from 7.9 to 8.0](https://forum.inductiveautomation.com/t/tag-browser-options-missing-from-7-9-to-8-0/32226)
**Author:** [@cole.sharrah](https://forum.inductiveautomation.com/u/cole.sharrah)\ **Replies:** 0\ **Last updated:** [February 13, 2020, 4:19pm UTC](https://forum.inductiveautomation.com/t/tag-browser-options-missing-from-7-9-to-8-0/32226 "2020-02-13T16:19:13Z")
Tag Browser: I am not seeing options in 8 that were in 7. The columns I can view in 8 are (Value, Datatype, and Traits) Where as in 7.9 I could view many other options (the one I care about is OPC Item Path), I can n… --- ## [DefaultExpandableRow](https://forum.inductiveautomation.com/t/defaultexpandablerow/32264)
**Author:** [@giulio.comito](https://forum.inductiveautomation.com/u/giulio.comito)\ **Replies:** 2\ **Last updated:** [February 14, 2020, 1:33pm UTC](https://forum.inductiveautomation.com/t/defaultexpandablerow/32264 "2020-02-14T13:33:03Z")
Hello! Anyone know how to insert an interface (DefaultExpandableRow) inside a dataModel? I will put the dataModel inside a TreeTable (from com.jidesoft.grid import TreeTable). The result I would like is a table contai… --- ## ["no viable alternative at input 'self'"](https://forum.inductiveautomation.com/t/no-viable-alternative-at-input-self/32223)
**Author:** [@guganathan.r](https://forum.inductiveautomation.com/u/guganathan.r)\ **Replies:** 3\ **Last updated:** [February 14, 2020, 1:26pm UTC](https://forum.inductiveautomation.com/t/no-viable-alternative-at-input-self/32223 "2020-02-14T13:26:10Z")
Hi, I’m getting error on my code as “no viable alternative at input ‘self’”. I couldn’t identify any issue on my code. If I make this code as comment, the error moves on to next line and so on, until I make all these … [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1208) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1210)