# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=649 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 650 --- ## [Report parameters from Perspective custom props](https://forum.inductiveautomation.com/t/report-parameters-from-perspective-custom-props/73668)
**Author:** [@hw79](https://forum.inductiveautomation.com/u/hw79)\ **Replies:** 11\ **Last updated:** [May 12, 2023, 9:30pm UTC](https://forum.inductiveautomation.com/t/report-parameters-from-perspective-custom-props/73668 "2023-05-12T21:30:55Z")
I'm in the report designer and using a named query that uses a custom prop from my perspective view. How can I pass that prop into the report so the query runs correctly? --- ## [UDTs on perspective](https://forum.inductiveautomation.com/t/udts-on-perspective/73373)
**Author:** [@Emilio\_Rangel1](https://forum.inductiveautomation.com/u/Emilio_Rangel1)\ **Replies:** 7\ **Last updated:** [May 12, 2023, 8:42pm UTC](https://forum.inductiveautomation.com/t/udts-on-perspective/73373 "2023-05-12T20:42:19Z")
Hello! I'm migrating an existing system currently running in Vision, but there is a necessity to migrate to Perspective. In Vision is possible to use a UDT as a property and it makes things ways easier, in perspective … --- ## [Hide label and shrink space](https://forum.inductiveautomation.com/t/hide-label-and-shrink-space/73662)
**Author:** [@craigb](https://forum.inductiveautomation.com/u/craigb)\ **Replies:** 4\ **Last updated:** [May 12, 2023, 7:59pm UTC](https://forum.inductiveautomation.com/t/hide-label-and-shrink-space/73662 "2023-05-12T19:59:28Z")
Wasn't sure what to call this one. I want to hide a label based on a value of 0, which is the easy part but I want the space to shrink/disappear. For example a column container, even if you 'hide' a label the space is st… --- ## [Application Error Code 105)\] when launching a Perspective](https://forum.inductiveautomation.com/t/application-error-code-105-when-launching-a-perspective/69410)
**Author:** [@hw79](https://forum.inductiveautomation.com/u/hw79)\ **Replies:** 7\ **Last updated:** [May 12, 2023, 4:36pm UTC](https://forum.inductiveautomation.com/t/application-error-code-105-when-launching-a-perspective/69410 "2023-05-12T16:36:07Z")
I'm trying to launch a Perspective app on an ipad and am getting an application error. This is occurring for both my app and the Perspective Demo. I didn't find another topic on this and wondered what it could be. Tha… --- ## [Application migrated from 7.9 to 8.1 - import command failure](https://forum.inductiveautomation.com/t/application-migrated-from-7-9-to-8-1-import-command-failure/73650)
**Author:** [@szcz](https://forum.inductiveautomation.com/u/szcz)\ **Replies:** 3\ **Last updated:** [May 12, 2023, 3:55pm UTC](https://forum.inductiveautomation.com/t/application-migrated-from-7-9-to-8-1-import-command-failure/73650 "2023-05-12T15:55:53Z")
Hi all, I am moving an application from 7.9 to 8.1 and I am in the scripting part. 7.9 contains references to global scripts beginning with shared. which I update accordingly to 8.1 conventions. The application has lot … --- ## [system.db.closeTransaction error (caused by: transaction closed)](https://forum.inductiveautomation.com/t/system-db-closetransaction-error-caused-by-transaction-closed/73603)
**Author:** [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Replies:** 11\ **Last updated:** [May 12, 2023, 2:05pm UTC](https://forum.inductiveautomation.com/t/system-db-closetransaction-error-caused-by-transaction-closed/73603 "2023-05-12T14:05:20Z")
Hello folks, First time trying to use transactions, and I can't figure out what I'm doing wrong. First, the basics: perspective 8.1.17 (requirement for this project) mssql 2022 20.04 I'm going mad I tried a bunch of… --- ## [Merge 2 dataset in to single dataset](https://forum.inductiveautomation.com/t/merge-2-dataset-in-to-single-dataset/73646)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 3\ **Last updated:** [May 12, 2023, 1:46pm UTC](https://forum.inductiveautomation.com/t/merge-2-dataset-in-to-single-dataset/73646 "2023-05-12T13:46:44Z")
Hi i have 2 dataset and i want to merge 2 dataset in to single dataset which is the easiest way to do it? 1 dataset have 3 columns 2 dataset have 2 columns i want final out with single dataset with 200R\*5C --- ## [Database best practice multiple gateways same local network](https://forum.inductiveautomation.com/t/database-best-practice-multiple-gateways-same-local-network/73208)
**Author:** [@rfolkes](https://forum.inductiveautomation.com/u/rfolkes)\ **Replies:** 3\ **Last updated:** [May 12, 2023, 1:07pm UTC](https://forum.inductiveautomation.com/t/database-best-practice-multiple-gateways-same-local-network/73208 "2023-05-12T13:07:19Z")
For system all on local network and servers running in server cluster as VMs (redundancy / data protection is outside the scope of this question) We are planning on 3 ignition gateway IO servers (Backend1-3) And 1 ga… --- ## [Tag Groups Optimization w/ AB](https://forum.inductiveautomation.com/t/tag-groups-optimization-w-ab/72759)
**Author:** [@rfolkes](https://forum.inductiveautomation.com/u/rfolkes)\ **Replies:** 9\ **Last updated:** [May 12, 2023, 12:54pm UTC](https://forum.inductiveautomation.com/t/tag-groups-optimization-w-ab/72759 "2023-05-12T12:54:24Z")
Looked at comments Here and Here rather then reply on those older topics I started a new one. So from my understanding from this with ignition connecting to AB just read the whole Tag UDT at one time but wanted to cla… --- ## [Operations Help Documentation](https://forum.inductiveautomation.com/t/operations-help-documentation/73614)
**Author:** [@Randolph\_Sewell](https://forum.inductiveautomation.com/u/Randolph_Sewell)\ **Replies:** 2\ **Last updated:** [May 12, 2023, 12:52pm UTC](https://forum.inductiveautomation.com/t/operations-help-documentation/73614 "2023-05-12T12:52:35Z")
I want to redirect operators to a wiki of sorts when they receive alarms or maybe on components(like a little question mark in the corner they can click to open a document with help about that specific thing). It can't b… --- ## [Ignition Gateway Faulted](https://forum.inductiveautomation.com/t/ignition-gateway-faulted/73643)
**Author:** [@Robbie.Wozencroft](https://forum.inductiveautomation.com/u/Robbie.Wozencroft)\ **Replies:** 4\ **Last updated:** [May 12, 2023, 12:51pm UTC](https://forum.inductiveautomation.com/t/ignition-gateway-faulted/73643 "2023-05-12T12:51:11Z")
Power went out and on restart the Gateway has faulted and I am unsure why. Ignition 8.1.4 on Windows 10 wrapper.log (6.6 MB) I've had a brief look through the wrapper and can't make much sense of it. any help would b… --- ## [Tag Groups from script?](https://forum.inductiveautomation.com/t/tag-groups-from-script/73644)
**Author:** [@Starlyn\_Olivero](https://forum.inductiveautomation.com/u/Starlyn_Olivero)\ **Replies:** 1\ **Last updated:** [May 12, 2023, 12:40pm UTC](https://forum.inductiveautomation.com/t/tag-groups-from-script/73644 "2023-05-12T12:40:52Z")
Hi, I would like to create Tag Groups specific configuration on a set of different Tag Providers from a script rather than manually importing them. Is this possible? I have around 5-8 tag providers and each one will ha… --- ## [Load big array triggered by an item](https://forum.inductiveautomation.com/t/load-big-array-triggered-by-an-item/73515)
**Author:** [@Peter\_Nikolaus](https://forum.inductiveautomation.com/u/Peter_Nikolaus)\ **Replies:** 5\ **Last updated:** [May 12, 2023, 12:24pm UTC](https://forum.inductiveautomation.com/t/load-big-array-triggered-by-an-item/73515 "2023-05-12T12:24:57Z")
I have a numeric item "Measurement" in the PLC and whenever this changes I want to load 500 measured values (array). In a Siemens training was said one should subscribe in such cases as little as possible. My approach w… --- ## [Day picker highlight production days](https://forum.inductiveautomation.com/t/day-picker-highlight-production-days/73638)
**Author:** [@Corne\_de\_Jonge](https://forum.inductiveautomation.com/u/Corne_de_Jonge)\ **Replies:** 1\ **Last updated:** [May 12, 2023, 11:15am UTC](https://forum.inductiveautomation.com/t/day-picker-highlight-production-days/73638 "2023-05-12T11:15:20Z")
Hi all, I'm curious if anyone has come across or developed a day picker that includes the ability to highlight specific days. In my project, I'm creating a production dashboard, and it would be useful if I could highli… --- ## [Dynamic String fill for the drop-down list](https://forum.inductiveautomation.com/t/dynamic-string-fill-for-the-drop-down-list/27389)
**Author:** [@dawei.liu](https://forum.inductiveautomation.com/u/dawei.liu)\ **Replies:** 6\ **Last updated:** [May 12, 2023, 8:46am UTC](https://forum.inductiveautomation.com/t/dynamic-string-fill-for-the-drop-down-list/27389 "2023-05-12T08:46:34Z")
Hi, I want to implement a drop-down list with filling its option strings dynamically. The strings are stored in a string array of a UDT that from OPC tags Take below snapshot as example, I want the "String 1" and "St… --- ## [Perspective Text List for Translation](https://forum.inductiveautomation.com/t/perspective-text-list-for-translation/73203)
**Author:** [@Alex\_Leech](https://forum.inductiveautomation.com/u/Alex_Leech)\ **Replies:** 4\ **Last updated:** [May 12, 2023, 8:05am UTC](https://forum.inductiveautomation.com/t/perspective-text-list-for-translation/73203 "2023-05-12T08:05:15Z")
Hi all, Looking for some guidance. I understand from docs and forums that in perspective that all translations are managed by locale and through the global translation manager. In vision, this can be be also 'overriden'… --- ## [How does 'com.inductiveautomation.logging.SQLiteAppender' work?](https://forum.inductiveautomation.com/t/how-does-com-inductiveautomation-logging-sqliteappender-work/73390)
**Author:** [@Shivam\_Gohri](https://forum.inductiveautomation.com/u/Shivam_Gohri)\ **Replies:** 4\ **Last updated:** [May 12, 2023, 6:15am UTC](https://forum.inductiveautomation.com/t/how-does-com-inductiveautomation-logging-sqliteappender-work/73390 "2023-05-12T06:15:09Z")
I'm trying to get all the gateway logs in a .log file using FileAppender. However, I'm unable to see the logs shown on UI (Diagnostic -\> logs) which are maintained in .idb file using 'com.inductiveautomation.logging.SQLi… --- ## [Row 0 doesn't have the same number of columns as header list error](https://forum.inductiveautomation.com/t/row-0-doesnt-have-the-same-number-of-columns-as-header-list-error/43527)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 4\ **Last updated:** [May 12, 2023, 5:53am UTC](https://forum.inductiveautomation.com/t/row-0-doesnt-have-the-same-number-of-columns-as-header-list-error/43527 "2023-05-12T05:53:22Z")
when i run the above script i am getting this error Row 0 doesn’t have the same number of columns as header list. can any one help me out on this --- ## [\[FEATURE\]Add Update Prompt with Timeout for Vision](https://forum.inductiveautomation.com/t/feature-add-update-prompt-with-timeout-for-vision/73630)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 2\ **Last updated:** [May 12, 2023, 3:50am UTC](https://forum.inductiveautomation.com/t/feature-add-update-prompt-with-timeout-for-vision/73630 "2023-05-12T03:50:07Z")
As in Perspective, can a "Prompt with timeout" option be added when configuring the update mode for Vision clients when changes are saved? We have 100 Vision clients running onsite with changes made and needing to be ro… --- ## [Popup Identifier X-Ref](https://forum.inductiveautomation.com/t/popup-identifier-x-ref/73119)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 4\ **Last updated:** [May 12, 2023, 2:46am UTC](https://forum.inductiveautomation.com/t/popup-identifier-x-ref/73119 "2023-05-12T02:46:30Z")
I have a bunch of popups and I've duplicated components with popups configured, changing parameters and such, not realizing that the ID is also duplicated, which prevents popups with the same ID being open at the same ti… --- ## [Conditional tag calculations](https://forum.inductiveautomation.com/t/conditional-tag-calculations/73620)
**Author:** [@Jay\_Baker](https://forum.inductiveautomation.com/u/Jay_Baker)\ **Replies:** 1\ **Last updated:** [May 12, 2023, 12:25am UTC](https://forum.inductiveautomation.com/t/conditional-tag-calculations/73620 "2023-05-12T00:25:34Z")
I'm using system.tag.queryTagCalculations to calculate min, max, average, etc over a day for a bunch of tags. All works great, yay. However - I now have a requirement to do conditional summaries as well, where the summa… --- ## [How to fix Perspective Table Column](https://forum.inductiveautomation.com/t/how-to-fix-perspective-table-column/73156)
**Author:** [@Jason\_Zhou](https://forum.inductiveautomation.com/u/Jason_Zhou)\ **Replies:** 1\ **Last updated:** [May 11, 2023, 10:58pm UTC](https://forum.inductiveautomation.com/t/how-to-fix-perspective-table-column/73156 "2023-05-11T22:58:28Z")
So the Perspective Table has column headers already but doesn't have row headers. I'm going to be implementing a table that may potentially have a lot of columns and will be scrollable horizontally. I want a column on th… --- ## [Downloading a zipfile from a flask api?](https://forum.inductiveautomation.com/t/downloading-a-zipfile-from-a-flask-api/73616)
**Author:** [@Travis\_Opperud](https://forum.inductiveautomation.com/u/Travis_Opperud)\ **Replies:** 2\ **Last updated:** [May 11, 2023, 9:13pm UTC](https://forum.inductiveautomation.com/t/downloading-a-zipfile-from-a-flask-api/73616 "2023-05-11T21:13:33Z")
Short summary: I'm trying to download a zip file from a flask API. I've tested the download using a webpage served from the same api, download works fine. Using the same return value, I am getting a corrupted file when … --- ## [Report-Labels Dynamic Starting Position](https://forum.inductiveautomation.com/t/report-labels-dynamic-starting-position/73524)
**Author:** [@Michael\_Pettit](https://forum.inductiveautomation.com/u/Michael_Pettit)\ **Replies:** 4\ **Last updated:** [May 11, 2023, 8:55pm UTC](https://forum.inductiveautomation.com/t/report-labels-dynamic-starting-position/73524 "2023-05-11T20:55:13Z")
Hi All, I've created a report in Ignition that utilizes the label component. The label has a simple text string and a barcode. This is working well, but I need a way to start the labels from a dynamic position on the sh… --- ## [System.db.refresh() doesn't seem to be a solution for a vision table component](https://forum.inductiveautomation.com/t/system-db-refresh-doesnt-seem-to-be-a-solution-for-a-vision-table-component/73606)
**Author:** [@hwbrill](https://forum.inductiveautomation.com/u/hwbrill)\ **Replies:** 2\ **Last updated:** [May 11, 2023, 7:53pm UTC](https://forum.inductiveautomation.com/t/system-db-refresh-doesnt-seem-to-be-a-solution-for-a-vision-table-component/73606 "2023-05-11T19:53:23Z")
I just can't figure out how to refresh a vision table component binded to a Name Query without setting the Polling Mode other than 'Off'. --- ## [Query broke after converting to named query](https://forum.inductiveautomation.com/t/query-broke-after-converting-to-named-query/73343)
**Author:** [@Chad\_Campbell](https://forum.inductiveautomation.com/u/Chad_Campbell)\ **Replies:** 14\ **Last updated:** [May 11, 2023, 7:35pm UTC](https://forum.inductiveautomation.com/t/query-broke-after-converting-to-named-query/73343 "2023-05-11T19:35:32Z")
I recently had an SQL Query assigned to an LED display value, in order to run the query in the client view I needed to change it to a Named Query so it would run on the gateway instead of on the client (permissions issue… --- ## [Alarm Pipeline Email All Recipients Shown For Reply All](https://forum.inductiveautomation.com/t/alarm-pipeline-email-all-recipients-shown-for-reply-all/73540)
**Author:** [@koenigs.alex](https://forum.inductiveautomation.com/u/koenigs.alex)\ **Replies:** 2\ **Last updated:** [May 11, 2023, 7:24pm UTC](https://forum.inductiveautomation.com/t/alarm-pipeline-email-all-recipients-shown-for-reply-all/73540 "2023-05-11T19:24:15Z")
Is it possible to have the email a notification pipeline sends have all the recipients on the "To" line. I would like it if people that receive the email can "reply all" so they can discuss the topic of the email. --- ## [Tag History SQL Query Result Timestamp](https://forum.inductiveautomation.com/t/tag-history-sql-query-result-timestamp/73609)
**Author:** [@Aman\_Pawar](https://forum.inductiveautomation.com/u/Aman_Pawar)\ **Replies:** 3\ **Last updated:** [May 11, 2023, 7:23pm UTC](https://forum.inductiveautomation.com/t/tag-history-sql-query-result-timestamp/73609 "2023-05-11T19:23:32Z")
I wanted to use SQL query to fetch tag history data of particular tag so I've used following query: SELECT tagid, intvalue, t\_stamp, DATEADD(s,t\_stamp/1000,'1970-01-01 00:00:00') as Time\_Stamp FROM sqlt\_data\_1\_2023\_04 w… --- ## [Store & Forward and move database](https://forum.inductiveautomation.com/t/store-forward-and-move-database/4371)
**Author:** [@jim\_lapratt](https://forum.inductiveautomation.com/u/jim_lapratt)\ **Replies:** 4\ **Last updated:** [May 11, 2023, 7:09pm UTC](https://forum.inductiveautomation.com/t/store-forward-and-move-database/4371 "2023-05-11T19:09:48Z")
Would this work or does data get cached in connection for store & forward. Have another MySql server up and going. Duplicate databases and tables in it. Stop ignition database connection, let store & forward store data… --- ## [BACnet Devices uninitialized](https://forum.inductiveautomation.com/t/bacnet-devices-uninitialized/73584)
**Author:** [@V\_Gopalakrishnan](https://forum.inductiveautomation.com/u/V_Gopalakrishnan)\ **Replies:** 13\ **Last updated:** [May 11, 2023, 6:40pm UTC](https://forum.inductiveautomation.com/t/bacnet-devices-uninitialized/73584 "2023-05-11T18:40:01Z")
My BACnet Devices uninitialized [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=648) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=650)