# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=926 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 927 --- ## [Prepared Queries Not Substituting Floats Correctly](https://forum.inductiveautomation.com/t/prepared-queries-not-substituting-floats-correctly/53471)
**Author:** [@catherine.fowler](https://forum.inductiveautomation.com/u/catherine.fowler)\ **Replies:** 7\ **Last updated:** [November 26, 2021, 4:20pm UTC](https://forum.inductiveautomation.com/t/prepared-queries-not-substituting-floats-correctly/53471 "2021-11-26T16:20:51Z")
I’m using Ignition 8.1.12 Perspective and found one of my queries was executing fine when I was checking for an integer in my WHERE clause, but when checking for a float it was failing. I boiled it down to a simpler quer… --- ## [Named query multiple DB](https://forum.inductiveautomation.com/t/named-query-multiple-db/53489)
**Author:** [@Arnaud\_Declerck](https://forum.inductiveautomation.com/u/Arnaud_Declerck)\ **Replies:** 3\ **Last updated:** [November 26, 2021, 4:05pm UTC](https://forum.inductiveautomation.com/t/named-query-multiple-db/53489 "2021-11-26T16:05:51Z")
Would it be possible to do a named query with select from multiple database connection? --- ## [How to resize vision root container to exact size](https://forum.inductiveautomation.com/t/how-to-resize-vision-root-container-to-exact-size/53494)
**Author:** [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\ **Replies:** 1\ **Last updated:** [November 26, 2021, 4:03pm UTC](https://forum.inductiveautomation.com/t/how-to-resize-vision-root-container-to-exact-size/53494 "2021-11-26T16:03:29Z")
Hi it could be noobie question, but for years I still couldn’t find a proper way to resize the vision root container to exact size, for example: 1336\*768. Please advise. --- ## [OPC UA - Device simulator program adds a digit to the values once save button clicked](https://forum.inductiveautomation.com/t/opc-ua-device-simulator-program-adds-a-digit-to-the-values-once-save-button-clicked/53484)
**Author:** [@RC23](https://forum.inductiveautomation.com/u/RC23)\ **Replies:** 1\ **Last updated:** [November 26, 2021, 3:36pm UTC](https://forum.inductiveautomation.com/t/opc-ua-device-simulator-program-adds-a-digit-to-the-values-once-save-button-clicked/53484 "2021-11-26T15:36:49Z")
Hi there, I am going through the elective course “Building in Perspective” and noticed that the tank capacity was around 4931.00 instead of 49.31 so I checked the OPC UA connection for the simulator and played around wi… --- ## [\[FEATURE\] Convert UDT instance into standard tags](https://forum.inductiveautomation.com/t/feature-convert-udt-instance-into-standard-tags/53478)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 1\ **Last updated:** [November 26, 2021, 3:27pm UTC](https://forum.inductiveautomation.com/t/feature-convert-udt-instance-into-standard-tags/53478 "2021-11-26T15:27:49Z")
I have a UDT instance that I realise I don’t want to be a UDT anymore since there will be too many variations to its instances. Of course, copying the json of UDT instances doesn’t include with it any of the tag config a… --- ## [How things work - the life of the screen](https://forum.inductiveautomation.com/t/how-things-work-the-life-of-the-screen/52419)
**Author:** [@hewking32](https://forum.inductiveautomation.com/u/hewking32)\ **Replies:** 4\ **Last updated:** [November 26, 2021, 2:22pm UTC](https://forum.inductiveautomation.com/t/how-things-work-the-life-of-the-screen/52419 "2021-11-26T14:22:17Z")
hi all I have a screen which is swapped to the second screen but the first screen does not seem to be destroyed because when navigating back it seems like everything is exactly as it was left. I have concerns however th… --- ## [I can not make the barcode visible when i click the button, Need solution in scripting](https://forum.inductiveautomation.com/t/i-can-not-make-the-barcode-visible-when-i-click-the-button-need-solution-in-scripting/53486)
**Author:** [@Atanu\_Sanyal](https://forum.inductiveautomation.com/u/Atanu_Sanyal)\ **Replies:** 1\ **Last updated:** [November 26, 2021, 12:18pm UTC](https://forum.inductiveautomation.com/t/i-can-not-make-the-barcode-visible-when-i-click-the-button-need-solution-in-scripting/53486 "2021-11-26T12:18:00Z")
Hello,I need some assistance regarding the below point i want to make the barcode visible when i click the button, can anybody help me to solve this problem, I am new in this platform, barcode is having visibility param… --- ## [Unable to view Perspective inside Iframe or Object tag in HTML](https://forum.inductiveautomation.com/t/unable-to-view-perspective-inside-iframe-or-object-tag-in-html/44947)
**Author:** [@nimer](https://forum.inductiveautomation.com/u/nimer)\ **Replies:** 2\ **Last updated:** [November 26, 2021, 7:41am UTC](https://forum.inductiveautomation.com/t/unable-to-view-perspective-inside-iframe-or-object-tag-in-html/44947 "2021-11-26T07:41:42Z")
Hi, I am trying to integrate Perspective view inside an HTML5 Iframe tag and Object tag. i have edited the X\_frame policies and am able to view the Perspective loading screen. However, I am unable to see anything other … --- ## [Recommendation for MQTT Edge Device](https://forum.inductiveautomation.com/t/recommendation-for-mqtt-edge-device/41227)
**Author:** [@ddurant](https://forum.inductiveautomation.com/u/ddurant)\ **Replies:** 14\ **Last updated:** [November 26, 2021, 6:21am UTC](https://forum.inductiveautomation.com/t/recommendation-for-mqtt-edge-device/41227 "2021-11-26T06:21:29Z")
Does anyone have a recommendation for a MQTT edge device? We looked at the Moxa one and weren’t real thrilled about its capabilities. Thanks, --- ## [Perspective on Android tablet in Kiosk mode](https://forum.inductiveautomation.com/t/perspective-on-android-tablet-in-kiosk-mode/53479)
**Author:** [@Sam.Taylor](https://forum.inductiveautomation.com/u/Sam.Taylor)\ **Replies:** 0\ **Last updated:** [November 26, 2021, 3:32am UTC](https://forum.inductiveautomation.com/t/perspective-on-android-tablet-in-kiosk-mode/53479 "2021-11-26T03:32:55Z")
Hi, I want to run Perspective workstation as a kiosk on an android tablet. I have achieved this via scripting on the most part (system.perspective.workstation.toKiosk()) however I would ideally like to run the app autom… --- ## [Invalid Key Perspective Binding](https://forum.inductiveautomation.com/t/invalid-key-perspective-binding/53474)
**Author:** [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\ **Replies:** 1\ **Last updated:** [November 25, 2021, 11:09pm UTC](https://forum.inductiveautomation.com/t/invalid-key-perspective-binding/53474 "2021-11-25T23:09:27Z")
Hello all, I am using a flex repeater in my perspective project and I bound the instance to a named query. What should be the return format of the instance? Is it json? If yes, I get an invalid key error on json. I a… --- ## [Binding to custom session object key and then referencing produces Bad\_Stale quality](https://forum.inductiveautomation.com/t/binding-to-custom-session-object-key-and-then-referencing-produces-bad-stale-quality/53475)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 0\ **Last updated:** [November 25, 2021, 9:48pm UTC](https://forum.inductiveautomation.com/t/binding-to-custom-session-object-key-and-then-referencing-produces-bad-stale-quality/53475 "2021-11-25T21:48:12Z")
v8.1.5 I created a custom session prop which was an object for e.g. session.custom.thing = { 'param1': 1, 'param2': 2 } When I bound session.custom.thing to a View custom prop and then bound another custom prop to r… --- ## [Moving Window Average Alarms](https://forum.inductiveautomation.com/t/moving-window-average-alarms/49286)
**Author:** [@sahil.jain](https://forum.inductiveautomation.com/u/sahil.jain)\ **Replies:** 5\ **Last updated:** [November 25, 2021, 9:06pm UTC](https://forum.inductiveautomation.com/t/moving-window-average-alarms/49286 "2021-11-25T21:06:50Z")
Hi, I have some tags being populated from a device. I would like to create various moving window average based alarms - e.g. if the average value in the past n minutes is outside some setpoints, raise an alarm. I’m lo… --- ## [Perspective dynamic Navigation tree build](https://forum.inductiveautomation.com/t/perspective-dynamic-navigation-tree-build/39394)
**Author:** [@Arnaud\_Declerck](https://forum.inductiveautomation.com/u/Arnaud_Declerck)\ **Replies:** 5\ **Last updated:** [November 25, 2021, 7:38pm UTC](https://forum.inductiveautomation.com/t/perspective-dynamic-navigation-tree-build/39394 "2021-11-25T19:38:13Z")
Hi, is there a way to build dinamically the navigation tree in function of a folder structure or tag string into perspective ? regards --- ## [Get Value result from a bound SetpointA in OPC tag Alarm](https://forum.inductiveautomation.com/t/get-value-result-from-a-bound-setpointa-in-opc-tag-alarm/53450)
**Author:** [@Bradley\_Maxted](https://forum.inductiveautomation.com/u/Bradley_Maxted)\ **Replies:** 3\ **Last updated:** [November 25, 2021, 7:16pm UTC](https://forum.inductiveautomation.com/t/get-value-result-from-a-bound-setpointa-in-opc-tag-alarm/53450 "2021-11-25T19:16:06Z")
I have an OPC tag measuring Vibration from 0 - 3. The high alarm setpoint is defined in a PLC as 1, but can be modified. I’m passing the high alarm setpoint into ignition as a separate OPC tag, and binding the value of… --- ## [Disable bindings onStartUp](https://forum.inductiveautomation.com/t/disable-bindings-onstartup/53466)
**Author:** [@flavien](https://forum.inductiveautomation.com/u/flavien)\ **Replies:** 2\ **Last updated:** [November 25, 2021, 5:24pm UTC](https://forum.inductiveautomation.com/t/disable-bindings-onstartup/53466 "2021-11-25T17:24:03Z")
Hi, Is it possible to disable bindings on view StartUp ? I’ve created a view which shows a popup message when “aggDatasets.dev1” variable is empty and linked with payload param. Payload depends on user choice. On sta… --- ## [Docked Window Size not correct on Client with Vision](https://forum.inductiveautomation.com/t/docked-window-size-not-correct-on-client-with-vision/30455)
**Author:** [@tmahaffey](https://forum.inductiveautomation.com/u/tmahaffey)\ **Replies:** 3\ **Last updated:** [March 6, 2020, 12:00am UTC](https://forum.inductiveautomation.com/t/docked-window-size-not-correct-on-client-with-vision/30455 "2020-03-06T00:00:04Z")
I’m having a hard time figuring out why my docked window’s size isn’t adjusting its size as I open up the client. The main screen seems to be scaling correctly. I don’t understand why the buttons on my docked window are … --- ## [Best Place for a script to manipulate Tag values](https://forum.inductiveautomation.com/t/best-place-for-a-script-to-manipulate-tag-values/53465)
**Author:** [@ihtus\_ihtus](https://forum.inductiveautomation.com/u/ihtus_ihtus)\ **Replies:** 3\ **Last updated:** [November 25, 2021, 3:46pm UTC](https://forum.inductiveautomation.com/t/best-place-for-a-script-to-manipulate-tag-values/53465 "2021-11-25T15:46:14Z")
Where is the best place for “Black Box Script” ? --- ## [\[BUG-2715\] searchable Dropdown stays focussed after selecting other dropdowns/textfield](https://forum.inductiveautomation.com/t/bug-2715-searchable-dropdown-stays-focussed-after-selecting-other-dropdowns-textfield/50261)
**Author:** [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\ **Replies:** 6\ **Last updated:** [November 25, 2021, 12:20pm UTC](https://forum.inductiveautomation.com/t/bug-2715-searchable-dropdown-stays-focussed-after-selecting-other-dropdowns-textfield/50261 "2021-11-25T12:20:28Z")
In perspective, When i select a couple of dropdowns in a row and then go to a text field and type something, the text gets typed in the searchable dropdowns. Showing off some really odd behavior. i type in ‘df’ (some ra… --- ## [Hourly aggregates Historian/Transaction group/script](https://forum.inductiveautomation.com/t/hourly-aggregates-historian-transaction-group-script/53278)
**Author:** [@IA\_old\_forum](https://forum.inductiveautomation.com/u/IA_old_forum)\ **Replies:** 5\ **Last updated:** [November 25, 2021, 12:13pm UTC](https://forum.inductiveautomation.com/t/hourly-aggregates-historian-transaction-group-script/53278 "2021-11-25T12:13:47Z")
Hello everyone! I am trying to aggregate the number of errors for 1 hour intervals in the following way: under detailing (in the above image) I would like to show in the respective perspective label (the gray boxes n… --- ## [Can bindings be updated dynamically?](https://forum.inductiveautomation.com/t/can-bindings-be-updated-dynamically/53409)
**Author:** [@jacob.mann](https://forum.inductiveautomation.com/u/jacob.mann)\ **Replies:** 6\ **Last updated:** [November 25, 2021, 11:56am UTC](https://forum.inductiveautomation.com/t/can-bindings-be-updated-dynamically/53409 "2021-11-25T11:56:11Z")
Is there a way to dynamically update a series of bindings? What I want to achieve is something similar to a “binding class” that would have a standard definition and be applied to multiple parameters throughout a project… --- ## [While loop script is not working](https://forum.inductiveautomation.com/t/while-loop-script-is-not-working/53390)
**Author:** [@IA\_old\_forum](https://forum.inductiveautomation.com/u/IA_old_forum)\ **Replies:** 16\ **Last updated:** [November 25, 2021, 11:23am UTC](https://forum.inductiveautomation.com/t/while-loop-script-is-not-working/53390 "2021-11-25T11:23:11Z")
Hello, I made a script function counter. it is supposed to check for new instances in which the bool tag turns true. And work as a counter while hourly intervals are active (e.g. when it is 15:00 hrs return the numbe… --- ## [Designer Perspective 'no-project' bug](https://forum.inductiveautomation.com/t/designer-perspective-no-project-bug/53379)
**Author:** [@betti.francesco](https://forum.inductiveautomation.com/u/betti.francesco)\ **Replies:** 0\ **Last updated:** [November 23, 2021, 9:47am UTC](https://forum.inductiveautomation.com/t/designer-perspective-no-project-bug/53379 "2021-11-23T09:47:26Z")
Hello, I’m facing a strange issue on the Perspective designer, the gateway version is 8.1.11, the OS is Linux, Java version 11.0.11+9-LTS. Basically, if I try to open a view inside a folder, the view won’t be opened, in… --- ## [\[Bug\] Carousel height issues with Workstation](https://forum.inductiveautomation.com/t/bug-carousel-height-issues-with-workstation/52882)
**Author:** [@catherine.fowler](https://forum.inductiveautomation.com/u/catherine.fowler)\ **Replies:** 1\ **Last updated:** [November 25, 2021, 4:46am UTC](https://forum.inductiveautomation.com/t/bug-carousel-height-issues-with-workstation/52882 "2021-11-25T04:46:46Z")
I found an issue where a carousel component got squished when displaying on Workstation but displayed fine in a browser (left view is launched as windowed in Workstation, right is opened in Chrome): I would expect it… --- ## [\[FEATURE\] Perspective - Add pixel position props for percent-mode coord container components](https://forum.inductiveautomation.com/t/feature-perspective-add-pixel-position-props-for-percent-mode-coord-container-components/48812)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 1\ **Last updated:** [November 25, 2021, 3:39am UTC](https://forum.inductiveautomation.com/t/feature-perspective-add-pixel-position-props-for-percent-mode-coord-container-components/48812 "2021-11-25T03:39:24Z")
Most of the time I want to use percent mode for P&ID layouts and device symbols etc. however I will invariably always convert the mode to fixed in order to be able to actually work on these Views, as working with it in p… --- ## [Perspective Workstation goes blank after loading homepage](https://forum.inductiveautomation.com/t/perspective-workstation-goes-blank-after-loading-homepage/53456)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 0\ **Last updated:** [November 25, 2021, 1:38am UTC](https://forum.inductiveautomation.com/t/perspective-workstation-goes-blank-after-loading-homepage/53456 "2021-11-25T01:38:07Z")
When I startup a Perspective Workstation session, it shows the loading screen, launches the homepage, then a few moments later it shows this: Any ideas? Edit: Actually it only happens when I open a particular page … --- ## [Perspective Property Editor always messes up the order of objects lists](https://forum.inductiveautomation.com/t/perspective-property-editor-always-messes-up-the-order-of-objects-lists/53454)
**Author:** [@ToMakPo](https://forum.inductiveautomation.com/u/ToMakPo)\ **Replies:** 2\ **Last updated:** [November 24, 2021, 11:37pm UTC](https://forum.inductiveautomation.com/t/perspective-property-editor-always-messes-up-the-order-of-objects-lists/53454 "2021-11-24T23:37:36Z")
Why does the order of the items in an object list always get messed up? For example, in this list of items, it’s supposed to be node0, node1, node2; but it changed it to node2, node0, node1. If it took my list that wa… --- ## [Error Launching Application/ Validation Exception](https://forum.inductiveautomation.com/t/error-launching-application-validation-exception/53453)
**Author:** [@Ros\_Alexander](https://forum.inductiveautomation.com/u/Ros_Alexander)\ **Replies:** 0\ **Last updated:** [November 24, 2021, 8:49pm UTC](https://forum.inductiveautomation.com/t/error-launching-application-validation-exception/53453 "2021-11-24T20:49:00Z")
I updated my pc and now I’m getting an error. Any thoughts? --- ## [Conditional formatting in table](https://forum.inductiveautomation.com/t/conditional-formatting-in-table/53449)
**Author:** [@ntheuer](https://forum.inductiveautomation.com/u/ntheuer)\ **Replies:** 2\ **Last updated:** [November 24, 2021, 8:35pm UTC](https://forum.inductiveautomation.com/t/conditional-formatting-in-table/53449 "2021-11-24T20:35:35Z")
So I can see where I want the data to go, and I feel like I got started in the right direction, but I cannot get my transform to name those index values (\[‘Facility’, ‘SectionName’, ‘Etc’\] instead of \[0,1,2\]) Can you pl… --- ## [Banner with moving text/characters](https://forum.inductiveautomation.com/t/banner-with-moving-text-characters/53447)
**Author:** [@sathianandan.dharmas](https://forum.inductiveautomation.com/u/sathianandan.dharmas)\ **Replies:** 2\ **Last updated:** [November 24, 2021, 8:08pm UTC](https://forum.inductiveautomation.com/t/banner-with-moving-text-characters/53447 "2021-11-24T20:08:03Z")
Hi All Is it possible to create a horizontal banner (in vision) like the attached image where I can move the text from right to left and keep it rolling as in like a news channel? I’m trying to display some data but ma… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=925) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=927)