# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1396 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1397 --- ## [Bug? - Drop down box not accepting scroll wheel input?](https://forum.inductiveautomation.com/t/bug-drop-down-box-not-accepting-scroll-wheel-input/32467)
**Author:** [@grietveld](https://forum.inductiveautomation.com/u/grietveld)\ **Replies:** 1\ **Last updated:** [March 2, 2020, 6:05pm UTC](https://forum.inductiveautomation.com/t/bug-drop-down-box-not-accepting-scroll-wheel-input/32467 "2020-03-02T18:05:11Z")
I’m not sure if I just didn’t notice it when I was building in 8.0.7, but I’m noticing after I upgraded to 8.0.8, that the drop down box in perspective doesn’t seem to allow me to use the scroll wheel to go through the l… --- ## [Power Table whiting out text for no discernable reason?](https://forum.inductiveautomation.com/t/power-table-whiting-out-text-for-no-discernable-reason/32734)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 4\ **Last updated:** [March 2, 2020, 3:57pm UTC](https://forum.inductiveautomation.com/t/power-table-whiting-out-text-for-no-discernable-reason/32734 "2020-03-02T15:57:16Z")
A odd aesthetic issue I have with a power table I use to let people select items off with a checkbox, occasionally the text columns text goes white and multipel rows will be affected, though I can’t discern any determini… --- ## [Perspective :: How to init SESSION CUSTOM vars on startup session?](https://forum.inductiveautomation.com/t/perspective-how-to-init-session-custom-vars-on-startup-session/32557)
**Author:** [@beaudoin.stephane](https://forum.inductiveautomation.com/u/beaudoin.stephane)\ **Replies:** 6\ **Last updated:** [March 2, 2020, 3:53pm UTC](https://forum.inductiveautomation.com/t/perspective-how-to-init-session-custom-vars-on-startup-session/32557 "2020-03-02T15:53:57Z")
Hi, I am working in perspective. I have several session custom that I want them to be initialized on the first run (session start). ie: session.custom.pot\_table\_view.limit\_param However, If I set this session\_custom … --- ## [Tab Container memory usage](https://forum.inductiveautomation.com/t/tab-container-memory-usage/32714)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 1\ **Last updated:** [March 2, 2020, 3:52pm UTC](https://forum.inductiveautomation.com/t/tab-container-memory-usage/32714 "2020-03-02T15:52:01Z")
Hello I’d like to use tab container for my plant which include 20 P&ID pages. Other method is to use horizantal menu item with 20 separate Page configuration for each P&ID diagram. If I want to compare tab container wi… --- ## [Ignition/beckhoff High Speed Communications](https://forum.inductiveautomation.com/t/ignition-beckhoff-high-speed-communications/32729)
**Author:** [@gregsachs](https://forum.inductiveautomation.com/u/gregsachs)\ **Replies:** 1\ **Last updated:** [March 2, 2020, 2:58pm UTC](https://forum.inductiveautomation.com/t/ignition-beckhoff-high-speed-communications/32729 "2020-03-02T14:58:42Z")
I’m trying to design an Ignition solution for connecting to Beckhoff PLCS. Co-workers of mine have written custom code for the Beckhoff that implements the Siemens RFC1006 FC5/FC6 message protocol, claiming to be able t… --- ## [Transform a column in a Perspective table](https://forum.inductiveautomation.com/t/transform-a-column-in-a-perspective-table/32617)
**Author:** [@winbetho](https://forum.inductiveautomation.com/u/winbetho)\ **Replies:** 2\ **Last updated:** [March 2, 2020, 11:34am UTC](https://forum.inductiveautomation.com/t/transform-a-column-in-a-perspective-table/32617 "2020-03-02T11:34:39Z")
Hi all! In Perspective, how do I transform a value to a string in a table? So the 0 will be “Bad” etc etc. I basicly know how to use the transform binding but i don’t understand how to pass the correct value to the tr… --- ## [SQL query in script - custom property error](https://forum.inductiveautomation.com/t/sql-query-in-script-custom-property-error/32691)
**Author:** [@john.eichler](https://forum.inductiveautomation.com/u/john.eichler)\ **Replies:** 7\ **Last updated:** [March 2, 2020, 1:42am UTC](https://forum.inductiveautomation.com/t/sql-query-in-script-custom-property-error/32691 "2020-03-02T01:42:54Z")
Hi All I have written a short script which builds an SQL query and displays the results in a table. This works fine when I hardcode the full name of the table into the script. However, when I set this up with a custom p… --- ## [Evaluation order of RC components, tag / SQL bindings](https://forum.inductiveautomation.com/t/evaluation-order-of-rc-components-tag-sql-bindings/32647)
**Author:** [@richardNZ15](https://forum.inductiveautomation.com/u/richardNZ15)\ **Replies:** 5\ **Last updated:** [March 1, 2020, 10:38pm UTC](https://forum.inductiveautomation.com/t/evaluation-order-of-rc-components-tag-sql-bindings/32647 "2020-03-01T22:38:00Z")
Hi, I have a fairly simple template i’ve tried to build, but its proving quite complicated to get it to work reliably. I have a combination of Root Container custom properties, bindings to standard components, bindings… --- ## [Reporting - how to get multiple data keys in table details? Also calculations for nested queries?](https://forum.inductiveautomation.com/t/reporting-how-to-get-multiple-data-keys-in-table-details-also-calculations-for-nested-queries/32711)
**Author:** [@rpavlicek](https://forum.inductiveautomation.com/u/rpavlicek)\ **Replies:** 11\ **Last updated:** [March 1, 2020, 6:54pm UTC](https://forum.inductiveautomation.com/t/reporting-how-to-get-multiple-data-keys-in-table-details-also-calculations-for-nested-queries/32711 "2020-03-01T18:54:54Z")
As nice as some things are in the reporting, I’ve been struggling with getting some important things accomplished to finish a single report. We have a report where we are using a single data source that first uses a SQL… --- ## [Add data to historian](https://forum.inductiveautomation.com/t/add-data-to-historian/32720)
**Author:** [@roinisan](https://forum.inductiveautomation.com/u/roinisan)\ **Replies:** 1\ **Last updated:** [March 1, 2020, 2:36pm UTC](https://forum.inductiveautomation.com/t/add-data-to-historian/32720 "2020-03-01T14:36:03Z")
Hello, I created some new tags and saved their data using the historian. and when I try to see the data it works just fine. I have data of this tags before I created them in the ignition - in access and I want to add… --- ## [Edge Historian Trending](https://forum.inductiveautomation.com/t/edge-historian-trending/32606)
**Author:** [@Dmart](https://forum.inductiveautomation.com/u/Dmart)\ **Replies:** 5\ **Last updated:** [March 1, 2020, 2:35am UTC](https://forum.inductiveautomation.com/t/edge-historian-trending/32606 "2020-03-01T02:35:15Z")
Currently designing a couple systems for a customer on my development machine. Using Ignition Edge 7.9.13 on Win10. Working on my trending screen and I have things getting pretty close to where I want them. Thanks to … --- ## ["Copy to/Paste from clipboard" limit? Tree View component](https://forum.inductiveautomation.com/t/copy-to-paste-from-clipboard-limit-tree-view-component/32719)
**Author:** [@kpswiney](https://forum.inductiveautomation.com/u/kpswiney)\ **Replies:** 2\ **Last updated:** [March 1, 2020, 1:27am UTC](https://forum.inductiveautomation.com/t/copy-to-paste-from-clipboard-limit-tree-view-component/32719 "2020-03-01T01:27:26Z")
Does anybody know if there is a clipboard limit on pasting to the Tree View component’s Items property? I am trying to paste a dataset configuration to that property and only the first 50 rows will transfer while my data… --- ## [Drop down in Power Table cell not working](https://forum.inductiveautomation.com/t/drop-down-in-power-table-cell-not-working/32162)
**Author:** [@Neo](https://forum.inductiveautomation.com/u/Neo)\ **Replies:** 6\ **Last updated:** [February 29, 2020, 1:14pm UTC](https://forum.inductiveautomation.com/t/drop-down-in-power-table-cell-not-working/32162 "2020-02-29T13:14:19Z")
I am trying to get the Power Table cell to show the drop down with multiple options. After going through few topics I found that it can be achieved using configureEditor extension function and Power Table already has the… --- ## [Leased scan class on tags using binEnum()](https://forum.inductiveautomation.com/t/leased-scan-class-on-tags-using-binenum/32712)
**Author:** [@chelton](https://forum.inductiveautomation.com/u/chelton)\ **Replies:** 2\ **Last updated:** [February 29, 2020, 3:32am UTC](https://forum.inductiveautomation.com/t/leased-scan-class-on-tags-using-binenum/32712 "2020-02-29T03:32:01Z")
I have an object on a template I change the colour on depending on 4 tags Alarm/Starting/Stopping/Running I created a custom property called Status with an expression binding binEnum(tag("edge") + {Pump.Device\_ID} + "/… --- ## [Webdev and Excel or CSV download](https://forum.inductiveautomation.com/t/webdev-and-excel-or-csv-download/32646)
**Author:** [@David.Reed.Schmidt](https://forum.inductiveautomation.com/u/David.Reed.Schmidt)\ **Replies:** 4\ **Last updated:** [February 29, 2020, 12:12am UTC](https://forum.inductiveautomation.com/t/webdev-and-excel-or-csv-download/32646 "2020-02-29T00:12:05Z")
How can I use the webdev module to export an excel or csv to the perspective client? Its a common scenario. I have a perspective client with a button on it. There is a DB back end to the Ignition server. The customer wa… --- ## [Moving to redundant gateways](https://forum.inductiveautomation.com/t/moving-to-redundant-gateways/32678)
**Author:** [@wpmccormick](https://forum.inductiveautomation.com/u/wpmccormick)\ **Replies:** 2\ **Last updated:** [February 28, 2020, 11:21pm UTC](https://forum.inductiveautomation.com/t/moving-to-redundant-gateways/32678 "2020-02-28T23:21:48Z")
I’m working on an installation where there are 2 Ignition systems, both Windows, and each at different points along the road of commissioning. The first system (we’ll call it Sub-system) is mostly finished (designed, pro… --- ## [\[Bug-16011\]8.0.8 Perspective - Margins missing in styles](https://forum.inductiveautomation.com/t/bug-16011-8-0-8-perspective-margins-missing-in-styles/32192)
**Author:** [@grietveld](https://forum.inductiveautomation.com/u/grietveld)\ **Replies:** 13\ **Last updated:** [February 28, 2020, 9:59pm UTC](https://forum.inductiveautomation.com/t/bug-16011-8-0-8-perspective-margins-missing-in-styles/32192 "2020-02-28T21:59:35Z")
I installed 8.0.8 release this morning, and I am noticing that all of my styles no longer have margin options and the option is removed from the editor. Is this intentional? If so, what is the best way to add spacing bet… --- ## [LDAP - Role Search Filter](https://forum.inductiveautomation.com/t/ldap-role-search-filter/32707)
**Author:** [@dan123](https://forum.inductiveautomation.com/u/dan123)\ **Replies:** 0\ **Last updated:** [February 28, 2020, 9:32pm UTC](https://forum.inductiveautomation.com/t/ldap-role-search-filter/32707 "2020-02-28T21:32:56Z")
I have a project with AD integration, but it’s connected to a very large directory, and it appears that it is causing my designer session to lag. I’d like to try filtering for only the groups that require Ignition access… --- ## [Force MQTT Publish of Certain Tags](https://forum.inductiveautomation.com/t/force-mqtt-publish-of-certain-tags/32705)
**Author:** [@breckenridge.boven](https://forum.inductiveautomation.com/u/breckenridge.boven)\ **Replies:** 0\ **Last updated:** [February 28, 2020, 8:56pm UTC](https://forum.inductiveautomation.com/t/force-mqtt-publish-of-certain-tags/32705 "2020-02-28T20:56:34Z")
I am using the MQTT Transmission module to transfer data to the and external system. We have some boolean tags that rarely change, maybe once every 2 months, but it is important that a sparkplug B message with that value… --- ## [AdHoc Trend Template Error](https://forum.inductiveautomation.com/t/adhoc-trend-template-error/20349)
**Author:** [@erikburns](https://forum.inductiveautomation.com/u/erikburns)\ **Replies:** 12\ **Last updated:** [February 28, 2020, 8:54pm UTC](https://forum.inductiveautomation.com/t/adhoc-trend-template-error/20349 "2020-02-28T20:54:35Z")
I am trying to use the AdHoc Trend Template, and the existing script will not create the tables in my database. I get the following error. File "\", line 17, in \ File "\ **Author:** [@Dan\_Bridgeman](https://forum.inductiveautomation.com/u/Dan_Bridgeman)\ **Replies:** 2\ **Last updated:** [February 28, 2020, 7:55pm UTC](https://forum.inductiveautomation.com/t/hide-or-remove-perspective-sign-out-and-status-footer/32704 "2020-02-28T19:55:38Z") Is it possible to completely hide or remove the little footer which is always there when you open a Perspective view in your browser? Even when it is minimized it still sits on top of whatever component is in the bottom… --- ## [I'm getting session.onShutdown errors in log. But, I've never made one?](https://forum.inductiveautomation.com/t/im-getting-session-onshutdown-errors-in-log-but-ive-never-made-one/32307)
**Author:** [@wking](https://forum.inductiveautomation.com/u/wking)\ **Replies:** 9\ **Last updated:** [February 28, 2020, 6:00pm UTC](https://forum.inductiveautomation.com/t/im-getting-session-onshutdown-errors-in-log-but-ive-never-made-one/32307 "2020-02-28T18:00:55Z")
It is telling me it’s on view: view=Page/Embedded/Cards/machine home card@C$0:0\[8\]\*\*, project-name=CMM But, there is no shutdown evet on this view. How do I figure out where this is coming from? INFO | jvm 1 | 202… --- ## [Unique Component Identifier](https://forum.inductiveautomation.com/t/unique-component-identifier/32700)
**Author:** [@hachjessed](https://forum.inductiveautomation.com/u/hachjessed)\ **Replies:** 4\ **Last updated:** [February 28, 2020, 6:09pm UTC](https://forum.inductiveautomation.com/t/unique-component-identifier/32700 "2020-02-28T18:09:30Z")
Is there a unique value/identifier related to each component instance within a project or projects? --- ## [How can use MEAN(average) aggregates filter value?](https://forum.inductiveautomation.com/t/how-can-use-mean-average-aggregates-filter-value/32687)
**Author:** [@soontosr](https://forum.inductiveautomation.com/u/soontosr)\ **Replies:** 5\ **Last updated:** [February 28, 2020, 5:27pm UTC](https://forum.inductiveautomation.com/t/how-can-use-mean-average-aggregates-filter-value/32687 "2020-02-28T17:27:12Z")
how can use MEAN aggregates filter value? Ex. Mean Weight \> 2.0 that. Mean 3 row., row is value “1.287” not Mean ProductCode Quantity Weight BAN\_002 380 3.243 BAN\_010 120 9.928 APL\_000 125 1.287 FWL\_220 3… --- ## [How to pass a table name parameter to named query?](https://forum.inductiveautomation.com/t/how-to-pass-a-table-name-parameter-to-named-query/32689)
**Author:** [@pdixon](https://forum.inductiveautomation.com/u/pdixon)\ **Replies:** 6\ **Last updated:** [February 28, 2020, 5:14pm UTC](https://forum.inductiveautomation.com/t/how-to-pass-a-table-name-parameter-to-named-query/32689 "2020-02-28T17:14:18Z")
I am trying to pass in the name of a table to a named query, If I hard code the table name in the query it works, but when I pass in the name as a parameter I get a syntax error. Any ideas? --- ## [\[14261\] \[System\]Client/System/EditCount is not present in 8.0.3](https://forum.inductiveautomation.com/t/14261-system-client-system-editcount-is-not-present-in-8-0-3/25977)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 8\ **Last updated:** [February 28, 2020, 3:07pm UTC](https://forum.inductiveautomation.com/t/14261-system-client-system-editcount-is-not-present-in-8-0-3/25977 "2020-02-28T15:07:39Z")
@PGriffith When migrationg from 7.9.11 to Ignition 8.0.3-nightly the tag \[System\]Client/System/EditCount doesn’t exist in 8.0.3. is it intentional or a bug ? --- ## [\[SOLVED\] Gracefully exit a system.db.runPrepQuery or system.db.runPrepUpdate script statement](https://forum.inductiveautomation.com/t/solved-gracefully-exit-a-system-db-runprepquery-or-system-db-runprepupdate-script-statement/32695)
**Author:** [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Replies:** 3\ **Last updated:** [February 28, 2020, 2:50pm UTC](https://forum.inductiveautomation.com/t/solved-gracefully-exit-a-system-db-runprepquery-or-system-db-runprepupdate-script-statement/32695 "2020-02-28T14:50:32Z")
Is there a way to gracefully exit a function if some type of SQL statement fails such as runPrepQuery or runPrepUpdate? I am getting errors sometimes due to database primary keys/foreign key relationships and I don’t wan… --- ## [User Scroll Bar Hide for Text Area](https://forum.inductiveautomation.com/t/user-scroll-bar-hide-for-text-area/26674)
**Author:** [@tbraun](https://forum.inductiveautomation.com/u/tbraun)\ **Replies:** 2\ **Last updated:** [February 28, 2020, 2:50pm UTC](https://forum.inductiveautomation.com/t/user-scroll-bar-hide-for-text-area/26674 "2020-02-28T14:50:06Z")
I’m tying to have a label that wraps text. How can I do this? If I use a text area, how can I hide the scroll bar? If I write this in the script console, it briefly hides it but then it gets overridden: txt = system.g… --- ## [Problems with a S71200 adressing syntax](https://forum.inductiveautomation.com/t/problems-with-a-s71200-adressing-syntax/32668)
**Author:** [@patricia.mendez](https://forum.inductiveautomation.com/u/patricia.mendez)\ **Replies:** 6\ **Last updated:** [February 28, 2020, 2:48pm UTC](https://forum.inductiveautomation.com/t/problems-with-a-s71200-adressing-syntax/32668 "2020-02-28T14:48:53Z")
Dear supporters, could you please help me with the syntax I have to use inside the Tag Editor window for a S7 1200? – I have already connected to the device and this is fine. This step is successfully completed. – Now… --- ## [Connect Ignition to RSLinx Emulate 5000 or Studio 5000 Logix Emulate](https://forum.inductiveautomation.com/t/connect-ignition-to-rslinx-emulate-5000-or-studio-5000-logix-emulate/32696)
**Author:** [@bryan.rivera](https://forum.inductiveautomation.com/u/bryan.rivera)\ **Replies:** 1\ **Last updated:** [February 28, 2020, 2:20pm UTC](https://forum.inductiveautomation.com/t/connect-ignition-to-rslinx-emulate-5000-or-studio-5000-logix-emulate/32696 "2020-02-28T14:20:05Z")
How to connect the Ignition OPC server to a Emulator of Rockwell [Previous page](https://forum.inductiveautomation.com/latest.md?page=1395) [Next page](https://forum.inductiveautomation.com/latest.md?page=1397)