# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=380 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 381 --- ## [Can I use Named Query Parameters to filter SQL Table in Vision?](https://forum.inductiveautomation.com/t/can-i-use-named-query-parameters-to-filter-sql-table-in-vision/92803)
**Author:** [@Roisin\_McGuire](https://forum.inductiveautomation.com/u/Roisin_McGuire)\ **Replies:** 4\ **Last updated:** [July 4, 2024, 3:15pm UTC](https://forum.inductiveautomation.com/t/can-i-use-named-query-parameters-to-filter-sql-table-in-vision/92803 "2024-07-04T15:15:21Z")
I am using a Named Query to display a pivot table from my database in Vision. The user doesn't need to see all columns and I would like to filter the columns without manually hiding the unwanted ones. Reproducible dummy… --- ## [Perspective Scheduler - Drag and Drop From Table](https://forum.inductiveautomation.com/t/perspective-scheduler-drag-and-drop-from-table/71853)
**Author:** [@alex.chmelka](https://forum.inductiveautomation.com/u/alex.chmelka)\ **Replies:** 16\ **Last updated:** [July 4, 2024, 3:12pm UTC](https://forum.inductiveautomation.com/t/perspective-scheduler-drag-and-drop-from-table/71853 "2024-07-04T15:12:34Z")
I'm trying something I'm not 100% is possible to do but wanted to throw the question in case others have attempted it. We are experimenting with the Perspective Scheduler. A big potential GUI goal we have can be broken i… --- ## [Verifing Supervisor login](https://forum.inductiveautomation.com/t/verifing-supervisor-login/92802)
**Author:** [@Joren\_De\_Boel](https://forum.inductiveautomation.com/u/Joren_De_Boel)\ **Replies:** 2\ **Last updated:** [July 4, 2024, 1:55pm UTC](https://forum.inductiveautomation.com/t/verifing-supervisor-login/92802 "2024-07-04T13:55:24Z")
Hi, For Ignition 7.9 , I'm looking for a solution for the following situation : Operators are logged in using their normal user & password . But some specific actions require special supervisor verification. So i'm loo… --- ## [Rate effects on Subscribed OPC tags](https://forum.inductiveautomation.com/t/rate-effects-on-subscribed-opc-tags/92792)
**Author:** [@Alex\_Leech](https://forum.inductiveautomation.com/u/Alex_Leech)\ **Replies:** 1\ **Last updated:** [July 4, 2024, 11:47am UTC](https://forum.inductiveautomation.com/t/rate-effects-on-subscribed-opc-tags/92792 "2024-07-04T11:47:16Z")
Hi all, Looking for a bit of clarity on the underlying logic behind the rate on a subscribed OPC tag group. If a tag group has an OPC setting of 'Subscribed', is the 'rate' parameter redundant? I.e. Does the tag only … --- ## [Import tag error](https://forum.inductiveautomation.com/t/import-tag-error/92315)
**Author:** [@Arnau\_Pinyol\_Salva](https://forum.inductiveautomation.com/u/Arnau_Pinyol_Salva)\ **Replies:** 2\ **Last updated:** [July 4, 2024, 7:04am UTC](https://forum.inductiveautomation.com/t/import-tag-error/92315 "2024-07-04T07:04:48Z")
I am importing a list of tags.xml and when I import it I get this error: Tag errors occurred during tag import Error\_Exception("Error importing tags: com.inductiveautomation.ignition.common.xmlserialization.simple.Impor… --- ## [Label translation when is used white-space style](https://forum.inductiveautomation.com/t/label-translation-when-is-used-white-space-style/92731)
**Author:** [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\ **Replies:** 3\ **Last updated:** [July 4, 2024, 6:23am UTC](https://forum.inductiveautomation.com/t/label-translation-when-is-used-white-space-style/92731 "2024-07-04T06:23:43Z")
Good morning, I'm trying to figure out how to translate a label.. I write a kind of multiline using white-space: pre how can I manage the translation? I make some test changing the key in this way: Label Test and… --- ## [Gateway Event Script Not Executing](https://forum.inductiveautomation.com/t/gateway-event-script-not-executing/63003)
**Author:** [@Keith\_Magill](https://forum.inductiveautomation.com/u/Keith_Magill)\ **Replies:** 5\ **Last updated:** [July 4, 2024, 6:19am UTC](https://forum.inductiveautomation.com/t/gateway-event-script-not-executing/63003 "2024-07-04T06:19:16Z")
I am not sure why this is not executing properly. I am looking to set a tag value when minute == 00. Eventually I will be setting it at 12:01 am to reset some PLC tag values. I have been trying to use the Gateway eve… --- ## [Weird Bug? Or mistake on my end?](https://forum.inductiveautomation.com/t/weird-bug-or-mistake-on-my-end/92777)
**Author:** [@D\_Mitri\_Tompkins](https://forum.inductiveautomation.com/u/D_Mitri_Tompkins)\ **Replies:** 4\ **Last updated:** [July 4, 2024, 6:11am UTC](https://forum.inductiveautomation.com/t/weird-bug-or-mistake-on-my-end/92777 "2024-07-04T06:11:33Z")
This is in Perspective, earlier while trying to configure something I accidentally made a custom value on the view root that seems to incessantly come back and read as an issue even if I delete it, change its data type, … --- ## [Named query in a transform question](https://forum.inductiveautomation.com/t/named-query-in-a-transform-question/92555)
**Author:** [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\ **Replies:** 6\ **Last updated:** [July 4, 2024, 3:41am UTC](https://forum.inductiveautomation.com/t/named-query-in-a-transform-question/92555 "2024-07-04T03:41:38Z")
Would it be bad practice to run a named query in a transform? I have a sql query that returns some data and a separate table that I cant inner join. So I want to loop the rows and run a named query to pull in the other … --- ## [Perspective Pie Chart With Unit Labels](https://forum.inductiveautomation.com/t/perspective-pie-chart-with-unit-labels/92758)
**Author:** [@Jacob\_Leonard](https://forum.inductiveautomation.com/u/Jacob_Leonard)\ **Replies:** 3\ **Last updated:** [July 4, 2024, 2:52am UTC](https://forum.inductiveautomation.com/t/perspective-pie-chart-with-unit-labels/92758 "2024-07-04T02:52:57Z")
Working with the pie chart in perspective, and i would like to add unit labels to my chart. I can just add a label on top of the chart, but I would like it to scale with the chart. Any Ideas? Or should I do it the sim… --- ## [Typo in Perspective local storage key](https://forum.inductiveautomation.com/t/typo-in-perspective-local-storage-key/92779)
**Author:** [@bmusson](https://forum.inductiveautomation.com/u/bmusson)\ **Replies:** 0\ **Last updated:** [July 4, 2024, 1:05am UTC](https://forum.inductiveautomation.com/t/typo-in-perspective-local-storage-key/92779 "2024-07-04T01:05:30Z")
perspsective.session.identifier --- ## [Can you auto scroll to different position on a popup based on a value?](https://forum.inductiveautomation.com/t/can-you-auto-scroll-to-different-position-on-a-popup-based-on-a-value/92765)
**Author:** [@r123](https://forum.inductiveautomation.com/u/r123)\ **Replies:** 1\ **Last updated:** [July 3, 2024, 10:54pm UTC](https://forum.inductiveautomation.com/t/can-you-auto-scroll-to-different-position-on-a-popup-based-on-a-value/92765 "2024-07-03T22:54:42Z")
I have a popup with error codes and a scrollbar. Is there a way to scroll to the correct section based on the error code? Currently it just using the onClick select view to open the popup. --- ## [Alarm Pipeline Enable/Disable](https://forum.inductiveautomation.com/t/alarm-pipeline-enable-disable/44520)
**Author:** [@tre99ahs](https://forum.inductiveautomation.com/u/tre99ahs)\ **Replies:** 8\ **Last updated:** [July 3, 2024, 10:49pm UTC](https://forum.inductiveautomation.com/t/alarm-pipeline-enable-disable/44520 "2024-07-03T22:49:40Z")
We are trying to set up our Dial-Out Alarms in a way that they can be enabled and disabled from buttons on the HMI screens, we still want the alarm to be active at all times but we want to decide whether it goes through … --- ## [Tag History Partitions and Pruning](https://forum.inductiveautomation.com/t/tag-history-partitions-and-pruning/92775)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 1\ **Last updated:** [July 3, 2024, 10:35pm UTC](https://forum.inductiveautomation.com/t/tag-history-partitions-and-pruning/92775 "2024-07-03T22:35:36Z")
Quick questions, when you change the partitioning and pruning settings for a tag history provider, when do those changes take affect? For instance, changing pruning from 1 year to 6 months, when is that data deleted? Or… --- ## [Microsoft Entra ID Mutli-Tenant Identity Provider](https://forum.inductiveautomation.com/t/microsoft-entra-id-mutli-tenant-identity-provider/92773)
**Author:** [@Johnnie\_McCord](https://forum.inductiveautomation.com/u/Johnnie_McCord)\ **Replies:** 0\ **Last updated:** [July 3, 2024, 9:07pm UTC](https://forum.inductiveautomation.com/t/microsoft-entra-id-mutli-tenant-identity-provider/92773 "2024-07-03T21:07:17Z")
Hello all, I am attempting to set up MS Entra ID as an OIDC Identity Provider in Ignition 8.1.37 for a client. When the MS Entra ID application is configured as single tenant everything works fine but only users from t… --- ## [Boolean True Counter](https://forum.inductiveautomation.com/t/boolean-true-counter/92760)
**Author:** [@Stephanie\_Aguiar](https://forum.inductiveautomation.com/u/Stephanie_Aguiar)\ **Replies:** 9\ **Last updated:** [July 3, 2024, 8:43pm UTC](https://forum.inductiveautomation.com/t/boolean-true-counter/92760 "2024-07-03T20:43:44Z")
I have a Boolean tag CH1\_Fault\_Boolean and I would like to count the amount of time this tag is true in a day. I have this code that works fine, but after using it for a while it shows an error but still keeps counting w… --- ## [Dynamically adjust xy chart length](https://forum.inductiveautomation.com/t/dynamically-adjust-xy-chart-length/92569)
**Author:** [@Hema\_T](https://forum.inductiveautomation.com/u/Hema_T)\ **Replies:** 3\ **Last updated:** [July 3, 2024, 7:21pm UTC](https://forum.inductiveautomation.com/t/dynamically-adjust-xy-chart-length/92569 "2024-07-03T19:21:14Z")
hi , In one of my charts , when values are high its not visible unless in hovering . So how to dynamically adjust the chart length based on the values --- ## [Vision Window Error: Listing Roles](https://forum.inductiveautomation.com/t/vision-window-error-listing-roles/92754)
**Author:** [@Charlie\_Boykin](https://forum.inductiveautomation.com/u/Charlie_Boykin)\ **Replies:** 2\ **Last updated:** [July 3, 2024, 5:54pm UTC](https://forum.inductiveautomation.com/t/vision-window-error-listing-roles/92754 "2024-07-03T17:54:32Z")
Any time I try and configure a script for a component using vison windows this window/process takes places. The error message says "Error listing roles" Details tab says: com.inductiveautomation.ignition.client.gatew… --- ## [Getting error trying to connect to Ignition OPC UA Server with security Basic256Sha256](https://forum.inductiveautomation.com/t/getting-error-trying-to-connect-to-ignition-opc-ua-server-with-security-basic256sha256/85242)
**Author:** [@Eike\_Saathoff](https://forum.inductiveautomation.com/u/Eike_Saathoff)\ **Replies:** 12\ **Last updated:** [July 3, 2024, 5:35pm UTC](https://forum.inductiveautomation.com/t/getting-error-trying-to-connect-to-ignition-opc-ua-server-with-security-basic256sha256/85242 "2024-07-03T17:35:31Z")
Hi everybody, I am trying to connect to the internal Ignition OPC UA-Server via python script with the opcua library. I changed the 'Bind Address' to 0.0.0.0 and exposed the tag browsers. I also restarted after. I also… --- ## [JFileChooser not respecting setCurrentDirectory](https://forum.inductiveautomation.com/t/jfilechooser-not-respecting-setcurrentdirectory/92756)
**Author:** [@michael.flagler](https://forum.inductiveautomation.com/u/michael.flagler)\ **Replies:** 0\ **Last updated:** [July 3, 2024, 5:17pm UTC](https://forum.inductiveautomation.com/t/jfilechooser-not-respecting-setcurrentdirectory/92756 "2024-07-03T17:17:48Z")
Anyone else ran across the issue when trying to use JFileChooser to open/save that it doens't respect the setCurrentDirectory when trying to point it to the current user's Documents folder? It works the first time, but t… --- ## [Active alarm in area?](https://forum.inductiveautomation.com/t/active-alarm-in-area/41892)
**Author:** [@pdixon](https://forum.inductiveautomation.com/u/pdixon)\ **Replies:** 22\ **Last updated:** [July 3, 2024, 3:27pm UTC](https://forum.inductiveautomation.com/t/active-alarm-in-area/41892 "2024-07-03T15:27:40Z")
I would like to have a way of knowing if any PLC tag in a particular process area has an active alarm so that I can show in the HMI which areas have or do not have an active alarm. This could be used in a process overvi… --- ## [Inquiry about Certification Compliance of Ignition SCADA for IEC 61850 and DNP3 Standards](https://forum.inductiveautomation.com/t/inquiry-about-certification-compliance-of-ignition-scada-for-iec-61850-and-dnp3-standards/92752)
**Author:** [@Pofer\_Wang](https://forum.inductiveautomation.com/u/Pofer_Wang)\ **Replies:** 1\ **Last updated:** [July 3, 2024, 2:25pm UTC](https://forum.inductiveautomation.com/t/inquiry-about-certification-compliance-of-ignition-scada-for-iec-61850-and-dnp3-standards/92752 "2024-07-03T14:25:24Z")
I currently have a project that is preparing to use Ignition SCADA and will utilize the 61850 and DNP3 communication functionalities. I would like to ask if it has passed the relevant certifications, such as UCA, KEMA, … --- ## [Creating alarms using scripting](https://forum.inductiveautomation.com/t/creating-alarms-using-scripting/92735)
**Author:** [@Purushothaman\_R](https://forum.inductiveautomation.com/u/Purushothaman_R)\ **Replies:** 2\ **Last updated:** [July 3, 2024, 2:48pm UTC](https://forum.inductiveautomation.com/t/creating-alarms-using-scripting/92735 "2024-07-03T14:48:08Z")
table { border: 1px solid #c4c7c5; border-radius: 4px; font-size: 16px; } th { padding: 18px 16px; text-align: left; } td { padding: 16px; border-top: 1px solid #c4c7c5; } .katex-mathml{ display: block; text-align: cente… --- ## [Help making system.util.execute work on Windows](https://forum.inductiveautomation.com/t/help-making-system-util-execute-work-on-windows/91396)
**Author:** [@diamond](https://forum.inductiveautomation.com/u/diamond)\ **Replies:** 3\ **Last updated:** [July 3, 2024, 2:43pm UTC](https://forum.inductiveautomation.com/t/help-making-system-util-execute-work-on-windows/91396 "2024-07-03T14:43:54Z")
Hello, I am trying to implement automatic git push on project update. Everything looks fine except for the system.util.execute function which does not seem to be working for me. I have a Windows Server 2022, and Igniti… --- ## [Export Tree structure](https://forum.inductiveautomation.com/t/export-tree-structure/92728)
**Author:** [@Anita.Shinde](https://forum.inductiveautomation.com/u/Anita.Shinde)\ **Replies:** 5\ **Last updated:** [July 3, 2024, 1:44pm UTC](https://forum.inductiveautomation.com/t/export-tree-structure/92728 "2024-07-03T13:44:56Z")
Hi, I want to export the tree structure from one gateway and import it to another gateway. Is it possible to export in ignition vision, anyone has any idea on this? Thanks in advance. --- ## [Perspective Google Maps Component Popups](https://forum.inductiveautomation.com/t/perspective-google-maps-component-popups/92748)
**Author:** [@Carlo\_DeSantis](https://forum.inductiveautomation.com/u/Carlo_DeSantis)\ **Replies:** 0\ **Last updated:** [July 3, 2024, 1:27pm UTC](https://forum.inductiveautomation.com/t/perspective-google-maps-component-popups/92748 "2024-07-03T13:27:45Z")
Is there any way to access the headerDisabled field for the InfoWindow component that is being used for the popups on the Google Maps component? --- ## [Siemens S7-1500 TIME datatype addressing](https://forum.inductiveautomation.com/t/siemens-s7-1500-time-datatype-addressing/15877)
**Author:** [@kevin.jones](https://forum.inductiveautomation.com/u/kevin.jones)\ **Replies:** 5\ **Last updated:** [July 3, 2024, 9:50am UTC](https://forum.inductiveautomation.com/t/siemens-s7-1500-time-datatype-addressing/15877 "2024-07-03T09:50:41Z")
Hello, I'm trying to address a TIME datatype on a Siemens S7-1500 PLC but unable to get a good tag connection in Ignition. All the data I'm trying to access is in DB50. All other data (bools and words) connect and read… --- ## [Alarms Status Table - Automatic column width](https://forum.inductiveautomation.com/t/alarms-status-table-automatic-column-width/92733)
**Author:** [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\ **Replies:** 0\ **Last updated:** [July 3, 2024, 8:46am UTC](https://forum.inductiveautomation.com/t/alarms-status-table-automatic-column-width/92733 "2024-07-03T08:46:30Z")
Good morning, I wonder how to set the automatic width of a specific column (in my case "Label") based on the lenght of the text in an Alarm Status Table in Perspective. I tried to clear the width property and even to se… --- ## [How to set full screen on tablet](https://forum.inductiveautomation.com/t/how-to-set-full-screen-on-tablet/92677)
**Author:** [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\ **Replies:** 7\ **Last updated:** [July 3, 2024, 7:59am UTC](https://forum.inductiveautomation.com/t/how-to-set-full-screen-on-tablet/92677 "2024-07-03T07:59:17Z")
Hello, maybe is a stupid question but I cannot find any help. I'm using a tablet where I installed the perspective app. I would like to run the project in full screen mode, without the status bar, is it possible? --- ## [Pipe linear gradient filling color](https://forum.inductiveautomation.com/t/pipe-linear-gradient-filling-color/92730)
**Author:** [@Martin\_Chauveliere](https://forum.inductiveautomation.com/u/Martin_Chauveliere)\ **Replies:** 0\ **Last updated:** [July 3, 2024, 7:55am UTC](https://forum.inductiveautomation.com/t/pipe-linear-gradient-filling-color/92730 "2024-07-03T07:55:50Z")
Hi guys, I would like to fill a pipe with a gradient color such as : linear-gradient(-90deg, #EF8D8D, #88DFFF); How can I manage to do that. Thx [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=379) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=381)