# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1205 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1206 --- ## [Publish Service Error](https://forum.inductiveautomation.com/t/publish-service-error/44418)
**Author:** [@ryanastiefes](https://forum.inductiveautomation.com/u/ryanastiefes)\ **Replies:** 1\ **Last updated:** [March 12, 2021, 5:37pm UTC](https://forum.inductiveautomation.com/t/publish-service-error/44418 "2021-03-12T17:37:09Z")
Ignition 7.7.10 Current Console Errors: WARN 9:30:34 AM PublishService Returning ServiceFault for request: \[PublishRequest requestHandle=74871032\]. StatusCode=StatusCode\[Severity=Bad, Subcode=Bad\_NoSubscription\] … --- ## [Component Creation](https://forum.inductiveautomation.com/t/component-creation/44403)
**Author:** [@hossam.abdalrahman](https://forum.inductiveautomation.com/u/hossam.abdalrahman)\ **Replies:** 9\ **Last updated:** [March 12, 2021, 5:32pm UTC](https://forum.inductiveautomation.com/t/component-creation/44403 "2021-03-12T17:32:21Z")
Hello, Is there a way to create a new component in a window using scripting ? Thanks --- ## [SQL Server Partial Resultset](https://forum.inductiveautomation.com/t/sql-server-partial-resultset/44408)
**Author:** [@adnaram](https://forum.inductiveautomation.com/u/adnaram)\ **Replies:** 2\ **Last updated:** [March 12, 2021, 5:30pm UTC](https://forum.inductiveautomation.com/t/sql-server-partial-resultset/44408 "2021-03-12T17:30:25Z")
Hi, We use microsoft SQL server and ignition 7.9.17. We have a stored procedure that return immediately a partial resultset and the complete result a few seconds later. There is an example below. I use system.db.runQue… --- ## [How to identify number of users on X view in the browser at a time](https://forum.inductiveautomation.com/t/how-to-identify-number-of-users-on-x-view-in-the-browser-at-a-time/44417)
**Author:** [@retinder.labana](https://forum.inductiveautomation.com/u/retinder.labana)\ **Replies:** 0\ **Last updated:** [March 12, 2021, 5:30pm UTC](https://forum.inductiveautomation.com/t/how-to-identify-number-of-users-on-x-view-in-the-browser-at-a-time/44417 "2021-03-12T17:30:17Z")
I know you can get a list on users that are currently logged in to the session through script and filter is based on browser to narrow down who is logged into the browser. I wanted to know if it be possible to narrow th… --- ## [Ignition and Maple System](https://forum.inductiveautomation.com/t/ignition-and-maple-system/37883)
**Author:** [@mjohnson](https://forum.inductiveautomation.com/u/mjohnson)\ **Replies:** 1\ **Last updated:** [March 12, 2021, 3:40pm UTC](https://forum.inductiveautomation.com/t/ignition-and-maple-system/37883 "2021-03-12T15:40:20Z")
I am using Ignition Edge as a MQTT publisher, Ignition Gateway as the MQTT broker, and I want to use a Maple system as a MQTT Client. Using MQTTfx as a tester I can see the info at the Broker. Having issues connecting … --- ## [If function in mysql query](https://forum.inductiveautomation.com/t/if-function-in-mysql-query/44399)
**Author:** [@kuderskyys](https://forum.inductiveautomation.com/u/kuderskyys)\ **Replies:** 6\ **Last updated:** [March 12, 2021, 3:17pm UTC](https://forum.inductiveautomation.com/t/if-function-in-mysql-query/44399 "2021-03-12T15:17:36Z")
Hey guys! Can someone help me out? I have a problem with if function in mysql query (I want to create something like a switch) SELECT concat(COUNT(\*)) FROM {Root Container.NumberOfNumber 1.Table} if ({Root Contain… --- ## [How to compare string in expression language](https://forum.inductiveautomation.com/t/how-to-compare-string-in-expression-language/44390)
**Author:** [@Premnath.K](https://forum.inductiveautomation.com/u/Premnath.K)\ **Replies:** 7\ **Last updated:** [March 12, 2021, 11:48am UTC](https://forum.inductiveautomation.com/t/how-to-compare-string-in-expression-language/44390 "2021-03-12T11:48:40Z")
Is there a way to compare to strings in an expression language? I just want to compare my local ip in the system network tag to specific ip in string format and enable/disable a button in vision based on the result. --- ## [Runtime Update Buffer Size Explaination](https://forum.inductiveautomation.com/t/runtime-update-buffer-size-explaination/44396)
**Author:** [@trishadx](https://forum.inductiveautomation.com/u/trishadx)\ **Replies:** 0\ **Last updated:** [March 12, 2021, 10:23am UTC](https://forum.inductiveautomation.com/t/runtime-update-buffer-size-explaination/44396 "2021-03-12T10:23:56Z")
Hi guys, I’m still diving into the world of ignition. I’m currently setting up 3 deskstops, 1 for a master 1 for redundancy and the other as the hitorian with mysql installed. Just looking between the redundancy settin… --- ## [Connection to S7-1200 running Ignition Edge on Raspberry PI 4](https://forum.inductiveautomation.com/t/connection-to-s7-1200-running-ignition-edge-on-raspberry-pi-4/44368)
**Author:** [@electricworks48](https://forum.inductiveautomation.com/u/electricworks48)\ **Replies:** 5\ **Last updated:** [March 12, 2021, 10:07am UTC](https://forum.inductiveautomation.com/t/connection-to-s7-1200-running-ignition-edge-on-raspberry-pi-4/44368 "2021-03-12T10:07:11Z")
Hi All i have the Raspberry Pi 4 4gb Running the following OS PRETTY\_NAME=“Raspbian GNU/Linux 10 (buster)” NAME=“Raspbian GNU/Linux” VERSION\_ID=“10” VERSION=“10 (buster)” VERSION\_CODENAME=buster ID=raspbian ID\_LI… --- ## [Help on connecting to mysql and redundancy gateway on another computer](https://forum.inductiveautomation.com/t/help-on-connecting-to-mysql-and-redundancy-gateway-on-another-computer/44363)
**Author:** [@trishadx](https://forum.inductiveautomation.com/u/trishadx)\ **Replies:** 4\ **Last updated:** [March 12, 2021, 10:02am UTC](https://forum.inductiveautomation.com/t/help-on-connecting-to-mysql-and-redundancy-gateway-on-another-computer/44363 "2021-03-12T10:02:19Z")
Hi guys, I have a networking issue as computer networks isnt my strongest subject. I have 3 desktops in my structure where 1 is the master, 1 is the redundancy and another as my historian where I keep it all on mysql. … --- ## [phoneNumber Validation](https://forum.inductiveautomation.com/t/phonenumber-validation/44248)
**Author:** [@tohhy-pm17](https://forum.inductiveautomation.com/u/tohhy-pm17)\ **Replies:** 8\ **Last updated:** [March 12, 2021, 8:44am UTC](https://forum.inductiveautomation.com/t/phonenumber-validation/44248 "2021-03-12T08:44:06Z")
Hi guys, have a good days. May I know that Ignition able to do the validation checking for phone number format which the users only able to insert number instead of alphabetic characters ? --- ## [\[BUG\] Power Chart Tags Fail when aggregateMode = Average](https://forum.inductiveautomation.com/t/bug-power-chart-tags-fail-when-aggregatemode-average/44394)
**Author:** [@matthew.gollasch](https://forum.inductiveautomation.com/u/matthew.gollasch)\ **Replies:** 0\ **Last updated:** [March 12, 2021, 8:15am UTC](https://forum.inductiveautomation.com/t/bug-power-chart-tags-fail-when-aggregatemode-average/44394 "2021-03-12T08:15:40Z")
1. The behavior you unexpectedly encountered - The Perspective Power Chart displays no pen data in the Chart or in the Pen Control panel if any of the configured pens have an aggregateMode = Average and that pen’s value… --- ## [Report Components visibility option](https://forum.inductiveautomation.com/t/report-components-visibility-option/44393)
**Author:** [@Premnath.K](https://forum.inductiveautomation.com/u/Premnath.K)\ **Replies:** 0\ **Last updated:** [March 12, 2021, 7:46am UTC](https://forum.inductiveautomation.com/t/report-components-visibility-option/44393 "2021-03-12T07:46:47Z")
I am using a cross tab for showing the day-wise data for a month in a cumulative manner in reports, I could not accommodate the entire 30 days data in one cross tab so split it into two cross tab like days 1 to 15 and da… --- ## [Perspective XY Chart Y-Axis format](https://forum.inductiveautomation.com/t/perspective-xy-chart-y-axis-format/44353)
**Author:** [@pascal](https://forum.inductiveautomation.com/u/pascal)\ **Replies:** 2\ **Last updated:** [March 12, 2021, 7:24am UTC](https://forum.inductiveautomation.com/t/perspective-xy-chart-y-axis-format/44353 "2021-03-12T07:24:08Z")
Hi there, I have a little formatting problem with XY Chart in Perspective. I’m using Ignition 8.0.16. On a XY Chart, i have set my Y-Axis value format to #,###. I use a french locale so normally, when i launch a sessio… --- ## [Unable to hide columns in Perspective Table](https://forum.inductiveautomation.com/t/unable-to-hide-columns-in-perspective-table/44349)
**Author:** [@DougSN](https://forum.inductiveautomation.com/u/DougSN)\ **Replies:** 4\ **Last updated:** [March 12, 2021, 3:43am UTC](https://forum.inductiveautomation.com/t/unable-to-hide-columns-in-perspective-table/44349 "2021-03-12T03:43:05Z")
I must be doing something wrong here, but I don’t see what it is. I have a column view in Perspective, and a Table component with a named query on the data binding. There are several UUID columns that I need to be in the… --- ## [Just Curious if its possible](https://forum.inductiveautomation.com/t/just-curious-if-its-possible/44156)
**Author:** [@toddayers](https://forum.inductiveautomation.com/u/toddayers)\ **Replies:** 3\ **Last updated:** [March 12, 2021, 3:16am UTC](https://forum.inductiveautomation.com/t/just-curious-if-its-possible/44156 "2021-03-12T03:16:40Z")
Right now our supervisors are using attendance sheets that have been created using excel. They pull up these sheets and print them off each day to provide to the coordinators to check off which employees are at work for … --- ## [Json viewer tools](https://forum.inductiveautomation.com/t/json-viewer-tools/44384)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 4\ **Last updated:** [March 12, 2021, 1:25am UTC](https://forum.inductiveautomation.com/t/json-viewer-tools/44384 "2021-03-12T01:25:29Z")
I use notepad++ a lot for viewing tag Json with the plugins ‘JSTool’ and ‘JSON Viewer’ which are great for the most part, however when you’re viewing a large number of tags and trying to use find to search for specific t… --- ## [Ignition Perspective Demo App, IIoT Stack Light Video Feed](https://forum.inductiveautomation.com/t/ignition-perspective-demo-app-iiot-stack-light-video-feed/44340)
**Author:** [@jrankin](https://forum.inductiveautomation.com/u/jrankin)\ **Replies:** 2\ **Last updated:** [March 11, 2021, 11:45pm UTC](https://forum.inductiveautomation.com/t/ignition-perspective-demo-app-iiot-stack-light-video-feed/44340 "2021-03-11T23:45:33Z")
Hello, Could someone at IA turn the Ignition Perspective Demo App, IIoT Stack Light Video Feed camera back on? It currently shows a red dotted line around the image. I like to use this in my automation-related classes … --- ## [Driven Scan Class Complete Notification](https://forum.inductiveautomation.com/t/driven-scan-class-complete-notification/44377)
**Author:** [@CJVR](https://forum.inductiveautomation.com/u/CJVR)\ **Replies:** 2\ **Last updated:** [March 11, 2021, 10:34pm UTC](https://forum.inductiveautomation.com/t/driven-scan-class-complete-notification/44377 "2021-03-11T22:34:50Z")
We are setting up a tag as an array with 6000 elements that will read an array from a PLC when instructed to. We were thinking of using a separate scan class for the tag, making it driven, setting one shot to true, and u… --- ## [Help with an error message](https://forum.inductiveautomation.com/t/help-with-an-error-message/44343)
**Author:** [@Ali.Etezadkhah](https://forum.inductiveautomation.com/u/Ali.Etezadkhah)\ **Replies:** 3\ **Last updated:** [March 11, 2021, 8:53pm UTC](https://forum.inductiveautomation.com/t/help-with-an-error-message/44343 "2021-03-11T20:53:47Z")
Hi, How do I get more information about an error like this? Every time I navigate to this page, I get this error message, but it doesn’t give me any useful information to track down the cause of it. I have not set any… --- ## [Modify / Disable entries in Easy Chart Popup](https://forum.inductiveautomation.com/t/modify-disable-entries-in-easy-chart-popup/44373)
**Author:** [@tobiasatats](https://forum.inductiveautomation.com/u/tobiasatats)\ **Replies:** 0\ **Last updated:** [March 11, 2021, 6:04pm UTC](https://forum.inductiveautomation.com/t/modify-disable-entries-in-easy-chart-popup/44373 "2021-03-11T18:04:13Z")
Hi, I’d like to remove the "Save as… " and “Print” options from the Popup right on the easy chart. Any Ideas / possiblity for that? I found only these guys here, which will do the same as the properties right on the ea… --- ## [View the wrapper.log File in a Client or Designer](https://forum.inductiveautomation.com/t/view-the-wrapper-log-file-in-a-client-or-designer/10156)
**Author:** [@nmudge](https://forum.inductiveautomation.com/u/nmudge)\ **Replies:** 7\ **Last updated:** [March 11, 2021, 5:55pm UTC](https://forum.inductiveautomation.com/t/view-the-wrapper-log-file-in-a-client-or-designer/10156 "2021-03-11T17:55:19Z")
The Perfect Abstractions development team recently released an Ignition project that enables people to easily see the wrapper.log file in a client or designer. This project solves the problem of not having remote access… --- ## [Removing Non-ASCII Characters](https://forum.inductiveautomation.com/t/removing-non-ascii-characters/44367)
**Author:** [@alexfediw](https://forum.inductiveautomation.com/u/alexfediw)\ **Replies:** 1\ **Last updated:** [March 11, 2021, 4:34pm UTC](https://forum.inductiveautomation.com/t/removing-non-ascii-characters/44367 "2021-03-11T16:34:02Z")
Hello, I am trying to display a string that I get from a tag. The displayed value is appearing like the picture included: I am trying to remove the trailing characters using: split({tagName},’\[^\\x00-\\x7F\]’)\[0\] But … --- ## [Cannot concatenate 'unicode' and 'int' objects : Error](https://forum.inductiveautomation.com/t/cannot-concatenate-unicode-and-int-objects-error/44366)
**Author:** [@seanbuckley2698](https://forum.inductiveautomation.com/u/seanbuckley2698)\ **Replies:** 6\ **Last updated:** [March 11, 2021, 4:11pm UTC](https://forum.inductiveautomation.com/t/cannot-concatenate-unicode-and-int-objects-error/44366 "2021-03-11T16:11:19Z")
When trying to give the body of an email I have the following code... system.net.sendEmail(smtpProfile="SendInBlue", fromAddr="notification@ticketingsystemfyp.com", subject="Request Submission Confirmation", body="Hello… --- ## [Reset configuration](https://forum.inductiveautomation.com/t/reset-configuration/44365)
**Author:** [@lachguerabdallah](https://forum.inductiveautomation.com/u/lachguerabdallah)\ **Replies:** 2\ **Last updated:** [March 11, 2021, 3:57pm UTC](https://forum.inductiveautomation.com/t/reset-configuration/44365 "2021-03-11T15:57:57Z")
hello Is there a way to get the instances back to the same udt configuration? thanks you --- ## [Is it possible to color fill certain cells in a Reporting table or Crosstab?](https://forum.inductiveautomation.com/t/is-it-possible-to-color-fill-certain-cells-in-a-reporting-table-or-crosstab/44336)
**Author:** [@framebuilder](https://forum.inductiveautomation.com/u/framebuilder)\ **Replies:** 2\ **Last updated:** [March 11, 2021, 3:37pm UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-color-fill-certain-cells-in-a-reporting-table-or-crosstab/44336 "2021-03-11T15:37:52Z")
Ignition 8.0.16 Is it possible to add any logic to Reporting components that allow color coding of cells in a table, simple table, or crosstab? For instance, we want to populate table with a dataset of integers but col… --- ## [\[SOLVED\] How to get PyRows to work in 8.0.16](https://forum.inductiveautomation.com/t/solved-how-to-get-pyrows-to-work-in-8-0-16/39961)
**Author:** [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Replies:** 5\ **Last updated:** [March 11, 2021, 3:37pm UTC](https://forum.inductiveautomation.com/t/solved-how-to-get-pyrows-to-work-in-8-0-16/39961 "2021-03-11T15:37:30Z")
Good morning, This webpage has a new section titled PyRow. I am trying to run the example given but am getting an error in the script console. Can someone help me understand why? https://docs.inductiveautomation.com/di… --- ## [Alarms event in remote tag provider not sended to AlarmJournal](https://forum.inductiveautomation.com/t/alarms-event-in-remote-tag-provider-not-sended-to-alarmjournal/43558)
**Author:** [@avg](https://forum.inductiveautomation.com/u/avg)\ **Replies:** 2\ **Last updated:** [March 11, 2021, 3:25pm UTC](https://forum.inductiveautomation.com/t/alarms-event-in-remote-tag-provider-not-sended-to-alarmjournal/43558 "2021-03-11T15:25:53Z")
Hello, everybody! I’ve got a project with two providers: One default local provider. One remote provider setup via a Gateway Connection with a secondary Ignition Gateway. I’ve got different alarms defined in remote p… --- ## [Module license activation change in 8.1](https://forum.inductiveautomation.com/t/module-license-activation-change-in-8-1/44364)
**Author:** [@joseph.burns](https://forum.inductiveautomation.com/u/joseph.burns)\ **Replies:** 2\ **Last updated:** [March 11, 2021, 3:09pm UTC](https://forum.inductiveautomation.com/t/module-license-activation-change-in-8-1/44364 "2021-03-11T15:09:15Z")
In 8.0, I could activate my module’s license on a gateway without an active platform license. In 8.1, it looks like the platform license is needed before the module license activates. Can anyone confirm if it’s a new re… --- ## [Communications & Scripting Query](https://forum.inductiveautomation.com/t/communications-scripting-query/44332)
**Author:** [@colin.bonner](https://forum.inductiveautomation.com/u/colin.bonner)\ **Replies:** 5\ **Last updated:** [March 11, 2021, 2:55pm UTC](https://forum.inductiveautomation.com/t/communications-scripting-query/44332 "2021-03-11T14:55:38Z")
So lets say I decide to monitor how long a falling temperature takes to drop below a predefined value by using a while loop as shown: An event script will kick this off as it knows that the temperature is about to start… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1204) [Next page](https://forum.inductiveautomation.com/latest.md?page=1206)