# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=565 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 566 --- ## [Table selection, filters problem and bugs](https://forum.inductiveautomation.com/t/table-selection-filters-problem-and-bugs/75896)
**Author:** [@Kaloyan\_Radomirov](https://forum.inductiveautomation.com/u/Kaloyan_Radomirov)\ **Replies:** 14\ **Last updated:** [September 23, 2023, 7:46pm UTC](https://forum.inductiveautomation.com/t/table-selection-filters-problem-and-bugs/75896 "2023-09-23T19:46:12Z")
Hello guys I have a problem with calculation the total of a filtered column. When I write something in the filter (search bar) of the table the results are out and I can have an amount. If I also apply a column filte… --- ## [Slow Queries In Tags](https://forum.inductiveautomation.com/t/slow-queries-in-tags/78726)
**Author:** [@Mario\_Olivares](https://forum.inductiveautomation.com/u/Mario_Olivares)\ **Replies:** 5\ **Last updated:** [September 23, 2023, 6:51pm UTC](https://forum.inductiveautomation.com/t/slow-queries-in-tags/78726 "2023-09-23T18:51:17Z")
Hello there everybody, I have mi Ignition project linked to an SQL Server database, and I have created some Query Tags inside of it. The thing is, while inside the SQL Server each variable on the table updates every 3 s… --- ## [Scraping information from website using httpClient()](https://forum.inductiveautomation.com/t/scraping-information-from-website-using-httpclient/79549)
**Author:** [@Nicholas\_Houston](https://forum.inductiveautomation.com/u/Nicholas_Houston)\ **Replies:** 5\ **Last updated:** [September 23, 2023, 5:08pm UTC](https://forum.inductiveautomation.com/t/scraping-information-from-website-using-httpclient/79549 "2023-09-23T17:08:26Z")
Hey everyone, I am building an inventory for a customer. They want accurate pricing added to a database. Is it possible to use httpClient() to scrape a price from a website? This is an example. I want to use this websi… --- ## [Changing a tag from a memory tag to an OPC tag](https://forum.inductiveautomation.com/t/changing-a-tag-from-a-memory-tag-to-an-opc-tag/79531)
**Author:** [@Judd\_Edema](https://forum.inductiveautomation.com/u/Judd_Edema)\ **Replies:** 6\ **Last updated:** [September 23, 2023, 4:58pm UTC](https://forum.inductiveautomation.com/t/changing-a-tag-from-a-memory-tag-to-an-opc-tag/79531 "2023-09-23T16:58:23Z")
I have an application I'm working on that has the possibility of functioning in 2 modes. 1 mode is a local PC-only mode. the second mode is communicating with a PLC. initially, I planned on having a gateway script tha… --- ## [Connection refused (websocket, http)](https://forum.inductiveautomation.com/t/connection-refused-websocket-http/70975)
**Author:** [@Hamza\_Salah](https://forum.inductiveautomation.com/u/Hamza_Salah)\ **Replies:** 5\ **Last updated:** [September 23, 2023, 2:09pm UTC](https://forum.inductiveautomation.com/t/connection-refused-websocket-http/70975 "2023-09-23T14:09:24Z")
Hi, I'm having a problem establishing a websocket or even an http connection between ignition and my raspberry pi. I keep getting this msg: Caused by: org.python.core.PyException: IOError: \[Errno socket error\] \[Errno 1… --- ## [Dataset with transform on one column](https://forum.inductiveautomation.com/t/dataset-with-transform-on-one-column/79533)
**Author:** [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\ **Replies:** 4\ **Last updated:** [September 23, 2023, 1:51pm UTC](https://forum.inductiveautomation.com/t/dataset-with-transform-on-one-column/79533 "2023-09-23T13:51:42Z")
Is it possible to apply a transform on one column of a dataset (from a named query)? For example, four integers are returned for this one column, 0-3. I would like to display to the user a string text depending on the … --- ## [Dock menu and sub menu](https://forum.inductiveautomation.com/t/dock-menu-and-sub-menu/79548)
**Author:** [@samer\_samy](https://forum.inductiveautomation.com/u/samer_samy)\ **Replies:** 1\ **Last updated:** [September 23, 2023, 12:09pm UTC](https://forum.inductiveautomation.com/t/dock-menu-and-sub-menu/79548 "2023-09-23T12:09:24Z")
Dears, I face a problem now in my project that I face recently and I do not know the rootcause of this problem . Before when I open the submenu from the main menu , the main menu disappear and the submenu appear . rec… --- ## [Named Query by Drop Down List for Month in the Vision Module](https://forum.inductiveautomation.com/t/named-query-by-drop-down-list-for-month-in-the-vision-module/79086)
**Author:** [@Andrew\_Soltwedel](https://forum.inductiveautomation.com/u/Andrew_Soltwedel)\ **Replies:** 7\ **Last updated:** [September 23, 2023, 2:16am UTC](https://forum.inductiveautomation.com/t/named-query-by-drop-down-list-for-month-in-the-vision-module/79086 "2023-09-23T02:16:21Z")
Hey Guys, I'm having a problem with pulling the Value from the drop down list and populating that value into my Named Query. I'm not sure what I'm doing wrong. My Selected value for September is an Integer of 9, but… --- ## [Shelved Alarms Keep Alarming When Re-triggered](https://forum.inductiveautomation.com/t/shelved-alarms-keep-alarming-when-re-triggered/52140)
**Author:** [@oliver.jones](https://forum.inductiveautomation.com/u/oliver.jones)\ **Replies:** 3\ **Last updated:** [September 23, 2023, 4:47am UTC](https://forum.inductiveautomation.com/t/shelved-alarms-keep-alarming-when-re-triggered/52140 "2023-09-23T04:47:31Z")
Hi, I am having a strange problem where a customer using Ignition 8.1.7 shelves nuisance alarms which send out SMS notifications, but as these nuisance alarms re-trigger (become inactive, then active again), to everyone… --- ## [Problem about adding tags](https://forum.inductiveautomation.com/t/problem-about-adding-tags/79285)
**Author:** [@can\_gul](https://forum.inductiveautomation.com/u/can_gul)\ **Replies:** 2\ **Last updated:** [September 23, 2023, 2:38am UTC](https://forum.inductiveautomation.com/t/problem-about-adding-tags/79285 "2023-09-23T02:38:53Z")
hello, I am trying to create tags but there is parent data type which is I never add in custom section. you can see in pictures. How can delete it? and I want to add opc item path but I can not add it, Why? please help m… --- ## [Troubles making a Derived Boolean Tag work as a mask for a Short Tag](https://forum.inductiveautomation.com/t/troubles-making-a-derived-boolean-tag-work-as-a-mask-for-a-short-tag/15203)
**Author:** [@Weffrey](https://forum.inductiveautomation.com/u/Weffrey)\ **Replies:** 5\ **Last updated:** [September 23, 2023, 1:39am UTC](https://forum.inductiveautomation.com/t/troubles-making-a-derived-boolean-tag-work-as-a-mask-for-a-short-tag/15203 "2023-09-23T01:39:33Z")
Hi! I have long wanted a clean way in Ignition to create an internal boolean tag that points at an OPC based integer or short so I can easily link graphics to set/clear a bit of an OPC tag without scripting. I have use… --- ## [Are comments in Named Queries known to not work correctly?](https://forum.inductiveautomation.com/t/are-comments-in-named-queries-known-to-not-work-correctly/79319)
**Author:** [@sherman](https://forum.inductiveautomation.com/u/sherman)\ **Replies:** 34\ **Last updated:** [September 23, 2023, 12:28am UTC](https://forum.inductiveautomation.com/t/are-comments-in-named-queries-known-to-not-work-correctly/79319 "2023-09-23T00:28:35Z")
I am trying to get some basic named queries up and running, and during my tribulations I have discovered that if I add comments (-- prefix, postgresql), I get errors like org.postgresql.util.PSQLException: The column in… --- ## [Historical value writing over itself in SQL](https://forum.inductiveautomation.com/t/historical-value-writing-over-itself-in-sql/79537)
**Author:** [@Asya\_Sergoyan](https://forum.inductiveautomation.com/u/Asya_Sergoyan)\ **Replies:** 1\ **Last updated:** [September 23, 2023, 12:21am UTC](https://forum.inductiveautomation.com/t/historical-value-writing-over-itself-in-sql/79537 "2023-09-23T00:21:53Z")
We are running Ignition 8.1 and have been collecting tag history on many tags. At 12:51 we randomly stopped collecting tag history and I can't understand why. See below for the historical export for every minute of a tem… --- ## [Unique Identity Provider per Project](https://forum.inductiveautomation.com/t/unique-identity-provider-per-project/79529)
**Author:** [@Colby\_Desselles](https://forum.inductiveautomation.com/u/Colby_Desselles)\ **Replies:** 2\ **Last updated:** [September 22, 2023, 9:44pm UTC](https://forum.inductiveautomation.com/t/unique-identity-provider-per-project/79529 "2023-09-22T21:44:03Z")
I have been doing some digging in identity providers and I was wondering how you would have a different IDP per project within perspective. I see the option per project to change the IDP, but they all share a common end… --- ## [System.tag.query missing custom properties](https://forum.inductiveautomation.com/t/system-tag-query-missing-custom-properties/78322)
**Author:** [@SamDonche](https://forum.inductiveautomation.com/u/SamDonche)\ **Replies:** 2\ **Last updated:** [September 22, 2023, 7:50pm UTC](https://forum.inductiveautomation.com/t/system-tag-query-missing-custom-properties/78322 "2023-09-22T19:50:59Z")
It seems that the function system.tag.query is not able to retrieve the information on custom properties. Is this intentional? --- ## [Named query returns \[{Column:value}\] instead of just value](https://forum.inductiveautomation.com/t/named-query-returns-column-value-instead-of-just-value/79526)
**Author:** [@kssp](https://forum.inductiveautomation.com/u/kssp)\ **Replies:** 2\ **Last updated:** [September 22, 2023, 7:36pm UTC](https://forum.inductiveautomation.com/t/named-query-returns-column-value-instead-of-just-value/79526 "2023-09-22T19:36:25Z")
Hey, folks. I have an onActionPerformed running for a dropdown in Perspective. The options for this dropdown are filled via a query that pulls all values from one column in a table. The correct values populate into this… --- ## [Double-Click Not Functioning in Perspective Table within Developer Tools in Web Browser](https://forum.inductiveautomation.com/t/double-click-not-functioning-in-perspective-table-within-developer-tools-in-web-browser/79494)
**Author:** [@Senthoor\_Mani\_M](https://forum.inductiveautomation.com/u/Senthoor_Mani_M)\ **Replies:** 4\ **Last updated:** [September 22, 2023, 7:30pm UTC](https://forum.inductiveautomation.com/t/double-click-not-functioning-in-perspective-table-within-developer-tools-in-web-browser/79494 "2023-09-22T19:30:44Z")
Hello everyone, I am currently working on a project involving a main view and a popup view. In the main view, there is a table, and a popup is supposed to open when a table row is clicked. Here's the issue I'm facing: w… --- ## [How open the GWBK file](https://forum.inductiveautomation.com/t/how-open-the-gwbk-file/79511)
**Author:** [@nabil\_hocini](https://forum.inductiveautomation.com/u/nabil_hocini)\ **Replies:** 7\ **Last updated:** [September 22, 2023, 6:41pm UTC](https://forum.inductiveautomation.com/t/how-open-the-gwbk-file/79511 "2023-09-22T18:41:14Z")
hello everyone, could you show me the way to open the .GWBK files, please? --- ## [Change DateTimeInput css style in theme folder](https://forum.inductiveautomation.com/t/change-datetimeinput-css-style-in-theme-folder/79349)
**Author:** [@flavien](https://forum.inductiveautomation.com/u/flavien)\ **Replies:** 4\ **Last updated:** [September 22, 2023, 5:03pm UTC](https://forum.inductiveautomation.com/t/change-datetimeinput-css-style-in-theme-folder/79349 "2023-09-22T17:03:51Z")
Hi, How can I change the background of datetimeinput popup below in my own theme's folder ? --- ## [Get a list of all first names, last names, and emails out of the active directory using system.user.getUsers()](https://forum.inductiveautomation.com/t/get-a-list-of-all-first-names-last-names-and-emails-out-of-the-active-directory-using-system-user-getusers/79484)
**Author:** [@Bushmatic](https://forum.inductiveautomation.com/u/Bushmatic)\ **Replies:** 7\ **Last updated:** [September 22, 2023, 4:43pm UTC](https://forum.inductiveautomation.com/t/get-a-list-of-all-first-names-last-names-and-emails-out-of-the-active-directory-using-system-user-getusers/79484 "2023-09-22T16:43:21Z")
I'm trying to figure out how to compile a list of all active users in the form of (first name, last name, email address) out of our active directory in Ignition. I have the following code, but I can't figure out how to g… --- ## [Notice of Domain Account Lock due to file](https://forum.inductiveautomation.com/t/notice-of-domain-account-lock-due-to-file/79471)
**Author:** [@MikeAllgood](https://forum.inductiveautomation.com/u/MikeAllgood)\ **Replies:** 4\ **Last updated:** [September 22, 2023, 3:12pm UTC](https://forum.inductiveautomation.com/t/notice-of-domain-account-lock-due-to-file/79471 "2023-09-22T15:12:40Z")
I did a deploy on a production server today and had to open up the designer to import some tags. Later, an IT rep contacted me to let me know that my account had been locked out due to a file Varonis did not like. The f… --- ## [Change font by change language in ignition Translation](https://forum.inductiveautomation.com/t/change-font-by-change-language-in-ignition-translation/21243)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 2\ **Last updated:** [September 22, 2023, 1:48pm UTC](https://forum.inductiveautomation.com/t/change-font-by-change-language-in-ignition-translation/21243 "2023-09-22T13:48:51Z")
Hello In some fonts only one the target language is support(for ex only Russian) so when change language the English the font can't render target character and text field shows empty in ignition. I see a lot in other S… --- ## [Perspective Scripting to find a Custom Property on a View](https://forum.inductiveautomation.com/t/perspective-scripting-to-find-a-custom-property-on-a-view/79466)
**Author:** [@Brian\_Shin](https://forum.inductiveautomation.com/u/Brian_Shin)\ **Replies:** 17\ **Last updated:** [September 22, 2023, 1:16pm UTC](https://forum.inductiveautomation.com/t/perspective-scripting-to-find-a-custom-property-on-a-view/79466 "2023-09-22T13:16:32Z")
Hello, I have a custom UDT tag that is on my view. Within this UDT tag are two tags: HighAlarmEnableMode HighAlarmEnablePB The PB tag needs to be a momentary bit where it's a 1 and goes back to 0. When the PB tag is … --- ## [Ignition and Cirrus Link desever much more CREDIT](https://forum.inductiveautomation.com/t/ignition-and-cirrus-link-desever-much-more-credit/79503)
**Author:** [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Replies:** 1\ **Last updated:** [September 22, 2023, 11:52am UTC](https://forum.inductiveautomation.com/t/ignition-and-cirrus-link-desever-much-more-credit/79503 "2023-09-22T11:52:44Z")
Ignition and Cirrus Link really do deserve much more credit, this combination has worked flawless for me for about 4 years now. I'm in the Oil & Gas industry. I have several very remote locations that we communicate wit… --- ## [Using dropdown to change primary view content](https://forum.inductiveautomation.com/t/using-dropdown-to-change-primary-view-content/79390)
**Author:** [@Pyrak](https://forum.inductiveautomation.com/u/Pyrak)\ **Replies:** 4\ **Last updated:** [September 22, 2023, 11:34am UTC](https://forum.inductiveautomation.com/t/using-dropdown-to-change-primary-view-content/79390 "2023-09-22T11:34:55Z")
Hi everyone, I'm having trouble configuring dropdown to change page content on selection of different items (A, B, C) in the list. I have a docked view with the dropdown set on top of the primary view I have three oth… --- ## [Extracting data from incoming SECS Message from equipment](https://forum.inductiveautomation.com/t/extracting-data-from-incoming-secs-message-from-equipment/79493)
**Author:** [@dvsagar95](https://forum.inductiveautomation.com/u/dvsagar95)\ **Replies:** 0\ **Last updated:** [September 22, 2023, 9:34am UTC](https://forum.inductiveautomation.com/t/extracting-data-from-incoming-secs-message-from-equipment/79493 "2023-09-22T09:34:12Z")
Hi, I am using ignition to communicate with an equipment using SECS/GEM. I am getting the response which is something like this: {u'body': \[{u'format': 'A', u'doc': 'MDLN, Equipment Model Type', u'value': 'sim1'}, {u'f… --- ## [Power Chart custom filter](https://forum.inductiveautomation.com/t/power-chart-custom-filter/79489)
**Author:** [@Jay\_Makwana](https://forum.inductiveautomation.com/u/Jay_Makwana)\ **Replies:** 0\ **Last updated:** [September 22, 2023, 5:58am UTC](https://forum.inductiveautomation.com/t/power-chart-custom-filter/79489 "2023-09-22T05:58:55Z")
Hi, There is a date/time filter in power chart to export data with selected time range, I want to add another custom filter in power chart. Is it possible to add? Help me out. Thank you. --- ## [Perspective Table Rows Not Bidirectional With JSON Structure](https://forum.inductiveautomation.com/t/perspective-table-rows-not-bidirectional-with-json-structure/79486)
**Author:** [@tmahaf](https://forum.inductiveautomation.com/u/tmahaf)\ **Replies:** 2\ **Last updated:** [September 22, 2023, 6:33am UTC](https://forum.inductiveautomation.com/t/perspective-table-rows-not-bidirectional-with-json-structure/79486 "2023-09-22T06:33:20Z")
I can toggle the checkboxfrom the table data prop and the checkbox works as expected: However, Setting the bit low on the checkbox doesn't work bidirectionally and the table Data value still shows the bit True: I… --- ## [\[BUG\]Edge Gateway Tag Provider Already Exists](https://forum.inductiveautomation.com/t/bug-edge-gateway-tag-provider-already-exists/79414)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 1\ **Last updated:** [September 21, 2023, 11:59pm UTC](https://forum.inductiveautomation.com/t/bug-edge-gateway-tag-provider-already-exists/79414 "2023-09-21T23:59:53Z")
Have an edge installation that I previously restored a backup on and renamed the tag provider. Restored the gateway backup again, it now has the default "edge" tag provider name but when I try to change it, it says the … --- ## [Edge Sync Services](https://forum.inductiveautomation.com/t/edge-sync-services/79477)
**Author:** [@Project2501](https://forum.inductiveautomation.com/u/Project2501)\ **Replies:** 1\ **Last updated:** [September 21, 2023, 9:13pm UTC](https://forum.inductiveautomation.com/t/edge-sync-services/79477 "2023-09-21T21:13:59Z")
My edge gateway is running with an Edge Sync License, all good. There is a main gateway running, connected to a historian collecting the edge gateway tags and serving perspective sessions. This is peachy. Should the S… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=564) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=566)