# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1218 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1219 --- ## [Executing script based on button](https://forum.inductiveautomation.com/t/executing-script-based-on-button/43570)
**Author:** [@michael.black](https://forum.inductiveautomation.com/u/michael.black)\ **Replies:** 4\ **Last updated:** [February 19, 2021, 3:10pm UTC](https://forum.inductiveautomation.com/t/executing-script-based-on-button/43570 "2021-02-19T15:10:55Z")
I have a button on a popup screen I am executing a script on. I have put the script in the Scripting folder. I have created a function called parts\_in\_entry. I am also passing in a parameter from the popup screen (vie… --- ## [After joining tables SUM() function returns wrong value](https://forum.inductiveautomation.com/t/after-joining-tables-sum-function-returns-wrong-value/43618)
**Author:** [@rwalters1](https://forum.inductiveautomation.com/u/rwalters1)\ **Replies:** 2\ **Last updated:** [February 19, 2021, 3:06pm UTC](https://forum.inductiveautomation.com/t/after-joining-tables-sum-function-returns-wrong-value/43618 "2021-02-19T15:06:49Z")
I have two tables (postgres database)- table1 has three columns (part\_number, scrap\_code, scrap\_lbs) table2 has three columns (fk\_part\_number, fk\_scrap\_code, operation\_code) When I SUM() the scrap\_lbs column from tabl… --- ## [Expression pollRate sdk](https://forum.inductiveautomation.com/t/expression-pollrate-sdk/42645)
**Author:** [@448719222](https://forum.inductiveautomation.com/u/448719222)\ **Replies:** 9\ **Last updated:** [February 19, 2021, 1:28pm UTC](https://forum.inductiveautomation.com/t/expression-pollrate-sdk/42645 "2021-02-19T13:28:52Z")
We have developed an expression, but I hope that this expression can control the execution rate by passing a parameter, for example, 1000 after runscript ('exr() ', 1000) to control the execution rate, and now() expressi… --- ## [How many concurrent perspective sessions do you have](https://forum.inductiveautomation.com/t/how-many-concurrent-perspective-sessions-do-you-have/43596)
**Author:** [@calimero100582](https://forum.inductiveautomation.com/u/calimero100582)\ **Replies:** 1\ **Last updated:** [February 19, 2021, 12:55pm UTC](https://forum.inductiveautomation.com/t/how-many-concurrent-perspective-sessions-do-you-have/43596 "2021-02-19T12:55:06Z")
Out of curiosity. How many concurrent users do you have for a single gateway? There is a lot of opportunities with Ignition, and I’m curious to know how high it can go, as some ideas could get me over 200 users at simult… --- ## [Relationship between tables](https://forum.inductiveautomation.com/t/relationship-between-tables/43598)
**Author:** [@fahad.ansari](https://forum.inductiveautomation.com/u/fahad.ansari)\ **Replies:** 1\ **Last updated:** [February 19, 2021, 12:52pm UTC](https://forum.inductiveautomation.com/t/relationship-between-tables/43598 "2021-02-19T12:52:12Z")
Can someone please help me to understand the relation between MESMaterialDEF table and MESEquipment table. --- ## [Projects for serveral water treatment plants](https://forum.inductiveautomation.com/t/projects-for-serveral-water-treatment-plants/43609)
**Author:** [@mojoeswa](https://forum.inductiveautomation.com/u/mojoeswa)\ **Replies:** 0\ **Last updated:** [February 19, 2021, 11:09am UTC](https://forum.inductiveautomation.com/t/projects-for-serveral-water-treatment-plants/43609 "2021-02-19T11:09:22Z")
Hi. I am investigating the possibility of using Ignition with several water treatment plants within a corporate WAN I want to use a central gateway with AEM (controller) and several connected gateways (agents). A gatew… --- ## [How to add space after every array value in perspective XY Chart](https://forum.inductiveautomation.com/t/how-to-add-space-after-every-array-value-in-perspective-xy-chart/39958)
**Author:** [@archana.deshmukh](https://forum.inductiveautomation.com/u/archana.deshmukh)\ **Replies:** 1\ **Last updated:** [February 19, 2021, 7:55am UTC](https://forum.inductiveautomation.com/t/how-to-add-space-after-every-array-value-in-perspective-xy-chart/39958 "2021-02-19T07:55:02Z")
--- ## [Tag history sync](https://forum.inductiveautomation.com/t/tag-history-sync/43601)
**Author:** [@wofoster](https://forum.inductiveautomation.com/u/wofoster)\ **Replies:** 0\ **Last updated:** [February 19, 2021, 7:09am UTC](https://forum.inductiveautomation.com/t/tag-history-sync/43601 "2021-02-19T07:09:34Z")
Hi all: I have a Cloud Gateway Version 8 manages varius remote edge via EAM so we also sync the Edge historian and it works fine. Now, my next step is to connect normal ignition gatewyas and have the same scenario with… --- ## [Stacked bar issue](https://forum.inductiveautomation.com/t/stacked-bar-issue/43599)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 0\ **Last updated:** [February 19, 2021, 3:47am UTC](https://forum.inductiveautomation.com/t/stacked-bar-issue/43599 "2021-02-19T03:47:13Z")
data = event.source.selectedData print data i am printing the Stacked bar - slectedData property. when i click the stacked bar different colors i am getting the output of dataset of each color which i have method in im… --- ## [Programmatically-applied PowerTable Filters](https://forum.inductiveautomation.com/t/programmatically-applied-powertable-filters/15495)
**Author:** [@MindMusic](https://forum.inductiveautomation.com/u/MindMusic)\ **Replies:** 5\ **Last updated:** [December 7, 2018, 8:42pm UTC](https://forum.inductiveautomation.com/t/programmatically-applied-powertable-filters/15495 "2018-12-07T20:42:01Z")
Hey there everyone. :slight\_smile: I have a PowerTable on a Popup dialog. The following code runs on the PowerTable's initialize function: import com.jidesoft.filter.AbstractFilter Determine Laptop Name from LaptopI… --- ## [Named Query Transaction Closed](https://forum.inductiveautomation.com/t/named-query-transaction-closed/43595)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 0\ **Last updated:** [February 18, 2021, 10:59pm UTC](https://forum.inductiveautomation.com/t/named-query-transaction-closed/43595 "2021-02-18T22:59:54Z")
Why when I run the following code in a gateway script I get an error on line 3 saying the transaction has been closed? If I run the same code in the script console it works fine. com.inductiveautomation.ignition.com… --- ## [Perspective table - call onCellEditCommit from onBlur event](https://forum.inductiveautomation.com/t/perspective-table-call-oncelleditcommit-from-onblur-event/43588)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 1\ **Last updated:** [February 18, 2021, 10:38pm UTC](https://forum.inductiveautomation.com/t/perspective-table-call-oncelleditcommit-from-onblur-event/43588 "2021-02-18T22:38:35Z")
Ignition 8.1.1. Table cell editing requires that Enter is pressed to trigger the onCellEditCommit event. How do I call the onCellEditCommit routine from the onBlur event? Oh, and will it work? --- ## [Best Way to Develop While Disconnected from Device](https://forum.inductiveautomation.com/t/best-way-to-develop-while-disconnected-from-device/41759)
**Author:** [@rrebro](https://forum.inductiveautomation.com/u/rrebro)\ **Replies:** 11\ **Last updated:** [February 18, 2021, 9:52pm UTC](https://forum.inductiveautomation.com/t/best-way-to-develop-while-disconnected-from-device/41759 "2021-02-18T21:52:32Z")
I am working on creating a standard for our HMIs using Ignition Vision. One of the biggest obstacles is trying to develop while away from the actual live PLC. I know there must be an easy way that I am missing. --- ## [History data table clean on tag deletion?](https://forum.inductiveautomation.com/t/history-data-table-clean-on-tag-deletion/35360)
**Author:** [@paul.nelson](https://forum.inductiveautomation.com/u/paul.nelson)\ **Replies:** 3\ **Last updated:** [February 18, 2021, 8:50pm UTC](https://forum.inductiveautomation.com/t/history-data-table-clean-on-tag-deletion/35360 "2021-02-18T20:50:49Z")
Does anyone have a procedure that they have developed to ‘clean up’ the sqlt\_data\_ tables if and when history configuration is dropped for a tag? We are going to either stop collecting on a significant number of tags or … --- ## [Perspective Checkbox fires onClick script twice](https://forum.inductiveautomation.com/t/perspective-checkbox-fires-onclick-script-twice/43585)
**Author:** [@dkylep](https://forum.inductiveautomation.com/u/dkylep)\ **Replies:** 4\ **Last updated:** [February 18, 2021, 8:32pm UTC](https://forum.inductiveautomation.com/t/perspective-checkbox-fires-onclick-script-twice/43585 "2021-02-18T20:32:23Z")
Ignition Perspective 8.1.1 (b2020120808) Checkbox firing ‘onClick’ script, twice… I ran into this problem and to confirm I made a simple perspective view with 1 Checkbox and 1 Label which has the same behavior. I set… --- ## [Sparkline Chart and Database Connection Fault](https://forum.inductiveautomation.com/t/sparkline-chart-and-database-connection-fault/43582)
**Author:** [@micah.hastings](https://forum.inductiveautomation.com/u/micah.hastings)\ **Replies:** 4\ **Last updated:** [February 18, 2021, 7:14pm UTC](https://forum.inductiveautomation.com/t/sparkline-chart-and-database-connection-fault/43582 "2021-02-18T19:14:19Z")
I have a sparkline chart which is displaying data via a SQL query for realtime charting. Problem is, if the database connection is down, the endless errors just keep being displayed no matter how many times you close the… --- ## [Perspective - Dropdown Menu](https://forum.inductiveautomation.com/t/perspective-dropdown-menu/43578)
**Author:** [@CeciliaOsorio2013](https://forum.inductiveautomation.com/u/CeciliaOsorio2013)\ **Replies:** 2\ **Last updated:** [February 18, 2021, 6:08pm UTC](https://forum.inductiveautomation.com/t/perspective-dropdown-menu/43578 "2021-02-18T18:08:52Z")
I am trying to add a sub-dropdown menu when hovering over an element on a dropdown menu. Is this possible in perspective? --- ## [Request Time Out system.util.sendRequest When Adding or Editing or Deleting User from Hybrid User Source](https://forum.inductiveautomation.com/t/request-time-out-system-util-sendrequest-when-adding-or-editing-or-deleting-user-from-hybrid-user-source/43579)
**Author:** [@kissamcorrina](https://forum.inductiveautomation.com/u/kissamcorrina)\ **Replies:** 0\ **Last updated:** [February 18, 2021, 5:49pm UTC](https://forum.inductiveautomation.com/t/request-time-out-system-util-sendrequest-when-adding-or-editing-or-deleting-user-from-hybrid-user-source/43579 "2021-02-18T17:49:13Z")
I essentially created a custom User Management component out of templates so users can edit the project’s user source. I decided to make a custom user management template for 2 reasons. 1) To more easily match the projec… --- ## [Refreshing database after adding row to table](https://forum.inductiveautomation.com/t/refreshing-database-after-adding-row-to-table/43574)
**Author:** [@tdeleissegues](https://forum.inductiveautomation.com/u/tdeleissegues)\ **Replies:** 5\ **Last updated:** [February 18, 2021, 5:18pm UTC](https://forum.inductiveautomation.com/t/refreshing-database-after-adding-row-to-table/43574 "2021-02-18T17:18:44Z")
I’ve made code to add a new row of data to my existing datatable over PostgreSQL and its adding the row successfully but its not refreshing the database. I was wondering what code would be used to refresh the database li… --- ## [Perspective Hover Style in Flex Repeater](https://forum.inductiveautomation.com/t/perspective-hover-style-in-flex-repeater/43548)
**Author:** [@mcgheeiv](https://forum.inductiveautomation.com/u/mcgheeiv)\ **Replies:** 6\ **Last updated:** [February 18, 2021, 5:01pm UTC](https://forum.inductiveautomation.com/t/perspective-hover-style-in-flex-repeater/43548 "2021-02-18T17:01:06Z")
Ignition 8.1.0 Attempting to emulate “tooltip” in Perspective. When the sub view is instantiated in an Embedded View the hover style works as expected. When the sub view is instantiated in a Flex Repeater, only informat… --- ## [Report Query- Table name as parameter (7.9)](https://forum.inductiveautomation.com/t/report-query-table-name-as-parameter-7-9/43569)
**Author:** [@Troy](https://forum.inductiveautomation.com/u/Troy)\ **Replies:** 6\ **Last updated:** [February 18, 2021, 4:15pm UTC](https://forum.inductiveautomation.com/t/report-query-table-name-as-parameter-7-9/43569 "2021-02-18T16:15:44Z")
In the Reporting Module, I have a script that determines which table the data is in, then sets data\[‘db\_table’\] = ‘myTable’. Then the query runs after the script, but gives an error saying “@p0” is not defined, even if … --- ## [How to define a tag within a perspective button ActionPerformed Script](https://forum.inductiveautomation.com/t/how-to-define-a-tag-within-a-perspective-button-actionperformed-script/43541)
**Author:** [@michael.black](https://forum.inductiveautomation.com/u/michael.black)\ **Replies:** 6\ **Last updated:** [February 18, 2021, 4:03pm UTC](https://forum.inductiveautomation.com/t/how-to-define-a-tag-within-a-perspective-button-actionperformed-script/43541 "2021-02-18T16:03:16Z")
I am trying to recreate this same script from a vision project and can’t figure out how to do it. It is an ActionPerformed Event script for when a button is pressed: I dont see how I can do this within a perspective… --- ## [Gateway Timer Event Script Help](https://forum.inductiveautomation.com/t/gateway-timer-event-script-help/43565)
**Author:** [@iceberg](https://forum.inductiveautomation.com/u/iceberg)\ **Replies:** 5\ **Last updated:** [February 18, 2021, 3:22pm UTC](https://forum.inductiveautomation.com/t/gateway-timer-event-script-help/43565 "2021-02-18T15:22:41Z")
I have a script that I would like to run at a predefined time (2am every morning). Looking through documentation, this sounds like I would want to use a Gateway Timer Event Script with a fixed rate. I can’t seem to find … --- ## [Turn off Client updates](https://forum.inductiveautomation.com/t/turn-off-client-updates/43567)
**Author:** [@jarno.vandenberg](https://forum.inductiveautomation.com/u/jarno.vandenberg)\ **Replies:** 4\ **Last updated:** [February 18, 2021, 3:09pm UTC](https://forum.inductiveautomation.com/t/turn-off-client-updates/43567 "2021-02-18T15:09:17Z")
Hello, Is there a way to turn off client updates after saving the project in the designer? I have a habbit of saving every minute or so (habbit from my early Siemens step 7 days). It is rather anoying that the users ei… --- ## [\[BUG\] 8.1.0 Vision reports unknown expression function "isAuthorized"?](https://forum.inductiveautomation.com/t/bug-8-1-0-vision-reports-unknown-expression-function-isauthorized/43561)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 4\ **Last updated:** [February 18, 2021, 1:23pm UTC](https://forum.inductiveautomation.com/t/bug-8-1-0-vision-reports-unknown-expression-function-isauthorized/43561 "2021-02-18T13:23:05Z")
I’m getting this error when trying to use the Expression function isAuthorized: ERROR com.inductiveautomation.ignition.client.util.gui.ErrorUtil - Unknown function: 'isAuthorized' --- ## [Error when executing a timer script](https://forum.inductiveautomation.com/t/error-when-executing-a-timer-script/43564)
**Author:** [@lachguerabdallah](https://forum.inductiveautomation.com/u/lachguerabdallah)\ **Replies:** 4\ **Last updated:** [February 18, 2021, 1:33pm UTC](https://forum.inductiveautomation.com/t/error-when-executing-a-timer-script/43564 "2021-02-18T13:33:15Z")
Ignition 8.0.12 I have a project function. I call this function from a timer script. but i get an error on the gateway. the function works fine when I call it from somewhere in the project. please help the error is t… --- ## ["A result set was generated for update." error for every alarm logged in the journal](https://forum.inductiveautomation.com/t/a-result-set-was-generated-for-update-error-for-every-alarm-logged-in-the-journal/43556)
**Author:** [@m.stretti](https://forum.inductiveautomation.com/u/m.stretti)\ **Replies:** 0\ **Last updated:** [February 18, 2021, 10:04am UTC](https://forum.inductiveautomation.com/t/a-result-set-was-generated-for-update-error-for-every-alarm-logged-in-the-journal/43556 "2021-02-18T10:04:46Z")
I have an alarm journal on ignition 8.1.1 logging on a sql server 2016 database. In the database default connection options “no count” is unchecked as is every other option. Very often alarms don’t get logged and end u… --- ## [GUI - inputBox, configrmBox - Strange behaviour](https://forum.inductiveautomation.com/t/gui-inputbox-configrmbox-strange-behaviour/22798)
**Author:** [@Mau89](https://forum.inductiveautomation.com/u/Mau89)\ **Replies:** 2\ **Last updated:** [February 18, 2021, 9:58am UTC](https://forum.inductiveautomation.com/t/gui-inputbox-configrmbox-strange-behaviour/22798 "2021-02-18T09:58:37Z")
Hi everyone, in my application I have a strange behavior. On a windows 10 client, it happens that the windows / dialogBox are not visible to Vision (inputBox, confirmBox, diagnostics window), while the opening of the p… --- ## [Perspective XY chart Gantt columns colors](https://forum.inductiveautomation.com/t/perspective-xy-chart-gantt-columns-colors/43555)
**Author:** [@Corentin.appart](https://forum.inductiveautomation.com/u/Corentin.appart)\ **Replies:** 0\ **Last updated:** [February 18, 2021, 9:42am UTC](https://forum.inductiveautomation.com/t/perspective-xy-chart-gantt-columns-colors/43555 "2021-02-18T09:42:09Z")
Hello all, I did the tuto to create a Gantt Chart : https://docs.inductiveautomation.com/display/DOC81/Perspective±+XY+Chart I have one serie. my question is the following : How can i change color of my columns depen… --- ## [Pass Tag History data as view parameter](https://forum.inductiveautomation.com/t/pass-tag-history-data-as-view-parameter/43553)
**Author:** [@Adriaan.leRoux](https://forum.inductiveautomation.com/u/Adriaan.leRoux)\ **Replies:** 0\ **Last updated:** [February 18, 2021, 6:27am UTC](https://forum.inductiveautomation.com/t/pass-tag-history-data-as-view-parameter/43553 "2021-02-18T06:27:04Z")
I have a chart in a view that I want to use as a template. This chart’s series data is bound to the view’s parameter using an expression, the view parameter is an array. When I do this I get no errors on the chart, but … [Previous page](https://forum.inductiveautomation.com/latest.md?page=1217) [Next page](https://forum.inductiveautomation.com/latest.md?page=1219)