# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=838 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 839 --- ## [Named Queries in Value Changed Tag Event Scripts](https://forum.inductiveautomation.com/t/named-queries-in-value-changed-tag-event-scripts/28589)
**Author:** [@gerhard.louw](https://forum.inductiveautomation.com/u/gerhard.louw)\ **Replies:** 4\ **Last updated:** [May 22, 2022, 11:16pm UTC](https://forum.inductiveautomation.com/t/named-queries-in-value-changed-tag-event-scripts/28589 "2022-05-22T23:16:14Z")
Good day, I am having difficulty in executing a Named Query in a Value Changed Tag Event Script. So this idea is that when my control step changes it populates a database for reporting. When I test the name query it w… --- ## [Refresh windows after making a change](https://forum.inductiveautomation.com/t/refresh-windows-after-making-a-change/59869)
**Author:** [@Esmeralda\_Lopez](https://forum.inductiveautomation.com/u/Esmeralda_Lopez)\ **Replies:** 3\ **Last updated:** [May 22, 2022, 8:37am UTC](https://forum.inductiveautomation.com/t/refresh-windows-after-making-a-change/59869 "2022-05-22T08:37:04Z")
Hello everyone, I want to refresh all windows to see the new change, how can I do that? If some 2 State Toggle change : TAG State toggle | Do ===============|============================ 'ON' | Enabl… --- ## [Tagvalue read fault](https://forum.inductiveautomation.com/t/tagvalue-read-fault/59870)
**Author:** [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\ **Replies:** 2\ **Last updated:** [May 22, 2022, 5:05am UTC](https://forum.inductiveautomation.com/t/tagvalue-read-fault/59870 "2022-05-22T05:05:00Z")
I need read all this folder’s tag value pathList=\[\] results = system.tag.browse(path = '\[Malu OPC tags\]Slitter/MaterialJob/Cut1', filter = {}) for result in results.getResults(): path=result\[u'fullPath'\] pathL… --- ## [Compare Template Differences](https://forum.inductiveautomation.com/t/compare-template-differences/59876)
**Author:** [@jgoodwill](https://forum.inductiveautomation.com/u/jgoodwill)\ **Replies:** 4\ **Last updated:** [May 21, 2022, 11:19pm UTC](https://forum.inductiveautomation.com/t/compare-template-differences/59876 "2022-05-21T23:19:03Z")
Is there a way to compare two templates or popups to determine if the two are identical or not, and if not what the differences are? I would like to compare a template from one project to another to determine if any cha… --- ## [HttpResponseException: 500 Internal Server Error](https://forum.inductiveautomation.com/t/httpresponseexception-500-internal-server-error/3448)
**Author:** [@driguez](https://forum.inductiveautomation.com/u/driguez)\ **Replies:** 6\ **Last updated:** [May 21, 2022, 10:19pm UTC](https://forum.inductiveautomation.com/t/httpresponseexception-500-internal-server-error/3448 "2022-05-21T22:19:31Z")
Dear, When upgrading the license to the system will throw the following error when starting a project Error launching aplication: HttpResponseException: 500: Internal Server Error windows server 2008 Ignition 7.2.… --- ## [IBM DB2 Named Query won't Run](https://forum.inductiveautomation.com/t/ibm-db2-named-query-wont-run/21674)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 2\ **Last updated:** [May 21, 2022, 3:04pm UTC](https://forum.inductiveautomation.com/t/ibm-db2-named-query-wont-run/21674 "2022-05-21T15:04:07Z")
I'm trying to run a named query on a IBM DB2 db, but I keep getting an error. The query runs perfect while using the testing tab. I have table bindings that uses named queries to this same db without issue. When I try… --- ## [Script editor Custom Methods](https://forum.inductiveautomation.com/t/script-editor-custom-methods/59852)
**Author:** [@Dustin\_VanKeuren](https://forum.inductiveautomation.com/u/Dustin_VanKeuren)\ **Replies:** 4\ **Last updated:** [May 20, 2022, 6:34pm UTC](https://forum.inductiveautomation.com/t/script-editor-custom-methods/59852 "2022-05-20T18:34:42Z")
When trying to copy code, if the selected text contains the def line, nothing is put on the clipboard. This led me to believe copy/paste was not working because I was trying to copy a script from one screen to another a… --- ## [Capture Image from Camera Feed in Perspective](https://forum.inductiveautomation.com/t/capture-image-from-camera-feed-in-perspective/59851)
**Author:** [@danieltalbot](https://forum.inductiveautomation.com/u/danieltalbot)\ **Replies:** 2\ **Last updated:** [May 20, 2022, 6:15pm UTC](https://forum.inductiveautomation.com/t/capture-image-from-camera-feed-in-perspective/59851 "2022-05-20T18:15:36Z")
Is it possible to capture an image from a live camera feed in Perspective like you could in Vision using the system.print.captureImage() function? --- ## [Slicing a String](https://forum.inductiveautomation.com/t/slicing-a-string/59845)
**Author:** [@christgustavoe](https://forum.inductiveautomation.com/u/christgustavoe)\ **Replies:** 3\ **Last updated:** [May 20, 2022, 6:14pm UTC](https://forum.inductiveautomation.com/t/slicing-a-string/59845 "2022-05-20T18:14:11Z")
Hello, I´m reading a string tag over OPC connection: { “Job222222Guid”: “863b5079-6c42-4f3f-a865-bda506d7a555”, “ExternalJobGuid”: “00000000-0000-0000-0000-000000000000”, "Name": “JOB069216-002”, “Description”: “#F… --- ## [Perspective Table Invalid Keys](https://forum.inductiveautomation.com/t/perspective-table-invalid-keys/59796)
**Author:** [@jcaudle](https://forum.inductiveautomation.com/u/jcaudle)\ **Replies:** 9\ **Last updated:** [May 20, 2022, 5:57pm UTC](https://forum.inductiveautomation.com/t/perspective-table-invalid-keys/59796 "2022-05-20T17:57:40Z")
I have a somewhat complicated perspective table with a subview and footer groups. There are no red marks in the table. No issues in the columns nor footer groups nor subview. I can’t find a single error and yet I have “… --- ## [Showing 10 recent Alarm on Alarm Status Table](https://forum.inductiveautomation.com/t/showing-10-recent-alarm-on-alarm-status-table/39012)
**Author:** [@lorenz.gulane](https://forum.inductiveautomation.com/u/lorenz.gulane)\ **Replies:** 1\ **Last updated:** [May 20, 2022, 5:43pm UTC](https://forum.inductiveautomation.com/t/showing-10-recent-alarm-on-alarm-status-table/39012 "2022-05-20T17:43:48Z")
I tried to filter or lessen the rows being shown on an Alarm Status Table and yet, its stikk showing all alarms. How am I supposed to do filtering it like showing only the 10 recent alarms? --- ## [Update Perspective Table - unicode indices must be integers](https://forum.inductiveautomation.com/t/update-perspective-table-unicode-indices-must-be-integers/59804)
**Author:** [@Andrea\_Rector](https://forum.inductiveautomation.com/u/Andrea_Rector)\ **Replies:** 6\ **Last updated:** [May 20, 2022, 5:10pm UTC](https://forum.inductiveautomation.com/t/update-perspective-table-unicode-indices-must-be-integers/59804 "2022-05-20T17:10:25Z")
I’ve gotten stuck on how to make my table in Perspective editable and write back to the database. Here’s the process: Table data bound to query (default format) The following script runs on the query, making all ce… --- ## [Designer Panel Resizing and Scrolling](https://forum.inductiveautomation.com/t/designer-panel-resizing-and-scrolling/59846)
**Author:** [@kgamble](https://forum.inductiveautomation.com/u/kgamble)\ **Replies:** 2\ **Last updated:** [May 20, 2022, 4:48pm UTC](https://forum.inductiveautomation.com/t/designer-panel-resizing-and-scrolling/59846 "2022-05-20T16:48:32Z")
Often when using the designer and switching between views, named queries, and project scripts. I deal with this super annoying resizing of the panels that causes me to accidentally open things I don’t want to when double… --- ## [How to query video from SQL Server into Perspective VideoPlayer component?](https://forum.inductiveautomation.com/t/how-to-query-video-from-sql-server-into-perspective-videoplayer-component/59807)
**Author:** [@ericmoulton](https://forum.inductiveautomation.com/u/ericmoulton)\ **Replies:** 6\ **Last updated:** [May 20, 2022, 4:14pm UTC](https://forum.inductiveautomation.com/t/how-to-query-video-from-sql-server-into-perspective-videoplayer-component/59807 "2022-05-20T16:14:12Z")
I am storing images in a SQL Server as varbinary(max), and retrieving them into the source property of an image component with a scalar named query like: select cast(’’ as xml).value(‘xs:base64Binary(sql:column("\[tbl\].\[… --- ## [Checkbox Switch Statement](https://forum.inductiveautomation.com/t/checkbox-switch-statement/59837)
**Author:** [@csilk](https://forum.inductiveautomation.com/u/csilk)\ **Replies:** 6\ **Last updated:** [May 20, 2022, 3:19pm UTC](https://forum.inductiveautomation.com/t/checkbox-switch-statement/59837 "2022-05-20T15:19:38Z")
I have 4 checkboxes and a text field. If the user selects checkbox1, I want “1” to display in the text field. If the user selects checkbox2, I want “2” to display in the text field. And so on… I have the following code … --- ## ['Designer Needs to be Manually Restarted' After short Timeout](https://forum.inductiveautomation.com/t/designer-needs-to-be-manually-restarted-after-short-timeout/57560)
**Author:** [@tmahaf](https://forum.inductiveautomation.com/u/tmahaf)\ **Replies:** 1\ **Last updated:** [May 20, 2022, 2:58pm UTC](https://forum.inductiveautomation.com/t/designer-needs-to-be-manually-restarted-after-short-timeout/57560 "2022-05-20T14:58:54Z")
Sometimes my VPN goes in and out, only might lose connection for a few seconds, but when it comes back online I get this message: Is there a setting somewhere that I can adjust so it doesn’t require this if I lose con… --- ## [\[Bug-2887\] Issue with commented parameter binding with Postgres (maybe others)](https://forum.inductiveautomation.com/t/bug-2887-issue-with-commented-parameter-binding-with-postgres-maybe-others/59831)
**Author:** [@DanielAbdelsamed](https://forum.inductiveautomation.com/u/DanielAbdelsamed)\ **Replies:** 6\ **Last updated:** [May 20, 2022, 2:38pm UTC](https://forum.inductiveautomation.com/t/bug-2887-issue-with-commented-parameter-binding-with-postgres-maybe-others/59831 "2022-05-20T14:38:07Z")
When creating a named query, having parts of the query commented out can be useful. Especially during debugging and for helping other developers. When a parameter is referenced within a query (non-commented), then also … --- ## [Python requests library](https://forum.inductiveautomation.com/t/python-requests-library/59778)
**Author:** [@louagejasper](https://forum.inductiveautomation.com/u/louagejasper)\ **Replies:** 8\ **Last updated:** [May 20, 2022, 2:25pm UTC](https://forum.inductiveautomation.com/t/python-requests-library/59778 "2022-05-20T14:25:08Z")
Hi, We try to use the requests library in Ignition (8.1.15). We get this error: Error running action 'component.onActionPerformed' on jasperlg@D/root/Button: Traceback (most recent call last): File "\ **Author:** [@Patrick\_Njogu](https://forum.inductiveautomation.com/u/Patrick_Njogu)\ **Replies:** 6\ **Last updated:** [May 20, 2022, 1:16pm UTC](https://forum.inductiveautomation.com/t/java-swing-role-in-the-inner-working-of-ignition/59833 "2022-05-20T13:16:05Z") I am an experienced Java Swing programmer and would love to work on Ignition. Ignition is totally new to me as is the automation industry. Naturally, I am starting at Induction University (and looking at the reported bug… --- ## [Increase a tag value by scripting](https://forum.inductiveautomation.com/t/increase-a-tag-value-by-scripting/59821)
**Author:** [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\ **Replies:** 4\ **Last updated:** [May 20, 2022, 12:23pm UTC](https://forum.inductiveautomation.com/t/increase-a-tag-value-by-scripting/59821 "2022-05-20T12:23:41Z")
c=currentValue.value p=previousValue.value if not initialChange: if p!=c: if c==0: BDindex=system.tag.readAsync("\[Malu OPC tags\]Rubber\_Extruder/BDIndex/BDIndex").value system.tag.writeAsync("\[Malu … --- ## [Ignition Tag Providers](https://forum.inductiveautomation.com/t/ignition-tag-providers/59817)
**Author:** [@elliot.lohr](https://forum.inductiveautomation.com/u/elliot.lohr)\ **Replies:** 2\ **Last updated:** [May 20, 2022, 12:08pm UTC](https://forum.inductiveautomation.com/t/ignition-tag-providers/59817 "2022-05-20T12:08:36Z")
Curious if Ignition Tag Providers are accessible through Windows File explorer? If it is, can this data be moved between gateways? I have a coworker who seems to have tanked their gateway and is trying to salvage anythin… --- ## [Easy Chart: convert varchar to datetime](https://forum.inductiveautomation.com/t/easy-chart-convert-varchar-to-datetime/59822)
**Author:** [@Ignition\_Tourists](https://forum.inductiveautomation.com/u/Ignition_Tourists)\ **Replies:** 1\ **Last updated:** [May 20, 2022, 12:01pm UTC](https://forum.inductiveautomation.com/t/easy-chart-convert-varchar-to-datetime/59822 "2022-05-20T12:01:13Z")
Hi All, I want to Chart Value from a data base with Easy Chart. In my table the date has the format yyyy-mm-ddT hh:mm:ssZ as a VARCHAR. In Easy Chart Customizer when I select the time Column i have this error: “The t… --- ## [Uploading photos, Temp storage then into database](https://forum.inductiveautomation.com/t/uploading-photos-temp-storage-then-into-database/59820)
**Author:** [@andrewbrown](https://forum.inductiveautomation.com/u/andrewbrown)\ **Replies:** 1\ **Last updated:** [May 20, 2022, 11:56am UTC](https://forum.inductiveautomation.com/t/uploading-photos-temp-storage-then-into-database/59820 "2022-05-20T11:56:32Z")
Hi All, I was wondering if there was any way of using the Fileupload component, storing the data (.toBytes) in a parameter to pass through to the root view to do a group upload into an MSSQL server. Reason being is the… --- ## [Change Custom Property values depending on switches](https://forum.inductiveautomation.com/t/change-custom-property-values-depending-on-switches/59823)
**Author:** [@hugobre](https://forum.inductiveautomation.com/u/hugobre)\ **Replies:** 5\ **Last updated:** [May 20, 2022, 10:05am UTC](https://forum.inductiveautomation.com/t/change-custom-property-values-depending-on-switches/59823 "2022-05-20T10:05:09Z")
Hey ! I have those 3 customs property right here. I want them to change their values depending on the state of the switches bellow. I guess that I have to script somewhere but I don’t know where. Thanks ! --- ## [MQTT Engine wont connect to The Things Stack public broker](https://forum.inductiveautomation.com/t/mqtt-engine-wont-connect-to-the-things-stack-public-broker/59717)
**Author:** [@Justin\_Byers](https://forum.inductiveautomation.com/u/Justin_Byers)\ **Replies:** 5\ **Last updated:** [May 20, 2022, 8:12am UTC](https://forum.inductiveautomation.com/t/mqtt-engine-wont-connect-to-the-things-stack-public-broker/59717 "2022-05-20T08:12:48Z")
Hi all, I was wondering if anyone had has this issue where the MQTT engine wont connect to the TTS puclic MQTT broker. --- ## [Wondering the best way forward with this request](https://forum.inductiveautomation.com/t/wondering-the-best-way-forward-with-this-request/59810)
**Author:** [@MikeAllgood](https://forum.inductiveautomation.com/u/MikeAllgood)\ **Replies:** 6\ **Last updated:** [May 20, 2022, 6:41am UTC](https://forum.inductiveautomation.com/t/wondering-the-best-way-forward-with-this-request/59810 "2022-05-20T06:41:58Z")
I’ve been asked to create something like this, , where the “bubble” indicator would display the number of active items returned from a query of an eternal application. I am fairly confident that there is not an out of … --- ## [Perspective Tree - restore tree expansion after self.refreshBinding("props.items")](https://forum.inductiveautomation.com/t/perspective-tree-restore-tree-expansion-after-self-refreshbinding-props-items/59779)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 6\ **Last updated:** [May 20, 2022, 6:29am UTC](https://forum.inductiveautomation.com/t/perspective-tree-restore-tree-expansion-after-self-refreshbinding-props-items/59779 "2022-05-20T06:29:24Z")
Ignition V8.1.15 I need to refresh the tree to eliminate the branch if it is now empty or add a new branch if one has been created. The problem is that the tree collapses so the user has to navigate the tree again. Th… --- ## [Perspective table binding in narrow mode](https://forum.inductiveautomation.com/t/perspective-table-binding-in-narrow-mode/59233)
**Author:** [@ASF](https://forum.inductiveautomation.com/u/ASF)\ **Replies:** 3\ **Last updated:** [May 19, 2022, 10:49pm UTC](https://forum.inductiveautomation.com/t/perspective-table-binding-in-narrow-mode/59233 "2022-05-19T22:49:20Z")
I have a named query that returns a single row of batch data, e.g.: ID: ABC123 Description: My Batch WeightSP: 100 WeightPV: 101 Status: Complete …and I would like to display it in a table, looking just like it does ab… --- ## [Ignition Query Alarm Journal causing gateway crash](https://forum.inductiveautomation.com/t/ignition-query-alarm-journal-causing-gateway-crash/59769)
**Author:** [@liam1](https://forum.inductiveautomation.com/u/liam1)\ **Replies:** 9\ **Last updated:** [May 19, 2022, 9:38pm UTC](https://forum.inductiveautomation.com/t/ignition-query-alarm-journal-causing-gateway-crash/59769 "2022-05-19T21:38:09Z")
Hi all, When running the system.alarm.queryJournal() function the gateway’s memory starts to fill up , which then leads to the gateway crashing. Is there a performant way to use this function in order to stop this fro… --- ## [Change Script on View Param works in Preview but not in Client](https://forum.inductiveautomation.com/t/change-script-on-view-param-works-in-preview-but-not-in-client/59753)
**Author:** [@nicholas.robinson](https://forum.inductiveautomation.com/u/nicholas.robinson)\ **Replies:** 5\ **Last updated:** [May 19, 2022, 9:34pm UTC](https://forum.inductiveautomation.com/t/change-script-on-view-param-works-in-preview-but-not-in-client/59753 "2022-05-19T21:34:20Z")
I have a tag change script on a view param that looks like this: Param (end time in millis) Change Script endMillis = currentValue.value end = system.date.fromMillis(endMillis) # make the range to the most rece… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=837) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=839)