# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=982 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 983 --- ## [The statement did not return a result set](https://forum.inductiveautomation.com/t/the-statement-did-not-return-a-result-set/49369)
**Author:** [@suram-in](https://forum.inductiveautomation.com/u/suram-in)\ **Replies:** 4\ **Last updated:** [July 30, 2021, 7:52pm UTC](https://forum.inductiveautomation.com/t/the-statement-did-not-return-a-result-set/49369 "2021-07-30T19:52:36Z")
Hi I am getting the error “The statement did not return a result set” for the below queries. I have written this code in expression. I want to display @TOTALVALUE in the Label Display. The Code is :: DECLARE @TotalCoun… --- ## [How do I gateway "System Name" in script?](https://forum.inductiveautomation.com/t/how-do-i-gateway-system-name-in-script/49413)
**Author:** [@frank.carney](https://forum.inductiveautomation.com/u/frank.carney)\ **Replies:** 1\ **Last updated:** [July 30, 2021, 6:15pm UTC](https://forum.inductiveautomation.com/t/how-do-i-gateway-system-name-in-script/49413 "2021-07-30T18:15:28Z")
I want the System Name in script so I can build up dynamic pens for my Easy Chart. For some reason the tag path in the historian requires this: --- ## [Tab navigation triggered from a button](https://forum.inductiveautomation.com/t/tab-navigation-triggered-from-a-button/49378)
**Author:** [@ordosays](https://forum.inductiveautomation.com/u/ordosays)\ **Replies:** 3\ **Last updated:** [July 30, 2021, 5:53pm UTC](https://forum.inductiveautomation.com/t/tab-navigation-triggered-from-a-button/49378 "2021-07-30T17:53:40Z")
I have a few views that use tabs and essentially use a svg “map” to switch tabs. Right now I sort of have it working with an on-click script writing to a memory tag and then the “currentTabIndex” bound to that memory tag… --- ## [configureCell extension function not working](https://forum.inductiveautomation.com/t/configurecell-extension-function-not-working/49407)
**Author:** [@michael.black](https://forum.inductiveautomation.com/u/michael.black)\ **Replies:** 4\ **Last updated:** [July 30, 2021, 5:12pm UTC](https://forum.inductiveautomation.com/t/configurecell-extension-function-not-working/49407 "2021-07-30T17:12:20Z")
I have a power table where I want to change the background color of the row if the string value of the column “username” equals the user that is currently logged in. This is the code I can’t get to work: currentuser =… --- ## [Ignition MQTT Questions](https://forum.inductiveautomation.com/t/ignition-mqtt-questions/49258)
**Author:** [@Brian.Boothe](https://forum.inductiveautomation.com/u/Brian.Boothe)\ **Replies:** 4\ **Last updated:** [July 30, 2021, 5:10pm UTC](https://forum.inductiveautomation.com/t/ignition-mqtt-questions/49258 "2021-07-30T17:10:41Z")
i want to be able to have our Client Display MQTT data on there Ignition Clients.we have a MQTT broker running now “mosquito Broker” with MQTT data coming from our PLC what is the minimal we need to be able to Effectiv… --- ## [Add crlf to string](https://forum.inductiveautomation.com/t/add-crlf-to-string/49406)
**Author:** [@NII](https://forum.inductiveautomation.com/u/NII)\ **Replies:** 5\ **Last updated:** [July 30, 2021, 5:07pm UTC](https://forum.inductiveautomation.com/t/add-crlf-to-string/49406 "2021-07-30T17:07:40Z")
Hi, How do I add crlf to a string tag literally (typing it directly to it in tag browser)? --- ## [Pie/Bar Charts Not Showing Up in Vision Client](https://forum.inductiveautomation.com/t/pie-bar-charts-not-showing-up-in-vision-client/49404)
**Author:** [@rrebro](https://forum.inductiveautomation.com/u/rrebro)\ **Replies:** 1\ **Last updated:** [July 30, 2021, 3:40pm UTC](https://forum.inductiveautomation.com/t/pie-bar-charts-not-showing-up-in-vision-client/49404 "2021-07-30T15:40:34Z")
I am trying to use bar and pie charts that are connected to a database. The charts with data show up in the Designer but when I go to Vision Client, the charts are blank and show no data --- ## [Question about large svgs in views](https://forum.inductiveautomation.com/t/question-about-large-svgs-in-views/49399)
**Author:** [@asher\_hounsell](https://forum.inductiveautomation.com/u/asher_hounsell)\ **Replies:** 1\ **Last updated:** [July 30, 2021, 3:07pm UTC](https://forum.inductiveautomation.com/t/question-about-large-svgs-in-views/49399 "2021-07-30T15:07:52Z")
I have a relatively large svg (3 mb) with many other small svgs in a container on a view, and like google maps I am moving it around and zooming into it. In browser these actions can be a bit slow and choppy. I am quite … --- ## [Use a Flex Repeater to select Details](https://forum.inductiveautomation.com/t/use-a-flex-repeater-to-select-details/49371)
**Author:** [@stan.cook](https://forum.inductiveautomation.com/u/stan.cook)\ **Replies:** 3\ **Last updated:** [July 30, 2021, 2:25pm UTC](https://forum.inductiveautomation.com/t/use-a-flex-repeater-to-select-details/49371 "2021-07-30T14:25:35Z")
Is it possible to know which embedded view of a Perspective Flex Repeater has been selected? I want an event script when the repeater is clicked which will ‘send’ a value to an adjacent “detail” view. The detail will s… --- ## [Service wrapper is not restarting JVM in case of fault](https://forum.inductiveautomation.com/t/service-wrapper-is-not-restarting-jvm-in-case-of-fault/49386)
**Author:** [@chi](https://forum.inductiveautomation.com/u/chi)\ **Replies:** 4\ **Last updated:** [July 30, 2021, 1:24pm UTC](https://forum.inductiveautomation.com/t/service-wrapper-is-not-restarting-jvm-in-case-of-fault/49386 "2021-07-30T13:24:54Z")
Hello, this night our Ignition server stopped working. The cause for the fault was most problably the logfile maintenance with a logger setting to debug. The wrapper detected a problem with the JVM but failed to restart… --- ## [Open Location In Mobile Device Maps - Perspective](https://forum.inductiveautomation.com/t/open-location-in-mobile-device-maps-perspective/49393)
**Author:** [@andytimc](https://forum.inductiveautomation.com/u/andytimc)\ **Replies:** 0\ **Last updated:** [July 30, 2021, 12:22pm UTC](https://forum.inductiveautomation.com/t/open-location-in-mobile-device-maps-perspective/49393 "2021-07-30T12:22:44Z")
I have built a map view to show a bunch of relavant locations to our field employees. I would like the ability to click an icon and show a pop-up with details and a button that says directions. The button would then open… --- ## [Tag editing in a text editor](https://forum.inductiveautomation.com/t/tag-editing-in-a-text-editor/49365)
**Author:** [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Replies:** 2\ **Last updated:** [July 30, 2021, 11:49am UTC](https://forum.inductiveautomation.com/t/tag-editing-in-a-text-editor/49365 "2021-07-30T11:49:13Z")
Importing and Exporting Tags - Understanding Tags (inductiveuniversity.com) At point in the video he says he cheated a little bit, and just changed the name. What do I need to change to get the same tags from one machi… --- ## [Mouse cursor control on embedded view](https://forum.inductiveautomation.com/t/mouse-cursor-control-on-embedded-view/49347)
**Author:** [@stan.cook](https://forum.inductiveautomation.com/u/stan.cook)\ **Replies:** 5\ **Last updated:** [July 30, 2021, 11:46am UTC](https://forum.inductiveautomation.com/t/mouse-cursor-control-on-embedded-view/49347 "2021-07-30T11:46:28Z")
Using Perspective, I have a small view “status line” that I am embedding in another view via a flex repeater. I’ll call this the “test” page. The “status line” view consists of a couple dynamic labels. I want to have … --- ## [Object has no atrtribute 'run'](https://forum.inductiveautomation.com/t/object-has-no-atrtribute-run/49389)
**Author:** [@pablo1jima](https://forum.inductiveautomation.com/u/pablo1jima)\ **Replies:** 5\ **Last updated:** [July 30, 2021, 11:28am UTC](https://forum.inductiveautomation.com/t/object-has-no-atrtribute-run/49389 "2021-07-30T11:28:24Z")
I want to modify the .Start\_Date and End Date from a Date Range with a SQL Query result The code: import system import sys OF = event.source.parent.getComponent(‘Busca\_OF’).intValue buscaIni = “SELECT FECHAINICIO FR… --- ## [Call stored procedure IBM](https://forum.inductiveautomation.com/t/call-stored-procedure-ibm/49346)
**Author:** [@supporto.edp](https://forum.inductiveautomation.com/u/supporto.edp)\ **Replies:** 2\ **Last updated:** [July 30, 2021, 10:19am UTC](https://forum.inductiveautomation.com/t/call-stored-procedure-ibm/49346 "2021-07-30T10:19:13Z")
Hi, i’m trying to call a procedure in as400 / iseries like this call = system.db.createSProcCall('ESTLIB/STPTEST','as400\_Conn') call.registerInParam("PrmCod", system.db.CHAR, "a") call.registerOutParam("PrmRis", system.… --- ## [Language handling and translation in Perspective](https://forum.inductiveautomation.com/t/language-handling-and-translation-in-perspective/49387)
**Author:** [@mahsasalimi](https://forum.inductiveautomation.com/u/mahsasalimi)\ **Replies:** 1\ **Last updated:** [July 30, 2021, 9:35am UTC](https://forum.inductiveautomation.com/t/language-handling-and-translation-in-perspective/49387 "2021-07-30T09:35:18Z")
Hi , I am learning about the best way of language handling in perspective. Question is , if I have a phrase like “Fresh Water” , is there a way to just create a key for “Fresh” and a key for “Water” and expect the phr… --- ## [\[BUG\] Copying is disabled in designer when a view is first opened](https://forum.inductiveautomation.com/t/bug-copying-is-disabled-in-designer-when-a-view-is-first-opened/49381)
**Author:** [@michael2](https://forum.inductiveautomation.com/u/michael2)\ **Replies:** 1\ **Last updated:** [July 30, 2021, 5:13am UTC](https://forum.inductiveautomation.com/t/bug-copying-is-disabled-in-designer-when-a-view-is-first-opened/49381 "2021-07-30T05:13:04Z")
See above: Clicking a component a second time will allow for copy pasting. I believe @nminchin has posted about this before but I couldn’t find the post. To replicate: Open a view Select a component Copying is dis… --- ## [Property() Expression Function](https://forum.inductiveautomation.com/t/property-expression-function/49376)
**Author:** [@WillMT10](https://forum.inductiveautomation.com/u/WillMT10)\ **Replies:** 5\ **Last updated:** [July 30, 2021, 4:57am UTC](https://forum.inductiveautomation.com/t/property-expression-function/49376 "2021-07-30T04:57:13Z")
Are there any drawbacks to using the property() expression function? I just want to make sure I’m not errantly creating a bunch of performance issues that I’ll need to correct down the road (à la tag()). --- ## [Bind Button Visbility to Cient ID](https://forum.inductiveautomation.com/t/bind-button-visbility-to-cient-id/49315)
**Author:** [@pratik\_jain](https://forum.inductiveautomation.com/u/pratik_jain)\ **Replies:** 2\ **Last updated:** [July 30, 2021, 2:38am UTC](https://forum.inductiveautomation.com/t/bind-button-visbility-to-cient-id/49315 "2021-07-30T02:38:34Z")
Hello, I am trying to bind Button Visibility to the Client ID (Computer Name). If the Application is running on a certain computer then only show the button. Any Help or leads are appreciated. Thank You --- ## [Have to restart gateway to see new themes made in the program files?](https://forum.inductiveautomation.com/t/have-to-restart-gateway-to-see-new-themes-made-in-the-program-files/49368)
**Author:** [@asher\_hounsell](https://forum.inductiveautomation.com/u/asher_hounsell)\ **Replies:** 5\ **Last updated:** [July 30, 2021, 12:07am UTC](https://forum.inductiveautomation.com/t/have-to-restart-gateway-to-see-new-themes-made-in-the-program-files/49368 "2021-07-30T00:07:14Z")
Hello. I am trying to learn how to use more CSS in perspective and made a new theme in the program files but do not yet see it in the session props theme, do I need to restart the gateway to do so? --- ## [How to reference main window from docked window in expression?](https://forum.inductiveautomation.com/t/how-to-reference-main-window-from-docked-window-in-expression/49366)
**Author:** [@dzohner](https://forum.inductiveautomation.com/u/dzohner)\ **Replies:** 6\ **Last updated:** [July 29, 2021, 9:26pm UTC](https://forum.inductiveautomation.com/t/how-to-reference-main-window-from-docked-window-in-expression/49366 "2021-07-29T21:26:56Z")
I am having difficulty referencing the current window in an expression. I have a docked window open and a main window. On the docked window I have a component I’m trying to write an expression with that references what c… --- ## [Power Chart custom pen name powerchart](https://forum.inductiveautomation.com/t/power-chart-custom-pen-name-powerchart/49320)
**Author:** [@AliE](https://forum.inductiveautomation.com/u/AliE)\ **Replies:** 5\ **Last updated:** [July 29, 2021, 9:10pm UTC](https://forum.inductiveautomation.com/t/power-chart-custom-pen-name-powerchart/49320 "2021-07-29T21:10:30Z")
Hi, How can I automatically add descriptive names to pens when they are selected from the Browse Tag window? I read the manual for the Power Chart, but it doesn’t have information about scripting. https://docs.inducti… --- ## [Feature request enable/disable a binding](https://forum.inductiveautomation.com/t/feature-request-enable-disable-a-binding/49352)
**Author:** [@wmbrits7](https://forum.inductiveautomation.com/u/wmbrits7)\ **Replies:** 5\ **Last updated:** [July 29, 2021, 8:23pm UTC](https://forum.inductiveautomation.com/t/feature-request-enable-disable-a-binding/49352 "2021-07-29T20:23:11Z")
Function to dynamically enable or disable a binding in perspective using a script similar to component.refreshBinding(‘propertyName’) --- ## [ERROR: INSERT has more target columns than expressions](https://forum.inductiveautomation.com/t/error-insert-has-more-target-columns-than-expressions/49357)
**Author:** [@arjunrajas](https://forum.inductiveautomation.com/u/arjunrajas)\ **Replies:** 9\ **Last updated:** [July 29, 2021, 7:05pm UTC](https://forum.inductiveautomation.com/t/error-insert-has-more-target-columns-than-expressions/49357 "2021-07-29T19:05:40Z")
i am using postgresql Database and i am trying to insert a row into a table using script given below system.db.runPrepUpdate(“INSERT INTO ABC(ROW\_ID,TRXN\_DATE,SHIFT,WORK\_STATION\_ID,PLANT\_ID,SUB\_LOCATION,CUSTOMER\_NAME,OA… --- ## [Default Launcher JSONs](https://forum.inductiveautomation.com/t/default-launcher-jsons/49265)
**Author:** [@john.furby](https://forum.inductiveautomation.com/u/john.furby)\ **Replies:** 4\ **Last updated:** [July 29, 2021, 6:57pm UTC](https://forum.inductiveautomation.com/t/default-launcher-jsons/49265 "2021-07-29T18:57:56Z")
Has anyone figured out a way to get new users the same starting JSON file for Vision Client and Designer launcher? It seems these only get created once Ignition is launched for the new user. We’ve gotten around this by m… --- ## [Report component property binding not evaluating?](https://forum.inductiveautomation.com/t/report-component-property-binding-not-evaluating/49367)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 0\ **Last updated:** [July 29, 2021, 6:54pm UTC](https://forum.inductiveautomation.com/t/report-component-property-binding-not-evaluating/49367 "2021-07-29T18:54:44Z")
Converted a legacy component report to a modern way using Convert right click magic. I have a table that has the visibility property binding that was autogenerated like this General\_Data.Fail\_Flag != 0 No matter what… --- ## [Template Repeater - Best Fit - Ordering Direction](https://forum.inductiveautomation.com/t/template-repeater-best-fit-ordering-direction/49361)
**Author:** [@Bill\_L](https://forum.inductiveautomation.com/u/Bill_L)\ **Replies:** 1\ **Last updated:** [July 29, 2021, 5:15pm UTC](https://forum.inductiveautomation.com/t/template-repeater-best-fit-ordering-direction/49361 "2021-07-29T17:15:35Z")
Is there a way to change the direction of ordering of items in a template repeater with a best fit layout? I would like the items to be ordered in columns first instead of rows. Desired: 1 4 7 2 5 8 3 6 9 Actual: 1 … --- ## [Read from A OPC device, write value to B OPC device/PLC](https://forum.inductiveautomation.com/t/read-from-a-opc-device-write-value-to-b-opc-device-plc/49325)
**Author:** [@stuart.williams](https://forum.inductiveautomation.com/u/stuart.williams)\ **Replies:** 10\ **Last updated:** [July 29, 2021, 4:15pm UTC](https://forum.inductiveautomation.com/t/read-from-a-opc-device-write-value-to-b-opc-device-plc/49325 "2021-07-29T16:15:21Z")
Hi everyone, I’ve got a customer that wants to use Ignition as a middleware between OPC systems (A device and B device) on a production line. Ignition is to read values from OPC device A and then write changes into a PL… --- ## [Add role to active user](https://forum.inductiveautomation.com/t/add-role-to-active-user/49355)
**Author:** [@jmoniz](https://forum.inductiveautomation.com/u/jmoniz)\ **Replies:** 2\ **Last updated:** [July 29, 2021, 4:11pm UTC](https://forum.inductiveautomation.com/t/add-role-to-active-user/49355 "2021-07-29T16:11:18Z")
I’ve gone looking but can’t seem to fine the method or proper syntax, to edit a user role assignment. I need to assign a specific role to them. I see this in the manual # Retrieve the user we're going to edit. userToC… --- ## [Py list to dataset](https://forum.inductiveautomation.com/t/py-list-to-dataset/49348)
**Author:** [@kghali](https://forum.inductiveautomation.com/u/kghali)\ **Replies:** 8\ **Last updated:** [July 29, 2021, 3:51pm UTC](https://forum.inductiveautomation.com/t/py-list-to-dataset/49348 "2021-07-29T15:51:13Z")
Hello, How can we make a dataset from py lists? [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=981) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=983)