# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1455 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1456 --- ## [PowerTable Dropdown, always show option set by configureEditor](https://forum.inductiveautomation.com/t/powertable-dropdown-always-show-option-set-by-configureeditor/28989)
**Author:** [@RadicalRumin](https://forum.inductiveautomation.com/u/RadicalRumin)\ **Replies:** 1\ **Last updated:** [October 10, 2019, 2:49pm UTC](https://forum.inductiveautomation.com/t/powertable-dropdown-always-show-option-set-by-configureeditor/28989 "2019-10-10T14:49:12Z")
I’ve been working on a CRUD project. I needed to make sure to only allow certain options for updates in a table. I’ve already done this using the configureEditor extension function. Let’s say table1 has a column referen… --- ## [\[6004\]Reporting SQL Query Parameter Deletion](https://forum.inductiveautomation.com/t/6004-reporting-sql-query-parameter-deletion/10537)
**Author:** [@gadgetguru69](https://forum.inductiveautomation.com/u/gadgetguru69)\ **Replies:** 4\ **Last updated:** [October 11, 2019, 4:30am UTC](https://forum.inductiveautomation.com/t/6004-reporting-sql-query-parameter-deletion/10537 "2019-10-11T04:30:21Z")
Guys just found an issue that you might want to look at. The first screen shot shows a where clause with 7 parameters assigned. Second screen shot shows parameter 5 should have been removed from list but actually param… --- ## [Custom Properties Set On Startup Script](https://forum.inductiveautomation.com/t/custom-properties-set-on-startup-script/29014)
**Author:** [@juanleroux](https://forum.inductiveautomation.com/u/juanleroux)\ **Replies:** 1\ **Last updated:** [October 10, 2019, 11:46pm UTC](https://forum.inductiveautomation.com/t/custom-properties-set-on-startup-script/29014 "2019-10-10T23:46:39Z")
I have a custom property “Path” on a Vision window. On startup of the client the property is blank. I would like to set the “Path” property on the client event startup script. How is this done? --- ## [Create SQL TABLE with Variable name](https://forum.inductiveautomation.com/t/create-sql-table-with-variable-name/29012)
**Author:** [@juan](https://forum.inductiveautomation.com/u/juan)\ **Replies:** 1\ **Last updated:** [October 10, 2019, 10:51pm UTC](https://forum.inductiveautomation.com/t/create-sql-table-with-variable-name/29012 "2019-10-10T22:51:55Z")
Good Afternoon, I’m trying to write a script that creates tables to my database, I want to name the table with the contents of a string variable, is this possible? --- ## [User Dataset](https://forum.inductiveautomation.com/t/user-dataset/11846)
**Author:** [@qversa](https://forum.inductiveautomation.com/u/qversa)\ **Replies:** 2\ **Last updated:** [October 10, 2019, 10:38pm UTC](https://forum.inductiveautomation.com/t/user-dataset/11846 "2019-10-10T22:38:44Z")
I'm looking for some coding help with Datasets. I would like to create a Window with a list of all users where the operator can select his name and a password box will popup. This way they do not have to type in their us… --- ## [Errant project import behavior in 8.0.4](https://forum.inductiveautomation.com/t/errant-project-import-behavior-in-8-0-4/29010)
**Author:** [@heybales](https://forum.inductiveautomation.com/u/heybales)\ **Replies:** 2\ **Last updated:** [October 10, 2019, 9:59pm UTC](https://forum.inductiveautomation.com/t/errant-project-import-behavior-in-8-0-4/29010 "2019-10-10T21:59:33Z")
I’ve had two occasions when project import did not work correctly. Both cases were exporting from 8.0.4 into 8.0.4. In the first case, vision templates and graphics were missing from the imported project. In the secon… --- ## [Unable to remove tag folder from Tag Browser in ignition 8.0.4](https://forum.inductiveautomation.com/t/unable-to-remove-tag-folder-from-tag-browser-in-ignition-8-0-4/29009)
**Author:** [@serenaz](https://forum.inductiveautomation.com/u/serenaz)\ **Replies:** 5\ **Last updated:** [October 10, 2019, 8:50pm UTC](https://forum.inductiveautomation.com/t/unable-to-remove-tag-folder-from-tag-browser-in-ignition-8-0-4/29009 "2019-10-10T20:50:04Z")
I have been transferring tags from the old v7.9 to the new 8.0.4. I started with line 10 (name of folder is Line10\_OEE) by creating tags manually to make sure it works first. Then I exported the rest of the folders from… --- ## [SQL Query Returns Different Results MSSQL vs Database Query Browser](https://forum.inductiveautomation.com/t/sql-query-returns-different-results-mssql-vs-database-query-browser/29002)
**Author:** [@jlopez](https://forum.inductiveautomation.com/u/jlopez)\ **Replies:** 2\ **Last updated:** [October 10, 2019, 8:31pm UTC](https://forum.inductiveautomation.com/t/sql-query-returns-different-results-mssql-vs-database-query-browser/29002 "2019-10-10T20:31:46Z")
I have a stored procedure named GetRowNumforFace constructed as follows: USE \[solidiadb\] GO /\*\*\*\*\*\* Object: StoredProcedure \[dbo\].\[GetRowNumforFace\] Script Date: 10/10/2019 1:34:59 PM \*\*\*\*\*\*/ SET ANSI\_NULLS ON … --- ## [IsShelved not updating](https://forum.inductiveautomation.com/t/isshelved-not-updating/29008)
**Author:** [@JoeJansen](https://forum.inductiveautomation.com/u/JoeJansen)\ **Replies:** 0\ **Last updated:** [October 10, 2019, 7:56pm UTC](https://forum.inductiveautomation.com/t/isshelved-not-updating/29008 "2019-10-10T19:56:21Z")
I am using system.alarm.shelve() to shelve some alarms via a scipt. I have an OPC tag that tracks the value of IsShelved for the alarm. When I shelve the alarms it works fine, but when the shelving times out and the al… --- ## [Passing .txt file content to Label object](https://forum.inductiveautomation.com/t/passing-txt-file-content-to-label-object/11437)
**Author:** [@csmeaton](https://forum.inductiveautomation.com/u/csmeaton)\ **Replies:** 2\ **Last updated:** [October 10, 2019, 6:41pm UTC](https://forum.inductiveautomation.com/t/passing-txt-file-content-to-label-object/11437 "2019-10-10T18:41:02Z")
I am trying to display Operator Work Instructions on a screen with the "label" object. Because these work instructions can be somewhat lengthy (string size of more than 400 characters) I would like to save the work inst… --- ## [Use a column from tables selected row as a data bounds](https://forum.inductiveautomation.com/t/use-a-column-from-tables-selected-row-as-a-data-bounds/29000)
**Author:** [@boster281](https://forum.inductiveautomation.com/u/boster281)\ **Replies:** 1\ **Last updated:** [October 10, 2019, 6:35pm UTC](https://forum.inductiveautomation.com/t/use-a-column-from-tables-selected-row-as-a-data-bounds/29000 "2019-10-10T18:35:58Z")
I want to use a tables selected row and certain column as my maximum bound on a numeric text field. I know how to get the value in Python scripting but not how to get it in expression or properties. --- ## [Popup Calendar does not save when property change](https://forum.inductiveautomation.com/t/popup-calendar-does-not-save-when-property-change/28993)
**Author:** [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Replies:** 3\ **Last updated:** [October 10, 2019, 5:59pm UTC](https://forum.inductiveautomation.com/t/popup-calendar-does-not-save-when-property-change/28993 "2019-10-10T17:59:17Z")
I have several popup calendars on my reports and I have them all set to NOT DISPLAY the time (But they all do) I can go change this property save it, close the designer and reopen and it is showing the TIME again. From… --- ## [How to pass multiple datatset in template repeater parameters](https://forum.inductiveautomation.com/t/how-to-pass-multiple-datatset-in-template-repeater-parameters/28988)
**Author:** [@Anita.Shinde](https://forum.inductiveautomation.com/u/Anita.Shinde)\ **Replies:** 5\ **Last updated:** [October 10, 2019, 5:25pm UTC](https://forum.inductiveautomation.com/t/how-to-pass-multiple-datatset-in-template-repeater-parameters/28988 "2019-10-10T17:25:18Z")
I have one template having scheduler in it. Template/Scheduler needs 4 dataset and 3 string values, how should I pass 4 dataset in template repeater parameters. Please help me out regarding same. --- ## [SQL Exception on Query Binding](https://forum.inductiveautomation.com/t/sql-exception-on-query-binding/28998)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [October 10, 2019, 5:24pm UTC](https://forum.inductiveautomation.com/t/sql-exception-on-query-binding/28998 "2019-10-10T17:24:12Z")
Is there a way to catch a SQL exception on query binding in Perspective? We have some stored procedures that raise errors that need to be displayed to the user and we do not want the binding to just fail. --- ## [\[9480\] Report Viewer: Page buttons do not work with "Page Layout" = Continuous](https://forum.inductiveautomation.com/t/9480-report-viewer-page-buttons-do-not-work-with-page-layout-continuous/27978)
**Author:** [@informatica](https://forum.inductiveautomation.com/u/informatica)\ **Replies:** 3\ **Last updated:** [October 10, 2019, 4:48pm UTC](https://forum.inductiveautomation.com/t/9480-report-viewer-page-buttons-do-not-work-with-page-layout-continuous/27978 "2019-10-10T16:48:21Z")
Good afternoon. In Ignition 8.0.3, if a report is designed with “Page Layout” = Continuos, then in a “report viewer” (Vision) the page buttons do not work (the page number increases / decreases but the “report viewer” i… --- ## [Using Perspective Scripts in Project Library](https://forum.inductiveautomation.com/t/using-perspective-scripts-in-project-library/28992)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 3\ **Last updated:** [October 10, 2019, 3:59pm UTC](https://forum.inductiveautomation.com/t/using-perspective-scripts-in-project-library/28992 "2019-10-10T15:59:37Z")
I am running 8.0.4. I noticed that when I create a project script in the project library and I use the ctrl+spacebar I do not see the system.perspective package. Is this on purpose or will this be added in a newer versio… --- ## [Historian Limitations?](https://forum.inductiveautomation.com/t/historian-limitations/28991)
**Author:** [@tim.schultz](https://forum.inductiveautomation.com/u/tim.schultz)\ **Replies:** 0\ **Last updated:** [October 10, 2019, 3:31pm UTC](https://forum.inductiveautomation.com/t/historian-limitations/28991 "2019-10-10T15:31:16Z")
Has anyone run into limitations using the Ignition Historian? We are running a system with 5k tags at a 1s interval, giving us around 50 million rows a week (rows in the sqlt\_ partition). It feels to me that this shoul… --- ## [Parameter for view's context?](https://forum.inductiveautomation.com/t/parameter-for-views-context/28793)
**Author:** [@Dan\_Bridgeman](https://forum.inductiveautomation.com/u/Dan_Bridgeman)\ **Replies:** 2\ **Last updated:** [October 10, 2019, 3:12pm UTC](https://forum.inductiveautomation.com/t/parameter-for-views-context/28793 "2019-10-10T15:12:01Z")
Is it possible to tell the what context a view is in when an action is performed? For example, if a button as an actionPerformed script, could I examine some property of the object or the event which would tell me if th… --- ## [Disable/Lock all Main Window click events while pop-up is open](https://forum.inductiveautomation.com/t/disable-lock-all-main-window-click-events-while-pop-up-is-open/28985)
**Author:** [@adam.hellyer](https://forum.inductiveautomation.com/u/adam.hellyer)\ **Replies:** 2\ **Last updated:** [October 10, 2019, 12:40pm UTC](https://forum.inductiveautomation.com/t/disable-lock-all-main-window-click-events-while-pop-up-is-open/28985 "2019-10-10T12:40:13Z")
The goal is that I would still be able to see what’s going on in the main window, but have a pop-up window that locks all activity on the main window until it’s closed. I assumed the easiest way to do this would be with… --- ## [Image editor in persective](https://forum.inductiveautomation.com/t/image-editor-in-persective/28984)
**Author:** [@anon35489801](https://forum.inductiveautomation.com/u/anon35489801)\ **Replies:** 0\ **Last updated:** [October 10, 2019, 11:59am UTC](https://forum.inductiveautomation.com/t/image-editor-in-persective/28984 "2019-10-10T11:59:32Z")
Hi, I was wondering if anyone knows of a image viewer/editor for perspective. We are trying to make it possible to add (multiple) small text/number fields that is created on a double click event for both mobile devices … --- ## [Power Table OnCellEdited](https://forum.inductiveautomation.com/t/power-table-oncelledited/10737)
**Author:** [@A123Dev](https://forum.inductiveautomation.com/u/A123Dev)\ **Replies:** 17\ **Last updated:** [October 10, 2019, 11:49am UTC](https://forum.inductiveautomation.com/t/power-table-oncelledited/10737 "2019-10-10T11:49:55Z")
I am trying to get OnCellEdited to update my db with new values for my power table and have referenced help section and searched this bulletin. I am having difficulty based on what i have found. Can someone provide a sa… --- ## [Shelved alarms disappeared](https://forum.inductiveautomation.com/t/shelved-alarms-disappeared/27088)
**Author:** [@Controller](https://forum.inductiveautomation.com/u/Controller)\ **Replies:** 1\ **Last updated:** [October 10, 2019, 11:19am UTC](https://forum.inductiveautomation.com/t/shelved-alarms-disappeared/27088 "2019-10-10T11:19:53Z")
Hello all, Ran into a strange situation. An alarm was shelved for 24 hours, alarm appeared in the shelved list. After the time had expired, the alarm reappeared in the alarm list (as normal). The alarm was then shelved … --- ## [Indirect Tag binding not filling in Custom or Template Properties, but works in expression binding](https://forum.inductiveautomation.com/t/indirect-tag-binding-not-filling-in-custom-or-template-properties-but-works-in-expression-binding/28966)
**Author:** [@rpavlicek](https://forum.inductiveautomation.com/u/rpavlicek)\ **Replies:** 3\ **Last updated:** [October 10, 2019, 4:03am UTC](https://forum.inductiveautomation.com/t/indirect-tag-binding-not-filling-in-custom-or-template-properties-but-works-in-expression-binding/28966 "2019-10-10T04:03:58Z")
In 8.0.4, when I have a custom or template property of string, if I put in a a indirect tag binding to a tag path, it doesn’t fill in anything. However, if I put the same thing in expression form, with the tag path in q… --- ## [Capturing input from a barcode scanner](https://forum.inductiveautomation.com/t/capturing-input-from-a-barcode-scanner/19640)
**Author:** [@danieltalbot](https://forum.inductiveautomation.com/u/danieltalbot)\ **Replies:** 12\ **Last updated:** [October 9, 2019, 11:28pm UTC](https://forum.inductiveautomation.com/t/capturing-input-from-a-barcode-scanner/19640 "2019-10-09T23:28:15Z")
I am trying to set up an asset tracking system for computers in my organization. I have a usb barcode scanner and would like a text area to capture the input from the scanner so that it filters the power table below it. … --- ## [Unattended install: Error running chown](https://forum.inductiveautomation.com/t/unattended-install-error-running-chown/28937)
**Author:** [@lorenzo.milesi](https://forum.inductiveautomation.com/u/lorenzo.milesi)\ **Replies:** 4\ **Last updated:** [October 9, 2019, 8:39pm UTC](https://forum.inductiveautomation.com/t/unattended-install-error-running-chown/28937 "2019-10-09T20:39:27Z")
I’m trying to use the unattended linux installer but it fails on chown, as the script seems to miss the username: ./Ignition-7.9.12-linux-x64-installer.run --mode unattended --prefix /opt/ignition-manual --unattendedmod… --- ## [Renaming a Perspective view crashes Ignition Designer](https://forum.inductiveautomation.com/t/renaming-a-perspective-view-crashes-ignition-designer/28971)
**Author:** [@mpawsey](https://forum.inductiveautomation.com/u/mpawsey)\ **Replies:** 0\ **Last updated:** [October 9, 2019, 10:38pm UTC](https://forum.inductiveautomation.com/t/renaming-a-perspective-view-crashes-ignition-designer/28971 "2019-10-09T22:38:01Z")
Renaming a view in the “Views” folder in Perspective crashes Ignition Designer. Renaming folders does not seem to crash the designer. System: Mac OS X 10.14.4 Java: 11.0.3+7-LTS Gateway: 8.0.3 (b2019080717) --- ## [Tag properties not reading consistently](https://forum.inductiveautomation.com/t/tag-properties-not-reading-consistently/28969)
**Author:** [@mgraham](https://forum.inductiveautomation.com/u/mgraham)\ **Replies:** 1\ **Last updated:** [October 9, 2019, 9:28pm UTC](https://forum.inductiveautomation.com/t/tag-properties-not-reading-consistently/28969 "2019-10-09T21:28:23Z")
I have this problem: same tag, but partial tag path results are different from full tagpath tg is set earlier in script to the tag path. partial script: imode = system.tag.read(tg+".InterpolationMode").getValue() pr… --- ## [RunNamedQuery from Project Script Error](https://forum.inductiveautomation.com/t/runnamedquery-from-project-script-error/28965)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 3\ **Last updated:** [October 9, 2019, 9:24pm UTC](https://forum.inductiveautomation.com/t/runnamedquery-from-project-script-error/28965 "2019-10-09T21:24:12Z")
Why when I run a named query in a project script I receive this? I am running system.db.runNamedQuery("MyProject", "MyQueries/NamedQuery", {"parameter":"myParameter"}, 0) and I get this error java.lang.Exception: j… --- ## [Clear Perspective DateTime Input](https://forum.inductiveautomation.com/t/clear-perspective-datetime-input/28955)
**Author:** [@justop](https://forum.inductiveautomation.com/u/justop)\ **Replies:** 1\ **Last updated:** [October 9, 2019, 8:31pm UTC](https://forum.inductiveautomation.com/t/clear-perspective-datetime-input/28955 "2019-10-09T20:31:08Z")
I’m using Ignition 8.0.4 and the Perspective DateTime Input object. I have two inputs controlling the range for a Time Series Chart object. I’d like to have a reset button on the page to clear the contents of the DateTim… --- ## [Fill drop-down list issue](https://forum.inductiveautomation.com/t/fill-drop-down-list-issue/28933)
**Author:** [@dwoo](https://forum.inductiveautomation.com/u/dwoo)\ **Replies:** 9\ **Last updated:** [October 9, 2019, 8:20pm UTC](https://forum.inductiveautomation.com/t/fill-drop-down-list-issue/28933 "2019-10-09T20:20:25Z")
I’m trying to generate a 1-column list and populate a drop-down list when a numeric label changes value. The data is read using OPC and any duplicate values are not added to the list. When it attempts to convert the Li… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1454) [Next page](https://forum.inductiveautomation.com/latest.md?page=1456)