# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1266 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1267 --- ## [SQL query to group tanks into one cell](https://forum.inductiveautomation.com/t/sql-query-to-group-tanks-into-one-cell/27499)
**Author:** [@mriederer](https://forum.inductiveautomation.com/u/mriederer)\ **Replies:** 9\ **Last updated:** [August 19, 2019, 11:33pm UTC](https://forum.inductiveautomation.com/t/sql-query-to-group-tanks-into-one-cell/27499 "2019-08-19T23:33:44Z")
I’m fairly new to SQL and would appreciate any help. Sorry if this isn’t really an Ignition thing but I figured someone on here could help out. Say I have a bunch of tanks with different fruit and either fresh or rotten… --- ## [Best Practive Integrator Dev Environment](https://forum.inductiveautomation.com/t/best-practive-integrator-dev-environment/27470)
**Author:** [@kgamble](https://forum.inductiveautomation.com/u/kgamble)\ **Replies:** 8\ **Last updated:** [August 19, 2019, 11:15pm UTC](https://forum.inductiveautomation.com/t/best-practive-integrator-dev-environment/27470 "2019-08-19T23:15:46Z")
I lead a group of engineers in a medium size integration company, working on multiple different ignition projects at once, for different customers, in different environments, on different versions. Currently for local d… --- ## [System.util.execute](https://forum.inductiveautomation.com/t/system-util-execute/10056)
**Author:** [@xion8x8](https://forum.inductiveautomation.com/u/xion8x8)\ **Replies:** 27\ **Last updated:** [August 19, 2019, 10:24pm UTC](https://forum.inductiveautomation.com/t/system-util-execute/10056 "2019-08-19T22:24:33Z")
I wanted to use system.util.execute to run a batch file in my computer. I am able to run the script below on a button actionPerformed event and it runs the batch file system.util.execute(\["C:\\windows\\system32\\cmd.exe",… --- ## [MES Reporting in 7.8](https://forum.inductiveautomation.com/t/mes-reporting-in-7-8/10718)
**Author:** [@jmoniz](https://forum.inductiveautomation.com/u/jmoniz)\ **Replies:** 6\ **Last updated:** [August 19, 2019, 7:13pm UTC](https://forum.inductiveautomation.com/t/mes-reporting-in-7-8/10718 "2019-08-19T19:13:23Z")
Having the report manager in the Gateway now is much welcomed. For those of us that use the MES modules How can we use the Analysis Controllers as a data source for the reports? --- ## [Time Series Chart](https://forum.inductiveautomation.com/t/time-series-chart/27574)
**Author:** [@tbraun](https://forum.inductiveautomation.com/u/tbraun)\ **Replies:** 3\ **Last updated:** [August 19, 2019, 4:53pm UTC](https://forum.inductiveautomation.com/t/time-series-chart/27574 "2019-08-19T16:53:20Z")
Hello, just installed 8.03, super excited about this new Time Series Chart however, I cannot find it. Where is the Time Series Chart in Designer? --- ## [Is there system.opcua.callMethod for 7.9 LTS?](https://forum.inductiveautomation.com/t/is-there-system-opcua-callmethod-for-7-9-lts/27566)
**Author:** [@ecujak](https://forum.inductiveautomation.com/u/ecujak)\ **Replies:** 3\ **Last updated:** [August 19, 2019, 4:14pm UTC](https://forum.inductiveautomation.com/t/is-there-system-opcua-callmethod-for-7-9-lts/27566 "2019-08-19T16:14:08Z")
I see system.opcua.callMethod documented for 8.x but I don’t see this in 7.9 LTS. Will you be adding this to 7.9? Is there an alternative way to execute a call method on OPC-UA device based on an event or button click fo… --- ## [Booleans in DataSet show wrong values in Perspective's table](https://forum.inductiveautomation.com/t/booleans-in-dataset-show-wrong-values-in-perspectives-table/26709)
**Author:** [@openphantom](https://forum.inductiveautomation.com/u/openphantom)\ **Replies:** 3\ **Last updated:** [August 19, 2019, 3:51pm UTC](https://forum.inductiveautomation.com/t/booleans-in-dataset-show-wrong-values-in-perspectives-table/26709 "2019-08-19T15:51:23Z")
Booleans in DataSet show wrong values in Perspective’s table. Ignition Version: 8.0.2 (b2019060511) --- ## [Invoke Notification Pipeline from Script](https://forum.inductiveautomation.com/t/invoke-notification-pipeline-from-script/27535)
**Author:** [@tanuj](https://forum.inductiveautomation.com/u/tanuj)\ **Replies:** 1\ **Last updated:** [August 19, 2019, 3:47pm UTC](https://forum.inductiveautomation.com/t/invoke-notification-pipeline-from-script/27535 "2019-08-19T15:47:12Z")
Our system is currently configured as " Ignition Edge Architecture: Hub-and-Spoke" model, having edge enterprise running at site and Central Ignition server hosted on cloud, The edge enterprise is also configured as a lo… --- ## [How to write expression similar to the TimeEq Function in OsiPI](https://forum.inductiveautomation.com/t/how-to-write-expression-similar-to-the-timeeq-function-in-osipi/27573)
**Author:** [@markerr](https://forum.inductiveautomation.com/u/markerr)\ **Replies:** 0\ **Last updated:** [August 19, 2019, 3:47pm UTC](https://forum.inductiveautomation.com/t/how-to-write-expression-similar-to-the-timeeq-function-in-osipi/27573 "2019-08-19T15:47:11Z")
I am trying to write an expression that gets the time throughout the day when a feeder is both on and the feed rate is above 90%. I have the tags for the speed and on/off already in ignition. I have used a historian func… --- ## [Tag cycling from good/bad quality on counter.acc](https://forum.inductiveautomation.com/t/tag-cycling-from-good-bad-quality-on-counter-acc/27347)
**Author:** [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Replies:** 2\ **Last updated:** [August 19, 2019, 3:28pm UTC](https://forum.inductiveautomation.com/t/tag-cycling-from-good-bad-quality-on-counter-acc/27347 "2019-08-19T15:28:03Z")
Using v7.9.12, looking at a counter tag acc value CpLX v30, the tag quality would cycle between good and bad. I didn’t have this issue on 7.9.10. I created a DINT, then moved the ACC into this new tag then had Ignition… --- ## [\[bug-11240\]sendRequestAsync](https://forum.inductiveautomation.com/t/bug-11240-sendrequestasync/17754)
**Author:** [@cmisztur2](https://forum.inductiveautomation.com/u/cmisztur2)\ **Replies:** 10\ **Last updated:** [August 19, 2019, 3:09pm UTC](https://forum.inductiveautomation.com/t/bug-11240-sendrequestasync/17754 "2019-08-19T15:09:49Z")
I noticed that the behavior of sendRequestAsync blocks the UI and the callback fires twice. Is this expected? system.util.sendRequestAsync(project='p', messageHandler='mh', payload={'Id':1}, onSuccess=callback) --- ## [2 Tier Navigation with Client Event Script](https://forum.inductiveautomation.com/t/2-tier-navigation-with-client-event-script/27563)
**Author:** [@lewist](https://forum.inductiveautomation.com/u/lewist)\ **Replies:** 4\ **Last updated:** [August 19, 2019, 3:05pm UTC](https://forum.inductiveautomation.com/t/2-tier-navigation-with-client-event-script/27563 "2019-08-19T15:05:38Z")
I have a navigation window that I have created as shown below. I am trying to use a Client Event Script to launch the appropriate window. Shown below is the screenshots of the client event script. The error … --- ## [SLC 505 tags bad quality when not viewed](https://forum.inductiveautomation.com/t/slc-505-tags-bad-quality-when-not-viewed/27530)
**Author:** [@kyle.lasher](https://forum.inductiveautomation.com/u/kyle.lasher)\ **Replies:** 2\ **Last updated:** [August 19, 2019, 11:56am UTC](https://forum.inductiveautomation.com/t/slc-505-tags-bad-quality-when-not-viewed/27530 "2019-08-19T11:56:15Z")
We have tags being logged via tag historian whose data integrity is 32 (waiting) when they are not actively present on an active screen. When I open a screen with a control bound to the tag or I navigate to the tag in my… --- ## [Ignition connection to Matrikon UA Tunneller](https://forum.inductiveautomation.com/t/ignition-connection-to-matrikon-ua-tunneller/26653)
**Author:** [@alireza.dehghani](https://forum.inductiveautomation.com/u/alireza.dehghani)\ **Replies:** 9\ **Last updated:** [August 19, 2019, 10:06am UTC](https://forum.inductiveautomation.com/t/ignition-connection-to-matrikon-ua-tunneller/26653 "2019-08-19T10:06:43Z")
Hi, A client has an OPC DA server and they installed UA Tunneller (Matrikon) and using UA CLIENT TO CLASSIC SERVER. Is it possible Ignition connects to this Tunneller? If yes, how? Do we need to consider the certificate… --- ## [Roster not draggable in Firefox](https://forum.inductiveautomation.com/t/roster-not-draggable-in-firefox/8132)
**Author:** [@eaolson](https://forum.inductiveautomation.com/u/eaolson)\ **Replies:** 5\ **Last updated:** [March 11, 2015, 10:00pm UTC](https://forum.inductiveautomation.com/t/roster-not-draggable-in-firefox/8132 "2015-03-11T22:00:27Z")
In Firefox, I can select a User Source and the On-Call Roster will populate with the appropriate people, but none of the entries is draggable. It doesn't matter if the entry is selected or not. I was initially having t… --- ## [Null values on datatypes after restore](https://forum.inductiveautomation.com/t/null-values-on-datatypes-after-restore/27219)
**Author:** [@miculacristianradu](https://forum.inductiveautomation.com/u/miculacristianradu)\ **Replies:** 3\ **Last updated:** [August 19, 2019, 6:33am UTC](https://forum.inductiveautomation.com/t/null-values-on-datatypes-after-restore/27219 "2019-08-19T06:33:55Z")
Hi guys, I have a question regardin tags on datatypes. I just restored a project (including datatypes and tags) from a gateway backup that used to work fine. The problem is that half of my pressure sensors don’t transm… --- ## [PDF Viewer / File Explorer](https://forum.inductiveautomation.com/t/pdf-viewer-file-explorer/27545)
**Author:** [@robharrison07](https://forum.inductiveautomation.com/u/robharrison07)\ **Replies:** 3\ **Last updated:** [August 19, 2019, 4:25am UTC](https://forum.inductiveautomation.com/t/pdf-viewer-file-explorer/27545 "2019-08-19T04:25:35Z")
I have looked through the manual and it appears that there is two components that i would really like to be able to use. 1) being the PDF Viewer from what i can tell it says that it’s a component but i don’t see it anywh… --- ## [How to reveal a password on a Perspective table cell hover](https://forum.inductiveautomation.com/t/how-to-reveal-a-password-on-a-perspective-table-cell-hover/27541)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 0\ **Last updated:** [August 17, 2019, 9:47pm UTC](https://forum.inductiveautomation.com/t/how-to-reveal-a-password-on-a-perspective-table-cell-hover/27541 "2019-08-17T21:47:05Z")
I’m posting this for anyone who may have a similar task - or a special CSS requirement for a table cell or column. I keep a database of Engineering passwords for authorised users. Rather than have all the passwords visi… --- ## [OPC-UA question](https://forum.inductiveautomation.com/t/opc-ua-question/27533)
**Author:** [@richard.d.white](https://forum.inductiveautomation.com/u/richard.d.white)\ **Replies:** 2\ **Last updated:** [August 16, 2019, 11:20pm UTC](https://forum.inductiveautomation.com/t/opc-ua-question/27533 "2019-08-16T23:20:28Z")
We currently use the Ignition-provided OPC-UA server to pull in data from multiple devices via Modbus. Our devices are all microprocessors (arduino based) and in general everything is running very smoothly. As we expan… --- ## [addMinutes gives a date & time in the year 0014](https://forum.inductiveautomation.com/t/addminutes-gives-a-date-time-in-the-year-0014/27501)
**Author:** [@alan.carter](https://forum.inductiveautomation.com/u/alan.carter)\ **Replies:** 3\ **Last updated:** [August 16, 2019, 10:45pm UTC](https://forum.inductiveautomation.com/t/addminutes-gives-a-date-time-in-the-year-0014/27501 "2019-08-16T22:45:05Z")
Hello everyone I am trying to write a simple script that will add a certain amount of minutes to a time stamp. This is intended to show what time a part will be completed, by adding its average cycle time to the time s… --- ## [Anyway to cycle through screens automatically?](https://forum.inductiveautomation.com/t/anyway-to-cycle-through-screens-automatically/8639)
**Author:** [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\ **Replies:** 5\ **Last updated:** [August 16, 2019, 8:29pm UTC](https://forum.inductiveautomation.com/t/anyway-to-cycle-through-screens-automatically/8639 "2019-08-16T20:29:05Z")
I have several "overview" screens built, is there a way to cycle throught these screens every 5 minutes?? --- ## [Scripting change to prefix in power table?](https://forum.inductiveautomation.com/t/scripting-change-to-prefix-in-power-table/11159)
**Author:** [@Kstofcho](https://forum.inductiveautomation.com/u/Kstofcho)\ **Replies:** 5\ **Last updated:** [August 16, 2019, 6:34pm UTC](https://forum.inductiveautomation.com/t/scripting-change-to-prefix-in-power-table/11159 "2019-08-16T18:34:52Z")
Is it possible to change the prefix in a power table by using an extension function (configureCell?)? Additionally, is it possible to pull custom properties (that I defined using an expression function) into the extensi… --- ## [Numeric Text Field - Display "Nothing" instead of 0](https://forum.inductiveautomation.com/t/numeric-text-field-display-nothing-instead-of-0/27522)
**Author:** [@Neil\_B](https://forum.inductiveautomation.com/u/Neil_B)\ **Replies:** 1\ **Last updated:** [August 16, 2019, 5:23pm UTC](https://forum.inductiveautomation.com/t/numeric-text-field-display-nothing-instead-of-0/27522 "2019-08-16T17:23:36Z")
Is there a way to format a numeric text field to display a blank or nothing when set to zero? I’m using this to clear the client tag value = u'' system.tag.write('\[client\]Form Data/CurUser', value) --- ## [Change Database Connection Name](https://forum.inductiveautomation.com/t/change-database-connection-name/27517)
**Author:** [@dion.botha](https://forum.inductiveautomation.com/u/dion.botha)\ **Replies:** 1\ **Last updated:** [August 16, 2019, 3:20pm UTC](https://forum.inductiveautomation.com/t/change-database-connection-name/27517 "2019-08-16T15:20:34Z")
Hello, Am I correct in saying that if I change the name of our main database connection I am going to have issues or will everything (including scripts) change their reference to the new name? --- ## [Parameter Binding within a UDT](https://forum.inductiveautomation.com/t/parameter-binding-within-a-udt/27512)
**Author:** [@PLCINC\_NY](https://forum.inductiveautomation.com/u/PLCINC_NY)\ **Replies:** 2\ **Last updated:** [August 16, 2019, 1:39pm UTC](https://forum.inductiveautomation.com/t/parameter-binding-within-a-udt/27512 "2019-08-16T13:39:11Z")
Can someone send an example of a “PARAMETER BINDING” I have a UDT that where I want to bind the value of a tag to the metadata of a tag in the same UTD. I want to bind the value of a tag named “20ma” to the “ScaledH… --- ## [Server says that it's offline for licensing](https://forum.inductiveautomation.com/t/server-says-that-its-offline-for-licensing/27513)
**Author:** [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\ **Replies:** 0\ **Last updated:** [August 16, 2019, 12:05pm UTC](https://forum.inductiveautomation.com/t/server-says-that-its-offline-for-licensing/27513 "2019-08-16T12:05:10Z")
Hey all, Just wondering if anyone has ever seen the license management section say that the server is offline even though the server has access to the internet? I am getting ready to transfer the license from this serve… --- ## [Does Ignition support Port forwarding?](https://forum.inductiveautomation.com/t/does-ignition-support-port-forwarding/27510)
**Author:** [@sara.johansson](https://forum.inductiveautomation.com/u/sara.johansson)\ **Replies:** 4\ **Last updated:** [August 16, 2019, 11:45am UTC](https://forum.inductiveautomation.com/t/does-ignition-support-port-forwarding/27510 "2019-08-16T11:45:16Z")
I am trying to make the Ignition OPC client to connect to the OPC UA on a PLC using Port forwarding. I have problems so that’s why I am asking - does Ignition support Port forwarding? (Server with Ignition is on WAN, PL… --- ## [Use UDT parameters for Engineering Limits](https://forum.inductiveautomation.com/t/use-udt-parameters-for-engineering-limits/27503)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 0\ **Last updated:** [August 16, 2019, 8:12am UTC](https://forum.inductiveautomation.com/t/use-udt-parameters-for-engineering-limits/27503 "2019-08-16T08:12:59Z")
Hi When I try to use UDT parameters in tag Metedata/Engineering limits/High, the numeric field doesn’t accept it. I only can parameters for string filed and not numeric field. If I want my UDT tag Engineering Limits de… --- ## [The Ignition 8.0.4-Nightly can't be downloaded](https://forum.inductiveautomation.com/t/the-ignition-8-0-4-nightly-cant-be-downloaded/27500)
**Author:** [@dawei.liu](https://forum.inductiveautomation.com/u/dawei.liu)\ **Replies:** 2\ **Last updated:** [August 16, 2019, 1:57am UTC](https://forum.inductiveautomation.com/t/the-ignition-8-0-4-nightly-cant-be-downloaded/27500 "2019-08-16T01:57:02Z")
Hi, I want to download the latest version 8.0.4-Nightly. It seems that there is no resource for this version in below links: https://inductiveautomation.com/downloads/ https://inductiveautomation.com/downloads/releas… --- ## [SQL Anywhere16 database](https://forum.inductiveautomation.com/t/sql-anywhere16-database/27495)
**Author:** [@bebel](https://forum.inductiveautomation.com/u/bebel)\ **Replies:** 0\ **Last updated:** [August 15, 2019, 11:27pm UTC](https://forum.inductiveautomation.com/t/sql-anywhere16-database/27495 "2019-08-15T23:27:59Z")
I’m trying to communicate with a SQL Anywhere 16 db that is used by a third party CMMS program. Based on a post I found I’m using Connect URL jdbc:sybase:Tds:192.168.xx.xx:2638/\[server name\] and an additional connection… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1265) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1267)