# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=738 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 739 --- ## [\[IGN-6887\] Read E-Mails on IMAP with OAUTH2](https://forum.inductiveautomation.com/t/ign-6887-read-e-mails-on-imap-with-oauth2/67184)
**Author:** [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\ **Replies:** 11\ **Last updated:** [December 3, 2022, 1:31am UTC](https://forum.inductiveautomation.com/t/ign-6887-read-e-mails-on-imap-with-oauth2/67184 "2022-12-03T01:31:11Z")
I have a customer that is using e-mail to transfer data to Ignition. The script that is being used to retrieve and process those e-mails and attachments is using the python imaplib. Now with MSFT and Google dropping basi… --- ## [Tag History Hours Above X Setpoint](https://forum.inductiveautomation.com/t/tag-history-hours-above-x-setpoint/67199)
**Author:** [@markusx1094](https://forum.inductiveautomation.com/u/markusx1094)\ **Replies:** 1\ **Last updated:** [December 3, 2022, 12:49am UTC](https://forum.inductiveautomation.com/t/tag-history-hours-above-x-setpoint/67199 "2022-12-03T00:49:01Z")
I would like to be able to query one of our tags to get how many hours within a month that it is above X setpoint. It seems like I should be able to do this with the reporting module but I can't seem to figure out how to… --- ## [How to bind multiple tags on templates?](https://forum.inductiveautomation.com/t/how-to-bind-multiple-tags-on-templates/67152)
**Author:** [@Elie\_Khananya](https://forum.inductiveautomation.com/u/Elie_Khananya)\ **Replies:** 5\ **Last updated:** [December 3, 2022, 12:40am UTC](https://forum.inductiveautomation.com/t/how-to-bind-multiple-tags-on-templates/67152 "2022-12-03T00:40:57Z")
hello, im hoping this is possible. I basically created a light image in templates and have multiple tags all booleans. i want to bind every tag to this template to have different colors. tag1 yellow, tag 2 red tag 3 gree… --- ## [Perspective - XYChart tooltip not visible](https://forum.inductiveautomation.com/t/perspective-xychart-tooltip-not-visible/67193)
**Author:** [@Michael\_White](https://forum.inductiveautomation.com/u/Michael_White)\ **Replies:** 3\ **Last updated:** [December 2, 2022, 11:49pm UTC](https://forum.inductiveautomation.com/t/perspective-xychart-tooltip-not-visible/67193 "2022-12-02T23:49:39Z")
Perhaps I'm just misunderstanding the component, but under the Series section of my XYChart props, it has a Tooltip section. I assumed this tooltip would be for hovering over that series, it will tell you the exact valu… --- ## [Moxa Mgate MB3180 troubleshooting questions](https://forum.inductiveautomation.com/t/moxa-mgate-mb3180-troubleshooting-questions/67198)
**Author:** [@IgnitionNewbie](https://forum.inductiveautomation.com/u/IgnitionNewbie)\ **Replies:** 4\ **Last updated:** [December 2, 2022, 11:38pm UTC](https://forum.inductiveautomation.com/t/moxa-mgate-mb3180-troubleshooting-questions/67198 "2022-12-02T23:38:56Z")
I have finally acquired a moxa to test if I can use it to convert serial to ethernet for ignition Im hoping we can get 1 to work as a proof of concept , because then I will be allowed to get 2 more for other projects t… --- ## [Ethernet Fieldbus Connection Checkweigher Device](https://forum.inductiveautomation.com/t/ethernet-fieldbus-connection-checkweigher-device/67191)
**Author:** [@beckya](https://forum.inductiveautomation.com/u/beckya)\ **Replies:** 6\ **Last updated:** [December 2, 2022, 8:12pm UTC](https://forum.inductiveautomation.com/t/ethernet-fieldbus-connection-checkweigher-device/67191 "2022-12-02T20:12:32Z")
I have In-Line Checkweighers that I need to connect to from Mettler Toledo and they have ethernet/IP fieldbus module installed on them. What driver can I use to connect to them? Does anyone have experience connecting to … --- ## [Cascading dropdowns in Perspective](https://forum.inductiveautomation.com/t/cascading-dropdowns-in-perspective/67162)
**Author:** [@hw79](https://forum.inductiveautomation.com/u/hw79)\ **Replies:** 5\ **Last updated:** [December 2, 2022, 6:50pm UTC](https://forum.inductiveautomation.com/t/cascading-dropdowns-in-perspective/67162 "2022-12-02T18:50:11Z")
I'm sure this is all noob stuff, but I'm trying to make a dropdown dependent on the selection of another dropdown. The first dropdown is populated from a SQL query and filters the table data, I'd like to get the second … --- ## [Translations for Alarm Messages](https://forum.inductiveautomation.com/t/translations-for-alarm-messages/11576)
**Author:** [@KenSchnipke](https://forum.inductiveautomation.com/u/KenSchnipke)\ **Replies:** 10\ **Last updated:** [December 2, 2022, 5:17pm UTC](https://forum.inductiveautomation.com/t/translations-for-alarm-messages/11576 "2022-12-02T17:17:57Z")
I'm evaluating Ignition as an alternative to our current HMI software. Everything looks excellent, but I can't seem to figure out the cleanest way to provide multiple language support for alarms. The alarm status table s… --- ## [Perspective Power Chart: pen selected event](https://forum.inductiveautomation.com/t/perspective-power-chart-pen-selected-event/67126)
**Author:** [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\ **Replies:** 2\ **Last updated:** [December 2, 2022, 4:07pm UTC](https://forum.inductiveautomation.com/t/perspective-power-chart-pen-selected-event/67126 "2022-12-02T16:07:45Z")
Hi all, I cannot find a way to catch the event, when a pen in a Power Chart has been selected by the operator. I'd like to react to that event to show/hide the axes grids as needed - I have many different pens on my Pow… --- ## [Adding Table Columns in Perspective with Script or Expression](https://forum.inductiveautomation.com/t/adding-table-columns-in-perspective-with-script-or-expression/67183)
**Author:** [@CTrenkamp](https://forum.inductiveautomation.com/u/CTrenkamp)\ **Replies:** 7\ **Last updated:** [December 2, 2022, 3:50pm UTC](https://forum.inductiveautomation.com/t/adding-table-columns-in-perspective-with-script-or-expression/67183 "2022-12-02T15:50:14Z")
Is it possible to add columns to table props with code dynamically. I was not able to find a solution but only this which states it can be done manually. I am trying to change the number of columns based on what table is… --- ## [Updating tag with latest record from table?](https://forum.inductiveautomation.com/t/updating-tag-with-latest-record-from-table/67156)
**Author:** [@rahman.tarek](https://forum.inductiveautomation.com/u/rahman.tarek)\ **Replies:** 1\ **Last updated:** [December 2, 2022, 3:21pm UTC](https://forum.inductiveautomation.com/t/updating-tag-with-latest-record-from-table/67156 "2022-12-02T15:21:36Z")
Hi there, i have a tag called operation\_number and i also have the same value in a table. I want the tag to query the latest record from the operation\_number value in the table for the respective machine. What is the be… --- ## [Ignition OPC UA loopback connection - can it expire?](https://forum.inductiveautomation.com/t/ignition-opc-ua-loopback-connection-can-it-expire/67090)
**Author:** [@reto.kunz](https://forum.inductiveautomation.com/u/reto.kunz)\ **Replies:** 9\ **Last updated:** [December 2, 2022, 2:27pm UTC](https://forum.inductiveautomation.com/t/ignition-opc-ua-loopback-connection-can-it-expire/67090 "2022-12-02T14:27:37Z")
There is something about the Ignition OPC UA loopback connection that I don't fully understand. Maybe someone can give me a hint. Per default, the tag system uses the 'Ignition OPC UA Server'- connection for OPC tags. P… --- ## [Database Driver corrupted, now cannot open the Databases/Driver page](https://forum.inductiveautomation.com/t/database-driver-corrupted-now-cannot-open-the-databases-driver-page/67180)
**Author:** [@Luis\_Miguel\_Rodrigue](https://forum.inductiveautomation.com/u/Luis_Miguel_Rodrigue)\ **Replies:** 2\ **Last updated:** [December 2, 2022, 1:28pm UTC](https://forum.inductiveautomation.com/t/database-driver-corrupted-now-cannot-open-the-databases-driver-page/67180 "2022-12-02T13:28:54Z")
Im currently having some issues with the connections section in the ignition configuration. After loading the wrong JAR files into the drivers module, the page doesnt load again, and is always showing a 500 page error. A… --- ## [Ignition Memory increasing after Scripting Restart](https://forum.inductiveautomation.com/t/ignition-memory-increasing-after-scripting-restart/66799)
**Author:** [@majad](https://forum.inductiveautomation.com/u/majad)\ **Replies:** 10\ **Last updated:** [December 2, 2022, 10:18am UTC](https://forum.inductiveautomation.com/t/ignition-memory-increasing-after-scripting-restart/66799 "2022-12-02T10:18:33Z")
Hello there, i wrote some functions in a shared Script which are called from an UDTs valueChanged event. Now every time i save some Changes i made in my Script and the Scripting restarts because of that the Memory usage… --- ## [User Source table-Authentication issue](https://forum.inductiveautomation.com/t/user-source-table-authentication-issue/67021)
**Author:** [@Krishnapriya\_K\_S](https://forum.inductiveautomation.com/u/Krishnapriya_K_S)\ **Replies:** 3\ **Last updated:** [December 2, 2022, 10:12am UTC](https://forum.inductiveautomation.com/t/user-source-table-authentication-issue/67021 "2022-12-02T10:12:06Z")
Hai , I need to change the column names in the user source table because doing so causes the authentication to fail. Is it viable to modify the table?How am i able to authenticate? Thanks in advance, --- ## [Authentication Challenge Popup - Hide close button](https://forum.inductiveautomation.com/t/authentication-challenge-popup-hide-close-button/67176)
**Author:** [@mdia](https://forum.inductiveautomation.com/u/mdia)\ **Replies:** 1\ **Last updated:** [December 2, 2022, 10:05am UTC](https://forum.inductiveautomation.com/t/authentication-challenge-popup-hide-close-button/67176 "2022-12-02T10:05:54Z")
Is there a way to hide the close button ('x' icon) from the embedded frame AuthChallenge? Seems like closing the popup from there doesn't return a result.isError() or anything, unless I am mistaken. --- ## [\[FEATURE\] EAM - Allow sending of tags from Agents](https://forum.inductiveautomation.com/t/feature-eam-allow-sending-of-tags-from-agents/67173)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 1\ **Last updated:** [December 2, 2022, 6:41am UTC](https://forum.inductiveautomation.com/t/feature-eam-allow-sending-of-tags-from-agents/67173 "2022-12-02T06:41:19Z")
It seems a bit silly not to allow sending of tags from an Agent to a controller when it's possible to send projects from Agent to Controller :confused: Thus, please allow sending tags from an Agent to EAM Agents/Control… --- ## [Counting Table Columns](https://forum.inductiveautomation.com/t/counting-table-columns/67171)
**Author:** [@CTrenkamp](https://forum.inductiveautomation.com/u/CTrenkamp)\ **Replies:** 4\ **Last updated:** [December 2, 2022, 3:12am UTC](https://forum.inductiveautomation.com/t/counting-table-columns/67171 "2022-12-02T03:12:02Z")
For some reason I cannot find anything that tells me how to count the number of columns in a table, only rows. Any suggestions? --- ## [User Source Table-Authentication Error](https://forum.inductiveautomation.com/t/user-source-table-authentication-error/67048)
**Author:** [@Goutham\_Rao\_Y](https://forum.inductiveautomation.com/u/Goutham_Rao_Y)\ **Replies:** 3\ **Last updated:** [December 1, 2022, 4:59am UTC](https://forum.inductiveautomation.com/t/user-source-table-authentication-error/67048 "2022-12-01T04:59:39Z")
Hello Team, I need your help to tackle the following problem. Database used: MSSQL server Module: Perspective When I tried to rename the column \[belonging to login authentication table\] with a new name, the column up… --- ## [Power chart stopped working on newer historical data](https://forum.inductiveautomation.com/t/power-chart-stopped-working-on-newer-historical-data/66612)
**Author:** [@codersmurf](https://forum.inductiveautomation.com/u/codersmurf)\ **Replies:** 1\ **Last updated:** [December 1, 2022, 11:17pm UTC](https://forum.inductiveautomation.com/t/power-chart-stopped-working-on-newer-historical-data/66612 "2022-12-01T23:17:15Z")
We had an issue with the database not keeping up, finally got it to play nice and it's doing fine. But now the powerchart isn't working with the data from the time the db was having issues. Any data before that is fine… --- ## [HTML5 Video in Vision 8.1.21](https://forum.inductiveautomation.com/t/html5-video-in-vision-8-1-21/66600)
**Author:** [@B\_Graham](https://forum.inductiveautomation.com/u/B_Graham)\ **Replies:** 1\ **Last updated:** [December 1, 2022, 11:08pm UTC](https://forum.inductiveautomation.com/t/html5-video-in-vision-8-1-21/66600 "2022-12-01T23:08:07Z")
Ignition 8.1.21 Good afternoon, I am wanting to view some setup videos in our Vision project. After doing some reading in the forums this has come up a couple times and in most cases was addressed using the Web dev mod… --- ## [Orthographic View Builder](https://forum.inductiveautomation.com/t/orthographic-view-builder/66813)
**Author:** [@kgamble](https://forum.inductiveautomation.com/u/kgamble)\ **Replies:** 4\ **Last updated:** [December 1, 2022, 8:50pm UTC](https://forum.inductiveautomation.com/t/orthographic-view-builder/66813 "2022-12-01T20:50:39Z")
I am currently working on a tool to make building orthographic views sillier to this one by @nader.chinichian I am soliciting some community feedback on a few questions I have to get some ideas. If the original builder… --- ## [Element cannot be null, PropertyTree ValueNode, NullPointerException](https://forum.inductiveautomation.com/t/element-cannot-be-null-propertytree-valuenode-nullpointerexception/67164)
**Author:** [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\ **Replies:** 10\ **Last updated:** [December 1, 2022, 9:10pm UTC](https://forum.inductiveautomation.com/t/element-cannot-be-null-propertytree-valuenode-nullpointerexception/67164 "2022-12-01T21:10:17Z")
I'm getting an ExecutionQueue WARN that is all over the logger in a gateway. I'm working on some other issues, better trapping exception etc... and this one doesn't give me any indication on where or what it causing thi… --- ## [Variables in Expression Language](https://forum.inductiveautomation.com/t/variables-in-expression-language/67154)
**Author:** [@Raymundo\_Villa](https://forum.inductiveautomation.com/u/Raymundo_Villa)\ **Replies:** 3\ **Last updated:** [December 1, 2022, 8:02pm UTC](https://forum.inductiveautomation.com/t/variables-in-expression-language/67154 "2022-12-01T20:02:41Z")
I am needing to know if in the "Expression" language of Ignition, can you create variables that will only be use in that expression. --- ## [Ignition with Mac OSX Mavericks](https://forum.inductiveautomation.com/t/ignition-with-mac-osx-mavericks/7828)
**Author:** [@cgele](https://forum.inductiveautomation.com/u/cgele)\ **Replies:** 1\ **Last updated:** [January 13, 2014, 8:59pm UTC](https://forum.inductiveautomation.com/t/ignition-with-mac-osx-mavericks/7828 "2014-01-13T20:59:32Z")
Anyone tried using Ignition with the new Mac OS? I'm considering updating, but wanted to see if there are any experiences either good or not so good. Thanks! --- ## [\[Bug\] Perspective Developer Container Issues](https://forum.inductiveautomation.com/t/bug-perspective-developer-container-issues/67120)
**Author:** [@drastura](https://forum.inductiveautomation.com/u/drastura)\ **Replies:** 5\ **Last updated:** [December 1, 2022, 6:33pm UTC](https://forum.inductiveautomation.com/t/bug-perspective-developer-container-issues/67120 "2022-12-01T18:33:57Z")
Where to I actually report a bug? in short, this is 8.1.21, Perspective, Designer. I have a container with a base property, and elements within, some scripted, some direct. If I'm in Designer, and copy the container, … --- ## [Scripting help: inserting data to a table, none type, dictionary, dynamic paths, f-string](https://forum.inductiveautomation.com/t/scripting-help-inserting-data-to-a-table-none-type-dictionary-dynamic-paths-f-string/53853)
**Author:** [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Replies:** 52\ **Last updated:** [April 6, 2022, 1:12pm UTC](https://forum.inductiveautomation.com/t/scripting-help-inserting-data-to-a-table-none-type-dictionary-dynamic-paths-f-string/53853 "2022-04-06T13:12:06Z")
in my dictionary I have: 199: "zone A", 200: " ", so in my script, I am trying to say something like if value=" " value=" " else value="located in "+value How do I ask if value is equal to a space? update I was m… --- ## [SQL query through script](https://forum.inductiveautomation.com/t/sql-query-through-script/44210)
**Author:** [@kp.krishnaprasad97](https://forum.inductiveautomation.com/u/kp.krishnaprasad97)\ **Replies:** 7\ **Last updated:** [December 1, 2022, 6:05pm UTC](https://forum.inductiveautomation.com/t/sql-query-through-script/44210 "2022-12-01T18:05:54Z")
How to run SQL query in python script using built in function in ignition and syntax query=“SELECT ID,EQUIPMENT,STREAMFUNCTION,Message FROM Messages WHERE STREAMFUNCTION LIKE “%S6%” and Reply = 1 ORDER BY ID DESC L… --- ## [Script help: Holiday edge case lead to empty datasets](https://forum.inductiveautomation.com/t/script-help-holiday-edge-case-lead-to-empty-datasets/66975)
**Author:** [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Replies:** 29\ **Last updated:** [December 1, 2022, 6:03pm UTC](https://forum.inductiveautomation.com/t/script-help-holiday-edge-case-lead-to-empty-datasets/66975 "2022-12-01T18:03:54Z")
for row, nextRow in zip(datasetIn, datasetIn\[1:\]): After a long holiday, I don't have any data. So when I reference nextRow, I get an error that I tried to call an undefined nextRow. So to fix this, I thought maybe: t… --- ## [Vision client launcher login fail](https://forum.inductiveautomation.com/t/vision-client-launcher-login-fail/67139)
**Author:** [@wei\_li](https://forum.inductiveautomation.com/u/wei_li)\ **Replies:** 1\ **Last updated:** [December 1, 2022, 4:52pm UTC](https://forum.inductiveautomation.com/t/vision-client-launcher-login-fail/67139 "2022-12-01T16:52:41Z")
Hi guys, i am new bee of ignition, i got a problem. vision client launcher login fail after i input the username and password. how to solve this problem please??? [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=737) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=739)