# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=333 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 334 --- ## [Choosing columns from query to Populate a bar chart](https://forum.inductiveautomation.com/t/choosing-columns-from-query-to-populate-a-bar-chart/96132)
**Author:** [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\ **Replies:** 4\ **Last updated:** [September 18, 2024, 3:20pm UTC](https://forum.inductiveautomation.com/t/choosing-columns-from-query-to-populate-a-bar-chart/96132 "2024-09-18T15:20:32Z")
Hello! I´ve got a table populated with 4 columns as follow: I want to choose column 2 (NUMERO DE PETICIONES) to be the height of the Bar and column 4 (DESCRIPCION) to be the name of the bar. How can I archieve this?… --- ## [Table Rows not Growing in Flex Container](https://forum.inductiveautomation.com/t/table-rows-not-growing-in-flex-container/96128)
**Author:** [@Joe\_Lockwood1](https://forum.inductiveautomation.com/u/Joe_Lockwood1)\ **Replies:** 2\ **Last updated:** [September 18, 2024, 3:23pm UTC](https://forum.inductiveautomation.com/t/table-rows-not-growing-in-flex-container/96128 "2024-09-18T15:23:21Z")
Question - Is it possible to have a table grow to fit a flex container? I currently have a table in a Flex container (the only object in it). I want the rows to scale based on screen size. I got my desired layout by man… --- ## [Optimization of “pens” deactivation in Easy Chart](https://forum.inductiveautomation.com/t/optimization-of-pens-deactivation-in-easy-chart/96124)
**Author:** [@Miguel\_Cimildoro](https://forum.inductiveautomation.com/u/Miguel_Cimildoro)\ **Replies:** 4\ **Last updated:** [September 18, 2024, 3:03pm UTC](https://forum.inductiveautomation.com/t/optimization-of-pens-deactivation-in-easy-chart/96124 "2024-09-18T15:03:18Z")
Hi all, I am working with an Easy Chart in Ignition and I need to disable (change to False) the “enabled” column of the pens only in the rows between index 76 and 87 when the component is hidden (hidden=True). I tried s… --- ## [Switch Users in Vision](https://forum.inductiveautomation.com/t/switch-users-in-vision/96087)
**Author:** [@Elmer\_Sanchez](https://forum.inductiveautomation.com/u/Elmer_Sanchez)\ **Replies:** 6\ **Last updated:** [September 18, 2024, 2:13pm UTC](https://forum.inductiveautomation.com/t/switch-users-in-vision/96087 "2024-09-18T14:13:04Z")
Hello, I am needing assistance on how to use "System.security.Switchuser" function. I am having no luck on how to switch users within a client. I've used the example in the manual but get an error. " Error executing sc… --- ## [Extend User Properties](https://forum.inductiveautomation.com/t/extend-user-properties/96060)
**Author:** [@Subin\_Adhikari](https://forum.inductiveautomation.com/u/Subin_Adhikari)\ **Replies:** 3\ **Last updated:** [September 18, 2024, 1:56pm UTC](https://forum.inductiveautomation.com/t/extend-user-properties/96060 "2024-09-18T13:56:40Z")
Gurus, What's the best way to extend user and roles property ? One of our clients need Active status on User ( Scheduling don't work in this case ) Being said that i can just trigger the "Lockout" for the user so that… --- ## [Migrating ActiveX Control Functionality to Ignition](https://forum.inductiveautomation.com/t/migrating-activex-control-functionality-to-ignition/96101)
**Author:** [@Jakub\_Bacik](https://forum.inductiveautomation.com/u/Jakub_Bacik)\ **Replies:** 1\ **Last updated:** [September 18, 2024, 1:43pm UTC](https://forum.inductiveautomation.com/t/migrating-activex-control-functionality-to-ignition/96101 "2024-09-18T13:43:16Z")
Hi, I'm facing a challenge with transferring functionality from an ActiveX control used in my current SCADA system (Intouch) to a new version of Ignition, which no longer supports ActiveX. The existing system relies on … --- ## [Why there is a Query Type in named queries?](https://forum.inductiveautomation.com/t/why-there-is-a-query-type-in-named-queries/96110)
**Author:** [@danielps1818](https://forum.inductiveautomation.com/u/danielps1818)\ **Replies:** 2\ **Last updated:** [September 18, 2024, 1:33pm UTC](https://forum.inductiveautomation.com/t/why-there-is-a-query-type-in-named-queries/96110 "2024-09-18T13:33:02Z")
Hello! Asking from the ignorance. Why does exists the Query Type in the named queries? I mean, I understand what does each type, but why not simply delete the query type and make all the queries work always? Any expl… --- ## [after generating password , in ignition --\> security --\> user, roles --\> manage users we unable to see user which is need to be populated. For more information. Please find below screen shot.for more details please find below attached file](https://forum.inductiveautomation.com/t/after-generating-password-in-ignition-security-user-roles-manage-users-we-unable-to-see-user-which-is-need-to-be-populated-for-more-information-please-find-below-screen-shot-for-more-details-please-find-below-attached-file/96125)
**Author:** [@Kaustubh\_Joshi](https://forum.inductiveautomation.com/u/Kaustubh_Joshi)\ **Replies:** 1\ **Last updated:** [September 18, 2024, 1:32pm UTC](https://forum.inductiveautomation.com/t/after-generating-password-in-ignition-security-user-roles-manage-users-we-unable-to-see-user-which-is-need-to-be-populated-for-more-information-please-find-below-screen-shot-for-more-details-please-find-below-attached-file/96125 "2024-09-18T13:32:55Z")
--- ## [Removing blue outline when cell is clicked in a Perspective table](https://forum.inductiveautomation.com/t/removing-blue-outline-when-cell-is-clicked-in-a-perspective-table/49151)
**Author:** [@mdelara](https://forum.inductiveautomation.com/u/mdelara)\ **Replies:** 5\ **Last updated:** [September 18, 2024, 1:23pm UTC](https://forum.inductiveautomation.com/t/removing-blue-outline-when-cell-is-clicked-in-a-perspective-table/49151 "2024-09-18T13:23:57Z")
Hi, is there a way to remove the outline of the cell in a Perspective editable table when it is clicked? I tried outlineStyle = “none” under cell property but it seems to have no effect. The reason I asked is because whe… --- ## [Error accessing InternalJsonStorageInfoRecord, will re-query.deleted = 'false'](https://forum.inductiveautomation.com/t/error-accessing-internaljsonstorageinforecord-will-re-query-deleted-false/94800)
**Author:** [@Rui\_Gao](https://forum.inductiveautomation.com/u/Rui_Gao)\ **Replies:** 1\ **Last updated:** [September 18, 2024, 1:11pm UTC](https://forum.inductiveautomation.com/t/error-accessing-internaljsonstorageinforecord-will-re-query-deleted-false/94800 "2024-09-18T13:11:26Z")
How to solve this problem? wrapper - 副本.log (316.4 KB) --- ## [Problem on the client](https://forum.inductiveautomation.com/t/problem-on-the-client/96122)
**Author:** [@Koussaila\_Fekroune](https://forum.inductiveautomation.com/u/Koussaila_Fekroune)\ **Replies:** 3\ **Last updated:** [September 18, 2024, 12:57pm UTC](https://forum.inductiveautomation.com/t/problem-on-the-client/96122 "2024-09-18T12:57:17Z")
I created a database I managed to have it displayed on the designer in the form of a table but on the client the tables become red or even the attachments --- ## [Update UDT Instance](https://forum.inductiveautomation.com/t/update-udt-instance/96088)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 4\ **Last updated:** [September 18, 2024, 12:54pm UTC](https://forum.inductiveautomation.com/t/update-udt-instance/96088 "2024-09-18T12:54:08Z")
I have a UDT instance that I am using system.tag.readBlocking() to get the entire UDT's contents in JSON format. How would I go about writing back to the UDT instance? Also, no all UDT members will be written to. --- ## [Ignition Redundancy ip address](https://forum.inductiveautomation.com/t/ignition-redundancy-ip-address/96104)
**Author:** [@Adarsh\_K1](https://forum.inductiveautomation.com/u/Adarsh_K1)\ **Replies:** 1\ **Last updated:** [September 18, 2024, 12:33pm UTC](https://forum.inductiveautomation.com/t/ignition-redundancy-ip-address/96104 "2024-09-18T12:33:54Z")
Hi, the project uses Standard Ignition with cloud-hosted redundancy, where the main server is hosted on one VM and the backup on another. If my Perspective clients are connected to the application via the main server, wo… --- ## [SOLVED\_ Chart on Vision Client Vs Charts on Designer](https://forum.inductiveautomation.com/t/solved-chart-on-vision-client-vs-charts-on-designer/96118)
**Author:** [@Saed\_Alhabbashi](https://forum.inductiveautomation.com/u/Saed_Alhabbashi)\ **Replies:** 2\ **Last updated:** [September 18, 2024, 12:20pm UTC](https://forum.inductiveautomation.com/t/solved-chart-on-vision-client-vs-charts-on-designer/96118 "2024-09-18T12:20:51Z")
Hello I am a new to this amazing SCADA, I am still trying the demo one (two hours) I have been trying out the charts, they work super however, when i launched the vision client all readings are fine except charts- see t… --- ## [Date format for query filter](https://forum.inductiveautomation.com/t/date-format-for-query-filter/96105)
**Author:** [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\ **Replies:** 7\ **Last updated:** [September 18, 2024, 10:45am UTC](https://forum.inductiveautomation.com/t/date-format-for-query-filter/96105 "2024-09-18T10:45:00Z")
Hello! A query: SELECT WO.REQUESTER AS SOLICITANTE, COUNT(WO.WORKORDER) AS "NUMERO PETICIONES" FROM WORKORDER WO WHERE WO.COMPANY = 'GESTIONESP' AND TO\_CHAR(WO.WORKREQUESTDATE, 'MM/YYYY') = :startDate AND WO… --- ## [Dateformat from query datetime or string for specific date format](https://forum.inductiveautomation.com/t/dateformat-from-query-datetime-or-string-for-specific-date-format/96112)
**Author:** [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\ **Replies:** 2\ **Last updated:** [September 18, 2024, 10:17am UTC](https://forum.inductiveautomation.com/t/dateformat-from-query-datetime-or-string-for-specific-date-format/96112 "2024-09-18T10:17:19Z")
Hello! I got a query than requires a date with specific date format MM/YYYY SELECT WO.WORKTYPE || ' - ' || WT.WORKTYPENAME AS DESCRIPCION, COUNT(WO.WORKORDER) AS PETICIONES FROM WORKORDER WO INNER JOIN WORKTYPE… --- ## [Updating the Power Tabel Data set value according to the Property tag change](https://forum.inductiveautomation.com/t/updating-the-power-tabel-data-set-value-according-to-the-property-tag-change/95581)
**Author:** [@Adarsh\_Shelar](https://forum.inductiveautomation.com/u/Adarsh_Shelar)\ **Replies:** 8\ **Last updated:** [September 18, 2024, 6:17am UTC](https://forum.inductiveautomation.com/t/updating-the-power-tabel-data-set-value-according-to-the-property-tag-change/95581 "2024-09-18T06:17:09Z")
Hi Team, So, in my current Project I have used one Power table based on the Property change need to update the Value in the Row data set of power table, just need the idea on what is the script format we are using for t… --- ## [Query not reporting correctly](https://forum.inductiveautomation.com/t/query-not-reporting-correctly/96089)
**Author:** [@thomas\_wallace](https://forum.inductiveautomation.com/u/thomas_wallace)\ **Replies:** 2\ **Last updated:** [September 17, 2024, 8:15pm UTC](https://forum.inductiveautomation.com/t/query-not-reporting-correctly/96089 "2024-09-17T20:15:49Z")
Having an issue with my chart not reporting correctly. My query I have OPC\_Item being divided by 60000. It shows the correct data when running a test in the query. When I use the query for my chart it shows up as not … --- ## [Perspective: How can I reorder array elements \*\*and maintain bindings\*\*?](https://forum.inductiveautomation.com/t/perspective-how-can-i-reorder-array-elements-and-maintain-bindings/40011)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 18\ **Last updated:** [September 17, 2024, 7:49pm UTC](https://forum.inductiveautomation.com/t/perspective-how-can-i-reorder-array-elements-and-maintain-bindings/40011 "2024-09-17T19:49:14Z")
v8.1.0rc1 Is there any way to rearrange property array elements and still keep the bindings intact within each array element’s objects? The only way I know of to rearrange elements is by copy/paste to text editor, rearr… --- ## [OPC UA Device Connected, but doesn't show in tag browser](https://forum.inductiveautomation.com/t/opc-ua-device-connected-but-doesnt-show-in-tag-browser/96076)
**Author:** [@ster](https://forum.inductiveautomation.com/u/ster)\ **Replies:** 3\ **Last updated:** [September 17, 2024, 7:37pm UTC](https://forum.inductiveautomation.com/t/opc-ua-device-connected-but-doesnt-show-in-tag-browser/96076 "2024-09-17T19:37:29Z")
Any idea why I have a successfully connected OPC UA device (Micro 800), but the device won't show in the tag browser? I also have a Matrikon OPC server as a separate connection that shows fine. --- ## [Read UDT Instance vs Read Members](https://forum.inductiveautomation.com/t/read-udt-instance-vs-read-members/96074)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 12\ **Last updated:** [September 17, 2024, 6:30pm UTC](https://forum.inductiveautomation.com/t/read-udt-instance-vs-read-members/96074 "2024-09-17T18:30:36Z")
I have a UDT definition with 19 members. I need to read 3 of them. Wondering if it's more efficient to read the 3 I need or if I should read the entire UDT and extract from the dictionary. Or, what's best practice? Cod… --- ## [Using a polling refresh rate from a session custom property](https://forum.inductiveautomation.com/t/using-a-polling-refresh-rate-from-a-session-custom-property/95805)
**Author:** [@Zach\_Larson](https://forum.inductiveautomation.com/u/Zach_Larson)\ **Replies:** 6\ **Last updated:** [September 17, 2024, 6:08pm UTC](https://forum.inductiveautomation.com/t/using-a-polling-refresh-rate-from-a-session-custom-property/95805 "2024-09-17T18:08:41Z")
If a gateway is using a session custom property of 600 in the polling by seconds, and multiple sessions are open, will they all be polling at the same time, or staggered by the amount that each opened initially? I thoug… --- ## [Websocket Disconnected Because DataFrame/Message Too Large with Perspective](https://forum.inductiveautomation.com/t/websocket-disconnected-because-dataframe-message-too-large-with-perspective/67391)
**Author:** [@tmahaf](https://forum.inductiveautomation.com/u/tmahaf)\ **Replies:** 6\ **Last updated:** [September 17, 2024, 1:06am UTC](https://forum.inductiveautomation.com/t/websocket-disconnected-because-dataframe-message-too-large-with-perspective/67391 "2024-09-17T01:06:04Z")
Hello, I am receiving this error in the logs - Websocket connection closed unexpectedly. code=1009, reason=Resulting message size \[2102265\] is too large for configured max of \[2097152\], codeMeaning=Message Too Big, … --- ## [Ignition Tag Import Error](https://forum.inductiveautomation.com/t/ignition-tag-import-error/96078)
**Author:** [@Harpreet\_Chauhan](https://forum.inductiveautomation.com/u/Harpreet_Chauhan)\ **Replies:** 0\ **Last updated:** [September 17, 2024, 4:27pm UTC](https://forum.inductiveautomation.com/t/ignition-tag-import-error/96078 "2024-09-17T16:27:42Z")
I imported tags from the json files and all of my tags have errors configuration in the parameters of the UDTs. How do I get rid of the errors and get the parameters working? --- ## [Script executed after system.nav.swapWindow](https://forum.inductiveautomation.com/t/script-executed-after-system-nav-swapwindow/96069)
**Author:** [@Stephane\_Boneff](https://forum.inductiveautomation.com/u/Stephane_Boneff)\ **Replies:** 2\ **Last updated:** [September 17, 2024, 4:02pm UTC](https://forum.inductiveautomation.com/t/script-executed-after-system-nav-swapwindow/96069 "2024-09-17T16:02:25Z")
Hello, After upgrade to 8.1.39, an App I didn't wrotten but I maintain has a strange behavior : On only one view, system.nav.swapWindow(xxx) displays the good view but the script on the from view is still executed. Th… --- ## [SFC Scripting - Turning On Light When Mode Activated](https://forum.inductiveautomation.com/t/sfc-scripting-turning-on-light-when-mode-activated/96071)
**Author:** [@James\_Capobianco](https://forum.inductiveautomation.com/u/James_Capobianco)\ **Replies:** 0\ **Last updated:** [September 17, 2024, 3:43pm UTC](https://forum.inductiveautomation.com/t/sfc-scripting-turning-on-light-when-mode-activated/96071 "2024-09-17T15:43:46Z")
Hey there, I'm having difficulty figuring out Scripting for simple tasks in SFC Ignition Designer. My task is to "activate a light, when a Maintenance Mode is Enabled." So I'm trying to understand how I assign Transitio… --- ## [History binding returns unwanted data point](https://forum.inductiveautomation.com/t/history-binding-returns-unwanted-data-point/96054)
**Author:** [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Replies:** 4\ **Last updated:** [September 17, 2024, 2:46pm UTC](https://forum.inductiveautomation.com/t/history-binding-returns-unwanted-data-point/96054 "2024-09-17T14:46:41Z")
Hello folks, I have a timeseries chart with a tag history binding, set up like this: The start and end date come from date pickers, configured to use 2023/12/01 and 2023/12/31 as defaults, because the sample data I h… --- ## [IIoT gateway and Ignition gateway](https://forum.inductiveautomation.com/t/iiot-gateway-and-ignition-gateway/95929)
**Author:** [@MOHAMED\_MANSOUR](https://forum.inductiveautomation.com/u/MOHAMED_MANSOUR)\ **Replies:** 7\ **Last updated:** [September 17, 2024, 2:35pm UTC](https://forum.inductiveautomation.com/t/iiot-gateway-and-ignition-gateway/95929 "2024-09-17T14:35:13Z")
my project setup is as follows: PLC \> IIoT Gateway \> OPC UA \> Ignition gateway \> Perspective. the IIoT gateway and Ignition gateway are on different networks. The IIoT acts as OPC UA server sending all data tags to ign… --- ## [Access Multiple Scripting Library Variables from Script](https://forum.inductiveautomation.com/t/access-multiple-scripting-library-variables-from-script/96063)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 2\ **Last updated:** [September 17, 2024, 2:33pm UTC](https://forum.inductiveautomation.com/t/access-multiple-scripting-library-variables-from-script/96063 "2024-09-17T14:33:58Z")
I have more than 10 different string variables defined in a scripting project library. Of course, I can access them individually via library.varName, but if I'm access 10 of them within the same script that gets annoying… --- ## [Docked view background not taking colour specified in stylesheet](https://forum.inductiveautomation.com/t/docked-view-background-not-taking-colour-specified-in-stylesheet/96059)
**Author:** [@IAKC](https://forum.inductiveautomation.com/u/IAKC)\ **Replies:** 1\ **Last updated:** [September 17, 2024, 2:33pm UTC](https://forum.inductiveautomation.com/t/docked-view-background-not-taking-colour-specified-in-stylesheet/96059 "2024-09-17T14:33:58Z")
I have specified the background colour in stylesheet as shown below. The variable is specified in a custom .css file. I have imported into light and dark theme. in the designer the colour is showing up correctly. .ia\_co… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=332) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=334)