# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=935 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 936 --- ## [Filteralarm for Acknowledged alarms that have been acknowledged less than 12 hours](https://forum.inductiveautomation.com/t/filteralarm-for-acknowledged-alarms-that-have-been-acknowledged-less-than-12-hours/52843)
**Author:** [@dfenter](https://forum.inductiveautomation.com/u/dfenter)\ **Replies:** 1\ **Last updated:** [November 8, 2021, 8:26pm UTC](https://forum.inductiveautomation.com/t/filteralarm-for-acknowledged-alarms-that-have-been-acknowledged-less-than-12-hours/52843 "2021-11-08T20:26:38Z")
I am trying to use the filteralarm script to have our alarm status table show acknowledged alarms that have been acknowledged for less than 12 hours. Using the IsAcked, AckTime, and other scripting functions I came up w… --- ## [Event Logging in Edge](https://forum.inductiveautomation.com/t/event-logging-in-edge/52840)
**Author:** [@Preston\_Barnett](https://forum.inductiveautomation.com/u/Preston_Barnett)\ **Replies:** 2\ **Last updated:** [November 8, 2021, 8:18pm UTC](https://forum.inductiveautomation.com/t/event-logging-in-edge/52840 "2021-11-08T20:18:06Z")
Hey everyone, I’m trying to accomplish event logging in Ignition Edge, and it’s been giving me real trouble with each solution I try to come up with. I’m wanting to accomplish something like the following. The yellow li… --- ## [Change the center length of conveyor based on template size](https://forum.inductiveautomation.com/t/change-the-center-length-of-conveyor-based-on-template-size/52791)
**Author:** [@markusx1094](https://forum.inductiveautomation.com/u/markusx1094)\ **Replies:** 3\ **Last updated:** [November 7, 2021, 4:10am UTC](https://forum.inductiveautomation.com/t/change-the-center-length-of-conveyor-based-on-template-size/52791 "2021-11-07T04:10:59Z")
What I am trying to do is to get center lines and background “bound” to the top left and bottom right corners without distorting the width of the lines and background so everything lines up correctly. I know I could… --- ## [SQL help, I have redundant rows and my grouping is not right](https://forum.inductiveautomation.com/t/sql-help-i-have-redundant-rows-and-my-grouping-is-not-right/52797)
**Author:** [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Replies:** 22\ **Last updated:** [November 8, 2021, 5:47pm UTC](https://forum.inductiveautomation.com/t/sql-help-i-have-redundant-rows-and-my-grouping-is-not-right/52797 "2021-11-08T17:47:03Z")
SELECT Top 40 myCode, Count (myCode), myQuantity FROM testmytable where (t\_stamp between '2021-10-01' and '2021-11-01' or t\_stamp \> DATEADD(minute, -500, GETUTCDATE())) Group by myCode, myQuantity order by Sum(myQuanti… --- ## [Convert seconds to HH MM SS](https://forum.inductiveautomation.com/t/convert-seconds-to-hh-mm-ss/8739)
**Author:** [@Paullys50](https://forum.inductiveautomation.com/u/Paullys50)\ **Replies:** 22\ **Last updated:** [November 8, 2021, 4:49pm UTC](https://forum.inductiveautomation.com/t/convert-seconds-to-hh-mm-ss/8739 "2021-11-08T16:49:26Z")
I am reading a tag in my PLC which is a count down timer, in seconds. I need to show this countdown time on a display, but I need the format to change to HH:MM:SS. How can I do this? I thought about using a expressi… --- ## [AD idp / mqtt edge (Beginner)](https://forum.inductiveautomation.com/t/ad-idp-mqtt-edge-beginner/52571)
**Author:** [@Kelltek](https://forum.inductiveautomation.com/u/Kelltek)\ **Replies:** 4\ **Last updated:** [November 8, 2021, 4:32pm UTC](https://forum.inductiveautomation.com/t/ad-idp-mqtt-edge-beginner/52571 "2021-11-08T16:32:41Z")
Greetings, First off I am new to igntion. I am a student and trying to get some projects set up for demo and learning purposes. I have two qestions I would like some information or clarification on. I am using Active… --- ## [Calling function on another gateway?](https://forum.inductiveautomation.com/t/calling-function-on-another-gateway/51926)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 12\ **Last updated:** [November 8, 2021, 4:22pm UTC](https://forum.inductiveautomation.com/t/calling-function-on-another-gateway/51926 "2021-11-08T16:22:47Z")
I have a split frontend/backend gateway architecture with two gateways and I’m trying to set up a page which displays all devices and allow the user (engineers) to enable/disable the connections from there. However becau… --- ## [Logix Driver fails to read/write CompactLogix 5380 Tags](https://forum.inductiveautomation.com/t/logix-driver-fails-to-read-write-compactlogix-5380-tags/52709)
**Author:** [@Falconb](https://forum.inductiveautomation.com/u/Falconb)\ **Replies:** 9\ **Last updated:** [November 8, 2021, 3:46pm UTC](https://forum.inductiveautomation.com/t/logix-driver-fails-to-read-write-compactlogix-5380-tags/52709 "2021-11-08T15:46:35Z")
Ignition 7.9.17 Logix Driver 3.9.17 Hi, We are using the latest Rockwell CompactLogix 5380 PLC running firmware 28 and using Ignition 7.9.17 to develop our project. I have found the Ignition project can’t read any of t… --- ## [Is it possible can we show scroll bar on few columns not on complete table in perspective ignition](https://forum.inductiveautomation.com/t/is-it-possible-can-we-show-scroll-bar-on-few-columns-not-on-complete-table-in-perspective-ignition/52823)
**Author:** [@Yatika\_Goel](https://forum.inductiveautomation.com/u/Yatika_Goel)\ **Replies:** 4\ **Last updated:** [November 8, 2021, 10:11am UTC](https://forum.inductiveautomation.com/t/is-it-possible-can-we-show-scroll-bar-on-few-columns-not-on-complete-table-in-perspective-ignition/52823 "2021-11-08T10:11:01Z")
Is it possible can we show scroll bar on few columns not on complete table in perspective ignition. --- ## [NJ Omron Driver question](https://forum.inductiveautomation.com/t/nj-omron-driver-question/52824)
**Author:** [@1050738465](https://forum.inductiveautomation.com/u/1050738465)\ **Replies:** 0\ **Last updated:** [November 8, 2021, 9:10am UTC](https://forum.inductiveautomation.com/t/nj-omron-driver-question/52824 "2021-11-08T09:10:12Z")
I am using NJ Omron driver in opcua devices to connect my PLC: nj501-1400，all connection settings are default. There is a bool array arr in PLC. When its length is greater than 941, there will be a value transmission err… --- ## [Get device Hostname in tag or scripting API](https://forum.inductiveautomation.com/t/get-device-hostname-in-tag-or-scripting-api/52819)
**Author:** [@hayden](https://forum.inductiveautomation.com/u/hayden)\ **Replies:** 2\ **Last updated:** [November 8, 2021, 7:41am UTC](https://forum.inductiveautomation.com/t/get-device-hostname-in-tag-or-scripting-api/52819 "2021-11-08T07:41:09Z")
I need to read the devices IP addresses in a diagnostics mimic, is there any way to get the IP as a tag or through scripting? --- ## [Launch Perspective Session from Designer Failing](https://forum.inductiveautomation.com/t/launch-perspective-session-from-designer-failing/52784)
**Author:** [@jacob.ramirez](https://forum.inductiveautomation.com/u/jacob.ramirez)\ **Replies:** 4\ **Last updated:** [November 8, 2021, 1:09am UTC](https://forum.inductiveautomation.com/t/launch-perspective-session-from-designer-failing/52784 "2021-11-08T01:09:25Z")
Has anyone had any problems with launching a session from the designer either by tools → Launch Perspective → Launch Session OR right-clicking a page configuration and selecting launch URL? I am running 8.1.11 (b2021101… --- ## [postgreSQL generate\_series in v9.6 vs 12.8](https://forum.inductiveautomation.com/t/postgresql-generate-series-in-v9-6-vs-12-8/52815)
**Author:** [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Replies:** 9\ **Last updated:** [November 7, 2021, 4:30pm UTC](https://forum.inductiveautomation.com/t/postgresql-generate-series-in-v9-6-vs-12-8/52815 "2021-11-07T16:30:01Z")
Can somebody shed some light on this: Why the same query in PostgreSQL v9.6 works and in v12.8 doesn’t anymore: postgreSQL v9.6 postgreSQL v12.8: I have this query in my Vision window which works in PostgreSQL v… --- ## [Report table with groups across page breaks issue](https://forum.inductiveautomation.com/t/report-table-with-groups-across-page-breaks-issue/52483)
**Author:** [@josborn](https://forum.inductiveautomation.com/u/josborn)\ **Replies:** 1\ **Last updated:** [November 7, 2021, 12:32am UTC](https://forum.inductiveautomation.com/t/report-table-with-groups-across-page-breaks-issue/52483 "2021-11-07T00:32:58Z")
There is probably something obvious i am missing here, but how do you prevent groups on a table from being broken across pages? The top most group will always span pages, which is fine as its header repeats on each p… --- ## [Modbus TCP address X320m](https://forum.inductiveautomation.com/t/modbus-tcp-address-x320m/52802)
**Author:** [@Kelltek](https://forum.inductiveautomation.com/u/Kelltek)\ **Replies:** 2\ **Last updated:** [November 6, 2021, 2:25pm UTC](https://forum.inductiveautomation.com/t/modbus-tcp-address-x320m/52802 "2021-11-06T14:25:40Z")
I have an x-320M control by web device that supports modbus/tcp. Unfortunately I can’t seem to map any registers. Even with a good connection to the device any tags or address structure times out or reports bad. I… --- ## [Modbus RTU to TCP times out and disconnects](https://forum.inductiveautomation.com/t/modbus-rtu-to-tcp-times-out-and-disconnects/52800)
**Author:** [@Kallie\_Winners](https://forum.inductiveautomation.com/u/Kallie_Winners)\ **Replies:** 2\ **Last updated:** [November 5, 2021, 11:11pm UTC](https://forum.inductiveautomation.com/t/modbus-rtu-to-tcp-times-out-and-disconnects/52800 "2021-11-05T23:11:31Z")
I’m trying to connect an ISCO Signature Flow Meter https://www.rshydro.co.uk/files/Signature-Manual.pdf over network to our Ignition gateway and read the tags. The ISCO is modbus 485 output, we are going through a Moxa … --- ## [Database connection either MySQL or MSSQLEXPRESS](https://forum.inductiveautomation.com/t/database-connection-either-mysql-or-mssqlexpress/52789)
**Author:** [@heberalanis1](https://forum.inductiveautomation.com/u/heberalanis1)\ **Replies:** 8\ **Last updated:** [November 5, 2021, 11:07pm UTC](https://forum.inductiveautomation.com/t/database-connection-either-mysql-or-mssqlexpress/52789 "2021-11-05T23:07:19Z")
I do have installed the ignition app in my computer but using an external hard drive, also I do have the MySQL community (the latest version) amd MSSQLExpress but those in the host drive C:, for some reason I cannot crea… --- ## [Perspective PowerChart Pens Dataset - Solved](https://forum.inductiveautomation.com/t/perspective-powerchart-pens-dataset-solved/48850)
**Author:** [@walktony](https://forum.inductiveautomation.com/u/walktony)\ **Replies:** 1\ **Last updated:** [November 2, 2021, 8:52am UTC](https://forum.inductiveautomation.com/t/perspective-powerchart-pens-dataset-solved/48850 "2021-11-02T08:52:53Z")
I have been attempting to migrate from Vision Easy Charts to Perspective Power Chart. I loaded the pen data to my smart chart via a named query. I have been trying to recreate the same with a Power Chart. I have the Pens… --- ## [Using script to add a button to a table row](https://forum.inductiveautomation.com/t/using-script-to-add-a-button-to-a-table-row/51072)
**Author:** [@israel.jordan](https://forum.inductiveautomation.com/u/israel.jordan)\ **Replies:** 9\ **Last updated:** [November 5, 2021, 8:10pm UTC](https://forum.inductiveautomation.com/t/using-script-to-add-a-button-to-a-table-row/51072 "2021-11-05T20:10:45Z")
Hello All, I am still a little new to Ignition, so please be kind. I have written a script in perspective that queries a database and uses the result set to populate an empty table that is contained in another view. I w… --- ## [How to print report to network printer](https://forum.inductiveautomation.com/t/how-to-print-report-to-network-printer/52794)
**Author:** [@michael.black](https://forum.inductiveautomation.com/u/michael.black)\ **Replies:** 4\ **Last updated:** [November 5, 2021, 7:45pm UTC](https://forum.inductiveautomation.com/t/how-to-print-report-to-network-printer/52794 "2021-11-05T19:45:14Z")
I had a report being printed from the system.report.executeAndDistribute function which printed to a local printer. Below is the example code which worked for this local printer: settings = {'primaryPrinterName': 'HP… --- ## [How do I ask SQL timestamp conditions?](https://forum.inductiveautomation.com/t/how-do-i-ask-sql-timestamp-conditions/52792)
**Author:** [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Replies:** 10\ **Last updated:** [November 5, 2021, 7:44pm UTC](https://forum.inductiveautomation.com/t/how-do-i-ask-sql-timestamp-conditions/52792 "2021-11-05T19:44:29Z")
where t\_stamp between x and y how do I properly ask SQL date questions related to t\_stamp? Like if I wanted the count during the last 5 minutes or if I wanted the count during the month of october --- ## [Is there an upper limit to the tags that can be read with system.opc.readValue?](https://forum.inductiveautomation.com/t/is-there-an-upper-limit-to-the-tags-that-can-be-read-with-system-opc-readvalue/52790)
**Author:** [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Replies:** 6\ **Last updated:** [November 5, 2021, 6:59pm UTC](https://forum.inductiveautomation.com/t/is-there-an-upper-limit-to-the-tags-that-can-be-read-with-system-opc-readvalue/52790 "2021-11-05T18:59:57Z")
I am trying to read 11,000 tags using system.opc.readValue but only can grab 1000 or so. What is the deal? --- ## [Is it possible to deselect a column in a Perspective Table using script?](https://forum.inductiveautomation.com/t/is-it-possible-to-deselect-a-column-in-a-perspective-table-using-script/52787)
**Author:** [@israel.jordan](https://forum.inductiveautomation.com/u/israel.jordan)\ **Replies:** 1\ **Last updated:** [November 5, 2021, 6:58pm UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-deselect-a-column-in-a-perspective-table-using-script/52787 "2021-11-05T18:58:06Z")
Hello all, I have a Table component that I am using to display SQL data. I plan to use column selection to aid me in manipulating the data. The problem that I am having is that I do not want my users to be able to selec… --- ## [How to update the configuration of an existing device via System.device](https://forum.inductiveautomation.com/t/how-to-update-the-configuration-of-an-existing-device-via-system-device/52506)
**Author:** [@phandc](https://forum.inductiveautomation.com/u/phandc)\ **Replies:** 10\ **Last updated:** [November 5, 2021, 6:32pm UTC](https://forum.inductiveautomation.com/t/how-to-update-the-configuration-of-an-existing-device-via-system-device/52506 "2021-11-05T18:32:49Z")
Hi everyone, I am trying to update the configuration of an existing device using System.device utilities. I can some devices via script as mentioned in the System.device.addDevice document. Howerver, the system.device u… --- ## [How to send an HTTP requests to localhost from a perspective session?](https://forum.inductiveautomation.com/t/how-to-send-an-http-requests-to-localhost-from-a-perspective-session/52782)
**Author:** [@pandreoli](https://forum.inductiveautomation.com/u/pandreoli)\ **Replies:** 1\ **Last updated:** [November 5, 2021, 3:30pm UTC](https://forum.inductiveautomation.com/t/how-to-send-an-http-requests-to-localhost-from-a-perspective-session/52782 "2021-11-05T15:30:41Z")
Hello, So I have a development Flask application running on my local computer. I can reach it at http://127.0.0.1:5000 or http://localhost:5000. Sending an HTTP request to this server from the script console works fine.… --- ## [Perspective - MAP - LAYER - UI - VIEW](https://forum.inductiveautomation.com/t/perspective-map-layer-ui-view/52783)
**Author:** [@luc.martin](https://forum.inductiveautomation.com/u/luc.martin)\ **Replies:** 0\ **Last updated:** [November 5, 2021, 3:30pm UTC](https://forum.inductiveautomation.com/t/perspective-map-layer-ui-view/52783 "2021-11-05T15:30:23Z")
8.1.11 Is there a way to get a view zoomed in a map ? I have a view with an image and overlay viewbox and want to be able to zoom it in a popup. --- ## [getBit expression issues](https://forum.inductiveautomation.com/t/getbit-expression-issues/52780)
**Author:** [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Replies:** 2\ **Last updated:** [November 5, 2021, 2:58pm UTC](https://forum.inductiveautomation.com/t/getbit-expression-issues/52780 "2021-11-05T14:58:11Z")
I am having issues with the getBit() expression working in V8.0.16 . I developed my app in 8.1.10 and had to import into an 8.0.16 project. Expression worked in 8.1 but does not work in 8.0. Is there a know issue? --- ## [How to get the offsetX and offsetY for component pointer events](https://forum.inductiveautomation.com/t/how-to-get-the-offsetx-and-offsety-for-component-pointer-events/52372)
**Author:** [@nathan1](https://forum.inductiveautomation.com/u/nathan1)\ **Replies:** 7\ **Last updated:** [November 5, 2021, 2:26pm UTC](https://forum.inductiveautomation.com/t/how-to-get-the-offsetx-and-offsety-for-component-pointer-events/52372 "2021-11-05T14:26:38Z")
I see that pointer events in Perspective provide access to the coordinates below which seem to all be relative to the document, window or screen. I need the coordinates relative to the target element (component) that was… --- ## [Classic chart: X axis questions](https://forum.inductiveautomation.com/t/classic-chart-x-axis-questions/7763)
**Author:** [@SonicClang](https://forum.inductiveautomation.com/u/SonicClang)\ **Replies:** 14\ **Last updated:** [November 5, 2021, 1:54pm UTC](https://forum.inductiveautomation.com/t/classic-chart-x-axis-questions/7763 "2021-11-05T13:54:09Z")
UPDATE: Question #2 has been answered. I'm still looking for an answer to #1. In a classic chart... 1) Is it possible to have the time and date display in the X axis? It's only displaying the time, which isn't the mo… --- ## [Data Type Instance Parameter Scripting](https://forum.inductiveautomation.com/t/data-type-instance-parameter-scripting/52777)
**Author:** [@Adriel\_Simas](https://forum.inductiveautomation.com/u/Adriel_Simas)\ **Replies:** 0\ **Last updated:** [November 5, 2021, 1:31pm UTC](https://forum.inductiveautomation.com/t/data-type-instance-parameter-scripting/52777 "2021-11-05T13:31:45Z")
Hi There, We need the parameter of a data type instance(UDT) to be enabled for some machines and not for others. These machines are all using the same data type instance so I was wondering if anyone would know how to go… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=934) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=936)