# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=941 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 942 --- ## [Active alarms from remote alarm Journal](https://forum.inductiveautomation.com/t/active-alarms-from-remote-alarm-journal/52293)
**Author:** [@louagejasper](https://forum.inductiveautomation.com/u/louagejasper)\ **Replies:** 1\ **Last updated:** [October 27, 2021, 8:11pm UTC](https://forum.inductiveautomation.com/t/active-alarms-from-remote-alarm-journal/52293 "2021-10-27T20:11:06Z")
We have one central gateway, and multiple remote gateways on each site for machine connectivity. On the central gateway, we are building screens to view data from the entire enterprise. On the central gateway, the goal … --- ## [Script window key shortcut combos](https://forum.inductiveautomation.com/t/script-window-key-shortcut-combos/52413)
**Author:** [@sanchit.sahay](https://forum.inductiveautomation.com/u/sanchit.sahay)\ **Replies:** 4\ **Last updated:** [October 27, 2021, 7:53pm UTC](https://forum.inductiveautomation.com/t/script-window-key-shortcut-combos/52413 "2021-10-27T19:53:40Z")
I am not sure how to create a Title for this issue, so hoping you go through the description and get it I need to use windows shortcuts, and link them to scripts. I need to have a button which when pressed acts as a sa… --- ## [Block Transaction Group Name Property doesn't return Name](https://forum.inductiveautomation.com/t/block-transaction-group-name-property-doesnt-return-name/52418)
**Author:** [@JLCTME](https://forum.inductiveautomation.com/u/JLCTME)\ **Replies:** 0\ **Last updated:** [October 27, 2021, 7:42pm UTC](https://forum.inductiveautomation.com/t/block-transaction-group-name-property-doesnt-return-name/52418 "2021-10-27T19:42:30Z")
I’m trying to create a Block Transaction Group with tag.value and the tag.name in the table. I brought in the same tag twice and set the data type for the first instance to Value (float) and the second to Name (string). … --- ## [Text field visible/invisible based on dropdown value](https://forum.inductiveautomation.com/t/text-field-visible-invisible-based-on-dropdown-value/52416)
**Author:** [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\ **Replies:** 2\ **Last updated:** [October 27, 2021, 7:22pm UTC](https://forum.inductiveautomation.com/t/text-field-visible-invisible-based-on-dropdown-value/52416 "2021-10-27T19:22:05Z")
I’m trying to make a text field visible/invisible when my dropdown selector is either 1 or 3. {Root Container.Dropdown.selectedValue} = 1 || 3 I’m sure I’m missing something in the syntax can anyone help? Thanks --- ## [Vertical Table in Perspective](https://forum.inductiveautomation.com/t/vertical-table-in-perspective/52396)
**Author:** [@williann.tx](https://forum.inductiveautomation.com/u/williann.tx)\ **Replies:** 6\ **Last updated:** [October 27, 2021, 7:06pm UTC](https://forum.inductiveautomation.com/t/vertical-table-in-perspective/52396 "2021-10-27T19:06:13Z")
Is it possible to have a vertical table with heading in a column? It would only be 2 columns: Header and data. Or any suggestions? Thanks in advance! -W --- ## [XY Chart Default Color Scheme](https://forum.inductiveautomation.com/t/xy-chart-default-color-scheme/52414)
**Author:** [@nicholas.robinson](https://forum.inductiveautomation.com/u/nicholas.robinson)\ **Replies:** 0\ **Last updated:** [October 27, 2021, 6:38pm UTC](https://forum.inductiveautomation.com/t/xy-chart-default-color-scheme/52414 "2021-10-27T18:38:43Z")
The time series chart in perspective has a really convenient property like this: The XY chart on the other hand seems not to and the default color scheme gets a bit loud for my taste once it moves into the realm of pi… --- ## [Table Binding Query Error Exception](https://forum.inductiveautomation.com/t/table-binding-query-error-exception/52407)
**Author:** [@MontyP](https://forum.inductiveautomation.com/u/MontyP)\ **Replies:** 2\ **Last updated:** [October 27, 2021, 5:38pm UTC](https://forum.inductiveautomation.com/t/table-binding-query-error-exception/52407 "2021-10-27T17:38:48Z")
I have an existing named query (MyQuery) that is successfully set up and outputting 2 rows and 16 columns when I test it in the named query testing area. I then go to view, add a table component, bind the data, and go to… --- ## [Custom Named Colors in Vision?](https://forum.inductiveautomation.com/t/custom-named-colors-in-vision/52404)
**Author:** [@batkinson](https://forum.inductiveautomation.com/u/batkinson)\ **Replies:** 5\ **Last updated:** [October 27, 2021, 4:50pm UTC](https://forum.inductiveautomation.com/t/custom-named-colors-in-vision/52404 "2021-10-27T16:50:45Z")
I may not be looking with the right search terms, but I’m having a hard time finding the best practice for storing a set of custom colors by name to be able to use them project wide across my vision screens. How can I b… --- ## [Creating table to display Arrays from OPC tags](https://forum.inductiveautomation.com/t/creating-table-to-display-arrays-from-opc-tags/52402)
**Author:** [@Eddie\_Earle](https://forum.inductiveautomation.com/u/Eddie_Earle)\ **Replies:** 9\ **Last updated:** [October 27, 2021, 4:14pm UTC](https://forum.inductiveautomation.com/t/creating-table-to-display-arrays-from-opc-tags/52402 "2021-10-27T16:14:46Z")
Hi, I’m using Ignition 8.1.10 to display OEE metrics from an OPC based machine, however one of the parameters I would like to get off it is an array that keeps causing errors when trying to convert the data. I can see … --- ## [Finding Phantom Query](https://forum.inductiveautomation.com/t/finding-phantom-query/52398)
**Author:** [@bschiv](https://forum.inductiveautomation.com/u/bschiv)\ **Replies:** 2\ **Last updated:** [October 27, 2021, 3:25pm UTC](https://forum.inductiveautomation.com/t/finding-phantom-query/52398 "2021-10-27T15:25:04Z")
I have a project that has been deployed at a customer. Recently I visited to check on things, and the Log showed that a number of database queries were timing out. There is likely more than one issue here, but one thing … --- ## [Name Query Datetime](https://forum.inductiveautomation.com/t/name-query-datetime/52354)
**Author:** [@Kfoldesi](https://forum.inductiveautomation.com/u/Kfoldesi)\ **Replies:** 3\ **Last updated:** [October 27, 2021, 1:47pm UTC](https://forum.inductiveautomation.com/t/name-query-datetime/52354 "2021-10-27T13:47:15Z")
The times are getting changed when stored to MS SQL. I’m reading a time stamp out of a Siemens PLC (array of bytes). And converting it with datetime.datetime import datetime logger = system.util.getLogger("MyLogger")… --- ## [How do I use the Input, Output, Input/Output options on perspective's view params?](https://forum.inductiveautomation.com/t/how-do-i-use-the-input-output-input-output-options-on-perspectives-view-params/24489)
**Author:** [@jfryar](https://forum.inductiveautomation.com/u/jfryar)\ **Replies:** 16\ **Last updated:** [October 27, 2021, 2:21pm UTC](https://forum.inductiveautomation.com/t/how-do-i-use-the-input-output-input-output-options-on-perspectives-view-params/24489 "2021-10-27T14:21:57Z")
I am attempting to create a confirmation dialogue in perspective. I need it to popup, ask the user if they are certain they want to take this action, and then give them the option to say yes or no. I am uncertain how I c… --- ## [Dataset to CSV without quotes](https://forum.inductiveautomation.com/t/dataset-to-csv-without-quotes/52381)
**Author:** [@andreas](https://forum.inductiveautomation.com/u/andreas)\ **Replies:** 5\ **Last updated:** [October 27, 2021, 1:35pm UTC](https://forum.inductiveautomation.com/t/dataset-to-csv-without-quotes/52381 "2021-10-27T13:35:32Z")
Hi all :slightly\_smiling\_face: We are running a query against a table in our database, and it returns a dataset with two columns ( name , value ). The dataset is converted to a CSV by: csv = system.dataset.toCSV(ds,1)… --- ## [Container for UDTS](https://forum.inductiveautomation.com/t/container-for-udts/52364)
**Author:** [@mojoeswa](https://forum.inductiveautomation.com/u/mojoeswa)\ **Replies:** 5\ **Last updated:** [October 27, 2021, 1:06pm UTC](https://forum.inductiveautomation.com/t/container-for-udts/52364 "2021-10-27T13:06:16Z")
What is the best practice for choosing containers for udts? For example, I have tried to use coordinate container for a motor, but when I change the resolution I get scrollbars (The engine is an embedded view in a P&ID s… --- ## [Dropdown text color property?](https://forum.inductiveautomation.com/t/dropdown-text-color-property/52367)
**Author:** [@agriner](https://forum.inductiveautomation.com/u/agriner)\ **Replies:** 4\ **Last updated:** [October 27, 2021, 12:07pm UTC](https://forum.inductiveautomation.com/t/dropdown-text-color-property/52367 "2021-10-27T12:07:49Z")
Is there a way to change the color property on a Dropdown component’s text? Changing the font and boldening the text works fine but actually changing the color doesn’t seem to work. --- ## [Call project library script to vision page with timer](https://forum.inductiveautomation.com/t/call-project-library-script-to-vision-page-with-timer/52382)
**Author:** [@batuhan.parlakay](https://forum.inductiveautomation.com/u/batuhan.parlakay)\ **Replies:** 1\ **Last updated:** [October 27, 2021, 11:49am UTC](https://forum.inductiveautomation.com/t/call-project-library-script-to-vision-page-with-timer/52382 "2021-10-27T11:49:29Z")
Hi, There is error-free code running in the project library script . I want to run this every 5 seconds. What parameters should I use even if it is done in the timer part? what should i do for this ? Thank you. --- ## [Read tag value everyhour](https://forum.inductiveautomation.com/t/read-tag-value-everyhour/52387)
**Author:** [@vani161998](https://forum.inductiveautomation.com/u/vani161998)\ **Replies:** 1\ **Last updated:** [October 27, 2021, 11:00am UTC](https://forum.inductiveautomation.com/t/read-tag-value-everyhour/52387 "2021-10-27T11:00:48Z")
hi, i need to read a tag value every hour through scripting .how can i do this? --- ## [\[BUG\] Tag Browse Tree component doesn't respect font setting](https://forum.inductiveautomation.com/t/bug-tag-browse-tree-component-doesnt-respect-font-setting/52269)
**Author:** [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Replies:** 3\ **Last updated:** [October 27, 2021, 5:32am UTC](https://forum.inductiveautomation.com/t/bug-tag-browse-tree-component-doesnt-respect-font-setting/52269 "2021-10-27T05:32:14Z")
I just found out, that the Tag Browse Tree component in Vision, v8.1.11 doesn’t respect font settings: It doesn’t matter what you set the font to, it will not change. It always stays, I think, on Dialog, Plan, 12. --- ## [Project Properties - Permissions role has error](https://forum.inductiveautomation.com/t/project-properties-permissions-role-has-error/52376)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 1\ **Last updated:** [October 27, 2021, 4:46am UTC](https://forum.inductiveautomation.com/t/project-properties-permissions-role-has-error/52376 "2021-10-27T04:46:24Z")
Is this something I need to do to get new roles recognised in order to use them in the project properties? I created a new dummy role to test with ‘PROJ’ which I can see in the list of roles using alt+space, but when I … --- ## [TIP - Converting a dataset column into a list](https://forum.inductiveautomation.com/t/tip-converting-a-dataset-column-into-a-list/38388)
**Author:** [@kgamble](https://forum.inductiveautomation.com/u/kgamble)\ **Replies:** 24\ **Last updated:** [October 26, 2021, 11:42pm UTC](https://forum.inductiveautomation.com/t/tip-converting-a-dataset-column-into-a-list/38388 "2021-10-26T23:42:33Z")
Something that I have done a ton, is query a list of values from a database, and then convert them into a list for some form of manipulation. Maybe I need to generate a list of users, equipment, or really anything. I ha… --- ## [Add whitespace to property/dataset output / Label wrap with no whitespace](https://forum.inductiveautomation.com/t/add-whitespace-to-property-dataset-output-label-wrap-with-no-whitespace/52373)
**Author:** [@csanyia](https://forum.inductiveautomation.com/u/csanyia)\ **Replies:** 0\ **Last updated:** [October 26, 2021, 11:47pm UTC](https://forum.inductiveautomation.com/t/add-whitespace-to-property-dataset-output-label-wrap-with-no-whitespace/52373 "2021-10-26T23:47:43Z")
Ignition 8, Vision: I have TAG#'s in a dataset or a string property that I need to be displayed w/ a whitespace in the middle. The tag is 8-10 chars long and I need a white space in the middle. Is there an easy way to d… --- ## [Add image ar Report from button](https://forum.inductiveautomation.com/t/add-image-ar-report-from-button/52371)
**Author:** [@juan.romero\_peralta](https://forum.inductiveautomation.com/u/juan.romero_peralta)\ **Replies:** 1\ **Last updated:** [October 26, 2021, 11:07pm UTC](https://forum.inductiveautomation.com/t/add-image-ar-report-from-button/52371 "2021-10-26T23:07:49Z")
I am working with: reportBytes = system.report.executeReport (path = “Reporte\_Alarma”, project = “SATTR”, parameters = overrides, fileType = “pdf”) In the parameters I want to add an address of an image (.jpg or .png) a… --- ## [System.alarm.shelve throwing an error](https://forum.inductiveautomation.com/t/system-alarm-shelve-throwing-an-error/52279)
**Author:** [@nathan1](https://forum.inductiveautomation.com/u/nathan1)\ **Replies:** 9\ **Last updated:** [October 26, 2021, 1:55pm UTC](https://forum.inductiveautomation.com/t/system-alarm-shelve-throwing-an-error/52279 "2021-10-26T13:55:48Z")
Hello. I'm trying to shelve an alarm via script and getting this error: interface.GatewayException: element cannot be mapped to a null key The documentation on the alarm path is very sparse but I assume it is just th… --- ## [Postgres db and jsonb datatypes with Ignition and Python Scripting](https://forum.inductiveautomation.com/t/postgres-db-and-jsonb-datatypes-with-ignition-and-python-scripting/52356)
**Author:** [@tmahaffey](https://forum.inductiveautomation.com/u/tmahaffey)\ **Replies:** 1\ **Last updated:** [October 26, 2021, 8:11pm UTC](https://forum.inductiveautomation.com/t/postgres-db-and-jsonb-datatypes-with-ignition-and-python-scripting/52356 "2021-10-26T20:11:41Z")
Has anyone gotten this to work? I have a python dictionary that I want to insert into a sql table that has a column of datatype jsonb, but I can't convert the dictionary to the right datatype to get the system.db.runPrep… --- ## [Use of parameters in report queries](https://forum.inductiveautomation.com/t/use-of-parameters-in-report-queries/52362)
**Author:** [@Footuck](https://forum.inductiveautomation.com/u/Footuck)\ **Replies:** 2\ **Last updated:** [October 26, 2021, 7:55pm UTC](https://forum.inductiveautomation.com/t/use-of-parameters-in-report-queries/52362 "2021-10-26T19:55:22Z")
When attempting to use a runtime parameter in a Perspective report, I’m expecting to be asked to provide a parameter value when I run the report, but I’m not. I have created the parameter in the report Data tab and give… --- ## [Missing details in error/warning messages in Gateway Log after upgrading from 8.0.16 to 8.1.10](https://forum.inductiveautomation.com/t/missing-details-in-error-warning-messages-in-gateway-log-after-upgrading-from-8-0-16-to-8-1-10/52360)
**Author:** [@MikeAllgood](https://forum.inductiveautomation.com/u/MikeAllgood)\ **Replies:** 3\ **Last updated:** [October 26, 2021, 7:41pm UTC](https://forum.inductiveautomation.com/t/missing-details-in-error-warning-messages-in-gateway-log-after-upgrading-from-8-0-16-to-8-1-10/52360 "2021-10-26T19:41:12Z")
We just upgraded a client to 8.1.10 from 8.0.16. The system uses a lot of scripting so we have Views that call Project Library script function (which call others…). I’ve noticed that when there is an error (e.t. due to … --- ## [Device Simulator Square Wave](https://forum.inductiveautomation.com/t/device-simulator-square-wave/52361)
**Author:** [@awaege1](https://forum.inductiveautomation.com/u/awaege1)\ **Replies:** 0\ **Last updated:** [October 26, 2021, 7:07pm UTC](https://forum.inductiveautomation.com/t/device-simulator-square-wave/52361 "2021-10-26T19:07:53Z")
I am having issues with the device simulator square wave generator. I currently have a time-step of 10000 ms. The Square wave function looks like this: square(0.0,1.0,0.1,true) Based off what I read in the manual I wou… --- ## [ReportViewer Unexpected Server Response](https://forum.inductiveautomation.com/t/reportviewer-unexpected-server-response/52253)
**Author:** [@jason.myers](https://forum.inductiveautomation.com/u/jason.myers)\ **Replies:** 7\ **Last updated:** [October 26, 2021, 7:05pm UTC](https://forum.inductiveautomation.com/t/reportviewer-unexpected-server-response/52253 "2021-10-26T19:05:20Z")
I have created a new report. I created a new view in Perspective and dropped a ReportViewer on it and set the “source” property to the path of the new report (by “copy path” in context menu). When attempting to display i… --- ## [\[FEATURE-2155\] SAML IDP Entity ID Setting](https://forum.inductiveautomation.com/t/feature-2155-saml-idp-entity-id-setting/46999)
**Author:** [@nicholas.robinson](https://forum.inductiveautomation.com/u/nicholas.robinson)\ **Replies:** 15\ **Last updated:** [October 26, 2021, 6:19pm UTC](https://forum.inductiveautomation.com/t/feature-2155-saml-idp-entity-id-setting/46999 "2021-10-26T18:19:44Z")
@jspecht is there a way we can manually specify IDP entity ID? Now this is automatically picked up as the gateway DNS but in order to manage a large number of instances from one single IDP federation, we need to be able… --- ## [XtraceLabel position and background color](https://forum.inductiveautomation.com/t/xtracelabel-position-and-background-color/52359)
**Author:** [@user53](https://forum.inductiveautomation.com/u/user53)\ **Replies:** 0\ **Last updated:** [October 26, 2021, 6:08pm UTC](https://forum.inductiveautomation.com/t/xtracelabel-position-and-background-color/52359 "2021-10-26T18:08:40Z")
Hello, I would like to customize the labels to make the values more visible. I want to change the position of the box value or the color background. I looked through the documentation but there was no example of code. … [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=940) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=942)