# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1107 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1108 --- ## [Please, Can you help me Edge Sync Services with SQL server](https://forum.inductiveautomation.com/t/please-can-you-help-me-edge-sync-services-with-sql-server/40020)
**Author:** [@duchung821](https://forum.inductiveautomation.com/u/duchung821)\ **Replies:** 4\ **Last updated:** [October 28, 2020, 2:16am UTC](https://forum.inductiveautomation.com/t/please-can-you-help-me-edge-sync-services-with-sql-server/40020 "2020-10-28T02:16:25Z")
I cannot synchronize data with SQL, I have declared it as shown. In which “MS\_SQL” is the database which is connected from the gateway server --- ## [Snap shot date time](https://forum.inductiveautomation.com/t/snap-shot-date-time/40065)
**Author:** [@Bnolan40](https://forum.inductiveautomation.com/u/Bnolan40)\ **Replies:** 4\ **Last updated:** [October 28, 2020, 2:09am UTC](https://forum.inductiveautomation.com/t/snap-shot-date-time/40065 "2020-10-28T02:09:46Z")
Hello I am coming from a wonderware background so bare with me. I am trying to snap shot the current time into a string from a push button can’t seem to get just the time. --- ## [Password field is not contained in a form](https://forum.inductiveautomation.com/t/password-field-is-not-contained-in-a-form/40071)
**Author:** [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Replies:** 2\ **Last updated:** [October 27, 2020, 9:59pm UTC](https://forum.inductiveautomation.com/t/password-field-is-not-contained-in-a-form/40071 "2020-10-27T21:59:52Z")
I created a user management view, very similar to the one in vision. I get an error in the console, Password field is not contained in a form. If I search this it looks like this is a warning based on Chrome. Any caus… --- ## [Perspective pass exception to view](https://forum.inductiveautomation.com/t/perspective-pass-exception-to-view/40066)
**Author:** [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\ **Replies:** 1\ **Last updated:** [October 27, 2020, 8:26pm UTC](https://forum.inductiveautomation.com/t/perspective-pass-exception-to-view/40066 "2020-10-27T20:26:34Z")
Ignition 8.0.16 I’m not totally sure if I’m doing this the correct way however here we go. I’ve got a footer dock that I’m using to signal to the user when an exception occurs. I open that dock in a try/except block. B… --- ## [Access one column of dataset returned by Stored Procedure in Perspective](https://forum.inductiveautomation.com/t/access-one-column-of-dataset-returned-by-stored-procedure-in-perspective/40058)
**Author:** [@JWStaggs78](https://forum.inductiveautomation.com/u/JWStaggs78)\ **Replies:** 2\ **Last updated:** [October 27, 2020, 7:44pm UTC](https://forum.inductiveautomation.com/t/access-one-column-of-dataset-returned-by-stored-procedure-in-perspective/40058 "2020-10-27T19:44:15Z")
My database admin, supplies some data via stored procedure which returns one row with 6 columns. I would like to bind to that and use 1 of those columns as a data point in a chart. I have a Named Query that takes the s… --- ## ['Usage Tracking' with Auditing?](https://forum.inductiveautomation.com/t/usage-tracking-with-auditing/40054)
**Author:** [@scott.stamps](https://forum.inductiveautomation.com/u/scott.stamps)\ **Replies:** 3\ **Last updated:** [October 27, 2020, 7:28pm UTC](https://forum.inductiveautomation.com/t/usage-tracking-with-auditing/40054 "2020-10-27T19:28:13Z")
We are interested in tracking our project(s) page/view usage by user - a bit like Google Analytics, but much simpler. It seems the Auditing feature gets close to this, but I am unsure if it can be configured to do what w… --- ## [History Tag Reporting exclude 0s](https://forum.inductiveautomation.com/t/history-tag-reporting-exclude-0s/40056)
**Author:** [@wci.jgiese](https://forum.inductiveautomation.com/u/wci.jgiese)\ **Replies:** 0\ **Last updated:** [October 27, 2020, 4:36pm UTC](https://forum.inductiveautomation.com/t/history-tag-reporting-exclude-0s/40056 "2020-10-27T16:36:54Z")
I’m trying to figure out how to get average speed of our machine running from history tags. I have figured out how to do it where it gives me say the total average over a 1hr period or what have you, but it includes the … --- ## [Value change scripts stopped working](https://forum.inductiveautomation.com/t/value-change-scripts-stopped-working/39949)
**Author:** [@Sheko29](https://forum.inductiveautomation.com/u/Sheko29)\ **Replies:** 2\ **Last updated:** [October 27, 2020, 3:39pm UTC](https://forum.inductiveautomation.com/t/value-change-scripts-stopped-working/39949 "2020-10-27T15:39:43Z")
Hi, I have some tags with change value scripts that work perfectly, but for no reason someone just stopped working with no error… justo doesn’t do the script… the only solution I found to this is enter the script and dis… --- ## [Dataset and loops](https://forum.inductiveautomation.com/t/dataset-and-loops/40026)
**Author:** [@steven.cox](https://forum.inductiveautomation.com/u/steven.cox)\ **Replies:** 11\ **Last updated:** [October 27, 2020, 2:30pm UTC](https://forum.inductiveautomation.com/t/dataset-and-loops/40026 "2020-10-27T14:30:12Z")
Hi all, I am new to Ignition and scripting and I am stuck again. I am trying to get the value of one cell and use that value in another cell. This is what I have: newDataSet = system.dataset.toPyData… --- ## [How to sum using a Join In a report](https://forum.inductiveautomation.com/t/how-to-sum-using-a-join-in-a-report/40029)
**Author:** [@jshaffer09](https://forum.inductiveautomation.com/u/jshaffer09)\ **Replies:** 8\ **Last updated:** [October 27, 2020, 2:02pm UTC](https://forum.inductiveautomation.com/t/how-to-sum-using-a-join-in-a-report/40029 "2020-10-27T14:02:59Z")
How to sum using a Join in a report I am trying to run the query below. When I run it, it shows no results. I am trying to list out each AppUsers name and there hours for the current month. Select a.UserNm, sum(isnu… --- ## [How to fix bar height in property it should not be auto adjust as per the input provided](https://forum.inductiveautomation.com/t/how-to-fix-bar-height-in-property-it-should-not-be-auto-adjust-as-per-the-input-provided/40048)
**Author:** [@archana.deshmukh](https://forum.inductiveautomation.com/u/archana.deshmukh)\ **Replies:** 0\ **Last updated:** [October 27, 2020, 1:56pm UTC](https://forum.inductiveautomation.com/t/how-to-fix-bar-height-in-property-it-should-not-be-auto-adjust-as-per-the-input-provided/40048 "2020-10-27T13:56:31Z")
how to fix bar height in property it should not be auto adjust as per the input provided. in above example if there is only one part number data available in database it is auto adjusting the height of that bar as pe… --- ## [SQL Bridge -- Error during group execution](https://forum.inductiveautomation.com/t/sql-bridge-error-during-group-execution/40047)
**Author:** [@joe.miller](https://forum.inductiveautomation.com/u/joe.miller)\ **Replies:** 0\ **Last updated:** [October 27, 2020, 1:20pm UTC](https://forum.inductiveautomation.com/t/sql-bridge-error-during-group-execution/40047 "2020-10-27T13:20:31Z")
In the log, i am seeing a logger entry: SQL Bridge.project name.TransactionGroupFolder\_TransactionGroupName the logger entry has the message: Error during group exectution if I get into the transaction group, it has th… --- ## [There are other users editing this project](https://forum.inductiveautomation.com/t/there-are-other-users-editing-this-project/40003)
**Author:** [@drastura](https://forum.inductiveautomation.com/u/drastura)\ **Replies:** 3\ **Last updated:** [October 27, 2020, 1:19pm UTC](https://forum.inductiveautomation.com/t/there-are-other-users-editing-this-project/40003 "2020-10-27T13:19:57Z")
I currently have several windows showing that someone else is editing them. Looking at the “Concurrent Users” box, it shows that myself, and two others are editing various things. The problem is, I’m listed as the one … --- ## [\[FEATURE-936\] Please sort Parent Data Type dropdown list :)](https://forum.inductiveautomation.com/t/feature-936-please-sort-parent-data-type-dropdown-list/40041)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 1\ **Last updated:** [October 27, 2020, 11:34am UTC](https://forum.inductiveautomation.com/t/feature-936-please-sort-parent-data-type-dropdown-list/40041 "2020-10-27T11:34:47Z")
v8.1.0rc1 Can the parent data type dropdown list please be sorted? Also, should Parent Data Type be renamed to Type Id to be consistent with the property name change? (i.e. from UDTParentType to TypeId) --- ## [Edit buttons in edit popup from NumericEntryField in Perspective](https://forum.inductiveautomation.com/t/edit-buttons-in-edit-popup-from-numericentryfield-in-perspective/40043)
**Author:** [@mpoulsen921](https://forum.inductiveautomation.com/u/mpoulsen921)\ **Replies:** 0\ **Last updated:** [October 27, 2020, 8:21am UTC](https://forum.inductiveautomation.com/t/edit-buttons-in-edit-popup-from-numericentryfield-in-perspective/40043 "2020-10-27T08:21:07Z")
Hi there, Is it possible to edit the text, boundaries, font, etc. of the two buttons in the edit popup from the Numeric Entry Field in Perspective? I have assigned a class to the style of the component, but that does n… --- ## [Transaction Groups Start Recording and Stop Recording](https://forum.inductiveautomation.com/t/transaction-groups-start-recording-and-stop-recording/38641)
**Author:** [@illank86](https://forum.inductiveautomation.com/u/illank86)\ **Replies:** 6\ **Last updated:** [October 27, 2020, 5:42am UTC](https://forum.inductiveautomation.com/t/transaction-groups-start-recording-and-stop-recording/38641 "2020-10-27T05:42:16Z")
Dear All, i have problem regarding Transaction Groups. i want to start recording from 1:00AM and stop record at 00:00PM on the same date every 1 Hour. my problem now is transaction groups is start recording from 00:33… --- ## [\[FEATURE\] Make disabled items more obviously disabled](https://forum.inductiveautomation.com/t/feature-make-disabled-items-more-obviously-disabled/40040)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 0\ **Last updated:** [October 27, 2020, 5:30am UTC](https://forum.inductiveautomation.com/t/feature-make-disabled-items-more-obviously-disabled/40040 "2020-10-27T05:30:02Z")
v8.1.0rc1 The new disabled badge is good, but it’s nowhere near obvious enough especially if you’re trying to skim through tags: --- ## [HttpResponseException: 404 Help](https://forum.inductiveautomation.com/t/httpresponseexception-404-help/38654)
**Author:** [@delbert\_edric](https://forum.inductiveautomation.com/u/delbert_edric)\ **Replies:** 5\ **Last updated:** [October 27, 2020, 12:14am UTC](https://forum.inductiveautomation.com/t/httpresponseexception-404-help/38654 "2020-10-27T00:14:40Z")
Hey guys, I am a Coop and as a side task, my boss asked me to help dig around to find a solution for this problem. Only her laptop or app is affected. I can open it just fine. I’ve heard it could be a corrupted file but… --- ## [Icon Inconsistencies on Perspective Designer](https://forum.inductiveautomation.com/t/icon-inconsistencies-on-perspective-designer/39993)
**Author:** [@weertske](https://forum.inductiveautomation.com/u/weertske)\ **Replies:** 1\ **Last updated:** [October 26, 2020, 10:30pm UTC](https://forum.inductiveautomation.com/t/icon-inconsistencies-on-perspective-designer/39993 "2020-10-26T22:30:16Z")
I have two designers opened on my computer. One pointing at my development platform and one pointing at my production platform. Both are running 8.0.16. On the dev platform I am able to use pretty much all material icons… --- ## [Bar Chart DateTime Format](https://forum.inductiveautomation.com/t/bar-chart-datetime-format/37999)
**Author:** [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Replies:** 4\ **Last updated:** [October 26, 2020, 8:40pm UTC](https://forum.inductiveautomation.com/t/bar-chart-datetime-format/37999 "2020-10-26T20:40:51Z")
Is there anyway to format date time in a bar chart (I don’t see a way)? Data is coming from tag history. Or, is there an easy way to edit data in a dataset to the correct format, then use this data in the binding? Typ… --- ## [After upgrade to 8.0.16 getting Error launching application when opening Designer](https://forum.inductiveautomation.com/t/after-upgrade-to-8-0-16-getting-error-launching-application-when-opening-designer/40031)
**Author:** [@MikeAllgood](https://forum.inductiveautomation.com/u/MikeAllgood)\ **Replies:** 5\ **Last updated:** [October 26, 2020, 7:56pm UTC](https://forum.inductiveautomation.com/t/after-upgrade-to-8-0-16-getting-error-launching-application-when-opening-designer/40031 "2020-10-26T19:56:41Z")
I just upgraded a production server from 8.0.8 to 8.0.16. After the upgrade and after the Gateway was running, I tried opening the Designer and got and error dialog. Thinking it may be due to the old Designer Launche… --- ## [Iterating through array(com.inductiveautomation.ignition.common.model.values.QualifiedValue)](https://forum.inductiveautomation.com/t/iterating-through-array-com-inductiveautomation-ignition-common-model-values-qualifiedvalue/40021)
**Author:** [@wking](https://forum.inductiveautomation.com/u/wking)\ **Replies:** 3\ **Last updated:** [October 26, 2020, 4:43pm UTC](https://forum.inductiveautomation.com/t/iterating-through-array-com-inductiveautomation-ignition-common-model-values-qualifiedvalue/40021 "2020-10-26T16:43:50Z")
I have a script server = "Ignition OPC UA Server" machina = "D24" indexer = range(32) pathArray = \[\] for i in indexer: path = "ns=1;s=\[%s\]Global.UnitData.Plug.Plug\[%s\].Station" %(machina,i) pathArray.append(path) … --- ## [Unable to Remove Tag Groups](https://forum.inductiveautomation.com/t/unable-to-remove-tag-groups/39842)
**Author:** [@james.wilson](https://forum.inductiveautomation.com/u/james.wilson)\ **Replies:** 2\ **Last updated:** [October 26, 2020, 3:33pm UTC](https://forum.inductiveautomation.com/t/unable-to-remove-tag-groups/39842 "2020-10-26T15:33:40Z")
I’m using Ignition v8.0.14. The image below shows the tag groups that appear in the list when editing a tag. I want to get rid of all that tag groups that start with AA which were created when I imported a tag structure … --- ## [system.net.sendEmail encoding](https://forum.inductiveautomation.com/t/system-net-sendemail-encoding/40013)
**Author:** [@jakned](https://forum.inductiveautomation.com/u/jakned)\ **Replies:** 2\ **Last updated:** [October 26, 2020, 2:24pm UTC](https://forum.inductiveautomation.com/t/system-net-sendemail-encoding/40013 "2020-10-26T14:24:16Z")
Hello, I am trying to send an email that has following subject (in Czech): “Nový posun” and what I receive is: “Nov?? posun” How do I make sending email contents with diacritics work properly? Thank you! --- ## [Integer Array Bit Alarming not working as advertised](https://forum.inductiveautomation.com/t/integer-array-bit-alarming-not-working-as-advertised/39873)
**Author:** [@rsonnicksen](https://forum.inductiveautomation.com/u/rsonnicksen)\ **Replies:** 1\ **Last updated:** [October 26, 2020, 1:15pm UTC](https://forum.inductiveautomation.com/t/integer-array-bit-alarming-not-working-as-advertised/39873 "2020-10-26T13:15:41Z")
I’m using Ignition Edge ver 7.9.16. Ive created an integer array with source type Integer which is bringing in 32 bits from a DINT (double integer) from the PLC. I’ve created 3 bit alarms on bits 0, 1 and 2. When I pu… --- ## [Equipment Schedule and daylight saving time](https://forum.inductiveautomation.com/t/equipment-schedule-and-daylight-saving-time/40007)
**Author:** [@chi](https://forum.inductiveautomation.com/u/chi)\ **Replies:** 0\ **Last updated:** [October 26, 2020, 10:00am UTC](https://forum.inductiveautomation.com/t/equipment-schedule-and-daylight-saving-time/40007 "2020-10-26T10:00:08Z")
Since the end of DST last night, i have an one hour offset in the equiqment schedules time axis. The times in the dataset are correct, but the axis on top of the schedule is one hour off. Gateway and client system times… --- ## [Perspective: Open Vision Window](https://forum.inductiveautomation.com/t/perspective-open-vision-window/34518)
**Author:** [@iscrac](https://forum.inductiveautomation.com/u/iscrac)\ **Replies:** 19\ **Last updated:** [October 26, 2020, 8:23am UTC](https://forum.inductiveautomation.com/t/perspective-open-vision-window/34518 "2020-10-26T08:23:02Z")
Hi Everyone! Can anyone answer me one question: Is it possible to open an Vision window from Perspective via Gateway or Session scripts? The idea is: I connect one Perspective page (via WebBrowser) in Vision, so I need… --- ## [Ignition Node Red](https://forum.inductiveautomation.com/t/ignition-node-red/39979)
**Author:** [@monc](https://forum.inductiveautomation.com/u/monc)\ **Replies:** 4\ **Last updated:** [October 26, 2020, 1:22am UTC](https://forum.inductiveautomation.com/t/ignition-node-red/39979 "2020-10-26T01:22:14Z")
Hello, Where can we buy the license for ignition node red module? (https://github.com/IgnitionModuleDevelopmentCommunity/IgnitionNode-RED) Thanks --- ## [Formatted Text field - committed value](https://forum.inductiveautomation.com/t/formatted-text-field-committed-value/39936)
**Author:** [@steven.cox](https://forum.inductiveautomation.com/u/steven.cox)\ **Replies:** 5\ **Last updated:** [October 25, 2020, 10:59pm UTC](https://forum.inductiveautomation.com/t/formatted-text-field-committed-value/39936 "2020-10-25T22:59:16Z")
Hi all, I am new to Ignition and scripting. I am trying to sort out an issue with formatted text fields. I have a formatted text field that works (I thought the way it was supposed to). When I enter text, the text pr… --- ## [Ignition OPC-UA client connecting to Softing SIS views it as recursive address space](https://forum.inductiveautomation.com/t/ignition-opc-ua-client-connecting-to-softing-sis-views-it-as-recursive-address-space/39989)
**Author:** [@321liftoff](https://forum.inductiveautomation.com/u/321liftoff)\ **Replies:** 7\ **Last updated:** [October 25, 2020, 3:32pm UTC](https://forum.inductiveautomation.com/t/ignition-opc-ua-client-connecting-to-softing-sis-views-it-as-recursive-address-space/39989 "2020-10-25T15:32:09Z")
@Kevin.Herron Using the OPC-UA beta module (8.0.16-SNAPSHOT (b2020072505)) running on Ignition 8.0.15 (b2020072213). When I connect to the Softing SIS server version 1.22.0.8686, which is connecting to a demo OPC-UA sou… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1106) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1108)