# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1099 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1100 --- ## [Ignition database](https://forum.inductiveautomation.com/t/ignition-database/40679)
**Author:** [@epifanio.tigno](https://forum.inductiveautomation.com/u/epifanio.tigno)\ **Replies:** 4\ **Last updated:** [November 17, 2020, 5:08am UTC](https://forum.inductiveautomation.com/t/ignition-database/40679 "2020-11-17T05:08:56Z")
Hi, is it possible to have and INSERT INTO SELECT STATEMENT in ignition? how about its syntax in scripting? --- ## [\[BUG\] v8.1.0 Coord container page centre alignment buttons move components if clicked multiple times](https://forum.inductiveautomation.com/t/bug-v8-1-0-coord-container-page-centre-alignment-buttons-move-components-if-clicked-multiple-times/40716)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 0\ **Last updated:** [November 17, 2020, 2:25am UTC](https://forum.inductiveautomation.com/t/bug-v8-1-0-coord-container-page-centre-alignment-buttons-move-components-if-clicked-multiple-times/40716 "2020-11-17T02:25:42Z")
v8.1.0 --- ## [Creating optimised SVG in Inkscape results in elements grouped oddly](https://forum.inductiveautomation.com/t/creating-optimised-svg-in-inkscape-results-in-elements-grouped-oddly/40715)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 0\ **Last updated:** [November 17, 2020, 1:01am UTC](https://forum.inductiveautomation.com/t/creating-optimised-svg-in-inkscape-results-in-elements-grouped-oddly/40715 "2020-11-17T01:01:39Z")
This is more an informative post about creating SVGs in Inkscape… It started off as a question but then turned into an answer as I worked through it. I have quite a complex SVG for swing bend pipes that connect ports of… --- ## [metroSSLPort similar](https://forum.inductiveautomation.com/t/metrosslport-similar/40619)
**Author:** [@448719222](https://forum.inductiveautomation.com/u/448719222)\ **Replies:** 5\ **Last updated:** [November 17, 2020, 12:49am UTC](https://forum.inductiveautomation.com/t/metrosslport-similar/40619 "2020-11-17T00:49:55Z")
When configuring outgoing connections in Gayway Network, if ssl is configured, the default port is 8060. If ssl is not configured, what is the default port, or which attribute should be configured in data/gatway.xml --- ## [Tag value change script](https://forum.inductiveautomation.com/t/tag-value-change-script/40711)
**Author:** [@trentbliss](https://forum.inductiveautomation.com/u/trentbliss)\ **Replies:** 1\ **Last updated:** [November 17, 2020, 12:31am UTC](https://forum.inductiveautomation.com/t/tag-value-change-script/40711 "2020-11-17T00:31:13Z")
When i use datetime.now() in the script console it shows my local time. But when it runs on an event tag script value change it uses UTC time. The script console is the same as the System, Current Time tag. I don’t kn… --- ## [\[FEATURE\] Allow nested level property filtering in Perspective Property Editor](https://forum.inductiveautomation.com/t/feature-allow-nested-level-property-filtering-in-perspective-property-editor/40713)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 0\ **Last updated:** [November 16, 2020, 11:58pm UTC](https://forum.inductiveautomation.com/t/feature-allow-nested-level-property-filtering-in-perspective-property-editor/40713 "2020-11-16T23:58:12Z")
I’ve just started using the filter feature and it’s pretty cool especially for embedded SVGs. However, it would be even more useful if we could filter by specific structures, for example if an array property contains a f… --- ## [DB Tables and Unique or duplicate values](https://forum.inductiveautomation.com/t/db-tables-and-unique-or-duplicate-values/39678)
**Author:** [@steven.cox](https://forum.inductiveautomation.com/u/steven.cox)\ **Replies:** 29\ **Last updated:** [November 16, 2020, 11:47pm UTC](https://forum.inductiveautomation.com/t/db-tables-and-unique-or-duplicate-values/39678 "2020-11-16T23:47:20Z")
Hi all, New to Ignition and scripting / SQL. I am building a project to learn and I have run into a issue that I can solve with a query and an addition to a script, but I want to see if that is the best option. To giv… --- ## [Upgrade Tags in deployement, without updating values](https://forum.inductiveautomation.com/t/upgrade-tags-in-deployement-without-updating-values/40707)
**Author:** [@Hulix\_Michael](https://forum.inductiveautomation.com/u/Hulix_Michael)\ **Replies:** 2\ **Last updated:** [November 16, 2020, 9:38pm UTC](https://forum.inductiveautomation.com/t/upgrade-tags-in-deployement-without-updating-values/40707 "2020-11-16T21:38:03Z")
Hi, is-there a simple way to import tags without overwriting values? As an example, I do some modifications in Dev’s tags, I export all my tags from dev to make sure I don’t forget one and finally I import those tags in … --- ## [\[bug-1084\]System.tag.browse null pointer exception](https://forum.inductiveautomation.com/t/bug-1084-system-tag-browse-null-pointer-exception/40697)
**Author:** [@Cory.grube](https://forum.inductiveautomation.com/u/Cory.grube)\ **Replies:** 5\ **Last updated:** [November 16, 2020, 9:19pm UTC](https://forum.inductiveautomation.com/t/bug-1084-system-tag-browse-null-pointer-exception/40697 "2020-11-16T21:19:20Z")
I have a popup that utilizes system.tag.browse('') to return a list of tag providers. This worked fine in 8.0, but seemingly with an upgrade to 8.1, this began giving me a null pointer exception: Traceback (most recent … --- ## [Perspective View Inheritance or Template?](https://forum.inductiveautomation.com/t/perspective-view-inheritance-or-template/40706)
**Author:** [@hodgins.e](https://forum.inductiveautomation.com/u/hodgins.e)\ **Replies:** 6\ **Last updated:** [November 16, 2020, 9:16pm UTC](https://forum.inductiveautomation.com/t/perspective-view-inheritance-or-template/40706 "2020-11-16T21:16:49Z")
Is it possible to create view that can be reused as a template for other views? For example if I created a view from say the Coordinate and then customized it. Could I then have other views inherit the properties, scri… --- ## [Get error message from SP SQL Server. display message with error type](https://forum.inductiveautomation.com/t/get-error-message-from-sp-sql-server-display-message-with-error-type/22662)
**Author:** [@juang](https://forum.inductiveautomation.com/u/juang)\ **Replies:** 2\ **Last updated:** [November 16, 2020, 7:16pm UTC](https://forum.inductiveautomation.com/t/get-error-message-from-sp-sql-server-display-message-with-error-type/22662 "2020-11-16T19:16:16Z")
I Need to get the error message from and SP or a Transaction and use it with Ignition. for example. if we have a duplicate fail insert, i want to catch that error , identify it, and then display an error message box say… --- ## [Perspective displays differently in different browsers](https://forum.inductiveautomation.com/t/perspective-displays-differently-in-different-browsers/40602)
**Author:** [@steven.cox](https://forum.inductiveautomation.com/u/steven.cox)\ **Replies:** 2\ **Last updated:** [November 16, 2020, 6:19pm UTC](https://forum.inductiveautomation.com/t/perspective-displays-differently-in-different-browsers/40602 "2020-11-16T18:19:52Z")
Hi all, I am just getting started learning Perspective. I have noticed that label layouts show up differently depending on what browser your in. This is 4 labels stacked vertically and aligned. Firefox… Chrome… … --- ## [Stretching in Column Container](https://forum.inductiveautomation.com/t/stretching-in-column-container/40655)
**Author:** [@steven.cox](https://forum.inductiveautomation.com/u/steven.cox)\ **Replies:** 2\ **Last updated:** [November 16, 2020, 6:17pm UTC](https://forum.inductiveautomation.com/t/stretching-in-column-container/40655 "2020-11-16T18:17:41Z")
Hi all, I am just starting out on perspective (& Ignition for that matter). I am playing with the different containers. I have a column container with a Markdown component in the first row. When it displays on a smal… --- ## [Interpolation does not work correctly in Easy Chart and "system.tag.queryTagCalculations()"](https://forum.inductiveautomation.com/t/interpolation-does-not-work-correctly-in-easy-chart-and-system-tag-querytagcalculations/40701)
**Author:** [@informatica](https://forum.inductiveautomation.com/u/informatica)\ **Replies:** 0\ **Last updated:** [November 16, 2020, 6:06pm UTC](https://forum.inductiveautomation.com/t/interpolation-does-not-work-correctly-in-easy-chart-and-system-tag-querytagcalculations/40701 "2020-11-16T18:06:39Z")
Good afternoon. In Ignition 8.0.14, I have configured a tag to history with this Tag Group (Scan Class): When I query the tag with “system.tag.queryTagCalculations()” to know its “DurationOff”, the function returns f… --- ## [Vision Power Table call configureHeaderStyle dynamically](https://forum.inductiveautomation.com/t/vision-power-table-call-configureheaderstyle-dynamically/40695)
**Author:** [@dustin.cooper](https://forum.inductiveautomation.com/u/dustin.cooper)\ **Replies:** 2\ **Last updated:** [November 16, 2020, 5:47pm UTC](https://forum.inductiveautomation.com/t/vision-power-table-call-configureheaderstyle-dynamically/40695 "2020-11-16T17:47:32Z")
Hi there! Ignition 8.1.0 Vision Power Table component ConfigureHeader extension function. TLDR; Is there a way to dynamically call the configureHeaderStyle extension function? I need to update the header style as n… --- ## [Issue with embedding "live" image in perspective](https://forum.inductiveautomation.com/t/issue-with-embedding-live-image-in-perspective/40377)
**Author:** [@cbarker](https://forum.inductiveautomation.com/u/cbarker)\ **Replies:** 4\ **Last updated:** [November 16, 2020, 4:54pm UTC](https://forum.inductiveautomation.com/t/issue-with-embedding-live-image-in-perspective/40377 "2020-11-16T16:54:29Z")
Currently using 8.0.16 if that helps I am trying to upgrade an old vision project to perspective. The vision one had IP Camera viewers to pull images which came from the internet. The url would stay the same, but the im… --- ## [Named Query :: DateTime not passing Time to query](https://forum.inductiveautomation.com/t/named-query-datetime-not-passing-time-to-query/40694)
**Author:** [@beaudoin.stephane](https://forum.inductiveautomation.com/u/beaudoin.stephane)\ **Replies:** 0\ **Last updated:** [November 16, 2020, 4:07pm UTC](https://forum.inductiveautomation.com/t/named-query-datetime-not-passing-time-to-query/40694 "2020-11-16T16:07:43Z")
Hi, I have a problem with the DateTime type in the named query not passing the time to the query (only date with no hours:min: sec). In PostgreSQL, the stored procedure (routine) is using variables with timestamp types.… --- ## [Send Email to current user via system.report.executeAndDistribute](https://forum.inductiveautomation.com/t/send-email-to-current-user-via-system-report-executeanddistribute/40675)
**Author:** [@jkelleyus](https://forum.inductiveautomation.com/u/jkelleyus)\ **Replies:** 7\ **Last updated:** [November 16, 2020, 4:03pm UTC](https://forum.inductiveautomation.com/t/send-email-to-current-user-via-system-report-executeanddistribute/40675 "2020-11-16T16:03:22Z")
Good afternoon, all! I’m working on placing a button on a report form for emailing the data using system.report.executeAndDistribute. This works for a static user, but I can’t seem to locate a method for getting the cur… --- ## [\[BUG-YT-302\] Project Inheritance Forcing Overrides](https://forum.inductiveautomation.com/t/bug-yt-302-project-inheritance-forcing-overrides/38516)
**Author:** [@ryanjmclaughlin](https://forum.inductiveautomation.com/u/ryanjmclaughlin)\ **Replies:** 17\ **Last updated:** [November 16, 2020, 3:51pm UTC](https://forum.inductiveautomation.com/t/bug-yt-302-project-inheritance-forcing-overrides/38516 "2020-11-16T15:51:46Z")
We are still trying to find some re-producible steps, but we keep having issues with inherited projects (in this case the “global” that was auto created from the 7.9 upgrade. Many of our projects have a full copy of the… --- ## [noInterpolation parameter for system.tag.queryTagHistory() is not working correctly](https://forum.inductiveautomation.com/t/nointerpolation-parameter-for-system-tag-querytaghistory-is-not-working-correctly/40644)
**Author:** [@informatica](https://forum.inductiveautomation.com/u/informatica)\ **Replies:** 4\ **Last updated:** [November 16, 2020, 3:01pm UTC](https://forum.inductiveautomation.com/t/nointerpolation-parameter-for-system-tag-querytaghistory-is-not-working-correctly/40644 "2020-11-16T15:01:41Z")
Good Afternoon. I’m using Ignition 8.0.14 and I think the noInterpolation parameter for system.tag.queryTagHistory() is not working correctly. I have configured a tag to be historized in the following way. If I chan… --- ## [\[BUG-975\] Vision: Web Browser: PopUp](https://forum.inductiveautomation.com/t/bug-975-vision-web-browser-popup/34297)
**Author:** [@iscrac](https://forum.inductiveautomation.com/u/iscrac)\ **Replies:** 38\ **Last updated:** [November 16, 2020, 8:31am UTC](https://forum.inductiveautomation.com/t/bug-975-vision-web-browser-popup/34297 "2020-11-16T08:31:26Z")
Hi! I created a page, where I pasted Web Browser component, so I connected to the page from perspective Module (for example ‘/main’). In this ‘/main’ page I have the button and when I press this button the page opens i… --- ## [Perspective Table Progress Bar](https://forum.inductiveautomation.com/t/perspective-table-progress-bar/31015)
**Author:** [@jreynolds](https://forum.inductiveautomation.com/u/jreynolds)\ **Replies:** 2\ **Last updated:** [November 16, 2020, 7:01am UTC](https://forum.inductiveautomation.com/t/perspective-table-progress-bar/31015 "2020-11-16T07:01:26Z")
When configuring the progress bar on the Table Component in Perspective 8.0.7. I would like to bind the max value property to another value on the same row, but in a different column. In the attached image I would like… --- ## [How to use dropdown component with a multi-column dataset to return all fields for the selected item](https://forum.inductiveautomation.com/t/how-to-use-dropdown-component-with-a-multi-column-dataset-to-return-all-fields-for-the-selected-item/40680)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 1\ **Last updated:** [November 16, 2020, 6:54am UTC](https://forum.inductiveautomation.com/t/how-to-use-dropdown-component-with-a-multi-column-dataset-to-return-all-fields-for-the-selected-item/40680 "2020-11-16T06:54:12Z")
I have a dropdown menu that is populated by a multi-column (4) dataset. Many of the columns can have the same values but are unique as a row when you consider all column values. The dropdown only seems to show item name… --- ## [\[BUG\] 8.1.0 Page configuration Primary View does not accept typed view paths](https://forum.inductiveautomation.com/t/bug-8-1-0-page-configuration-primary-view-does-not-accept-typed-view-paths/40678)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 0\ **Last updated:** [November 16, 2020, 2:38am UTC](https://forum.inductiveautomation.com/t/bug-8-1-0-page-configuration-primary-view-does-not-accept-typed-view-paths/40678 "2020-11-16T02:38:22Z")
When adding a new page to the Perspective page configuration, you can’t type or paste view paths into the Primary View field, you have to manually navigate to the view from the dropdown menu. --- ## [Gwcmd causes batch file to exit after restoring gateway backup](https://forum.inductiveautomation.com/t/gwcmd-causes-batch-file-to-exit-after-restoring-gateway-backup/40518)
**Author:** [@ASF](https://forum.inductiveautomation.com/u/ASF)\ **Replies:** 4\ **Last updated:** [November 16, 2020, 1:35am UTC](https://forum.inductiveautomation.com/t/gwcmd-causes-batch-file-to-exit-after-restoring-gateway-backup/40518 "2020-11-16T01:35:43Z")
I am writing a batch file to set up a few things on a new Ignition Gateway PC. The first thing it does is to restore a gateway backup. Following that, I want it to do things like open ports in the firewall and so on. Ho… --- ## [Tag Event Script on Document tag](https://forum.inductiveautomation.com/t/tag-event-script-on-document-tag/40673)
**Author:** [@dhiren.naidoo](https://forum.inductiveautomation.com/u/dhiren.naidoo)\ **Replies:** 4\ **Last updated:** [November 15, 2020, 8:05pm UTC](https://forum.inductiveautomation.com/t/tag-event-script-on-document-tag/40673 "2020-11-15T20:05:31Z")
Hi everyone So, I am struggling with a Tag Event (Value Change) script on a Memory Document tag. (Gateway V8.1.0) Ideally, I want the user to click a button on a perspective view that writes to a custom prop (type:obje… --- ## [404 Error](https://forum.inductiveautomation.com/t/404-error/3048)
**Author:** [@Forrest\_APF](https://forum.inductiveautomation.com/u/Forrest_APF)\ **Replies:** 16\ **Last updated:** [November 15, 2020, 4:16pm UTC](https://forum.inductiveautomation.com/t/404-error/3048 "2020-11-15T16:16:51Z")
Yesterday we noticed that when we would browse to our IA server, port 8088, we would get the bellow error: HTTP Status 404 - type Status report message description The requested resource () is not available. Apach… --- ## [IP Camera Viewer - Exception: Received HTTP 503: Service Unavailable after loss of connection](https://forum.inductiveautomation.com/t/ip-camera-viewer-exception-received-http-503-service-unavailable-after-loss-of-connection/40665)
**Author:** [@rpavlicek](https://forum.inductiveautomation.com/u/rpavlicek)\ **Replies:** 2\ **Last updated:** [November 14, 2020, 8:05pm UTC](https://forum.inductiveautomation.com/t/ip-camera-viewer-exception-received-http-503-service-unavailable-after-loss-of-connection/40665 "2020-11-14T20:05:54Z")
I have an Axis IP Camera setup to a Blue Iris server which is acting as a web server. Using the IP Camera Viewer in Ignition, I can connect to that camera’s view via a JPEG Stills mode, however if there is a disconnecti… --- ## [Expression binding with tag transform in perspective](https://forum.inductiveautomation.com/t/expression-binding-with-tag-transform-in-perspective/40659)
**Author:** [@cole.sharrah](https://forum.inductiveautomation.com/u/cole.sharrah)\ **Replies:** 2\ **Last updated:** [November 14, 2020, 6:54pm UTC](https://forum.inductiveautomation.com/t/expression-binding-with-tag-transform-in-perspective/40659 "2020-11-14T18:54:17Z")
I want an expression to determine the color of a text box by looking at 2 tags for communication status. I have an expression tag that works; when I copy that expression into the color binding with a transform, it does … --- ## [Checkbox not rendering](https://forum.inductiveautomation.com/t/checkbox-not-rendering/40661)
**Author:** [@TusaBrat](https://forum.inductiveautomation.com/u/TusaBrat)\ **Replies:** 1\ **Last updated:** [November 14, 2020, 6:42pm UTC](https://forum.inductiveautomation.com/t/checkbox-not-rendering/40661 "2020-11-14T18:42:20Z")
Has anyone else had an issue where the checkbox is not rendering? I have tried material/check\_box. When that didn’t work, I downloaded the checkbox image from materialsio and placed it in the image library, then pointe… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1098) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1100)