# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1463 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1464 --- ## [Text Data from SQL Query](https://forum.inductiveautomation.com/t/text-data-from-sql-query/11337)
**Author:** [@boster281](https://forum.inductiveautomation.com/u/boster281)\ **Replies:** 1\ **Last updated:** [March 9, 2016, 11:01pm UTC](https://forum.inductiveautomation.com/t/text-data-from-sql-query/11337 "2016-03-09T23:01:53Z")
Not sure if this is possible but figure i might a well ask. I want to do an sql query that returns a number SELECT PartStatus FROM \[Thermoplastics\].\[dbo\].\[PartTracking\] WHERE Container like '{Root Container.Containe… --- ## [Transaction Group Quality Code](https://forum.inductiveautomation.com/t/transaction-group-quality-code/11336)
**Author:** [@jim\_lapratt](https://forum.inductiveautomation.com/u/jim_lapratt)\ **Replies:** 1\ **Last updated:** [March 9, 2016, 5:35pm UTC](https://forum.inductiveautomation.com/t/transaction-group-quality-code/11336 "2016-03-09T17:35:35Z")
In a Transaction group what is the "Store quality code" value derived from? 1 tag, all tags........ --- ## [Sql query The multi-part identifier could not be bound](https://forum.inductiveautomation.com/t/sql-query-the-multi-part-identifier-could-not-be-bound/11335)
**Author:** [@boster281](https://forum.inductiveautomation.com/u/boster281)\ **Replies:** 0\ **Last updated:** [March 9, 2016, 2:00pm UTC](https://forum.inductiveautomation.com/t/sql-query-the-multi-part-identifier-could-not-be-bound/11335 "2016-03-09T14:00:05Z")
The error message i am getting: File "", line 43, in Thermoplastics.dbo.PartTracking set Thermoplastics.dbo.PartTracking = 97 from Thermoplastics.dbo.PartTracking inner join Thermoplast… --- ## [Ignition OPC UA interoperability](https://forum.inductiveautomation.com/t/ignition-opc-ua-interoperability/11327)
**Author:** [@R.Alamsha](https://forum.inductiveautomation.com/u/R.Alamsha)\ **Replies:** 3\ **Last updated:** [March 9, 2016, 1:53pm UTC](https://forum.inductiveautomation.com/t/ignition-opc-ua-interoperability/11327 "2016-03-09T13:53:48Z")
I am carrying out some interoperability tests of Ignition OPC UA client/server with other OPC UA vendors. Recently i tried to connect UaExpert OPC UA client (Unified Automation) with Ignition server. I noticed a lot of … --- ## [Reporting 7.8 date error](https://forum.inductiveautomation.com/t/reporting-7-8-date-error/11093)
**Author:** [@heybales](https://forum.inductiveautomation.com/u/heybales)\ **Replies:** 6\ **Last updated:** [March 9, 2016, 1:18am UTC](https://forum.inductiveautomation.com/t/reporting-7-8-date-error/11093 "2016-03-09T01:18:55Z")
I'm getting the following warnings when running a report. WARN: Ending date {StepFinish} for tag history in report Report could not be parsed as a date. WARN: Using Historical date range, but could not parse {StepSTart… --- ## [Valid data point calculation from SQL](https://forum.inductiveautomation.com/t/valid-data-point-calculation-from-sql/11090)
**Author:** [@emanuel](https://forum.inductiveautomation.com/u/emanuel)\ **Replies:** 3\ **Last updated:** [March 8, 2016, 9:57pm UTC](https://forum.inductiveautomation.com/t/valid-data-point-calculation-from-sql/11090 "2016-03-08T21:57:21Z")
I have a customer that currently uses an Excel to log data through another SCADA package that I am replacing with IA. The data they log is just simple temperatures and average that data at the end of the day (24-hour), b… --- ## [Comments panel unstick link not obeying foreground color](https://forum.inductiveautomation.com/t/comments-panel-unstick-link-not-obeying-foreground-color/11325)
**Author:** [@fledder](https://forum.inductiveautomation.com/u/fledder)\ **Replies:** 0\ **Last updated:** [March 7, 2016, 10:51pm UTC](https://forum.inductiveautomation.com/t/comments-panel-unstick-link-not-obeying-foreground-color/11325 "2016-03-07T22:51:45Z")
Ignition 7.8.0 On the comments panel, the Unstick link is always black text, no matter what the foreground color is set to. --- ## [Report Parameters for table cells](https://forum.inductiveautomation.com/t/report-parameters-for-table-cells/11323)
**Author:** [@Caleb\_Bohon](https://forum.inductiveautomation.com/u/Caleb_Bohon)\ **Replies:** 0\ **Last updated:** [March 7, 2016, 9:50pm UTC](https://forum.inductiveautomation.com/t/report-parameters-for-table-cells/11323 "2016-03-07T21:50:36Z")
Is there any way to quickly change a parameter on multiple table cells / text shapes? I have a table where I want the cell borders to show, and I had all the columns setup to do that, but when I extended the table it d… --- ## [Tag history table Fixed sample size returns extra sample](https://forum.inductiveautomation.com/t/tag-history-table-fixed-sample-size-returns-extra-sample/11322)
**Author:** [@Chris\_Taylor](https://forum.inductiveautomation.com/u/Chris_Taylor)\ **Replies:** 4\ **Last updated:** [March 7, 2016, 8:23pm UTC](https://forum.inductiveautomation.com/t/tag-history-table-fixed-sample-size-returns-extra-sample/11322 "2016-03-07T20:23:40Z")
I’m having problems I’m trying to retrieve a number of values to a table from tag history for a single point in time. take a look at the image. I’m asking for four records, the sample size is fixed at 1, but I’m get… --- ## [Email Chart](https://forum.inductiveautomation.com/t/email-chart/11224)
**Author:** [@hazey](https://forum.inductiveautomation.com/u/hazey)\ **Replies:** 6\ **Last updated:** [March 7, 2016, 3:54pm UTC](https://forum.inductiveautomation.com/t/email-chart/11224 "2016-03-07T15:54:03Z")
Guys I want to email a chart, I have written this script in client event script. It works but I get multiple copies of the email, more than the 2 clients that are open. How can I limit it to one email please? thx Dennis … --- ## [Report Tag History From Dataset Parameter](https://forum.inductiveautomation.com/t/report-tag-history-from-dataset-parameter/11319)
**Author:** [@bfearnow](https://forum.inductiveautomation.com/u/bfearnow)\ **Replies:** 2\ **Last updated:** [March 5, 2016, 6:26pm UTC](https://forum.inductiveautomation.com/t/report-tag-history-from-dataset-parameter/11319 "2016-03-05T18:26:35Z")
I'll probably fail at explaining this, but I have a dataset tag looking for any production lines that have an end time equal to a certain time. When this event happens it gets passed to a report. Within the report, a t… --- ## [CReating Report](https://forum.inductiveautomation.com/t/creating-report/11312)
**Author:** [@illank86](https://forum.inductiveautomation.com/u/illank86)\ **Replies:** 3\ **Last updated:** [March 5, 2016, 3:41am UTC](https://forum.inductiveautomation.com/t/creating-report/11312 "2016-03-05T03:41:20Z")
Hi all, i know this is gonna be a really really stupid question,i try to find it in the forum and inductive university as well but got no answer. ok so my question is, if i want to create 5 different reports, should i … --- ## [Easy Chart Using Too Much Memory](https://forum.inductiveautomation.com/t/easy-chart-using-too-much-memory/11281)
**Author:** [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\ **Replies:** 1\ **Last updated:** [March 4, 2016, 8:50pm UTC](https://forum.inductiveautomation.com/t/easy-chart-using-too-much-memory/11281 "2016-03-04T20:50:59Z")
Hey guys, I have a pretty simple project that I'm building that will control a piece of equipment. The main page is basically a template (many systems will be used) that displays a trend via easy chart and some control… --- ## [Easy chart pen where clause](https://forum.inductiveautomation.com/t/easy-chart-pen-where-clause/11300)
**Author:** [@Fabrice\_CHAVEROT](https://forum.inductiveautomation.com/u/Fabrice_CHAVEROT)\ **Replies:** 1\ **Last updated:** [March 3, 2016, 11:12pm UTC](https://forum.inductiveautomation.com/t/easy-chart-pen-where-clause/11300 "2016-03-03T23:12:22Z")
Is it possible to access a custom property in the pen editor of an easy chart component ? It gives me an error If not is there a workaround to do that ? \[attachment=0\]ignition.PNG\[/attachment\] --- ## [Object size property in scripting](https://forum.inductiveautomation.com/t/object-size-property-in-scripting/11310)
**Author:** [@kblankenship](https://forum.inductiveautomation.com/u/kblankenship)\ **Replies:** 0\ **Last updated:** [March 3, 2016, 6:16pm UTC](https://forum.inductiveautomation.com/t/object-size-property-in-scripting/11310 "2016-03-03T18:16:40Z")
Is there a way to capture an object's size as a property for scripting? I am building a Template canvas and do not want it to exceed the size of the canvas and add scroll bars, so I was going to script template size to … --- ## [Auto Scan Class Creation?](https://forum.inductiveautomation.com/t/auto-scan-class-creation/11309)
**Author:** [@mm3](https://forum.inductiveautomation.com/u/mm3)\ **Replies:** 0\ **Last updated:** [March 3, 2016, 5:34pm UTC](https://forum.inductiveautomation.com/t/auto-scan-class-creation/11309 "2016-03-03T17:34:11Z")
Does Ignition 7.8.1 have a feature to create scan classes for you? I've got a UDT Parameter called historyScanClass that is a string. A tag in the UDT is then using {historyScanClass} to retrieve this parameter for i… --- ## [History tag, single value?](https://forum.inductiveautomation.com/t/history-tag-single-value/11308)
**Author:** [@Chris\_Taylor](https://forum.inductiveautomation.com/u/Chris_Taylor)\ **Replies:** 0\ **Last updated:** [March 3, 2016, 3:32pm UTC](https://forum.inductiveautomation.com/t/history-tag-single-value/11308 "2016-03-03T15:32:33Z")
I think I'm having a senior moment. I have a number of boolean history tags, what I'd like to do is to query the tag history to bring back a single value for each tag for a specific point in history, and they drive a b… --- ## [While using SQL query to write to database how to write NULL](https://forum.inductiveautomation.com/t/while-using-sql-query-to-write-to-database-how-to-write-null/11306)
**Author:** [@vanko25](https://forum.inductiveautomation.com/u/vanko25)\ **Replies:** 1\ **Last updated:** [March 3, 2016, 2:09pm UTC](https://forum.inductiveautomation.com/t/while-using-sql-query-to-write-to-database-how-to-write-null/11306 "2016-03-03T14:09:33Z")
Hello all, I am using the following script to write to sql table the data from few dropdown boxes. But if the selected value is blank it won't write it down as NULL. Any idea how to do that? Here is the code: name = … --- ## [system.security.getRoles() returns empty list](https://forum.inductiveautomation.com/t/system-security-getroles-returns-empty-list/11292)
**Author:** [@WChester](https://forum.inductiveautomation.com/u/WChester)\ **Replies:** 2\ **Last updated:** [March 3, 2016, 1:09pm UTC](https://forum.inductiveautomation.com/t/system-security-getroles-returns-empty-list/11292 "2016-03-03T13:09:21Z")
I am trying to set up some security in a project of mine. As part of that I need to look at the role that the current user has. When I use system.security.getRoles() I get an empty list. However when I use system.… --- ## [Read and Write DB table](https://forum.inductiveautomation.com/t/read-and-write-db-table/11282)
**Author:** [@Jayden](https://forum.inductiveautomation.com/u/Jayden)\ **Replies:** 2\ **Last updated:** [March 3, 2016, 9:28am UTC](https://forum.inductiveautomation.com/t/read-and-write-db-table/11282 "2016-03-03T09:28:06Z")
Hi everyone, I'm new to ignition and scripting, so this is no doubt a simple question. I would like to have some buttons in my project to write to and from cells in a DB table. Button 1 - Writes value from DB cel… --- ## [Grouping does not take effect in chart](https://forum.inductiveautomation.com/t/grouping-does-not-take-effect-in-chart/11305)
**Author:** [@rmdalisay](https://forum.inductiveautomation.com/u/rmdalisay)\ **Replies:** 0\ **Last updated:** [March 3, 2016, 6:28am UTC](https://forum.inductiveautomation.com/t/grouping-does-not-take-effect-in-chart/11305 "2016-03-03T06:28:00Z")
Hi! I am using MES reports and wanted to convert them to reporting version 7.8. I am currently trying to convert the OEE Report. I already followed the instructions in inductiveautomation.com/forum/v ... rts#p53836 … --- ## [Still no tag description in browse tree?](https://forum.inductiveautomation.com/t/still-no-tag-description-in-browse-tree/11304)
**Author:** [@pjgonzales](https://forum.inductiveautomation.com/u/pjgonzales)\ **Replies:** 0\ **Last updated:** [March 2, 2016, 8:59pm UTC](https://forum.inductiveautomation.com/t/still-no-tag-description-in-browse-tree/11304 "2016-03-02T20:59:18Z")
Is there still no method of getting tag documetation information to be displayed in the Tag Browse Tree instead of the tag name? Not really a big deal if you are making tags from scratch, but after importing a bunch from… --- ## [Power Table - set locale](https://forum.inductiveautomation.com/t/power-table-set-locale/11303)
**Author:** [@cristihcd](https://forum.inductiveautomation.com/u/cristihcd)\ **Replies:** 0\ **Last updated:** [March 2, 2016, 8:50pm UTC](https://forum.inductiveautomation.com/t/power-table-set-locale/11303 "2016-03-02T20:50:30Z")
Hi, We have a project for which we use two locales (translations): English and Romanian In Romanian, the decimal separator is comma (1.234,10). Our user's keyboards are set to English, so entering a dot on the number… --- ## [Active alarms report](https://forum.inductiveautomation.com/t/active-alarms-report/11286)
**Author:** [@Jado58](https://forum.inductiveautomation.com/u/Jado58)\ **Replies:** 2\ **Last updated:** [March 2, 2016, 7:46pm UTC](https://forum.inductiveautomation.com/t/active-alarms-report/11286 "2016-03-02T19:46:37Z")
Hi, I'd like to generate a report for the active alarms to be emailed at the end of the day, what would be a good way to approach this task? Thanks --- ## [Role Retreival failed](https://forum.inductiveautomation.com/t/role-retreival-failed/11301)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 0\ **Last updated:** [March 2, 2016, 4:27pm UTC](https://forum.inductiveautomation.com/t/role-retreival-failed/11301 "2016-03-02T16:27:44Z")
after upgrading from 7.74 yo 7.8.1 when in the designer and you try to edit a script on any component four error boxes pop up with the below message. What I found was our default security profile for the project does no… --- ## [Expression break line](https://forum.inductiveautomation.com/t/expression-break-line/11296)
**Author:** [@Ddugas](https://forum.inductiveautomation.com/u/Ddugas)\ **Replies:** 5\ **Last updated:** [March 2, 2016, 3:47pm UTC](https://forum.inductiveautomation.com/t/expression-break-line/11296 "2016-03-02T15:47:34Z")
Hi , i am trying to make a kind of machine diagnosis using studio5000 and ignition… so if the machine is at step 1 and need two more sensor to be ON to go at step 2 id like my diagnosis to write down these 2 sensor with… --- ## [Template repeater auto scroll](https://forum.inductiveautomation.com/t/template-repeater-auto-scroll/11244)
**Author:** [@Ignaciof](https://forum.inductiveautomation.com/u/Ignaciof)\ **Replies:** 3\ **Last updated:** [March 2, 2016, 2:51pm UTC](https://forum.inductiveautomation.com/t/template-repeater-auto-scroll/11244 "2016-03-02T14:51:01Z")
Hi! I’m trying to make a window with some elements scrolling constantly. In this way, I found that if I use the template repeater with this configuration: It make a continuous vertical scroll. But if I make the same … --- ## [Reports and Datasets](https://forum.inductiveautomation.com/t/reports-and-datasets/11294)
**Author:** [@Caleb\_Bohon](https://forum.inductiveautomation.com/u/Caleb_Bohon)\ **Replies:** 4\ **Last updated:** [March 2, 2016, 12:27pm UTC](https://forum.inductiveautomation.com/t/reports-and-datasets/11294 "2016-03-02T12:27:54Z")
I am creating a report that is going to use a dataset for a multipage table. I want the user to click a button on the page with a report viewer to have the client run a script that creates the dataset then runs the rep… --- ## [Scan Classes Organization](https://forum.inductiveautomation.com/t/scan-classes-organization/11225)
**Author:** [@Ignaciof](https://forum.inductiveautomation.com/u/Ignaciof)\ **Replies:** 5\ **Last updated:** [March 2, 2016, 11:12am UTC](https://forum.inductiveautomation.com/t/scan-classes-organization/11225 "2016-03-02T11:12:16Z")
Hola! I have a question about Tags organization in Scan Classes, is better englobe all the tags in two or three Scan Classes or make smaller groups? In my case, I have a big default Scan Classe and we realized that is… --- ## [Keyboard and login](https://forum.inductiveautomation.com/t/keyboard-and-login/11295)
**Author:** [@boster281](https://forum.inductiveautomation.com/u/boster281)\ **Replies:** 3\ **Last updated:** [March 2, 2016, 8:44am UTC](https://forum.inductiveautomation.com/t/keyboard-and-login/11295 "2016-03-02T08:44:57Z")
Is there anyway to have the built in keyboard and login popups larger? [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1462) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1464)