# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=485 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 486 --- ## [Add Flex Instances on addition of new row in Database](https://forum.inductiveautomation.com/t/add-flex-instances-on-addition-of-new-row-in-database/56205)
**Author:** [@Sourabh\_Ambildhuke](https://forum.inductiveautomation.com/u/Sourabh_Ambildhuke)\ **Replies:** 8\ **Last updated:** [February 12, 2024, 9:52am UTC](https://forum.inductiveautomation.com/t/add-flex-instances-on-addition-of-new-row-in-database/56205 "2024-02-12T09:52:02Z")
Hi team, New to perspective and stuck on challenge so can anyone has done this previously. I want to add Flex repeater instance when a new row is added in the database and show data in flex repeater parameters. is it p… --- ## [Inherit project resources based on condition](https://forum.inductiveautomation.com/t/inherit-project-resources-based-on-condition/85470)
**Author:** [@Sachin\_Kamble](https://forum.inductiveautomation.com/u/Sachin_Kamble)\ **Replies:** 2\ **Last updated:** [February 12, 2024, 5:44am UTC](https://forum.inductiveautomation.com/t/inherit-project-resources-based-on-condition/85470 "2024-02-12T05:44:24Z")
I am using Ignition 8.1.22. I have created one global project with all common resources required for three child projects. Is it possible to inherit global project resources based on child project name? Eg. I have crea… --- ## [Perspective Table - Rendered View - Table onRowClick not working on views with disabled component](https://forum.inductiveautomation.com/t/perspective-table-rendered-view-table-onrowclick-not-working-on-views-with-disabled-component/84995)
**Author:** [@chrisl](https://forum.inductiveautomation.com/u/chrisl)\ **Replies:** 1\ **Last updated:** [February 12, 2024, 3:50am UTC](https://forum.inductiveautomation.com/t/perspective-table-rendered-view-table-onrowclick-not-working-on-views-with-disabled-component/84995 "2024-02-12T03:50:52Z")
Hi There! I noticed that in Perspective's Table onRowClick, onRowDoublick actions is not working on "render=view" with disabled Text Field and Number Field components. However, those actions works perfectly fine if the … --- ## [Script to ping computer](https://forum.inductiveautomation.com/t/script-to-ping-computer/16612)
**Author:** [@Vince](https://forum.inductiveautomation.com/u/Vince)\ **Replies:** 24\ **Last updated:** [February 11, 2024, 7:40pm UTC](https://forum.inductiveautomation.com/t/script-to-ping-computer/16612 "2024-02-11T19:40:53Z")
Hi everyone! I'd like to do a page that will show the health of our main system. I need to ping some devices and show the response time. Is it possible to do this using in a script? Thanks. --- ## [Single AD Authentication for two separated projects](https://forum.inductiveautomation.com/t/single-ad-authentication-for-two-separated-projects/85523)
**Author:** [@thidalgo](https://forum.inductiveautomation.com/u/thidalgo)\ **Replies:** 2\ **Last updated:** [February 11, 2024, 3:28pm UTC](https://forum.inductiveautomation.com/t/single-ad-authentication-for-two-separated-projects/85523 "2024-02-11T15:28:32Z")
Hello I've two separated projects in two separated gateways, both in the same customer but for two completely different worlds. However I'd like to provide navigation from one project to another redirecting the browser f… --- ## [Ignition report module](https://forum.inductiveautomation.com/t/ignition-report-module/85530)
**Author:** [@Yousef\_Ali](https://forum.inductiveautomation.com/u/Yousef_Ali)\ **Replies:** 1\ **Last updated:** [February 11, 2024, 2:51pm UTC](https://forum.inductiveautomation.com/t/ignition-report-module/85530 "2024-02-11T14:51:10Z")
I would like to create report as per second table . The row data taken from DB as per first table group by machine name .. i would like to do something like Merge in Excel . Is it applicable in Report Module ? --- ## [Error in Connecting Ignition with online web application MySQL Database](https://forum.inductiveautomation.com/t/error-in-connecting-ignition-with-online-web-application-mysql-database/85532)
**Author:** [@Muhammad\_Asad\_Javed](https://forum.inductiveautomation.com/u/Muhammad_Asad_Javed)\ **Replies:** 0\ **Last updated:** [February 11, 2024, 2:48pm UTC](https://forum.inductiveautomation.com/t/error-in-connecting-ignition-with-online-web-application-mysql-database/85532 "2024-02-11T14:48:26Z")
I have tried to connect to my online web application MYSQL database using MYSQL connection, it shows error but if I gave this IP (182.190.221.137) access as remote host in my cpanel then my connection show valid. Th… --- ## [From Perspective, I want to edit a DB cell from a table selected cell](https://forum.inductiveautomation.com/t/from-perspective-i-want-to-edit-a-db-cell-from-a-table-selected-cell/85519)
**Author:** [@Leandro\_Garcia\_Carva](https://forum.inductiveautomation.com/u/Leandro_Garcia_Carva)\ **Replies:** 17\ **Last updated:** [February 10, 2024, 8:09pm UTC](https://forum.inductiveautomation.com/t/from-perspective-i-want-to-edit-a-db-cell-from-a-table-selected-cell/85519 "2024-02-10T20:09:57Z")
Hi I just want to write a selected cell of DB from a table. Could you give me a simple script sample? Regards, Leandro --- ## [Coding endDate in script](https://forum.inductiveautomation.com/t/coding-enddate-in-script/85525)
**Author:** [@water2](https://forum.inductiveautomation.com/u/water2)\ **Replies:** 5\ **Last updated:** [February 10, 2024, 6:03pm UTC](https://forum.inductiveautomation.com/t/coding-enddate-in-script/85525 "2024-02-10T18:03:59Z")
event.source.parent.getComponent('Chart CR').startDate = system.date.addHours(now, -24) event.source.parent.getComponent('Chart CR').endDate = now I'm just trying to change this code so its 6am to 6am. So a crude examp… --- ## [Maximize Automatically](https://forum.inductiveautomation.com/t/maximize-automatically/73986)
**Author:** [@thidalgo](https://forum.inductiveautomation.com/u/thidalgo)\ **Replies:** 8\ **Last updated:** [February 10, 2024, 3:21pm UTC](https://forum.inductiveautomation.com/t/maximize-automatically/73986 "2024-02-10T15:21:55Z")
Hello it's possible to automatically maximize a perspective application, running on workstation minimized in the task bar, when an event occurs (tag change, message received ... ) ? --- ## [PLC / Network Redundancy in Ignition](https://forum.inductiveautomation.com/t/plc-network-redundancy-in-ignition/83683)
**Author:** [@Khurram\_sarfraz](https://forum.inductiveautomation.com/u/Khurram_sarfraz)\ **Replies:** 6\ **Last updated:** [February 10, 2024, 12:41pm UTC](https://forum.inductiveautomation.com/t/plc-network-redundancy-in-ignition/83683 "2024-02-10T12:41:12Z")
I have two Redundant SIEMENS S7-400H PLC. I am connected to both of them via Ignition Gateway and have imported the respective tags in two folders in ignition designer The way it can be achieved is by modifying the .OPC… --- ## [Redundancy configuration for Siemens 400 PLC](https://forum.inductiveautomation.com/t/redundancy-configuration-for-siemens-400-plc/80119)
**Author:** [@liangliang\_yi](https://forum.inductiveautomation.com/u/liangliang_yi)\ **Replies:** 10\ **Last updated:** [February 10, 2024, 12:33pm UTC](https://forum.inductiveautomation.com/t/redundancy-configuration-for-siemens-400-plc/80119 "2024-02-10T12:33:46Z")
I have a 400 PLC, two CP cards, different IP addresses and slot numbers. I can use the exchange project to change the ip address if one CP is faulty. but I am not able to change the slot number, which is not working for… --- ## [System.alarm.querystatus and empty display path](https://forum.inductiveautomation.com/t/system-alarm-querystatus-and-empty-display-path/85514)
**Author:** [@franklepkowski](https://forum.inductiveautomation.com/u/franklepkowski)\ **Replies:** 0\ **Last updated:** [February 10, 2024, 3:52am UTC](https://forum.inductiveautomation.com/t/system-alarm-querystatus-and-empty-display-path/85514 "2024-02-10T03:52:56Z")
Hello, I have noticed if I create a tag an assign an alarm then leave the display path blank this causes system.alarm.querystatus to return a false instead of a true. \]This seems like a bug, has anyone else noticed this… --- ## [Add FTP server to WebDev?](https://forum.inductiveautomation.com/t/add-ftp-server-to-webdev/85513)
**Author:** [@scottmwyant](https://forum.inductiveautomation.com/u/scottmwyant)\ **Replies:** 1\ **Last updated:** [February 10, 2024, 2:46am UTC](https://forum.inductiveautomation.com/t/add-ftp-server-to-webdev/85513 "2024-02-10T02:46:09Z")
Anyone else ever run into this? I have a scenario where I’d love to have an FTP client shoot a file over to Ignition, where it would be handled in the webdev module, similar to an HTTP POST. Currently I have a separate… --- ## [Deleting specific instances of a flex repeater - keeping "for" loop in sync with instances](https://forum.inductiveautomation.com/t/deleting-specific-instances-of-a-flex-repeater-keeping-for-loop-in-sync-with-instances/85507)
**Author:** [@Bushmatic](https://forum.inductiveautomation.com/u/Bushmatic)\ **Replies:** 3\ **Last updated:** [February 9, 2024, 10:27pm UTC](https://forum.inductiveautomation.com/t/deleting-specific-instances-of-a-flex-repeater-keeping-for-loop-in-sync-with-instances/85507 "2024-02-09T22:27:56Z")
I'm using a button script to use system.perspective.sendMessage() to iterate through a flex repeater component and delete specific instances contained therein. Each instance has a property called "Factory", which can be … --- ## [Reporting - Tag History Query Data - how to convert feet to inches](https://forum.inductiveautomation.com/t/reporting-tag-history-query-data-how-to-convert-feet-to-inches/85497)
**Author:** [@Bruce\_Altmann](https://forum.inductiveautomation.com/u/Bruce_Altmann)\ **Replies:** 7\ **Last updated:** [February 9, 2024, 10:06pm UTC](https://forum.inductiveautomation.com/t/reporting-tag-history-query-data-how-to-convert-feet-to-inches/85497 "2024-02-09T22:06:00Z")
Just trying to export from scada data daily for another platform. (coding up another static table Report) Just need to convert a few tank level from feet to inches (the perspective view does this by design for the … --- ## [Client Launcher Intune Kiosk](https://forum.inductiveautomation.com/t/client-launcher-intune-kiosk/85503)
**Author:** [@Adam\_Rich](https://forum.inductiveautomation.com/u/Adam_Rich)\ **Replies:** 0\ **Last updated:** [February 9, 2024, 9:02pm UTC](https://forum.inductiveautomation.com/t/client-launcher-intune-kiosk/85503 "2024-02-09T21:02:18Z")
Has anyone successfully deployed a Fullscreen Client Launcher via Microsoft Intune? I'm trying to get our environment set up for it and I'm getting stuck, when entering it into intune. --- ## [Perspective custom properties don't propagate with views on other views](https://forum.inductiveautomation.com/t/perspective-custom-properties-dont-propagate-with-views-on-other-views/41226)
**Author:** [@codersmurf](https://forum.inductiveautomation.com/u/codersmurf)\ **Replies:** 14\ **Last updated:** [February 9, 2024, 8:45pm UTC](https://forum.inductiveautomation.com/t/perspective-custom-properties-dont-propagate-with-views-on-other-views/41226 "2024-02-09T20:45:06Z")
I have a view with controls and custom properties on that view. Those custom properties don’t show up when I drag those views on other views. Is this a bug, or by design? If so, how do I have properties that carry ove… --- ## [UPC-A barcode display format](https://forum.inductiveautomation.com/t/upc-a-barcode-display-format/85434)
**Author:** [@dis](https://forum.inductiveautomation.com/u/dis)\ **Replies:** 3\ **Last updated:** [February 9, 2024, 7:08pm UTC](https://forum.inductiveautomation.com/t/upc-a-barcode-display-format/85434 "2024-02-09T19:08:14Z")
The UPC-A barcode does not display in the "correct" format. Can the UPC barcode be made to look like a standard UPC-A barcode? They want this style Is there a way to do that? --- ## [How do I access a tag's expression definition in a script?](https://forum.inductiveautomation.com/t/how-do-i-access-a-tags-expression-definition-in-a-script/85481)
**Author:** [@David\_Nicks](https://forum.inductiveautomation.com/u/David_Nicks)\ **Replies:** 6\ **Last updated:** [February 9, 2024, 8:30pm UTC](https://forum.inductiveautomation.com/t/how-do-i-access-a-tags-expression-definition-in-a-script/85481 "2024-02-09T20:30:49Z")
Let's say I have a tag called Status that is an expression tag, whose value is calculated as TagA OR TagB OR TagC. The Status tag is also configured as an alarm trigger. When the alarm shows up in an alarm table, I want… --- ## [Tags alternating from good to bad](https://forum.inductiveautomation.com/t/tags-alternating-from-good-to-bad/85499)
**Author:** [@Logan\_Chance](https://forum.inductiveautomation.com/u/Logan_Chance)\ **Replies:** 8\ **Last updated:** [February 9, 2024, 8:23pm UTC](https://forum.inductiveautomation.com/t/tags-alternating-from-good-to-bad/85499 "2024-02-09T20:23:37Z")
I am struggling hard with a current issue. I have 7 CompactLogix connected to Ignition. This is the only PLC having complications. It was the first PLC connected to the network and the previous PLC programmer was gues… --- ## [Extract excel/csv file from database query browser](https://forum.inductiveautomation.com/t/extract-excel-csv-file-from-database-query-browser/85484)
**Author:** [@Lorenzo\_Marta](https://forum.inductiveautomation.com/u/Lorenzo_Marta)\ **Replies:** 1\ **Last updated:** [February 9, 2024, 8:00pm UTC](https://forum.inductiveautomation.com/t/extract-excel-csv-file-from-database-query-browser/85484 "2024-02-09T20:00:36Z")
Hi everyone, I need to extract an excel or csv file from database. Currently, I selected data from Database Query Browser and I saved data by coping and pasting them in an excel file. Is it possible to generate directly… --- ## [Database used by system.db.\* queries](https://forum.inductiveautomation.com/t/database-used-by-system-db-queries/85229)
**Author:** [@rbachman](https://forum.inductiveautomation.com/u/rbachman)\ **Replies:** 35\ **Last updated:** [February 9, 2024, 7:58pm UTC](https://forum.inductiveautomation.com/t/database-used-by-system-db-queries/85229 "2024-02-09T19:58:46Z")
We had an issue a few weeks ago after archiving data from a few of our MSSQL databases. The "archived" databases had tables with the same name as the "active" databases, and some of our system.db.\* queries began to fail … --- ## [Perspective power table dynamically change render view](https://forum.inductiveautomation.com/t/perspective-power-table-dynamically-change-render-view/85493)
**Author:** [@dhiraj.pawar](https://forum.inductiveautomation.com/u/dhiraj.pawar)\ **Replies:** 1\ **Last updated:** [February 9, 2024, 6:23pm UTC](https://forum.inductiveautomation.com/t/perspective-power-table-dynamically-change-render-view/85493 "2024-02-09T18:23:22Z")
Hello Team, Can you confirm feasibility of we can pass dynamically render view based on condition? Example we have table with different file extension. suppose file extension is pdf then table to 'view icon' render or … --- ## [How to maintain aspect ratio in a resizeable popup window?](https://forum.inductiveautomation.com/t/how-to-maintain-aspect-ratio-in-a-resizeable-popup-window/14614)
**Author:** [@brian.mcenulty](https://forum.inductiveautomation.com/u/brian.mcenulty)\ **Replies:** 6\ **Last updated:** [February 9, 2024, 5:56pm UTC](https://forum.inductiveautomation.com/t/how-to-maintain-aspect-ratio-in-a-resizeable-popup-window/14614 "2024-02-09T17:56:47Z")
I'm trying to create a popup window that will contain an IP Camera Viewer object in it. What I'd like to do is set the popup window to be resizeable and maintain its aspect ratio when resized so that the camera viewer al… --- ## [Tab loading slowly](https://forum.inductiveautomation.com/t/tab-loading-slowly/85488)
**Author:** [@Randolph\_Sewell](https://forum.inductiveautomation.com/u/Randolph_Sewell)\ **Replies:** 3\ **Last updated:** [February 9, 2024, 5:46pm UTC](https://forum.inductiveautomation.com/t/tab-loading-slowly/85488 "2024-02-09T17:46:34Z")
I have tabs with lots of tag information on them and it takes about 5 seconds to load each tab. I was wondering if there was a way I could preload the stuff on the tabs? I thought about having all the windows always visi… --- ## [Creating my own background color in perspective theme](https://forum.inductiveautomation.com/t/creating-my-own-background-color-in-perspective-theme/85485)
**Author:** [@Cameron\_Nickle](https://forum.inductiveautomation.com/u/Cameron_Nickle)\ **Replies:** 1\ **Last updated:** [February 9, 2024, 4:50pm UTC](https://forum.inductiveautomation.com/t/creating-my-own-background-color-in-perspective-theme/85485 "2024-02-09T16:50:40Z")
Hi all! I wanted to have some fun with the perspective themes and wanted to try my hand at making a simple theme. I can make any of the components change the way I want but I cannot seem to get the overall background co… --- ## [Static Value On A Reporting XY Chart](https://forum.inductiveautomation.com/t/static-value-on-a-reporting-xy-chart/85092)
**Author:** [@koenigs.alex](https://forum.inductiveautomation.com/u/koenigs.alex)\ **Replies:** 4\ **Last updated:** [February 9, 2024, 4:05pm UTC](https://forum.inductiveautomation.com/t/static-value-on-a-reporting-xy-chart/85092 "2024-02-09T16:05:54Z")
I am making a report with an XY chart and I am pulling data from SQL. I want to add a static line to the trend that is not in my data from SQL. Anyone have an idea how to add a static line to a trend? --- ## [Issue with session properties](https://forum.inductiveautomation.com/t/issue-with-session-properties/69754)
**Author:** [@Binyameen\_Aslam](https://forum.inductiveautomation.com/u/Binyameen_Aslam)\ **Replies:** 18\ **Last updated:** [February 9, 2024, 3:58pm UTC](https://forum.inductiveautomation.com/t/issue-with-session-properties/69754 "2024-02-09T15:58:58Z")
This works in designer but when I run the session it shows red exclamation mark "null" error. --- ## [How to calculate avg on time and off time of the machine?](https://forum.inductiveautomation.com/t/how-to-calculate-avg-on-time-and-off-time-of-the-machine/85272)
**Author:** [@Govind\_Suthar1](https://forum.inductiveautomation.com/u/Govind_Suthar1)\ **Replies:** 13\ **Last updated:** [February 9, 2024, 2:39pm UTC](https://forum.inductiveautomation.com/t/how-to-calculate-avg-on-time-and-off-time-of-the-machine/85272 "2024-02-09T14:39:20Z")
Hello friends, I installed a sensor for monitoring AC status. It gives me a value of 1 or 0 when the AC is on or off. So, I log that value(0/1) in the database using the transaction group. I want to calculate the total … [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=484) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=486)