# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1365 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1366 --- ## [Bar Chart Component's Grid lines](https://forum.inductiveautomation.com/t/bar-chart-components-grid-lines/18820)
**Author:** [@sarah.joy](https://forum.inductiveautomation.com/u/sarah.joy)\ **Replies:** 0\ **Last updated:** [July 13, 2018, 8:56pm UTC](https://forum.inductiveautomation.com/t/bar-chart-components-grid-lines/18820 "2018-07-13T20:56:59Z")
Is there a way to hide the grid lines in the bar chart component? --- ## [Database connections use project default database](https://forum.inductiveautomation.com/t/database-connections-use-project-default-database/10987)
**Author:** [@Tim](https://forum.inductiveautomation.com/u/Tim)\ **Replies:** 1\ **Last updated:** [July 13, 2018, 8:39pm UTC](https://forum.inductiveautomation.com/t/database-connections-use-project-default-database/10987 "2018-07-13T20:39:39Z")
Observed from the Status/Database Connections screen of the gateway queries of any database are shown only within a project's default database window even when this (default) database is not part of the query. The activ… --- ## [How Do I Remove a Property Binding?](https://forum.inductiveautomation.com/t/how-do-i-remove-a-property-binding/18818)
**Author:** [@ddurant](https://forum.inductiveautomation.com/u/ddurant)\ **Replies:** 2\ **Last updated:** [July 13, 2018, 7:25pm UTC](https://forum.inductiveautomation.com/t/how-do-i-remove-a-property-binding/18818 "2018-07-13T19:25:09Z")
I'm trying to remove a property binding. I've gone through the IU course on binding, I've searched the forms and the docs. Nowhere does it tell you how to remove a property binding or any other for that matter. Maybe … --- ## [Adding to a Table when tags change](https://forum.inductiveautomation.com/t/adding-to-a-table-when-tags-change/18755)
**Author:** [@caroline.piephoff](https://forum.inductiveautomation.com/u/caroline.piephoff)\ **Replies:** 4\ **Last updated:** [July 13, 2018, 6:19pm UTC](https://forum.inductiveautomation.com/t/adding-to-a-table-when-tags-change/18755 "2018-07-13T18:19:11Z")
I have a pop-up window with a power table that I want to add entries to when certain tags change. I have 12 tags that I am controlling values for on a separate page, and I want to be able to track their value changes in … --- ## [Transaction group statistics](https://forum.inductiveautomation.com/t/transaction-group-statistics/18816)
**Author:** [@gregsachs](https://forum.inductiveautomation.com/u/gregsachs)\ **Replies:** 0\ **Last updated:** [July 13, 2018, 5:08pm UTC](https://forum.inductiveautomation.com/t/transaction-group-statistics/18816 "2018-07-13T17:08:22Z")
Hello, long time user of Rockwell FTTM. I'm looking at migrating FTTM applications to ignition using transaction groups, and one thing that I can't figure out is how to do a screen with the status of the transcations. … --- ## [system.db.runPrepQuery](https://forum.inductiveautomation.com/t/system-db-runprepquery/18814)
**Author:** [@LopezSilvanoE](https://forum.inductiveautomation.com/u/LopezSilvanoE)\ **Replies:** 2\ **Last updated:** [July 13, 2018, 4:00pm UTC](https://forum.inductiveautomation.com/t/system-db-runprepquery/18814 "2018-07-13T16:00:02Z")
Hello .. I have a issue when try to run a PrepQuery using system.db.runPrepQuery This is my scripting... ##############################################3 StartDate = '2018-07-13 06:00:00.000' EndDate = '2018-07… --- ## [Report SQL query - dynamic database?](https://forum.inductiveautomation.com/t/report-sql-query-dynamic-database/13970)
**Author:** [@Kstofcho](https://forum.inductiveautomation.com/u/Kstofcho)\ **Replies:** 4\ **Last updated:** [July 13, 2018, 7:52am UTC](https://forum.inductiveautomation.com/t/report-sql-query-dynamic-database/13970 "2018-07-13T07:52:19Z")
Is it possible to bind the database on a Basic SQL Query within the reporting module to a tag? I am only seeing a dropdown selection and no way to bind it to a property, tag or query. I have a project set up to connect t… --- ## [SFC Stuck in Cancelling](https://forum.inductiveautomation.com/t/sfc-stuck-in-cancelling/14029)
**Author:** [@ajen](https://forum.inductiveautomation.com/u/ajen)\ **Replies:** 7\ **Last updated:** [July 13, 2018, 12:24am UTC](https://forum.inductiveautomation.com/t/sfc-stuck-in-cancelling/14029 "2018-07-13T00:24:51Z")
Hi, Has anyone encountered their SFCs getting stuck in the Cancelling step? Unfortunately, I don't know the circumstances on how it gets there. When monitoring these instances, active and historical steps do not get … --- ## [Create Report using tagpaths from DB](https://forum.inductiveautomation.com/t/create-report-using-tagpaths-from-db/18805)
**Author:** [@user1](https://forum.inductiveautomation.com/u/user1)\ **Replies:** 1\ **Last updated:** [July 12, 2018, 4:21pm UTC](https://forum.inductiveautomation.com/t/create-report-using-tagpaths-from-db/18805 "2018-07-12T16:21:45Z")
Hey, I have a database that has station names, its tagpaths, and other attributes. It's what is used to drive the navigation. I'm trying to create an Ignition report that can pull all the station tagpaths and concate… --- ## [Audit Log Table default sort](https://forum.inductiveautomation.com/t/audit-log-table-default-sort/18804)
**Author:** [@harold.bruulsema](https://forum.inductiveautomation.com/u/harold.bruulsema)\ **Replies:** 2\ **Last updated:** [July 12, 2018, 3:39pm UTC](https://forum.inductiveautomation.com/t/audit-log-table-default-sort/18804 "2018-07-12T15:39:33Z")
I have a window, with a Table object, to show recent events in the Audit Log, and a Date Range object, to allow selecting the date range to view. The Data property is bound to Other-\> Functions The Binding Function … --- ## [Access Windows Command Line](https://forum.inductiveautomation.com/t/access-windows-command-line/14720)
**Author:** [@daniel.desimone](https://forum.inductiveautomation.com/u/daniel.desimone)\ **Replies:** 10\ **Last updated:** [July 12, 2018, 2:52pm UTC](https://forum.inductiveautomation.com/t/access-windows-command-line/14720 "2018-07-12T14:52:38Z")
I need to pipe a string into the windows command line and run it. Specifically, I need to run 'snmpset -v 2c -c private XXX.XXX.XXX.XXX #.#.#.oid.#.#.# i 1', so an SNMP set command using net-snmp. That's all working fine… --- ## [Reporting - 4 save file actions with different parameters and schedule](https://forum.inductiveautomation.com/t/reporting-4-save-file-actions-with-different-parameters-and-schedule/18789)
**Author:** [@rmdalisay](https://forum.inductiveautomation.com/u/rmdalisay)\ **Replies:** 3\ **Last updated:** [July 12, 2018, 4:58am UTC](https://forum.inductiveautomation.com/t/reporting-4-save-file-actions-with-different-parameters-and-schedule/18789 "2018-07-12T04:58:57Z")
Hi!! My requirement is to auto-generate a single report per minute, daily, monthly and yearly. Thus, I should have 4 sets of startdate and enddate for each schedule. To be able to do this, I am trying to create 4 save … --- ## [Roles not Working](https://forum.inductiveautomation.com/t/roles-not-working/18781)
**Author:** [@drinaldi](https://forum.inductiveautomation.com/u/drinaldi)\ **Replies:** 6\ **Last updated:** [July 11, 2018, 3:43pm UTC](https://forum.inductiveautomation.com/t/roles-not-working/18781 "2018-07-11T15:43:56Z")
Hello, I keep getting this error below when I run my program even though the user has al the rights to do everything. please help! caused by GatewayException: Error executing function 'RunUpdateQuery': The current user… --- ## [Web Browser Component - Chromium profile directory used/locked](https://forum.inductiveautomation.com/t/web-browser-component-chromium-profile-directory-used-locked/18780)
**Author:** [@salbrechtsen](https://forum.inductiveautomation.com/u/salbrechtsen)\ **Replies:** 7\ **Last updated:** [July 11, 2018, 2:10pm UTC](https://forum.inductiveautomation.com/t/web-browser-component-chromium-profile-directory-used-locked/18780 "2018-07-11T14:10:01Z")
Any time I have more than one instance of the Web Browser component on a window, I get the error: The Chromium profile directory is already used/locked by another BrowserContext instance or process I'm assuming this… --- ## [Triggered Expression Item problem](https://forum.inductiveautomation.com/t/triggered-expression-item-problem/18783)
**Author:** [@NHOutbacker](https://forum.inductiveautomation.com/u/NHOutbacker)\ **Replies:** 3\ **Last updated:** [July 11, 2018, 2:15am UTC](https://forum.inductiveautomation.com/t/triggered-expression-item-problem/18783 "2018-07-11T02:15:01Z")
I am trying to create a triggered expression item that uses a SQL expression to determine the next value for my primary key. Now the primary key is a 15-character string (because of the requirements of the application).… --- ## [Error when attempting to set up AD/Database Hybrid User Source](https://forum.inductiveautomation.com/t/error-when-attempting-to-set-up-ad-database-hybrid-user-source/18773)
**Author:** [@DougSN](https://forum.inductiveautomation.com/u/DougSN)\ **Replies:** 1\ **Last updated:** [July 10, 2018, 5:23pm UTC](https://forum.inductiveautomation.com/t/error-when-attempting-to-set-up-ad-database-hybrid-user-source/18773 "2018-07-10T17:23:29Z")
I have set up a new user source to authenticate against AD, and to use a database for role information. I filled in all the AD information with the same data that we have in another user source, so that should be fine. I… --- ## [On Close script](https://forum.inductiveautomation.com/t/on-close-script/18777)
**Author:** [@oisin.gribben](https://forum.inductiveautomation.com/u/oisin.gribben)\ **Replies:** 1\ **Last updated:** [July 10, 2018, 1:37pm UTC](https://forum.inductiveautomation.com/t/on-close-script/18777 "2018-07-10T13:37:11Z")
Is there a function for writing a script when a window has been closed eg.(Window.onClose()) --- ## [Change scrollbar](https://forum.inductiveautomation.com/t/change-scrollbar/11984)
**Author:** [@pascal](https://forum.inductiveautomation.com/u/pascal)\ **Replies:** 5\ **Last updated:** [July 10, 2018, 12:21pm UTC](https://forum.inductiveautomation.com/t/change-scrollbar/11984 "2018-07-10T12:21:31Z")
Hello everyone, I recently saw the webinar Design Like a Pro: Graphic Design Tips for Better HMIs and I can't figure out how to get the scrollbar as it is in the video. It seems that when the project is in Client mode … --- ## [Very slow Designer start](https://forum.inductiveautomation.com/t/very-slow-designer-start/8713)
**Author:** [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\ **Replies:** 5\ **Last updated:** [July 10, 2018, 10:01am UTC](https://forum.inductiveautomation.com/t/very-slow-designer-start/8713 "2018-07-10T10:01:00Z")
I'm experiencing a rather frustrating issue: to start designer from the designer.jnlp file it takes up to 1 minute just for "Downloading application" and "Verifying application", then 20 more seconds for "Analyzing local… --- ## [Report Bar Chart](https://forum.inductiveautomation.com/t/report-bar-chart/18771)
**Author:** [@rgarcher](https://forum.inductiveautomation.com/u/rgarcher)\ **Replies:** 0\ **Last updated:** [July 9, 2018, 7:49pm UTC](https://forum.inductiveautomation.com/t/report-bar-chart/18771 "2018-07-09T19:49:59Z")
Is there a way to make the data source for a bar chart be calculated values from rows of a table? I have a SQL query with several nested queries which I'm using to come up with 1 row of calculated values and 1 row of ti… --- ## [Bar Chart Configuration](https://forum.inductiveautomation.com/t/bar-chart-configuration/5857)
**Author:** [@vikasgodbole](https://forum.inductiveautomation.com/u/vikasgodbole)\ **Replies:** 4\ **Last updated:** [July 9, 2018, 6:05pm UTC](https://forum.inductiveautomation.com/t/bar-chart-configuration/5857 "2018-07-09T18:05:36Z")
HI All, In one of the project we are trying to configure the bar chart to show historical data. We would like to know in detail How to configure bar chart. How to connect the tags to the Bar chart so that we can se… --- ## [How to prevent Ignition server restart/crash](https://forum.inductiveautomation.com/t/how-to-prevent-ignition-server-restart-crash/18769)
**Author:** [@harryzhou4498](https://forum.inductiveautomation.com/u/harryzhou4498)\ **Replies:** 2\ **Last updated:** [July 9, 2018, 3:29pm UTC](https://forum.inductiveautomation.com/t/how-to-prevent-ignition-server-restart-crash/18769 "2018-07-09T15:29:46Z")
I’m currently getting server restarts/crashes on Ignition with these messages in my logs. I’m not sure what this is related to - I would assume that Ignition’s server cannot be online indefinitely and may need to restar… --- ## [Charting High Volumes of Data](https://forum.inductiveautomation.com/t/charting-high-volumes-of-data/18763)
**Author:** [@kevin.jones](https://forum.inductiveautomation.com/u/kevin.jones)\ **Replies:** 6\ **Last updated:** [July 9, 2018, 2:50pm UTC](https://forum.inductiveautomation.com/t/charting-high-volumes-of-data/18763 "2018-07-09T14:50:41Z")
Hello, I’m having some issues charting a large number of data points and I can’t figure out what is going wrong. I’m using an Easy Chart with a SQL query to grab the data. With the size of the chart in useI can get up t… --- ## [Template repeater render issue](https://forum.inductiveautomation.com/t/template-repeater-render-issue/18751)
**Author:** [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\ **Replies:** 5\ **Last updated:** [July 9, 2018, 7:52am UTC](https://forum.inductiveautomation.com/t/template-repeater-render-issue/18751 "2018-07-09T07:52:31Z")
A template repeater should show 10 instances of a template like this: Sometimes they show up like in the following screenshot: All leds are Images from the builtin library: each image Color Swap Filter property is … --- ## [Power table dynamic data edit](https://forum.inductiveautomation.com/t/power-table-dynamic-data-edit/18762)
**Author:** [@john.eichler](https://forum.inductiveautomation.com/u/john.eichler)\ **Replies:** 1\ **Last updated:** [July 8, 2018, 8:53am UTC](https://forum.inductiveautomation.com/t/power-table-dynamic-data-edit/18762 "2018-07-08T08:53:14Z")
ignition 7.9. Hi I'm following these guidelines for editing an SQL db through a Power table. https://docs.inductiveautomation.com/display/DOC79/Updating+the+Database+through+the+Power+Table I can get it to work f… --- ## [Custom On/Off Button](https://forum.inductiveautomation.com/t/custom-on-off-button/18591)
**Author:** [@ddurant](https://forum.inductiveautomation.com/u/ddurant)\ **Replies:** 12\ **Last updated:** [July 7, 2018, 10:57pm UTC](https://forum.inductiveautomation.com/t/custom-on-off-button/18591 "2018-07-07T22:57:26Z")
I have two buttons that I got from the Symbol Factory: I want to put one on top of the other so when you press it, it turns green or red. I see where you can add an image to a two-state toggle button using the Image … --- ## [Ripping Schedule from Admin Schedule Management Component](https://forum.inductiveautomation.com/t/ripping-schedule-from-admin-schedule-management-component/18758)
**Author:** [@stuart.williams](https://forum.inductiveautomation.com/u/stuart.williams)\ **Replies:** 2\ **Last updated:** [July 7, 2018, 7:15pm UTC](https://forum.inductiveautomation.com/t/ripping-schedule-from-admin-schedule-management-component/18758 "2018-07-07T19:15:12Z")
Hello again, everyone. I'd love to use the built-in Schedule Management component instead of developing my own, but our customer wants the schedules to be in a monthly display. So, my plan was to have them make the sch… --- ## [Using Template Repeater with templates that use UDTs](https://forum.inductiveautomation.com/t/using-template-repeater-with-templates-that-use-udts/12257)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 1\ **Last updated:** [October 27, 2016, 1:05am UTC](https://forum.inductiveautomation.com/t/using-template-repeater-with-templates-that-use-udts/12257 "2016-10-27T01:05:17Z")
Hi, I'm very new to Ignition and perhaps this is a dumb question... I have a tank template that has one custom parameter which is a UDT type. I've called the parameter TankUDT. I have a number of instances of this … --- ## [Pass UDT to a Window via python script](https://forum.inductiveautomation.com/t/pass-udt-to-a-window-via-python-script/12294)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 2\ **Last updated:** [November 2, 2016, 10:40am UTC](https://forum.inductiveautomation.com/t/pass-udt-to-a-window-via-python-script/12294 "2016-11-02T10:40:20Z")
I want to pass a UDTProperty parameter to a Window via script, but I can't work out how to convert the UDT tagpath string to a UDTProperty type. I have at the moment this script on the mouse release action of a button: … --- ## [SQL Query Error](https://forum.inductiveautomation.com/t/sql-query-error/8753)
**Author:** [@ceccontrols](https://forum.inductiveautomation.com/u/ceccontrols)\ **Replies:** 5\ **Last updated:** [July 7, 2018, 2:48am UTC](https://forum.inductiveautomation.com/t/sql-query-error/8753 "2018-07-07T02:48:02Z")
I am getting an "error converting varchar to bigint" on my query on tag history. It is happening in the where clause. t\_stamp is a date, intvalue is an bigint, dataintegrity is an int. Sample of row data and error belo… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1364) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1366)