# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=639 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 640 --- ## [Sorting Using Python Sorted Function](https://forum.inductiveautomation.com/t/sorting-using-python-sorted-function/74181)
**Author:** [@Robert\_Hrynciw](https://forum.inductiveautomation.com/u/Robert_Hrynciw)\ **Replies:** 4\ **Last updated:** [May 31, 2023, 2:06pm UTC](https://forum.inductiveautomation.com/t/sorting-using-python-sorted-function/74181 "2023-05-31T14:06:28Z")
Hello, I recently created a JSON table with dropdowns inside of it. It is sorted certain ways with a SQL binding on page launch. When using a system.db.runNamedQuery script to return values based on different filters, I… --- ## [How to set a custom property to None/Null?](https://forum.inductiveautomation.com/t/how-to-set-a-custom-property-to-none-null/74353)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 1\ **Last updated:** [May 31, 2023, 2:00pm UTC](https://forum.inductiveautomation.com/t/how-to-set-a-custom-property-to-none-null/74353 "2023-05-31T14:00:39Z")
Using 7.9.9. I have a window setup with a table and filters above it to search through records. One part of this is two calendars that provide a startDate and endDate parameter to a named query. There is also a checkb… --- ## [Perspective Table - refreshBinding from button not working](https://forum.inductiveautomation.com/t/perspective-table-refreshbinding-from-button-not-working/74223)
**Author:** [@shaunstewart](https://forum.inductiveautomation.com/u/shaunstewart)\ **Replies:** 7\ **Last updated:** [May 31, 2023, 1:59pm UTC](https://forum.inductiveautomation.com/t/perspective-table-refreshbinding-from-button-not-working/74223 "2023-05-31T13:59:36Z")
Im trying to refresh a binding i have on a Perspective Tables "props.data" from a button and cant get it to work. Im using a message handler on the Table and calling it from the button. My binding on props.data is a data… --- ## [How can I check if a component exists or not?](https://forum.inductiveautomation.com/t/how-can-i-check-if-a-component-exists-or-not/74340)
**Author:** [@AMA\_nylon](https://forum.inductiveautomation.com/u/AMA_nylon)\ **Replies:** 6\ **Last updated:** [May 31, 2023, 1:54pm UTC](https://forum.inductiveautomation.com/t/how-can-i-check-if-a-component-exists-or-not/74340 "2023-05-31T13:54:16Z")
Hi there, I'm new to Ignition and I'm trying to make an event script on Startup of a Popup that loop over a range of 16 and check first whether a component FlexContainer exists before applying some modifications. Here i… --- ## [How to convert to military time?](https://forum.inductiveautomation.com/t/how-to-convert-to-military-time/74350)
**Author:** [@rahman.tarek](https://forum.inductiveautomation.com/u/rahman.tarek)\ **Replies:** 4\ **Last updated:** [May 31, 2023, 1:10pm UTC](https://forum.inductiveautomation.com/t/how-to-convert-to-military-time/74350 "2023-05-31T13:10:29Z")
I have the following tag value - 06-02 14:37 PM. This is a datetime object and i need to convert to military time. any tips? --- ## [Redundant Ignition Backend Gateways with KepserverEX](https://forum.inductiveautomation.com/t/redundant-ignition-backend-gateways-with-kepserverex/70697)
**Author:** [@franklepkowski](https://forum.inductiveautomation.com/u/franklepkowski)\ **Replies:** 3\ **Last updated:** [May 31, 2023, 1:06pm UTC](https://forum.inductiveautomation.com/t/redundant-ignition-backend-gateways-with-kepserverex/70697 "2023-05-31T13:06:23Z")
Hello All, I have redundant gateways with kepware installed on each gateway. Intention is to allow Ignition to have connection to kepware in the event of the primary gateway going down. Has anyone done something similia… --- ## [Serial number search in docked view through session custom property](https://forum.inductiveautomation.com/t/serial-number-search-in-docked-view-through-session-custom-property/74345)
**Author:** [@Chowmya\_C](https://forum.inductiveautomation.com/u/Chowmya_C)\ **Replies:** 1\ **Last updated:** [May 31, 2023, 12:38pm UTC](https://forum.inductiveautomation.com/t/serial-number-search-in-docked-view-through-session-custom-property/74345 "2023-05-31T12:38:02Z")
There's a docked view in which I need to search serial number in text field. In primary view the searched serial number's details should display in each instances of flex repeater... So,in URL it will be in a page How… --- ## [The trends on the very right side of the easy chart cannot be plotted](https://forum.inductiveautomation.com/t/the-trends-on-the-very-right-side-of-the-easy-chart-cannot-be-plotted/74285)
**Author:** [@June\_Zhu](https://forum.inductiveautomation.com/u/June_Zhu)\ **Replies:** 4\ **Last updated:** [May 31, 2023, 7:27am UTC](https://forum.inductiveautomation.com/t/the-trends-on-the-very-right-side-of-the-easy-chart-cannot-be-plotted/74285 "2023-05-31T07:27:17Z")
The trends on the very right side of the easy chart cannot be plotted, there was a blank space all the time. Does anyone have the same problem? thanks. --- ## [UDT Dynamic Alarm Label doesn't see memory tag values when the gateway starts](https://forum.inductiveautomation.com/t/udt-dynamic-alarm-label-doesnt-see-memory-tag-values-when-the-gateway-starts/74334)
**Author:** [@Maxim\_Graur](https://forum.inductiveautomation.com/u/Maxim_Graur)\ **Replies:** 0\ **Last updated:** [May 31, 2023, 7:24am UTC](https://forum.inductiveautomation.com/t/udt-dynamic-alarm-label-doesnt-see-memory-tag-values-when-the-gateway-starts/74334 "2023-05-31T07:24:49Z")
Dear sirs, I'm trying to build Alarm Labels dynamically as shown in the following picture: In the UDT I use Memory Tags to store text parts as "Tag name" + "Alarm message" + "Device description": It works , but… --- ## [Can I change the value of a specific column in the dataset and show it?](https://forum.inductiveautomation.com/t/can-i-change-the-value-of-a-specific-column-in-the-dataset-and-show-it/74324)
**Author:** [@KIM\_JINGEUN](https://forum.inductiveautomation.com/u/KIM_JINGEUN)\ **Replies:** 4\ **Last updated:** [May 31, 2023, 7:01am UTC](https://forum.inductiveautomation.com/t/can-i-change-the-value-of-a-specific-column-in-the-dataset-and-show-it/74324 "2023-05-31T07:01:45Z")
Hello! I have a few questions. This is the dataset retrieved from sql. I want to show the value of a specific column in this table as a value of a different type. For example, if the value of 'event ID' column is … --- ## [Is it possible to bypass the shutdown event script of a perspective view?](https://forum.inductiveautomation.com/t/is-it-possible-to-bypass-the-shutdown-event-script-of-a-perspective-view/74320)
**Author:** [@AVG04](https://forum.inductiveautomation.com/u/AVG04)\ **Replies:** 3\ **Last updated:** [May 31, 2023, 6:03am UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-bypass-the-shutdown-event-script-of-a-perspective-view/74320 "2023-05-31T06:03:41Z")
Here is my current setup: I have a perspective view with an onShutdown System Events that is enabled (script) the script function is to check if there are irregularities found on the view data. (this will be triggered … --- ## [Multiply dataset columns with number](https://forum.inductiveautomation.com/t/multiply-dataset-columns-with-number/74258)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 12\ **Last updated:** [May 31, 2023, 5:06am UTC](https://forum.inductiveautomation.com/t/multiply-dataset-columns-with-number/74258 "2023-05-31T05:06:38Z")
Hi , I have dataset . i want to multiply 2,3,4 column with a number 0003 which method is good approach do this please anyone help me out --- ## [Lora Device -\> LoraWAN Gateway -\> The Things Network -\> Ignition](https://forum.inductiveautomation.com/t/lora-device-lorawan-gateway-the-things-network-ignition/74246)
**Author:** [@Craig\_Blizard](https://forum.inductiveautomation.com/u/Craig_Blizard)\ **Replies:** 6\ **Last updated:** [May 31, 2023, 5:06am UTC](https://forum.inductiveautomation.com/t/lora-device-lorawan-gateway-the-things-network-ignition/74246 "2023-05-31T05:06:40Z")
Hey guys, I have an application where I have a power meter which speaks Lora to a LoraWAN gateway. The LoraWAN gateway is a RAK7258 which passes data to the Things Network. I am looking for advice on how to bring the … --- ## [Searchable dropdown in vision](https://forum.inductiveautomation.com/t/searchable-dropdown-in-vision/63432)
**Author:** [@rahul.bhakte](https://forum.inductiveautomation.com/u/rahul.bhakte)\ **Replies:** 19\ **Last updated:** [May 31, 2023, 3:22am UTC](https://forum.inductiveautomation.com/t/searchable-dropdown-in-vision/63432 "2023-05-31T03:22:23Z")
Is there any provision to make dropdown searchable in vision? If no, how can I do it? Please help!!! --- ## [Centre aligned label text to bounding box](https://forum.inductiveautomation.com/t/centre-aligned-label-text-to-bounding-box/12017)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 4\ **Last updated:** [May 31, 2023, 1:48am UTC](https://forum.inductiveautomation.com/t/centre-aligned-label-text-to-bounding-box/12017 "2023-05-31T01:48:26Z")
This might be a stupid question.. but I can't work out how to centre-align my labels. I have it working as per the Inductive University video for buttons, but the same HTML code doesn't work for labels. In my Data.Text … --- ## [XYChart x axis mark display](https://forum.inductiveautomation.com/t/xychart-x-axis-mark-display/72064)
**Author:** [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\ **Replies:** 3\ **Last updated:** [May 31, 2023, 12:57am UTC](https://forum.inductiveautomation.com/t/xychart-x-axis-mark-display/72064 "2023-05-31T00:57:23Z")
I have a set of data When displaying on the XYChart, the x axis only displayed the even index. I would like to display all index as marker in x axes. I found the interval setting for when selecting "xAxes/render" to… --- ## [Cant debug Tag Browse Tree filter](https://forum.inductiveautomation.com/t/cant-debug-tag-browse-tree-filter/74322)
**Author:** [@richardNZ15](https://forum.inductiveautomation.com/u/richardNZ15)\ **Replies:** 6\ **Last updated:** [May 30, 2023, 11:53pm UTC](https://forum.inductiveautomation.com/t/cant-debug-tag-browse-tree-filter/74322 "2023-05-30T23:53:46Z")
This is a really annoying one. I've read through all the forum posts about how to utilize this filter, and all i really want to do is show realtime tags from specific providers and not others. So i imagined something l… --- ## [Hiding app bar mobile when scrolling](https://forum.inductiveautomation.com/t/hiding-app-bar-mobile-when-scrolling/73935)
**Author:** [@Corne\_de\_Jonge](https://forum.inductiveautomation.com/u/Corne_de_Jonge)\ **Replies:** 1\ **Last updated:** [May 30, 2023, 10:48pm UTC](https://forum.inductiveautomation.com/t/hiding-app-bar-mobile-when-scrolling/73935 "2023-05-30T22:48:55Z")
Hello everyone, I'm currently working on implementing a feature for a mobile application where the top and bottom dock should hide when scrolling. I have achieved the hiding functionality for the docks. However, I'm cu… --- ## [Dropdown Filter not working](https://forum.inductiveautomation.com/t/dropdown-filter-not-working/74134)
**Author:** [@MAURICIO\_AZAMBUJA](https://forum.inductiveautomation.com/u/MAURICIO_AZAMBUJA)\ **Replies:** 5\ **Last updated:** [May 30, 2023, 9:29pm UTC](https://forum.inductiveautomation.com/t/dropdown-filter-not-working/74134 "2023-05-30T21:29:20Z")
i am having problems with the dropdown filter in perspective. When I type some value in the search it doesn't make the selection according to the search. Only when I click the down button on the keyboard does the value… --- ## [Stored Procedure Call Blocking or Timeout](https://forum.inductiveautomation.com/t/stored-procedure-call-blocking-or-timeout/74316)
**Author:** [@Jake\_Bottari](https://forum.inductiveautomation.com/u/Jake_Bottari)\ **Replies:** 3\ **Last updated:** [May 30, 2023, 8:27pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-call-blocking-or-timeout/74316 "2023-05-30T20:27:40Z")
When using the functions system.db.createSProcCall() and subsequently system.db.execSPProcCall(), does this just submit the call to the SQL server and continue executing the script? Or does it block until a response is r… --- ## [Perspective Carousel Dot Color](https://forum.inductiveautomation.com/t/perspective-carousel-dot-color/74304)
**Author:** [@Lauren\_Hart](https://forum.inductiveautomation.com/u/Lauren_Hart)\ **Replies:** 2\ **Last updated:** [May 30, 2023, 8:11pm UTC](https://forum.inductiveautomation.com/t/perspective-carousel-dot-color/74304 "2023-05-30T20:11:01Z")
Hello, Is there a way to dynamically change the dot color for the perspective carousel component? I am using the carousel component for a questionnaire. Each view that the carousel navigates through has a new question. … --- ## [Multiselection Drop down selector default value](https://forum.inductiveautomation.com/t/multiselection-drop-down-selector-default-value/74301)
**Author:** [@Alexandre\_Potvin](https://forum.inductiveautomation.com/u/Alexandre_Potvin)\ **Replies:** 11\ **Last updated:** [May 30, 2023, 8:08pm UTC](https://forum.inductiveautomation.com/t/multiselection-drop-down-selector-default-value/74301 "2023-05-30T20:08:16Z")
Hi I am using multiselection for 8 value but the user does not need to fill all of them to save in the DB the problem is that when the selection is not complet the link does not esxist. In a previous test i was using l… --- ## [Perpective Table Date Column is Unformatted in Python](https://forum.inductiveautomation.com/t/perpective-table-date-column-is-unformatted-in-python/72942)
**Author:** [@Jeff\_Spicuzzi](https://forum.inductiveautomation.com/u/Jeff_Spicuzzi)\ **Replies:** 4\ **Last updated:** [May 30, 2023, 7:17pm UTC](https://forum.inductiveautomation.com/t/perpective-table-date-column-is-unformatted-in-python/72942 "2023-05-30T19:17:50Z")
I have a simple line of code to display the formatted date from the selected row in a table. PeriodEnd column is configured with the correct name, Render=date, DateFormat is MM/DD/YYYY HH:mm:ss The date displays proper… --- ## [System.alarm.querystatus() not working](https://forum.inductiveautomation.com/t/system-alarm-querystatus-not-working/74308)
**Author:** [@Christy\_Jean](https://forum.inductiveautomation.com/u/Christy_Jean)\ **Replies:** 10\ **Last updated:** [May 30, 2023, 6:44pm UTC](https://forum.inductiveautomation.com/t/system-alarm-querystatus-not-working/74308 "2023-05-30T18:44:57Z")
whenever value == true, I get null but i'm not seeing what I'm doing wrong. --- ## [\[SOLVED\] Add alternating color to Perspective table rows through scripting after sorting the data](https://forum.inductiveautomation.com/t/solved-add-alternating-color-to-perspective-table-rows-through-scripting-after-sorting-the-data/73649)
**Author:** [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Replies:** 12\ **Last updated:** [May 30, 2023, 6:19pm UTC](https://forum.inductiveautomation.com/t/solved-add-alternating-color-to-perspective-table-rows-through-scripting-after-sorting-the-data/73649 "2023-05-30T18:19:19Z")
I have a generic Perspective table with an added custom property called ds that will call a named query in the future. On the table is a single system event onStartup that calls a custom method script on the table. … --- ## [Perspective Navigation with OnClick Button(s)](https://forum.inductiveautomation.com/t/perspective-navigation-with-onclick-button-s/74309)
**Author:** [@Yash\_Patel](https://forum.inductiveautomation.com/u/Yash_Patel)\ **Replies:** 1\ **Last updated:** [May 30, 2023, 6:14pm UTC](https://forum.inductiveautomation.com/t/perspective-navigation-with-onclick-button-s/74309 "2023-05-30T18:14:55Z")
If you want onClick button(s) on the Navigation menu, you can do it within Ignition using Ignition event script. Working Example: Off State: On State(onClick): Create your Navigation and give it a text value of y… --- ## [Opening, on one client, two projects that are on separate networks](https://forum.inductiveautomation.com/t/opening-on-one-client-two-projects-that-are-on-separate-networks/74311)
**Author:** [@kathyb](https://forum.inductiveautomation.com/u/kathyb)\ **Replies:** 2\ **Last updated:** [May 30, 2023, 6:02pm UTC](https://forum.inductiveautomation.com/t/opening-on-one-client-two-projects-that-are-on-separate-networks/74311 "2023-05-30T18:02:45Z")
I have two applications I would like to open on the same client. One application is on the local gateway and the other is on the remote. I have two NICs installed on the client with addressing based off of the two networ… --- ## [Programmatically expand nodes in tag browse tree](https://forum.inductiveautomation.com/t/programmatically-expand-nodes-in-tag-browse-tree/73169)
**Author:** [@Sala\_Tiemann](https://forum.inductiveautomation.com/u/Sala_Tiemann)\ **Replies:** 5\ **Last updated:** [May 30, 2023, 5:41pm UTC](https://forum.inductiveautomation.com/t/programmatically-expand-nodes-in-tag-browse-tree/73169 "2023-05-30T17:41:53Z")
Hello, I'm working with a tag browse tree in Perspective and I was wondering if there was a way to programmatically expand the nodes without needing a user to click on a folder. I.e. is there a way to identify a node by … --- ## [Open a popup as a view is open](https://forum.inductiveautomation.com/t/open-a-popup-as-a-view-is-open/74264)
**Author:** [@AGOSTINO\_SCLAUZERO](https://forum.inductiveautomation.com/u/AGOSTINO_SCLAUZERO)\ **Replies:** 6\ **Last updated:** [May 30, 2023, 5:11pm UTC](https://forum.inductiveautomation.com/t/open-a-popup-as-a-view-is-open/74264 "2023-05-30T17:11:17Z")
The requirement: I've got a perspective application that is passed an id as an URL parameter. If this id is -1 it should show a dialog to allow the user to chose a document in a list; if an id\>0 is provided, the applic… --- ## [UDT shared across multiple tag providers needs unique History provider per tag provider](https://forum.inductiveautomation.com/t/udt-shared-across-multiple-tag-providers-needs-unique-history-provider-per-tag-provider/74300)
**Author:** [@msrobin](https://forum.inductiveautomation.com/u/msrobin)\ **Replies:** 6\ **Last updated:** [May 30, 2023, 4:30pm UTC](https://forum.inductiveautomation.com/t/udt-shared-across-multiple-tag-providers-needs-unique-history-provider-per-tag-provider/74300 "2023-05-30T16:30:41Z")
We have a Developement Gateway that has multiple tag providers on it. We want to use a "global" UDT that is pushed to each tag provider by an EAM task so that all tag providers are using the same tags/structure, etc. T… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=638) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=640)