# Ignition

**URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=434

[Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md)

**Page:** 435

---

## [On Call Roster Calculated script](https://forum.inductiveautomation.com/t/on-call-roster-calculated-script/89024)

<div class="topic-metadata">

**Author:** [@Alagumani\_Kaliyaperu](https://forum.inductiveautomation.com/u/Alagumani_Kaliyaperu)\
**Replies:** 10\
**Last updated:** [April 21, 2024, 8:18am UTC](https://forum.inductiveautomation.com/t/on-call-roster-calculated-script/89024 "2024-04-21T08:18:13Z")

</div>

Hi, I'm working on dynamic on call roster, I try to take the alarm display path to my 'Calculated' script and try to extract the my 'area number' from the display path message. I tried some scripts but that's not help to…

---

## [Dropdown menu save in Power Table](https://forum.inductiveautomation.com/t/dropdown-menu-save-in-power-table/88822)

<div class="topic-metadata">

**Author:** [@Mia\_Galatis](https://forum.inductiveautomation.com/u/Mia_Galatis)\
**Replies:** 3\
**Last updated:** [April 21, 2024, 5:00am UTC](https://forum.inductiveautomation.com/t/dropdown-menu-save-in-power-table/88822 "2024-04-21T05:00:54Z")

</div>

I have three dropdown options and I want the value that is selected to be displayed in a power table. All are 'yes' and 'no' options. For example, if the user selects 'No' I would like it to show 'No' on the correct colu…

---

## [Query tag and parameters](https://forum.inductiveautomation.com/t/query-tag-and-parameters/85496)

<div class="topic-metadata">

**Author:** [@italogustavoaraujo](https://forum.inductiveautomation.com/u/italogustavoaraujo)\
**Replies:** 1\
**Last updated:** [April 21, 2024, 4:47am UTC](https://forum.inductiveautomation.com/t/query-tag-and-parameters/85496 "2024-04-21T04:47:35Z")

</div>

Hey guys! Can you tell me if it is possible to pass a tag as a parameter in a Query Tag? I have a list of products in the DB and I needed to historicize the name instead of the code, to cross-reference some informati…

---

## [NamedQuery help](https://forum.inductiveautomation.com/t/namedquery-help/89138)

<div class="topic-metadata">

**Author:** [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\
**Replies:** 4\
**Last updated:** [April 21, 2024, 12:36am UTC](https://forum.inductiveautomation.com/t/namedquery-help/89138 "2024-04-21T00:36:35Z")

</div>

Good day, I have this named query: SELECT TOP (1) \* FROM Buggy\_Corral\_Contents WHERE Lot\_Num LIKE :LotLabel1 OR Lot\_Num LIKE :LotLabel2 OR Lot\_Num LIKE :LotLabel3 OR Lot\_Num LIKE :LotLabel4…

---

## [How to Implement Ignition Redundancy with PostgreSQL Database on the Same Server](https://forum.inductiveautomation.com/t/how-to-implement-ignition-redundancy-with-postgresql-database-on-the-same-server/80908)

<div class="topic-metadata">

**Author:** [@tyler.bennett](https://forum.inductiveautomation.com/u/tyler.bennett)\
**Replies:** 8\
**Last updated:** [April 20, 2024, 6:37pm UTC](https://forum.inductiveautomation.com/t/how-to-implement-ignition-redundancy-with-postgresql-database-on-the-same-server/80908 "2024-04-20T18:37:06Z")

</div>

I am planning implementation of Ignition redundancy on an existing system that has the Ignition Gateway and a PostgreSQL historical database on the same server hardware (co-located). The database connection string Ignit…

---

## [Table Data Translation](https://forum.inductiveautomation.com/t/table-data-translation/89148)

<div class="topic-metadata">

**Author:** [@Sayantan\_Chatterjee](https://forum.inductiveautomation.com/u/Sayantan_Chatterjee)\
**Replies:** 2\
**Last updated:** [April 20, 2024, 6:10pm UTC](https://forum.inductiveautomation.com/t/table-data-translation/89148 "2024-04-20T18:10:08Z")

</div>

Hello Everyone, I am working in a global project, that needs the language translation. I am able to translate button, popups and table headers but not the table data. Please suggest how could I translate the table dat…

---

## [Designer launcher doesn't open](https://forum.inductiveautomation.com/t/designer-launcher-doesnt-open/52549)

<div class="topic-metadata">

**Author:** [@Ahmed\_Elsayed](https://forum.inductiveautomation.com/u/Ahmed_Elsayed)\
**Replies:** 11\
**Last updated:** [April 20, 2024, 12:44pm UTC](https://forum.inductiveautomation.com/t/designer-launcher-doesnt-open/52549 "2024-04-20T12:44:06Z")

</div>

Designer launcher doesn’t open , it keeps doing that

---

## [PowerChart timeAxis Grid Missing](https://forum.inductiveautomation.com/t/powerchart-timeaxis-grid-missing/89076)

<div class="topic-metadata">

**Author:** [@tecnoeletronic](https://forum.inductiveautomation.com/u/tecnoeletronic)\
**Replies:** 1\
**Last updated:** [April 20, 2024, 9:18am UTC](https://forum.inductiveautomation.com/t/powerchart-timeaxis-grid-missing/89076 "2024-04-20T09:18:27Z")

</div>

Hi, in a powerChart i enabled the timeAxis.grid: The chart show the grid correctly: But when i add a pen (or more) the grid disappear: Why? How to avoid this?

---

## [How to change colors of a dropdown box](https://forum.inductiveautomation.com/t/how-to-change-colors-of-a-dropdown-box/89110)

<div class="topic-metadata">

**Author:** [@matt\_Kerg](https://forum.inductiveautomation.com/u/matt_Kerg)\
**Replies:** 2\
**Last updated:** [April 19, 2024, 6:04pm UTC](https://forum.inductiveautomation.com/t/how-to-change-colors-of-a-dropdown-box/89110 "2024-04-19T18:04:24Z")

</div>

I have tried just about all the elements in the style menu and can modify the background etc but I can not change the dark and light blue default selection and hover in the dropdown box itself. Any help would be appre…

---

## [Perspective XY Chart - Get Selected Range](https://forum.inductiveautomation.com/t/perspective-xy-chart-get-selected-range/64870)

<div class="topic-metadata">

**Author:** [@aspatchek2013](https://forum.inductiveautomation.com/u/aspatchek2013)\
**Replies:** 3\
**Last updated:** [April 19, 2024, 11:59pm UTC](https://forum.inductiveautomation.com/t/perspective-xy-chart-get-selected-range/64870 "2024-04-19T23:59:26Z")

</div>

I am using an XY chart as a Gantt chart. I am implementing it using a horizontal scroll bar. Are there any properties or methods to know what range the horizontal scroll bar is currently selecting?

---

## [Gateway loosing projects... How to restore projects](https://forum.inductiveautomation.com/t/gateway-loosing-projects-how-to-restore-projects/88820)

<div class="topic-metadata">

**Author:** [@Emile\_Laplante](https://forum.inductiveautomation.com/u/Emile_Laplante)\
**Replies:** 6\
**Last updated:** [April 19, 2024, 11:01pm UTC](https://forum.inductiveautomation.com/t/gateway-loosing-projects-how-to-restore-projects/88820 "2024-04-19T23:01:28Z")

</div>

Hi, I don't know why, but my gateway installed on my PC dosen't see all my projects and every time I create a new project, the project is not seen from the gateway page few days later. All my projects are still in the …

---

## [Alarm Status Table - Individual Cell Styling](https://forum.inductiveautomation.com/t/alarm-status-table-individual-cell-styling/89145)

<div class="topic-metadata">

**Author:** [@brian.mcenulty](https://forum.inductiveautomation.com/u/brian.mcenulty)\
**Replies:** 0\
**Last updated:** [April 19, 2024, 10:57pm UTC](https://forum.inductiveautomation.com/t/alarm-status-table-individual-cell-styling/89145 "2024-04-19T22:57:49Z")

</div>

With the Perspective alarm status table component, I'd like to apply styling to only the alarm priority cell with a background color in line with our alarm priority colors for the project rather than the entire row using…

---

## [Reporting Module Table - Use column index instead of column name](https://forum.inductiveautomation.com/t/reporting-module-table-use-column-index-instead-of-column-name/89140)

<div class="topic-metadata">

**Author:** [@carlosbqz](https://forum.inductiveautomation.com/u/carlosbqz)\
**Replies:** 4\
**Last updated:** [April 19, 2024, 10:26pm UTC](https://forum.inductiveautomation.com/t/reporting-module-table-use-column-index-instead-of-column-name/89140 "2024-04-19T22:26:47Z")

</div>

Hello, good evening everyone, As the title suggests, I'm trying to use column indexes instead of column names to populate a Table component in the Reporting Module of Ignition. The reason I'm attempting this approach i…

---

## [How to display alarms in object tooltip](https://forum.inductiveautomation.com/t/how-to-display-alarms-in-object-tooltip/89135)

<div class="topic-metadata">

**Author:** [@jake](https://forum.inductiveautomation.com/u/jake)\
**Replies:** 3\
**Last updated:** [April 19, 2024, 9:16pm UTC](https://forum.inductiveautomation.com/t/how-to-display-alarms-in-object-tooltip/89135 "2024-04-19T21:16:23Z")

</div>

In my application I have objects drawn to represent conveyors. The Name of the object is being used with indirect tagging to create an expression that changes the color of the object. What I want to do is display any act…

---

## [Create white list in doOptions to allow access to specific sites](https://forum.inductiveautomation.com/t/create-white-list-in-dooptions-to-allow-access-to-specific-sites/89142)

<div class="topic-metadata">

**Author:** [@fmata](https://forum.inductiveautomation.com/u/fmata)\
**Replies:** 0\
**Last updated:** [April 19, 2024, 8:41pm UTC](https://forum.inductiveautomation.com/t/create-white-list-in-dooptions-to-allow-access-to-specific-sites/89142 "2024-04-19T20:41:42Z")

</div>

Hi there, I hope this message finds you well. I'm currently exploring how to create a whitelist in the Webdev Module. However, I've encountered an obstacle in obtaining the origin URL. I attempted the following approac…

---

## [Functions for background](https://forum.inductiveautomation.com/t/functions-for-background/89131)

<div class="topic-metadata">

**Author:** [@Alfredo\_Egmo](https://forum.inductiveautomation.com/u/Alfredo_Egmo)\
**Replies:** 5\
**Last updated:** [April 19, 2024, 8:47pm UTC](https://forum.inductiveautomation.com/t/functions-for-background/89131 "2024-04-19T20:47:23Z")

</div>

Is there a way in ignition to create kind of a function that will receive parameters as the value of a tag and inside of that function it will compare the value with other tag values(limits) and depending of that logic i…

---

## [Library Function Call from runScript](https://forum.inductiveautomation.com/t/library-function-call-from-runscript/89141)

<div class="topic-metadata">

**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\
**Replies:** 5\
**Last updated:** [April 19, 2024, 8:25pm UTC](https://forum.inductiveautomation.com/t/library-function-call-from-runscript/89141 "2024-04-19T20:25:03Z")

</div>

I have a project library script that works when I call it from the script console but I can't get a runScript() expression to work with it, for whatever reason. I get correct results in the console and I'm calling the fu…

---

## [EventScripts on a addTag Method](https://forum.inductiveautomation.com/t/eventscripts-on-a-addtag-method/89136)

<div class="topic-metadata">

**Author:** [@Subin\_Adhikari](https://forum.inductiveautomation.com/u/Subin_Adhikari)\
**Replies:** 3\
**Last updated:** [April 19, 2024, 8:13pm UTC](https://forum.inductiveautomation.com/t/eventscripts-on-a-addtag-method/89136 "2024-04-19T20:13:03Z")

</div>

Gurus , Can i create a tag with EventScript in attributes ? if yes may i know the right way please. event\_changed\_script = \[ { "eventid": "valueChanged", "script": "\\tif 1 \\u003d\\u003d 1:\\n\\…

---

## [Cant get report to populate](https://forum.inductiveautomation.com/t/cant-get-report-to-populate/89132)

<div class="topic-metadata">

**Author:** [@Nathaniel\_Webb](https://forum.inductiveautomation.com/u/Nathaniel_Webb)\
**Replies:** 4\
**Last updated:** [April 19, 2024, 7:25pm UTC](https://forum.inductiveautomation.com/t/cant-get-report-to-populate/89132 "2024-04-19T19:25:53Z")

</div>

I have created a report from a sql query. I know the query is good, as i have tested it and see the xml in the preview. \<?xml version="1.0" ?\> \<sample-data\> \<!--This is the raw data used to create the report pre…

---

## [Bedrock PLC Polling](https://forum.inductiveautomation.com/t/bedrock-plc-polling/89116)

<div class="topic-metadata">

**Author:** [@Nathan\_Higgins1](https://forum.inductiveautomation.com/u/Nathan_Higgins1)\
**Replies:** 7\
**Last updated:** [April 19, 2024, 7:11pm UTC](https://forum.inductiveautomation.com/t/bedrock-plc-polling/89116 "2024-04-19T19:11:20Z")

</div>

I have a bedrock PLC that faults tags if I have too many in the same polling group. Has anyone have issues with bedrock PLCs?

---

## [Alarm Trend Tag Override Suggestion](https://forum.inductiveautomation.com/t/alarm-trend-tag-override-suggestion/89048)

<div class="topic-metadata">

**Author:** [@michael.flagler](https://forum.inductiveautomation.com/u/michael.flagler)\
**Replies:** 7\
**Last updated:** [April 19, 2024, 6:54pm UTC](https://forum.inductiveautomation.com/t/alarm-trend-tag-override-suggestion/89048 "2024-04-19T18:54:18Z")

</div>

Most of our alarms in Ignition are PLC driven for analog events/inputs. LIke HH/H/L/LL alarms are just bits in an alarm integer that turn on based on the PLC alarm status. The alarm status component allows trending of al…

---

## [Displaying Totalized values from database based on Identifier and selected time range for report](https://forum.inductiveautomation.com/t/displaying-totalized-values-from-database-based-on-identifier-and-selected-time-range-for-report/89125)

<div class="topic-metadata">

**Author:** [@Kyle\_Skoog](https://forum.inductiveautomation.com/u/Kyle_Skoog)\
**Replies:** 2\
**Last updated:** [April 19, 2024, 6:53pm UTC](https://forum.inductiveautomation.com/t/displaying-totalized-values-from-database-based-on-identifier-and-selected-time-range-for-report/89125 "2024-04-19T18:53:55Z")

</div>

I am creating a report that is displaying the total value of ingredients added within a selected time frame for separate tanks. I am currently storing all tank ingredient data in the same table and have separate queries …

---

## [Gateway message handler exists but logs show not found](https://forum.inductiveautomation.com/t/gateway-message-handler-exists-but-logs-show-not-found/89124)

<div class="topic-metadata">

**Author:** [@devty](https://forum.inductiveautomation.com/u/devty)\
**Replies:** 4\
**Last updated:** [April 19, 2024, 6:43pm UTC](https://forum.inductiveautomation.com/t/gateway-message-handler-exists-but-logs-show-not-found/89124 "2024-04-19T18:43:18Z")

</div>

Was wondering if anyone had ideas on how to troubleshoot this further. I have stripped the code down to the most basic sanity check and still get an issue. I have an onChange event for a tag that scoops up some text fo…

---

## [Sort Order of Columns in table.filter.results.data](https://forum.inductiveautomation.com/t/sort-order-of-columns-in-table-filter-results-data/89126)

<div class="topic-metadata">

**Author:** [@Colin\_Quinn](https://forum.inductiveautomation.com/u/Colin_Quinn)\
**Replies:** 4\
**Last updated:** [April 19, 2024, 6:16pm UTC](https://forum.inductiveautomation.com/t/sort-order-of-columns-in-table-filter-results-data/89126 "2024-04-19T18:16:56Z")

</div>

Hi, I am working on an export feature for a table with filters enabled. When exporting the entire table I am able to just use the table's column order, however when using the filter I am unable to control the order in wh…

---

## [Help me: Understand Tag groups and data arrival](https://forum.inductiveautomation.com/t/help-me-understand-tag-groups-and-data-arrival/89122)

<div class="topic-metadata">

**Author:** [@dis](https://forum.inductiveautomation.com/u/dis)\
**Replies:** 2\
**Last updated:** [April 19, 2024, 6:02pm UTC](https://forum.inductiveautomation.com/t/help-me-understand-tag-groups-and-data-arrival/89122 "2024-04-19T18:02:01Z")

</div>

I am trying to better understand tag groups and tag scan rates in order to ensure that the data is available and current when my Gateway Tag change event triggers. I have tested and verified the scripts themselves so th…

---

## [\[BUG\]Template Property, Template Instance Custom Prop Share Name](https://forum.inductiveautomation.com/t/bug-template-property-template-instance-custom-prop-share-name/89127)

<div class="topic-metadata">

**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\
**Replies:** 0\
**Last updated:** [April 19, 2024, 4:56pm UTC](https://forum.inductiveautomation.com/t/bug-template-property-template-instance-custom-prop-share-name/89127 "2024-04-19T16:56:41Z")

</div>

I have a template with the parameter "position" and I'm also able to create a custom property "position" but the reference to both of these properties in an expression is the same, so I have no idea which one it's going …

---

## [SSO on this version of the app is not compatible with the gateway. Please upgrade your app to newest version. - Ignition Perspective Mobile](https://forum.inductiveautomation.com/t/sso-on-this-version-of-the-app-is-not-compatible-with-the-gateway-please-upgrade-your-app-to-newest-version-ignition-perspective-mobile/86506)

<div class="topic-metadata">

**Author:** [@Elizabeth\_Engler](https://forum.inductiveautomation.com/u/Elizabeth_Engler)\
**Replies:** 2\
**Last updated:** [April 19, 2024, 3:38pm UTC](https://forum.inductiveautomation.com/t/sso-on-this-version-of-the-app-is-not-compatible-with-the-gateway-please-upgrade-your-app-to-newest-version-ignition-perspective-mobile/86506 "2024-04-19T15:38:24Z")

</div>

I get this error when I try to open one of my projects in the Ignition Perspective Mobile app. I've been using the app yesterday and up until now, but now I'm getting this message. I have not recently updated the gateway…

---

## [Multi-state indicator style doesn't work live](https://forum.inductiveautomation.com/t/multi-state-indicator-style-doesnt-work-live/89071)

<div class="topic-metadata">

**Author:** [@Luke\_Waller](https://forum.inductiveautomation.com/u/Luke_Waller)\
**Replies:** 14\
**Last updated:** [April 19, 2024, 3:37pm UTC](https://forum.inductiveautomation.com/t/multi-state-indicator-style-doesnt-work-live/89071 "2024-04-19T15:37:58Z")

</div>

We developed a style through the style customizer that has an animation to flash, with three different states. When in design mode it works but in preview or live it doesn't work. Any thoughts on why?

---

## [Perspective Mouse Click & Drag](https://forum.inductiveautomation.com/t/perspective-mouse-click-drag/28583)

<div class="topic-metadata">

**Author:** [@kgamble](https://forum.inductiveautomation.com/u/kgamble)\
**Replies:** 62\
**Last updated:** [April 19, 2024, 3:28pm UTC](https://forum.inductiveautomation.com/t/perspective-mouse-click-drag/28583 "2024-04-19T15:28:27Z")

</div>

I am building a photoshop like color picker in my perspective application, and I have done some fancy math to determine where in a color gradient the user clicks, and calculate the color code accordingly. I even added a …

---

## [Getting better exception description from SQL java.lang.Exception?](https://forum.inductiveautomation.com/t/getting-better-exception-description-from-sql-java-lang-exception/76628)

<div class="topic-metadata">

**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Replies:** 3\
**Last updated:** [April 19, 2024, 3:23pm UTC](https://forum.inductiveautomation.com/t/getting-better-exception-description-from-sql-java-lang-exception/76628 "2024-04-19T15:23:06Z")

</div>

Is there any way to get useful information from a SQL exception, other than just "your query didn't work :/"? This is what I am getting at the moment, and while I've worked out that I removed one of the fields but forgo…

[Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=433)

[Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=435)