# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1475 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1476 --- ## [Select Report Data Source](https://forum.inductiveautomation.com/t/select-report-data-source/10704)
**Author:** [@jreynolds](https://forum.inductiveautomation.com/u/jreynolds)\ **Replies:** 1\ **Last updated:** [November 2, 2015, 4:18pm UTC](https://forum.inductiveautomation.com/t/select-report-data-source/10704 "2015-11-02T16:18:09Z")
I'm wanting to know if it's possible to select the data source within a report based upon a parameter. Basically I want to run one select statment if parameter equlas 1 and a different select statement if parameter equ… --- ## [Designer won't launch](https://forum.inductiveautomation.com/t/designer-wont-launch/10282)
**Author:** [@NathanR](https://forum.inductiveautomation.com/u/NathanR)\ **Replies:** 10\ **Last updated:** [November 2, 2015, 1:59pm UTC](https://forum.inductiveautomation.com/t/designer-wont-launch/10282 "2015-11-02T13:59:23Z")
When I try to launch the designer from gateway web-launch all I get is the Java startup window with “Java…”, even Java runtime console won’t start. When I launch the project everything works as normal. I’m using Ignit… --- ## [system.db.runPrepUpdate syntax help](https://forum.inductiveautomation.com/t/system-db-runprepupdate-syntax-help/10691)
**Author:** [@Andre](https://forum.inductiveautomation.com/u/Andre)\ **Replies:** 9\ **Last updated:** [November 2, 2015, 2:09am UTC](https://forum.inductiveautomation.com/t/system-db-runprepupdate-syntax-help/10691 "2015-11-02T02:09:03Z")
Hi, I’m trying to execute this line of code in a gateway tag change script: system.db.runPrepUpdate(“INSERT INTO recipe\_interlock (IngredientAdded) VALUES (?) WHERE (RecipeNumber = ‘%i’ AND IngredientNumber = ‘%i’)”\[Tr… --- ## [OPC- UA Path](https://forum.inductiveautomation.com/t/opc-ua-path/4563)
**Author:** [@RayJ](https://forum.inductiveautomation.com/u/RayJ)\ **Replies:** 6\ **Last updated:** [November 1, 2015, 11:26pm UTC](https://forum.inductiveautomation.com/t/opc-ua-path/4563 "2015-11-01T23:26:56Z")
Hi all, 1. I have Allen Bradley DH+ with 5 SLC nodes and a Datalink GW1000 Ethenet to DH+ converter. Is it possible to configure the OPC-UA connection path to see each node. 2. Can the user name and password be rem… --- ## [runUpdateQuery script](https://forum.inductiveautomation.com/t/runupdatequery-script/10709)
**Author:** [@CamJam](https://forum.inductiveautomation.com/u/CamJam)\ **Replies:** 5\ **Last updated:** [November 1, 2015, 8:27pm UTC](https://forum.inductiveautomation.com/t/runupdatequery-script/10709 "2015-11-01T20:27:51Z")
Hi, I have a script i use in my gateway scripts that looks to see if tables exist and create new tables if they dont exist. in v7.7.5 i have something like this and it works system.db.runUpdateQuery(“CREATE TABLE IF N… --- ## [Hardware specification for replace old system](https://forum.inductiveautomation.com/t/hardware-specification-for-replace-old-system/10710)
**Author:** [@Rv.Batista](https://forum.inductiveautomation.com/u/Rv.Batista)\ **Replies:** 0\ **Last updated:** [November 1, 2015, 3:24pm UTC](https://forum.inductiveautomation.com/t/hardware-specification-for-replace-old-system/10710 "2015-11-01T15:24:05Z")
Hello guys, I'm to make a proposal to a customer to replace his old scada system. They have almost 200 plc in the plant and 120 of them are identicals. It's 35000 tags (screen refresh rate is 250ms), 7000 trends (at … --- ## [Radar chart multiple polygons](https://forum.inductiveautomation.com/t/radar-chart-multiple-polygons/10707)
**Author:** [@Koen](https://forum.inductiveautomation.com/u/Koen)\ **Replies:** 0\ **Last updated:** [October 31, 2015, 2:45am UTC](https://forum.inductiveautomation.com/t/radar-chart-multiple-polygons/10707 "2015-10-31T02:45:45Z")
Hi, The User Manual states, and I quote \[quote\]“Each row in the dataset will become a single series (polygon) on the chart. The dataset’s first column represents the name of the series, and subsequent columns represen… --- ## [Changing existing device drivers from Controllogix to Logix](https://forum.inductiveautomation.com/t/changing-existing-device-drivers-from-controllogix-to-logix/10703)
**Author:** [@dhaugh](https://forum.inductiveautomation.com/u/dhaugh)\ **Replies:** 0\ **Last updated:** [October 30, 2015, 6:25pm UTC](https://forum.inductiveautomation.com/t/changing-existing-device-drivers-from-controllogix-to-logix/10703 "2015-10-30T18:25:31Z")
After upgrading our processors to ver 24 & Logix driver, all Ignition tags were in error. OPC Item path needs to be changed for every tag a huge P.I.A. for any migration. Program Scoped tags needed "Program:" added. … --- ## [Report not loading anymore](https://forum.inductiveautomation.com/t/report-not-loading-anymore/10693)
**Author:** [@stokstaart](https://forum.inductiveautomation.com/u/stokstaart)\ **Replies:** 6\ **Last updated:** [October 30, 2015, 3:48pm UTC](https://forum.inductiveautomation.com/t/report-not-loading-anymore/10693 "2015-10-30T15:48:46Z")
Goodday, as i almost finished my report (20+hrs..) i tried to add an Piechart. I now whish i hadn't done that since it looks i have to restart all the work i put into it! I get a NullPointerException and i find the f… --- ## [OPC-UA Settings not loading after Full Gateway Restore](https://forum.inductiveautomation.com/t/opc-ua-settings-not-loading-after-full-gateway-restore/10697)
**Author:** [@jimmylooo](https://forum.inductiveautomation.com/u/jimmylooo)\ **Replies:** 3\ **Last updated:** [October 30, 2015, 2:52pm UTC](https://forum.inductiveautomation.com/t/opc-ua-settings-not-loading-after-full-gateway-restore/10697 "2015-10-30T14:52:51Z")
I'm working on Migrating our Gateway to a new server. After restoring the backup from the Original gateway, all looks good except I cant view/edit the OPC-UA Settings. I can view/edit the OPC-UA Device settings with… --- ## [Enble/disable transaction group](https://forum.inductiveautomation.com/t/enble-disable-transaction-group/10698)
**Author:** [@angelo.bersani](https://forum.inductiveautomation.com/u/angelo.bersani)\ **Replies:** 1\ **Last updated:** [October 30, 2015, 2:24pm UTC](https://forum.inductiveautomation.com/t/enble-disable-transaction-group/10698 "2015-10-30T14:24:43Z")
Good evening, we need to enable / disable a transaction group through a python script. Is there a way to do this? Thanks --- ## [Multiple selection in table then input same result](https://forum.inductiveautomation.com/t/multiple-selection-in-table-then-input-same-result/10684)
**Author:** [@trishhiyah](https://forum.inductiveautomation.com/u/trishhiyah)\ **Replies:** 6\ **Last updated:** [October 30, 2015, 1:53am UTC](https://forum.inductiveautomation.com/t/multiple-selection-in-table-then-input-same-result/10684 "2015-10-30T01:53:31Z")
Hi, is it possible in a table to select multiple row then input same result(drop down list) with the selected row in this table. Thank you so much --- ## [Power Table - Mouse Click](https://forum.inductiveautomation.com/t/power-table-mouse-click/10528)
**Author:** [@Maithen](https://forum.inductiveautomation.com/u/Maithen)\ **Replies:** 2\ **Last updated:** [October 29, 2015, 8:22pm UTC](https://forum.inductiveautomation.com/t/power-table-mouse-click/10528 "2015-10-29T20:22:47Z")
I am using 7.8.0 RC1. I have difficulties in catching the event mouseClicked from the PowerTable. Whatever script i have under the Event Handlers \> mouse \> mouseClicked does not get executed. --- ## [PDF Viewer Module V2.7 API mismatch](https://forum.inductiveautomation.com/t/pdf-viewer-module-v2-7-api-mismatch/10641)
**Author:** [@0sm0](https://forum.inductiveautomation.com/u/0sm0)\ **Replies:** 3\ **Last updated:** [October 29, 2015, 7:50pm UTC](https://forum.inductiveautomation.com/t/pdf-viewer-module-v2-7-api-mismatch/10641 "2015-10-29T19:50:48Z")
Hi guys, I have some older projects that use the IA Labs PDF Viewer Module V2.7 which is not compatible with Ignition V7.8 \[API Mismatch\]. Therefore I can not open the window containing the PDF viewer component in or… --- ## [Dynamically call different python functions from shared libr](https://forum.inductiveautomation.com/t/dynamically-call-different-python-functions-from-shared-libr/10689)
**Author:** [@iamthebull](https://forum.inductiveautomation.com/u/iamthebull)\ **Replies:** 3\ **Last updated:** [October 29, 2015, 5:34am UTC](https://forum.inductiveautomation.com/t/dynamically-call-different-python-functions-from-shared-libr/10689 "2015-10-29T05:34:46Z")
Is there a way to accomplish the following? I want to pass a string variable functionName to a tag event script and call a function from the shared script library of the same name. ie. if functionName = "myFunction1"… --- ## [Huge Alarm.data file (20GB)](https://forum.inductiveautomation.com/t/huge-alarm-data-file-20gb/10692)
**Author:** [@fran.alija](https://forum.inductiveautomation.com/u/fran.alija)\ **Replies:** 0\ **Last updated:** [October 28, 2015, 10:45pm UTC](https://forum.inductiveautomation.com/t/huge-alarm-data-file-20gb/10692 "2015-10-28T22:45:01Z")
Hi All, We have an issue in one of our Ignition systems. After several months running smoothly today just stopped working due to a C drive full. The main reason for the drive full is a huge Alarm.data file (20GB) locat… --- ## [OPC Tag Drag and Drop Creation extra text](https://forum.inductiveautomation.com/t/opc-tag-drag-and-drop-creation-extra-text/10567)
**Author:** [@gadgetguru69](https://forum.inductiveautomation.com/u/gadgetguru69)\ **Replies:** 3\ **Last updated:** [October 28, 2015, 8:22pm UTC](https://forum.inductiveautomation.com/t/opc-tag-drag-and-drop-creation-extra-text/10567 "2015-10-28T20:22:12Z")
See attached image of issue when dragging OPC item into tag to create new tag. We are getting extra text in the OPC item path that never was there before. The tag still functions correctly but not sure this is intended b… --- ## [Expression Tag Calculation](https://forum.inductiveautomation.com/t/expression-tag-calculation/10683)
**Author:** [@gglenn](https://forum.inductiveautomation.com/u/gglenn)\ **Replies:** 3\ **Last updated:** [October 28, 2015, 11:54am UTC](https://forum.inductiveautomation.com/t/expression-tag-calculation/10683 "2015-10-28T11:54:33Z")
I am attempting to display in Easy Chart a motor's commanded speed, actual speed, and percent error. The percent error is calculated by ((Actual Speed - Command Speed)/Command Speed) \* 100. I have created OPC tags for Ac… --- ## [Designer: switching between scripting and GUI editors](https://forum.inductiveautomation.com/t/designer-switching-between-scripting-and-gui-editors/10676)
**Author:** [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\ **Replies:** 2\ **Last updated:** [October 27, 2015, 2:40pm UTC](https://forum.inductiveautomation.com/t/designer-switching-between-scripting-and-gui-editors/10676 "2015-10-27T14:40:07Z")
Hi, in my project I need to switch very often between the project script library editor and the GUI editor. Very often it happens that, after switching to the script editor, I cannot switch any longer to the GUI editor, … --- ## [Extract mark text from easy chart](https://forum.inductiveautomation.com/t/extract-mark-text-from-easy-chart/10678)
**Author:** [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Replies:** 4\ **Last updated:** [October 27, 2015, 2:18pm UTC](https://forum.inductiveautomation.com/t/extract-mark-text-from-easy-chart/10678 "2015-10-27T14:18:24Z")
Something is in the back of my mind that this has been asked before, but I just can’t find it. Any way to extract this text? --- ## [Text wrapping in labels](https://forum.inductiveautomation.com/t/text-wrapping-in-labels/10654)
**Author:** [@Kstofcho](https://forum.inductiveautomation.com/u/Kstofcho)\ **Replies:** 1\ **Last updated:** [October 27, 2015, 11:34am UTC](https://forum.inductiveautomation.com/t/text-wrapping-in-labels/10654 "2015-10-27T11:34:40Z")
Hello, I am adding a second language to our interface and am having to resize a lot of text to accommodate the second language due to many words and phrases being more lengthy. I have some labels that are wrapped. Prev… --- ## [Error writing tags using Kepware](https://forum.inductiveautomation.com/t/error-writing-tags-using-kepware/10673)
**Author:** [@dbortolini](https://forum.inductiveautomation.com/u/dbortolini)\ **Replies:** 2\ **Last updated:** [October 27, 2015, 9:55am UTC](https://forum.inductiveautomation.com/t/error-writing-tags-using-kepware/10673 "2015-10-27T09:55:13Z")
Hello, today I have this problem that is going to drive me crazy. My environment is this: Kepware 5.19 as OPC collector Ignition 7.8 (recently updated) connected to Kepware via UA I've setup a Siemens TCP/IP channel… --- ## [Native Client Launcher 7.7.5 doesn't work for Windows](https://forum.inductiveautomation.com/t/native-client-launcher-7-7-5-doesnt-work-for-windows/10662)
**Author:** [@framebuilder](https://forum.inductiveautomation.com/u/framebuilder)\ **Replies:** 4\ **Last updated:** [October 26, 2015, 6:53pm UTC](https://forum.inductiveautomation.com/t/native-client-launcher-7-7-5-doesnt-work-for-windows/10662 "2015-10-26T18:53:10Z")
clientlauncher.exe version 7.7.5 for Windows doesn’t open. I get the following error attached. Our Gateway is version 7.7.5, Gateway Java is 1.8.0\_60 I’ve tried with different computers with 1.6, 1.7, and 1.8 JREs and… --- ## [Assigning a Parent Type to a UDT - v7.8 Ubuntu 14.04](https://forum.inductiveautomation.com/t/assigning-a-parent-type-to-a-udt-v7-8-ubuntu-14-04/10674)
**Author:** [@akuznia](https://forum.inductiveautomation.com/u/akuznia)\ **Replies:** 0\ **Last updated:** [October 26, 2015, 6:02pm UTC](https://forum.inductiveautomation.com/t/assigning-a-parent-type-to-a-udt-v7-8-ubuntu-14-04/10674 "2015-10-26T18:02:26Z")
I’m using the Inductive University Challenge File project. I created a UDT named SuperType. I gave it one memory tag property and a single parameter. I create another UDT named SubType. When I select a Parent Type fr… --- ## [Gateway restore fails?](https://forum.inductiveautomation.com/t/gateway-restore-fails/10663)
**Author:** [@jmoniz](https://forum.inductiveautomation.com/u/jmoniz)\ **Replies:** 5\ **Last updated:** [October 26, 2015, 5:37pm UTC](https://forum.inductiveautomation.com/t/gateway-restore-fails/10663 "2015-10-26T17:37:30Z")
We are in the process of trying to upgrade to 7.8 from 7.7.2. In doing so every time we do a backup and try restore the Gateway just hangs. By hanging I mean, the Web server service starts but the Gateway stays in a per… --- ## [7.8 Report Printing](https://forum.inductiveautomation.com/t/7-8-report-printing/10669)
**Author:** [@DSI600](https://forum.inductiveautomation.com/u/DSI600)\ **Replies:** 4\ **Last updated:** [October 26, 2015, 3:59pm UTC](https://forum.inductiveautomation.com/t/7-8-report-printing/10669 "2015-10-26T15:59:53Z")
I know we can schedule a new report to print. Is there a way to auto print the report on a trigger and ignore the schedule? --- ## [SQL Division](https://forum.inductiveautomation.com/t/sql-division/10671)
**Author:** [@Jado58](https://forum.inductiveautomation.com/u/Jado58)\ **Replies:** 1\ **Last updated:** [October 26, 2015, 3:14pm UTC](https://forum.inductiveautomation.com/t/sql-division/10671 "2015-10-26T15:14:36Z")
I’m using SQL Server 2005, I want to check the “TypeHopper\_0x” value if = 2, add “CycleHopper\_0x” to a @nat\_weight, This part I was able to accomplish. Now @nat\_weight = 1871. Now I want to divide the value of "cycleHop… --- ## [Filter by Date Optional](https://forum.inductiveautomation.com/t/filter-by-date-optional/10658)
**Author:** [@MoisesZV](https://forum.inductiveautomation.com/u/MoisesZV)\ **Replies:** 3\ **Last updated:** [October 26, 2015, 1:12pm UTC](https://forum.inductiveautomation.com/t/filter-by-date-optional/10658 "2015-10-26T13:12:47Z")
Hi, I'm trying to filter a table, but I want an optional filter by date. I have a custom property in my table called "dateFilter", this is the expression: if({Root Container.checkbox.selected}=1,"and date between '{Ro… --- ## [Combining several project in to a Plant wide project](https://forum.inductiveautomation.com/t/combining-several-project-in-to-a-plant-wide-project/10664)
**Author:** [@jshaffer09](https://forum.inductiveautomation.com/u/jshaffer09)\ **Replies:** 1\ **Last updated:** [October 25, 2015, 4:14pm UTC](https://forum.inductiveautomation.com/t/combining-several-project-in-to-a-plant-wide-project/10664 "2015-10-25T16:14:11Z")
Is there a way to combine all my projects for each piece of equipment in to one major plant wide project? --- ## [Popups not came back to front on client update in fullscreen](https://forum.inductiveautomation.com/t/popups-not-came-back-to-front-on-client-update-in-fullscreen/10270)
**Author:** [@pdibenedetto](https://forum.inductiveautomation.com/u/pdibenedetto)\ **Replies:** 2\ **Last updated:** [October 24, 2015, 12:18am UTC](https://forum.inductiveautomation.com/t/popups-not-came-back-to-front-on-client-update-in-fullscreen/10270 "2015-10-24T00:18:42Z")
To replicate: Launch a client on fullscreen mode. Open Diagnostic window (or a errorbox or any popup window) Save & publish the project on designer and update on client Now, try to open diagnostic window again. Vers… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1474) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1476)