# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1545 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1546 --- ## [\[bug-13183\] named query error when in folder](https://forum.inductiveautomation.com/t/bug-13183-named-query-error-when-in-folder/23421)
**Author:** [@BumbleBeeTuna](https://forum.inductiveautomation.com/u/BumbleBeeTuna)\ **Replies:** 3\ **Last updated:** [March 20, 2019, 3:39pm UTC](https://forum.inductiveautomation.com/t/bug-13183-named-query-error-when-in-folder/23421 "2019-03-20T15:39:49Z")
using: b2019031702 on windows 10 Today I noticed if I create a named query in a folder I receive the below error. If I move the same query to the root of named queries it works. query used on both NQ: select 'Hello… --- ## [\[BUG-12227\] Button Background Color](https://forum.inductiveautomation.com/t/bug-12227-button-background-color/21647)
**Author:** [@nick.schuetz](https://forum.inductiveautomation.com/u/nick.schuetz)\ **Replies:** 7\ **Last updated:** [March 20, 2019, 3:31pm UTC](https://forum.inductiveautomation.com/t/bug-12227-button-background-color/21647 "2019-03-20T15:31:35Z")
The vision button background color is not behaving as expected. The Border Painted option causes the entire background to become pale causing them to look disabled. Also of note is the opaque button doesn’t seem to do a… --- ## [Modelling Table scrollbar](https://forum.inductiveautomation.com/t/modelling-table-scrollbar/23478)
**Author:** [@f.pinciaroli](https://forum.inductiveautomation.com/u/f.pinciaroli)\ **Replies:** 0\ **Last updated:** [March 20, 2019, 2:07pm UTC](https://forum.inductiveautomation.com/t/modelling-table-scrollbar/23478 "2019-03-20T14:07:32Z")
Hello, I would like to resize the scrollBar of a specific table. I was able to set the width with: \`event.source.parent.getComponent('TableProducts2').getVerticalScrollBar().setPreferredSize( Dimension(70, Integer.MAX… --- ## [\[Bug-12699\] System.device library function help text missing in Designer](https://forum.inductiveautomation.com/t/bug-12699-system-device-library-function-help-text-missing-in-designer/22471)
**Author:** [@andrea.morando](https://forum.inductiveautomation.com/u/andrea.morando)\ **Replies:** 2\ **Last updated:** [March 20, 2019, 8:33am UTC](https://forum.inductiveautomation.com/t/bug-12699-system-device-library-function-help-text-missing-in-designer/22471 "2019-03-20T08:33:23Z")
Good morning, the “system.device” library does not appear inside the perspective scope. I get the following error: “AttributeError: ‘com.inductiveautomation.ignition.common.script.Imm’ object has no attribute ‘device’… --- ## [Store and Forward for DB insert via script](https://forum.inductiveautomation.com/t/store-and-forward-for-db-insert-via-script/23324)
**Author:** [@pawel.kondol](https://forum.inductiveautomation.com/u/pawel.kondol)\ **Replies:** 2\ **Last updated:** [March 20, 2019, 7:33am UTC](https://forum.inductiveautomation.com/t/store-and-forward-for-db-insert-via-script/23324 "2019-03-20T07:33:49Z")
HI All, Can database insert through scripting for Store and Forward. Is this function available and how to enable it. There are occasions when DB is down for few minutes and I have few scripts to add manually downtime o… --- ## [Popup Calendar Display](https://forum.inductiveautomation.com/t/popup-calendar-display/23473)
**Author:** [@Dilan](https://forum.inductiveautomation.com/u/Dilan)\ **Replies:** 0\ **Last updated:** [March 20, 2019, 6:43am UTC](https://forum.inductiveautomation.com/t/popup-calendar-display/23473 "2019-03-20T06:43:46Z")
Hi All, Just a quick one, I would like to center the pop up calendar display once selected, but I seem to be missing the ability to do this. Please see attached. --- ## [Save Search Results](https://forum.inductiveautomation.com/t/save-search-results/23472)
**Author:** [@sgchris.williams](https://forum.inductiveautomation.com/u/sgchris.williams)\ **Replies:** 0\ **Last updated:** [March 20, 2019, 4:40am UTC](https://forum.inductiveautomation.com/t/save-search-results/23472 "2019-03-20T04:40:08Z")
Hi, i have a tab strip to switch between screens, the main window that i’m having an issue with has drop down boxes that i want to keep the selected name, when another tab has been selected, i have read a few posts wher… --- ## [\[BUG\] Export to CSV / Excel doesn't populate suggested filename](https://forum.inductiveautomation.com/t/bug-export-to-csv-excel-doesnt-populate-suggested-filename/23470)
**Author:** [@joshdunstan](https://forum.inductiveautomation.com/u/joshdunstan)\ **Replies:** 0\ **Last updated:** [March 19, 2019, 11:53pm UTC](https://forum.inductiveautomation.com/t/bug-export-to-csv-excel-doesnt-populate-suggested-filename/23470 "2019-03-19T23:53:10Z")
As the title suggests, system.dataset.exportCSV(tag, 1, data) doesn’t populate the filename, also, need to specify the ‘.csv’ portion to get it to great a typed file. --- ## [How do I setDomainGridlineStroke - Report Viewer - Time Series Chart Scripting](https://forum.inductiveautomation.com/t/how-do-i-setdomaingridlinestroke-report-viewer-time-series-chart-scripting/23234)
**Author:** [@paulm1](https://forum.inductiveautomation.com/u/paulm1)\ **Replies:** 1\ **Last updated:** [March 19, 2019, 11:06pm UTC](https://forum.inductiveautomation.com/t/how-do-i-setdomaingridlinestroke-report-viewer-time-series-chart-scripting/23234 "2019-03-19T23:06:12Z")
In the Report environment, I am currently using the following script to change my Time Series Chart Gridline colors. from java.awt import Color from org.jfree.chart.plot import CategoryPlot plot = chart.getPlot() plo… --- ## [Lookup expression Error](https://forum.inductiveautomation.com/t/lookup-expression-error/10481)
**Author:** [@jreynolds](https://forum.inductiveautomation.com/u/jreynolds)\ **Replies:** 8\ **Last updated:** [March 19, 2019, 10:21pm UTC](https://forum.inductiveautomation.com/t/lookup-expression-error/10481 "2019-03-19T22:21:57Z")
I’m trying to pull a value from a dataset using the lookup expression, but all I get is the failover value. lookup({Root Container.bsktData},"BSKTLOC\_01",0,2) I’m wanting to grab the bskt\_id based on the BSKTLOC\_## --- ## [SQL Query with realtime tag values](https://forum.inductiveautomation.com/t/sql-query-with-realtime-tag-values/23467)
**Author:** [@joshdunstan](https://forum.inductiveautomation.com/u/joshdunstan)\ **Replies:** 3\ **Last updated:** [March 19, 2019, 9:55pm UTC](https://forum.inductiveautomation.com/t/sql-query-with-realtime-tag-values/23467 "2019-03-19T21:55:44Z")
With the query below, I’d like to use it to build a table that shows be both an offline (DB) and online (PLC) value for some recipe management. I’d like to do this with a query alone but am having issues getting a dynami… --- ## [\[Bug\] Vision 7.9 to 8.0 project import](https://forum.inductiveautomation.com/t/bug-vision-7-9-to-8-0-project-import/22323)
**Author:** [@nick.schuetz](https://forum.inductiveautomation.com/u/nick.schuetz)\ **Replies:** 3\ **Last updated:** [February 4, 2019, 4:37pm UTC](https://forum.inductiveautomation.com/t/bug-vision-7-9-to-8-0-project-import/22323 "2019-02-04T16:37:35Z")
Performed a fresh install of Ignition 8.0.0-beta0 (b2019020402). Tried to import a project from 7.9.6. Using the project import from the gateway doesnt result in any errors, but opening the project in the designer, there… --- ## [Power Table not recognizing datetime2 fields as a date column](https://forum.inductiveautomation.com/t/power-table-not-recognizing-datetime2-fields-as-a-date-column/23372)
**Author:** [@silverbacknet](https://forum.inductiveautomation.com/u/silverbacknet)\ **Replies:** 5\ **Last updated:** [March 19, 2019, 8:19pm UTC](https://forum.inductiveautomation.com/t/power-table-not-recognizing-datetime2-fields-as-a-date-column/23372 "2019-03-19T20:19:26Z")
I’m pulling in several fields to a power table, and I’d like to both use power table’s built-in formatter and enable users to edit the date with a date picker instead of typing. Power table always sees it as a string fie… --- ## [\[BUG-13135\]: Native Launcher Import - Launcher Config Error](https://forum.inductiveautomation.com/t/bug-13135-native-launcher-import-launcher-config-error/23342)
**Author:** [@hodgins.e](https://forum.inductiveautomation.com/u/hodgins.e)\ **Replies:** 3\ **Last updated:** [March 19, 2019, 7:47pm UTC](https://forum.inductiveautomation.com/t/bug-13135-native-launcher-import-launcher-config-error/23342 "2019-03-19T19:47:40Z")
we can’t seem to import the .json file after we’ve exported the config. We get this error: --- ## [Can't Open a Window](https://forum.inductiveautomation.com/t/cant-open-a-window/23452)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 1\ **Last updated:** [March 19, 2019, 6:28pm UTC](https://forum.inductiveautomation.com/t/cant-open-a-window/23452 "2019-03-19T18:28:25Z")
A project I am working on has a nav bar where one button points to a screen “Popup\_Help”. Trying to open this in the Designer and the Client view fail however. I know the window exists, I can see it in the Project Brow… --- ## [\[BYES Apps\] Open Street Maps Viewer component (Ignition 7.8)](https://forum.inductiveautomation.com/t/byes-apps-open-street-maps-viewer-component-ignition-7-8/6625)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 9\ **Last updated:** [March 19, 2019, 6:24pm UTC](https://forum.inductiveautomation.com/t/byes-apps-open-street-maps-viewer-component-ignition-7-8/6625 "2019-03-19T18:24:07Z")
An Open Street Maps viewer component See Module’s doc to configure. Requirement: Ignition V 7.6.0 or greater Features : On line internet maps or off line maps hosted by a webserver like ignition gateway Map marker p… --- ## [\[Question\] Perspective - Named query datatypes](https://forum.inductiveautomation.com/t/question-perspective-named-query-datatypes/23448)
**Author:** [@grietveld](https://forum.inductiveautomation.com/u/grietveld)\ **Replies:** 6\ **Last updated:** [March 19, 2019, 6:22pm UTC](https://forum.inductiveautomation.com/t/question-perspective-named-query-datatypes/23448 "2019-03-19T18:22:26Z")
I’m not sure if this is a bug or if there is a simple datatype casting I can do do address this, but I’m running a named query to return data for a table in perspective. Several of the columns are boolean values. In the … --- ## [\[question/bug?\] \[perspective\] duplicating components](https://forum.inductiveautomation.com/t/question-bug-perspective-duplicating-components/23445)
**Author:** [@BumbleBeeTuna](https://forum.inductiveautomation.com/u/BumbleBeeTuna)\ **Replies:** 5\ **Last updated:** [March 19, 2019, 4:50pm UTC](https://forum.inductiveautomation.com/t/question-bug-perspective-duplicating-components/23445 "2019-03-19T16:50:01Z")
When I duplicate a label some of the position properties do not carry over, specifically the shrink key. Is this expected or a bug? The root container is a flex. --- ## [Use direct tag value inside a Named Query in reporting module](https://forum.inductiveautomation.com/t/use-direct-tag-value-inside-a-named-query-in-reporting-module/23443)
**Author:** [@Mr.K001](https://forum.inductiveautomation.com/u/Mr.K001)\ **Replies:** 4\ **Last updated:** [March 19, 2019, 4:19pm UTC](https://forum.inductiveautomation.com/t/use-direct-tag-value-inside-a-named-query-in-reporting-module/23443 "2019-03-19T16:19:31Z")
Hey gang, I’m just throwing this out there to see if anyone has any genius ideas… Is there a way to add a tag value inside of a Name Query without using the parameters? like in a normal Query you can include the {tag p… --- ## [Green question on tags](https://forum.inductiveautomation.com/t/green-question-on-tags/23413)
**Author:** [@sullah1](https://forum.inductiveautomation.com/u/sullah1)\ **Replies:** 3\ **Last updated:** [March 19, 2019, 4:16pm UTC](https://forum.inductiveautomation.com/t/green-question-on-tags/23413 "2019-03-19T16:16:22Z")
I see green question mark on the Tags and it shows the static value of the tag. I am using Ignition 7.9.7 version. I drag and drop the tags using OPC DA server, the values of the tags were updating but now most of them g… --- ## [Store and Forward ERROR: value too long for type character varying(255)](https://forum.inductiveautomation.com/t/store-and-forward-error-value-too-long-for-type-character-varying-255/23432)
**Author:** [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Replies:** 1\ **Last updated:** [March 19, 2019, 4:12pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-error-value-too-long-for-type-character-varying-255/23432 "2019-03-19T16:12:37Z")
Every once in a while I get this “ERROR: value too long for type character varying(255)” in the gateway log. The interesting thing is that I’ve changed all the fields in the ‘alarm\_events’ and ‘alarm\_events\_data’ from v… --- ## [Modify tab buttons](https://forum.inductiveautomation.com/t/modify-tab-buttons/23444)
**Author:** [@bchristenson](https://forum.inductiveautomation.com/u/bchristenson)\ **Replies:** 0\ **Last updated:** [March 19, 2019, 3:52pm UTC](https://forum.inductiveautomation.com/t/modify-tab-buttons/23444 "2019-03-19T15:52:52Z")
Hi, Is there any way to modify how much the tabs skip while pressing the 2 buttons ignition offers automatically? i’m talking about the buttons in my screenshot: I would like to click on it once and have it skip an en… --- ## [Progress Bar Font Color](https://forum.inductiveautomation.com/t/progress-bar-font-color/23442)
**Author:** [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Replies:** 0\ **Last updated:** [March 19, 2019, 2:46pm UTC](https://forum.inductiveautomation.com/t/progress-bar-font-color/23442 "2019-03-19T14:46:15Z")
I have read through what I could find about the progress bar, it appears that the Font Color can’t be changed. Is this correct? I have “Show Percentage” checked and I want to change that color. Thanks --- ## [Multiple conditions for a boolean tag change](https://forum.inductiveautomation.com/t/multiple-conditions-for-a-boolean-tag-change/23435)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 1\ **Last updated:** [March 19, 2019, 2:19pm UTC](https://forum.inductiveautomation.com/t/multiple-conditions-for-a-boolean-tag-change/23435 "2019-03-19T14:19:04Z")
I have a popup window that is supposed to appear and be mandatory to fill out. It is supposed to appear by either being triggered manually via a button, or automatically. The automatic part is the tricky part here - it… --- ## [Unable to login to client under administrator after power failure](https://forum.inductiveautomation.com/t/unable-to-login-to-client-under-administrator-after-power-failure/23437)
**Author:** [@readywebsolutions](https://forum.inductiveautomation.com/u/readywebsolutions)\ **Replies:** 0\ **Last updated:** [March 19, 2019, 1:51pm UTC](https://forum.inductiveautomation.com/t/unable-to-login-to-client-under-administrator-after-power-failure/23437 "2019-03-19T13:51:00Z")
Has anyone run into this problem before? After server shutdown due to power failure the Client refuses to accept any user with the Administrator’s role. I successfully log in with a user under another role (Operator, etc… --- ## [Get min/max/average values from dataset](https://forum.inductiveautomation.com/t/get-min-max-average-values-from-dataset/20988)
**Author:** [@ASF](https://forum.inductiveautomation.com/u/ASF)\ **Replies:** 11\ **Last updated:** [March 19, 2019, 12:33pm UTC](https://forum.inductiveautomation.com/t/get-min-max-average-values-from-dataset/20988 "2019-03-19T12:33:38Z")
I have a script which uses system.tag.queryTagHistory to retrieve log data in 15 minute intervals for the previous 24 hours. I run it three times, and get a minimum dataset, a maximum dataset, and an average dataset. Now… --- ## [\[BUG\] Projects export from gateway as .ZIP and expect .PROJ on import](https://forum.inductiveautomation.com/t/bug-projects-export-from-gateway-as-zip-and-expect-proj-on-import/22846)
**Author:** [@joshdunstan](https://forum.inductiveautomation.com/u/joshdunstan)\ **Replies:** 8\ **Last updated:** [March 19, 2019, 12:23pm UTC](https://forum.inductiveautomation.com/t/bug-projects-export-from-gateway-as-zip-and-expect-proj-on-import/22846 "2019-03-19T12:23:33Z")
As the title suggests, when exporting from the gateway by default we get a ZIP file. Then the importer wants a PROJ file. Renaming the file as a proj works as the interim solution. --- ## [Creating DB connection to a SQL Server using Windows Authentication for a group of Users](https://forum.inductiveautomation.com/t/creating-db-connection-to-a-sql-server-using-windows-authentication-for-a-group-of-users/18869)
**Author:** [@jayakishoreanish](https://forum.inductiveautomation.com/u/jayakishoreanish)\ **Replies:** 1\ **Last updated:** [March 19, 2019, 12:12am UTC](https://forum.inductiveautomation.com/t/creating-db-connection-to-a-sql-server-using-windows-authentication-for-a-group-of-users/18869 "2019-03-19T00:12:47Z")
Hi All, Is it possible to setup a Database connection for a group of Windows Authenticated Users to SQL Server. Under the properties of the Ignition Gateway Services , in the log on Tab, the Windows User Groups created… --- ## [Perspective Session Props & Vision Client Launcher issues](https://forum.inductiveautomation.com/t/perspective-session-props-vision-client-launcher-issues/23124)
**Author:** [@roger\_larson](https://forum.inductiveautomation.com/u/roger_larson)\ **Replies:** 3\ **Last updated:** [March 18, 2019, 11:59pm UTC](https://forum.inductiveautomation.com/t/perspective-session-props-vision-client-launcher-issues/23124 "2019-03-18T23:59:58Z")
Hi all, I have an issue in a perspective application where the authenticated username, as well as the longitude and latitude coordinates, do not populate when the application start, they all remain null. The username so… --- ## [Reading and Processing CSVs - intermittent errors](https://forum.inductiveautomation.com/t/reading-and-processing-csvs-intermittent-errors/23393)
**Author:** [@AIO](https://forum.inductiveautomation.com/u/AIO)\ **Replies:** 5\ **Last updated:** [March 18, 2019, 9:51pm UTC](https://forum.inductiveautomation.com/t/reading-and-processing-csvs-intermittent-errors/23393 "2019-03-18T21:51:17Z")
Hey folks, Apologies for the formatting. I have a batch of CSV files that I would like to read in to a dataset, find the line of best fit equation, then use this equation to generate a new dataset at regular intervals. … [Previous page](https://forum.inductiveautomation.com/latest.md?page=1544) [Next page](https://forum.inductiveautomation.com/latest.md?page=1546)