# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1478 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1479 --- ## [SQL tags data to columns](https://forum.inductiveautomation.com/t/sql-tags-data-to-columns/27593)
**Author:** [@nouh.qaoud](https://forum.inductiveautomation.com/u/nouh.qaoud)\ **Replies:** 0\ **Last updated:** [August 20, 2019, 1:03pm UTC](https://forum.inductiveautomation.com/t/sql-tags-data-to-columns/27593 "2019-08-20T13:03:02Z")
Dears I have haistorical tag with 3 values only (1,2,3) . Could you please help me to show the percentage of each value per day as below: Thanks Nouh --- ## [Tags register address](https://forum.inductiveautomation.com/t/tags-register-address/27306)
**Author:** [@miculacristianradu](https://forum.inductiveautomation.com/u/miculacristianradu)\ **Replies:** 2\ **Last updated:** [August 20, 2019, 10:11am UTC](https://forum.inductiveautomation.com/t/tags-register-address/27306 "2019-08-20T10:11:33Z")
Hi, I have a question regarding the way we set tag values in Ignition. I noticed that every group of tags, when we set the register address,beside the number it has different letter on prefix. (see bellow) Here… --- ## [Ignition 7.9.5 - isAlarmActiveFiltered - wildcards for relative tagpath](https://forum.inductiveautomation.com/t/ignition-7-9-5-isalarmactivefiltered-wildcards-for-relative-tagpath/16131)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 9\ **Last updated:** [August 20, 2019, 9:35am UTC](https://forum.inductiveautomation.com/t/ignition-7-9-5-isalarmactivefiltered-wildcards-for-relative-tagpath/16131 "2019-08-20T09:35:56Z")
Hi @KathyApplebaum, We try to use the new expression in 7.9.5 isAlarmActiveFiltered We have gateway tags inside an UDT with the following expression Tag1 : forceQuality(isAlarmActiveFiltered("..\[.\]/\*\_AH", "\*",… --- ## [Template Parameters not loading](https://forum.inductiveautomation.com/t/template-parameters-not-loading/27589)
**Author:** [@oisin.gribben](https://forum.inductiveautomation.com/u/oisin.gribben)\ **Replies:** 0\ **Last updated:** [August 20, 2019, 9:24am UTC](https://forum.inductiveautomation.com/t/template-parameters-not-loading/27589 "2019-08-20T09:24:12Z")
Hi, We have a script that passes in 2 datasets to a trends template that has an easy chart on it. When opening the template we get an error saying penList doesn’t exist. I double checked on the template and it’s there … --- ## ["Table Header font" property for the Alarm Journal Component](https://forum.inductiveautomation.com/t/table-header-font-property-for-the-alarm-journal-component/8518)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 3\ **Last updated:** [August 20, 2019, 8:14am UTC](https://forum.inductiveautomation.com/t/table-header-font-property-for-the-alarm-journal-component/8518 "2019-08-20T08:14:46Z")
Can you please add "Table Header font" property for the Alarm Journal Component. We have it for the Alarm Status Component. --- ## [Hide components until overlay errors disappear in Perspective Views](https://forum.inductiveautomation.com/t/hide-components-until-overlay-errors-disappear-in-perspective-views/27561)
**Author:** [@roberto.camp](https://forum.inductiveautomation.com/u/roberto.camp)\ **Replies:** 4\ **Last updated:** [August 20, 2019, 6:47am UTC](https://forum.inductiveautomation.com/t/hide-components-until-overlay-errors-disappear-in-perspective-views/27561 "2019-08-20T06:47:54Z")
Hey guys, I’m having a small “usability” / “neatness” problem. I have a project on Perspective in which I use a bunch of embedded views within embedded views with Indirect tags. I have no functional problem in the sense… --- ## [Translate the date](https://forum.inductiveautomation.com/t/translate-the-date/27511)
**Author:** [@mikkn](https://forum.inductiveautomation.com/u/mikkn)\ **Replies:** 2\ **Last updated:** [August 20, 2019, 6:13am UTC](https://forum.inductiveautomation.com/t/translate-the-date/27511 "2019-08-20T06:13:13Z")
hey i’m using the reporting module, to make a daily report, so we need the date to be showed at the front, but the date is in English, so my question is there a way to change date from spelled English to spelled on Dani… --- ## [Cirrus MQTT error](https://forum.inductiveautomation.com/t/cirrus-mqtt-error/27548)
**Author:** [@craigb](https://forum.inductiveautomation.com/u/craigb)\ **Replies:** 3\ **Last updated:** [August 20, 2019, 3:55am UTC](https://forum.inductiveautomation.com/t/cirrus-mqtt-error/27548 "2019-08-20T03:55:55Z")
I had the cirrus modules set up and working in 7.9… I’ve installed the latest modules for v8 and I cant get it to work right. I can get the MQTT device (Raspberry pi) to connect to my V8 server and send its messages, If… --- ## [Scan Class when using MQTT](https://forum.inductiveautomation.com/t/scan-class-when-using-mqtt/27575)
**Author:** [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Replies:** 4\ **Last updated:** [August 20, 2019, 1:57am UTC](https://forum.inductiveautomation.com/t/scan-class-when-using-mqtt/27575 "2019-08-20T01:57:24Z")
I can’t figure out how to use the scan classes with MQTT (Tags). I have a MQTT publisher the publishes the tags every 3 minutes (180000 ms). Now in Ignition (7.9.10) I have just 4 tags set to store to a MSSQL database. … --- ## [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… --- ## [Define String Column Length in SDK](https://forum.inductiveautomation.com/t/define-string-column-length-in-sdk/27569)
**Author:** [@cody.tamaki](https://forum.inductiveautomation.com/u/cody.tamaki)\ **Replies:** 2\ **Last updated:** [August 19, 2019, 3:27pm UTC](https://forum.inductiveautomation.com/t/define-string-column-length-in-sdk/27569 "2019-08-19T15:27:05Z")
I’ve got a module that automatically creates a table in SQL and I would like to make a column that would be equivalent to a LONGTEXT in MySQL. What is the best way to define that? I’m following the guide below. \[https… --- ## [\[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… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1477) [Next page](https://forum.inductiveautomation.com/latest.md?page=1479)