# Latest

**URL:** https://forum.inductiveautomation.com/latest.md?page=457

[Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md)

**Page:** 458

---

## [Pulling datetime from SQL](https://forum.inductiveautomation.com/t/pulling-datetime-from-sql/62091)

<div class="topic-metadata">

**Author:** [@CMuecke](https://forum.inductiveautomation.com/u/CMuecke)\
**Replies:** 11\
**Last updated:** [June 19, 2024, 1:10am UTC](https://forum.inductiveautomation.com/t/pulling-datetime-from-sql/62091 "2024-06-19T01:10:06Z")

</div>

I am grabbing a table from SQL that has a datetime column. How do I get that time converted to a readable Date and Time?

---

## [Perspective Sparkline Chart Dynamic Tag History Time Range](https://forum.inductiveautomation.com/t/perspective-sparkline-chart-dynamic-tag-history-time-range/92052)

<div class="topic-metadata">

**Author:** [@Randolph\_Sewell](https://forum.inductiveautomation.com/u/Randolph_Sewell)\
**Replies:** 1\
**Last updated:** [June 18, 2024, 11:49pm UTC](https://forum.inductiveautomation.com/t/perspective-sparkline-chart-dynamic-tag-history-time-range/92052 "2024-06-18T23:49:07Z")

</div>

I want to bind the sparklines history query time range to something just like how I can with the tag path but for some reason there's not a property for that. For example I want them to be able to change it from last 2 h…

---

## [Issue with Basic Division in Gateway Event Script](https://forum.inductiveautomation.com/t/issue-with-basic-division-in-gateway-event-script/92051)

<div class="topic-metadata">

**Author:** [@Matthew\_Karee](https://forum.inductiveautomation.com/u/Matthew_Karee)\
**Replies:** 2\
**Last updated:** [June 18, 2024, 10:04pm UTC](https://forum.inductiveautomation.com/t/issue-with-basic-division-in-gateway-event-script/92051 "2024-06-18T22:04:45Z")

</div>

I'm trying to do a very basic division operation within a Gateway Tag Change Script and I'm getting an error saying the tag change script cannot be executed. #both tags called below are floats: scrapQuantity = system.ta…

---

## [Deleting historical records from the module code](https://forum.inductiveautomation.com/t/deleting-historical-records-from-the-module-code/92048)

<div class="topic-metadata">

**Author:** [@Christopher\_Campbell](https://forum.inductiveautomation.com/u/Christopher_Campbell)\
**Replies:** 4\
**Last updated:** [June 18, 2024, 9:26pm UTC](https://forum.inductiveautomation.com/t/deleting-historical-records-from-the-module-code/92048 "2024-06-18T21:26:53Z")

</div>

I have a module that is using the DatasourceManager to create a table in a SQL db and write BasicHistoricalRecords. I would like to be able to prune data from this table that is too old, or based on another event. I ca…

---

## [Best way to print values from Gateway Event Scipt for debugging purposes](https://forum.inductiveautomation.com/t/best-way-to-print-values-from-gateway-event-scipt-for-debugging-purposes/92049)

<div class="topic-metadata">

**Author:** [@Matthew\_Karee](https://forum.inductiveautomation.com/u/Matthew_Karee)\
**Replies:** 3\
**Last updated:** [June 18, 2024, 9:09pm UTC](https://forum.inductiveautomation.com/t/best-way-to-print-values-from-gateway-event-scipt-for-debugging-purposes/92049 "2024-06-18T21:09:12Z")

</div>

I'm debugging a Gateway Tag Change Script and need to print some intermediary values from my program. Which console or log would be easiest to do this in? What is the syntax?

---

## [Report to usable excel file](https://forum.inductiveautomation.com/t/report-to-usable-excel-file/41462)

<div class="topic-metadata">

**Author:** [@vasilevdim](https://forum.inductiveautomation.com/u/vasilevdim)\
**Replies:** 5\
**Last updated:** [June 18, 2024, 8:59pm UTC](https://forum.inductiveautomation.com/t/report-to-usable-excel-file/41462 "2024-06-18T20:59:55Z")

</div>

Hi, Guys, I have a report designed with simple table, which I export to excel file. It works, but actually this excel file is not usable, since the data is in text boxes. Of course, there are ways to convert the text bo…

---

## [How to store sticky data on page](https://forum.inductiveautomation.com/t/how-to-store-sticky-data-on-page/92047)

<div class="topic-metadata">

**Author:** [@Eugene49](https://forum.inductiveautomation.com/u/Eugene49)\
**Replies:** 3\
**Last updated:** [June 18, 2024, 8:27pm UTC](https://forum.inductiveautomation.com/t/how-to-store-sticky-data-on-page/92047 "2024-06-18T20:27:23Z")

</div>

This is a long shot, But is there away to store data on page, such that when I exit that page, and later re-enter that page those data is the same as it was when I left page? I do not want to store it on session, as I …

---

## [What is the execution behavior of Gateway Tag Change Scripts that have multiple tags?](https://forum.inductiveautomation.com/t/what-is-the-execution-behavior-of-gateway-tag-change-scripts-that-have-multiple-tags/92030)

<div class="topic-metadata">

**Author:** [@framebuilder](https://forum.inductiveautomation.com/u/framebuilder)\
**Replies:** 6\
**Last updated:** [June 18, 2024, 7:57pm UTC](https://forum.inductiveautomation.com/t/what-is-the-execution-behavior-of-gateway-tag-change-scripts-that-have-multiple-tags/92030 "2024-06-18T19:57:53Z")

</div>

We're running into an issue with a Gateway Tag Change Script. It seems like if you define multiple tags as triggers, that the associated script is executed one-by-one synchronously (in series). All tags are in the defa…

---

## [Pulsing outputs](https://forum.inductiveautomation.com/t/pulsing-outputs/92044)

<div class="topic-metadata">

**Author:** [@Mitchell\_Gerber](https://forum.inductiveautomation.com/u/Mitchell_Gerber)\
**Replies:** 2\
**Last updated:** [June 18, 2024, 7:46pm UTC](https://forum.inductiveautomation.com/t/pulsing-outputs/92044 "2024-06-18T19:46:18Z")

</div>

Is there a way to pulse outputs in perspective? I am trying to make an icon flash and not sure the best way to go about it. The flash is controlled by a tag turning on. Thanks!

---

## [Views need to be re-opened to refresh messaging scripts](https://forum.inductiveautomation.com/t/views-need-to-be-re-opened-to-refresh-messaging-scripts/91765)

<div class="topic-metadata">

**Author:** [@mal](https://forum.inductiveautomation.com/u/mal)\
**Replies:** 1\
**Last updated:** [June 18, 2024, 7:44pm UTC](https://forum.inductiveautomation.com/t/views-need-to-be-re-opened-to-refresh-messaging-scripts/91765 "2024-06-18T19:44:15Z")

</div>

Hey Ya'll. We started using Messages heavily in Perspective and they are great. However, there is a very annoying bug that requires a view to be closed and re-opened in the designer for scripts associated to messages …

---

## [runPrepUpdate vs runUpdateQuery](https://forum.inductiveautomation.com/t/runprepupdate-vs-runupdatequery/75197)

<div class="topic-metadata">

**Author:** [@Joseph\_Loh](https://forum.inductiveautomation.com/u/Joseph_Loh)\
**Replies:** 16\
**Last updated:** [June 18, 2024, 7:19pm UTC](https://forum.inductiveautomation.com/t/runprepupdate-vs-runupdatequery/75197 "2024-06-18T19:19:43Z")

</div>

I'm writing an insert into query to add a row of data into a table with 5 columns. From reading the doc, I assume I don't need to use prep update as my data is not being typed out by user and doesn't contain additional…

---

## [Issue for creating a Microsoft Sever](https://forum.inductiveautomation.com/t/issue-for-creating-a-microsoft-sever/89119)

<div class="topic-metadata">

**Author:** [@Trung\_Tin\_Nguyen](https://forum.inductiveautomation.com/u/Trung_Tin_Nguyen)\
**Replies:** 8\
**Last updated:** [June 18, 2024, 6:58pm UTC](https://forum.inductiveautomation.com/t/issue-for-creating-a-microsoft-sever/89119 "2024-06-18T18:58:57Z")

</div>

Had this pop up when I was trying to create a sever according to the Inductive University, anyone have any ideas? Cannot create PoolableConnectionFactory (Login failed for user 'admin'. ClientConnectionId:c64ce8ea-fca2-…

---

## [Opening perspective app inside iframe considerations?](https://forum.inductiveautomation.com/t/opening-perspective-app-inside-iframe-considerations/92014)

<div class="topic-metadata">

**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Replies:** 2\
**Last updated:** [June 18, 2024, 6:20pm UTC](https://forum.inductiveautomation.com/t/opening-perspective-app-inside-iframe-considerations/92014 "2024-06-18T18:20:57Z")

</div>

Customer wants to use something called Spartan App or Spartan Framework. Seems like it's an internal website that has links to the various tools the team uses (like jupyter notebooks) and they want to be able to add a l…

---

## [How to run a script continuously to update tags](https://forum.inductiveautomation.com/t/how-to-run-a-script-continuously-to-update-tags/92018)

<div class="topic-metadata">

**Author:** [@Mitchell\_Gerber](https://forum.inductiveautomation.com/u/Mitchell_Gerber)\
**Replies:** 5\
**Last updated:** [June 18, 2024, 5:48pm UTC](https://forum.inductiveautomation.com/t/how-to-run-a-script-continuously-to-update-tags/92018 "2024-06-18T17:48:12Z")

</div>

I currently have a script written for on start up to update an items visibility based on a tag value. I want this to continuously update as the tag value changes. How should I go about this? Thanks!

---

## [Tag History Provider error](https://forum.inductiveautomation.com/t/tag-history-provider-error/92033)

<div class="topic-metadata">

**Author:** [@Steven\_Cheron](https://forum.inductiveautomation.com/u/Steven_Cheron)\
**Replies:** 0\
**Last updated:** [June 18, 2024, 3:44pm UTC](https://forum.inductiveautomation.com/t/tag-history-provider-error/92033 "2024-06-18T15:44:57Z")

</div>

Hi, I have a scale-out architecture (front-end and back-end gateways) and a MSSQL database. On the back-end gateway, I've setting up the tag provider and the historical provider. It works well. On the front-end gatewa…

---

## [viewParams in an embedded view inside of a tableRow](https://forum.inductiveautomation.com/t/viewparams-in-an-embedded-view-inside-of-a-tablerow/92029)

<div class="topic-metadata">

**Author:** [@Matthew\_Breeding](https://forum.inductiveautomation.com/u/Matthew_Breeding)\
**Replies:** 5\
**Last updated:** [June 18, 2024, 5:42pm UTC](https://forum.inductiveautomation.com/t/viewparams-in-an-embedded-view-inside-of-a-tablerow/92029 "2024-06-18T17:42:35Z")

</div>

So I know in the column of a table you can make it render a component in each row of that column and apply params that apply to every row, I was wondering if there is a way to assign params for EACH row What I'm trying …

---

## [Creating postgresql schemas and tables](https://forum.inductiveautomation.com/t/creating-postgresql-schemas-and-tables/92024)

<div class="topic-metadata">

**Author:** [@Josh\_Hoover](https://forum.inductiveautomation.com/u/Josh_Hoover)\
**Replies:** 3\
**Last updated:** [June 18, 2024, 5:31pm UTC](https://forum.inductiveautomation.com/t/creating-postgresql-schemas-and-tables/92024 "2024-06-18T17:31:49Z")

</div>

So, I'm attempting to use ignition scripting to create schemas and tables in postgres and am stuck. Part of my code is below (the part that gives an error): I'm not sure what else to try. Any feedback will be apprecia…

---

## [How to dynamically get valid descriptions and display names for all alarm event properties?](https://forum.inductiveautomation.com/t/how-to-dynamically-get-valid-descriptions-and-display-names-for-all-alarm-event-properties/91994)

<div class="topic-metadata">

**Author:** [@tyler.bennett](https://forum.inductiveautomation.com/u/tyler.bennett)\
**Replies:** 3\
**Last updated:** [June 18, 2024, 4:45pm UTC](https://forum.inductiveautomation.com/t/how-to-dynamically-get-valid-descriptions-and-display-names-for-all-alarm-event-properties/91994 "2024-06-18T16:45:41Z")

</div>

When interrogating the properties (CommonAlarmProperties) of an alarm event (PyAlarmEvent) object, as returned from system.alarm.queryStatus() I have noticed that the getDescription() method returns a LocalizedString obj…

---

## ["Object not callable error" on a project script](https://forum.inductiveautomation.com/t/object-not-callable-error-on-a-project-script/92028)

<div class="topic-metadata">

**Author:** [@sean\_dysinger](https://forum.inductiveautomation.com/u/sean_dysinger)\
**Replies:** 13\
**Last updated:** [June 18, 2024, 4:24pm UTC](https://forum.inductiveautomation.com/t/object-not-callable-error-on-a-project-script/92028 "2024-06-18T16:24:50Z")

</div>

I am sure I am missing something in the path or something stupid but - doing some testing with project script using an event script on a button. I keep getting the error below. not callable pdf.pdf (116.9 KB)

---

## [Update tag based on condition](https://forum.inductiveautomation.com/t/update-tag-based-on-condition/92025)

<div class="topic-metadata">

**Author:** [@michael.black](https://forum.inductiveautomation.com/u/michael.black)\
**Replies:** 4\
**Last updated:** [June 18, 2024, 3:50pm UTC](https://forum.inductiveautomation.com/t/update-tag-based-on-condition/92025 "2024-06-18T15:50:39Z")

</div>

I have a situation where I have an OPC tag that I am reading in, however if a certain condition happens, lets just say a boolean tag, I dont want to update the tag from the plc, instead I want to keep the tag value the s…

---

## [How do I do an if expression in perspective?](https://forum.inductiveautomation.com/t/how-do-i-do-an-if-expression-in-perspective/92032)

<div class="topic-metadata">

**Author:** [@Mitchell\_Gerber](https://forum.inductiveautomation.com/u/Mitchell_Gerber)\
**Replies:** 2\
**Last updated:** [June 18, 2024, 3:49pm UTC](https://forum.inductiveautomation.com/t/how-do-i-do-an-if-expression-in-perspective/92032 "2024-06-18T15:49:04Z")

</div>

This is what I have but it will not work as intended.

---

## [Vision aplication](https://forum.inductiveautomation.com/t/vision-aplication/92026)

<div class="topic-metadata">

**Author:** [@Christian\_Tovanche](https://forum.inductiveautomation.com/u/Christian_Tovanche)\
**Replies:** 5\
**Last updated:** [June 18, 2024, 2:52pm UTC](https://forum.inductiveautomation.com/t/vision-aplication/92026 "2024-06-18T14:52:29Z")

</div>

help me with this error. Logged in with my username and password of my gateway

---

## [Alarming display path pulling from an array](https://forum.inductiveautomation.com/t/alarming-display-path-pulling-from-an-array/91980)

<div class="topic-metadata">

**Author:** [@Julien](https://forum.inductiveautomation.com/u/Julien)\
**Replies:** 6\
**Last updated:** [June 18, 2024, 2:47pm UTC](https://forum.inductiveautomation.com/t/alarming-display-path-pulling-from-an-array/91980 "2024-06-18T14:47:54Z")

</div>

I am using a Bool array to create alarms, and trying to pull from a String array of the same size to get my alarms descriptions but it seems like I cannot use the bit position to do so. If I use {\[~\]String\_Array\_Desc\[0\]…

---

## [View Canvas - precisely place center of embedded view?](https://forum.inductiveautomation.com/t/view-canvas-precisely-place-center-of-embedded-view/91036)

<div class="topic-metadata">

**Author:** [@msteele](https://forum.inductiveautomation.com/u/msteele)\
**Replies:** 1\
**Last updated:** [June 18, 2024, 2:44pm UTC](https://forum.inductiveautomation.com/t/view-canvas-precisely-place-center-of-embedded-view/91036 "2024-06-18T14:44:20Z")

</div>

I'm building process diagrams with embedded views as items in a view canvas where content must be dynamic or at least indirected at runtime, but then a SVG canvas for items that are persistent. Both the view canvas and e…

---

## [Import different projects in same Gateway](https://forum.inductiveautomation.com/t/import-different-projects-in-same-gateway/92019)

<div class="topic-metadata">

**Author:** [@Dhiraj\_Khandelwal](https://forum.inductiveautomation.com/u/Dhiraj_Khandelwal)\
**Replies:** 2\
**Last updated:** [June 18, 2024, 2:16pm UTC](https://forum.inductiveautomation.com/t/import-different-projects-in-same-gateway/92019 "2024-06-18T14:16:57Z")

</div>

I want to import a different project with different UDTs and tags. When I import a different project, I see the tags are from previous project. What can I do to gets the tags related to that Projects?

---

## [Expression Function not returning Boolean](https://forum.inductiveautomation.com/t/expression-function-not-returning-boolean/92015)

<div class="topic-metadata">

**Author:** [@Ryan\_Craig](https://forum.inductiveautomation.com/u/Ryan_Craig)\
**Replies:** 3\
**Last updated:** [June 18, 2024, 1:59pm UTC](https://forum.inductiveautomation.com/t/expression-function-not-returning-boolean/92015 "2024-06-18T13:59:19Z")

</div>

I am using an expression function to try and flip a buttons enabled property on and off, based on tags. This is the current expression I have: if({this.custom.insReady} || {this.custom.prgrm} = 1, 'true', 'false' ) …

---

## [Trending: Realtime vs. Historic Tags and Tag Browse Tree](https://forum.inductiveautomation.com/t/trending-realtime-vs-historic-tags-and-tag-browse-tree/92017)

<div class="topic-metadata">

**Author:** [@kcui](https://forum.inductiveautomation.com/u/kcui)\
**Replies:** 0\
**Last updated:** [June 18, 2024, 1:55pm UTC](https://forum.inductiveautomation.com/t/trending-realtime-vs-historic-tags-and-tag-browse-tree/92017 "2024-06-18T13:55:35Z")

</div>

This may seem like a real basic question but I'm still a bit unclear after reading the Tag Provider section in the Manual. I have a series of tags in my tag provider that have historization enabled. When I use the Tag …

---

## [Dynamically Create/Update/Replace Custom Properties with bindings and change scripts](https://forum.inductiveautomation.com/t/dynamically-create-update-replace-custom-properties-with-bindings-and-change-scripts/48325)

<div class="topic-metadata">

**Author:** [@mal](https://forum.inductiveautomation.com/u/mal)\
**Replies:** 2\
**Last updated:** [June 18, 2024, 1:51pm UTC](https://forum.inductiveautomation.com/t/dynamically-create-update-replace-custom-properties-with-bindings-and-change-scripts/48325 "2024-06-18T13:51:19Z")

</div>

We recently learned that Perspective Session Properties created in parent projects are not inheritable by child projects. We are looking for a workaround for this issue as we are developing a fairly sizeable code base w…

---

## [Change color for each option based on some category for Perspective Dropdown Component](https://forum.inductiveautomation.com/t/change-color-for-each-option-based-on-some-category-for-perspective-dropdown-component/37952)

<div class="topic-metadata">

**Author:** [@harigobu.gb](https://forum.inductiveautomation.com/u/harigobu.gb)\
**Replies:** 13\
**Last updated:** [June 18, 2024, 1:28pm UTC](https://forum.inductiveautomation.com/t/change-color-for-each-option-based-on-some-category-for-perspective-dropdown-component/37952 "2024-06-18T13:28:58Z")

</div>

Hi, How to change the color for each option dynamically when the page is loaded based on the categories. Options will be binded from database using named query. Thanks in advance.

---

## [Ignition 8.1 gateway stopped and not restarting](https://forum.inductiveautomation.com/t/ignition-8-1-gateway-stopped-and-not-restarting/92011)

<div class="topic-metadata">

**Author:** [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\
**Replies:** 6\
**Last updated:** [June 18, 2024, 1:10pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-gateway-stopped-and-not-restarting/92011 "2024-06-18T13:10:20Z")

</div>

My Ignition gateway has stop and is not restarting, what I can do to make it start again? this is from my wrapper.txt INFO | jvm 83 | 2024/06/18 10:46:07 | I \[IgnitionGateway \] \[10:46:07.773\]: Ignitio…

[Previous page](https://forum.inductiveautomation.com/latest.md?page=456)

[Next page](https://forum.inductiveautomation.com/latest.md?page=458)
