# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1936 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1937 --- ## [Prefix property for numeric texts boxes](https://forum.inductiveautomation.com/t/prefix-property-for-numeric-texts-boxes/5142)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 0\ **Last updated:** [September 13, 2012, 6:46pm UTC](https://forum.inductiveautomation.com/t/prefix-property-for-numeric-texts-boxes/5142 "2012-09-13T18:46:56Z")
I see suffix..Can I get a prefix? --- ## [Looping through all Client tags](https://forum.inductiveautomation.com/t/looping-through-all-client-tags/5124)
**Author:** [@paul.prescott](https://forum.inductiveautomation.com/u/paul.prescott)\ **Replies:** 5\ **Last updated:** [September 13, 2012, 6:30pm UTC](https://forum.inductiveautomation.com/t/looping-through-all-client-tags/5124 "2012-09-13T18:30:10Z")
Is it possible to loop through all Client tags (in Python scripting) without using the name of each tag. I expect it would be something like: for individualTag in {Collection of all Client Tags} : ... However, I … --- ## [Capture Tree View State](https://forum.inductiveautomation.com/t/capture-tree-view-state/5138)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 3\ **Last updated:** [September 13, 2012, 6:01pm UTC](https://forum.inductiveautomation.com/t/capture-tree-view-state/5138 "2012-09-13T18:01:37Z")
Is there a tree view property I can capture that holds the state of which nodes are expanded? I have a tab and tree navigation setup i am working on and when I switch between tabs the tree item data changes. when i swi… --- ## [Eventchange for spinner](https://forum.inductiveautomation.com/t/eventchange-for-spinner/5125)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 5\ **Last updated:** [September 13, 2012, 4:03pm UTC](https://forum.inductiveautomation.com/t/eventchange-for-spinner/5125 "2012-09-13T16:03:56Z")
Is there any way of 'Knowing' whether the buttons are held down on or something so that I can call a script for the event? Right now I have this: if event.propertyName == "intValue": event.source.active = 1 else… --- ## [Tree View Control Item Order](https://forum.inductiveautomation.com/t/tree-view-control-item-order/5075)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 3\ **Last updated:** [September 12, 2012, 9:19pm UTC](https://forum.inductiveautomation.com/t/tree-view-control-item-order/5075 "2012-09-12T21:19:01Z")
Is there a way to control the order items are displayed in the tree view component? I have unchecked the Auto Sort property, but it still is sorting alphabetically by the path. Thank you, --- ## [Pdf orientation](https://forum.inductiveautomation.com/t/pdf-orientation/4868)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 31\ **Last updated:** [September 12, 2012, 9:11pm UTC](https://forum.inductiveautomation.com/t/pdf-orientation/4868 "2012-09-12T21:11:29Z")
In both landscape and portrait orientations of pdfs, The viewer will only give me a portrait view. How can I get a wideview? --- ## [Scripting Module](https://forum.inductiveautomation.com/t/scripting-module/5136)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 0\ **Last updated:** [September 12, 2012, 7:40pm UTC](https://forum.inductiveautomation.com/t/scripting-module/5136 "2012-09-12T19:40:56Z")
Oh, W :open\_mouth: W Dynamically creating tags on the fly. The possibilities for ignition just took a huge leap to toward infinity. --- ## [Comments Panel](https://forum.inductiveautomation.com/t/comments-panel/5129)
**Author:** [@DarrenAsh](https://forum.inductiveautomation.com/u/DarrenAsh)\ **Replies:** 3\ **Last updated:** [September 12, 2012, 4:37pm UTC](https://forum.inductiveautomation.com/t/comments-panel/5129 "2012-09-12T16:37:07Z")
This is a minor issue, but wondering if there is an easy work around. The comments panel "Add Note" and "Cancel" push buttons shift location if you attach a file with a long path name. This can cause the buttons to be… --- ## [Upgrade from V7.2 to V7.5](https://forum.inductiveautomation.com/t/upgrade-from-v7-2-to-v7-5/5132)
**Author:** [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Replies:** 5\ **Last updated:** [September 12, 2012, 2:24pm UTC](https://forum.inductiveautomation.com/t/upgrade-from-v7-2-to-v7-5/5132 "2012-09-12T14:24:16Z")
I will be soon upgrading a Mission Critical application from V7.2 to V7.5. Anyone know of any 'gotcha' that I may encounter? --- ## [Restrict Scripts](https://forum.inductiveautomation.com/t/restrict-scripts/4835)
**Author:** [@SamJaimes](https://forum.inductiveautomation.com/u/SamJaimes)\ **Replies:** 13\ **Last updated:** [September 12, 2012, 2:13pm UTC](https://forum.inductiveautomation.com/t/restrict-scripts/4835 "2012-09-12T14:13:23Z")
Hello, It is possible to resctrict scripting in a project? --- ## [How to check whether Database Transaction completed or not?](https://forum.inductiveautomation.com/t/how-to-check-whether-database-transaction-completed-or-not/5118)
**Author:** [@skallepalli](https://forum.inductiveautomation.com/u/skallepalli)\ **Replies:** 2\ **Last updated:** [September 12, 2012, 11:31am UTC](https://forum.inductiveautomation.com/t/how-to-check-whether-database-transaction-completed-or-not/5118 "2012-09-12T11:31:10Z")
Dear Inductive Team, We need to load multiple datasets in a single Event, one dataset based on another datset result. Example: vDS1 = system.db.runQuery("SELECT \* FROM Table1;") vValue1 = vDS1.getValueAt(2, 0) vDS2… --- ## [Synchronize 2 tables in different databases](https://forum.inductiveautomation.com/t/synchronize-2-tables-in-different-databases/5131)
**Author:** [@jvandeve](https://forum.inductiveautomation.com/u/jvandeve)\ **Replies:** 1\ **Last updated:** [September 11, 2012, 8:08pm UTC](https://forum.inductiveautomation.com/t/synchronize-2-tables-in-different-databases/5131 "2012-09-11T20:08:22Z")
Is there an easy way to compare two tables in different databases and return the difference ? I try to synchronize a SQL server table from IT with a MySQL table on the plant side. When the data changes in the IT table … --- ## [Modbus Addressing in a Data Type Structure](https://forum.inductiveautomation.com/t/modbus-addressing-in-a-data-type-structure/5128)
**Author:** [@email4jab](https://forum.inductiveautomation.com/u/email4jab)\ **Replies:** 0\ **Last updated:** [September 11, 2012, 4:37pm UTC](https://forum.inductiveautomation.com/t/modbus-addressing-in-a-data-type-structure/5128 "2012-09-11T16:37:39Z")
Hello, I'd like to set up a Data Type, reference an address as a parameter (FirstAddress) type Integer and then reference that address with an offset to each tag in the structure. For example if my Data Type was all Bool… --- ## [Individual button disable for multi state button](https://forum.inductiveautomation.com/t/individual-button-disable-for-multi-state-button/5121)
**Author:** [@fledder](https://forum.inductiveautomation.com/u/fledder)\ **Replies:** 1\ **Last updated:** [September 10, 2012, 11:44pm UTC](https://forum.inductiveautomation.com/t/individual-button-disable-for-multi-state-button/5121 "2012-09-10T23:44:47Z")
Is there a way to disable individual buttons on a multi state button object? For example, I am using it for a mode controller, and there are some modes that are not always valid to switch to, depending on some other cond… --- ## [Saving attachments](https://forum.inductiveautomation.com/t/saving-attachments/2617)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 9\ **Last updated:** [September 10, 2012, 8:12pm UTC](https://forum.inductiveautomation.com/t/saving-attachments/2617 "2012-09-10T20:12:51Z")
A system we are developing has as a requirement the saving of file attachments. We are currently saving these as BLOBs in our MySQL database, which works well. However the database is growing in size very quickly, so w… --- ## [Using eclipse to create components](https://forum.inductiveautomation.com/t/using-eclipse-to-create-components/5110)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 12\ **Last updated:** [September 10, 2012, 4:11pm UTC](https://forum.inductiveautomation.com/t/using-eclipse-to-create-components/5110 "2012-09-10T16:11:41Z")
Does anyone do this? I was hoping that I could create a customized component using WindowsBuilder inside of Eclipse to create an object that could be exported to my Ignition project since its Java… --- ## [Column Selector Sequence for DataOut](https://forum.inductiveautomation.com/t/column-selector-sequence-for-dataout/5114)
**Author:** [@mreddy1986](https://forum.inductiveautomation.com/u/mreddy1986)\ **Replies:** 3\ **Last updated:** [September 10, 2012, 3:30pm UTC](https://forum.inductiveautomation.com/t/column-selector-sequence-for-dataout/5114 "2012-09-10T15:30:44Z")
Friends, I am trying to get the columns for a Data set in the order(Sequence) of the columns(check boxes) selected on the Column selector..Can anyone help in this regard... Thanks, Moulee. --- ## [Immediately open an export... and maybe reimport when closed](https://forum.inductiveautomation.com/t/immediately-open-an-export-and-maybe-reimport-when-closed/5122)
**Author:** [@fledder](https://forum.inductiveautomation.com/u/fledder)\ **Replies:** 0\ **Last updated:** [September 8, 2012, 4:39am UTC](https://forum.inductiveautomation.com/t/immediately-open-an-export-and-maybe-reimport-when-closed/5122 "2012-09-08T04:39:03Z")
So here's the first part of the idea: when you do an export, have an option to immediately open that export file in the default .csv editor. Sorta like the download save / open dialog in your favorite web browser. Bigg… --- ## [Canvas with jhplot library](https://forum.inductiveautomation.com/t/canvas-with-jhplot-library/5115)
**Author:** [@Antonio](https://forum.inductiveautomation.com/u/Antonio)\ **Replies:** 2\ **Last updated:** [September 8, 2012, 2:00am UTC](https://forum.inductiveautomation.com/t/canvas-with-jhplot-library/5115 "2012-09-08T02:00:43Z")
Hello I would like to create some nice 3D animations on ingnition. One way that i found is to use Canvas 3D, but all scripts examples are using jhplot library that is not workin on Ignition. There are more ways to ma… --- ## [Export certain columns to excel sheet](https://forum.inductiveautomation.com/t/export-certain-columns-to-excel-sheet/5120)
**Author:** [@tamerplc](https://forum.inductiveautomation.com/u/tamerplc)\ **Replies:** 2\ **Last updated:** [September 7, 2012, 11:22pm UTC](https://forum.inductiveautomation.com/t/export-certain-columns-to-excel-sheet/5120 "2012-09-07T23:22:09Z")
I have this code to export table to excel sheet but i need to export certain column only for example column name 1,2,3,4,7 but no need for column 6 table = event.source.parent.getComponent("AlarmTable") filePath = s… --- ## [Report initial load reportLoading finished but report blank](https://forum.inductiveautomation.com/t/report-initial-load-reportloading-finished-but-report-blank/5084)
**Author:** [@DomArmstrong](https://forum.inductiveautomation.com/u/DomArmstrong)\ **Replies:** 8\ **Last updated:** [September 7, 2012, 10:58pm UTC](https://forum.inductiveautomation.com/t/report-initial-load-reportloading-finished-but-report-blank/5084 "2012-09-07T22:58:54Z")
Having an issue where I am printing multiple reports at a time. I'm using the reportLoading flag to check whether the report is ready to print: \[code\]if event.propertyName == "reportLoading": reportLoading = event.sou… --- ## [Hide Table Column if no values exist](https://forum.inductiveautomation.com/t/hide-table-column-if-no-values-exist/5119)
**Author:** [@jkrugerud](https://forum.inductiveautomation.com/u/jkrugerud)\ **Replies:** 0\ **Last updated:** [September 7, 2012, 5:17pm UTC](https://forum.inductiveautomation.com/t/hide-table-column-if-no-values-exist/5119 "2012-09-07T17:17:56Z")
I am running the following query to populate a table: \[size=85\]\[color=#FF0000\]SELECT \* FROM ( SELECT pvp.MaterialDescription, pvp.CurrentPrice, cb.ShortDesc FROM po\_vendor\_prices\_1270 as pvp JOIN Codes\_Branch as cb … --- ## [How can I make a project display correctly on an iPad 2?](https://forum.inductiveautomation.com/t/how-can-i-make-a-project-display-correctly-on-an-ipad-2/4852)
**Author:** [@tomearp](https://forum.inductiveautomation.com/u/tomearp)\ **Replies:** 11\ **Last updated:** [September 7, 2012, 5:01pm UTC](https://forum.inductiveautomation.com/t/how-can-i-make-a-project-display-correctly-on-an-ipad-2/4852 "2012-09-07T17:01:54Z")
Hello, I'm having some trouble getting a project to display correctly on an iPad 2. I have tried all manner of main window sizes and various combinations of "Fit to Device" and "Start Maximised" etc. etc. No matter w… --- ## [Hiding report layers](https://forum.inductiveautomation.com/t/hiding-report-layers/5104)
**Author:** [@systemparadox](https://forum.inductiveautomation.com/u/systemparadox)\ **Replies:** 2\ **Last updated:** [September 7, 2012, 8:10am UTC](https://forum.inductiveautomation.com/t/hiding-report-layers/5104 "2012-09-07T08:10:53Z")
Is there any way to programmatically hide layers in a report? I have a report that needs to be visible on screen in its entirety, but when printed it should only print the data, as the report layout will be pre-printed… --- ## [Subreports option missing from report designer](https://forum.inductiveautomation.com/t/subreports-option-missing-from-report-designer/5107)
**Author:** [@systemparadox](https://forum.inductiveautomation.com/u/systemparadox)\ **Replies:** 2\ **Last updated:** [September 7, 2012, 7:54am UTC](https://forum.inductiveautomation.com/t/subreports-option-missing-from-report-designer/5107 "2012-09-07T07:54:06Z")
The 'Subreport' option (reportmill.com/support/Subreports.pdf) appears to be missing from the 'Add Shapes' menu in the report designer. Is this intentional? Thanks. --- ## [Mobile module - click event problem](https://forum.inductiveautomation.com/t/mobile-module-click-event-problem/4644)
**Author:** [@idelamer](https://forum.inductiveautomation.com/u/idelamer)\ **Replies:** 12\ **Last updated:** [September 6, 2012, 3:23pm UTC](https://forum.inductiveautomation.com/t/mobile-module-click-event-problem/4644 "2012-09-06T15:23:24Z")
I noticed this problem on 7.4.3-beta1 and 7.5.0. I'm using the Mobile Skeleton project. When in one of the "Main Windows", clicking anywhere on the screen will cause the "Back" button to fire, and will return to the Na… --- ## [Existing PDF report](https://forum.inductiveautomation.com/t/existing-pdf-report/5106)
**Author:** [@systemparadox](https://forum.inductiveautomation.com/u/systemparadox)\ **Replies:** 1\ **Last updated:** [September 6, 2012, 3:07pm UTC](https://forum.inductiveautomation.com/t/existing-pdf-report/5106 "2012-09-06T15:07:13Z")
I'm trying to create a report to fill-in an existing PDF, but a collection of problems have conspired against me: The "Ignition Reporting Features" documentation page (inductiveautomation.com/supp ... atures.htm) menti… --- ## [Alarms Itempath](https://forum.inductiveautomation.com/t/alarms-itempath/5094)
**Author:** [@tamerplc](https://forum.inductiveautomation.com/u/tamerplc)\ **Replies:** 2\ **Last updated:** [September 6, 2012, 8:14am UTC](https://forum.inductiveautomation.com/t/alarms-itempath/5094 "2012-09-06T08:14:08Z")
In Navigation bar there is an Alarm counting with below scripting code runScript("system.alert.queryAlertStatus(" + "activeAndAcked=" + toInt({Root Container.Alarms.activeAndAcked}) + "," + "activeAndUnacked=" + toI… --- ## [Tag import export](https://forum.inductiveautomation.com/t/tag-import-export/4461)
**Author:** [@marioquark](https://forum.inductiveautomation.com/u/marioquark)\ **Replies:** 17\ **Last updated:** [September 6, 2012, 7:20am UTC](https://forum.inductiveautomation.com/t/tag-import-export/4461 "2012-09-06T07:20:33Z")
importing a client tag previously exported on file: --- ## [Docked Window North Changing sizes](https://forum.inductiveautomation.com/t/docked-window-north-changing-sizes/5102)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [September 6, 2012, 12:22am UTC](https://forum.inductiveautomation.com/t/docked-window-north-changing-sizes/5102 "2012-09-06T00:22:46Z")
I have a window docked north and another window docked west. when i resize the window docked west the window docked north seems to resize or reposition it self when i open or close windows. this wouldn't be a problem bu… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1935) [Next page](https://forum.inductiveautomation.com/latest.md?page=1937)