# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=805 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 806 --- ## [Modbus TCP Connected Device Works with Modpoll but NOT on Ignition!](https://forum.inductiveautomation.com/t/modbus-tcp-connected-device-works-with-modpoll-but-not-on-ignition/55916)
**Author:** [@John\_Reilly](https://forum.inductiveautomation.com/u/John_Reilly)\ **Replies:** 8\ **Last updated:** [July 26, 2022, 10:41am UTC](https://forum.inductiveautomation.com/t/modbus-tcp-connected-device-works-with-modpoll-but-not-on-ignition/55916 "2022-07-26T10:41:06Z")
Hi, I’m having issue pulling modbus data into Ignition. Using Modpoll I am able to pull the correct data from the Modbus gateway using the following command. modpoll -t4:float -f -0 -r 16 -c 62 -l 10 192.168.1.100 -t … --- ## [Make the settime() changable](https://forum.inductiveautomation.com/t/make-the-settime-changable/62257)
**Author:** [@uy\_huynh](https://forum.inductiveautomation.com/u/uy_huynh)\ **Replies:** 3\ **Last updated:** [July 26, 2022, 8:51am UTC](https://forum.inductiveautomation.com/t/make-the-settime-changable/62257 "2022-07-26T08:51:20Z")
Hi all, I’m trying to set the date from components always at a certain time with settime(), but seems like this function makes the components can not be changed, it always change back to the settime(). Is there anyway w… --- ## [About the Identity Provider](https://forum.inductiveautomation.com/t/about-the-identity-provider/62285)
**Author:** [@Igor\_Listo](https://forum.inductiveautomation.com/u/Igor_Listo)\ **Replies:** 2\ **Last updated:** [July 26, 2022, 7:02am UTC](https://forum.inductiveautomation.com/t/about-the-identity-provider/62285 "2022-07-26T07:02:30Z")
Hello, I connecting Azure AD with OpenID and have next error in Ignition logs: at com.inductiveautomation.ignition.gateway.auth.idp.IdpAdapter.parseAttributes(IdpAdapter.java:122) at com.inductiveautomation.ignition.… --- ## [Httpget script unicode is improperly](https://forum.inductiveautomation.com/t/httpget-script-unicode-is-improperly/62261)
**Author:** [@Pofer\_Wang](https://forum.inductiveautomation.com/u/Pofer_Wang)\ **Replies:** 2\ **Last updated:** [July 26, 2022, 2:50am UTC](https://forum.inductiveautomation.com/t/httpget-script-unicode-is-improperly/62261 "2022-07-26T02:50:43Z")
Hello everyone, I have a problem. About scripty httpget() I have a URL : https://opendata.cwb.gov.tw/api/v1/rest/datastore/F-C0032-001?Authorization=CWB-BEF23F74-BCE9-4055-8F2D-BFD879239878&locationName=高雄市&elementName… --- ## [Adding an automatic trigger on history provider table](https://forum.inductiveautomation.com/t/adding-an-automatic-trigger-on-history-provider-table/62272)
**Author:** [@brian\_carisey](https://forum.inductiveautomation.com/u/brian_carisey)\ **Replies:** 5\ **Last updated:** [July 25, 2022, 7:13pm UTC](https://forum.inductiveautomation.com/t/adding-an-automatic-trigger-on-history-provider-table/62272 "2022-07-25T19:13:31Z")
Hello, I’m currently using history provider to store my data on a mysql database. My issue is the following : The table is reaching a size that is creating issues(15 Gb). I saw that there is a way to partition the dat… --- ## [SQL formatting problem](https://forum.inductiveautomation.com/t/sql-formatting-problem/62281)
**Author:** [@Kfoldesi](https://forum.inductiveautomation.com/u/Kfoldesi)\ **Replies:** 3\ **Last updated:** [July 25, 2022, 6:48pm UTC](https://forum.inductiveautomation.com/t/sql-formatting-problem/62281 "2022-07-25T18:48:48Z")
What can I do to resolve this? My script for the Delete button running onClick() MyText = self.parent.parent.getChild(Table).props.selection.data\[0\].id ID = MyText MyFunc.MsgBox(ID) system.db.runNamedQu… --- ## [Dash icon for multiple selection in security settings](https://forum.inductiveautomation.com/t/dash-icon-for-multiple-selection-in-security-settings/62109)
**Author:** [@yin.cheng](https://forum.inductiveautomation.com/u/yin.cheng)\ **Replies:** 5\ **Last updated:** [July 25, 2022, 6:06pm UTC](https://forum.inductiveautomation.com/t/dash-icon-for-multiple-selection-in-security-settings/62109 "2022-07-25T18:06:47Z")
Hi all, i am using v8.1.7 I realised when i select multiple components and tried to do some security settings, instead of the common tick and untick options, there is a ‘-’ option. Tried to search around in the manual,… --- ## [SQL Query Return all values equal to specific value](https://forum.inductiveautomation.com/t/sql-query-return-all-values-equal-to-specific-value/62270)
**Author:** [@csilk](https://forum.inductiveautomation.com/u/csilk)\ **Replies:** 3\ **Last updated:** [July 25, 2022, 4:25pm UTC](https://forum.inductiveautomation.com/t/sql-query-return-all-values-equal-to-specific-value/62270 "2022-07-25T16:25:06Z")
I have the following database: I have a button that I has the following script: checkReports = system.db.runScalarQuery("SELECT Client FROM Tracker WHERE SendReminder IN ('X')") self.getSibling("TextField").props.tex… --- ## [Tab container and box shadow](https://forum.inductiveautomation.com/t/tab-container-and-box-shadow/62255)
**Author:** [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\ **Replies:** 8\ **Last updated:** [July 25, 2022, 3:56pm UTC](https://forum.inductiveautomation.com/t/tab-container-and-box-shadow/62255 "2022-07-25T15:56:37Z")
Good morning, I would like to remove the box shadow of the tab container; I see inspecting it that the default grey color should be made in this lines: .ia\_tabContainerComponent\_\_tab--modern--active { font-weight: … --- ## [IsAlarmActive() expression function poor performance](https://forum.inductiveautomation.com/t/isalarmactive-expression-function-poor-performance/14867)
**Author:** [@alexraymond](https://forum.inductiveautomation.com/u/alexraymond)\ **Replies:** 7\ **Last updated:** [July 25, 2022, 3:26pm UTC](https://forum.inductiveautomation.com/t/isalarmactive-expression-function-poor-performance/14867 "2022-07-25T15:26:51Z")
Can anyone shed light on some performance issues I've had with this expression function? I tried using this expression an alarm tag inside of a UDT in the following way: High Level Tag (Bool): If (Level \> SP || ( is… --- ## [Can we derive history from historical tag - duration above a certain value](https://forum.inductiveautomation.com/t/can-we-derive-history-from-historical-tag-duration-above-a-certain-value/62224)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 2\ **Last updated:** [July 25, 2022, 3:07pm UTC](https://forum.inductiveautomation.com/t/can-we-derive-history-from-historical-tag-duration-above-a-certain-value/62224 "2022-07-25T15:07:02Z")
I have a tag monitoring an analog process value. It has been logged in the historian for many months. I’m displaying the value on a PowerChart. I would like to add a label below the chart showing the amount of time the … --- ## [Ignition to Delta Lake connection](https://forum.inductiveautomation.com/t/ignition-to-delta-lake-connection/62264)
**Author:** [@rahman.tarek](https://forum.inductiveautomation.com/u/rahman.tarek)\ **Replies:** 1\ **Last updated:** [July 25, 2022, 2:32pm UTC](https://forum.inductiveautomation.com/t/ignition-to-delta-lake-connection/62264 "2022-07-25T14:32:06Z")
Hi there, I was wondering if it is possible to connect Ignition to Delta Lake and if so how would i go about doing it? Would i have to setup a manual JDBC driver and translator in the Gateway? Home | Delta Lake --- ## [Write Boolean Tag Error](https://forum.inductiveautomation.com/t/write-boolean-tag-error/62262)
**Author:** [@Jason\_Hsu](https://forum.inductiveautomation.com/u/Jason_Hsu)\ **Replies:** 2\ **Last updated:** [July 25, 2022, 11:53am UTC](https://forum.inductiveautomation.com/t/write-boolean-tag-error/62262 "2022-07-25T11:53:17Z")
I’d like to write bool tag by gateway event but sometimes it gives error as below. I have no idea why the error occurred randomly? It sometimes works but sometimes error occurs. Ignition Version: 8.1.13 Gateway Event Sc… --- ## [Perspective dropdown - disable text entry](https://forum.inductiveautomation.com/t/perspective-dropdown-disable-text-entry/62193)
**Author:** [@richardNZ15](https://forum.inductiveautomation.com/u/richardNZ15)\ **Replies:** 7\ **Last updated:** [July 25, 2022, 1:05am UTC](https://forum.inductiveautomation.com/t/perspective-dropdown-disable-text-entry/62193 "2022-07-25T01:05:23Z")
Why is there no property to disable text entry on a Perspective dropdown? Similar to the Editable property in the Vision text components. Surely non-editable dropdowns are more widely used than dropdowns that need the … --- ## [REPORT - table group only shows the row 0](https://forum.inductiveautomation.com/t/report-table-group-only-shows-the-row-0/62246)
**Author:** [@gmiroclosa](https://forum.inductiveautomation.com/u/gmiroclosa)\ **Replies:** 1\ **Last updated:** [July 24, 2022, 2:45pm UTC](https://forum.inductiveautomation.com/t/report-table-group-only-shows-the-row-0/62246 "2022-07-24T14:45:06Z")
Hi everybody, I’ve a report and a table group, the child table only shows the row 0 when, on details table, the property Page break = 0. Otherwise, if I put Page break = 1 I have all rows but in diferent pages. How co… --- ## [Tags Provider issue to get OPCUA tags](https://forum.inductiveautomation.com/t/tags-provider-issue-to-get-opcua-tags/62251)
**Author:** [@vnayal](https://forum.inductiveautomation.com/u/vnayal)\ **Replies:** 1\ **Last updated:** [July 24, 2022, 1:24pm UTC](https://forum.inductiveautomation.com/t/tags-provider-issue-to-get-opcua-tags/62251 "2022-07-24T13:24:41Z")
I am unable to get OPC UA tags in different tag provider. In one tag provieder I am getting values and in aother it is showing bad\_notconnected. --- ## [Ignition 7.9 with kepware RedundancyMaster2 Problem](https://forum.inductiveautomation.com/t/ignition-7-9-with-kepware-redundancymaster2-problem/62249)
**Author:** [@JONGMIN\_LEE](https://forum.inductiveautomation.com/u/JONGMIN_LEE)\ **Replies:** 0\ **Last updated:** [July 24, 2022, 4:40am UTC](https://forum.inductiveautomation.com/t/ignition-7-9-with-kepware-redundancymaster2-problem/62249 "2022-07-24T04:40:31Z")
My customer is running two kepserver OPCs. Each OPC server is connected to a different port of the same PLC, and there is no problem with each PLC connection. And the connection and read/write operation from the Ignitio… --- ## [Descending and ascending columns](https://forum.inductiveautomation.com/t/descending-and-ascending-columns/62203)
**Author:** [@Conn\_Mccurdy](https://forum.inductiveautomation.com/u/Conn_Mccurdy)\ **Replies:** 10\ **Last updated:** [July 23, 2022, 8:02am UTC](https://forum.inductiveautomation.com/t/descending-and-ascending-columns/62203 "2022-07-23T08:02:29Z")
Does the sort function work in tables for anyone else or is there something i have to do to get it to sort my data the way I want it to. So I want my data to be showing the most recent values at the top of my table but … --- ## [How do I interface with device properties setting?](https://forum.inductiveautomation.com/t/how-do-i-interface-with-device-properties-setting/62240)
**Author:** [@wildbilly](https://forum.inductiveautomation.com/u/wildbilly)\ **Replies:** 6\ **Last updated:** [July 22, 2022, 11:59pm UTC](https://forum.inductiveautomation.com/t/how-do-i-interface-with-device-properties-setting/62240 "2022-07-22T23:59:38Z")
you can supply the device add function these keys when adding… but how would someone query them and edit them after the fact? I don’t see them in config.idb :confused: is there a way? --- ## [Insert into database only if the entry doesn't exist](https://forum.inductiveautomation.com/t/insert-into-database-only-if-the-entry-doesnt-exist/35122)
**Author:** [@smcfarlane](https://forum.inductiveautomation.com/u/smcfarlane)\ **Replies:** 11\ **Last updated:** [July 22, 2022, 8:55pm UTC](https://forum.inductiveautomation.com/t/insert-into-database-only-if-the-entry-doesnt-exist/35122 "2022-07-22T20:55:17Z")
I have a perspective view where I am adding users to a database on a button event script. I want to prevent duplicate names from being added, in other words if the name already exists in the table, don’t add the entry an… --- ## [Importing Weather into Ignition](https://forum.inductiveautomation.com/t/importing-weather-into-ignition/19972)
**Author:** [@agweb.salinas](https://forum.inductiveautomation.com/u/agweb.salinas)\ **Replies:** 2\ **Last updated:** [July 22, 2022, 8:39pm UTC](https://forum.inductiveautomation.com/t/importing-weather-into-ignition/19972 "2022-07-22T20:39:06Z")
Hey all, So I'm trying to import weather into ignition and from what I've see out there, the best way to go about doing this is using an XML. the code I have been referencing has been provided by another user https:/… --- ## [Compare t\_stamp with datatime tag in query](https://forum.inductiveautomation.com/t/compare-t-stamp-with-datatime-tag-in-query/62210)
**Author:** [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\ **Replies:** 5\ **Last updated:** [July 22, 2022, 8:12pm UTC](https://forum.inductiveautomation.com/t/compare-t-stamp-with-datatime-tag-in-query/62210 "2022-07-22T20:12:41Z")
Good morning guys, in perspective I have a DateTime Input components; its value props is binded to a DateTime memory tag (format string = “yyyy-MM-dd h:mm:ss aa” as default). I create a query in a query tag and I’m try… --- ## [Default No historical tag information could be found for any of the specified paths](https://forum.inductiveautomation.com/t/default-no-historical-tag-information-could-be-found-for-any-of-the-specified-paths/62232)
**Author:** [@mokam](https://forum.inductiveautomation.com/u/mokam)\ **Replies:** 1\ **Last updated:** [July 22, 2022, 6:43pm UTC](https://forum.inductiveautomation.com/t/default-no-historical-tag-information-could-be-found-for-any-of-the-specified-paths/62232 "2022-07-22T18:43:08Z")
Hi All, Mysql Ignition 8.0.17 I’have some issue adding tags to the historian. I’M not able to find my new tags in the table sqlth\_te In the gateway logs I found the message default No historical tag information cou… --- ## [Expression tag to alarm several other tag values](https://forum.inductiveautomation.com/t/expression-tag-to-alarm-several-other-tag-values/62227)
**Author:** [@Michael\_De\_Santis](https://forum.inductiveautomation.com/u/Michael_De_Santis)\ **Replies:** 5\ **Last updated:** [July 22, 2022, 6:14pm UTC](https://forum.inductiveautomation.com/t/expression-tag-to-alarm-several-other-tag-values/62227 "2022-07-22T18:14:49Z")
We are using the SMS to module to send out alarms to our plant personnel. I am trying to create an expression tag in which I can just tell the system that at a certain time, it would go into alarm and run this script to … --- ## [How to select a tag in the Tag Browse Tree through scripting](https://forum.inductiveautomation.com/t/how-to-select-a-tag-in-the-tag-browse-tree-through-scripting/62221)
**Author:** [@YF129701](https://forum.inductiveautomation.com/u/YF129701)\ **Replies:** 4\ **Last updated:** [July 22, 2022, 5:08pm UTC](https://forum.inductiveautomation.com/t/how-to-select-a-tag-in-the-tag-browse-tree-through-scripting/62221 "2022-07-22T17:08:39Z")
As the title says, I have a view with a Tag Browse Tree component. On that view, I have a parameter called tagPath and I want to be able to pass in a path and it be selected in the Tag Browse Tree automatically… There is… --- ## [\[IGN-6344\] Frontend/Backend gateways - Perspective system.tag.write\* causing two audit entries](https://forum.inductiveautomation.com/t/ign-6344-frontend-backend-gateways-perspective-system-tag-write-causing-two-audit-entries/62099)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 4\ **Last updated:** [July 22, 2022, 4:40pm UTC](https://forum.inductiveautomation.com/t/ign-6344-frontend-backend-gateways-perspective-system-tag-write-causing-two-audit-entries/62099 "2022-07-22T16:40:09Z")
Split Gateway architecture, Frontend and Backend. Recently upgraded from 8.1.5 to 8.1.18. I’ve just noticed that calling system.tag.write\* in Perspective, not affecting Vision (haven’t specifically checked anywhere els… --- ## [Perspective File Upload - No error catching/reporting for user](https://forum.inductiveautomation.com/t/perspective-file-upload-no-error-catching-reporting-for-user/62188)
**Author:** [@Ben\_Walker](https://forum.inductiveautomation.com/u/Ben_Walker)\ **Replies:** 3\ **Last updated:** [July 22, 2022, 4:37pm UTC](https://forum.inductiveautomation.com/t/perspective-file-upload-no-error-catching-reporting-for-user/62188 "2022-07-22T16:37:41Z")
Hey, I’m on Edge (8.1.18) and I’m using the File Upload control in Perspective in a Workstation Kiosk environment. I noticed that if I simulate an error on the onFileReceived event.file.copyTo() method, such as a broken… --- ## [CommonAlarmProperties](https://forum.inductiveautomation.com/t/commonalarmproperties/62222)
**Author:** [@aspatchek2013](https://forum.inductiveautomation.com/u/aspatchek2013)\ **Replies:** 2\ **Last updated:** [July 22, 2022, 3:41pm UTC](https://forum.inductiveautomation.com/t/commonalarmproperties/62222 "2022-07-22T15:41:33Z")
I am looking for some documentation on the following: from com.inductiveautomation.ignition.common.alarming.config import CommonAlarmProperties I have found others using it on the forum. I am implementing it in some co… --- ## ["gateway connection lost" Secondary desktop window not freezing](https://forum.inductiveautomation.com/t/gateway-connection-lost-secondary-desktop-window-not-freezing/62172)
**Author:** [@rpavlicek](https://forum.inductiveautomation.com/u/rpavlicek)\ **Replies:** 1\ **Last updated:** [July 22, 2022, 2:46pm UTC](https://forum.inductiveautomation.com/t/gateway-connection-lost-secondary-desktop-window-not-freezing/62172 "2022-07-22T14:46:18Z")
In Vision (8.1.10), we have a data entry form that utilizes live updates. When there is a disconnect from the gateway, we actually want the “Gateway connection lost” message box to come up and freeze the screen. This p… --- ## [\[SOLVED\] Parse a table returned from a named query](https://forum.inductiveautomation.com/t/solved-parse-a-table-returned-from-a-named-query/35950)
**Author:** [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Replies:** 12\ **Last updated:** [July 22, 2022, 1:59pm UTC](https://forum.inductiveautomation.com/t/solved-parse-a-table-returned-from-a-named-query/35950 "2022-07-22T13:59:09Z")
What is the syntax to call a named query and parse the results in Ignition scripting? tbl = system.db.runNamedQuery("projectName", "somePath/selectStuff", {}) if tbl.getRowCount() \> 0: keyID = tbl\[0\]\[0\] someTex… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=804) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=806)