# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=585 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 586 --- ## [Simple RunPrepQuery Issue](https://forum.inductiveautomation.com/t/simple-runprepquery-issue/78180)
**Author:** [@Jaden\_Steinbacher](https://forum.inductiveautomation.com/u/Jaden_Steinbacher)\ **Replies:** 3\ **Last updated:** [August 21, 2023, 8:26pm UTC](https://forum.inductiveautomation.com/t/simple-runprepquery-issue/78180 "2023-08-21T20:26:22Z")
Hi, I am having an issue with a very simple query I am trying to run. I am trying to get all the data from the table by its name. The code is below. query = "SELECT \* FROM ?" s = "DrillPlates" t = system.db.runPrepQue… --- ## [\[BUG-5805\] Perspective chart does not update correctly](https://forum.inductiveautomation.com/t/bug-5805-perspective-chart-does-not-update-correctly/78178)
**Author:** [@dan\_mueller](https://forum.inductiveautomation.com/u/dan_mueller)\ **Replies:** 1\ **Last updated:** [August 21, 2023, 8:18pm UTC](https://forum.inductiveautomation.com/t/bug-5805-perspective-chart-does-not-update-correctly/78178 "2023-08-21T20:18:46Z")
My perspective chart updates erratically when I launch my session. It seems to happen when I am working on different applications and switch back to the session. The sessions that run on the manufacturing floor rarely… --- ## [\[SOLVED\] Connection database](https://forum.inductiveautomation.com/t/solved-connection-database/78176)
**Author:** [@Esmeralda\_Lopez](https://forum.inductiveautomation.com/u/Esmeralda_Lopez)\ **Replies:** 3\ **Last updated:** [August 21, 2023, 7:30pm UTC](https://forum.inductiveautomation.com/t/solved-connection-database/78176 "2023-08-21T19:30:06Z")
Hi, I got this error when I try to lauch a project I am trying to find where I need to change the name of the database because I changed. I took a look in the gateway but have the correct name --- ## [Force Close Startup Script](https://forum.inductiveautomation.com/t/force-close-startup-script/78175)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 5\ **Last updated:** [August 21, 2023, 7:24pm UTC](https://forum.inductiveautomation.com/t/force-close-startup-script/78175 "2023-08-21T19:24:17Z")
I have a startup script that checks for valid IPs in a dataset and closes the application if "access is denied." I've got an error box via system.gui.errorBox() to alert the user, but I want this box to stay on the scree… --- ## [\[SOLVED\] Memory and slow](https://forum.inductiveautomation.com/t/solved-memory-and-slow/78172)
**Author:** [@Esmeralda\_Lopez](https://forum.inductiveautomation.com/u/Esmeralda_Lopez)\ **Replies:** 4\ **Last updated:** [August 21, 2023, 6:05pm UTC](https://forum.inductiveautomation.com/t/solved-memory-and-slow/78172 "2023-08-21T18:05:41Z")
Hello everyone, I have a project but in the gateway says that I am using this memory of 4096, when in the designer launching I have 2048 Does anyone know why this happen? --- ## [Create momentary button using Vision standard button](https://forum.inductiveautomation.com/t/create-momentary-button-using-vision-standard-button/77871)
**Author:** [@michael.black](https://forum.inductiveautomation.com/u/michael.black)\ **Replies:** 41\ **Last updated:** [August 21, 2023, 3:30pm UTC](https://forum.inductiveautomation.com/t/create-momentary-button-using-vision-standard-button/77871 "2023-08-21T15:30:07Z")
I have an existing plc with a reset bit in it. I am creating an equivalent Vision project from an HMI program which uses a momentary button to turn on the reset bit in the plc. The plc doesn't turn the bit off so I hav… --- ## [Where to use system.security.getRoles()](https://forum.inductiveautomation.com/t/where-to-use-system-security-getroles/78158)
**Author:** [@pbg](https://forum.inductiveautomation.com/u/pbg)\ **Replies:** 3\ **Last updated:** [August 21, 2023, 3:10pm UTC](https://forum.inductiveautomation.com/t/where-to-use-system-security-getroles/78158 "2023-08-21T15:10:37Z")
I am hoping to use, if any(role.startswith(security\_prefix) for role in system.security.getRoles()): in a onStartup script but I just get the error, AttributeError: 'com.inductiveautomation.ignition.common.script.Imm'… --- ## [Add or remove the Power Chart props.pens object by script](https://forum.inductiveautomation.com/t/add-or-remove-the-power-chart-props-pens-object-by-script/75498)
**Author:** [@Cristian\_Gomez](https://forum.inductiveautomation.com/u/Cristian_Gomez)\ **Replies:** 2\ **Last updated:** [August 20, 2023, 1:53am UTC](https://forum.inductiveautomation.com/t/add-or-remove-the-power-chart-props-pens-object-by-script/75498 "2023-08-20T01:53:25Z")
Hi everyone I have a question about how is the syntax to execute the action to add or remove the props.pends object in a power chart from the script, I'm programming a button to add a path of history from a table alread… --- ## [Color Change based on the Integer Value in Perspective](https://forum.inductiveautomation.com/t/color-change-based-on-the-integer-value-in-perspective/78150)
**Author:** [@suram-in](https://forum.inductiveautomation.com/u/suram-in)\ **Replies:** 4\ **Last updated:** [August 21, 2023, 2:04pm UTC](https://forum.inductiveautomation.com/t/color-change-based-on-the-integer-value-in-perspective/78150 "2023-08-21T14:04:27Z")
Hi, I would like to change the text color of the Label based on the integer value varies between 0- 100. For Few values I need to flash the color of the text. I already did the same using Vision using style customizer bu… --- ## [Ignition 8.1.30 & Sepasoft Production Model](https://forum.inductiveautomation.com/t/ignition-8-1-30-sepasoft-production-model/78133)
**Author:** [@Soundararajans\_S](https://forum.inductiveautomation.com/u/Soundararajans_S)\ **Replies:** 3\ **Last updated:** [August 21, 2023, 1:19pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-30-sepasoft-production-model/78133 "2023-08-21T13:19:19Z")
Hi, Am installed Ignition Version: 8.1.30 (b2023071408) & Production 3.81.9 (b2023062424), OEE Downtime 3.81.9 (b2023062424). In designer Production module is not showing. How to retrieve the module. --- ## [Ignition Server CPU and Memory Usage](https://forum.inductiveautomation.com/t/ignition-server-cpu-and-memory-usage/78131)
**Author:** [@monc](https://forum.inductiveautomation.com/u/monc)\ **Replies:** 2\ **Last updated:** [August 21, 2023, 12:59pm UTC](https://forum.inductiveautomation.com/t/ignition-server-cpu-and-memory-usage/78131 "2023-08-21T12:59:13Z")
Hello, Is there a way to find what's causing the High CPU and Memory Usage? I only have 1 designer and 1 Perspective instance open, and the CPU and Memory just went up. I'm using Ignition 8.1.18 and I attached a photo… --- ## [Ignition Power Table columnAttributesData not showing](https://forum.inductiveautomation.com/t/ignition-power-table-columnattributesdata-not-showing/78138)
**Author:** [@Tjark\_Sterk](https://forum.inductiveautomation.com/u/Tjark_Sterk)\ **Replies:** 1\ **Last updated:** [August 21, 2023, 12:46pm UTC](https://forum.inductiveautomation.com/t/ignition-power-table-columnattributesdata-not-showing/78138 "2023-08-21T12:46:47Z")
Hey somehow some of my powertables don't have any data I can access in the columnAttributesData property. I access my data trough a query and I did nothing different than I did with my other tables, where I can access t… --- ## [Manually adding items to props.selection.data on Table is being overwritten on first write](https://forum.inductiveautomation.com/t/manually-adding-items-to-props-selection-data-on-table-is-being-overwritten-on-first-write/78147)
**Author:** [@liam1](https://forum.inductiveautomation.com/u/liam1)\ **Replies:** 2\ **Last updated:** [August 21, 2023, 12:34pm UTC](https://forum.inductiveautomation.com/t/manually-adding-items-to-props-selection-data-on-table-is-being-overwritten-on-first-write/78147 "2023-08-21T12:34:33Z")
I am trying in implement a multi-data point selection with a onClick Add and Remove for my table I have noticed , that when trying to add a item to the props.selection.data for the first cycle , the array gets reset b… --- ## [How to use Seaborn library in Python script](https://forum.inductiveautomation.com/t/how-to-use-seaborn-library-in-python-script/78146)
**Author:** [@samer\_samy](https://forum.inductiveautomation.com/u/samer_samy)\ **Replies:** 1\ **Last updated:** [August 21, 2023, 11:41am UTC](https://forum.inductiveautomation.com/t/how-to-use-seaborn-library-in-python-script/78146 "2023-08-21T11:41:08Z")
Hi guys, I am beginner here, I watched video in our fabulous learning portal " inductive university", Talking about using python libraries and as example they imported randint from random library. So can I use seaborn … --- ## [Read/Write/Update Dataset Tag using Sparkplug B](https://forum.inductiveautomation.com/t/read-write-update-dataset-tag-using-sparkplug-b/78022)
**Author:** [@Chad\_Gregory](https://forum.inductiveautomation.com/u/Chad_Gregory)\ **Replies:** 9\ **Last updated:** [August 21, 2023, 11:35am UTC](https://forum.inductiveautomation.com/t/read-write-update-dataset-tag-using-sparkplug-b/78022 "2023-08-21T11:35:56Z")
I am looking to read and write a dataset via sparkplug B. I think I have parsed the spec correctly to generate a sparkplug b payload. Using MQTTX, I am able to parse sparkplug b payload and when I capture the dataset pay… --- ## [Routing path in ignition map component](https://forum.inductiveautomation.com/t/routing-path-in-ignition-map-component/78132)
**Author:** [@darshan\_s](https://forum.inductiveautomation.com/u/darshan_s)\ **Replies:** 0\ **Last updated:** [August 21, 2023, 6:01am UTC](https://forum.inductiveautomation.com/t/routing-path-in-ignition-map-component/78132 "2023-08-21T06:01:42Z")
Hey! IAM trying to route a path between 2 different locations on ignition map component, I AM able to only mark 2 different locations simultaneously, but not able to map the path between those. How do I map it, is ther… --- ## [Ignition Vision : Add multiple names in SQL database](https://forum.inductiveautomation.com/t/ignition-vision-add-multiple-names-in-sql-database/78125)
**Author:** [@Anthony\_Buddini](https://forum.inductiveautomation.com/u/Anthony_Buddini)\ **Replies:** 1\ **Last updated:** [August 21, 2023, 3:59am UTC](https://forum.inductiveautomation.com/t/ignition-vision-add-multiple-names-in-sql-database/78125 "2023-08-21T03:59:10Z")
Hi everyone, I'm trying to add a few customer names, as highlighted in the attached snapshot, using the EDIT function in SQL Database query browser tool. I tried adding them using " , " and also tried inserting "OR" b… --- ## [\[FEATURE\] Add expression function to check if tag is valid (exists and not disabled)](https://forum.inductiveautomation.com/t/feature-add-expression-function-to-check-if-tag-is-valid-exists-and-not-disabled/61192)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 5\ **Last updated:** [August 21, 2023, 3:03am UTC](https://forum.inductiveautomation.com/t/feature-add-expression-function-to-check-if-tag-is-valid-exists-and-not-disabled/61192 "2023-08-21T03:03:44Z")
I should have asked for this a very long time ago to be honest… I would like a function to check if a tag is valid. What I mean by this, is that it both exists and is not disabled. No other qualities should affect the v… --- ## [\[BUG?\] Designer not pulling in themes with multiple dashes in root css filename?](https://forum.inductiveautomation.com/t/bug-designer-not-pulling-in-themes-with-multiple-dashes-in-root-css-filename/78127)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 0\ **Last updated:** [August 21, 2023, 2:41am UTC](https://forum.inductiveautomation.com/t/bug-designer-not-pulling-in-themes-with-multiple-dashes-in-root-css-filename/78127 "2023-08-21T02:41:28Z")
v8.1.30 I created the same extremely basic css files within the root ../themes/ folder, which simply imports the light.css file, one called "test-light.css" and another called "test-asm-light.css". The "test-light" appe… --- ## [Ignition Tag Group: Seeking Expertise](https://forum.inductiveautomation.com/t/ignition-tag-group-seeking-expertise/77973)
**Author:** [@A\_Power](https://forum.inductiveautomation.com/u/A_Power)\ **Replies:** 8\ **Last updated:** [August 21, 2023, 12:42am UTC](https://forum.inductiveautomation.com/t/ignition-tag-group-seeking-expertise/77973 "2023-08-21T00:42:57Z")
I'm reaching out to the community for insights on setting up tag groups in Ignition. Below, I've detailed our journey, the challenges we faced, and the solutions we implemented. I hope this context will help you understa… --- ## [Can a listbox item be highlighted based on a condition?](https://forum.inductiveautomation.com/t/can-a-listbox-item-be-highlighted-based-on-a-condition/77964)
**Author:** [@robertm](https://forum.inductiveautomation.com/u/robertm)\ **Replies:** 6\ **Last updated:** [August 19, 2023, 1:04pm UTC](https://forum.inductiveautomation.com/t/can-a-listbox-item-be-highlighted-based-on-a-condition/77964 "2023-08-19T13:04:16Z")
I have a dropdown list that I use the selected value to populate a 24 hour data table. There are 40 widgets to choose from in the list box. The 24 hour data table values are stored in a PLC. I have a request to highli… --- ## [Tag write to edge gateway fails](https://forum.inductiveautomation.com/t/tag-write-to-edge-gateway-fails/78091)
**Author:** [@Project2501](https://forum.inductiveautomation.com/u/Project2501)\ **Replies:** 3\ **Last updated:** [August 19, 2023, 12:23pm UTC](https://forum.inductiveautomation.com/t/tag-write-to-edge-gateway-fails/78091 "2023-08-19T12:23:35Z")
Edge Gateway serving tags to a central server. I can see all of the tags in a perspective session, can see them from the server's designer. If I try to write to a property from anywhere but the edge gateway designer, th… --- ## [Select all rows in a perspectives table](https://forum.inductiveautomation.com/t/select-all-rows-in-a-perspectives-table/77475)
**Author:** [@bwagner](https://forum.inductiveautomation.com/u/bwagner)\ **Replies:** 8\ **Last updated:** [August 19, 2023, 11:25am UTC](https://forum.inductiveautomation.com/t/select-all-rows-in-a-perspectives-table/77475 "2023-08-19T11:25:10Z")
I have a table that I am using as a schedule to send data to a plc. I would like to be able to have a select all button to select and highlight all the rows in the table so I can iterate through them to send to the plc. … --- ## [Better way to draw trend across multiple vertical slider](https://forum.inductiveautomation.com/t/better-way-to-draw-trend-across-multiple-vertical-slider/78075)
**Author:** [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\ **Replies:** 3\ **Last updated:** [August 19, 2023, 11:01am UTC](https://forum.inductiveautomation.com/t/better-way-to-draw-trend-across-multiple-vertical-slider/78075 "2023-08-19T11:01:59Z")
I am trying to work out a way to visualize a look up table. like the screenshot below, I have a couple of sliders, but I want to link the dots as a chart. Currently I can achieve it by having a XY chart at the back o… --- ## [Apex Chart color the datalabels based on value](https://forum.inductiveautomation.com/t/apex-chart-color-the-datalabels-based-on-value/60792)
**Author:** [@Berkay\_Sahin](https://forum.inductiveautomation.com/u/Berkay_Sahin)\ **Replies:** 1\ **Last updated:** [August 18, 2023, 11:38pm UTC](https://forum.inductiveautomation.com/t/apex-chart-color-the-datalabels-based-on-value/60792 "2023-08-18T23:38:26Z")
Hello, How can I simply change the color of each data labels in Apex Chart based on value? I am looking for something like mentioned here change color of single dataLabel in ApexCharts - Stack Overflow Below I playe… --- ## [Ignition and STIGs](https://forum.inductiveautomation.com/t/ignition-and-stigs/78103)
**Author:** [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Replies:** 1\ **Last updated:** [August 18, 2023, 11:21pm UTC](https://forum.inductiveautomation.com/t/ignition-and-stigs/78103 "2023-08-18T23:21:33Z")
Does anyone have any experience with STIGs, Security Technical Implementation Guides, and Ignition. We are doing a few projects using ignition that require some extensive hardening. Curious what STIGs, if any, apply for … --- ## [Remote Tag Providers - Tags not Found 7.9 to 8.1](https://forum.inductiveautomation.com/t/remote-tag-providers-tags-not-found-7-9-to-8-1/77818)
**Author:** [@jciatti](https://forum.inductiveautomation.com/u/jciatti)\ **Replies:** 1\ **Last updated:** [August 15, 2023, 9:47pm UTC](https://forum.inductiveautomation.com/t/remote-tag-providers-tags-not-found-7-9-to-8-1/77818 "2023-08-15T21:47:33Z")
I have a remote tag provider connection between an 8.1 gateway (which is providing the tags) and a 7.9 gateway (which is consuming the tags). After our upgrade to 8.1.30, it appeared the connection was working, but as o… --- ## [Repaintable canvas to show Cognex camera image](https://forum.inductiveautomation.com/t/repaintable-canvas-to-show-cognex-camera-image/48820)
**Author:** [@tim1](https://forum.inductiveautomation.com/u/tim1)\ **Replies:** 19\ **Last updated:** [August 18, 2023, 9:52pm UTC](https://forum.inductiveautomation.com/t/repaintable-canvas-to-show-cognex-camera-image/48820 "2023-08-18T21:52:07Z")
I am using Ignition version 8.1.3 and a Cognex 7200 camera that does not have HMI view/http capabilities. I’ve scoured the forums for ways to get Ignition to show the most recent picture from the cognex camera. The best… --- ## [Stacked Bar Graph with Non-Numeric X-Axis](https://forum.inductiveautomation.com/t/stacked-bar-graph-with-non-numeric-x-axis/78094)
**Author:** [@hd2023](https://forum.inductiveautomation.com/u/hd2023)\ **Replies:** 3\ **Last updated:** [August 18, 2023, 8:04pm UTC](https://forum.inductiveautomation.com/t/stacked-bar-graph-with-non-numeric-x-axis/78094 "2023-08-18T20:04:33Z")
Hi everyone. I am trying to make a stacked bar chart similar to the one below. I'd like to use the XY Chart and the X-axis labels should be non-numeric (i.e. string values, such as "apple", "banana", etc). So, my da… --- ## [Report issue in Ignition](https://forum.inductiveautomation.com/t/report-issue-in-ignition/77924)
**Author:** [@Surya\_Chandra\_Mohan](https://forum.inductiveautomation.com/u/Surya_Chandra_Mohan)\ **Replies:** 2\ **Last updated:** [August 18, 2023, 7:56pm UTC](https://forum.inductiveautomation.com/t/report-issue-in-ignition/77924 "2023-08-18T19:56:49Z")
Hello, I am trying to convert decimal numbers to whole numbers in a respective column in a Report. Right now the column is showing whole numbers but in the xml format it is showing in decimal format. I tried changing … [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=584) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=586)