# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=334 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 335 --- ## [Indexes to improve tag history performance](https://forum.inductiveautomation.com/t/indexes-to-improve-tag-history-performance/96052)
**Author:** [@Joel\_Farley](https://forum.inductiveautomation.com/u/Joel_Farley)\ **Replies:** 1\ **Last updated:** [September 17, 2024, 1:43pm UTC](https://forum.inductiveautomation.com/t/indexes-to-improve-tag-history-performance/96052 "2024-09-17T13:43:11Z")
Found myself looking at the sql tables of the tag history directly to get a little bit more information than what can be provided through trend graphs. Wondering what indexes could be put in to improve the performance o… --- ## [Bacnet Invalidate Browser error](https://forum.inductiveautomation.com/t/bacnet-invalidate-browser-error/91591)
**Author:** [@Virgar\_Poulsen](https://forum.inductiveautomation.com/u/Virgar_Poulsen)\ **Replies:** 3\ **Last updated:** [September 17, 2024, 1:25pm UTC](https://forum.inductiveautomation.com/t/bacnet-invalidate-browser-error/91591 "2024-09-17T13:25:01Z")
I'm have huge problems with bacnet, now it won't even allow me to invalidate browse. Anyone else had this issue ? "Failed to invalidate browse cache: data/opcua/devices" Using Ignition Edge 8.1.39 --- ## [Perspective Video player - video duration](https://forum.inductiveautomation.com/t/perspective-video-player-video-duration/96056)
**Author:** [@Jon\_Forbord](https://forum.inductiveautomation.com/u/Jon_Forbord)\ **Replies:** 0\ **Last updated:** [September 17, 2024, 11:31am UTC](https://forum.inductiveautomation.com/t/perspective-video-player-video-duration/96056 "2024-09-17T11:31:28Z")
Hi, Is there a way to get the length/duration of a video loaded with the video-player? I want to make a custom-slider to scroll through several videos, to do this, I need to know the total duration of each video. --- ## [Expression Structure Script to Replace Spaces with Underscore](https://forum.inductiveautomation.com/t/expression-structure-script-to-replace-spaces-with-underscore/95997)
**Author:** [@Ly17](https://forum.inductiveautomation.com/u/Ly17)\ **Replies:** 8\ **Last updated:** [September 17, 2024, 4:18am UTC](https://forum.inductiveautomation.com/t/expression-structure-script-to-replace-spaces-with-underscore/95997 "2024-09-17T04:18:17Z")
I have the following transform script but it's only replacing spaces with underscores at the top level of the object structure and not any of the sub-levels. def transform(self, value, quality, timestamp): # Create … --- ## [Export data into a Google Drive folder](https://forum.inductiveautomation.com/t/export-data-into-a-google-drive-folder/44978)
**Author:** [@DougSN](https://forum.inductiveautomation.com/u/DougSN)\ **Replies:** 7\ **Last updated:** [September 17, 2024, 3:28am UTC](https://forum.inductiveautomation.com/t/export-data-into-a-google-drive-folder/44978 "2024-09-17T03:28:03Z")
Has anyone successfully written code to export data to a file on Google Drive through Ignition? I would want to have a gateway script that checks for the data, creates a dataset, and then puts it into a spreadsheet on Go… --- ## [Pespective webpage change to phone sms interface and auto fill the info](https://forum.inductiveautomation.com/t/pespective-webpage-change-to-phone-sms-interface-and-auto-fill-the-info/96013)
**Author:** [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\ **Replies:** 4\ **Last updated:** [September 17, 2024, 2:15am UTC](https://forum.inductiveautomation.com/t/pespective-webpage-change-to-phone-sms-interface-and-auto-fill-the-info/96013 "2024-09-17T02:15:07Z")
I have seen some app that when you type some sms message and select some recipients, then click 'bulk Send', it will automatically change to the phone sms app and fill up the sms mesaage body and recipients using the inf… --- ## [Scripting with User Roles](https://forum.inductiveautomation.com/t/scripting-with-user-roles/96007)
**Author:** [@Phat\_Truc](https://forum.inductiveautomation.com/u/Phat_Truc)\ **Replies:** 7\ **Last updated:** [September 17, 2024, 1:56am UTC](https://forum.inductiveautomation.com/t/scripting-with-user-roles/96007 "2024-09-17T01:56:45Z")
In my project, there are 5 roles: Admin: 4, Supervisor: 3, Engineer: 2, Operator: 1, and Monitor: 0. (shown in the picture below) When scripting with components in Vision, I want to disable components that do not hav… --- ## [Retrieving and viewing data in SQL query](https://forum.inductiveautomation.com/t/retrieving-and-viewing-data-in-sql-query/96037)
**Author:** [@Enrique\_Torres](https://forum.inductiveautomation.com/u/Enrique_Torres)\ **Replies:** 3\ **Last updated:** [September 16, 2024, 10:06pm UTC](https://forum.inductiveautomation.com/t/retrieving-and-viewing-data-in-sql-query/96037 "2024-09-16T22:06:22Z")
greetings everyone! I am very new to ignition. I am wondering if anyone can help me with viewing data from query (rows and columns) in reports. I know where it is coming from (tags) but I don't know where the table is lo… --- ## [Controller Template with Interlock](https://forum.inductiveautomation.com/t/controller-template-with-interlock/95854)
**Author:** [@Melvin\_Miclat](https://forum.inductiveautomation.com/u/Melvin_Miclat)\ **Replies:** 8\ **Last updated:** [September 16, 2024, 9:18pm UTC](https://forum.inductiveautomation.com/t/controller-template-with-interlock/95854 "2024-09-16T21:18:20Z")
I have created a controller template with Interlock. I would like to make the interlock group shape to be invisible if there is no associated interlock. This is actually a 2 part question. We will deal with this one firs… --- ## [Write Dataset to Array](https://forum.inductiveautomation.com/t/write-dataset-to-array/96035)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 1\ **Last updated:** [September 16, 2024, 8:44pm UTC](https://forum.inductiveautomation.com/t/write-dataset-to-array/96035 "2024-09-16T20:44:40Z")
I have a string array that I'm using to initially populate a dataset on a view. The property's dataset is filled in via tag read on a change script, but I do not want it written until an "apply" button is clicked. So, be… --- ## [New Browser Tab/Popup - Stay on Top](https://forum.inductiveautomation.com/t/new-browser-tab-popup-stay-on-top/96030)
**Author:** [@Jake\_Geers](https://forum.inductiveautomation.com/u/Jake_Geers)\ **Replies:** 0\ **Last updated:** [September 16, 2024, 6:19pm UTC](https://forum.inductiveautomation.com/t/new-browser-tab-popup-stay-on-top/96030 "2024-09-16T18:19:59Z")
Hello, I have a button in Perspective with an action to navigate to another page in a new tab. When I click the button in Perspective, a new browser tab is opened as expected. When I click the button from Edge (Pers… --- ## [Pipes not showing in Perspective Development](https://forum.inductiveautomation.com/t/pipes-not-showing-in-perspective-development/96029)
**Author:** [@ster](https://forum.inductiveautomation.com/u/ster)\ **Replies:** 2\ **Last updated:** [September 16, 2024, 7:33pm UTC](https://forum.inductiveautomation.com/t/pipes-not-showing-in-perspective-development/96029 "2024-09-16T19:33:59Z")
I'm trying to use the Piping tool in Perspective for the first time and it all seems straightforward, but when I place a pipe on my development screen, nothing shows up. It shows all the handles on other objects, each t… --- ## [Error trying to use a template with a dataset](https://forum.inductiveautomation.com/t/error-trying-to-use-a-template-with-a-dataset/94270)
**Author:** [@Harry\_Elwell](https://forum.inductiveautomation.com/u/Harry_Elwell)\ **Replies:** 6\ **Last updated:** [September 16, 2024, 6:36pm UTC](https://forum.inductiveautomation.com/t/error-trying-to-use-a-template-with-a-dataset/94270 "2024-09-16T18:36:07Z")
I am working on a project and need to create a template with a Numeric Label for the value and a Label for the description. There is a custom property "mbRegister" on the root container of the template. There is an indir… --- ## [Ignition Perspective Name Query Reporting](https://forum.inductiveautomation.com/t/ignition-perspective-name-query-reporting/96025)
**Author:** [@ahawes](https://forum.inductiveautomation.com/u/ahawes)\ **Replies:** 6\ **Last updated:** [September 16, 2024, 6:16pm UTC](https://forum.inductiveautomation.com/t/ignition-perspective-name-query-reporting/96025 "2024-09-16T18:16:18Z")
Good afternoon Team, I am trying to build a barchart within a report. Here is my set up for the chart. Here is what i am getting back. Is there a way to chose what goes into the axis and columns? The chart is only… --- ## [Bind to String Array Element, Bad\_OutOfRange Quality](https://forum.inductiveautomation.com/t/bind-to-string-array-element-bad-outofrange-quality/95974)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 7\ **Last updated:** [September 16, 2024, 5:50pm UTC](https://forum.inductiveautomation.com/t/bind-to-string-array-element-bad-outofrange-quality/95974 "2024-09-16T17:50:25Z")
I have a string array tag and I'm binding to the individual elements. If I drag the \[0\] element onto a property it gives me the tag binding path, then I change it to be indirect \[elevator\]Test/Downstream\_Eq\_Numbers\[0\] … --- ## [How to prevent shelving critical alarms?](https://forum.inductiveautomation.com/t/how-to-prevent-shelving-critical-alarms/96023)
**Author:** [@Patrick\_Whitlock](https://forum.inductiveautomation.com/u/Patrick_Whitlock)\ **Replies:** 1\ **Last updated:** [September 16, 2024, 5:11pm UTC](https://forum.inductiveautomation.com/t/how-to-prevent-shelving-critical-alarms/96023 "2024-09-16T17:11:04Z")
Hello, I am using the Alarm Status Table element in Perspective, and I want to make it so that you cannot shelf a critical alarm, but any other lower priority alarm can be shelved. Is this possible? Thanks! --- ## [Perspective: Unable to see view "View not found - no view configured"](https://forum.inductiveautomation.com/t/perspective-unable-to-see-view-view-not-found-no-view-configured/96016)
**Author:** [@IAKC](https://forum.inductiveautomation.com/u/IAKC)\ **Replies:** 3\ **Last updated:** [September 16, 2024, 4:45pm UTC](https://forum.inductiveautomation.com/t/perspective-unable-to-see-view-view-not-found-no-view-configured/96016 "2024-09-16T16:45:25Z")
I am unable to view a page on my phone. I can browse to the page on my host machine. Gateway is in a VM. On my phone I tried going to the page using Chrome and Brave. I also installed the app which finds the gateway and … --- ## [AlarmJournalTable - sort order](https://forum.inductiveautomation.com/t/alarmjournaltable-sort-order/96020)
**Author:** [@Amanda\_Marti](https://forum.inductiveautomation.com/u/Amanda_Marti)\ **Replies:** 0\ **Last updated:** [September 16, 2024, 3:34pm UTC](https://forum.inductiveautomation.com/t/alarmjournaltable-sort-order/96020 "2024-09-16T15:34:49Z")
Hello, I need help :cry:. How can I dynamically get the sort order applied to the AlarmJournalTable? When I go to props.columns.(some column).sort, the value of that property never updates. Is there any way to find out … --- ## [Map Marker and Popup](https://forum.inductiveautomation.com/t/map-marker-and-popup/96017)
**Author:** [@Thomas\_MUSSO](https://forum.inductiveautomation.com/u/Thomas_MUSSO)\ **Replies:** 3\ **Last updated:** [September 16, 2024, 2:57pm UTC](https://forum.inductiveautomation.com/t/map-marker-and-popup/96017 "2024-09-16T14:57:25Z")
Hello everyone, I would like to display a popup when I click on a marker in my map. (no problem on that) However, depending on the marker clicked, the title of my popup should be different. Example: click on marker 1… --- ## [Resettable runtime counter](https://forum.inductiveautomation.com/t/resettable-runtime-counter/91299)
**Author:** [@Austin\_Allen](https://forum.inductiveautomation.com/u/Austin_Allen)\ **Replies:** 32\ **Last updated:** [September 16, 2024, 3:00pm UTC](https://forum.inductiveautomation.com/t/resettable-runtime-counter/91299 "2024-09-16T15:00:04Z")
Hello, I'm trying to figure out how to create an expression for a runtime counter. I found this script that works: if({\[~\]P\_1\_RI.value}, if(IsGood({\[~\]P1\_RT.value}),{\[~\]P1\_RT.value},0)+1, if(IsGood({\[~\]P1\_RT.value}),{… --- ## [Serialization Error from Template](https://forum.inductiveautomation.com/t/serialization-error-from-template/96014)
**Author:** [@Noah\_St\_Mark](https://forum.inductiveautomation.com/u/Noah_St_Mark)\ **Replies:** 4\ **Last updated:** [September 16, 2024, 2:53pm UTC](https://forum.inductiveautomation.com/t/serialization-error-from-template/96014 "2024-09-16T14:53:13Z")
Hello, I am getting an error I have never seen before. As well as throwing Null pointer exceptions. Any idea as to why this is happening? I believe it is coming from my template repeater. I have a hunch its due to some … --- ## [Question about scanning barcodes](https://forum.inductiveautomation.com/t/question-about-scanning-barcodes/95734)
**Author:** [@Rajashekar\_Reddy](https://forum.inductiveautomation.com/u/Rajashekar_Reddy)\ **Replies:** 2\ **Last updated:** [September 16, 2024, 2:34pm UTC](https://forum.inductiveautomation.com/t/question-about-scanning-barcodes/95734 "2024-09-16T14:34:16Z")
Hello, I would like to know how to read QR codes from mobile devices and associate them with tags or labels. I have four clients, each with a different mobile application. How can I achieve this? Your guidance would be … --- ## [Perspective DateTime Input issue](https://forum.inductiveautomation.com/t/perspective-datetime-input-issue/96006)
**Author:** [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\ **Replies:** 2\ **Last updated:** [September 16, 2024, 2:29pm UTC](https://forum.inductiveautomation.com/t/perspective-datetime-input-issue/96006 "2024-09-16T14:29:40Z")
I'm on Ignition 8.1.31 and I'm experiencing the following issue on a DateTimeInput: if you set pickerType to time and you try to assign a datetime before 2014-09-16 10:00 AM to the value property, you cannot - the time p… --- ## [Looping a script while tag is on](https://forum.inductiveautomation.com/t/looping-a-script-while-tag-is-on/93402)
**Author:** [@jason\_melcher](https://forum.inductiveautomation.com/u/jason_melcher)\ **Replies:** 20\ **Last updated:** [September 16, 2024, 1:34pm UTC](https://forum.inductiveautomation.com/t/looping-a-script-while-tag-is-on/93402 "2024-09-16T13:34:40Z")
Hi, fairly new to python coding but have experience elsewhere. I'm trying to make a simple script that will loop an audio file while a certain tag is on. In other programming languages I would just use a jump and a labl… --- ## [How to read the tag from Azure Data explorer](https://forum.inductiveautomation.com/t/how-to-read-the-tag-from-azure-data-explorer/96012)
**Author:** [@Hiren\_Kathiriya](https://forum.inductiveautomation.com/u/Hiren_Kathiriya)\ **Replies:** 0\ **Last updated:** [September 16, 2024, 11:23am UTC](https://forum.inductiveautomation.com/t/how-to-read-the-tag-from-azure-data-explorer/96012 "2024-09-16T11:23:13Z")
Hi, I am reading the plants live Tags in Azure Data Explorer & want to browse all the ADX tags in Ignition. Any module need to install in gateway? Any hint/instructions would be appreciated. Thanks you --- ## [Emulating Mouse Clicks With Perspective](https://forum.inductiveautomation.com/t/emulating-mouse-clicks-with-perspective/95864)
**Author:** [@Ryan\_Norton](https://forum.inductiveautomation.com/u/Ryan_Norton)\ **Replies:** 7\ **Last updated:** [September 16, 2024, 6:46am UTC](https://forum.inductiveautomation.com/t/emulating-mouse-clicks-with-perspective/95864 "2024-09-16T06:46:03Z")
I am trying to integrate an Edge deployment with third party app that can only be manipulated with mouse clicks. This is being done to relieve workload on the operator and ensure accuracy. My intent is to use a screen fo… --- ## [\[Bug\]Modbus Device Connection Field Name Formatting](https://forum.inductiveautomation.com/t/bug-modbus-device-connection-field-name-formatting/96000)
**Author:** [@Douglas\_Lawrie](https://forum.inductiveautomation.com/u/Douglas_Lawrie)\ **Replies:** 1\ **Last updated:** [September 16, 2024, 1:35am UTC](https://forum.inductiveautomation.com/t/bug-modbus-device-connection-field-name-formatting/96000 "2024-09-16T01:35:25Z")
Ignition Edge Version: 8.1.43 OS: Windows Server 2022 Modbus device connection names are incorrectly formatted. See screenshot. --- ## [Historical data into sql database](https://forum.inductiveautomation.com/t/historical-data-into-sql-database/95992)
**Author:** [@PRAMANJ](https://forum.inductiveautomation.com/u/PRAMANJ)\ **Replies:** 8\ **Last updated:** [September 15, 2024, 2:07pm UTC](https://forum.inductiveautomation.com/t/historical-data-into-sql-database/95992 "2024-09-15T14:07:59Z")
How can I dump historical time series data of selected tags for a given time range from a table displayed into a database table of given name? --- ## [Exporting Tags with all properties](https://forum.inductiveautomation.com/t/exporting-tags-with-all-properties/95663)
**Author:** [@Ravi\_Achan](https://forum.inductiveautomation.com/u/Ravi_Achan)\ **Replies:** 4\ **Last updated:** [September 14, 2024, 2:44pm UTC](https://forum.inductiveautomation.com/t/exporting-tags-with-all-properties/95663 "2024-09-14T14:44:42Z")
Hi, I want to export tags with all their properties, either XML or JSON will do. I have a lot of OPC tags, which each have the properties I want to export. Most of these tags are derived from UDTs. When I export the tag… --- ## [Table column visible error](https://forum.inductiveautomation.com/t/table-column-visible-error/95940)
**Author:** [@770043297](https://forum.inductiveautomation.com/u/770043297)\ **Replies:** 9\ **Last updated:** [September 15, 2024, 2:02am UTC](https://forum.inductiveautomation.com/t/table-column-visible-error/95940 "2024-09-15T02:02:18Z")
Here's how I configured it Then I select ID visible False, column\_3 is gone. ID is last :smiling\_face\_with\_tear: [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=333) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=335)