# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=442 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 443 --- ## [Convert Epoch Time in SQL Query](https://forum.inductiveautomation.com/t/convert-epoch-time-in-sql-query/88644)
**Author:** [@NP209](https://forum.inductiveautomation.com/u/NP209)\ **Replies:** 20\ **Last updated:** [April 10, 2024, 4:02pm UTC](https://forum.inductiveautomation.com/t/convert-epoch-time-in-sql-query/88644 "2024-04-10T16:02:29Z")
Hello everyone, I'm trying to find the format for converting from epoch time to normal time. We have a PLC logging timestamps in epoch time and I can't get it working. I need to pull the last 3 minutes of data from this… --- ## [In perspective how to use print out the whole page into a PDF on a iPAD?](https://forum.inductiveautomation.com/t/in-perspective-how-to-use-print-out-the-whole-page-into-a-pdf-on-a-ipad/88641)
**Author:** [@jdenchev](https://forum.inductiveautomation.com/u/jdenchev)\ **Replies:** 9\ **Last updated:** [April 10, 2024, 3:46pm UTC](https://forum.inductiveautomation.com/t/in-perspective-how-to-use-print-out-the-whole-page-into-a-pdf-on-a-ipad/88641 "2024-04-10T15:46:02Z")
Just want to print out the whole page into a PDF. With iPAD, request print doesn't work, since there is no printer connected. However, system.perspective.print(page) doesn't work. Can someone help me with this? --- ## [Taking the sum of time that a machine is on(1), displaying value on label](https://forum.inductiveautomation.com/t/taking-the-sum-of-time-that-a-machine-is-on-1-displaying-value-on-label/88234)
**Author:** [@Nathaniel\_Webb](https://forum.inductiveautomation.com/u/Nathaniel_Webb)\ **Replies:** 7\ **Last updated:** [April 10, 2024, 3:15pm UTC](https://forum.inductiveautomation.com/t/taking-the-sum-of-time-that-a-machine-is-on-1-displaying-value-on-label/88234 "2024-04-10T15:15:46Z")
hello, I am creating a dashboard for four machines. We run them at the same time every week, 6am Monday to 6 am Friday. I would like to write a script to connect to historian and sum the time that it is running, excludi… --- ## [Perspective Workstation APK - Deployment](https://forum.inductiveautomation.com/t/perspective-workstation-apk-deployment/71337)
**Author:** [@tim.schultz](https://forum.inductiveautomation.com/u/tim.schultz)\ **Replies:** 3\ **Last updated:** [April 10, 2024, 3:13pm UTC](https://forum.inductiveautomation.com/t/perspective-workstation-apk-deployment/71337 "2024-04-10T15:13:58Z")
I'm trying to setup a staging tool to install Ignition on handheld computers running Android. I'm fairly new to the Android world so this may be a dumb question, but what is class name in this context? --- ## [Ignition to Maximo](https://forum.inductiveautomation.com/t/ignition-to-maximo/76599)
**Author:** [@jason.schwenk](https://forum.inductiveautomation.com/u/jason.schwenk)\ **Replies:** 3\ **Last updated:** [April 10, 2024, 2:35pm UTC](https://forum.inductiveautomation.com/t/ignition-to-maximo/76599 "2024-04-10T14:35:01Z")
So I did a search and didn't find anything on the subject.... Is there a way to integrate Ignition into Maximo? I can get get Maximo set up to trigger a WO on a trigger but I cannot find any info on how to get the ignit… --- ## [Bootstrap in Perspective](https://forum.inductiveautomation.com/t/bootstrap-in-perspective/88631)
**Author:** [@grzegorz.kaczmarczyk](https://forum.inductiveautomation.com/u/grzegorz.kaczmarczyk)\ **Replies:** 2\ **Last updated:** [April 10, 2024, 1:37pm UTC](https://forum.inductiveautomation.com/t/bootstrap-in-perspective/88631 "2024-04-10T13:37:55Z")
Can you use bootstrap in Perspective? --- ## [Issue: Websocket disconnecting](https://forum.inductiveautomation.com/t/issue-websocket-disconnecting/88627)
**Author:** [@Sam\_Bermejo](https://forum.inductiveautomation.com/u/Sam_Bermejo)\ **Replies:** 1\ **Last updated:** [April 10, 2024, 12:13pm UTC](https://forum.inductiveautomation.com/t/issue-websocket-disconnecting/88627 "2024-04-10T12:13:16Z")
Hi all, I'm experiencing some issues with the Ignition Gateway. The WebSocket keeps disconnecting and I am not sure what the cause of this is. The gateway is installed in a VM in an Azure Portal. Could anyone point out… --- ## [MQTT Engine publish interval](https://forum.inductiveautomation.com/t/mqtt-engine-publish-interval/88617)
**Author:** [@Karl\_Eckermann](https://forum.inductiveautomation.com/u/Karl_Eckermann)\ **Replies:** 1\ **Last updated:** [April 10, 2024, 12:09pm UTC](https://forum.inductiveautomation.com/t/mqtt-engine-publish-interval/88617 "2024-04-10T12:09:17Z")
Hi, New to Ignition. Any help is appreciated. I have been trying find a way the publish tags on a set interval. I currently have it working when a tag is modified it will publish to the MQTT engine. Is there a way to … --- ## [Progress bar in table](https://forum.inductiveautomation.com/t/progress-bar-in-table/88620)
**Author:** [@jrd](https://forum.inductiveautomation.com/u/jrd)\ **Replies:** 3\ **Last updated:** [April 10, 2024, 9:35am UTC](https://forum.inductiveautomation.com/t/progress-bar-in-table/88620 "2024-04-10T09:35:46Z")
Hi I'm trying to display percentComplete in a table as a progress bar My settings are as below, but no bar What have I missed? !\[image|203x500\](upload://iiKvu7bnT1UuLy0S4cxiCZe5WfW.png) --- ## [Perspectice XY Chart Tooltip](https://forum.inductiveautomation.com/t/perspectice-xy-chart-tooltip/47649)
**Author:** [@cfuta](https://forum.inductiveautomation.com/u/cfuta)\ **Replies:** 2\ **Last updated:** [April 10, 2024, 8:00am UTC](https://forum.inductiveautomation.com/t/perspectice-xy-chart-tooltip/47649 "2024-04-10T08:00:10Z")
I was wondering if how to change the tooltip location when a data point on a chart is close to the edge of the screen? Currently the tooltip will get cut off if the point is too close to the edge and I would like to make… --- ## [Designer Confirmation Exit GUI Bug with 4k Monitor](https://forum.inductiveautomation.com/t/designer-confirmation-exit-gui-bug-with-4k-monitor/86433)
**Author:** [@liam1](https://forum.inductiveautomation.com/u/liam1)\ **Replies:** 2\ **Last updated:** [April 10, 2024, 6:19am UTC](https://forum.inductiveautomation.com/t/designer-confirmation-exit-gui-bug-with-4k-monitor/86433 "2024-04-10T06:19:43Z")
Hi all, I'm running two 4k monitors and one 1080p laptop screen. When trying to close the designer , the "Confirm Exit" popup GUI is clipping off the buttons. This issue doesn't occur if I use1080p monitors. Is ther… --- ## [Perspective - How to add gradient color to the column in the XY chart](https://forum.inductiveautomation.com/t/perspective-how-to-add-gradient-color-to-the-column-in-the-xy-chart/88619)
**Author:** [@Gotham](https://forum.inductiveautomation.com/u/Gotham)\ **Replies:** 0\ **Last updated:** [April 10, 2024, 5:50am UTC](https://forum.inductiveautomation.com/t/perspective-how-to-add-gradient-color-to-the-column-in-the-xy-chart/88619 "2024-04-10T05:50:11Z")
--- ## [Vision Chart: Interpolation and visual bands](https://forum.inductiveautomation.com/t/vision-chart-interpolation-and-visual-bands/88491)
**Author:** [@Sasi\_Rai](https://forum.inductiveautomation.com/u/Sasi_Rai)\ **Replies:** 4\ **Last updated:** [April 10, 2024, 4:24am UTC](https://forum.inductiveautomation.com/t/vision-chart-interpolation-and-visual-bands/88491 "2024-04-10T04:24:57Z")
Hi Everyone, Given below is my Chart, in Vision. It displays a forecast of what the value of a certain Variable will be, in half hour intervals, the next 7 days. Just like a 7 days' temperature forecast. Even though … --- ## [Time/date transform in perspective table](https://forum.inductiveautomation.com/t/time-date-transform-in-perspective-table/88559)
**Author:** [@jrd](https://forum.inductiveautomation.com/u/jrd)\ **Replies:** 4\ **Last updated:** [April 10, 2024, 3:44am UTC](https://forum.inductiveautomation.com/t/time-date-transform-in-perspective-table/88559 "2024-04-10T03:44:14Z")
Hi Using perspective, I would like to display the 'scheduled events' data from an equipment schedule component in a table. I copied the binding, and all is fine.... except the format of the startDate and endDate fields… --- ## [\[BUG\] When deleting UDT Definition with no instances, warning shows anyway](https://forum.inductiveautomation.com/t/bug-when-deleting-udt-definition-with-no-instances-warning-shows-anyway/41824)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 2\ **Last updated:** [April 10, 2024, 1:34am UTC](https://forum.inductiveautomation.com/t/bug-when-deleting-udt-definition-with-no-instances-warning-shows-anyway/41824 "2024-04-10T01:34:50Z")
I made a new UDT type/definition and then deleted it (without creating any instances), and this warning still showed up: This prompt causes false concern as effectively it seems to appear regardless. --- ## [Printing from Perspective Workstation](https://forum.inductiveautomation.com/t/printing-from-perspective-workstation/88595)
**Author:** [@hw79](https://forum.inductiveautomation.com/u/hw79)\ **Replies:** 1\ **Last updated:** [April 10, 2024, 12:14am UTC](https://forum.inductiveautomation.com/t/printing-from-perspective-workstation/88595 "2024-04-10T00:14:41Z")
Is there a best practice to print from Perspective Workstation for iOS? I have a report I'd like to print but the download and open in new tab options don't appear in the report viewer on mobile. --- ## [Merging 2 different datasets](https://forum.inductiveautomation.com/t/merging-2-different-datasets/88597)
**Author:** [@Lowie\_Vanhaesbrouck](https://forum.inductiveautomation.com/u/Lowie_Vanhaesbrouck)\ **Replies:** 14\ **Last updated:** [April 9, 2024, 10:40pm UTC](https://forum.inductiveautomation.com/t/merging-2-different-datasets/88597 "2024-04-09T22:40:05Z")
Hello , I have 2 different datasets (normally same amount of rows but not now) But I don't know how to merge them , couldn't find it online to do it for my specific case. You can see how I tried to do it , and how the o… --- ## [Alarm Suspicious Events](https://forum.inductiveautomation.com/t/alarm-suspicious-events/88609)
**Author:** [@David\_Lopez](https://forum.inductiveautomation.com/u/David_Lopez)\ **Replies:** 0\ **Last updated:** [April 9, 2024, 10:20pm UTC](https://forum.inductiveautomation.com/t/alarm-suspicious-events/88609 "2024-04-09T22:20:03Z")
Hi there! I'm working on a Ignition 8.1.38 Vision project and I have been through many interesting alarm issues and questions. I created a UDT with a single memory tag for testing purposes. After creating a UDT instan… --- ## [Using Ignition Designer behind an http proxy](https://forum.inductiveautomation.com/t/using-ignition-designer-behind-an-http-proxy/50461)
**Author:** [@fpsileno](https://forum.inductiveautomation.com/u/fpsileno)\ **Replies:** 10\ **Last updated:** [April 2, 2024, 4:40pm UTC](https://forum.inductiveautomation.com/t/using-ignition-designer-behind-an-http-proxy/50461 "2024-04-02T16:40:23Z")
Hi, I'm trying to use Ignition Designer at work, behind a company http proxy. I'm having a lot of issues (and there is very little specific documentation about this). So far, I've managed to put this string in the "JVM… --- ## [Duplicate alarm records](https://forum.inductiveautomation.com/t/duplicate-alarm-records/88608)
**Author:** [@Ahmad\_Kammonah](https://forum.inductiveautomation.com/u/Ahmad_Kammonah)\ **Replies:** 1\ **Last updated:** [April 9, 2024, 9:28pm UTC](https://forum.inductiveautomation.com/t/duplicate-alarm-records/88608 "2024-04-09T21:28:20Z")
I was looking into query the alarm journal but I'm finding that every change of event (e.g. from active to clear or vice versa), the event is being recorded twice as show in the screenshot: This is the query I'm usin… --- ## [Set Automatic Zoom in browser when we open perspective session](https://forum.inductiveautomation.com/t/set-automatic-zoom-in-browser-when-we-open-perspective-session/88549)
**Author:** [@Raghavendra\_Praneeth](https://forum.inductiveautomation.com/u/Raghavendra_Praneeth)\ **Replies:** 4\ **Last updated:** [April 9, 2024, 8:13pm UTC](https://forum.inductiveautomation.com/t/set-automatic-zoom-in-browser-when-we-open-perspective-session/88549 "2024-04-09T20:13:16Z")
Whenever I open my perspective session in browser i see that automatic zoom is set to 100% and I manually change it to 75% to view my screen clearly. Can any one please suggest whether there is a way in Ignition where we… --- ## [Reorder Carousel Screens?](https://forum.inductiveautomation.com/t/reorder-carousel-screens/88594)
**Author:** [@Jeff\_Muldoon](https://forum.inductiveautomation.com/u/Jeff_Muldoon)\ **Replies:** 2\ **Last updated:** [April 9, 2024, 6:23pm UTC](https://forum.inductiveautomation.com/t/reorder-carousel-screens/88594 "2024-04-09T18:23:28Z")
I've searched and cannot seem to find a way to re-order my carousel views. I'd like to insert a new view in between 2 already created ones but can't seem to figure out a way to do it without redoing them all. Am I missi… --- ## [Remove Store and Forward Engine](https://forum.inductiveautomation.com/t/remove-store-and-forward-engine/19092)
**Author:** [@martinel37461](https://forum.inductiveautomation.com/u/martinel37461)\ **Replies:** 3\ **Last updated:** [April 9, 2024, 5:27pm UTC](https://forum.inductiveautomation.com/t/remove-store-and-forward-engine/19092 "2024-04-09T17:27:04Z")
I've deleted a database but the Store and Forward engine is still in place. Throughput is "N/A", quarantined is 0 and activity is "unavailable". I can't find a way to delete the Store and Forward Engine. I'm sure it's … --- ## [Perspective client not showing table data](https://forum.inductiveautomation.com/t/perspective-client-not-showing-table-data/70031)
**Author:** [@Ly17](https://forum.inductiveautomation.com/u/Ly17)\ **Replies:** 11\ **Last updated:** [April 9, 2024, 4:52pm UTC](https://forum.inductiveautomation.com/t/perspective-client-not-showing-table-data/70031 "2024-04-09T16:52:04Z")
I have a perspective table with a named query binding that returns data which I can see in the designer but when I run the client, the table doesn't show any data. What's causing this? Tables with manually entered data s… --- ## [Parsing SAML response for Active Directory Memberships](https://forum.inductiveautomation.com/t/parsing-saml-response-for-active-directory-memberships/44405)
**Author:** [@nicholas.robinson](https://forum.inductiveautomation.com/u/nicholas.robinson)\ **Replies:** 13\ **Last updated:** [April 9, 2024, 4:07pm UTC](https://forum.inductiveautomation.com/t/parsing-saml-response-for-active-directory-memberships/44405 "2024-04-09T16:07:24Z")
In our SAML response we can get a list of active directories that a person is part of, we intend to use this to control access and access level. The data contained in the attribute value is an array. When I use the fol… --- ## [How to add the second attachment onto Perspective email](https://forum.inductiveautomation.com/t/how-to-add-the-second-attachment-onto-perspective-email/88582)
**Author:** [@jdenchev](https://forum.inductiveautomation.com/u/jdenchev)\ **Replies:** 1\ **Last updated:** [April 9, 2024, 3:25pm UTC](https://forum.inductiveautomation.com/t/how-to-add-the-second-attachment-onto-perspective-email/88582 "2024-04-09T15:25:53Z")
I set up a button to click to email out a PDF report as attachment. However, how can I add the second attachment PDF to the same email? It means I can send out one email with two attachment. How can I do that? def runAc… --- ## [Not a built-in type: class java.math.BigInteger](https://forum.inductiveautomation.com/t/not-a-built-in-type-class-java-math-biginteger/88579)
**Author:** [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Replies:** 2\ **Last updated:** [April 9, 2024, 3:17pm UTC](https://forum.inductiveautomation.com/t/not-a-built-in-type-class-java-math-biginteger/88579 "2024-04-09T15:17:37Z")
When doing arithmetic with jython longs, and passing them into system.opc.write\*(), I'm getting scary backtraces: 2024/04/09 14:25:26.554 | W \[o.e.m.o.s.c.s.OpcUaBinaryStreamEncoder\] \[14:25:26\]: Not a built-in type: cla… --- ## [Perspective table dynamic row highlights](https://forum.inductiveautomation.com/t/perspective-table-dynamic-row-highlights/88580)
**Author:** [@Aron\_Grzywaczewski](https://forum.inductiveautomation.com/u/Aron_Grzywaczewski)\ **Replies:** 1\ **Last updated:** [April 9, 2024, 2:41pm UTC](https://forum.inductiveautomation.com/t/perspective-table-dynamic-row-highlights/88580 "2024-04-09T14:41:01Z")
Can I create a row highlight based on a value of certain column in perspective? I know this could be done in vision, but I am not sure about perspective. Here is an example, I want to highlight the rows in green when t… --- ## [Save/restore component properties to DB](https://forum.inductiveautomation.com/t/save-restore-component-properties-to-db/88383)
**Author:** [@David\_Nicks](https://forum.inductiveautomation.com/u/David_Nicks)\ **Replies:** 10\ **Last updated:** [April 9, 2024, 2:25pm UTC](https://forum.inductiveautomation.com/t/save-restore-component-properties-to-db/88383 "2024-04-09T14:25:19Z")
v8.1 Trying to build a couple functions that will allow users to save runtime configurations (e.g. table filtering/columns/sorting/etc) into a DB so they can be sticky between sessions. I have a decent working prototype… --- ## [Table of visualisation](https://forum.inductiveautomation.com/t/table-of-visualisation/88577)
**Author:** [@yahia\_alem](https://forum.inductiveautomation.com/u/yahia_alem)\ **Replies:** 4\ **Last updated:** [April 9, 2024, 2:03pm UTC](https://forum.inductiveautomation.com/t/table-of-visualisation/88577 "2024-04-09T14:03:51Z")
Hello, I'm wondering if in ignition I can open a table of visualition in real time ? something like the tables in TIA portal ? Thank you [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=441) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=443)