# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1113 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1114 --- ## [\[SOLVED\] Timezones in Ignition Component Scripting](https://forum.inductiveautomation.com/t/solved-timezones-in-ignition-component-scripting/39603)
**Author:** [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Replies:** 6\ **Last updated:** [October 12, 2020, 8:31pm UTC](https://forum.inductiveautomation.com/t/solved-timezones-in-ignition-component-scripting/39603 "2020-10-12T20:31:32Z")
Good afternoon, I have the following code in 2 places: dateAdded = system.date.format(system.date.now(), "yyyy-MM-dd HH:mm:ss") The first place is a powertable on the ‘onCellEdited’ function. This returns a date 2 hou… --- ## [Report Messy code](https://forum.inductiveautomation.com/t/report-messy-code/39574)
**Author:** [@448719222](https://forum.inductiveautomation.com/u/448719222)\ **Replies:** 6\ **Last updated:** [October 12, 2020, 2:17pm UTC](https://forum.inductiveautomation.com/t/report-messy-code/39574 "2020-10-12T14:17:21Z")
I save the file as pdf in the rep ort schedule, but the file is garbled and the language is ChineseBeOnDutyTable2020101009.pdf (40.2 KB) --- ## [SQL Select, Join, Where help](https://forum.inductiveautomation.com/t/sql-select-join-where-help/39571)
**Author:** [@steven.cox](https://forum.inductiveautomation.com/u/steven.cox)\ **Replies:** 7\ **Last updated:** [October 12, 2020, 2:01pm UTC](https://forum.inductiveautomation.com/t/sql-select-join-where-help/39571 "2020-10-12T14:01:00Z")
Hi all, I am pulling data from multiple tables to populate a Vision Table using a named query. This query worked until I started to add to it. When it failed, I put it back to the original and it did not work. SELECT … --- ## [\[BUG\] Perspective: Date Time Input not showing correct items for time pickerType according to format](https://forum.inductiveautomation.com/t/bug-perspective-date-time-input-not-showing-correct-items-for-time-pickertype-according-to-format/39592)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 0\ **Last updated:** [October 12, 2020, 11:20am UTC](https://forum.inductiveautomation.com/t/bug-perspective-date-time-input-not-showing-correct-items-for-time-pickertype-according-to-format/39592 "2020-10-12T11:20:09Z")
v8.1rc1 While the formattedDate property is correct, this component doesn’t graphically display correctly according to the format property value when the pickerType is set to time. These are some incorrect combos for th… --- ## [\[FEATURE\] Perspective: Add 'DD:HH:mm:ss' support for the Date Time Input component](https://forum.inductiveautomation.com/t/feature-perspective-add-ddmm-ss-support-for-the-date-time-input-component/39590)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 0\ **Last updated:** [October 12, 2020, 10:23am UTC](https://forum.inductiveautomation.com/t/feature-perspective-add-ddmm-ss-support-for-the-date-time-input-component/39590 "2020-10-12T10:23:04Z")
I need to let the operators enter in a “relative” time rather than an absolute time. That is, I need them to enter in days:hours:mins:secs, and it would be awesome if I could use the Date Time Input component, however it… --- ## [Power table update issue](https://forum.inductiveautomation.com/t/power-table-update-issue/39584)
**Author:** [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\ **Replies:** 0\ **Last updated:** [October 12, 2020, 2:13am UTC](https://forum.inductiveautomation.com/t/power-table-update-issue/39584 "2020-10-12T02:13:55Z")
My ignition current version is 8.1.0RC1 In my version module power table I have 2 issue: Problem 1: if system.gui.confirm(u'记录将删除， 请确认？'): RequestDateTime=event.source.parent.getComponent('Power Table').RequestDateTi… --- ## [Ignition 8.1 upgrade from previous version 8.0.x](https://forum.inductiveautomation.com/t/ignition-8-1-upgrade-from-previous-version-8-0-x/39579)
**Author:** [@Yfactor](https://forum.inductiveautomation.com/u/Yfactor)\ **Replies:** 2\ **Last updated:** [October 12, 2020, 12:08am UTC](https://forum.inductiveautomation.com/t/ignition-8-1-upgrade-from-previous-version-8-0-x/39579 "2020-10-12T00:08:10Z")
Hi there, I am currently using Ignition 8.12. If I were to upgrade to 8.1(RC), will my other projects made with previous version be affected? Cheers --- ## [\[BUG\] Perspective copy paste component doesn't always copy all associated properties](https://forum.inductiveautomation.com/t/bug-perspective-copy-paste-component-doesnt-always-copy-all-associated-properties/37838)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 4\ **Last updated:** [October 12, 2020, 12:04am UTC](https://forum.inductiveautomation.com/t/bug-perspective-copy-paste-component-doesnt-always-copy-all-associated-properties/37838 "2020-10-12T00:04:30Z")
v8.0.15 When I copy and paste the below json into a flex container, the “shrink: 0” doesn’t make it and it becomes a “1”. The basis doesn’t get set right either, should be “auto” but it pastes as “50px”. The json is fro… --- ## [Compara null from query](https://forum.inductiveautomation.com/t/compara-null-from-query/39570)
**Author:** [@etlikmilos](https://forum.inductiveautomation.com/u/etlikmilos)\ **Replies:** 2\ **Last updated:** [October 11, 2020, 12:14pm UTC](https://forum.inductiveautomation.com/t/compara-null-from-query/39570 "2020-10-11T12:14:55Z")
Hi all i have question again about compare but now is from null value. I have query to SQL and I compare returns value but if is still true :(. How I can compare this null values ? testBarCode = system.db.runPrepQuery(… --- ## [Detecting selection changes in Vision table allowing multiselection](https://forum.inductiveautomation.com/t/detecting-selection-changes-in-vision-table-allowing-multiselection/39475)
**Author:** [@jross2020](https://forum.inductiveautomation.com/u/jross2020)\ **Replies:** 10\ **Last updated:** [October 10, 2020, 5:43pm UTC](https://forum.inductiveautomation.com/t/detecting-selection-changes-in-vision-table-allowing-multiselection/39475 "2020-10-10T17:43:51Z")
I want to detect when the currently selected row(s) change in a Vision table, configured to allow multiple row selection. Binding a script to the “propertychange” event, I see that a “selectedRow” event is generated only … --- ## [Error in console: Unable to add data to memory buffer](https://forum.inductiveautomation.com/t/error-in-console-unable-to-add-data-to-memory-buffer/30175)
**Author:** [@tarun89engg](https://forum.inductiveautomation.com/u/tarun89engg)\ **Replies:** 3\ **Last updated:** [October 10, 2020, 7:37am UTC](https://forum.inductiveautomation.com/t/error-in-console-unable-to-add-data-to-memory-buffer/30175 "2020-10-10T07:37:48Z")
Until now we don’t have this error, It shows me in console unable to add data to memory buffer. with the following error in detail java.lang.Exception: Unable to add data to memory buffer, buffer full. at com.induc… --- ## [Perspective best view to use for subviews](https://forum.inductiveautomation.com/t/perspective-best-view-to-use-for-subviews/39556)
**Author:** [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Replies:** 0\ **Last updated:** [October 9, 2020, 9:44pm UTC](https://forum.inductiveautomation.com/t/perspective-best-view-to-use-for-subviews/39556 "2020-10-09T21:44:57Z")
I have a view (see photo), right now just coordinate To attempt to make this more mobile friendly and for lower resolution desktops, what’s the best view container type to use and the containers within that container to… --- ## [Can Perspective Session Properties be Accessed from Project Scripts](https://forum.inductiveautomation.com/t/can-perspective-session-properties-be-accessed-from-project-scripts/39554)
**Author:** [@MikeAllgood](https://forum.inductiveautomation.com/u/MikeAllgood)\ **Replies:** 4\ **Last updated:** [October 9, 2020, 9:35pm UTC](https://forum.inductiveautomation.com/t/can-perspective-session-properties-be-accessed-from-project-scripts/39554 "2020-10-09T21:35:08Z")
I’m wanting to setup a progress bar in a view to do what progress bars do. The screen actions the user generates calls a Project Script. I created a Session Custom Property that I wanted to use to drive the progress ba… --- ## [runNamedQuery Script help](https://forum.inductiveautomation.com/t/runnamedquery-script-help/39551)
**Author:** [@steven.cox](https://forum.inductiveautomation.com/u/steven.cox)\ **Replies:** 3\ **Last updated:** [October 9, 2020, 6:48pm UTC](https://forum.inductiveautomation.com/t/runnamedquery-script-help/39551 "2020-10-09T18:48:10Z")
Hi all, I cannot figure out why this script fails. I have restarted Designer with the same results. From the Script Console… The binder\_select\_index query works and has a matching parameter and the commented secti… --- ## [Perspective refreshBinding error, no binding on property](https://forum.inductiveautomation.com/t/perspective-refreshbinding-error-no-binding-on-property/39544)
**Author:** [@nick.christensen1](https://forum.inductiveautomation.com/u/nick.christensen1)\ **Replies:** 2\ **Last updated:** [October 9, 2020, 4:42pm UTC](https://forum.inductiveautomation.com/t/perspective-refreshbinding-error-no-binding-on-property/39544 "2020-10-09T16:42:30Z")
In perspective I am attempting to run a script to refresh a property query binding on an onMouseEnter event. There is limited documentation on this method, but I believe I am using it correctly. Error Error running act… --- ## [Visibility of components/assets](https://forum.inductiveautomation.com/t/visibility-of-components-assets/39519)
**Author:** [@kumar.chellappan](https://forum.inductiveautomation.com/u/kumar.chellappan)\ **Replies:** 3\ **Last updated:** [October 9, 2020, 4:36pm UTC](https://forum.inductiveautomation.com/t/visibility-of-components-assets/39519 "2020-10-09T16:36:43Z")
Hi, I have 3 components/Assets and 10 users. Eventually, I will have more than 100 components/Assets and more than 100 users. This is in perspective. I am using the user-role right now to give read/write abilities. Som… --- ## [Flex containers in a flex container justify](https://forum.inductiveautomation.com/t/flex-containers-in-a-flex-container-justify/39545)
**Author:** [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Replies:** 2\ **Last updated:** [October 9, 2020, 4:31pm UTC](https://forum.inductiveautomation.com/t/flex-containers-in-a-flex-container-justify/39545 "2020-10-09T16:31:54Z")
v8.0.16, Perspective I have a flex container with 6 flex containers inside of it. Is there a way to justify the first 4 to the left and the last 2to the right? Or do I need to have 2 main flex containers, one with 4, … --- ## [\[SOLVED\] Is there a way to set a variable OPC Server for a regular tag?](https://forum.inductiveautomation.com/t/solved-is-there-a-way-to-set-a-variable-opc-server-for-a-regular-tag/39540)
**Author:** [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Replies:** 2\ **Last updated:** [October 9, 2020, 3:21pm UTC](https://forum.inductiveautomation.com/t/solved-is-there-a-way-to-set-a-variable-opc-server-for-a-regular-tag/39540 "2020-10-09T15:21:58Z")
Good morning, I have an OPC tag (several hundred actually) and I’d like to change the OPC server path for all of them. From what I can see I can’t set the OPC Server to a variable though so i have to manually update eve… --- ## [In-memory Caching, Server Memory Grows Without Bound](https://forum.inductiveautomation.com/t/in-memory-caching-server-memory-grows-without-bound/39079)
**Author:** [@cmaynes](https://forum.inductiveautomation.com/u/cmaynes)\ **Replies:** 14\ **Last updated:** [October 9, 2020, 3:14pm UTC](https://forum.inductiveautomation.com/t/in-memory-caching-server-memory-grows-without-bound/39079 "2020-10-09T15:14:49Z")
Version: 7.9.6 I am using a decorate function to cache query data that rarely changes. I have already checked to make sure there is no leak with my decorator/caching system using the Python pympler package outside Ignit… --- ## [Reading UDT Parameter Value?](https://forum.inductiveautomation.com/t/reading-udt-parameter-value/11872)
**Author:** [@jrbvo](https://forum.inductiveautomation.com/u/jrbvo)\ **Replies:** 2\ **Last updated:** [October 9, 2020, 2:41pm UTC](https://forum.inductiveautomation.com/t/reading-udt-parameter-value/11872 "2020-10-09T14:41:33Z")
Hi All, Is there any ways to read a UDT Parameter value (for example I have a parameter called alarmDescription on UDT tank\_anomaly). I need to be able to read this value into a script. Doing a UDT Binding on a windo… --- ## [Clients don't reconnect after power failure](https://forum.inductiveautomation.com/t/clients-dont-reconnect-after-power-failure/39537)
**Author:** [@EricProvBRP](https://forum.inductiveautomation.com/u/EricProvBRP)\ **Replies:** 0\ **Last updated:** [October 9, 2020, 2:29pm UTC](https://forum.inductiveautomation.com/t/clients-dont-reconnect-after-power-failure/39537 "2020-10-09T14:29:53Z")
Our Ignition Gateway (7.9.13) runs on a VM and 400 clients are connected to. Yesterday, the plant was in production when a power failure occurred. About 375 clients lost power at the same time. When the power recovere… --- ## [\[14527\]Flex Repeater Performance part 2](https://forum.inductiveautomation.com/t/14527-flex-repeater-performance-part-2/26742)
**Author:** [@jpark](https://forum.inductiveautomation.com/u/jpark)\ **Replies:** 10\ **Last updated:** [October 9, 2020, 1:53pm UTC](https://forum.inductiveautomation.com/t/14527-flex-repeater-performance-part-2/26742 "2020-10-09T13:53:29Z")
@PGriffith Same issue from this link: Flex Repeater performance - #3 by Chris\_Taylor I have a test screen with a flex repeater with 100 instances of a simple view. The view has 1 dropdown, 4 textboxes and 4 labels. … --- ## [Ignition Gateway Network Remote Tag Provider Issues](https://forum.inductiveautomation.com/t/ignition-gateway-network-remote-tag-provider-issues/39532)
**Author:** [@gbrp](https://forum.inductiveautomation.com/u/gbrp)\ **Replies:** 1\ **Last updated:** [October 9, 2020, 1:11pm UTC](https://forum.inductiveautomation.com/t/ignition-gateway-network-remote-tag-provider-issues/39532 "2020-10-09T13:11:51Z")
Hi All, I am currently encountering a quite peculiar problem with Ignition 7.9.14 gateway network. In this particular scenario, I have a server that has numerous outgoing connection to to other servers and the aim is t… --- ## [Query tag problem](https://forum.inductiveautomation.com/t/query-tag-problem/10293)
**Author:** [@andrea.montresor](https://forum.inductiveautomation.com/u/andrea.montresor)\ **Replies:** 6\ **Last updated:** [October 9, 2020, 12:57pm UTC](https://forum.inductiveautomation.com/t/query-tag-problem/10293 "2020-10-09T12:57:01Z")
Hello, I have a problem in a query tag. This is my query: select cd\_response from response where id\_status = 0 and id\_barcode\_supplier = {\[.\]FEEDER\_CODE} order by dt\_time\_stamp FEEDER\_CODE tag is in the same folder … --- ## [Prepared statement delete problem](https://forum.inductiveautomation.com/t/prepared-statement-delete-problem/39530)
**Author:** [@david4](https://forum.inductiveautomation.com/u/david4)\ **Replies:** 2\ **Last updated:** [October 9, 2020, 11:57am UTC](https://forum.inductiveautomation.com/t/prepared-statement-delete-problem/39530 "2020-10-09T11:57:33Z")
Hi everybody, I’m trying to delete via prepared statments but I have a problem: when I execute this statement (without prepared statement): system.db.runUpdateQuery("delete from TABLE where COLUMNX = 15.4 ") it retur… --- ## [Tags concurrency](https://forum.inductiveautomation.com/t/tags-concurrency/39497)
**Author:** [@david4](https://forum.inductiveautomation.com/u/david4)\ **Replies:** 2\ **Last updated:** [October 9, 2020, 9:57am UTC](https://forum.inductiveautomation.com/t/tags-concurrency/39497 "2020-10-09T09:57:30Z")
Good afternoon everybody, Is there some method to associate a mutex to a gateway tag? To allow each client to write this tag 1 at a time? thank you --- ## [Tag Event Scripts](https://forum.inductiveautomation.com/t/tag-event-scripts/39096)
**Author:** [@448719222](https://forum.inductiveautomation.com/u/448719222)\ **Replies:** 6\ **Last updated:** [October 9, 2020, 12:54am UTC](https://forum.inductiveautomation.com/t/tag-event-scripts/39096 "2020-10-09T00:54:24Z")
I wrote a script, the purpose is to store the value of the last 5 changes of a tag, but now I found a strange phenomenon, when the measuring point changes once, the same value as the timestamp will be stored, help me … --- ## [Get status of transaction group](https://forum.inductiveautomation.com/t/get-status-of-transaction-group/29327)
**Author:** [@fmjingenieros](https://forum.inductiveautomation.com/u/fmjingenieros)\ **Replies:** 4\ **Last updated:** [October 9, 2020, 12:34am UTC](https://forum.inductiveautomation.com/t/get-status-of-transaction-group/29327 "2020-10-09T00:34:28Z")
Hi, We have a critical system that use transaction group. A register is inserted each time a tag changes, this depends on the system behaviour could be each 5 minutes or in weekend could be only one time at day. The pr… --- ## [Transaction Group Status Tags](https://forum.inductiveautomation.com/t/transaction-group-status-tags/39521)
**Author:** [@mokam](https://forum.inductiveautomation.com/u/mokam)\ **Replies:** 0\ **Last updated:** [October 8, 2020, 11:34pm UTC](https://forum.inductiveautomation.com/t/transaction-group-status-tags/39521 "2020-10-08T23:34:07Z")
Hi all, I need to know if there à way to know if the transaction group is working fine. Is there way to get the status of the transaction group running fine or not. Thanks. Ignition 8.0.5 --- ## [How to center columns in an Alarm Status Table?](https://forum.inductiveautomation.com/t/how-to-center-columns-in-an-alarm-status-table/38069)
**Author:** [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Replies:** 1\ **Last updated:** [October 8, 2020, 10:18pm UTC](https://forum.inductiveautomation.com/t/how-to-center-columns-in-an-alarm-status-table/38069 "2020-10-08T22:18:02Z")
Good afternoon, Is it possible to center the columns on an Alarm Status Table? I can’t seem to find a setting where that is possible. Thanks for any info. [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1112) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1114)