# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=806 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 807 --- ## [\[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… --- ## [How to get initial value from queryTagHistory](https://forum.inductiveautomation.com/t/how-to-get-initial-value-from-querytaghistory/62179)
**Author:** [@fleclerc](https://forum.inductiveautomation.com/u/fleclerc)\ **Replies:** 5\ **Last updated:** [July 22, 2022, 1:29pm UTC](https://forum.inductiveautomation.com/t/how-to-get-initial-value-from-querytaghistory/62179 "2022-07-22T13:29:36Z")
When using system.tag.queryTagHistory, I have NULL as value until there is a change for that tag. How can I get the initial value of each tag at start time? In the picture, before Mode changes to MODE\_AUTOMATIC it w… --- ## [system.tag.queryTagHistory - gives uncertain initial value error](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-gives-uncertain-initial-value-error/62192)
**Author:** [@Ravi\_Iyer](https://forum.inductiveautomation.com/u/Ravi_Iyer)\ **Replies:** 4\ **Last updated:** [July 22, 2022, 12:16pm UTC](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-gives-uncertain-initial-value-error/62192 "2022-07-22T12:16:07Z")
Hi I am trying to access historical value of a tag (value about a minute ago) (and subtract it from value now, to get the difference). I am getting error ‘uncertain initial value’. Here is my tag editor - script. e… --- ## [Average Value Missing End of Data When Querying Historian Tag](https://forum.inductiveautomation.com/t/average-value-missing-end-of-data-when-querying-historian-tag/62202)
**Author:** [@Ryan\_Price](https://forum.inductiveautomation.com/u/Ryan_Price)\ **Replies:** 6\ **Last updated:** [July 22, 2022, 12:13pm UTC](https://forum.inductiveautomation.com/t/average-value-missing-end-of-data-when-querying-historian-tag/62202 "2022-07-22T12:13:37Z")
Hi, I'm wondering if anyone can help with a problem I've been having. I'm using Ignition 8.1 and Vision. I have Ignition set up to monitor PLC tags from a production machine. Of these tags, I am historically trending a… --- ## [Changing from SQL server to ignition historian](https://forum.inductiveautomation.com/t/changing-from-sql-server-to-ignition-historian/61856)
**Author:** [@Conn\_Mccurdy](https://forum.inductiveautomation.com/u/Conn_Mccurdy)\ **Replies:** 15\ **Last updated:** [July 22, 2022, 8:51am UTC](https://forum.inductiveautomation.com/t/changing-from-sql-server-to-ignition-historian/61856 "2022-07-22T08:51:54Z")
So I have a database in SQL that only shows data for the moth that we are currently in. I am looking for a way to either have the name of the database update automatically every month or just use ignition itself to store… --- ## [Easy Chart Default Settings](https://forum.inductiveautomation.com/t/easy-chart-default-settings/61865)
**Author:** [@cody.abbott](https://forum.inductiveautomation.com/u/cody.abbott)\ **Replies:** 1\ **Last updated:** [July 21, 2022, 10:59pm UTC](https://forum.inductiveautomation.com/t/easy-chart-default-settings/61865 "2022-07-21T22:59:36Z")
What’s the best way to make pens take on a desired style when tags are dragged and dropped from a tag browse tree? Every time I add a new tag, I need to change the style to digital. --- ## [Ignition connect to Omron OPC server Faulted](https://forum.inductiveautomation.com/t/ignition-connect-to-omron-opc-server-faulted/61911)
**Author:** [@Yung\_Chun\_Huang](https://forum.inductiveautomation.com/u/Yung_Chun_Huang)\ **Replies:** 1\ **Last updated:** [July 21, 2022, 10:50pm UTC](https://forum.inductiveautomation.com/t/ignition-connect-to-omron-opc-server-faulted/61911 "2022-07-21T22:50:32Z")
Hi all, I have two ignition gateway one running on Linux and another running on windows. For the ignition running on windows, it can easily connect to Omron PLC through OPC connections/servers. However, for the one dep… --- ## [Radar Chart - Automatic Labelling](https://forum.inductiveautomation.com/t/radar-chart-automatic-labelling/62048)
**Author:** [@A\_Power](https://forum.inductiveautomation.com/u/A_Power)\ **Replies:** 1\ **Last updated:** [July 21, 2022, 10:41pm UTC](https://forum.inductiveautomation.com/t/radar-chart-automatic-labelling/62048 "2022-07-21T22:41:47Z")
Figured I would follow this up in a new thread as it has been a few years now. In a nut shell - I want this (as per the manual) But from the looks of it having the labels and the readout values automatically is not … --- ## [SLC5/04, ABSLCBrowseRequest: Unable to read processor type, "P0:0" is not a valid address](https://forum.inductiveautomation.com/t/slc5-04-abslcbrowserequest-unable-to-read-processor-type-p0-0-is-not-a-valid-address/62169)
**Author:** [@Jacob\_Sanchez](https://forum.inductiveautomation.com/u/Jacob_Sanchez)\ **Replies:** 11\ **Last updated:** [July 21, 2022, 9:53pm UTC](https://forum.inductiveautomation.com/t/slc5-04-abslcbrowserequest-unable-to-read-processor-type-p0-0-is-not-a-valid-address/62169 "2022-07-21T21:53:45Z")
Whenever we restart the ignition gateway, one of our SLC5/04’s (out of 5) opc driver fails to connect. The error is as follows. com.inductiveautomation.xopc.driver.util.AddressNotFoundException: "P0:0" is not a valid ad… --- ## [User Login Time](https://forum.inductiveautomation.com/t/user-login-time/62174)
**Author:** [@Trevor\_Nelson](https://forum.inductiveautomation.com/u/Trevor_Nelson)\ **Replies:** 3\ **Last updated:** [July 21, 2022, 8:44pm UTC](https://forum.inductiveautomation.com/t/user-login-time/62174 "2022-07-21T20:44:10Z")
Is there a way to get the time that a user logged into your application? --- ## [Perspective - Unexpected problem unregistering listener from session event bus](https://forum.inductiveautomation.com/t/perspective-unexpected-problem-unregistering-listener-from-session-event-bus/39636)
**Author:** [@Devin](https://forum.inductiveautomation.com/u/Devin)\ **Replies:** 11\ **Last updated:** [July 21, 2022, 7:53pm UTC](https://forum.inductiveautomation.com/t/perspective-unexpected-problem-unregistering-listener-from-session-event-bus/39636 "2022-07-21T19:53:26Z")
Hi all, I'm getting the below error in my gateway logs referring to an expression binding on a Perspective label component. It seems to populate the error anytime I have the page active. Wondering if anyone has seen thi… --- ## [Switch Expression](https://forum.inductiveautomation.com/t/switch-expression/62143)
**Author:** [@Michael\_Smith](https://forum.inductiveautomation.com/u/Michael_Smith)\ **Replies:** 9\ **Last updated:** [July 21, 2022, 6:24pm UTC](https://forum.inductiveautomation.com/t/switch-expression/62143 "2022-07-21T18:24:20Z")
Hi there. I have a transaction group I’m trying to set up, and in that transaction group I have a expression item. Purpose of this expression item is to read a tag value and assign a string return based on the numeric … --- ## [8.1.2 TCP driver Binary Data](https://forum.inductiveautomation.com/t/8-1-2-tcp-driver-binary-data/43612)
**Author:** [@gregory.sachs](https://forum.inductiveautomation.com/u/gregory.sachs)\ **Replies:** 9\ **Last updated:** [July 21, 2022, 5:00pm UTC](https://forum.inductiveautomation.com/t/8-1-2-tcp-driver-binary-data/43612 "2022-07-21T17:00:00Z")
In 8.1.2, the new MessageBytes and WritableBytes tags were added, to allow binary data to be sent/received from a TCP device. I’m trying to do a socket stream to a device on port 4001, where I send it 0x020x000x010x01 f… --- ## [Rearrange Legend Labels XYChart](https://forum.inductiveautomation.com/t/rearrange-legend-labels-xychart/62168)
**Author:** [@danieltalbot](https://forum.inductiveautomation.com/u/danieltalbot)\ **Replies:** 1\ **Last updated:** [July 21, 2022, 4:36pm UTC](https://forum.inductiveautomation.com/t/rearrange-legend-labels-xychart/62168 "2022-07-21T16:36:15Z")
If I change the order of my series it rearranges the order of the labels in the legend, but it also rearranges the order of the columns in the chart. Can anyone help me get the legend labels to match the column? I … --- ## [Can Ignition expose JMX metrics?](https://forum.inductiveautomation.com/t/can-ignition-expose-jmx-metrics/62165)
**Author:** [@Jordan\_Larson](https://forum.inductiveautomation.com/u/Jordan_Larson)\ **Replies:** 2\ **Last updated:** [July 21, 2022, 3:43pm UTC](https://forum.inductiveautomation.com/t/can-ignition-expose-jmx-metrics/62165 "2022-07-21T15:43:52Z")
I checked for any previously related thread and there was one a few years ago regarding VisualVM and a link that no longer existed but it sort of seemed to be on the right track We used Datadog for monitoring and they h… --- ## [Ignition Multiple OPC Tags](https://forum.inductiveautomation.com/t/ignition-multiple-opc-tags/61961)
**Author:** [@Carlos\_Dominguez](https://forum.inductiveautomation.com/u/Carlos_Dominguez)\ **Replies:** 2\ **Last updated:** [July 21, 2022, 3:31pm UTC](https://forum.inductiveautomation.com/t/ignition-multiple-opc-tags/61961 "2022-07-21T15:31:56Z")
Hello Guys I have 4 PLC’s connected to ignition. I want to create a tag into Ignition to modify the same 4 tags each one. Is there a option to do this? Thanks! --- ## [Access Dataset from Named Query](https://forum.inductiveautomation.com/t/access-dataset-from-named-query/62166)
**Author:** [@jwilliams](https://forum.inductiveautomation.com/u/jwilliams)\ **Replies:** 1\ **Last updated:** [July 21, 2022, 2:46pm UTC](https://forum.inductiveautomation.com/t/access-dataset-from-named-query/62166 "2022-07-21T14:46:41Z")
I have a table that gets populated based on a Named Query. I am trying to find out how to access that dataset through scripting. I know it is possible to access them from this documentation (Datasets - Ignition User Manu… --- ## [Script's query handling](https://forum.inductiveautomation.com/t/scripts-query-handling/62157)
**Author:** [@mori.luca](https://forum.inductiveautomation.com/u/mori.luca)\ **Replies:** 3\ **Last updated:** [July 21, 2022, 2:37pm UTC](https://forum.inductiveautomation.com/t/scripts-query-handling/62157 "2022-07-21T14:37:23Z")
Hi, I though that every single query in a script would run inside it’s own transaction, but recently speaking with a developer, he told me that once he had deadlock issues and they solved it by placing every single quer… --- ## [New Install, observing "trustAnchors parameter must be non-empty" in the error logs](https://forum.inductiveautomation.com/t/new-install-observing-trustanchors-parameter-must-be-non-empty-in-the-error-logs/59157)
**Author:** [@Jordan\_Larson](https://forum.inductiveautomation.com/u/Jordan_Larson)\ **Replies:** 13\ **Last updated:** [July 21, 2022, 2:11pm UTC](https://forum.inductiveautomation.com/t/new-install-observing-trustanchors-parameter-must-be-non-empty-in-the-error-logs/59157 "2022-07-21T14:11:54Z")
Greetings! I have a new installation of a 8.1.16 Gateway running on RHEL 8.5 latest. We are using Lets Encrypt certificates pulled via Hashicorp Vault Agent, that basically triggers the script referenced in this wonder… --- ## [Change the Named Query Path](https://forum.inductiveautomation.com/t/change-the-named-query-path/62161)
**Author:** [@jwilliams](https://forum.inductiveautomation.com/u/jwilliams)\ **Replies:** 1\ **Last updated:** [July 21, 2022, 1:12pm UTC](https://forum.inductiveautomation.com/t/change-the-named-query-path/62161 "2022-07-21T13:12:29Z")
Is it possible to change the Named Query being run based on a value chosen in a dropdown list? I have a dropdown list that is responsible for returning users from a named query with results like this: Where the number … --- ## [Need to update certain tags based on the value change of one tag](https://forum.inductiveautomation.com/t/need-to-update-certain-tags-based-on-the-value-change-of-one-tag/62152)
**Author:** [@Killmonger](https://forum.inductiveautomation.com/u/Killmonger)\ **Replies:** 4\ **Last updated:** [July 21, 2022, 9:20am UTC](https://forum.inductiveautomation.com/t/need-to-update-certain-tags-based-on-the-value-change-of-one-tag/62152 "2022-07-21T09:20:14Z")
Hi, I have a UDT of 5 pumps, they have the same named 10 tags each, I need to store the other 9 tags for each of those 5 pumps on the basis of a change of one tag(same for all pumps) for each pump. I need to store it in … --- ## [Having difficulty getting a security level rule to work](https://forum.inductiveautomation.com/t/having-difficulty-getting-a-security-level-rule-to-work/39667)
**Author:** [@RichardPriest](https://forum.inductiveautomation.com/u/RichardPriest)\ **Replies:** 4\ **Last updated:** [July 21, 2022, 7:20am UTC](https://forum.inductiveautomation.com/t/having-difficulty-getting-a-security-level-rule-to-work/39667 "2022-07-21T07:20:58Z")
I’m trying to configure an expression in a Public rule that will enable the level whenever a string tag “Security” is set to “Active” and disable otherwise. A boolean tag would also be an option. I’ve had no luck trying… --- ## [PowerChart Trend Browse tags delete](https://forum.inductiveautomation.com/t/powerchart-trend-browse-tags-delete/62150)
**Author:** [@Pofer\_Wang](https://forum.inductiveautomation.com/u/Pofer_Wang)\ **Replies:** 1\ **Last updated:** [July 21, 2022, 4:01am UTC](https://forum.inductiveautomation.com/t/powerchart-trend-browse-tags-delete/62150 "2022-07-21T04:01:18Z")
Hello everyone, I have a problem. About history data I had two tag use history enable,and I stop it now. But my PowerChart’s browse tags still exists tag. Have one meet the problem too? --- ## [Selecting multiple datasets, returning output parameters and returns with stored procedures](https://forum.inductiveautomation.com/t/selecting-multiple-datasets-returning-output-parameters-and-returns-with-stored-procedures/62145)
**Author:** [@stuart.williams](https://forum.inductiveautomation.com/u/stuart.williams)\ **Replies:** 2\ **Last updated:** [July 21, 2022, 2:11am UTC](https://forum.inductiveautomation.com/t/selecting-multiple-datasets-returning-output-parameters-and-returns-with-stored-procedures/62145 "2022-07-21T02:11:57Z")
Hi everyone, I am in the process of moving all of a customer’s OEE calculation’s from the front end to their MSSQL database. I am writing stored procedures to get all the data and return the calculated values along with… --- ## [Efficient way to filter alarm on priority, alarm journal as a data source in reporting](https://forum.inductiveautomation.com/t/efficient-way-to-filter-alarm-on-priority-alarm-journal-as-a-data-source-in-reporting/62149)
**Author:** [@marcg](https://forum.inductiveautomation.com/u/marcg)\ **Replies:** 0\ **Last updated:** [July 21, 2022, 1:41am UTC](https://forum.inductiveautomation.com/t/efficient-way-to-filter-alarm-on-priority-alarm-journal-as-a-data-source-in-reporting/62149 "2022-07-21T01:41:25Z")
Query alarms based on priority. --- ## [Perspective App - ios devices - Take picture and send/save the file into the network (server/ folder)](https://forum.inductiveautomation.com/t/perspective-app-ios-devices-take-picture-and-send-save-the-file-into-the-network-server-folder/62146)
**Author:** [@edwinfreirec](https://forum.inductiveautomation.com/u/edwinfreirec)\ **Replies:** 1\ **Last updated:** [July 20, 2022, 10:05pm UTC](https://forum.inductiveautomation.com/t/perspective-app-ios-devices-take-picture-and-send-save-the-file-into-the-network-server-folder/62146 "2022-07-20T22:05:15Z")
Hi All, We are developing an application with Perspective 8.1.16, where we are using Perspective App in mobile devices (ios devices). Between the features, it is required to take a pictures with ios devices (iPad), and … --- ## [Latched value not writing to DB once executed on transaction group](https://forum.inductiveautomation.com/t/latched-value-not-writing-to-db-once-executed-on-transaction-group/61920)
**Author:** [@Raymond\_Sipes](https://forum.inductiveautomation.com/u/Raymond_Sipes)\ **Replies:** 1\ **Last updated:** [July 20, 2022, 9:54pm UTC](https://forum.inductiveautomation.com/t/latched-value-not-writing-to-db-once-executed-on-transaction-group/61920 "2022-07-20T21:54:04Z")
Hello! I have a transaction group set up to executed once the status submit boolean is set to true. This all works correctly but the data is not being written to the DB. This is the stored procedure I have for the trans… --- ## [Kafka and Ignition 8](https://forum.inductiveautomation.com/t/kafka-and-ignition-8/34051)
**Author:** [@Jason.klingman](https://forum.inductiveautomation.com/u/Jason.klingman)\ **Replies:** 7\ **Last updated:** [July 20, 2022, 8:52pm UTC](https://forum.inductiveautomation.com/t/kafka-and-ignition-8/34051 "2022-07-20T20:52:32Z")
Hello, I am trying to connect to my company’s Kafka instance from Ignition. We have connected to other pub/sub platforms like IBM MQ via MQTT but I cannot find how to connect to Kafka. Can anyone share how they were ab… --- ## [How to clear this error application launcher?](https://forum.inductiveautomation.com/t/how-to-clear-this-error-application-launcher/62010)
**Author:** [@Adarsh\_Shelar](https://forum.inductiveautomation.com/u/Adarsh_Shelar)\ **Replies:** 3\ **Last updated:** [July 20, 2022, 8:30pm UTC](https://forum.inductiveautomation.com/t/how-to-clear-this-error-application-launcher/62010 "2022-07-20T20:30:20Z")
while launching the RunTime Aplication i am facing this error. --- ## [Perspective Property binding and scripting parse error](https://forum.inductiveautomation.com/t/perspective-property-binding-and-scripting-parse-error/62144)
**Author:** [@mike4](https://forum.inductiveautomation.com/u/mike4)\ **Replies:** 3\ **Last updated:** [July 20, 2022, 8:26pm UTC](https://forum.inductiveautomation.com/t/perspective-property-binding-and-scripting-parse-error/62144 "2022-07-20T20:26:32Z")
Hi, I’m having trouble with my scripting to change the background color of some components. I am a beginner at python so any advice would be greatly appreciated! My goal is to turn the background color of each of the R… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=805) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=807)