# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=908 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 909 --- ## [Delete records older than (Transaction Groups) - How does this work?](https://forum.inductiveautomation.com/t/delete-records-older-than-transaction-groups-how-does-this-work/36532)
**Author:** [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\ **Replies:** 5\ **Last updated:** [January 7, 2022, 11:00pm UTC](https://forum.inductiveautomation.com/t/delete-records-older-than-transaction-groups-how-does-this-work/36532 "2022-01-07T23:00:27Z")
Question, when this setting is turned on, does this do a delete row as part of the same query call to SQL? or does it issue a second query immediately before or after the insert query? Just curious. --- ## [Ignition 8.1.10 Vision HMI Performance/PLC Overloading](https://forum.inductiveautomation.com/t/ignition-8-1-10-vision-hmi-performance-plc-overloading/54785)
**Author:** [@james4](https://forum.inductiveautomation.com/u/james4)\ **Replies:** 1\ **Last updated:** [January 7, 2022, 9:47pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-10-vision-hmi-performance-plc-overloading/54785 "2022-01-07T21:47:43Z")
Good Day, I have read a few posts now regarding an issue we seem to be having with our Ignition Vision set-up. Essentially, I believe the issue is we are overloading our PLC and we are not getting the response times we… --- ## [WebDev Self Signed Cert on Localhost](https://forum.inductiveautomation.com/t/webdev-self-signed-cert-on-localhost/54708)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 3\ **Last updated:** [January 7, 2022, 9:38pm UTC](https://forum.inductiveautomation.com/t/webdev-self-signed-cert-on-localhost/54708 "2022-01-07T21:38:39Z")
I am trying to setup my local dev environment so I can test out some WebDev calls that are setup to require HTTPS. Everytime I try making a post call to the WebDev resource I receive the message “unable to find valid cer… --- ## [Azure Dev Ops Notifications to Ignition](https://forum.inductiveautomation.com/t/azure-dev-ops-notifications-to-ignition/54784)
**Author:** [@tyler.robertson](https://forum.inductiveautomation.com/u/tyler.robertson)\ **Replies:** 2\ **Last updated:** [January 7, 2022, 8:35pm UTC](https://forum.inductiveautomation.com/t/azure-dev-ops-notifications-to-ignition/54784 "2022-01-07T20:35:59Z")
HI there, I’ll preface this with I’m a mediocre web developer so I may be missing something fundamental. I’m looking to take notifications on Push / Build for Git repos hosted internally in Azure Dev Ops and get those i… --- ## [Gateway spontaneous restart](https://forum.inductiveautomation.com/t/gateway-spontaneous-restart/54779)
**Author:** [@ken.maze](https://forum.inductiveautomation.com/u/ken.maze)\ **Replies:** 3\ **Last updated:** [January 7, 2022, 7:37pm UTC](https://forum.inductiveautomation.com/t/gateway-spontaneous-restart/54779 "2022-01-07T19:37:32Z")
HI, My gateway spontaneously restarts a few times a day. The log just says Restarting gateway scripts... Is there any way I can find out more information, like why or what restarted it? Thanks --- ## [Index of Max value](https://forum.inductiveautomation.com/t/index-of-max-value/54777)
**Author:** [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\ **Replies:** 12\ **Last updated:** [January 7, 2022, 7:09pm UTC](https://forum.inductiveautomation.com/t/index-of-max-value/54777 "2022-01-07T19:09:31Z")
Hello all, I would like to extract the timestamp value of each folder’s name shown below and then identify the folder with the most recent timestamp. In the example below I would like to be able to select the path of th… --- ## [Perspective session Count](https://forum.inductiveautomation.com/t/perspective-session-count/54781)
**Author:** [@splata](https://forum.inductiveautomation.com/u/splata)\ **Replies:** 1\ **Last updated:** [January 7, 2022, 7:06pm UTC](https://forum.inductiveautomation.com/t/perspective-session-count/54781 "2022-01-07T19:06:48Z")
Hello,how can i have access to view how many active session in a specific project like in the status gateway --- ## [Tag Historian query as child query data source use in Timeseries chart gives date range from 1970-29-01](https://forum.inductiveautomation.com/t/tag-historian-query-as-child-query-data-source-use-in-timeseries-chart-gives-date-range-from-1970-29-01/35386)
**Author:** [@ssatonkar](https://forum.inductiveautomation.com/u/ssatonkar)\ **Replies:** 6\ **Last updated:** [January 7, 2022, 5:52pm UTC](https://forum.inductiveautomation.com/t/tag-historian-query-as-child-query-data-source-use-in-timeseries-chart-gives-date-range-from-1970-29-01/35386 "2022-01-07T17:52:51Z")
I am using a basic SQL query as arent and tag Historical query as a child. When I apply the data source obtained from Tag Historical query to Time Series chart I get chart date range from 1970-29-01. It is not taking dat… --- ## [Perspective Icon/Image Browsing - New Component](https://forum.inductiveautomation.com/t/perspective-icon-image-browsing-new-component/54773)
**Author:** [@rod.rebman](https://forum.inductiveautomation.com/u/rod.rebman)\ **Replies:** 1\ **Last updated:** [January 7, 2022, 5:05pm UTC](https://forum.inductiveautomation.com/t/perspective-icon-image-browsing-new-component/54773 "2022-01-07T17:05:42Z")
Moving into Perspective for the first time - has there been a change in the icon path properties, I do not see any utility to browse to the SVG directory or image manager per the tutorials or manual - V8.1.5: --- ## [Cirrus MQTT Distributor ACLs Format](https://forum.inductiveautomation.com/t/cirrus-mqtt-distributor-acls-format/54442)
**Author:** [@John\_Lamport](https://forum.inductiveautomation.com/u/John_Lamport)\ **Replies:** 4\ **Last updated:** [January 7, 2022, 3:13pm UTC](https://forum.inductiveautomation.com/t/cirrus-mqtt-distributor-acls-format/54442 "2022-01-07T15:13:07Z")
I have a Allen Bradley to MQTT gateway by RTA model # 460ETCQT. I have configured it to read 2 PLC tags and mapped them to 2 topics. I am now trying to configure the MQTT Distributer by Cirrus to read those tags. I have … --- ## [Perspective Dashboard Component](https://forum.inductiveautomation.com/t/perspective-dashboard-component/54760)
**Author:** [@kyle.bennett](https://forum.inductiveautomation.com/u/kyle.bennett)\ **Replies:** 0\ **Last updated:** [January 7, 2022, 2:33pm UTC](https://forum.inductiveautomation.com/t/perspective-dashboard-component/54760 "2022-01-07T14:33:57Z")
I’m still tinkering with the dashboard component. I would like to be able to prevent the user from doing the following two things, but I don’t see a way around it. Any ideas? Closing a widget using the ‘X’ that shows… --- ## [Issues querying audit log](https://forum.inductiveautomation.com/t/issues-querying-audit-log/54734)
**Author:** [@rcarrilhof](https://forum.inductiveautomation.com/u/rcarrilhof)\ **Replies:** 7\ **Last updated:** [January 6, 2022, 10:35pm UTC](https://forum.inductiveautomation.com/t/issues-querying-audit-log/54734 "2022-01-06T22:35:42Z")
Hi. The solution is partially working for me, the basic goes quite well. SELECT \* FROM audit\_events - is returning the expected result, but when I try to do any filter, E.g. SELECT \* FROM audit\_events WHERE ACTOR = … --- ## [Make columns in tables word wrap and adjust column height](https://forum.inductiveautomation.com/t/make-columns-in-tables-word-wrap-and-adjust-column-height/4134)
**Author:** [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\ **Replies:** 7\ **Last updated:** [January 6, 2022, 9:05pm UTC](https://forum.inductiveautomation.com/t/make-columns-in-tables-word-wrap-and-adjust-column-height/4134 "2022-01-06T21:05:17Z")
It would be cool if you could select columns that can word wrap in a table so the whole thing could be readable and it would automatically adjust the height of that row. Much like the comments panel does now. Here's my… --- ## [Perspective Dashboard Displacement](https://forum.inductiveautomation.com/t/perspective-dashboard-displacement/54333)
**Author:** [@kyle.bennett](https://forum.inductiveautomation.com/u/kyle.bennett)\ **Replies:** 4\ **Last updated:** [January 6, 2022, 8:41pm UTC](https://forum.inductiveautomation.com/t/perspective-dashboard-displacement/54333 "2022-01-06T20:41:12Z")
Can we control the direction of displaced widgets on the ‘Dashboard Component’? I’d like to have a column for each production line, then each widget will display a specific order to be ran. I’d like the user to be able… --- ## [Micro 820 to Ignition - What am I doing wrong?](https://forum.inductiveautomation.com/t/micro-820-to-ignition-what-am-i-doing-wrong/54746)
**Author:** [@jparsons](https://forum.inductiveautomation.com/u/jparsons)\ **Replies:** 3\ **Last updated:** [January 6, 2022, 8:31pm UTC](https://forum.inductiveautomation.com/t/micro-820-to-ignition-what-am-i-doing-wrong/54746 "2022-01-06T20:31:49Z")
I am communicating from a micro 820 to ignition edge through modbus tcp. My coil is working but my holding register values are not connecting. I dont know what I am doing wrong. Does anyone see anything wrong with these … --- ## [Bypass ReportViewer](https://forum.inductiveautomation.com/t/bypass-reportviewer/54743)
**Author:** [@cpanici](https://forum.inductiveautomation.com/u/cpanici)\ **Replies:** 2\ **Last updated:** [January 6, 2022, 7:10pm UTC](https://forum.inductiveautomation.com/t/bypass-reportviewer/54743 "2022-01-06T19:10:01Z")
Hello, I am trying to eliminate the need for a view in perspective. How it works now: Basically, I have a table on a main view. When a user selects a record and hits the view report button, it takes the user to another… --- ## [Backup tag provider](https://forum.inductiveautomation.com/t/backup-tag-provider/54354)
**Author:** [@berni](https://forum.inductiveautomation.com/u/berni)\ **Replies:** 3\ **Last updated:** [January 6, 2022, 6:19pm UTC](https://forum.inductiveautomation.com/t/backup-tag-provider/54354 "2022-01-06T18:19:36Z")
Hello everyone, I have an Ignition architecture with 2 redundant servers (a master node and a backup node) and more than 10 Edge panels, each panel being connected to a PLC. Every gateway is set with Ignition 8.1.5. To… --- ## [Deploying with Docker](https://forum.inductiveautomation.com/t/deploying-with-docker/54724)
**Author:** [@Vinay\_N](https://forum.inductiveautomation.com/u/Vinay_N)\ **Replies:** 2\ **Last updated:** [January 6, 2022, 5:20pm UTC](https://forum.inductiveautomation.com/t/deploying-with-docker/54724 "2022-01-06T17:20:58Z")
We have a product built on Ignition and I am researching deploying Ignition and the various artifacts using containers. The plan is to use it for development purposes first. I have a Docker image successfully built with… --- ## [TagPath Editing and Historian Data Retention Issue](https://forum.inductiveautomation.com/t/tagpath-editing-and-historian-data-retention-issue/54727)
**Author:** [@Des\_Schwindt](https://forum.inductiveautomation.com/u/Des_Schwindt)\ **Replies:** 2\ **Last updated:** [January 6, 2022, 4:47pm UTC](https://forum.inductiveautomation.com/t/tagpath-editing-and-historian-data-retention-issue/54727 "2022-01-06T16:47:38Z")
Hello Searched through the forum but no luck so far. Issue is a tagpath required an update by adding a folder and moving some tags under that folder which is no issue. The problem stands where the group of tags are now … --- ## [Table subview expension](https://forum.inductiveautomation.com/t/table-subview-expension/54733)
**Author:** [@Arnaud\_Declerck](https://forum.inductiveautomation.com/u/Arnaud_Declerck)\ **Replies:** 0\ **Last updated:** [January 6, 2022, 4:44pm UTC](https://forum.inductiveautomation.com/t/table-subview-expension/54733 "2022-01-06T16:44:42Z")
Hi, i'm currently using a subview into a table in perspective. is it possible that the subview use the full free space bellow when no row in table. the subview is a flex in column mode. regards --- ## [Gateway network queues (lots of them)](https://forum.inductiveautomation.com/t/gateway-network-queues-lots-of-them/54673)
**Author:** [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Replies:** 12\ **Last updated:** [January 6, 2022, 4:10pm UTC](https://forum.inductiveautomation.com/t/gateway-network-queues-lots-of-them/54673 "2022-01-06T16:10:31Z")
Hello folks, I just opened the ‘Queue Management’ tab on the ‘Gateway Network’ page, and immediately started scratching my head. Here’s why: 1938 queues ! And they’re all there, it’s not just a name ! I checked 4 p… --- ## [Best practice for tag calculating derivative (difference between values at 2 timestamps)](https://forum.inductiveautomation.com/t/best-practice-for-tag-calculating-derivative-difference-between-values-at-2-timestamps/54728)
**Author:** [@djs](https://forum.inductiveautomation.com/u/djs)\ **Replies:** 1\ **Last updated:** [January 6, 2022, 4:03pm UTC](https://forum.inductiveautomation.com/t/best-practice-for-tag-calculating-derivative-difference-between-values-at-2-timestamps/54728 "2022-01-06T16:03:21Z")
I have tags that are calculating throughput from individual ports on network switches (through Kymera SNMP Driver). The way to calculate throughput is to take the difference of ifInOctets over a period of time and the di… --- ## [Dropdown List Manual Selection in Addition to Scroll!](https://forum.inductiveautomation.com/t/dropdown-list-manual-selection-in-addition-to-scroll/54700)
**Author:** [@Sam.Naji](https://forum.inductiveautomation.com/u/Sam.Naji)\ **Replies:** 5\ **Last updated:** [January 6, 2022, 3:24pm UTC](https://forum.inductiveautomation.com/t/dropdown-list-manual-selection-in-addition-to-scroll/54700 "2022-01-06T15:24:05Z")
I have a droplist list whose data source is an SQL table (1 column.) My question is how to give the user the option to start typing in the dropdown list to select the item directly and still have the ability to scroll th… --- ## [MSSQL DB connection on Ignition 8.1](https://forum.inductiveautomation.com/t/mssql-db-connection-on-ignition-8-1/48572)
**Author:** [@sathianandan.dharmas](https://forum.inductiveautomation.com/u/sathianandan.dharmas)\ **Replies:** 12\ **Last updated:** [January 6, 2022, 3:07pm UTC](https://forum.inductiveautomation.com/t/mssql-db-connection-on-ignition-8-1/48572 "2022-01-06T15:07:17Z")
Hi All I’ve been trying to set up a database connection for MSSQL database which is running on an MSSQL 2019 server and end up having faulted connection. I checked the URL, db name, and the user credentials it looks rig… --- ## [Audit log options](https://forum.inductiveautomation.com/t/audit-log-options/14411)
**Author:** [@tom.wouters](https://forum.inductiveautomation.com/u/tom.wouters)\ **Replies:** 5\ **Last updated:** [May 31, 2017, 12:07pm UTC](https://forum.inductiveautomation.com/t/audit-log-options/14411 "2017-05-31T12:07:49Z")
Hello, I have configured my audit profile and everything works. Now I want to add two things to my audit log; I want te computer name added to the table. In the configuration settings at the advanced settings the… --- ## [Convert a string value tag into dateTime](https://forum.inductiveautomation.com/t/convert-a-string-value-tag-into-datetime/54713)
**Author:** [@vani161998](https://forum.inductiveautomation.com/u/vani161998)\ **Replies:** 4\ **Last updated:** [January 6, 2022, 1:01pm UTC](https://forum.inductiveautomation.com/t/convert-a-string-value-tag-into-datetime/54713 "2022-01-06T13:01:30Z")
I have a string value ‘20211228064508000’ in a tag . i want to convert into current date format. I tried to change the data type of tag to Datetime but it didn’t work. Anybody have any solution? --- ## [Error in Log Activity. Logger: ReadArrayTagsRequest](https://forum.inductiveautomation.com/t/error-in-log-activity-logger-readarraytagsrequest/12328)
**Author:** [@casey.myers](https://forum.inductiveautomation.com/u/casey.myers)\ **Replies:** 3\ **Last updated:** [January 6, 2022, 12:57pm UTC](https://forum.inductiveautomation.com/t/error-in-log-activity-logger-readarraytagsrequest/12328 "2022-01-06T12:57:42Z")
Our Ignition Gateway Log Activity, for an Allen-Bradley 1756-L71, is throwing the following error ever second. Nonstop. Does anyone have any ideas as to why it is being thrown? I have tried researching the error, etc.,… --- ## [Manage Perspective app with keyboard only (no touch)](https://forum.inductiveautomation.com/t/manage-perspective-app-with-keyboard-only-no-touch/54717)
**Author:** [@chi](https://forum.inductiveautomation.com/u/chi)\ **Replies:** 0\ **Last updated:** [January 6, 2022, 11:15am UTC](https://forum.inductiveautomation.com/t/manage-perspective-app-with-keyboard-only-no-touch/54717 "2022-01-06T11:15:27Z")
Hello, i am trying to use the Perspective Android app on a smart signage display. That display has no touch or mouse, so i have to manage the app settings with keyboard only. Is this even possible? I have not found a w… --- ## [Designer error - Cannot create PyString with non-byte value](https://forum.inductiveautomation.com/t/designer-error-cannot-create-pystring-with-non-byte-value/50795)
**Author:** [@michal.ruda](https://forum.inductiveautomation.com/u/michal.ruda)\ **Replies:** 5\ **Last updated:** [November 19, 2021, 3:32pm UTC](https://forum.inductiveautomation.com/t/designer-error-cannot-create-pystring-with-non-byte-value/50795 "2021-11-19T15:32:08Z")
Hi. Can anybody help me with this? I am unable to open any project in the Designer. Thanks. Michal --- ## [How to: Committing project to Git with author and timestamps](https://forum.inductiveautomation.com/t/how-to-committing-project-to-git-with-author-and-timestamps/48662)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 9\ **Last updated:** [January 6, 2022, 11:04am UTC](https://forum.inductiveautomation.com/t/how-to-committing-project-to-git-with-author-and-timestamps/48662 "2022-01-06T11:04:49Z")
I modified the bash script from the best practices guide which has a guide to configuring automatic Git commits on Designer save. I made it so that it adds the author of the change and the timestamp of the change to the … [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=907) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=909)