# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1662 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1663 --- ## [SQL parts per hour, min, dynamic](https://forum.inductiveautomation.com/t/sql-parts-per-hour-min-dynamic/16517)
**Author:** [@juang](https://forum.inductiveautomation.com/u/juang)\ **Replies:** 14\ **Last updated:** [January 12, 2018, 1:41pm UTC](https://forum.inductiveautomation.com/t/sql-parts-per-hour-min-dynamic/16517 "2018-01-12T13:41:44Z")
Hello, I need to write a a query to report cases per hour, or pallets per hour. the way i have it, it is. i have Runlog table, in that table i have create an entry every time a pallet it is creater with the runid, pal… --- ## [Alarm escalation alternatives](https://forum.inductiveautomation.com/t/alarm-escalation-alternatives/16309)
**Author:** [@richardNZ15](https://forum.inductiveautomation.com/u/richardNZ15)\ **Replies:** 4\ **Last updated:** [January 12, 2018, 11:47am UTC](https://forum.inductiveautomation.com/t/alarm-escalation-alternatives/16309 "2018-01-12T11:47:09Z")
Hi, My client would like Alarms to escalate if they are not acknowledged or cleared for some amount of time. They were hoping to be able to change the alarm priority in realtime, which i've discovered we can't do (alar… --- ## [Edit UDT Type (not instance) through script](https://forum.inductiveautomation.com/t/edit-udt-type-not-instance-through-script/16572)
**Author:** [@Esn](https://forum.inductiveautomation.com/u/Esn)\ **Replies:** 1\ **Last updated:** [January 12, 2018, 11:01am UTC](https://forum.inductiveautomation.com/t/edit-udt-type-not-instance-through-script/16572 "2018-01-12T11:01:30Z")
Hi, I need to add a lot of tags to different UDT Types. I can easily create the tags using the system.tag.addTag() function in the script console, but it seems like I cannot add tags to an UDT Type using script. Am I d… --- ## [Report - Retreive Historical Tag Values Greater than X](https://forum.inductiveautomation.com/t/report-retreive-historical-tag-values-greater-than-x/16566)
**Author:** [@mlatour](https://forum.inductiveautomation.com/u/mlatour)\ **Replies:** 0\ **Last updated:** [January 11, 2018, 8:38pm UTC](https://forum.inductiveautomation.com/t/report-retreive-historical-tag-values-greater-than-x/16566 "2018-01-11T20:38:47Z")
I was looking to see if it's possible to use the "Tag Historian Query" in the report builder for a tag, but only retrieve values for the tag that are greater than X. We're trying to get the average flow rate over a shif… --- ## [Set IP Camera Viewer Video Mode by Scripting](https://forum.inductiveautomation.com/t/set-ip-camera-viewer-video-mode-by-scripting/16549)
**Author:** [@salbrechtsen](https://forum.inductiveautomation.com/u/salbrechtsen)\ **Replies:** 6\ **Last updated:** [January 11, 2018, 7:27pm UTC](https://forum.inductiveautomation.com/t/set-ip-camera-viewer-video-mode-by-scripting/16549 "2018-01-11T19:27:26Z")
Is there a way to set the IP Camera Viewer Video Mode property by scripting? I have noticed the property is an int datatype. I have tried setting it to 0 and 1 and can't seem to get it to change. --- ## [Julian Date conversion](https://forum.inductiveautomation.com/t/julian-date-conversion/16562)
**Author:** [@k.jain](https://forum.inductiveautomation.com/u/k.jain)\ **Replies:** 7\ **Last updated:** [January 11, 2018, 5:10pm UTC](https://forum.inductiveautomation.com/t/julian-date-conversion/16562 "2018-01-11T17:10:43Z")
Hello, I am trying to store both standard and julian date in mysql database. The query I am using is: INSERT INTO table(StartTime,EndTime,WorkOrder,Shift,trigger,State,JulianDate) VALUES('2018-01-10 19:00:00',null,null,n… --- ## [Jython bin() Not Working](https://forum.inductiveautomation.com/t/jython-bin-not-working/16542)
**Author:** [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Replies:** 8\ **Last updated:** [January 11, 2018, 4:33pm UTC](https://forum.inductiveautomation.com/t/jython-bin-not-working/16542 "2018-01-11T16:33:16Z")
in need to use scripting to do bit manipulation from a DINT I cannot get the jython bin() to work. Is there another version of this in scripting? --- ## [Null Tags and Unknown Quality](https://forum.inductiveautomation.com/t/null-tags-and-unknown-quality/16564)
**Author:** [@stewar2](https://forum.inductiveautomation.com/u/stewar2)\ **Replies:** 0\ **Last updated:** [January 11, 2018, 3:07pm UTC](https://forum.inductiveautomation.com/t/null-tags-and-unknown-quality/16564 "2018-01-11T15:07:54Z")
Hi, I’ve been emailing back and forth with support since Friday but haven’t recieved an email back in a few days so I thought I’d give a shout here to see if anyone could help out. The tags are coming back null with unk… --- ## [Script function execution context](https://forum.inductiveautomation.com/t/script-function-execution-context/16537)
**Author:** [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\ **Replies:** 9\ **Last updated:** [January 11, 2018, 11:25am UTC](https://forum.inductiveautomation.com/t/script-function-execution-context/16537 "2018-01-11T11:25:26Z")
Hi all, is there a way to know which is the execution context of a python script function? Say I have a function in a shared script library: def foo(): pass That function will be called in my project by: 1) a gatew… --- ## [Alarm History Report](https://forum.inductiveautomation.com/t/alarm-history-report/16550)
**Author:** [@jose.granero](https://forum.inductiveautomation.com/u/jose.granero)\ **Replies:** 0\ **Last updated:** [January 10, 2018, 6:08pm UTC](https://forum.inductiveautomation.com/t/alarm-history-report/16550 "2018-01-10T18:08:47Z")
I've created a simple alarm history report which just has a table showing the following fields: Event time Active duration Display path Name Event Value I want this last value to be the one which caused the alarm tr… --- ## [Area / PLC / tags names management](https://forum.inductiveautomation.com/t/area-plc-tags-names-management/15788)
**Author:** [@valet81](https://forum.inductiveautomation.com/u/valet81)\ **Replies:** 3\ **Last updated:** [January 11, 2018, 9:37am UTC](https://forum.inductiveautomation.com/t/area-plc-tags-names-management/15788 "2018-01-11T09:37:04Z")
Hi all, I've used Ignition for a couple of years with easy and standard configurations (like a couple of PLCs on the same machine). I'm now working on a big project with different plants over the world, various sub-d… --- ## [Spectre and Meltdown](https://forum.inductiveautomation.com/t/spectre-and-meltdown/16546)
**Author:** [@ClayBuysse](https://forum.inductiveautomation.com/u/ClayBuysse)\ **Replies:** 4\ **Last updated:** [January 11, 2018, 12:38am UTC](https://forum.inductiveautomation.com/t/spectre-and-meltdown/16546 "2018-01-11T00:38:24Z")
Windows recently issued a few updates related to the Spectre and Meltdown bugs. These updates have caused some unforeseen problems with some of my other software and I'm wondering if anyone out there has seen any Igniti… --- ## [Micrologix 1400 TCP and/or UDP Ports Used](https://forum.inductiveautomation.com/t/micrologix-1400-tcp-and-or-udp-ports-used/16554)
**Author:** [@dturner](https://forum.inductiveautomation.com/u/dturner)\ **Replies:** 2\ **Last updated:** [January 10, 2018, 9:25pm UTC](https://forum.inductiveautomation.com/t/micrologix-1400-tcp-and-or-udp-ports-used/16554 "2018-01-10T21:25:52Z")
What ports, UDP and TCP, does the Allen-Bradley Micrologix 1400 driver use to communicate to a Micrologix 1400? I need to configure a router to allow traffic from the PLC to the Ignition Gateway. --- ## [Custom where clause in Transaction Group](https://forum.inductiveautomation.com/t/custom-where-clause-in-transaction-group/16548)
**Author:** [@Peter.Dmitriev](https://forum.inductiveautomation.com/u/Peter.Dmitriev)\ **Replies:** 2\ **Last updated:** [January 10, 2018, 6:14pm UTC](https://forum.inductiveautomation.com/t/custom-where-clause-in-transaction-group/16548 "2018-01-10T18:14:44Z")
Hello, I’m running into issues with AND statement in custom WHERE clause in standard transaction group. Single condition WHERE clause works fine. This works: This doesn’t work: Can anybody advise on what am I … --- ## [Modbus On Deif Delomatic DM400 Gas](https://forum.inductiveautomation.com/t/modbus-on-deif-delomatic-dm400-gas/16530)
**Author:** [@Mike\_Hodgson](https://forum.inductiveautomation.com/u/Mike_Hodgson)\ **Replies:** 2\ **Last updated:** [January 10, 2018, 5:05pm UTC](https://forum.inductiveautomation.com/t/modbus-on-deif-delomatic-dm400-gas/16530 "2018-01-10T17:05:45Z")
Hi, I've a couple of DM400 Gas engine controllers on a site that the client needs data collected from. The Modbus is on port 30000 which Ignition says has a connection, but trying to read the holding registers 0-880 do… --- ## [Expression Tag Type Conversion Error](https://forum.inductiveautomation.com/t/expression-tag-type-conversion-error/16547)
**Author:** [@stewar2](https://forum.inductiveautomation.com/u/stewar2)\ **Replies:** 0\ **Last updated:** [January 10, 2018, 4:56pm UTC](https://forum.inductiveautomation.com/t/expression-tag-type-conversion-error/16547 "2018-01-10T16:56:49Z")
When converting from a Int4 in a expression tag, the Ignition website suggests to use Float4. So I convert my Int4 data point to float with an expression tag, and then evaluate the newly converted tag with the expression… --- ## [Hourglass or other visual indication to indicate history retrieval in progress?](https://forum.inductiveautomation.com/t/hourglass-or-other-visual-indication-to-indicate-history-retrieval-in-progress/16540)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 2\ **Last updated:** [January 10, 2018, 4:12pm UTC](https://forum.inductiveautomation.com/t/hourglass-or-other-visual-indication-to-indicate-history-retrieval-in-progress/16540 "2018-01-10T16:12:57Z")
Is there any simple way to indicate that the historian is updating when, for example, I change the selected date range for a table or chart? e.g., show the hourglass cursor icon or similar. There are some five to seven… --- ## [More graph types -- spc charts](https://forum.inductiveautomation.com/t/more-graph-types-spc-charts/94)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 16\ **Last updated:** [January 10, 2018, 4:00pm UTC](https://forum.inductiveautomation.com/t/more-graph-types-spc-charts/94 "2018-01-10T16:00:51Z")
Hi gang: Any chance of getting some spc charts in factory pmi. Histograms, Pareto charts, x-bar and range charts, individuals and moving averages, ewma, cusum, etc.? Regards, D. Lewis --- ## [Create SQL Database Table via Python](https://forum.inductiveautomation.com/t/create-sql-database-table-via-python/16532)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 4\ **Last updated:** [January 10, 2018, 8:28am UTC](https://forum.inductiveautomation.com/t/create-sql-database-table-via-python/16532 "2018-01-10T08:28:26Z")
Hi, Is it possible to create a database table in the project's default SQL provider (e.g. MySQL) in Ignition? (Python?) I have tried to use this: SQLCreate = "CREATE TABLE cfgTrends (Area NVARCHAR(25) NOT NULL)" … --- ## ["MQTT+FTP" to build robust IIoT projects on Ignition:](https://forum.inductiveautomation.com/t/mqtt-ftp-to-build-robust-iiot-projects-on-ignition/11332)
**Author:** [@R.Alamsha](https://forum.inductiveautomation.com/u/R.Alamsha)\ **Replies:** 0\ **Last updated:** [March 9, 2016, 3:32am UTC](https://forum.inductiveautomation.com/t/mqtt-ftp-to-build-robust-iiot-projects-on-ignition/11332 "2016-03-09T03:32:20Z")
As Ignition recommends MQTT as the "Protocol for IIoT and Smart City" projects to manage 1000's of geographically distributed RTUs, i thought it deserves deeper discussion and hence i am initiating this topic. Remote R… --- ## [Disk Space Calculation](https://forum.inductiveautomation.com/t/disk-space-calculation/4972)
**Author:** [@rfbuehler](https://forum.inductiveautomation.com/u/rfbuehler)\ **Replies:** 4\ **Last updated:** [January 9, 2018, 7:53pm UTC](https://forum.inductiveautomation.com/t/disk-space-calculation/4972 "2018-01-09T19:53:50Z")
Does anyone have a formula that will allow me to calculate the ammount of disk space required to historical archives? --- ## [Programatically Access Project Browser](https://forum.inductiveautomation.com/t/programatically-access-project-browser/16522)
**Author:** [@salbrechtsen](https://forum.inductiveautomation.com/u/salbrechtsen)\ **Replies:** 2\ **Last updated:** [January 9, 2018, 6:13pm UTC](https://forum.inductiveautomation.com/t/programatically-access-project-browser/16522 "2018-01-09T18:13:58Z")
This might be a long shot, but is there a way to programmatically (through scripting) read folders in the project scope? I am particularly interested in reading/iterating over the folder structure in Project templates fo… --- ## [Connecting to non PLC devices](https://forum.inductiveautomation.com/t/connecting-to-non-plc-devices/16519)
**Author:** [@shwethag](https://forum.inductiveautomation.com/u/shwethag)\ **Replies:** 2\ **Last updated:** [January 9, 2018, 4:14pm UTC](https://forum.inductiveautomation.com/t/connecting-to-non-plc-devices/16519 "2018-01-09T16:14:14Z")
Hello All: I am a new user of ignition software. We develop control systems for pharmaceutical industries. We are currently working on a project which includes PLC, HMI and other Modbus TCP/IP or RS485 device. I know we … --- ## [SQL Query Help - Bulk Insert](https://forum.inductiveautomation.com/t/sql-query-help-bulk-insert/16527)
**Author:** [@jreynolds](https://forum.inductiveautomation.com/u/jreynolds)\ **Replies:** 2\ **Last updated:** [January 9, 2018, 3:59pm UTC](https://forum.inductiveautomation.com/t/sql-query-help-bulk-insert/16527 "2018-01-09T15:59:42Z")
I'm getting a syntax error when I run the following query, from a button. Query: getFrom=r'\\\\wtz-svr-fs-01\\FileShare\\Wentzville\\SeqPublic\\WEN-201 LOC\\Container Management System\\MARS\_Import\\TVS Updated CSV\_Fixed.c… --- ## [VisionWindowOpened Script fires on designer update](https://forum.inductiveautomation.com/t/visionwindowopened-script-fires-on-designer-update/14048)
**Author:** [@lporath](https://forum.inductiveautomation.com/u/lporath)\ **Replies:** 8\ **Last updated:** [January 9, 2018, 2:32pm UTC](https://forum.inductiveautomation.com/t/visionwindowopened-script-fires-on-designer-update/14048 "2018-01-09T14:32:32Z")
Every time I push a designer update to my clients the VisionWindowOpened Script fires causing problems with my application. Is there a way to stop that script from running after an update or an update flag I could use t… --- ## [Client permissions](https://forum.inductiveautomation.com/t/client-permissions/16509)
**Author:** [@Claus\_Nielsen](https://forum.inductiveautomation.com/u/Claus_Nielsen)\ **Replies:** 9\ **Last updated:** [January 9, 2018, 2:23pm UTC](https://forum.inductiveautomation.com/t/client-permissions/16509 "2018-01-09T14:23:12Z")
Hello all, Working on a little project where I need to start a transaction on a database, and up until now I have just used named queries to run SQL commands. Starting a transaction is not possible using named queries … --- ## [ERROR with system](https://forum.inductiveautomation.com/t/error-with-system/15987)
**Author:** [@antoniosantos\_ccb](https://forum.inductiveautomation.com/u/antoniosantos_ccb)\ **Replies:** 4\ **Last updated:** [January 9, 2018, 10:02am UTC](https://forum.inductiveautomation.com/t/error-with-system/15987 "2018-01-09T10:02:14Z")
Please, say why this error? Estou usando system.db.runQuery(). --- ## ["Gateway Comm Mode is not Read/Write" error in clients?](https://forum.inductiveautomation.com/t/gateway-comm-mode-is-not-read-write-error-in-clients/16514)
**Author:** [@jeffkrol](https://forum.inductiveautomation.com/u/jeffkrol)\ **Replies:** 2\ **Last updated:** [January 8, 2018, 10:34pm UTC](https://forum.inductiveautomation.com/t/gateway-comm-mode-is-not-read-write-error-in-clients/16514 "2018-01-08T22:34:11Z")
I have been noticing this problem on a big project of ours. Occasionally users of our client are reporting that sometimes when they click a button/field that executes a write to the PLC, they get an error that says "Gate… --- ## [Can an expression tag be shelved?](https://forum.inductiveautomation.com/t/can-an-expression-tag-be-shelved/16521)
**Author:** [@adolfo.rafael.martin](https://forum.inductiveautomation.com/u/adolfo.rafael.martin)\ **Replies:** 0\ **Last updated:** [January 8, 2018, 8:55pm UTC](https://forum.inductiveautomation.com/t/can-an-expression-tag-be-shelved/16521 "2018-01-08T20:55:58Z")
Hi; Can an expression tag be shelved? --- ## [Get Values from Int Array](https://forum.inductiveautomation.com/t/get-values-from-int-array/16511)
**Author:** [@hassferterst56889](https://forum.inductiveautomation.com/u/hassferterst56889)\ **Replies:** 1\ **Last updated:** [January 8, 2018, 5:20pm UTC](https://forum.inductiveautomation.com/t/get-values-from-int-array/16511 "2018-01-08T17:20:35Z")
Hello is there a way to get the values of a Int array from a Siemens SPS 1515 over the Ignition OPC UA server? We only get the first Value and differented into bits. What should we change to get the Values itself?? … [Previous page](https://forum.inductiveautomation.com/latest.md?page=1661) [Next page](https://forum.inductiveautomation.com/latest.md?page=1663)