# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=739 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 740 --- ## [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??? --- ## [Syntax Error on Token: 'EQUAL' (Line 1 , Char 8)](https://forum.inductiveautomation.com/t/syntax-error-on-token-equal-line-1-char-8/67153)
**Author:** [@Pranav\_Ravichandran](https://forum.inductiveautomation.com/u/Pranav_Ravichandran)\ **Replies:** 1\ **Last updated:** [December 1, 2022, 4:52pm UTC](https://forum.inductiveautomation.com/t/syntax-error-on-token-equal-line-1-char-8/67153 "2022-12-01T16:52:03Z")
Syntax Error on Token: 'EQUAL' (Line 1 , Char 8) is the error i am getting everytime i use a equal to symbol for example I am trying to switch windows every 10 seconds and I used a timer to initiate the change and when i… --- ## [Message gui shows up twice?](https://forum.inductiveautomation.com/t/message-gui-shows-up-twice/67143)
**Author:** [@rahman.tarek](https://forum.inductiveautomation.com/u/rahman.tarek)\ **Replies:** 4\ **Last updated:** [December 1, 2022, 4:37pm UTC](https://forum.inductiveautomation.com/t/message-gui-shows-up-twice/67143 "2022-12-01T16:37:03Z")
Hi there, I have a script in the database extension function such that when both cause and comment of the table is entered i want to show a confirmation dialog box. But for some reason i keep getting two. any ideas why … --- ## [Component Error on Time Series Chart with Query](https://forum.inductiveautomation.com/t/component-error-on-time-series-chart-with-query/67110)
**Author:** [@Alexandre\_Potvin](https://forum.inductiveautomation.com/u/Alexandre_Potvin)\ **Replies:** 3\ **Last updated:** [December 1, 2022, 3:26pm UTC](https://forum.inductiveautomation.com/t/component-error-on-time-series-chart-with-query/67110 "2022-12-01T15:26:03Z")
Hi I keep getting component error on my Time Serie Chart. The data look good. Maybe is because i am using a a temporary table but the data look ok so i am confused maybe somone can help. Thank You --- ## [Receive an access level error while writing to a tag](https://forum.inductiveautomation.com/t/receive-an-access-level-error-while-writing-to-a-tag/66879)
**Author:** [@Anna\_Goldberg](https://forum.inductiveautomation.com/u/Anna_Goldberg)\ **Replies:** 15\ **Last updated:** [December 1, 2022, 2:21pm UTC](https://forum.inductiveautomation.com/t/receive-an-access-level-error-while-writing-to-a-tag/66879 "2022-12-01T14:21:42Z")
I try to wright to a tag, even though it's security wright permissions are set to public I receive error message regarding security level: "The access level does not allow writing to the node. --- ## [Ignition on Steam Deck - Confirmed working](https://forum.inductiveautomation.com/t/ignition-on-steam-deck-confirmed-working/66690)
**Author:** [@mathieurleblanc33](https://forum.inductiveautomation.com/u/mathieurleblanc33)\ **Replies:** 2\ **Last updated:** [December 1, 2022, 2:16pm UTC](https://forum.inductiveautomation.com/t/ignition-on-steam-deck-confirmed-working/66690 "2022-12-01T14:16:13Z")
Hi, I can confirm that Ignition 8.1.22 will work on the Steam Deck. Project Designer and client launcher is fully functional. Note: When doing the install via installer.run file, change the default install directory f… --- ## [Ignition - Script - API call error](https://forum.inductiveautomation.com/t/ignition-script-api-call-error/67128)
**Author:** [@Elangovan\_Packirisam](https://forum.inductiveautomation.com/u/Elangovan_Packirisam)\ **Replies:** 3\ **Last updated:** [December 1, 2022, 1:27pm UTC](https://forum.inductiveautomation.com/t/ignition-script-api-call-error/67128 "2022-12-01T13:27:14Z")
I have a script with goes as follow. I am trying to print weather data by API. This API end point and the parameters I posted is working fine when I checked with POSTMAN API app. But it doesn't work while I do from the I… --- ## [1756-L61/B Rev. 20.019](https://forum.inductiveautomation.com/t/1756-l61-b-rev-20-019/44588)
**Author:** [@toddhowden](https://forum.inductiveautomation.com/u/toddhowden)\ **Replies:** 7\ **Last updated:** [December 1, 2022, 1:25pm UTC](https://forum.inductiveautomation.com/t/1756-l61-b-rev-20-019/44588 "2022-12-01T13:25:39Z")
Has anyone had issues connecting to an AB 1756-L61/B controller running version 20.019? I have been able to connect similar controllers with earlier versions without issue but have difficulty getting this controller to … --- ## [Gateway error: Received event for missing view "Audit1\_SP@C"](https://forum.inductiveautomation.com/t/gateway-error-received-event-for-missing-view-audit1-sp-c/67102)
**Author:** [@Michael\_Coleman](https://forum.inductiveautomation.com/u/Michael_Coleman)\ **Replies:** 8\ **Last updated:** [December 1, 2022, 12:12pm UTC](https://forum.inductiveautomation.com/t/gateway-error-received-event-for-missing-view-audit1-sp-c/67102 "2022-12-01T12:12:49Z")
I am receiving a gateway error: "Received event for missing view 'Audit1\_SP@C"'. The script is taking the drop down box answers and dumping them into a SQL database. The script works in preview mode on the Ignition desig… --- ## [Alarm Event Value format](https://forum.inductiveautomation.com/t/alarm-event-value-format/66800)
**Author:** [@bfreeman](https://forum.inductiveautomation.com/u/bfreeman)\ **Replies:** 2\ **Last updated:** [December 1, 2022, 9:38am UTC](https://forum.inductiveautomation.com/t/alarm-event-value-format/66800 "2022-12-01T09:38:34Z")
Hi, Is there a way to format the display of the Event Value in a Perspective Alarm Status Table? I have a use case with an Event Value which is a DateTime and I would like to specify a date format. Thanks --- ## [Date format displays string in Perspective Table component](https://forum.inductiveautomation.com/t/date-format-displays-string-in-perspective-table-component/67125)
**Author:** [@Amruth\_Jois](https://forum.inductiveautomation.com/u/Amruth_Jois)\ **Replies:** 6\ **Last updated:** [December 1, 2022, 9:32am UTC](https://forum.inductiveautomation.com/t/date-format-displays-string-in-perspective-table-component/67125 "2022-12-01T09:32:03Z")
hi Team, i am trying get the data from SQL table to Perspective Table component, but dat format is displaying as string format, that i couldn't able to solve this. --- ## [Table component displaying datetime as a string](https://forum.inductiveautomation.com/t/table-component-displaying-datetime-as-a-string/58114)
**Author:** [@Dean\_Walsh](https://forum.inductiveautomation.com/u/Dean_Walsh)\ **Replies:** 9\ **Last updated:** [December 1, 2022, 9:09am UTC](https://forum.inductiveautomation.com/t/table-component-displaying-datetime-as-a-string/58114 "2022-12-01T09:09:00Z")
I would like to display a datetime from an SQL database in a table but i believe its giving me the date as a string despite seemingly recognizing it as a date in the dataset editor. (the data type provided for it fro… --- ## [Script to remove parameter from tag](https://forum.inductiveautomation.com/t/script-to-remove-parameter-from-tag/66953)
**Author:** [@abiesbiogas](https://forum.inductiveautomation.com/u/abiesbiogas)\ **Replies:** 19\ **Last updated:** [December 1, 2022, 8:54am UTC](https://forum.inductiveautomation.com/t/script-to-remove-parameter-from-tag/66953 "2022-12-01T08:54:30Z")
Hello, I did some research but I couldn't find a way to do it: how can I remove a custom parameter from tag by script? I have an udt defined, say myUDT, and it has a parameter, say myParameter, then I added an instanc… --- ## [Configure HTTP Binding](https://forum.inductiveautomation.com/t/configure-http-binding/67082)
**Author:** [@Italo\_Araujo](https://forum.inductiveautomation.com/u/Italo_Araujo)\ **Replies:** 1\ **Last updated:** [December 1, 2022, 7:19am UTC](https://forum.inductiveautomation.com/t/configure-http-binding/67082 "2022-12-01T07:19:35Z")
Hello, I created a URL in the WebDev module and I am not able to configure it correctly to populate a table. When I pass the Url in Postman it brings me the information. Using HTTP Binding I'm not getting it. ca… --- ## [Support for CSS declared variables in perspective style classes?](https://forum.inductiveautomation.com/t/support-for-css-declared-variables-in-perspective-style-classes/67116)
**Author:** [@wildbilly](https://forum.inductiveautomation.com/u/wildbilly)\ **Replies:** 6\ **Last updated:** [December 1, 2022, 2:51am UTC](https://forum.inductiveautomation.com/t/support-for-css-declared-variables-in-perspective-style-classes/67116 "2022-12-01T02:51:46Z")
Seems likes perspective styles should support this. It works as component property. Alternatively, if anyone is aware of another way to get a theme supported color like this to work I'd be interested in that as well. Wh… --- ## [Scale Display Issue with Perspective Time Series Chart](https://forum.inductiveautomation.com/t/scale-display-issue-with-perspective-time-series-chart/60521)
**Author:** [@Andrew\_Donelick](https://forum.inductiveautomation.com/u/Andrew_Donelick)\ **Replies:** 1\ **Last updated:** [December 1, 2022, 2:13am UTC](https://forum.inductiveautomation.com/t/scale-display-issue-with-perspective-time-series-chart/60521 "2022-12-01T02:13:22Z")
I’m having a display issue with a Perspective Time Series Chart. The issue occurs with the y-axis scale of the chart. Let’s say I bind values to the min and max value of the axes property, as shown below. Whenever the… --- ## [Perspective Time Series Chart y-axis scale change doesn't redraw](https://forum.inductiveautomation.com/t/perspective-time-series-chart-y-axis-scale-change-doesnt-redraw/43663)
**Author:** [@philip](https://forum.inductiveautomation.com/u/philip)\ **Replies:** 8\ **Last updated:** [December 1, 2022, 1:05am UTC](https://forum.inductiveautomation.com/t/perspective-time-series-chart-y-axis-scale-change-doesnt-redraw/43663 "2022-12-01T01:05:52Z")
If I set a binding on the min and max of an axis on a time series chart or change the min max value via a script, the chart does not update the axis until the mouse is over it. Is there a way to have the chart automatica… --- ## [\[IGN-6880\] How to set Carousel "dot" color via style class?](https://forum.inductiveautomation.com/t/ign-6880-how-to-set-carousel-dot-color-via-style-class/67097)
**Author:** [@ShaneH](https://forum.inductiveautomation.com/u/ShaneH)\ **Replies:** 1\ **Last updated:** [November 30, 2022, 9:06pm UTC](https://forum.inductiveautomation.com/t/ign-6880-how-to-set-carousel-dot-color-via-style-class/67097 "2022-11-30T21:06:56Z")
Perspective 8.1.22 For a Perspective Carousel component: How do you set the Carousel "dot" color via style class? Setting 'fillColor' directly works. But I tried every 'color' field available in the style class, a… --- ## [Perspective Scroll Snap](https://forum.inductiveautomation.com/t/perspective-scroll-snap/67107)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 5\ **Last updated:** [November 30, 2022, 8:45pm UTC](https://forum.inductiveautomation.com/t/perspective-scroll-snap/67107 "2022-11-30T20:45:26Z")
I'm curious to see if anyone has implemented a scroll snap on a perspective flex container session, IE I have row direction flex container that wraps the children when viewed on a phone like device. It would be nice to … --- ## [Nested if statement in expression language](https://forum.inductiveautomation.com/t/nested-if-statement-in-expression-language/67108)
**Author:** [@rahman.tarek](https://forum.inductiveautomation.com/u/rahman.tarek)\ **Replies:** 1\ **Last updated:** [November 30, 2022, 8:16pm UTC](https://forum.inductiveautomation.com/t/nested-if-statement-in-expression-language/67108 "2022-11-30T20:16:23Z")
Hi, I have an expression binding and i want to return 1 if the conditions of 2 tags is how i want it. unfortunately im getting a syntax error. can someone help? --- ## [Template Script Reference Stuck at Original Setting](https://forum.inductiveautomation.com/t/template-script-reference-stuck-at-original-setting/67099)
**Author:** [@Jeremiah\_Brown1](https://forum.inductiveautomation.com/u/Jeremiah_Brown1)\ **Replies:** 4\ **Last updated:** [November 30, 2022, 7:56pm UTC](https://forum.inductiveautomation.com/t/template-script-reference-stuck-at-original-setting/67099 "2022-11-30T19:56:45Z")
Hello, I have a template with a script to launch a popup Window. Originally it was set to open a popup window named Analog Input. However, it has been changed (as can be seen in screenshot) to open a popup window named … --- ## [Change Install Directory After Installation](https://forum.inductiveautomation.com/t/change-install-directory-after-installation/67086)
**Author:** [@jacob.ramirez](https://forum.inductiveautomation.com/u/jacob.ramirez)\ **Replies:** 11\ **Last updated:** [November 30, 2022, 6:36pm UTC](https://forum.inductiveautomation.com/t/change-install-directory-after-installation/67086 "2022-11-30T18:36:01Z")
Is the best way to change the install directory for Ignition to uninstall and install? Change the install directory through the install wizard Or move the Ignition folder? --- ## [Error 500: Error executing function 'OPCSystem.writeValues': The current user does not have the required roles for this operation](https://forum.inductiveautomation.com/t/error-500-error-executing-function-opcsystem-writevalues-the-current-user-does-not-have-the-required-roles-for-this-operation/67095)
**Author:** [@Eric\_G](https://forum.inductiveautomation.com/u/Eric_G)\ **Replies:** 4\ **Last updated:** [November 30, 2022, 5:15pm UTC](https://forum.inductiveautomation.com/t/error-500-error-executing-function-opcsystem-writevalues-the-current-user-does-not-have-the-required-roles-for-this-operation/67095 "2022-11-30T17:15:03Z")
v8.1.19 Script works in designer but not in Vision client. Is this a demo mode issue? Gateway log follows: Traceback (most recent call last): File "\", line 12, in \_\_do\_async File "\ **Author:** [@christopher\_wray](https://forum.inductiveautomation.com/u/christopher_wray)\ **Replies:** 3\ **Last updated:** [November 30, 2022, 5:03pm UTC](https://forum.inductiveautomation.com/t/flex-repeater-and-instances/67094 "2022-11-30T17:03:56Z") I have a bit of an issue, I have a flex repeater, with a query binding. I have a script transform, which has some conditional syntax depending on the conditions. For example test1\_instance.append(test) test2\_instance… --- ## [Micro 820 Daily Totals](https://forum.inductiveautomation.com/t/micro-820-daily-totals/66304)
**Author:** [@kaleb.s](https://forum.inductiveautomation.com/u/kaleb.s)\ **Replies:** 11\ **Last updated:** [November 30, 2022, 4:48pm UTC](https://forum.inductiveautomation.com/t/micro-820-daily-totals/66304 "2022-11-30T16:48:23Z")
Having a weird issue as of yesterday with two of my micro 820's. The daily waterflow totals are no longer updating and the reset didnt occur for the 24hr tag either. No changes were made to either of the micros. All o… --- ## [Status Chart Component Show Data from a Transaction Group](https://forum.inductiveautomation.com/t/status-chart-component-show-data-from-a-transaction-group/67091)
**Author:** [@Carly\_Jankowski](https://forum.inductiveautomation.com/u/Carly_Jankowski)\ **Replies:** 1\ **Last updated:** [November 30, 2022, 4:28pm UTC](https://forum.inductiveautomation.com/t/status-chart-component-show-data-from-a-transaction-group/67091 "2022-11-30T16:28:12Z")
I have an OPC tag that is reading the status of a machine from a PLC. I put this tag in a transaction group so that it will read the status of the tag (from t\_stamp) every 60 seconds. I thought the status chart component… --- ## [Scripting in Tag Expressions](https://forum.inductiveautomation.com/t/scripting-in-tag-expressions/66652)
**Author:** [@steven.rehnborg](https://forum.inductiveautomation.com/u/steven.rehnborg)\ **Replies:** 8\ **Last updated:** [November 30, 2022, 4:23pm UTC](https://forum.inductiveautomation.com/t/scripting-in-tag-expressions/66652 "2022-11-30T16:23:01Z")
Is it possible to run a user defined script in an expression for a tag? I am trying to convert an OPC tag from an integer value in BCD format into an integer value. I have a script that functions in the script console,… --- ## [OPC UA Session Timeout vs Keep-Alive Timeout](https://forum.inductiveautomation.com/t/opc-ua-session-timeout-vs-keep-alive-timeout/67080)
**Author:** [@Davide\_Bortolini](https://forum.inductiveautomation.com/u/Davide_Bortolini)\ **Replies:** 3\ **Last updated:** [November 30, 2022, 3:23pm UTC](https://forum.inductiveautomation.com/t/opc-ua-session-timeout-vs-keep-alive-timeout/67080 "2022-11-30T15:23:13Z")
Good morning, I had an issue with OPC UA communication and I wanted to share with you the details and, perhaps, give an input to improve Ignition OPC UA settings. I was facing this issue while communicating with a Siem… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=738) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=740)