# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=759 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 760 --- ## [\[IGN-5112\]Oracle and generated ids](https://forum.inductiveautomation.com/t/ign-5112-oracle-and-generated-ids/9238)
**Author:** [@ssorrell](https://forum.inductiveautomation.com/u/ssorrell)\ **Replies:** 3\ **Last updated:** [October 25, 2022, 7:08pm UTC](https://forum.inductiveautomation.com/t/ign-5112-oracle-and-generated-ids/9238 "2022-10-25T19:08:51Z")
The typical ignition method of getting the generated id by adding getKey=1 to the runPrepQuery call throws a java exception indicating that getInt() is not supported. I modified the driver config to add support for getK… --- ## [Screen changes on one clients PC when another client changes a screen on another PC](https://forum.inductiveautomation.com/t/screen-changes-on-one-clients-pc-when-another-client-changes-a-screen-on-another-pc/65659)
**Author:** [@drinaldi](https://forum.inductiveautomation.com/u/drinaldi)\ **Replies:** 10\ **Last updated:** [October 25, 2022, 6:10pm UTC](https://forum.inductiveautomation.com/t/screen-changes-on-one-clients-pc-when-another-client-changes-a-screen-on-another-pc/65659 "2022-10-25T18:10:02Z")
ignition 8.1.19 vision clients Having a funny issue. two clients viewing screens, one clients changes to a different screen, and the other users screens changes also to that screen. Why would this happen??? Thanks --- ## [Functionality question, clicking on a row in a table in perspective to pull up another view](https://forum.inductiveautomation.com/t/functionality-question-clicking-on-a-row-in-a-table-in-perspective-to-pull-up-another-view/65307)
**Author:** [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Replies:** 31\ **Last updated:** [October 25, 2022, 4:10pm UTC](https://forum.inductiveautomation.com/t/functionality-question-clicking-on-a-row-in-a-table-in-perspective-to-pull-up-another-view/65307 "2022-10-25T16:10:40Z")
What is the best practice for letting users click on tables to direct them to pages with relevant data from the row in that table which they clicked on? Do you have a mouse up event and then run a script to detect the s… --- ## [How to display the last 3 values in a column horizontally](https://forum.inductiveautomation.com/t/how-to-display-the-last-3-values-in-a-column-horizontally/65490)
**Author:** [@Brennan\_Joles](https://forum.inductiveautomation.com/u/Brennan_Joles)\ **Replies:** 6\ **Last updated:** [October 25, 2022, 3:30pm UTC](https://forum.inductiveautomation.com/t/how-to-display-the-last-3-values-in-a-column-horizontally/65490 "2022-10-25T15:30:59Z")
I have the following named query: SELECT TOP 3\* FROM (SELECT schedOverTimemins as last5, TableNum FROM Tables\_Data\_East\_V2 WHERE TableNum = 5 ) AS SUBQUERYB WHERE last5 IS NOT NULL How would I display the… --- ## [Perspective - Scripting - Valid if view exists](https://forum.inductiveautomation.com/t/perspective-scripting-valid-if-view-exists/48128)
**Author:** [@luc.martin](https://forum.inductiveautomation.com/u/luc.martin)\ **Replies:** 2\ **Last updated:** [October 25, 2022, 2:33pm UTC](https://forum.inductiveautomation.com/t/perspective-scripting-valid-if-view-exists/48128 "2022-10-25T14:33:50Z")
8.1.7 Is their a trick to check if a view exist ? I want to root an embeded view according to the existance or not of a view. --- ## [Identity Provider Idp Security Level Rules](https://forum.inductiveautomation.com/t/identity-provider-idp-security-level-rules/65637)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 2\ **Last updated:** [October 25, 2022, 1:31pm UTC](https://forum.inductiveautomation.com/t/identity-provider-idp-security-level-rules/65637 "2022-10-25T13:31:10Z")
Say I wanted to give a tag write permissions more complex than I can give with just roles, for example (pseudo-code): ({Authenticated/Roles/Operator} and {Authenticated/Roles/Area\_WWTP}) or {Authenticated/Roles/Master} … --- ## [New man in the field](https://forum.inductiveautomation.com/t/new-man-in-the-field/65007)
**Author:** [@Le\_Vy](https://forum.inductiveautomation.com/u/Le_Vy)\ **Replies:** 6\ **Last updated:** [October 25, 2022, 12:35pm UTC](https://forum.inductiveautomation.com/t/new-man-in-the-field/65007 "2022-10-25T12:35:44Z")
How can a new man start learning about ignition? --- ## [How I can import mySQL database into table on weddev module? Can I have some sample files?](https://forum.inductiveautomation.com/t/how-i-can-import-mysql-database-into-table-on-weddev-module-can-i-have-some-sample-files/65633)
**Author:** [@Le\_Vy](https://forum.inductiveautomation.com/u/Le_Vy)\ **Replies:** 1\ **Last updated:** [October 25, 2022, 12:33pm UTC](https://forum.inductiveautomation.com/t/how-i-can-import-mysql-database-into-table-on-weddev-module-can-i-have-some-sample-files/65633 "2022-10-25T12:33:47Z")
How I can import mySQL database into table on weddev module? Can I have some sample files? --- ## [Why NamedQuery can't run in Script](https://forum.inductiveautomation.com/t/why-namedquery-cant-run-in-script/65579)
**Author:** [@wangjun\_ming\_1996](https://forum.inductiveautomation.com/u/wangjun_ming_1996)\ **Replies:** 4\ **Last updated:** [October 25, 2022, 12:28pm UTC](https://forum.inductiveautomation.com/t/why-namedquery-cant-run-in-script/65579 "2022-10-25T12:28:39Z")
Using ‘NameQuery’ to run in script program will report an error The Script: params = {'bay':'BAY4', 'lot':'593301'} system.db.runNamedQuery("Get\_Prev\_Thick", params) the 'Get\_Prev\_Thick' content is : SELECT attrib… --- ## [Perspective Flex Repeater Instances Updation](https://forum.inductiveautomation.com/t/perspective-flex-repeater-instances-updation/65505)
**Author:** [@John\_John](https://forum.inductiveautomation.com/u/John_John)\ **Replies:** 2\ **Last updated:** [October 25, 2022, 8:31am UTC](https://forum.inductiveautomation.com/t/perspective-flex-repeater-instances-updation/65505 "2022-10-25T08:31:55Z")
I have created Flex repeater with checkbox template. On change of checkbox, message handler is called. In the message handler received I am fetching the flex repeater instances. But Flex repeater instance updating after … --- ## [Problem with XY Chart and script transform](https://forum.inductiveautomation.com/t/problem-with-xy-chart-and-script-transform/65599)
**Author:** [@Michal\_Goralczyk](https://forum.inductiveautomation.com/u/Michal_Goralczyk)\ **Replies:** 9\ **Last updated:** [October 24, 2022, 2:43pm UTC](https://forum.inductiveautomation.com/t/problem-with-xy-chart-and-script-transform/65599 "2022-10-24T14:43:30Z")
Hi, I have a problem loading my chart on the perspective screen. I use the script to adjust what the XY chart shows depending on the situation. Script generates .json format for dataSources. When I load the window as a … --- ## [\[Feature\] Tag history interpolation by time period](https://forum.inductiveautomation.com/t/feature-tag-history-interpolation-by-time-period/65616)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 2\ **Last updated:** [October 24, 2022, 10:34pm UTC](https://forum.inductiveautomation.com/t/feature-tag-history-interpolation-by-time-period/65616 "2022-10-24T22:34:18Z")
Following on from my post, Tag history interpolation - not returning interpolated values, I would like to propose a better and more obvious interpolation. In a discussion with support the summary was, Basically, i… --- ## [Perspective Sensor Multiline](https://forum.inductiveautomation.com/t/perspective-sensor-multiline/65607)
**Author:** [@tj.holt](https://forum.inductiveautomation.com/u/tj.holt)\ **Replies:** 3\ **Last updated:** [October 25, 2022, 6:54am UTC](https://forum.inductiveautomation.com/t/perspective-sensor-multiline/65607 "2022-10-25T06:54:15Z")
I'd like to create a new line with the units of analog input on the bottom. I've tried expression with '\\n' and pre-wrap. The multiline editor shows 2 lines, but the component shows the value as 1. I'd like to avoid cr… --- ## [CSS :has new since 09-2022 Removes the C out of CSS!](https://forum.inductiveautomation.com/t/css-has-new-since-09-2022-removes-the-c-out-of-css/64515)
**Author:** [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\ **Replies:** 5\ **Last updated:** [October 25, 2022, 6:32am UTC](https://forum.inductiveautomation.com/t/css-has-new-since-09-2022-removes-the-c-out-of-css/64515 "2022-10-25T06:32:03Z")
Seems i missed something this month… Chrome edge and safari have released :has selector this month! Doubt it will be working in the designer anytime soon, but in the browser this is gonna be BIG! Gotta get your users … --- ## [Are invalid alarm notification pipelines defined in tags displayed as errors anywhere?](https://forum.inductiveautomation.com/t/are-invalid-alarm-notification-pipelines-defined-in-tags-displayed-as-errors-anywhere/65580)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 3\ **Last updated:** [October 24, 2022, 11:14pm UTC](https://forum.inductiveautomation.com/t/are-invalid-alarm-notification-pipelines-defined-in-tags-displayed-as-errors-anywhere/65580 "2022-10-24T23:14:55Z")
I've intentionally added a bogus prefix to some tag alarm notification profile names on some select tags that a site doesn't want paged out temporarily. When I tested it, the alarms didn't page out, but I also didn't see… --- ## [Uncertain initial value](https://forum.inductiveautomation.com/t/uncertain-initial-value/65597)
**Author:** [@mark\_fuller](https://forum.inductiveautomation.com/u/mark_fuller)\ **Replies:** 1\ **Last updated:** [October 24, 2022, 9:56pm UTC](https://forum.inductiveautomation.com/t/uncertain-initial-value/65597 "2022-10-24T21:56:40Z")
I have a digital tag from an OPC/UA device (advantech adam-6317). when I edit Tag Group from 'default' to any other group the Value shown in the tag browser shows "Uncertain\_InitialValue". i need this tag to be polled … --- ## [ESRI API Embedding in Ignition](https://forum.inductiveautomation.com/t/esri-api-embedding-in-ignition/16293)
**Author:** [@alexander.stevenson](https://forum.inductiveautomation.com/u/alexander.stevenson)\ **Replies:** 5\ **Last updated:** [October 24, 2022, 9:24pm UTC](https://forum.inductiveautomation.com/t/esri-api-embedding-in-ignition/16293 "2022-10-24T21:24:11Z")
I would like to know if there’s a way to embed the ESRI ArcGIS API for JavaScript or Python into Ignition. Appreciate the help in advance! --- ## [Vision Popup UDT Script Failure](https://forum.inductiveautomation.com/t/vision-popup-udt-script-failure/65610)
**Author:** [@Taylor.Johnson](https://forum.inductiveautomation.com/u/Taylor.Johnson)\ **Replies:** 2\ **Last updated:** [October 24, 2022, 8:58pm UTC](https://forum.inductiveautomation.com/t/vision-popup-udt-script-failure/65610 "2022-10-24T20:58:23Z")
Hello! I have made a template that uses a tab strip to 'select' different views for the operator. The issue I am having though is that when I try to do a button press, my old "button script" code is failing to pull the m… --- ## [Time series chart with grouped by hour](https://forum.inductiveautomation.com/t/time-series-chart-with-grouped-by-hour/65542)
**Author:** [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Replies:** 8\ **Last updated:** [October 24, 2022, 8:53pm UTC](https://forum.inductiveautomation.com/t/time-series-chart-with-grouped-by-hour/65542 "2022-10-24T20:53:32Z")
I am getting all the events in my query by grouping on format(t\_stamp, 'yyyy-MM-dd HH') However, data is not showing in my time series chart now. So I think I need a datetime conversion. What is a good way to overcome … --- ## [Drag and drop from tree view](https://forum.inductiveautomation.com/t/drag-and-drop-from-tree-view/27644)
**Author:** [@j.abrante](https://forum.inductiveautomation.com/u/j.abrante)\ **Replies:** 27\ **Last updated:** [October 24, 2022, 8:07pm UTC](https://forum.inductiveautomation.com/t/drag-and-drop-from-tree-view/27644 "2022-10-24T20:07:35Z")
Someone have a example to do a drag and drop a item from tree view to power table? I need to do the same of Tag Browse Tree --- ## [Typical Database Size](https://forum.inductiveautomation.com/t/typical-database-size/2859)
**Author:** [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\ **Replies:** 3\ **Last updated:** [October 24, 2022, 7:30pm UTC](https://forum.inductiveautomation.com/t/typical-database-size/2859 "2022-10-24T19:30:25Z")
I already know the answer I'm going to get to this question but I told our IT department that I'd ask so I apologize ahead of time for the dumb question.. :wink: We run a clustered instance MS SQL server setup at our… --- ## [Dealing with Dates, Times, & Timestamps are never easy!](https://forum.inductiveautomation.com/t/dealing-with-dates-times-timestamps-are-never-easy/45781)
**Author:** [@MikeAllgood](https://forum.inductiveautomation.com/u/MikeAllgood)\ **Replies:** 7\ **Last updated:** [October 24, 2022, 6:49pm UTC](https://forum.inductiveautomation.com/t/dealing-with-dates-times-timestamps-are-never-easy/45781 "2022-10-24T18:49:27Z")
I have need to compare a value from a Datetime field from SQL to the current time in a script. Unfortunately the value returned from my Name Query for the datetime value is of type java.sql.timestamp. When I try using t… --- ## [OPC-UA Maximum amount of subscriptions](https://forum.inductiveautomation.com/t/opc-ua-maximum-amount-of-subscriptions/65546)
**Author:** [@Yvain17](https://forum.inductiveautomation.com/u/Yvain17)\ **Replies:** 14\ **Last updated:** [October 24, 2022, 5:41pm UTC](https://forum.inductiveautomation.com/t/opc-ua-maximum-amount-of-subscriptions/65546 "2022-10-24T17:41:36Z")
Ignition 8.1.21 I am trying to add a PLC to my system that has its own OPC-UA server built in. I have added two of these types of PLC with their own OPC-UA and they work just fine. I set this 3rd PLC up the exact same w… --- ## [OPC tag write from DB table to OPC UDT data type](https://forum.inductiveautomation.com/t/opc-tag-write-from-db-table-to-opc-udt-data-type/17452)
**Author:** [@Mr.K001](https://forum.inductiveautomation.com/u/Mr.K001)\ **Replies:** 19\ **Last updated:** [October 24, 2022, 4:39pm UTC](https://forum.inductiveautomation.com/t/opc-tag-write-from-db-table-to-opc-udt-data-type/17452 "2022-10-24T16:39:32Z")
Hi guys, I have a UDT tag in the PLC Data\[99\] and each memeber is also a UDT data type so for example data\[0\] has Data\[0\].name ,Data\[0\].code, Data\[0\].level I also have a table that has 4 columns name,code,level and Tag(I… --- ## [Add transparency to built in theme color](https://forum.inductiveautomation.com/t/add-transparency-to-built-in-theme-color/65594)
**Author:** [@Alex\_Leech](https://forum.inductiveautomation.com/u/Alex_Leech)\ **Replies:** 2\ **Last updated:** [October 24, 2022, 3:10pm UTC](https://forum.inductiveautomation.com/t/add-transparency-to-built-in-theme-color/65594 "2022-10-24T15:10:54Z")
Hi all! Is it possible within an expression to add transparency to a built in theme color? For example, I'd like to take '--qual-1' which is bound to a backgroundColor prop, and within an expression, retrieve the HEX a… --- ## [Best way to dynamically create a 'header' row for conversion to csv file using UDT tag name](https://forum.inductiveautomation.com/t/best-way-to-dynamically-create-a-header-row-for-conversion-to-csv-file-using-udt-tag-name/65549)
**Author:** [@michael.black](https://forum.inductiveautomation.com/u/michael.black)\ **Replies:** 9\ **Last updated:** [October 24, 2022, 3:07pm UTC](https://forum.inductiveautomation.com/t/best-way-to-dynamically-create-a-header-row-for-conversion-to-csv-file-using-udt-tag-name/65549 "2022-10-24T15:07:44Z")
I have created a csv file from a tag history query but want to change the header row. I was thinking I could not show the header when converting to csv file using system.dataset.toCSV and then insert a custom row in the… --- ## [\[BUG-6767\] Perspective Disappearing Pipes in Perspective Clients](https://forum.inductiveautomation.com/t/bug-6767-perspective-disappearing-pipes-in-perspective-clients/65322)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 17\ **Last updated:** [October 24, 2022, 2:59pm UTC](https://forum.inductiveautomation.com/t/bug-6767-perspective-disappearing-pipes-in-perspective-clients/65322 "2022-10-24T14:59:41Z")
v8.1.21 Browser (Chrome) I'm finding that Perspective Pipes (using the piping tool) disappear randomly. e.g. What it should be: It's not possible to predict when it's going to remove pipes in the client. I thoug… --- ## [GE Fanuc 90-30 Ethernet Connection TCP](https://forum.inductiveautomation.com/t/ge-fanuc-90-30-ethernet-connection-tcp/28521)
**Author:** [@juang](https://forum.inductiveautomation.com/u/juang)\ **Replies:** 15\ **Last updated:** [October 24, 2022, 2:56pm UTC](https://forum.inductiveautomation.com/t/ge-fanuc-90-30-ethernet-connection-tcp/28521 "2022-10-24T14:56:48Z")
Has anyone connected to a GE Fanuc 90-30? if so how? and where you able to access the tags? how can i do the address ? --- ## [Perspective disable right click menu on touchscreen](https://forum.inductiveautomation.com/t/perspective-disable-right-click-menu-on-touchscreen/65595)
**Author:** [@dsui](https://forum.inductiveautomation.com/u/dsui)\ **Replies:** 2\ **Last updated:** [October 24, 2022, 2:50pm UTC](https://forum.inductiveautomation.com/t/perspective-disable-right-click-menu-on-touchscreen/65595 "2022-10-24T14:50:41Z")
I am currently developing a Perspective app using Ignition 8.1 and using a Google Chrome on a Phoenix HMI Panel PC (has Windows 10 OS) for the session. One of the pages has a set of buttons used for motor control; hold d… --- ## [Writing a value from a dataset tag](https://forum.inductiveautomation.com/t/writing-a-value-from-a-dataset-tag/65587)
**Author:** [@sebastien\_ng](https://forum.inductiveautomation.com/u/sebastien_ng)\ **Replies:** 12\ **Last updated:** [October 24, 2022, 1:47pm UTC](https://forum.inductiveautomation.com/t/writing-a-value-from-a-dataset-tag/65587 "2022-10-24T13:47:21Z")
Hello, I would like to update (add a row) to my tag dataset. I'am using this fonction : system.tag.writeBlocking(self.view.params.tagPath, self.view.params.listZone) When I try use this function, the old value on the d… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=758) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=760)