# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1304 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1305 --- ## [Duplicate a table row that is linked to another table with foriegn keys](https://forum.inductiveautomation.com/t/duplicate-a-table-row-that-is-linked-to-another-table-with-foriegn-keys/23834)
**Author:** [@bellm](https://forum.inductiveautomation.com/u/bellm)\ **Replies:** 8\ **Last updated:** [April 4, 2019, 3:23pm UTC](https://forum.inductiveautomation.com/t/duplicate-a-table-row-that-is-linked-to-another-table-with-foriegn-keys/23834 "2019-04-04T15:23:28Z")
Our customer has asked if we could add a copy button to our recipe screen. What they want is to select a row and press a copy button to duplicate that row and all the coat info. I have attached a screen shot of the scree… --- ## [CodeSys OPC Server Error](https://forum.inductiveautomation.com/t/codesys-opc-server-error/23849)
**Author:** [@mczaldivar](https://forum.inductiveautomation.com/u/mczaldivar)\ **Replies:** 0\ **Last updated:** [April 4, 2019, 2:03pm UTC](https://forum.inductiveautomation.com/t/codesys-opc-server-error/23849 "2019-04-04T14:03:03Z")
Hello, I am trying to connect to my codesys OPC server without success so far. I am using the Ignition OPC-COM and use Matrikon’s Explorer to verify that i can read tags and its works. Follow the log java.lang.Illegal… --- ## [Huge tables in Tag Historian](https://forum.inductiveautomation.com/t/huge-tables-in-tag-historian/23846)
**Author:** [@wofoster](https://forum.inductiveautomation.com/u/wofoster)\ **Replies:** 0\ **Last updated:** [April 4, 2019, 11:07am UTC](https://forum.inductiveautomation.com/t/huge-tables-in-tag-historian/23846 "2019-04-04T11:07:31Z")
Hi all: I have an issue with a huge database of tag historian with Millions of registers. I am trying to find the the root cause of this huge tables . I suspect some History scanclass can has any bad setup. In this cas… --- ## [Get the screen-relative coordinates of an open popup Window](https://forum.inductiveautomation.com/t/get-the-screen-relative-coordinates-of-an-open-popup-window/23842)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 0\ **Last updated:** [April 4, 2019, 4:28am UTC](https://forum.inductiveautomation.com/t/get-the-screen-relative-coordinates-of-an-open-popup-window/23842 "2019-04-04T04:28:53Z")
If I have a popup window open, how would I get its screen-relative coordinates? I’m after something identical to using system.gui.convertPointToScreen(…) for components on a window. I need something like: window = sys… --- ## [Named Query hangs](https://forum.inductiveautomation.com/t/named-query-hangs/23439)
**Author:** [@Tim](https://forum.inductiveautomation.com/u/Tim)\ **Replies:** 4\ **Last updated:** [April 3, 2019, 11:02pm UTC](https://forum.inductiveautomation.com/t/named-query-hangs/23439 "2019-04-03T23:02:07Z")
I’m seeing named queries hanging in the gateway active query status screen when the client calling window is closed before the query results are returned. They will remain under the active query heading until manually c… --- ## [Launch designer straight into a project](https://forum.inductiveautomation.com/t/launch-designer-straight-into-a-project/20126)
**Author:** [@mrogers](https://forum.inductiveautomation.com/u/mrogers)\ **Replies:** 9\ **Last updated:** [April 3, 2019, 9:15pm UTC](https://forum.inductiveautomation.com/t/launch-designer-straight-into-a-project/20126 "2019-04-03T21:15:51Z")
Just a quick question, is it possible to make the designer launcher .jnlp open straight into a given project? I don't usually deal with multiple projects on the same gateway so it'd be nice if I could just skip that step… --- ## [Weird issue with report script data source (dataset)](https://forum.inductiveautomation.com/t/weird-issue-with-report-script-data-source-dataset/23826)
**Author:** [@paul.bouillon](https://forum.inductiveautomation.com/u/paul.bouillon)\ **Replies:** 1\ **Last updated:** [April 3, 2019, 9:06pm UTC](https://forum.inductiveautomation.com/t/weird-issue-with-report-script-data-source-dataset/23826 "2019-04-03T21:06:05Z")
Hi All, Trying to understand why I’m only getting a single row returned from my datasource created by script… Essentially, I am trying to sum the rows of my nested query, so that I can display a pie chart – was trying … --- ## [Ignition Store are Forward](https://forum.inductiveautomation.com/t/ignition-store-are-forward/23830)
**Author:** [@greggry.demark](https://forum.inductiveautomation.com/u/greggry.demark)\ **Replies:** 1\ **Last updated:** [April 3, 2019, 8:54pm UTC](https://forum.inductiveautomation.com/t/ignition-store-are-forward/23830 "2019-04-03T20:54:04Z")
Hello, I am trying to determine if the “Store and Forward” function would be appropriate for my application. I have a PLC based process where every two minutes I need to write less than 12 records to my database. In t… --- ## [Shared script runs in console but not as Gateway event script](https://forum.inductiveautomation.com/t/shared-script-runs-in-console-but-not-as-gateway-event-script/23799)
**Author:** [@rpulsifer](https://forum.inductiveautomation.com/u/rpulsifer)\ **Replies:** 8\ **Last updated:** [April 3, 2019, 6:04pm UTC](https://forum.inductiveautomation.com/t/shared-script-runs-in-console-but-not-as-gateway-event-script/23799 "2019-04-03T18:04:18Z")
I developed this script in the script console and it runs just as I want it to, BUT saving it as a Shared script function and calling it from a tag-change Gateway event script I get the screwy-est error: line 41 in cal… --- ## [SProcCall params](https://forum.inductiveautomation.com/t/sproccall-params/23823)
**Author:** [@apurdy](https://forum.inductiveautomation.com/u/apurdy)\ **Replies:** 0\ **Last updated:** [April 3, 2019, 5:32pm UTC](https://forum.inductiveautomation.com/t/sproccall-params/23823 "2019-04-03T17:32:40Z")
Is there a way to access the params in the SProcCall? Here’s my conundrum… When I make a stored procedure call, I also want to print out the input parameters for operator knowledge as well as log the inputs. We have sev… --- ## [Getting a specific time frame from tag historian](https://forum.inductiveautomation.com/t/getting-a-specific-time-frame-from-tag-historian/23815)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 9\ **Last updated:** [April 3, 2019, 5:31pm UTC](https://forum.inductiveautomation.com/t/getting-a-specific-time-frame-from-tag-historian/23815 "2019-04-03T17:31:13Z")
I am working on a project that has a many tags being recorded using Tag Historian. End result of what I want is for there to be a button to be clicked twice - once to start and once to stop. I record the timestamp of t… --- ## [Reporting Bar Graph Using Part of my Dataset as a Legend](https://forum.inductiveautomation.com/t/reporting-bar-graph-using-part-of-my-dataset-as-a-legend/23817)
**Author:** [@EEdmondson](https://forum.inductiveautomation.com/u/EEdmondson)\ **Replies:** 0\ **Last updated:** [April 3, 2019, 3:42pm UTC](https://forum.inductiveautomation.com/t/reporting-bar-graph-using-part-of-my-dataset-as-a-legend/23817 "2019-04-03T15:42:08Z")
My bar graph in my report is using most of my data to populate the bars of the graph (as it should) but then it leaves out one column from my named query that I want displayed and it puts the value in the graph legend. W… --- ## [Power Table Data Historical Start/End Date binding not updating in runtime](https://forum.inductiveautomation.com/t/power-table-data-historical-start-end-date-binding-not-updating-in-runtime/23816)
**Author:** [@andytimc](https://forum.inductiveautomation.com/u/andytimc)\ **Replies:** 0\ **Last updated:** [April 3, 2019, 3:36pm UTC](https://forum.inductiveautomation.com/t/power-table-data-historical-start-end-date-binding-not-updating-in-runtime/23816 "2019-04-03T15:36:40Z")
I have a pop-up window which shows a tag history trend and a table of datapoints for the same tag. The table start Date and End Date Bindings are tied to the Easy Chart Start Date and End Date bindings. However, in runti… --- ## [Root Container Error but no Message](https://forum.inductiveautomation.com/t/root-container-error-but-no-message/23806)
**Author:** [@paulm1](https://forum.inductiveautomation.com/u/paulm1)\ **Replies:** 1\ **Last updated:** [April 3, 2019, 1:00am UTC](https://forum.inductiveautomation.com/t/root-container-error-but-no-message/23806 "2019-04-03T01:00:13Z")
I have a sql property binding error on my Root Container with no message. I have gone through everything associated with the Root Container and i can not find it. No errors while in Designer this (see below) only show… --- ## [createPopupMenu not working with Ubuntu (Xorg)](https://forum.inductiveautomation.com/t/createpopupmenu-not-working-with-ubuntu-xorg/23802)
**Author:** [@bfuson](https://forum.inductiveautomation.com/u/bfuson)\ **Replies:** 3\ **Last updated:** [April 2, 2019, 9:32pm UTC](https://forum.inductiveautomation.com/t/createpopupmenu-not-working-with-ubuntu-xorg/23802 "2019-04-02T21:32:13Z")
Using system.gui.createPopupMenu to instantiate simple quick-menus on templates. Works as expected on every Windows install I’ve tried. Recently was ‘gifted’ a Xubuntu development environment by the almighty cloud. Even… --- ## [Inserting a tag value into a scripted SQL query](https://forum.inductiveautomation.com/t/inserting-a-tag-value-into-a-scripted-sql-query/23796)
**Author:** [@ethanrendlen](https://forum.inductiveautomation.com/u/ethanrendlen)\ **Replies:** 2\ **Last updated:** [April 2, 2019, 6:52pm UTC](https://forum.inductiveautomation.com/t/inserting-a-tag-value-into-a-scripted-sql-query/23796 "2019-04-02T18:52:57Z")
Hello, I am trying to add a tag value into a scripted SQL query that will work if I use a test string, SO IM CLOSE! Help me out here it is almost done. jobnum = system.tag.read("{\[PanelShop\]JobNumSelect}").value quer… --- ## [Power Table Foreground Color Based on Date](https://forum.inductiveautomation.com/t/power-table-foreground-color-based-on-date/23782)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 4\ **Last updated:** [April 2, 2019, 3:42pm UTC](https://forum.inductiveautomation.com/t/power-table-foreground-color-based-on-date/23782 "2019-04-02T15:42:41Z")
I have a power table with a hidden datetime column coming from a DB. If the date in the row is older than today’s date, I want the text color to be red. Here is the code I tried to no avail from datetime import datet… --- ## [How do YOU handle a large number of trend tags for selection?](https://forum.inductiveautomation.com/t/how-do-you-handle-a-large-number-of-trend-tags-for-selection/23766)
**Author:** [@pjgonzales](https://forum.inductiveautomation.com/u/pjgonzales)\ **Replies:** 6\ **Last updated:** [April 2, 2019, 2:08pm UTC](https://forum.inductiveautomation.com/t/how-do-you-handle-a-large-number-of-trend-tags-for-selection/23766 "2019-04-02T14:08:12Z")
I’m working on a project and the customer wants me to make 2-3 process variables from 100+ devices available for trending so they can pick and choose/compare values. The issue I have is trying to figure out how to organi… --- ## [MS SQL Count and Case statements not working](https://forum.inductiveautomation.com/t/ms-sql-count-and-case-statements-not-working/23784)
**Author:** [@EEdmondson](https://forum.inductiveautomation.com/u/EEdmondson)\ **Replies:** 1\ **Last updated:** [April 2, 2019, 1:43pm UTC](https://forum.inductiveautomation.com/t/ms-sql-count-and-case-statements-not-working/23784 "2019-04-02T13:43:14Z")
count(case when Telesis\_Stamp='' then null else 1 end) as Passed, count(case when Telesis\_Stamp='' then 1 else null end) as Failed, count(\*) as Total FROM PartData\_GKN05\_C WHERE Infeed\_Pick\_Time \>= DATEADD(day,-7, GE… --- ## [Backup node slow start](https://forum.inductiveautomation.com/t/backup-node-slow-start/23744)
**Author:** [@daniel.garcia-redrue](https://forum.inductiveautomation.com/u/daniel.garcia-redrue)\ **Replies:** 10\ **Last updated:** [April 2, 2019, 1:31pm UTC](https://forum.inductiveautomation.com/t/backup-node-slow-start/23744 "2019-04-02T13:31:16Z")
Hi all, I have the following system running: Ignition v7.9.7 (over Windows Server 2016) 79 devices (2 TCP + 77 Modbus) and 160000 tags defined 1 database connection Redundancy node: warm mode, buffer siz… --- ## [Pyton Libraries Issue](https://forum.inductiveautomation.com/t/pyton-libraries-issue/23765)
**Author:** [@carolineuchoa.estuda](https://forum.inductiveautomation.com/u/carolineuchoa.estuda)\ **Replies:** 1\ **Last updated:** [April 2, 2019, 8:08am UTC](https://forum.inductiveautomation.com/t/pyton-libraries-issue/23765 "2019-04-02T08:08:04Z")
Hello, To work around the impossibility of calling some useful Python libraries inside Ignition: I’d like to know if there is a way to, inside Ignition, call a Python file outside of Ignition to run the code with the l… --- ## [Get Client RAM Consumption (and more)](https://forum.inductiveautomation.com/t/get-client-ram-consumption-and-more/17277)
**Author:** [@Amarth](https://forum.inductiveautomation.com/u/Amarth)\ **Replies:** 6\ **Last updated:** [April 1, 2019, 11:32pm UTC](https://forum.inductiveautomation.com/t/get-client-ram-consumption-and-more/17277 "2019-04-01T23:32:18Z")
Hello all, Is there a way to get the RAM (and uptime) of clients (throught scripting for example) in order to monitor/display it ? The system.util.getSessionsInfos() is very close from what I need but it lacks the RAM. … --- ## [Initial values on power table filters](https://forum.inductiveautomation.com/t/initial-values-on-power-table-filters/11641)
**Author:** [@caritoel27](https://forum.inductiveautomation.com/u/caritoel27)\ **Replies:** 2\ **Last updated:** [April 1, 2019, 11:07pm UTC](https://forum.inductiveautomation.com/t/initial-values-on-power-table-filters/11641 "2019-04-01T23:07:15Z")
Hi, Please, I have the following question: Is it posible that power table filters have an initial value? For example a date column can have an initial filter : first day of the current month And if so how can I do i… --- ## [How do I set which screen a client opens on (multiple displays)?](https://forum.inductiveautomation.com/t/how-do-i-set-which-screen-a-client-opens-on-multiple-displays/23770)
**Author:** [@chaddcharbonneau](https://forum.inductiveautomation.com/u/chaddcharbonneau)\ **Replies:** 1\ **Last updated:** [April 1, 2019, 10:31pm UTC](https://forum.inductiveautomation.com/t/how-do-i-set-which-screen-a-client-opens-on-multiple-displays/23770 "2019-04-01T22:31:57Z")
I have multiple monitors running and the client doesn’t launch as expected. Thanks. --- ## [7.9.10 can no longer open client through NAT](https://forum.inductiveautomation.com/t/7-9-10-can-no-longer-open-client-through-nat/23767)
**Author:** [@Hazmat480](https://forum.inductiveautomation.com/u/Hazmat480)\ **Replies:** 0\ **Last updated:** [April 1, 2019, 8:08pm UTC](https://forum.inductiveautomation.com/t/7-9-10-can-no-longer-open-client-through-nat/23767 "2019-04-01T20:08:51Z")
We upgraded from version 7.9.8 to 7.9.10 and we can no longer open the client through a NAT connection. Client opens and says connecting then times out. It was working fine with version 7.9.8. Any help would be appreciat… --- ## [Box and Whisker Font Size](https://forum.inductiveautomation.com/t/box-and-whisker-font-size/15085)
**Author:** [@COVBob](https://forum.inductiveautomation.com/u/COVBob)\ **Replies:** 1\ **Last updated:** [April 1, 2019, 8:40pm UTC](https://forum.inductiveautomation.com/t/box-and-whisker-font-size/15085 "2019-04-01T20:40:30Z")
The Box and Whisker chart font parameter seems to only impact the title, but not the category or value axis labels. I feel like I'm just missing something simple, can someone point me to how to edit those? --- ## [MS SQL Queries Adding Table Columns](https://forum.inductiveautomation.com/t/ms-sql-queries-adding-table-columns/23758)
**Author:** [@EEdmondson](https://forum.inductiveautomation.com/u/EEdmondson)\ **Replies:** 2\ **Last updated:** [April 1, 2019, 8:16pm UTC](https://forum.inductiveautomation.com/t/ms-sql-queries-adding-table-columns/23758 "2019-04-01T20:16:22Z")
Hi all, I’m not very Jython savvy. I have data that I am pulling from a dataset and I want to add columns to the table after I have pulled that data. I want to do this because I want to calculate some things from the da… --- ## [MS SQL Queries: Getting Current Date and Using Date Arithmetic to Filter Database Results](https://forum.inductiveautomation.com/t/ms-sql-queries-getting-current-date-and-using-date-arithmetic-to-filter-database-results/23755)
**Author:** [@EEdmondson](https://forum.inductiveautomation.com/u/EEdmondson)\ **Replies:** 2\ **Last updated:** [April 1, 2019, 5:55pm UTC](https://forum.inductiveautomation.com/t/ms-sql-queries-getting-current-date-and-using-date-arithmetic-to-filter-database-results/23755 "2019-04-01T17:55:31Z")
Hi all, I’m trying to create a named query that will only pull data on items that have been introduced after a certain date (this date happens to be whatever the current date is - 7 days). I have been having a lot of tr… --- ## [Power table Selected Cell value Expression - Question](https://forum.inductiveautomation.com/t/power-table-selected-cell-value-expression-question/23672)
**Author:** [@paulm1](https://forum.inductiveautomation.com/u/paulm1)\ **Replies:** 3\ **Last updated:** [April 1, 2019, 4:53pm UTC](https://forum.inductiveautomation.com/t/power-table-selected-cell-value-expression-question/23672 "2019-04-01T16:53:04Z")
I have a Standard Table Component(Table1)that is displaying values associated with operator request. I also have a Power Table Component(PwrTable2) on the same screen that is populated based on the selected row from Tab… --- ## [Alarm handling - pipeline](https://forum.inductiveautomation.com/t/alarm-handling-pipeline/15054)
**Author:** [@SBL](https://forum.inductiveautomation.com/u/SBL)\ **Replies:** 5\ **Last updated:** [April 1, 2019, 3:24pm UTC](https://forum.inductiveautomation.com/t/alarm-handling-pipeline/15054 "2019-04-01T15:24:44Z")
Hi guys, I was wondering if there was a easy solution to activate alarm notification also when transitioned to inactive? Now I get an email when transitioned to Active, but would also like to get an notification when… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1303) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1305)