# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1539 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1540 --- ## [Event that fires when opening a page?](https://forum.inductiveautomation.com/t/event-that-fires-when-opening-a-page/23809)
**Author:** [@silverbacknet](https://forum.inductiveautomation.com/u/silverbacknet)\ **Replies:** 2\ **Last updated:** [April 3, 2019, 2:10pm UTC](https://forum.inductiveautomation.com/t/event-that-fires-when-opening-a-page/23809 "2019-04-03T14:10:05Z")
I’m curious whether any bindable event fires each time a page is loaded, rather than the actual Session startup, or if there’s something I can stick on the page that just immediately fires once. I need to take some param… --- ## [Collaboration with graphic designers/web developers on Perspective](https://forum.inductiveautomation.com/t/collaboration-with-graphic-designers-web-developers-on-perspective/23701)
**Author:** [@ASF](https://forum.inductiveautomation.com/u/ASF)\ **Replies:** 4\ **Last updated:** [April 3, 2019, 2:01pm UTC](https://forum.inductiveautomation.com/t/collaboration-with-graphic-designers-web-developers-on-perspective/23701 "2019-04-03T14:01:10Z")
My client has floated the idea of having a graphic designer/web developer get involved with the development of a few perspective views, because, well, engineers aren’t exactly known for their aesthetic flair :wink: The … --- ## [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… --- ## [Get coerced into date error when trying to get a the vlaue from datetimeinput component](https://forum.inductiveautomation.com/t/get-coerced-into-date-error-when-trying-to-get-a-the-vlaue-from-datetimeinput-component/23807)
**Author:** [@john.schlottke](https://forum.inductiveautomation.com/u/john.schlottke)\ **Replies:** 2\ **Last updated:** [April 3, 2019, 12:23am UTC](https://forum.inductiveautomation.com/t/get-coerced-into-date-error-when-trying-to-get-a-the-vlaue-from-datetimeinput-component/23807 "2019-04-03T00:23:12Z")
startDate = self.getSibling(‘StartDate’).props.formattedValues.date endDate = self.getSibling(‘EndDate’).props.formattedValues.date newdate = system.date.addDays(startDate,5) --- ## [Help with container selection](https://forum.inductiveautomation.com/t/help-with-container-selection/23625)
**Author:** [@ASF](https://forum.inductiveautomation.com/u/ASF)\ **Replies:** 4\ **Last updated:** [April 2, 2019, 11:49pm UTC](https://forum.inductiveautomation.com/t/help-with-container-selection/23625 "2019-04-02T23:49:48Z")
Just hoping for a little advice on container selection as I’m still getting my head around how they all work… I’ve got a popup that shows status information and parameter data on the left, and a small graph/chart on the… --- ## [Image - SQL Database](https://forum.inductiveautomation.com/t/image-sql-database/10619)
**Author:** [@robert.i](https://forum.inductiveautomation.com/u/robert.i)\ **Replies:** 4\ **Last updated:** [April 2, 2019, 11:44pm UTC](https://forum.inductiveautomation.com/t/image-sql-database/10619 "2019-04-02T23:44:48Z")
save a image to sql using script of ignition --- ## [Coordinate View - Smaller After Upgrade](https://forum.inductiveautomation.com/t/coordinate-view-smaller-after-upgrade/23795)
**Author:** [@jayce.oxton](https://forum.inductiveautomation.com/u/jayce.oxton)\ **Replies:** 5\ **Last updated:** [April 2, 2019, 9:33pm UTC](https://forum.inductiveautomation.com/t/coordinate-view-smaller-after-upgrade/23795 "2019-04-02T21:33:34Z")
I have a view that was done in a coordinate view and after upgrading our server with the latest nightly build 2 nights ago the coordinate container appears smaller than it did before. You can see this in the screenshot … --- ## [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… --- ## [A few appearance problems that would really help us](https://forum.inductiveautomation.com/t/a-few-appearance-problems-that-would-really-help-us/23743)
**Author:** [@silverbacknet](https://forum.inductiveautomation.com/u/silverbacknet)\ **Replies:** 2\ **Last updated:** [April 2, 2019, 9:07pm UTC](https://forum.inductiveautomation.com/t/a-few-appearance-problems-that-would-really-help-us/23743 "2019-04-02T21:07:24Z")
There’s a few things I can already see that the client who commissioned this project is going to demand changed… No vertical-align (or verticalAlign) top/bottom, table cells are always vertically centered. Need bottom … --- ## [\[Feature-13345\] Include Prefix and Suffix As String Format Config Options In Table Column Config](https://forum.inductiveautomation.com/t/feature-13345-include-prefix-and-suffix-as-string-format-config-options-in-table-column-config/23687)
**Author:** [@BumbleBeeTuna](https://forum.inductiveautomation.com/u/BumbleBeeTuna)\ **Replies:** 1\ **Last updated:** [April 2, 2019, 9:02pm UTC](https://forum.inductiveautomation.com/t/feature-13345-include-prefix-and-suffix-as-string-format-config-options-in-table-column-config/23687 "2019-04-02T21:02:47Z")
It would be nice to have the ability to configure column prefix and suffix like in vision. Specifically, adding table.props.column.prefix/suffix --- ## [Understanding perspective session events](https://forum.inductiveautomation.com/t/understanding-perspective-session-events/23328)
**Author:** [@waldner](https://forum.inductiveautomation.com/u/waldner)\ **Replies:** 9\ **Last updated:** [April 2, 2019, 6:55pm UTC](https://forum.inductiveautomation.com/t/understanding-perspective-session-events/23328 "2019-04-02T18:55:20Z")
As suggested in another thread, I’m trying to use the message passing mechanism to communicate from a perspective client to the gateway. On the client, I’ve set up the following startup and shutdown event scripts: # st… --- ## [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… --- ## [The method updateValue doesn't create tags](https://forum.inductiveautomation.com/t/the-method-updatevalue-doesnt-create-tags/22421)
**Author:** [@Eden.Mar](https://forum.inductiveautomation.com/u/Eden.Mar)\ **Replies:** 5\ **Last updated:** [April 2, 2019, 6:42pm UTC](https://forum.inductiveautomation.com/t/the-method-updatevalue-doesnt-create-tags/22421 "2019-04-02T18:42:26Z")
Hello, I’m currently in the process of migrating some of our own modules from 7.9 to 8.0 and testing for any changes. Per the javadoc, updateValue under com.inductiveautomation.ignition.gateway.tags.managed.ManagedTagPr… --- ## [\[Bug?\] Unable to drop templates in Vision windows or template designer](https://forum.inductiveautomation.com/t/bug-unable-to-drop-templates-in-vision-windows-or-template-designer/22949)
**Author:** [@cwaddoups](https://forum.inductiveautomation.com/u/cwaddoups)\ **Replies:** 2\ **Last updated:** [April 2, 2019, 6:38pm UTC](https://forum.inductiveautomation.com/t/bug-unable-to-drop-templates-in-vision-windows-or-template-designer/22949 "2019-04-02T18:38:09Z")
Using today’s build (b2019022702) I attempted to modify an existing template by dropping another template into it in the designer. I was unable to drop that template in the designer, instead the cursor turned into a cir… --- ## [Help: Getting java.lang.ClassCastException in runNamedQuery on the script console](https://forum.inductiveautomation.com/t/help-getting-java-lang-classcastexception-in-runnamedquery-on-the-script-console/23789)
**Author:** [@sudipta.tripathy](https://forum.inductiveautomation.com/u/sudipta.tripathy)\ **Replies:** 10\ **Last updated:** [April 2, 2019, 5:43pm UTC](https://forum.inductiveautomation.com/t/help-getting-java-lang-classcastexception-in-runnamedquery-on-the-script-console/23789 "2019-04-02T17:43:18Z")
Please help. Why am I getting this error on the script console? data=system.db.runNamedQuery(“TestProject”,“GetAlert”, params) java.lang.ClassCastException: java.lang.ClassCastException: Cannot coerce value ‘GetAlert’ … --- ## [Named query does not default to project's default connection](https://forum.inductiveautomation.com/t/named-query-does-not-default-to-projects-default-connection/23646)
**Author:** [@james.vosler](https://forum.inductiveautomation.com/u/james.vosler)\ **Replies:** 2\ **Last updated:** [April 2, 2019, 5:28pm UTC](https://forum.inductiveautomation.com/t/named-query-does-not-default-to-projects-default-connection/23646 "2019-04-02T17:28:21Z")
We are attempting to determine whether or not a named query from a parent project will use the default connection of the parent project or the default project, but found that if the named query’s connection is set to \< D… --- ## [Reverse Order of SQL Query Issue](https://forum.inductiveautomation.com/t/reverse-order-of-sql-query-issue/23781)
**Author:** [@cathal](https://forum.inductiveautomation.com/u/cathal)\ **Replies:** 4\ **Last updated:** [April 2, 2019, 3:48pm UTC](https://forum.inductiveautomation.com/t/reverse-order-of-sql-query-issue/23781 "2019-04-02T15:48:46Z")
I’m having an issue using ORDER BY in my SQL code. This SQL code is contained in a Power Table. My intention is to return the values in order of the record date descending, however once I add this line to the code it res… --- ## [Critical UDT Issues, History Issues](https://forum.inductiveautomation.com/t/critical-udt-issues-history-issues/23768)
**Author:** [@roger\_larson](https://forum.inductiveautomation.com/u/roger_larson)\ **Replies:** 4\ **Last updated:** [April 2, 2019, 3:45pm UTC](https://forum.inductiveautomation.com/t/critical-udt-issues-history-issues/23768 "2019-04-02T15:45:01Z")
Hi everyone, I’d like to report several issues that we have encountered on our projects, just to have a place to know where to look for updates before and after 8.0 is released. Feel free to ask for clarification on an… --- ## [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… --- ## [\[bug-13422\]Designer hangs if Perspective is opened before Vision](https://forum.inductiveautomation.com/t/bug-13422-designer-hangs-if-perspective-is-opened-before-vision/23731)
**Author:** [@silverbacknet](https://forum.inductiveautomation.com/u/silverbacknet)\ **Replies:** 3\ **Last updated:** [April 2, 2019, 3:39pm UTC](https://forum.inductiveautomation.com/t/bug-13422-designer-hangs-if-perspective-is-opened-before-vision/23731 "2019-04-02T15:39:33Z")
I have a project with both old Vision panels and new Perspective ones; if I open Vision first, all is good, but if I open Perspective first, attempting to open Vision will hang the designer. --- ## [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… --- ## [\[Question\] Beta License](https://forum.inductiveautomation.com/t/question-beta-license/20609)
**Author:** [@ryanjmclaughlin](https://forum.inductiveautomation.com/u/ryanjmclaughlin)\ **Replies:** 12\ **Last updated:** [April 2, 2019, 12:56pm UTC](https://forum.inductiveautomation.com/t/question-beta-license/20609 "2019-04-02T12:56:00Z")
As this is a pre-release we are not yet going to upgrade any of our 7.9 gateways until RC time. It appears the standard trial license model is in affect. Are there any plans to allow temp licenses or a second activatio… --- ## [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… --- ## [Identity Provider Not Displayed In Project Properties](https://forum.inductiveautomation.com/t/identity-provider-not-displayed-in-project-properties/23764)
**Author:** [@SMcIntosh](https://forum.inductiveautomation.com/u/SMcIntosh)\ **Replies:** 4\ **Last updated:** [April 1, 2019, 9:10pm UTC](https://forum.inductiveautomation.com/t/identity-provider-not-displayed-in-project-properties/23764 "2019-04-01T21:10:33Z")
I can’t log in to my perspective client (with the login event) using any alternative user sources. I know the sources themselves are set up correctly - when set to the gateway default user source I can log in with them -… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1538) [Next page](https://forum.inductiveautomation.com/latest.md?page=1540)