# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1445 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1446 --- ## [Dataset Row and Column count](https://forum.inductiveautomation.com/t/dataset-row-and-column-count/12237)
**Author:** [@Mr.K001](https://forum.inductiveautomation.com/u/Mr.K001)\ **Replies:** 3\ **Last updated:** [October 14, 2016, 8:28pm UTC](https://forum.inductiveautomation.com/t/dataset-row-and-column-count/12237 "2016-10-14T20:28:42Z")
Hi everyone, I was wondering if there is a way to check on the number of rows of a dataset using Expression language. I know you can do it with scripting. I check order numbers I get from PLC with a 3 tables to come up w… --- ## [OPC-UA sever faults after gateway backup restore](https://forum.inductiveautomation.com/t/opc-ua-sever-faults-after-gateway-backup-restore/12236)
**Author:** [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Replies:** 2\ **Last updated:** [October 14, 2016, 5:08pm UTC](https://forum.inductiveautomation.com/t/opc-ua-sever-faults-after-gateway-backup-restore/12236 "2016-10-14T17:08:52Z")
V7.7 install I have seen this before, where the default OPC-UA server faults after restoring a gateway backup. I recall seeing this in one of the workshops at ICC 2015 and Travis had to do some Ninja behind the scenes … --- ## [Production module upgrade on postgres has invalid SQL](https://forum.inductiveautomation.com/t/production-module-upgrade-on-postgres-has-invalid-sql/12234)
**Author:** [@gekkoman](https://forum.inductiveautomation.com/u/gekkoman)\ **Replies:** 0\ **Last updated:** [October 13, 2016, 10:36pm UTC](https://forum.inductiveautomation.com/t/production-module-upgrade-on-postgres-has-invalid-sql/12234 "2016-10-13T22:36:13Z")
When upgrading a production model from 7.7 to 7.9 it wishes to alter types of some columns. These are missing the TYPE keyword on the column name and this prevents production model from validating. In my case the cor… --- ## [Increment a tag from pulse counts](https://forum.inductiveautomation.com/t/increment-a-tag-from-pulse-counts/12231)
**Author:** [@BG3009](https://forum.inductiveautomation.com/u/BG3009)\ **Replies:** 1\ **Last updated:** [October 13, 2016, 12:57pm UTC](https://forum.inductiveautomation.com/t/increment-a-tag-from-pulse-counts/12231 "2016-10-13T12:57:54Z")
I've got a meter that counts from 1 to 10 then starts all over again; how can I use this pulse count to increment a tag? I am thinking of using a transaction group to increment a value each time I get a pulse. But is thi… --- ## [How to get On call Roster from a username?](https://forum.inductiveautomation.com/t/how-to-get-on-call-roster-from-a-username/12221)
**Author:** [@MoisesZV](https://forum.inductiveautomation.com/u/MoisesZV)\ **Replies:** 5\ **Last updated:** [October 12, 2016, 3:27pm UTC](https://forum.inductiveautomation.com/t/how-to-get-on-call-roster-from-a-username/12221 "2016-10-12T15:27:59Z")
Hi, given a Username I want to get the on call roster it belongs, This is for send it to an alarm pipeline. It is possible to do this? --- ## [WHERE IN clause](https://forum.inductiveautomation.com/t/where-in-clause/12215)
**Author:** [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Replies:** 3\ **Last updated:** [October 12, 2016, 3:12pm UTC](https://forum.inductiveautomation.com/t/where-in-clause/12215 "2016-10-12T15:12:17Z")
Anyone use this before where the contents of IN are dynamic? I need to create a query where the contents of the WHERE IN (x,y,z) are the result of a another query. Only way I can figure out to do it is in scripting, wher… --- ## [Accessing components from script modules or other screens](https://forum.inductiveautomation.com/t/accessing-components-from-script-modules-or-other-screens/3229)
**Author:** [@alex.ferrell](https://forum.inductiveautomation.com/u/alex.ferrell)\ **Replies:** 5\ **Last updated:** [October 12, 2016, 11:00am UTC](https://forum.inductiveautomation.com/t/accessing-components-from-script-modules-or-other-screens/3229 "2016-10-12T11:00:00Z")
I might be missing something obvious but I can't figure out how to get a Component (in this case a table) into a script module. I got it working by running a query to SQL to get the data, but the data I need for the scri… --- ## [system.serial.openSerialPort() problem](https://forum.inductiveautomation.com/t/system-serial-openserialport-problem/12217)
**Author:** [@Serhii](https://forum.inductiveautomation.com/u/Serhii)\ **Replies:** 3\ **Last updated:** [October 11, 2016, 3:44pm UTC](https://forum.inductiveautomation.com/t/system-serial-openserialport-problem/12217 "2016-10-11T15:44:57Z")
Hi! Have the same problem again. inductiveautomation.com/forum/v ... 72&t=11487 Ignition 7.6.7, x32 Serial Client Module version 1.6.7 (b2014082615) --- ## [Updating tags in Ignition indirectly!](https://forum.inductiveautomation.com/t/updating-tags-in-ignition-indirectly/12223)
**Author:** [@sudhamoorthy](https://forum.inductiveautomation.com/u/sudhamoorthy)\ **Replies:** 2\ **Last updated:** [October 11, 2016, 1:16pm UTC](https://forum.inductiveautomation.com/t/updating-tags-in-ignition-indirectly/12223 "2016-10-11T13:16:58Z")
Hi, We have an ignition project, which pulls the tag data from devices and loads them into SQL server in periodical intervals. And we have a .net application, which pulls the data from the SQL server and displays data … --- ## [How to get the legent to display properly in Bar Chart?](https://forum.inductiveautomation.com/t/how-to-get-the-legent-to-display-properly-in-bar-chart/12222)
**Author:** [@vanko26](https://forum.inductiveautomation.com/u/vanko26)\ **Replies:** 0\ **Last updated:** [October 11, 2016, 10:13am UTC](https://forum.inductiveautomation.com/t/how-to-get-the-legent-to-display-properly-in-bar-chart/12222 "2016-10-11T10:13:12Z")
Hi all! I am experiencing some issues with trying to populate Bar chart with data from 2 SQL tables. First table is being populated by a transaction group every time a machine stops with t\_stamp, name and error code. … --- ## [Horizontal Scroll Bar](https://forum.inductiveautomation.com/t/horizontal-scroll-bar/12212)
**Author:** [@EMC1](https://forum.inductiveautomation.com/u/EMC1)\ **Replies:** 2\ **Last updated:** [October 11, 2016, 8:00am UTC](https://forum.inductiveautomation.com/t/horizontal-scroll-bar/12212 "2016-10-11T08:00:48Z")
I have updated a report that displays data for the last 7 days in a table to allow the user to choose start and end dates as they want to be able to choose a 30 day period. Now my table is not display 30 days data correc… --- ## [Javaws error - Win10](https://forum.inductiveautomation.com/t/javaws-error-win10/12219)
**Author:** [@dmoon](https://forum.inductiveautomation.com/u/dmoon)\ **Replies:** 1\ **Last updated:** [October 10, 2016, 3:29pm UTC](https://forum.inductiveautomation.com/t/javaws-error-win10/12219 "2016-10-10T15:29:43Z")
I only noticed this on a Win10 Surface Pro 4 (fully updated, Java 8u73 to 8u101), but through Firefox, IE, and Chrome, was unable to launch Designer with javaws. Client launchers worked fine. After spending way too lon… --- ## [OPC Subcription Settings](https://forum.inductiveautomation.com/t/opc-subcription-settings/10876)
**Author:** [@DNP3](https://forum.inductiveautomation.com/u/DNP3)\ **Replies:** 6\ **Last updated:** [October 7, 2016, 2:17pm UTC](https://forum.inductiveautomation.com/t/opc-subcription-settings/10876 "2016-10-07T14:17:43Z")
Does Ignitions OPC UA client support more advanced subscription/monitoring settings such as: Queue Size Discard oldest objects Data change filters Data change triggers options (Status/Value/Timestamp) Deadband Type:… --- ## [Problem with Linear Scale and line styles](https://forum.inductiveautomation.com/t/problem-with-linear-scale-and-line-styles/12211)
**Author:** [@Esn](https://forum.inductiveautomation.com/u/Esn)\ **Replies:** 1\ **Last updated:** [October 7, 2016, 12:10pm UTC](https://forum.inductiveautomation.com/t/problem-with-linear-scale-and-line-styles/12211 "2016-10-07T12:10:33Z")
Hi, I have used a Linear Scale component to display some dynamic values. When the values are close to equal they overlap which makes the text unreadable. http://imgur.com/6zTv2vc The line styles in the dataset of t… --- ## [Best way to connect to Omron CJ PLC?](https://forum.inductiveautomation.com/t/best-way-to-connect-to-omron-cj-plc/12209)
**Author:** [@xasga](https://forum.inductiveautomation.com/u/xasga)\ **Replies:** 4\ **Last updated:** [October 7, 2016, 11:31am UTC](https://forum.inductiveautomation.com/t/best-way-to-connect-to-omron-cj-plc/12209 "2016-10-07T11:31:24Z")
Our evaluation of Ignition has progressed to the point that we are ready to use it on a small job for a customer. We need to read and write to an Omron CJ series PLC. I saw some posts from late last year indicating t… --- ## [Change project .jnlp icon](https://forum.inductiveautomation.com/t/change-project-jnlp-icon/12201)
**Author:** [@rcorkern](https://forum.inductiveautomation.com/u/rcorkern)\ **Replies:** 2\ **Last updated:** [October 7, 2016, 12:15am UTC](https://forum.inductiveautomation.com/t/change-project-jnlp-icon/12201 "2016-10-07T00:15:44Z")
Is it possible to change the icon of the .jnlp file downloaded for a project? I see how to change the default icon for all .jnlp files but I'm looking to only change it on the project file that is downloaded from the ga… --- ## [Update Table on Different Window](https://forum.inductiveautomation.com/t/update-table-on-different-window/12207)
**Author:** [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Replies:** 3\ **Last updated:** [October 6, 2016, 7:07pm UTC](https://forum.inductiveautomation.com/t/update-table-on-different-window/12207 "2016-10-06T19:07:59Z")
How do I update a table component that is on a different window? Typically I use this when table is on same window: # refresh running status table in Action Container table = event.source.parent.parent.getComponent(… --- ## [Simple data entry form using WebDev module](https://forum.inductiveautomation.com/t/simple-data-entry-form-using-webdev-module/12109)
**Author:** [@Pcervantes](https://forum.inductiveautomation.com/u/Pcervantes)\ **Replies:** 2\ **Last updated:** [October 5, 2016, 8:11pm UTC](https://forum.inductiveautomation.com/t/simple-data-entry-form-using-webdev-module/12109 "2016-10-05T20:11:09Z")
I have a need to setup data entry form to be used on a Ipod based scanner. I can't use the mobile because it can't use a bar code scanner as an input. So I setup a HTML form page to use and it has four input fields and a… --- ## [Solved - Alarm Journal Event truncated error](https://forum.inductiveautomation.com/t/solved-alarm-journal-event-truncated-error/12200)
**Author:** [@Kraenbring](https://forum.inductiveautomation.com/u/Kraenbring)\ **Replies:** 0\ **Last updated:** [October 5, 2016, 2:30pm UTC](https://forum.inductiveautomation.com/t/solved-alarm-journal-event-truncated-error/12200 "2016-10-05T14:30:43Z")
Just throwing this out there for anyone else with this problem. If you see records stuck in your Store/Forward for the Alarm Journal Event saying "String or binary data would be truncated.", you need to change a database… --- ## [Historical and recent data trend - storage and efficiency -](https://forum.inductiveautomation.com/t/historical-and-recent-data-trend-storage-and-efficiency/12190)
**Author:** [@JLTProgramming](https://forum.inductiveautomation.com/u/JLTProgramming)\ **Replies:** 4\ **Last updated:** [October 3, 2016, 10:13pm UTC](https://forum.inductiveautomation.com/t/historical-and-recent-data-trend-storage-and-efficiency/12190 "2016-10-03T22:13:16Z")
First post to the forum. Hello everyone. Thanks in advance for any advice, and sorry if this is a noob question. This pertains to optimizing efficiency for storage and review of a number of tags. Here is the situatio… --- ## [Easy chart get Gateway Time](https://forum.inductiveautomation.com/t/easy-chart-get-gateway-time/12113)
**Author:** [@MoisesZV](https://forum.inductiveautomation.com/u/MoisesZV)\ **Replies:** 3\ **Last updated:** [October 3, 2016, 2:04pm UTC](https://forum.inductiveautomation.com/t/easy-chart-get-gateway-time/12113 "2016-10-03T14:04:22Z")
Hi, I have a problem design with Ignition. 1.- I have a computer where Ignition is installed, I put an Easy chart with some tags on real time and saved my proyect. 2.- I have a client connected to my gateway compute… --- ## [Scripting is turned off, how did i do it](https://forum.inductiveautomation.com/t/scripting-is-turned-off-how-did-i-do-it/12142)
**Author:** [@waker1der](https://forum.inductiveautomation.com/u/waker1der)\ **Replies:** 4\ **Last updated:** [October 3, 2016, 9:27am UTC](https://forum.inductiveautomation.com/t/scripting-is-turned-off-how-did-i-do-it/12142 "2016-10-03T09:27:34Z")
Help, I have managed to turn scripting off in all my projects. I only use basic scripts, no gateway or client scripts something like if currentValue.value == x: system.tag.write("tagname", 100) but none of… --- ## [Getting a Chart to plot all points in a large dataset](https://forum.inductiveautomation.com/t/getting-a-chart-to-plot-all-points-in-a-large-dataset/12193)
**Author:** [@srideep](https://forum.inductiveautomation.com/u/srideep)\ **Replies:** 2\ **Last updated:** [October 3, 2016, 8:59am UTC](https://forum.inductiveautomation.com/t/getting-a-chart-to-plot-all-points-in-a-large-dataset/12193 "2016-10-03T08:59:00Z")
I'm trying to plot a large dataset (~1000 points) in a chart, which works, however not all the points appear in the chart. As I'm aware, the chart tries to draw a reasonable representation of the data without plotting ea… --- ## [Query to "Get All Templates"?](https://forum.inductiveautomation.com/t/query-to-get-all-templates/12168)
**Author:** [@mpeasley](https://forum.inductiveautomation.com/u/mpeasley)\ **Replies:** 1\ **Last updated:** [September 30, 2016, 11:50pm UTC](https://forum.inductiveautomation.com/t/query-to-get-all-templates/12168 "2016-09-30T23:50:51Z")
Is there a way to query ignition and get the template names in the project? Something similar to getting the window names. --- ## [What is the effect of changing the Include Schema in Table](https://forum.inductiveautomation.com/t/what-is-the-effect-of-changing-the-include-schema-in-table/12137)
**Author:** [@vec](https://forum.inductiveautomation.com/u/vec)\ **Replies:** 1\ **Last updated:** [September 30, 2016, 11:34pm UTC](https://forum.inductiveautomation.com/t/what-is-the-effect-of-changing-the-include-schema-in-table/12137 "2016-09-30T23:34:50Z")
I am adding a project to an existing system, I would like to segregate the tables for the new project from the existing project in the system database. My thought was to create an new schema in the database and change t… --- ## [Export strings in excel in real time without transaction](https://forum.inductiveautomation.com/t/export-strings-in-excel-in-real-time-without-transaction/12153)
**Author:** [@P11](https://forum.inductiveautomation.com/u/P11)\ **Replies:** 1\ **Last updated:** [September 30, 2016, 11:28pm UTC](https://forum.inductiveautomation.com/t/export-strings-in-excel-in-real-time-without-transaction/12153 "2016-09-30T23:28:00Z")
What can I do to export strings in excel in real time without transaction groups ? --- ## [Script window fails to open after adding dynamic property](https://forum.inductiveautomation.com/t/script-window-fails-to-open-after-adding-dynamic-property/12189)
**Author:** [@fledder](https://forum.inductiveautomation.com/u/fledder)\ **Replies:** 2\ **Last updated:** [September 30, 2016, 1:20am UTC](https://forum.inductiveautomation.com/t/script-window-fails-to-open-after-adding-dynamic-property/12189 "2016-09-30T01:20:18Z")
I am trying to add a dynamic property to an object. My code looks like this on a button referencing a paintable canvas: canvas = event.source.parent.getComponent('Paintable Canvas') props = canvas.getDynamicProps() pr… --- ## [Syntax error silently accepted. Script Not Executed](https://forum.inductiveautomation.com/t/syntax-error-silently-accepted-script-not-executed/12187)
**Author:** [@xasga](https://forum.inductiveautomation.com/u/xasga)\ **Replies:** 0\ **Last updated:** [September 29, 2016, 3:31pm UTC](https://forum.inductiveautomation.com/t/syntax-error-silently-accepted-script-not-executed/12187 "2016-09-29T15:31:08Z")
In a tag value change script, I accidentally left the colon off the end of a while statement. There was no visual indication of the error in the text of the script. (Later I saw that there is a thin red bar on the righ… --- ## [UDT definition: Lockable? Reusable?](https://forum.inductiveautomation.com/t/udt-definition-lockable-reusable/12186)
**Author:** [@xasga](https://forum.inductiveautomation.com/u/xasga)\ **Replies:** 2\ **Last updated:** [September 29, 2016, 3:13pm UTC](https://forum.inductiveautomation.com/t/udt-definition-lockable-reusable/12186 "2016-09-29T15:13:31Z")
Can the definition of a UDT be locked, so that it cannot be changed or deleted? Can the definition of a UDT be exported, so that it can be imported for use on a new application? I looked for the answers in the user m… --- ## [Modbus TCP with TM221 Schneider - Read and write error](https://forum.inductiveautomation.com/t/modbus-tcp-with-tm221-schneider-read-and-write-error/12174)
**Author:** [@altar](https://forum.inductiveautomation.com/u/altar)\ **Replies:** 2\ **Last updated:** [September 29, 2016, 8:16am UTC](https://forum.inductiveautomation.com/t/modbus-tcp-with-tm221-schneider-read-and-write-error/12174 "2016-09-29T08:16:05Z")
Hi, I use a TM221 PLC Modbus TCP. I can not read or write to an address. The connection is OK but an error in the log. ReadHoldingRegistersRequest Uncaught throwable handling response. key = 2 req = \[\], rsp = \[0… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1444) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1446)