# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=490 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 491 --- ## [Audit profile retention time and pruning](https://forum.inductiveautomation.com/t/audit-profile-retention-time-and-pruning/85153)
**Author:** [@boandersen](https://forum.inductiveautomation.com/u/boandersen)\ **Replies:** 1\ **Last updated:** [February 2, 2024, 4:30pm UTC](https://forum.inductiveautomation.com/t/audit-profile-retention-time-and-pruning/85153 "2024-02-02T16:30:54Z")
I am seeking information on the pruning of the audit log and how it works. I want to remove some entries from the log, and am considering if it is safest to let ignition gateway do the work by temporarily setting the pr… --- ## [\[IGN-9174\] New Tag Diagnostic window missing "Refresh" button](https://forum.inductiveautomation.com/t/ign-9174-new-tag-diagnostic-window-missing-refresh-button/85136)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 0\ **Last updated:** [February 2, 2024, 4:45am UTC](https://forum.inductiveautomation.com/t/ign-9174-new-tag-diagnostic-window-missing-refresh-button/85136 "2024-02-02T04:45:01Z")
v8.1.36 To see updates to tag values/errors, you have to close and reopen the diag window :confused: --- ## [Scheduled Gateway Event Script writing to shared drive succeeds but doesnt actually write anything](https://forum.inductiveautomation.com/t/scheduled-gateway-event-script-writing-to-shared-drive-succeeds-but-doesnt-actually-write-anything/85161)
**Author:** [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Replies:** 5\ **Last updated:** [February 2, 2024, 4:02pm UTC](https://forum.inductiveautomation.com/t/scheduled-gateway-event-script-writing-to-shared-drive-succeeds-but-doesnt-actually-write-anything/85161 "2024-02-02T16:02:46Z")
I have a gateway scheduled script with the following script: def onScheduledEvent(): tbl = system.db.runNamedQuery('Project\_Name', 'select\_LastWeek\_Data') csv = system.dataset.toCSV(tbl) startDater = syste… --- ## [OPC tag script using UDT parameters](https://forum.inductiveautomation.com/t/opc-tag-script-using-udt-parameters/84195)
**Author:** [@Brendan\_Munroe](https://forum.inductiveautomation.com/u/Brendan_Munroe)\ **Replies:** 9\ **Last updated:** [February 2, 2024, 3:33pm UTC](https://forum.inductiveautomation.com/t/opc-tag-script-using-udt-parameters/84195 "2024-02-02T15:33:10Z")
I'm trying to create a UDT for an OPC tag that uses a script. I've found some documentation and topics similar, but I'm struggling to have the script update the desired tags using the parameters from the UDT definition. … --- ## [Image from local machine in Image component](https://forum.inductiveautomation.com/t/image-from-local-machine-in-image-component/85138)
**Author:** [@Adarsh\_K](https://forum.inductiveautomation.com/u/Adarsh_K)\ **Replies:** 3\ **Last updated:** [February 2, 2024, 3:28pm UTC](https://forum.inductiveautomation.com/t/image-from-local-machine-in-image-component/85138 "2024-02-02T15:28:32Z")
Hi , My Project is to upload and save the user image byte in DB and show it in perspective image component . While i am printing or writing it to tag the bytes i am fetching , Base64 byte but when i am writing it to a… --- ## [Architecture for Distributed Control Center](https://forum.inductiveautomation.com/t/architecture-for-distributed-control-center/85104)
**Author:** [@akp](https://forum.inductiveautomation.com/u/akp)\ **Replies:** 12\ **Last updated:** [February 2, 2024, 3:11pm UTC](https://forum.inductiveautomation.com/t/architecture-for-distributed-control-center/85104 "2024-02-02T15:11:49Z")
Hello All, What would be the best architecture to follow for a central control center with 6 regional control centers? All of these control centers need to have a backup control center. The complete system has 14 contro… --- ## [Perspective Workstation Redundancy Without Repeated Login](https://forum.inductiveautomation.com/t/perspective-workstation-redundancy-without-repeated-login/85121)
**Author:** [@Sara\_Kalaf](https://forum.inductiveautomation.com/u/Sara_Kalaf)\ **Replies:** 4\ **Last updated:** [February 2, 2024, 3:03pm UTC](https://forum.inductiveautomation.com/t/perspective-workstation-redundancy-without-repeated-login/85121 "2024-02-02T15:03:20Z")
Hey everybody, I've got a question for those of you with more experience with Perspective Workstation. So normally when failover to a redundant server occurs when using Ignition Perspective in a browser, the user is pr… --- ## [Perspective Dropdown component - not accessing last item on list](https://forum.inductiveautomation.com/t/perspective-dropdown-component-not-accessing-last-item-on-list/85117)
**Author:** [@ltoscano](https://forum.inductiveautomation.com/u/ltoscano)\ **Replies:** 8\ **Last updated:** [February 2, 2024, 2:55pm UTC](https://forum.inductiveautomation.com/t/perspective-dropdown-component-not-accessing-last-item-on-list/85117 "2024-02-02T14:55:15Z")
Good Day All, I'm seeing a weird behavior using the dropdown component in Perspective which is probably entirely my fault but I don't know why. I have a table component, with one of the columns is a product code. If I … --- ## [Power Chart - Rename axes name by selecting the row in Pen Tabel?](https://forum.inductiveautomation.com/t/power-chart-rename-axes-name-by-selecting-the-row-in-pen-tabel/85154)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 0\ **Last updated:** [February 2, 2024, 1:24pm UTC](https://forum.inductiveautomation.com/t/power-chart-rename-axes-name-by-selecting-the-row-in-pen-tabel/85154 "2024-02-02T13:24:20Z")
Hi , Is there way to rename the axis name by clicking the row in pen tabel --- ## [Vision Client launcher don't show the project](https://forum.inductiveautomation.com/t/vision-client-launcher-dont-show-the-project/85142)
**Author:** [@Molnar\_Bence](https://forum.inductiveautomation.com/u/Molnar_Bence)\ **Replies:** 2\ **Last updated:** [February 2, 2024, 1:13pm UTC](https://forum.inductiveautomation.com/t/vision-client-launcher-dont-show-the-project/85142 "2024-02-02T13:13:57Z")
I made one project for just test, but I don't see that in the Vision Client, but I don't no why. Do you have any idea what is the problem? Here is the picture about this problem( the hide from launcher isn't active): … --- ## [\[FEATURE\] perspective map component - marker clustering feature](https://forum.inductiveautomation.com/t/feature-perspective-map-component-marker-clustering-feature/51336)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 10\ **Last updated:** [February 2, 2024, 1:04pm UTC](https://forum.inductiveautomation.com/t/feature-perspective-map-component-marker-clustering-feature/51336 "2024-02-02T13:04:21Z")
Hi @jball, For maps with lots of markers, it will be usefull to have a markers clustering feature ! You can vote: --- ## [Power Table Column Total Displayed In A Numerical Label](https://forum.inductiveautomation.com/t/power-table-column-total-displayed-in-a-numerical-label/85148)
**Author:** [@Ben\_Givens](https://forum.inductiveautomation.com/u/Ben_Givens)\ **Replies:** 2\ **Last updated:** [February 2, 2024, 12:44pm UTC](https://forum.inductiveautomation.com/t/power-table-column-total-displayed-in-a-numerical-label/85148 "2024-02-02T12:44:41Z")
Hi All I want to display the total of a power table column in a numerical label. The data is stored using the internal historian. --- ## [How to get the View Canvas selected instance index number](https://forum.inductiveautomation.com/t/how-to-get-the-view-canvas-selected-instance-index-number/85011)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 5\ **Last updated:** [February 2, 2024, 12:40pm UTC](https://forum.inductiveautomation.com/t/how-to-get-the-view-canvas-selected-instance-index-number/85011 "2024-02-02T12:40:45Z")
Hi, I have 4 Instance of chart in View Canvas But i open a popup in 2nd chart of instance. I want to get the View Canvas number dynamically and pass it to the popup suppose if i delete the 2nd chart i want to know w… --- ## [XLReporter Connection to Ignition OPC-UA Server](https://forum.inductiveautomation.com/t/xlreporter-connection-to-ignition-opc-ua-server/34538)
**Author:** [@bmusson](https://forum.inductiveautomation.com/u/bmusson)\ **Replies:** 16\ **Last updated:** [February 2, 2024, 12:15pm UTC](https://forum.inductiveautomation.com/t/xlreporter-connection-to-ignition-opc-ua-server/34538 "2024-02-02T12:15:26Z")
We’re migrating an XLReporter project from an RSLinx connector to an Ignition OPC-UA Server and having some issues getting things talking. XLReporter is installed on the same OS as the Gateway (Ignition 8). In XLReporte… --- ## [Report with Scripted Nested Data](https://forum.inductiveautomation.com/t/report-with-scripted-nested-data/11801)
**Author:** [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Replies:** 26\ **Last updated:** [February 2, 2024, 11:41am UTC](https://forum.inductiveautomation.com/t/report-with-scripted-nested-data/11801 "2024-02-02T11:41:02Z")
The report datasource scripting examples explain how to access the nested data in another key for use constructing a custom dataset. What I don't see is how to construct nested data that would be suitable for use with a… --- ## [Issue with Database Query](https://forum.inductiveautomation.com/t/issue-with-database-query/85088)
**Author:** [@PRASHANTH\_KAKKIRALA](https://forum.inductiveautomation.com/u/PRASHANTH_KAKKIRALA)\ **Replies:** 3\ **Last updated:** [February 2, 2024, 8:58am UTC](https://forum.inductiveautomation.com/t/issue-with-database-query/85088 "2024-02-02T08:58:36Z")
I'm facing an issue while using a query with PostgreSQL. Named Query: SELECT "A".\*,"B"."B\_data1", "B"."B\_data2" FROM "A" join "B" ON ("A"."id" = "B"."A\_id") WHERE "A"."E" ='P\_Test' LIMIT 1 Error : When I remove the… --- ## [Apex chart show the wrong datetime](https://forum.inductiveautomation.com/t/apex-chart-show-the-wrong-datetime/82330)
**Author:** [@Edvard\_Wilhelms](https://forum.inductiveautomation.com/u/Edvard_Wilhelms)\ **Replies:** 7\ **Last updated:** [February 2, 2024, 8:33am UTC](https://forum.inductiveautomation.com/t/apex-chart-show-the-wrong-datetime/82330 "2024-02-02T08:33:43Z")
Hi, I've downloaded the ApexChart modules from kyvis-labs. It looks great! But for some reason it modifies my timestamp 2 hours wrong. The dataset is correct and it interprets the data with an exact 2 hours lag. I have … --- ## [Need download option in Ignition Perspective](https://forum.inductiveautomation.com/t/need-download-option-in-ignition-perspective/78387)
**Author:** [@Ruchika](https://forum.inductiveautomation.com/u/Ruchika)\ **Replies:** 6\ **Last updated:** [February 2, 2024, 5:33am UTC](https://forum.inductiveautomation.com/t/need-download-option-in-ignition-perspective/78387 "2024-02-02T05:33:39Z")
I have uploaded my folder of image files into ignition using web dev module. And now I want a option in my view to download a particular image. I added download icon and trying to use onClick- system.perspective.download… --- ## [Perspective Send Message to all other opened clients](https://forum.inductiveautomation.com/t/perspective-send-message-to-all-other-opened-clients/85084)
**Author:** [@ToMakPo](https://forum.inductiveautomation.com/u/ToMakPo)\ **Replies:** 10\ **Last updated:** [February 2, 2024, 3:04am UTC](https://forum.inductiveautomation.com/t/perspective-send-message-to-all-other-opened-clients/85084 "2024-02-02T03:04:41Z")
I am trying to push a message to all other opened clients when a button is pushed. I have a script on my button: projectName = system.util.getProjectName() system.util.sendMessage( project = projectName, messageHand… --- ## [Bulk Editing OPC Tag Properties](https://forum.inductiveautomation.com/t/bulk-editing-opc-tag-properties/85127)
**Author:** [@Kriselle\_Tanhueco](https://forum.inductiveautomation.com/u/Kriselle_Tanhueco)\ **Replies:** 2\ **Last updated:** [February 2, 2024, 12:42am UTC](https://forum.inductiveautomation.com/t/bulk-editing-opc-tag-properties/85127 "2024-02-02T00:42:32Z")
Hi, I have a set of historian-enabled tags whose properties I want to be able to edit at will. More specifically, I want tags to be able to have their historian deadbands and sample times edited. Is there a way to accom… --- ## [Ignition 7.9 system.net.httpPost needs API Key, gives 401 error code. Works on Postman just fine](https://forum.inductiveautomation.com/t/ignition-7-9-system-net-httppost-needs-api-key-gives-401-error-code-works-on-postman-just-fine/84870)
**Author:** [@Dan\_Hobba](https://forum.inductiveautomation.com/u/Dan_Hobba)\ **Replies:** 7\ **Last updated:** [February 1, 2024, 9:43pm UTC](https://forum.inductiveautomation.com/t/ignition-7-9-system-net-httppost-needs-api-key-gives-401-error-code-works-on-postman-just-fine/84870 "2024-02-01T21:43:39Z")
Hello! I am in a little bit of a pickle here. The Pickle: system.net.httpPost does not work, however the same header (just a single API token) sent to the same URL on PostMan works just fine. Here is the image of the … --- ## [Perspective Views cutoff/resizing when toggling between views in Designer](https://forum.inductiveautomation.com/t/perspective-views-cutoff-resizing-when-toggling-between-views-in-designer/61390)
**Author:** [@dsui](https://forum.inductiveautomation.com/u/dsui)\ **Replies:** 7\ **Last updated:** [February 1, 2024, 9:11pm UTC](https://forum.inductiveautomation.com/t/perspective-views-cutoff-resizing-when-toggling-between-views-in-designer/61390 "2024-02-01T21:11:03Z")
I am currently developing with the Perspective module in Ignition 8.1.18. One item I noticed in the Designer is that a view will sometimes be cut off to a 600x400 window. This usually occurs when toggling between differe… --- ## [An easier way to extract role as an uncluttered string](https://forum.inductiveautomation.com/t/an-easier-way-to-extract-role-as-an-uncluttered-string/85120)
**Author:** [@ian.sebryk](https://forum.inductiveautomation.com/u/ian.sebryk)\ **Replies:** 5\ **Last updated:** [February 1, 2024, 9:10pm UTC](https://forum.inductiveautomation.com/t/an-easier-way-to-extract-role-as-an-uncluttered-string/85120 "2024-02-01T21:10:57Z")
i just want a bloody string. userRoles = \[\] for role in self.session.props.auth.user.roles: userRoles.append(str(role)) message = str(value) + ' -\> ' + str(userRoles) return message #\<-- yields: Ian -\> \['Read/Write',… --- ## [How to JOIN two tables on serperate databases?](https://forum.inductiveautomation.com/t/how-to-join-two-tables-on-serperate-databases/85115)
**Author:** [@NP209](https://forum.inductiveautomation.com/u/NP209)\ **Replies:** 3\ **Last updated:** [February 1, 2024, 8:07pm UTC](https://forum.inductiveautomation.com/t/how-to-join-two-tables-on-serperate-databases/85115 "2024-02-01T20:07:02Z")
I need help with an SQL Query between two tables in separate databases. I want to return all rows from PacakageRecord table on our Bizerba database where both the ArticleNumber from our PackageRecord matches the ItemNum… --- ## [Device Overload](https://forum.inductiveautomation.com/t/device-overload/85055)
**Author:** [@Pat\_Cunningham](https://forum.inductiveautomation.com/u/Pat_Cunningham)\ **Replies:** 10\ **Last updated:** [February 1, 2024, 6:09pm UTC](https://forum.inductiveautomation.com/t/device-overload/85055 "2024-02-01T18:09:26Z")
I am trying to manage my device overload. I am currently at 45% and I have two questions. I tried putting all of my tags in a leased group and setting the rate to 60000. I do not have a session open but I am still a… --- ## [Perspective - table header checkbox](https://forum.inductiveautomation.com/t/perspective-table-header-checkbox/85114)
**Author:** [@davee\_s](https://forum.inductiveautomation.com/u/davee_s)\ **Replies:** 1\ **Last updated:** [February 1, 2024, 6:05pm UTC](https://forum.inductiveautomation.com/t/perspective-table-header-checkbox/85114 "2024-02-01T18:05:43Z")
Hello guys, I am looking for a table to have a checkbox in the header to select/deselect all checkboxes in table rows like this image. Is possible to have in Perspective table? Thanks --- ## [Is it possible to change the filter table text field for the table object in perspective](https://forum.inductiveautomation.com/t/is-it-possible-to-change-the-filter-table-text-field-for-the-table-object-in-perspective/85108)
**Author:** [@Travis\_Crooks](https://forum.inductiveautomation.com/u/Travis_Crooks)\ **Replies:** 3\ **Last updated:** [February 1, 2024, 5:35pm UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-change-the-filter-table-text-field-for-the-table-object-in-perspective/85108 "2024-02-01T17:35:46Z")
Does anyone know if the search field properties can be modified in the perspective property editor? I cannot find this in the OTB properties that appear or from the property list for the table object. I also did not find… --- ## [runUpdateQuery - SQL Insert Into Select - multiple datasources](https://forum.inductiveautomation.com/t/runupdatequery-sql-insert-into-select-multiple-datasources/85046)
**Author:** [@Sam\_Oostendorp](https://forum.inductiveautomation.com/u/Sam_Oostendorp)\ **Replies:** 6\ **Last updated:** [February 1, 2024, 5:23pm UTC](https://forum.inductiveautomation.com/t/runupdatequery-sql-insert-into-select-multiple-datasources/85046 "2024-02-01T17:23:13Z")
I am trying to use a system.db.runUpdateQuery() command to execute an 'Insert Into Select' query to a SQL database. The SELECT statement is grabbing data from 1 database on 1 server, which has a valid connection in the … --- ## [Alarm Icons - Looking for alternate ideas - potential feature request](https://forum.inductiveautomation.com/t/alarm-icons-looking-for-alternate-ideas-potential-feature-request/85103)
**Author:** [@bwirth](https://forum.inductiveautomation.com/u/bwirth)\ **Replies:** 3\ **Last updated:** [February 1, 2024, 5:11pm UTC](https://forum.inductiveautomation.com/t/alarm-icons-looking-for-alternate-ideas-potential-feature-request/85103 "2024-02-01T17:11:37Z")
I have a need (desire) to show an alarm icon at various places on a screen. This needs: if alarms are active, highest priority, and if there are unAcked alarms. I am currently doing this through an expression on a pr… --- ## [HTTP POST Binding](https://forum.inductiveautomation.com/t/http-post-binding/85095)
**Author:** [@jakned](https://forum.inductiveautomation.com/u/jakned)\ **Replies:** 3\ **Last updated:** [February 1, 2024, 3:29pm UTC](https://forum.inductiveautomation.com/t/http-post-binding/85095 "2024-02-01T15:29:25Z")
Hi, I am working on a labeling project and I want to use Labelary API to render a ZPL code for me as a preview. I tried using a image component in Perspective and that did work with GET request (just like you do img tag … [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=489) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=491)