# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=850 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 851 --- ## [SQL Edit Command Doesn't Allow Transaction Group to Find Value](https://forum.inductiveautomation.com/t/sql-edit-command-doesnt-allow-transaction-group-to-find-value/58980)
**Author:** [@james4](https://forum.inductiveautomation.com/u/james4)\ **Replies:** 11\ **Last updated:** [April 28, 2022, 3:43pm UTC](https://forum.inductiveautomation.com/t/sql-edit-command-doesnt-allow-transaction-group-to-find-value/58980 "2022-04-28T15:43:57Z")
Good morning, I pre-made a recipe list for a customer from the office but when I got on-site it looks like I was given some wrong information. At the office I used a custom made recipe editor to add fields into SQL with… --- ## [Sql help, how to apply conditions to lead() over partition](https://forum.inductiveautomation.com/t/sql-help-how-to-apply-conditions-to-lead-over-partition/59000)
**Author:** [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Replies:** 0\ **Last updated:** [April 28, 2022, 3:13pm UTC](https://forum.inductiveautomation.com/t/sql-help-how-to-apply-conditions-to-lead-over-partition/59000 "2022-04-28T15:13:40Z")
For my query, I want to get the lead t\_stamp when the table.code column in that row is less than 1500. select t\_stamp, lead(t\_stamp) over (order by t\_stamp) as lead from table This gets me all t\_stamps and leads excep… --- ## [Can't open styles with hyphens or underscores](https://forum.inductiveautomation.com/t/cant-open-styles-with-hyphens-or-underscores/58884)
**Author:** [@peter](https://forum.inductiveautomation.com/u/peter)\ **Replies:** 8\ **Last updated:** [April 28, 2022, 3:02pm UTC](https://forum.inductiveautomation.com/t/cant-open-styles-with-hyphens-or-underscores/58884 "2022-04-28T15:02:51Z")
This is in 8.1.15, Perspective, Linux I created a style with a hyphen in it, closed it and then found I couldn’t open it again. I experimented with various style names and discovered that if I had a hyphen or underscor… --- ## [Timezone Behavior](https://forum.inductiveautomation.com/t/timezone-behavior/58988)
**Author:** [@mcolson1590](https://forum.inductiveautomation.com/u/mcolson1590)\ **Replies:** 5\ **Last updated:** [April 28, 2022, 3:02pm UTC](https://forum.inductiveautomation.com/t/timezone-behavior/58988 "2022-04-28T15:02:50Z")
I have the Timezone set to Gateway Timezone. The time shown on the vision client at the gateway does not match the time shown on a vision client on my computer (EST vs CST). When trending in realtime, i'm then missing … --- ## [Uncaught exception in Designer console - Loop limit exceeded](https://forum.inductiveautomation.com/t/uncaught-exception-in-designer-console-loop-limit-exceeded/58997)
**Author:** [@peter](https://forum.inductiveautomation.com/u/peter)\ **Replies:** 3\ **Last updated:** [April 28, 2022, 2:44pm UTC](https://forum.inductiveautomation.com/t/uncaught-exception-in-designer-console-loop-limit-exceeded/58997 "2022-04-28T14:44:40Z")
This is in 8.1.15 I just encountered this error in the designer console: 08:08:32.579 \[Browser Thread: 40031\] ERROR Perspective.Designer.Workspace - level: LEVEL\_ERROR message: "onerrorLogger: {\\"msg\\":\\"Uncaught Excep… --- ## [Importing from FactoryPMI](https://forum.inductiveautomation.com/t/importing-from-factorypmi/5539)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 9\ **Last updated:** [April 28, 2022, 2:18pm UTC](https://forum.inductiveautomation.com/t/importing-from-factorypmi/5539 "2022-04-28T14:18:37Z")
Is it possible to import a FactoryPMI .fpmi file into Ignition? --- ## [Tag Editor Data Extract](https://forum.inductiveautomation.com/t/tag-editor-data-extract/58959)
**Author:** [@mwolter](https://forum.inductiveautomation.com/u/mwolter)\ **Replies:** 2\ **Last updated:** [April 28, 2022, 1:14pm UTC](https://forum.inductiveautomation.com/t/tag-editor-data-extract/58959 "2022-04-28T13:14:51Z")
I’m trying to get a simple script or SQL statement to extract the Tag Name and OPC Item Path fields from the Tag Editor Screen in Ignition Designer and dump it into a flat file or some format that I can use to cross refe… --- ## [Numeric Entry Field up/down arrow](https://forum.inductiveautomation.com/t/numeric-entry-field-up-down-arrow/58982)
**Author:** [@DUMAS\_Solene](https://forum.inductiveautomation.com/u/DUMAS_Solene)\ **Replies:** 3\ **Last updated:** [April 28, 2022, 1:04pm UTC](https://forum.inductiveautomation.com/t/numeric-entry-field-up-down-arrow/58982 "2022-04-28T13:04:09Z")
Hello, How can I remove the up/down arrow of Numeric Entry Field that appears when you clic on it, in Perspective? Thank you for the answer. --- ## [Redundancy - Cloud to Cloud and OPC Servers](https://forum.inductiveautomation.com/t/redundancy-cloud-to-cloud-and-opc-servers/19143)
**Author:** [@ctonge](https://forum.inductiveautomation.com/u/ctonge)\ **Replies:** 10\ **Last updated:** [August 8, 2018, 5:57pm UTC](https://forum.inductiveautomation.com/t/redundancy-cloud-to-cloud-and-opc-servers/19143 "2018-08-08T17:57:03Z")
I have a redundancy configuration where my servers are in different cloud networks and thus can't resolve each other's local IP addresses. So far this seems to be an issue only with the backup's OPC connection to the in… --- ## [Search and Replace with UDT parameters](https://forum.inductiveautomation.com/t/search-and-replace-with-udt-parameters/58685)
**Author:** [@bwhite](https://forum.inductiveautomation.com/u/bwhite)\ **Replies:** 4\ **Last updated:** [April 28, 2022, 12:28pm UTC](https://forum.inductiveautomation.com/t/search-and-replace-with-udt-parameters/58685 "2022-04-28T12:28:05Z")
I imported a project and need to change the name of the PLC connection. I did a search and replace on the PLC name and changed all the references to the device name. However, the search and replace will not allow me to… --- ## [Perspective dataset / table row limit](https://forum.inductiveautomation.com/t/perspective-dataset-table-row-limit/58970)
**Author:** [@Paul.M](https://forum.inductiveautomation.com/u/Paul.M)\ **Replies:** 8\ **Last updated:** [April 28, 2022, 10:12am UTC](https://forum.inductiveautomation.com/t/perspective-dataset-table-row-limit/58970 "2022-04-28T10:12:33Z")
Hello, I have a SQL db. with 300 + rows (max. 500) and I try to show data to a perspective table but I have a row limitation at 235. named queries - I get all my data from SQL but it stop shows at 235. runQuerry - I… --- ## [EmbeddedView : Change of view with a script](https://forum.inductiveautomation.com/t/embeddedview-change-of-view-with-a-script/58928)
**Author:** [@Valerian\_LADIEU](https://forum.inductiveautomation.com/u/Valerian_LADIEU)\ **Replies:** 8\ **Last updated:** [April 28, 2022, 9:40am UTC](https://forum.inductiveautomation.com/t/embeddedview-change-of-view-with-a-script/58928 "2022-04-28T09:40:42Z")
Hello everyone, I’m having trouble with a view appearing I created a scipt allowing me to retrieve the post name according to the folders of my sites So Script = “PDL” or “PDL PTR 1” according to this value, I would … --- ## [Numeric Entry Field Moving On Click](https://forum.inductiveautomation.com/t/numeric-entry-field-moving-on-click/58843)
**Author:** [@Casu](https://forum.inductiveautomation.com/u/Casu)\ **Replies:** 7\ **Last updated:** [April 28, 2022, 6:10am UTC](https://forum.inductiveautomation.com/t/numeric-entry-field-moving-on-click/58843 "2022-04-28T06:10:57Z")
Hi, just wondering if this is fixable - below is my numeric text field, when I click into the box, it will move slightly downwards, so the dark gray background is visible. This darker box is where the textbox is placed o… --- ## [Assign UDT Parameters Using Expression](https://forum.inductiveautomation.com/t/assign-udt-parameters-using-expression/58960)
**Author:** [@Aaron\_Shivne](https://forum.inductiveautomation.com/u/Aaron_Shivne)\ **Replies:** 1\ **Last updated:** [April 28, 2022, 5:37am UTC](https://forum.inductiveautomation.com/t/assign-udt-parameters-using-expression/58960 "2022-04-28T05:37:50Z")
Is there a way to use an expression to assign a UDT parameter. This would be very helpful for combining UDTs and using the parameters of one to assign to the nested UDT. --- ## [Embedding a view within itself](https://forum.inductiveautomation.com/t/embedding-a-view-within-itself/58913)
**Author:** [@ASF](https://forum.inductiveautomation.com/u/ASF)\ **Replies:** 5\ **Last updated:** [April 28, 2022, 12:12am UTC](https://forum.inductiveautomation.com/t/embedding-a-view-within-itself/58913 "2022-04-28T00:12:12Z")
From the title you’ve probably already formed a strong opinion about what I’m trying to do, but hear me out :grin: My projects are structured in groups. There is a group UDT which controls the operation of all equipment… --- ## [Airlink LX40 activation for text messaging](https://forum.inductiveautomation.com/t/airlink-lx40-activation-for-text-messaging/58741)
**Author:** [@robert3](https://forum.inductiveautomation.com/u/robert3)\ **Replies:** 1\ **Last updated:** [April 27, 2022, 10:30pm UTC](https://forum.inductiveautomation.com/t/airlink-lx40-activation-for-text-messaging/58741 "2022-04-27T22:30:31Z")
Has anyone used the Airlink LX40 for text messaging? Were you able to activate it, with your service provider, for just text messaging that is no mobile data? We are concerned about security so we don’t want it to have a… --- ## [°C when instantiating an UDT with °C as measurement unit](https://forum.inductiveautomation.com/t/a-c-when-instantiating-an-udt-with-c-as-measurement-unit/58671)
**Author:** [@Davide3i](https://forum.inductiveautomation.com/u/Davide3i)\ **Replies:** 8\ **Last updated:** [April 27, 2022, 10:13pm UTC](https://forum.inductiveautomation.com/t/a-c-when-instantiating-an-udt-with-c-as-measurement-unit/58671 "2022-04-27T22:13:37Z")
Hello. I’m having an issue when instantiating an UDT where a parameter has °C for engineering unit. °C gets changed to °C, which I suppose is caused by the fact °C is not interpreted as a UTF-8 character. Any hints? … --- ## [UIManager Being Ignored?](https://forum.inductiveautomation.com/t/uimanager-being-ignored/31350)
**Author:** [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\ **Replies:** 5\ **Last updated:** [April 27, 2022, 7:54pm UTC](https://forum.inductiveautomation.com/t/uimanager-being-ignored/31350 "2022-04-27T19:54:32Z")
With Ignition V8 is UIManager still available to change the style of components? I’m trying to get the button disabled text color to change and it just doesn’t seem to work… and I’m wondering if I’m doing something wron… --- ## [How to create pug-in projects to work with main projects](https://forum.inductiveautomation.com/t/how-to-create-pug-in-projects-to-work-with-main-projects/58951)
**Author:** [@retinder.labana](https://forum.inductiveautomation.com/u/retinder.labana)\ **Replies:** 0\ **Last updated:** [April 27, 2022, 7:15pm UTC](https://forum.inductiveautomation.com/t/how-to-create-pug-in-projects-to-work-with-main-projects/58951 "2022-04-27T19:15:22Z")
I want to build a structure where a project can work as a standalone or it can be used as a plugin to be connected to another project \[Everything is located in one gateway\] Currently I am using inheritance on and off fo… --- ## [SQL SELECT Query](https://forum.inductiveautomation.com/t/sql-select-query/58893)
**Author:** [@user43](https://forum.inductiveautomation.com/u/user43)\ **Replies:** 17\ **Last updated:** [April 27, 2022, 5:55pm UTC](https://forum.inductiveautomation.com/t/sql-select-query/58893 "2022-04-27T17:55:14Z")
I’m making a Report for a customer. The data is in Historian. I have made basic reports before using the designer but I’m not very good with SQL. I need a query that will grab the data for multiple flow meters , groupe… --- ## [Syntax Error on Token](https://forum.inductiveautomation.com/t/syntax-error-on-token/58930)
**Author:** [@Dean\_Walsh](https://forum.inductiveautomation.com/u/Dean_Walsh)\ **Replies:** 8\ **Last updated:** [April 27, 2022, 5:52pm UTC](https://forum.inductiveautomation.com/t/syntax-error-on-token/58930 "2022-04-27T17:52:56Z")
I have been trying to get an icon to become invisible or visible based on whether a property value is between a range within an expression this is my code if (({session.custom.winddirect} = ( \<= 337.5 && \>= 22.5 )), ({… --- ## [Way to make icon blink?](https://forum.inductiveautomation.com/t/way-to-make-icon-blink/58938)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 1\ **Last updated:** [April 27, 2022, 5:51pm UTC](https://forum.inductiveautomation.com/t/way-to-make-icon-blink/58938 "2022-04-27T17:51:53Z")
Using Vision 8.1.16. My applications lets users send messages to each other. Right now the way they know this is when they have the application open, there’s a blinking icon that lets them know. However, many times us… --- ## [Disabled Component Colors](https://forum.inductiveautomation.com/t/disabled-component-colors/3927)
**Author:** [@Joseph\_Mendonca](https://forum.inductiveautomation.com/u/Joseph_Mendonca)\ **Replies:** 9\ **Last updated:** [April 27, 2022, 5:41pm UTC](https://forum.inductiveautomation.com/t/disabled-component-colors/3927 "2022-04-27T17:41:31Z")
Is there a way to over ride the default disabled component colors? --- ## [Are Designer edited resources stored in open text files?](https://forum.inductiveautomation.com/t/are-designer-edited-resources-stored-in-open-text-files/58906)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 1\ **Last updated:** [April 27, 2022, 5:33pm UTC](https://forum.inductiveautomation.com/t/are-designer-edited-resources-stored-in-open-text-files/58906 "2022-04-27T17:33:19Z")
My JXBrowser keeps crashing in my Designer sessions and I’ve lost work a few times now because I have to restart the Designer to get it back. I’m wondering if the locally edited resources are stored in the local filesyst… --- ## [Disabled tags - OPC Server limit impact](https://forum.inductiveautomation.com/t/disabled-tags-opc-server-limit-impact/58934)
**Author:** [@ccorrea](https://forum.inductiveautomation.com/u/ccorrea)\ **Replies:** 2\ **Last updated:** [April 27, 2022, 5:02pm UTC](https://forum.inductiveautomation.com/t/disabled-tags-opc-server-limit-impact/58934 "2022-04-27T17:02:30Z")
Hi folks, Did my homework and went thorugh all related posts in the forum, but couldn’t find a specific answer to our specific -temporary- situation. Usual disclaimer, I’m just an average Ignition enthusiatic…who can’t … --- ## [When should/if you update Designer Launcher?](https://forum.inductiveautomation.com/t/when-should-if-you-update-designer-launcher/42488)
**Author:** [@peter](https://forum.inductiveautomation.com/u/peter)\ **Replies:** 20\ **Last updated:** [April 27, 2022, 4:59pm UTC](https://forum.inductiveautomation.com/t/when-should-if-you-update-designer-launcher/42488 "2022-04-27T16:59:06Z")
When you do an upgrade of a gateway, when/if should you re-download the designer launcher via the “Get Designer” button on the gateway page? Should it be done for every upgrade? Just on major version changes? After loo… --- ## [Reporting Charts - different jfree charts](https://forum.inductiveautomation.com/t/reporting-charts-different-jfree-charts/58880)
**Author:** [@daniel.thomson](https://forum.inductiveautomation.com/u/daniel.thomson)\ **Replies:** 2\ **Last updated:** [April 27, 2022, 4:21pm UTC](https://forum.inductiveautomation.com/t/reporting-charts-different-jfree-charts/58880 "2022-04-27T16:21:12Z")
Hello Hive Mind - currently trying to see if the reporting module can draw other chart variants supported by jfree chart but not necessarily in the set that is defined within the reporting module. Anyone ever successfull… --- ## [Reporting tables showing \ instead of real value](https://forum.inductiveautomation.com/t/reporting-tables-showing-list-instead-of-real-value/58859)
**Author:** [@Dolmen](https://forum.inductiveautomation.com/u/Dolmen)\ **Replies:** 2\ **Last updated:** [April 27, 2022, 4:00pm UTC](https://forum.inductiveautomation.com/t/reporting-tables-showing-list-instead-of-real-value/58859 "2022-04-27T16:00:22Z")
Hi, I am having an issue with a reporting table. One column in the table shows list as the value even when the real value is shown in the raw data xml table in the preview panel and in the DB query browser. Does anyon… --- ## [Excel file to PDF](https://forum.inductiveautomation.com/t/excel-file-to-pdf/58851)
**Author:** [@vani161998](https://forum.inductiveautomation.com/u/vani161998)\ **Replies:** 1\ **Last updated:** [April 27, 2022, 3:47pm UTC](https://forum.inductiveautomation.com/t/excel-file-to-pdf/58851 "2022-04-27T15:47:39Z")
hi, i am having my excel file as bytes in database .I want to convert my excel file to pdf in ignition perspective .how can i do that? --- ## [Error when passing a List to project script](https://forum.inductiveautomation.com/t/error-when-passing-a-list-to-project-script/58931)
**Author:** [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Replies:** 8\ **Last updated:** [April 27, 2022, 3:44pm UTC](https://forum.inductiveautomation.com/t/error-when-passing-a-list-to-project-script/58931 "2022-04-27T15:44:26Z")
This one has me a little stumped. I’m writing a project script function and I want to send a list as one of the parameters. However, I get a CastException error. I’m currently executing this in the script console. Ign… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=849) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=851)