# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=858 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 859 --- ## [Using Named Queries to Pull SQLite Tag Historian Data to Find Delta Time](https://forum.inductiveautomation.com/t/using-named-queries-to-pull-sqlite-tag-historian-data-to-find-delta-time/58434)
**Author:** [@Isaac\_Hodgkins](https://forum.inductiveautomation.com/u/Isaac_Hodgkins)\ **Replies:** 5\ **Last updated:** [April 13, 2022, 8:25pm UTC](https://forum.inductiveautomation.com/t/using-named-queries-to-pull-sqlite-tag-historian-data-to-find-delta-time/58434 "2022-04-13T20:25:18Z")
I have a tag that returns a string value of “Running”, “Paused” or “Stopped”. I’d like to take the delta time between each status change and then sum it to get the total run, pause and stop time. In some versions of SQL… --- ## [Designer Password Entering](https://forum.inductiveautomation.com/t/designer-password-entering/58428)
**Author:** [@BryanB](https://forum.inductiveautomation.com/u/BryanB)\ **Replies:** 4\ **Last updated:** [April 13, 2022, 6:42pm UTC](https://forum.inductiveautomation.com/t/designer-password-entering/58428 "2022-04-13T18:42:41Z")
Just ran into a weird quirk when entering a password into the Designer Launcher. If you have a password that has letters followed by a number followed by an underscore, if you hit CTRL+Backspace it only deletes back to … --- ## [Unexpected End of File Client Designer Launcher 7.9.17](https://forum.inductiveautomation.com/t/unexpected-end-of-file-client-designer-launcher-7-9-17/58420)
**Author:** [@wildbilly](https://forum.inductiveautomation.com/u/wildbilly)\ **Replies:** 1\ **Last updated:** [April 13, 2022, 6:37pm UTC](https://forum.inductiveautomation.com/t/unexpected-end-of-file-client-designer-launcher-7-9-17/58420 "2022-04-13T18:37:00Z")
I’ve tried hostname:8088:8043 Ip:8088:8043 and everything in between. Can still reach the gateway webpage. Are there logs somewhere? --- ## [Way to update a dataset and trigger onCellEdited programtically?](https://forum.inductiveautomation.com/t/way-to-update-a-dataset-and-trigger-oncelledited-programtically/58415)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 2\ **Last updated:** [April 13, 2022, 5:14pm UTC](https://forum.inductiveautomation.com/t/way-to-update-a-dataset-and-trigger-oncelledited-programtically/58415 "2022-04-13T17:14:08Z")
I have two tables, one called DetailedView which has it’s data bound to a custom property initialData which is bound to a named query, and another called Overview who’s data property is calculated via expression on the D… --- ## [Get selected date from equipment schedule](https://forum.inductiveautomation.com/t/get-selected-date-from-equipment-schedule/58396)
**Author:** [@richardNZ15](https://forum.inductiveautomation.com/u/richardNZ15)\ **Replies:** 1\ **Last updated:** [April 13, 2022, 5:10pm UTC](https://forum.inductiveautomation.com/t/get-selected-date-from-equipment-schedule/58396 "2022-04-13T17:10:24Z")
I’m trying to create a Vision window that shows scheduled events using the equipment schedule, which is pulling its dataset from a SQL table. Displaying the data is all fine and dandy, but how on earth can we create a n… --- ## [Ignition session users](https://forum.inductiveautomation.com/t/ignition-session-users/58418)
**Author:** [@Esme\_Lopez](https://forum.inductiveautomation.com/u/Esme_Lopez)\ **Replies:** 3\ **Last updated:** [April 13, 2022, 4:18pm UTC](https://forum.inductiveautomation.com/t/ignition-session-users/58418 "2022-04-13T16:18:43Z")
Hi, I want to restrict the login sessions and just open one session per user --- ## [Using a checkbox to display specific markers on a map](https://forum.inductiveautomation.com/t/using-a-checkbox-to-display-specific-markers-on-a-map/58404)
**Author:** [@Conn\_Mccurdy](https://forum.inductiveautomation.com/u/Conn_Mccurdy)\ **Replies:** 1\ **Last updated:** [April 13, 2022, 3:40pm UTC](https://forum.inductiveautomation.com/t/using-a-checkbox-to-display-specific-markers-on-a-map/58404 "2022-04-13T15:40:34Z")
So I am trying to use a map and a checkbox together where I can show pumps and ramps. What I am trying to do is use a checkbox to refine what shows on the map. For example, if I have ramps and and pumps both showing, I c… --- ## [Query help, show selected assets or if none selected show all](https://forum.inductiveautomation.com/t/query-help-show-selected-assets-or-if-none-selected-show-all/58417)
**Author:** [@Dean\_Walsh](https://forum.inductiveautomation.com/u/Dean_Walsh)\ **Replies:** 2\ **Last updated:** [April 13, 2022, 3:07pm UTC](https://forum.inductiveautomation.com/t/query-help-show-selected-assets-or-if-none-selected-show-all/58417 "2022-04-13T15:07:58Z")
I am trying to show a table of assets alarms with a filter for the asset ID, this works well but i would like to have the functionality to show all of the assets when an asset ID is not defined by the user. (When the pa… --- ## [Delete Selected Rows From Table In Perspective?](https://forum.inductiveautomation.com/t/delete-selected-rows-from-table-in-perspective/41880)
**Author:** [@awarunek187](https://forum.inductiveautomation.com/u/awarunek187)\ **Replies:** 7\ **Last updated:** [April 13, 2022, 2:41pm UTC](https://forum.inductiveautomation.com/t/delete-selected-rows-from-table-in-perspective/41880 "2022-04-13T14:41:00Z")
How is this accomplished? It is so easy to do in Vision. I can not seem to get this done in Perspective. --- ## [Numeric text field scripting](https://forum.inductiveautomation.com/t/numeric-text-field-scripting/58412)
**Author:** [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\ **Replies:** 1\ **Last updated:** [April 13, 2022, 1:21pm UTC](https://forum.inductiveautomation.com/t/numeric-text-field-scripting/58412 "2022-04-13T13:21:08Z")
Good day! I am trying to use a numeric text field to change a .value of a tag when entered. Is this the correct way? Im very new to python scripting. --- ## [Sql parameter x was not defined for stored procedure y](https://forum.inductiveautomation.com/t/sql-parameter-x-was-not-defined-for-stored-procedure-y/57113)
**Author:** [@michael.black](https://forum.inductiveautomation.com/u/michael.black)\ **Replies:** 4\ **Last updated:** [April 13, 2022, 12:51pm UTC](https://forum.inductiveautomation.com/t/sql-parameter-x-was-not-defined-for-stored-procedure-y/57113 "2022-04-13T12:51:17Z")
I am running version 7.9.13 of Ignition. I have a MSSQL connection established to a Microsoft SQL DB. I have a Microsoft SQL Server JDBC Driver with jar file of sqljdbc4.jar. This computer is currently installed with … --- ## [Perspective Power-Chart: Show Time in local timezone](https://forum.inductiveautomation.com/t/perspective-power-chart-show-time-in-local-timezone/58407)
**Author:** [@henning.heine](https://forum.inductiveautomation.com/u/henning.heine)\ **Replies:** 2\ **Last updated:** [April 13, 2022, 12:29pm UTC](https://forum.inductiveautomation.com/t/perspective-power-chart-show-time-in-local-timezone/58407 "2022-04-13T12:29:30Z")
I am visualizing historized tags with the perspective power chart. The time axis is always shown in UTC time. Is it possible to change the time format to the local timezone? Thanks in advance for your input! --- ## [Axis visibility - For multiple Y-axis](https://forum.inductiveautomation.com/t/axis-visibility-for-multiple-y-axis/58403)
**Author:** [@Shivani\_Shete](https://forum.inductiveautomation.com/u/Shivani_Shete)\ **Replies:** 4\ **Last updated:** [April 13, 2022, 9:20am UTC](https://forum.inductiveautomation.com/t/axis-visibility-for-multiple-y-axis/58403 "2022-04-13T09:20:56Z")
I’m having multiple pens and Y-axis for easy chart. I have given the inbuild selection option of pens for charts, but it is not working (when deselect, the tag still shows reading on chart). Also I want to give visibil… --- ## [How to find components on other winddows/ template for the scripting](https://forum.inductiveautomation.com/t/how-to-find-components-on-other-winddows-template-for-the-scripting/58400)
**Author:** [@anuradha.upase](https://forum.inductiveautomation.com/u/anuradha.upase)\ **Replies:** 1\ **Last updated:** [April 13, 2022, 5:56am UTC](https://forum.inductiveautomation.com/t/how-to-find-components-on-other-winddows-template-for-the-scripting/58400 "2022-04-13T05:56:18Z")
I have create one template containing numeric fields and I have used that template on the multiple screen, but I want to show some value from the table on that numeric fields. Generally when we used simple numeric field… --- ## [Hiding Specific Rows in Table Perspective](https://forum.inductiveautomation.com/t/hiding-specific-rows-in-table-perspective/58329)
**Author:** [@Casu](https://forum.inductiveautomation.com/u/Casu)\ **Replies:** 5\ **Last updated:** [April 13, 2022, 1:22am UTC](https://forum.inductiveautomation.com/t/hiding-specific-rows-in-table-perspective/58329 "2022-04-13T01:22:54Z")
\[Perspective table in ignition 8.1\] Is there a way to hide rows in a table/change the row height to 0? I am attempting to filter through multiple aspects in columns so I can combine filters and I am able to get an arra… --- ## [\[FEATURE\] Alarm Status Tables: Add ability to show icons for priority, ack status, and status](https://forum.inductiveautomation.com/t/feature-alarm-status-tables-add-ability-to-show-icons-for-priority-ack-status-and-status/58391)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 0\ **Last updated:** [April 13, 2022, 12:57am UTC](https://forum.inductiveautomation.com/t/feature-alarm-status-tables-add-ability-to-show-icons-for-priority-ack-status-and-status/58391 "2022-04-13T00:57:31Z")
This comes from a discussion of other SCADA platforms and a screenshot I saw of one which displays alarms quite nicely in their alarm status table, especially when space is a limiting factor (so most of the time!). Th… --- ## [Tag Change Event Properties](https://forum.inductiveautomation.com/t/tag-change-event-properties/58372)
**Author:** [@robby.tanner](https://forum.inductiveautomation.com/u/robby.tanner)\ **Replies:** 2\ **Last updated:** [April 13, 2022, 12:31am UTC](https://forum.inductiveautomation.com/t/tag-change-event-properties/58372 "2022-04-13T00:31:51Z")
I added a Gateway Tag Change Event script. I printed the event object and saw: Event: ‘com.inductiveautomation.ignition.common.util.FilteredTagChangeListener$FilteredTagChangeEvent@55508c34\[currentValue=\[0, Bad Quality,… --- ## [Ignition Modules - Unsure What I Really Need](https://forum.inductiveautomation.com/t/ignition-modules-unsure-what-i-really-need/58360)
**Author:** [@Russell\_Gibson](https://forum.inductiveautomation.com/u/Russell_Gibson)\ **Replies:** 13\ **Last updated:** [April 12, 2022, 10:14pm UTC](https://forum.inductiveautomation.com/t/ignition-modules-unsure-what-i-really-need/58360 "2022-04-12T22:14:57Z")
Hi All - Looking at a 2nd Ignition project, the first I didn’t have to worry about licensing as it was covered by the clients site enterprise license. This time we have to provide the license. So…firstly we’re UK based … --- ## [Strip R, G, and B Components from Color as String in Expression](https://forum.inductiveautomation.com/t/strip-r-g-and-b-components-from-color-as-string-in-expression/57999)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 7\ **Last updated:** [April 12, 2022, 10:13pm UTC](https://forum.inductiveautomation.com/t/strip-r-g-and-b-components-from-color-as-string-in-expression/57999 "2022-04-12T22:13:47Z")
I have a color String that I’m using to format the color of objects (i.e. “RRR,GGG,BBB”). How can I split this into an individual RRR, GGG, or BBB value using Ignition’s expression language? --- ## [EAM Backup Tasks](https://forum.inductiveautomation.com/t/eam-backup-tasks/17899)
**Author:** [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\ **Replies:** 10\ **Last updated:** [April 12, 2022, 9:52pm UTC](https://forum.inductiveautomation.com/t/eam-backup-tasks/17899 "2022-04-12T21:52:57Z")
I am collecting backups for several Ignition Gateway servers via EAM. I am able to see the list of backups, but I do not see any way to purge old backups? Is there something somewhere what I am missing? It would be ni… --- ## [Python OPC-UA for AI/ML in Ignition](https://forum.inductiveautomation.com/t/python-opc-ua-for-ai-ml-in-ignition/58379)
**Author:** [@miles.brim](https://forum.inductiveautomation.com/u/miles.brim)\ **Replies:** 1\ **Last updated:** [April 12, 2022, 9:50pm UTC](https://forum.inductiveautomation.com/t/python-opc-ua-for-ai-ml-in-ignition/58379 "2022-04-12T21:50:09Z")
This post is a follow-up to the previous post on “Machine Learning in Ignition using MATLAB” My goal is to find an appropriate, industrial approach for integrating machine learning into production processes. Previously… --- ## [Failure to send binary data greather than 64KB using Requests](https://forum.inductiveautomation.com/t/failure-to-send-binary-data-greather-than-64kb-using-requests/31647)
**Author:** [@jpoitras](https://forum.inductiveautomation.com/u/jpoitras)\ **Replies:** 6\ **Last updated:** [April 12, 2022, 8:05pm UTC](https://forum.inductiveautomation.com/t/failure-to-send-binary-data-greather-than-64kb-using-requests/31647 "2022-04-12T20:05:35Z")
I'm trying to send an image to an Azure vision endpoint. The data stored in the DB looks something like this. DB Value: array('b', \[-119, 80, 78, 71, 13, 10, 26, 10, 0, 0, 0, 13, 73 .. etc Its converted to a byteArray… --- ## [\[BUG\] Template Path Binding on Popup View](https://forum.inductiveautomation.com/t/bug-template-path-binding-on-popup-view/58376)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 1\ **Last updated:** [April 12, 2022, 7:36pm UTC](https://forum.inductiveautomation.com/t/bug-template-path-binding-on-popup-view/58376 "2022-04-12T19:36:46Z")
I have two templates that are identical sizes with different content inside. I swap the template path based on the type of component. (between the paths “Pumps/Status/XF” and “Pumps/Status/XF\_Blower”). The path bindings… --- ## [SEPASOFT, updateDependencies function Not Working](https://forum.inductiveautomation.com/t/sepasoft-updatedependencies-function-not-working/58368)
**Author:** [@prashant.pednekar](https://forum.inductiveautomation.com/u/prashant.pednekar)\ **Replies:** 0\ **Last updated:** [April 12, 2022, 5:56pm UTC](https://forum.inductiveautomation.com/t/sepasoft-updatedependencies-function-not-working/58368 "2022-04-12T17:56:08Z")
Hello, I am running Ignition 8.1.13 with Track and Trace , Production version 3.81.2 from SEPASOFT. I have added new Materials in my Process Segment and trying to update the dependent Operation Segment using the ‘system… --- ## [Modbus address Scanner](https://forum.inductiveautomation.com/t/modbus-address-scanner/58132)
**Author:** [@OscarJ](https://forum.inductiveautomation.com/u/OscarJ)\ **Replies:** 10\ **Last updated:** [April 12, 2022, 5:15pm UTC](https://forum.inductiveautomation.com/t/modbus-address-scanner/58132 "2022-04-12T17:15:16Z")
I am having problems reading the data that my scanner takes, it is connected via MODBUS and in Ignition it tells me that it is connected but when trying to read it through a tag it is difficult for me to write its addres… --- ## [Importing excel or csv data to dataset tag practically](https://forum.inductiveautomation.com/t/importing-excel-or-csv-data-to-dataset-tag-practically/58279)
**Author:** [@berkay.cinar](https://forum.inductiveautomation.com/u/berkay.cinar)\ **Replies:** 4\ **Last updated:** [April 12, 2022, 3:15pm UTC](https://forum.inductiveautomation.com/t/importing-excel-or-csv-data-to-dataset-tag-practically/58279 "2022-04-12T15:15:48Z")
Hello, I know this subject has been discussed before but I could not see a practical solution in those. I need to import 2 columns of data to a dataset tag. Since I am talking about plus 500 rows I am looking for easier… --- ## [Alarm Status Table: Filter Alarm Function](https://forum.inductiveautomation.com/t/alarm-status-table-filter-alarm-function/58272)
**Author:** [@josh3](https://forum.inductiveautomation.com/u/josh3)\ **Replies:** 1\ **Last updated:** [April 12, 2022, 3:29pm UTC](https://forum.inductiveautomation.com/t/alarm-status-table-filter-alarm-function/58272 "2022-04-12T15:29:29Z")
Hi, Is it possible to have the Status Alarm Table only display alarms based on user logins and therefore filters to certain areas of the plant? Our tag structures are broken up into certain areas of the plant and each … --- ## [\[IGN-2083\]Webdev file resource security](https://forum.inductiveautomation.com/t/ign-2083-webdev-file-resource-security/58302)
**Author:** [@flavien](https://forum.inductiveautomation.com/u/flavien)\ **Replies:** 4\ **Last updated:** [April 12, 2022, 3:17pm UTC](https://forum.inductiveautomation.com/t/ign-2083-webdev-file-resource-security/58302 "2022-04-12T15:17:26Z")
Hi, Anyone with the access URL can read the file in a web browser. Is there any method to secure access ? With basic auth for example. Thanks --- ## [Showing Table is slow even though query is fast?](https://forum.inductiveautomation.com/t/showing-table-is-slow-even-though-query-is-fast/58020)
**Author:** [@stefan.marcin74](https://forum.inductiveautomation.com/u/stefan.marcin74)\ **Replies:** 13\ **Last updated:** [April 12, 2022, 2:21pm UTC](https://forum.inductiveautomation.com/t/showing-table-is-slow-even-though-query-is-fast/58020 "2022-04-12T14:21:30Z")
Hi, we have seen this issue since we started using ignition. Why Table component is so slow to display ? We use data binding where sql script runs and fills the table. The table is hidden and only if it gets data then it… --- ## [Project library in perspective](https://forum.inductiveautomation.com/t/project-library-in-perspective/58348)
**Author:** [@vani161998](https://forum.inductiveautomation.com/u/vani161998)\ **Replies:** 7\ **Last updated:** [April 12, 2022, 2:21pm UTC](https://forum.inductiveautomation.com/t/project-library-in-perspective/58348 "2022-04-12T14:21:20Z")
Can we call project library script behind any components in perspective? I tried in button it is not working. [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=857) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=859)