# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=529 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 530 --- ## [When to refresh the binding on a table edited by multiple-clients?](https://forum.inductiveautomation.com/t/when-to-refresh-the-binding-on-a-table-edited-by-multiple-clients/43652)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 25\ **Last updated:** [November 29, 2023, 7:18pm UTC](https://forum.inductiveautomation.com/t/when-to-refresh-the-binding-on-a-table-edited-by-multiple-clients/43652 "2023-11-29T19:18:29Z")
I’ve got a simple configurations table in my Perspective application. It’s used to populate various dropdowns in other views. Multiple users can edit the table. It seems to me … I don’t want a polling binding to the da… --- ## [How do you sort a dataset?](https://forum.inductiveautomation.com/t/how-do-you-sort-a-dataset/4090)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 16\ **Last updated:** [November 29, 2023, 6:47pm UTC](https://forum.inductiveautomation.com/t/how-do-you-sort-a-dataset/4090 "2023-11-29T18:47:12Z")
I find myself stumped again! I have sorted lists before but I am at a loss as to why I cannot do this. The table I am trying to sort has three columns and about 50 rows. ds = event.source.parent.getComponent('Table').… --- ## [Chart data on "Y"](https://forum.inductiveautomation.com/t/chart-data-on-y/82380)
**Author:** [@antonio.sanchez](https://forum.inductiveautomation.com/u/antonio.sanchez)\ **Replies:** 6\ **Last updated:** [November 29, 2023, 6:22pm UTC](https://forum.inductiveautomation.com/t/chart-data-on-y/82380 "2023-11-29T18:22:13Z")
Hello Everyone I have the next situation, I do a chart whit the next query SELECT CONVERT(INT, CONVERT(VARCHAR,CONVERT(DATE,dm.Fecha),112)) AS 'Fechax', SUM(CASE WHEN dm.Linea = 'ELFO\_006\_Oficinas' THEN dm.Dato - ISNUL… --- ## [Removing Historian Tables](https://forum.inductiveautomation.com/t/removing-historian-tables/82483)
**Author:** [@jmb6259](https://forum.inductiveautomation.com/u/jmb6259)\ **Replies:** 3\ **Last updated:** [November 29, 2023, 4:50pm UTC](https://forum.inductiveautomation.com/t/removing-historian-tables/82483 "2023-11-29T16:50:23Z")
Is there a best practice for removing old historian tables? I have a lot of old tables that contain data we no longer use. I would like to clean up the database and remove them, but I'm not sure if simply deleting the … --- ## [Unable to Override Resource](https://forum.inductiveautomation.com/t/unable-to-override-resource/82484)
**Author:** [@rfolkes](https://forum.inductiveautomation.com/u/rfolkes)\ **Replies:** 2\ **Last updated:** [November 29, 2023, 4:12pm UTC](https://forum.inductiveautomation.com/t/unable-to-override-resource/82484 "2023-11-29T16:12:00Z")
8.1.33 Is there a setting somewhere that prevents Override of resources from parent project? --- ## [Ignition 8 Alarm Journal Query speeds](https://forum.inductiveautomation.com/t/ignition-8-alarm-journal-query-speeds/37059)
**Author:** [@ssilk76](https://forum.inductiveautomation.com/u/ssilk76)\ **Replies:** 7\ **Last updated:** [November 29, 2023, 4:04pm UTC](https://forum.inductiveautomation.com/t/ignition-8-alarm-journal-query-speeds/37059 "2023-11-29T16:04:36Z")
We recently transitioned from 7.9.10 to 8.0.12 and overall it has been a fairly smooth transition. However… I have some alarm journal queries where I gather the top 10 alarms by duration and frequency for a machine in a… --- ## [Ignition Vision Client Errors Opening Projects](https://forum.inductiveautomation.com/t/ignition-vision-client-errors-opening-projects/80605)
**Author:** [@Ly17](https://forum.inductiveautomation.com/u/Ly17)\ **Replies:** 3\ **Last updated:** [November 29, 2023, 4:01pm UTC](https://forum.inductiveautomation.com/t/ignition-vision-client-errors-opening-projects/80605 "2023-11-29T16:01:00Z")
Anyone knows that errors below are and how to resolve them. One of our users tried opening a project in Vision client and received those errors. Thanks, --- ## [Perspective Workstation multiple tabs](https://forum.inductiveautomation.com/t/perspective-workstation-multiple-tabs/82090)
**Author:** [@Bigtalljv](https://forum.inductiveautomation.com/u/Bigtalljv)\ **Replies:** 2\ **Last updated:** [November 29, 2023, 3:34pm UTC](https://forum.inductiveautomation.com/t/perspective-workstation-multiple-tabs/82090 "2023-11-29T15:34:36Z")
Hi, I know it's come up before, but I can't seem to find a answer. Is there any plan to have perspective workstation able to have multiple tabs open? Its a very common request from my users. We have redundant ignitio… --- ## [Insert tag historian points on a remote tag provider](https://forum.inductiveautomation.com/t/insert-tag-historian-points-on-a-remote-tag-provider/82481)
**Author:** [@Eskil\_Holum](https://forum.inductiveautomation.com/u/Eskil_Holum)\ **Replies:** 0\ **Last updated:** [November 29, 2023, 3:12pm UTC](https://forum.inductiveautomation.com/t/insert-tag-historian-points-on-a-remote-tag-provider/82481 "2023-11-29T15:12:02Z")
I want to use the system.tag.storeTagHistory to insert some old data we have on some datapoints. This usually works fine but this time the data comes from an edge device as a remote tag provider and what happens when i u… --- ## [\[BUG\] tagBrowserStartPath on Power Chart not working on startup](https://forum.inductiveautomation.com/t/bug-tagbrowserstartpath-on-power-chart-not-working-on-startup/82480)
**Author:** [@Eskil\_Holum](https://forum.inductiveautomation.com/u/Eskil_Holum)\ **Replies:** 0\ **Last updated:** [November 29, 2023, 3:04pm UTC](https://forum.inductiveautomation.com/t/bug-tagbrowserstartpath-on-power-chart-not-working-on-startup/82480 "2023-11-29T15:04:06Z")
tagBrowserStartPath is not working on powerchart when the startpath is calculated on a tag. I have a powerchart which has the startpath calculated in a binding. Expected result: Start path for browsing tags starts at … --- ## [Config Security Zones Perspective project](https://forum.inductiveautomation.com/t/config-security-zones-perspective-project/82473)
**Author:** [@sebastien\_ng](https://forum.inductiveautomation.com/u/sebastien_ng)\ **Replies:** 4\ **Last updated:** [November 29, 2023, 2:54pm UTC](https://forum.inductiveautomation.com/t/config-security-zones-perspective-project/82473 "2023-11-29T14:54:08Z")
Hello, helm me understand sommething about security zones. I want restrict users to connect on project by IP adress. The project is on localhost and computer is connected on wifi (IP adress :192.168.1.144) I configure… --- ## [Writing tag values to ignition OPC UA Server](https://forum.inductiveautomation.com/t/writing-tag-values-to-ignition-opc-ua-server/82401)
**Author:** [@historian\_user](https://forum.inductiveautomation.com/u/historian_user)\ **Replies:** 2\ **Last updated:** [November 29, 2023, 2:46pm UTC](https://forum.inductiveautomation.com/t/writing-tag-values-to-ignition-opc-ua-server/82401 "2023-11-29T14:46:03Z")
Hi, I am trying to write different register tags into the Ignition OPC UA server from where I Can read it using my Node red Modbus server. Any pointers to how I can proceed? I want to use a view from where I Can just p… --- ## [Unknown Issue With Perspective](https://forum.inductiveautomation.com/t/unknown-issue-with-perspective/82478)
**Author:** [@Ryan\_Craig](https://forum.inductiveautomation.com/u/Ryan_Craig)\ **Replies:** 4\ **Last updated:** [November 29, 2023, 2:40pm UTC](https://forum.inductiveautomation.com/t/unknown-issue-with-perspective/82478 "2023-11-29T14:40:34Z")
I am having an issue occur on one of our prospective projects that I can't seem to trouble shoot. We use a perspective project as an HMI for our machines that controls which recipe the machine is run on, based on the Par… --- ## [\[Feature Request\] - Add property to Tab Container to save state of embedded views](https://forum.inductiveautomation.com/t/feature-request-add-property-to-tab-container-to-save-state-of-embedded-views/82471)
**Author:** [@laura.strydom](https://forum.inductiveautomation.com/u/laura.strydom)\ **Replies:** 4\ **Last updated:** [November 29, 2023, 1:30pm UTC](https://forum.inductiveautomation.com/t/feature-request-add-property-to-tab-container-to-save-state-of-embedded-views/82471 "2023-11-29T13:30:31Z")
Good day, I want to submit a feature request to add a property to the Tab Container that will allow to save the state of embedded views when switching between tabs. Currently, the Tabs property has an internal property… --- ## [hasRole() expression error and system tag path error](https://forum.inductiveautomation.com/t/hasrole-expression-error-and-system-tag-path-error/82475)
**Author:** [@Why\_Me](https://forum.inductiveautomation.com/u/Why_Me)\ **Replies:** 3\ **Last updated:** [November 29, 2023, 1:24pm UTC](https://forum.inductiveautomation.com/t/hasrole-expression-error-and-system-tag-path-error/82475 "2023-11-29T13:24:27Z")
I have an error using hasRole() using single arg.. If i input all args it seems to be ok but thats manually entering username.. so i then try to get the user name from the system tags and it returns null? Even tho… --- ## [Manage remote Database Instances(queries, tables) through Ignition views](https://forum.inductiveautomation.com/t/manage-remote-database-instances-queries-tables-through-ignition-views/82461)
**Author:** [@Mohd\_Waqas](https://forum.inductiveautomation.com/u/Mohd_Waqas)\ **Replies:** 1\ **Last updated:** [November 29, 2023, 12:29pm UTC](https://forum.inductiveautomation.com/t/manage-remote-database-instances-queries-tables-through-ignition-views/82461 "2023-11-29T12:29:39Z")
Hi, I have one query like do we have any possibilities to configure remote site Database instances through ignition views. any functions, any script to update the DB instances like managing tables, delete/update/modified… --- ## [\[BUG\] Database Query Browser queries clear](https://forum.inductiveautomation.com/t/bug-database-query-browser-queries-clear/78706)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 1\ **Last updated:** [November 29, 2023, 12:16pm UTC](https://forum.inductiveautomation.com/t/bug-database-query-browser-queries-clear/78706 "2023-11-29T12:16:52Z")
The DB Query Browser tool clears the queries when you do certain things like: Open the DB tool from another "workspace" (e.g. Scripting/Perspective/Vision/Named Queries) by clicking on Tools -\> Database Query Browser R… --- ## [User Management works in Designer but not in client](https://forum.inductiveautomation.com/t/user-management-works-in-designer-but-not-in-client/82468)
**Author:** [@Why\_Me](https://forum.inductiveautomation.com/u/Why_Me)\ **Replies:** 5\ **Last updated:** [November 29, 2023, 12:04pm UTC](https://forum.inductiveautomation.com/t/user-management-works-in-designer-but-not-in-client/82468 "2023-11-29T12:04:42Z")
When i launch project from designer the component doesnt work. It obviously has something to do with the symbol in the top left. Gateway is set to allow it to be done from client. If i go to preview mode it works fine… --- ## [SQL Query Where in list](https://forum.inductiveautomation.com/t/sql-query-where-in-list/42771)
**Author:** [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\ **Replies:** 7\ **Last updated:** [November 29, 2023, 11:48am UTC](https://forum.inductiveautomation.com/t/sql-query-where-in-list/42771 "2023-11-29T11:48:29Z")
OK my brain is hurting and I can’t seem to figure this out. I’ve got a list of strings and I’m trying to do a query using the WHERE IN operator. This is in MySQL. Basically list = \[item1,item2,item3,item4\] sqlQuery = … --- ## [Clear output console contents from script](https://forum.inductiveautomation.com/t/clear-output-console-contents-from-script/15213)
**Author:** [@iamthebull](https://forum.inductiveautomation.com/u/iamthebull)\ **Replies:** 30\ **Last updated:** [November 29, 2023, 11:33am UTC](https://forum.inductiveautomation.com/t/clear-output-console-contents-from-script/15213 "2023-11-29T11:33:41Z")
Is it possible to clear the content of the output console from a script? Or to simulate clicking the Clear button to do the same? Both in the designer and the client? --- ## [Ignition Server shutting down](https://forum.inductiveautomation.com/t/ignition-server-shutting-down/82452)
**Author:** [@Renz\_Eran\_Santos](https://forum.inductiveautomation.com/u/Renz_Eran_Santos)\ **Replies:** 13\ **Last updated:** [November 29, 2023, 9:32am UTC](https://forum.inductiveautomation.com/t/ignition-server-shutting-down/82452 "2023-11-29T09:32:14Z")
Hi, Can someone help me, our Ignition Master Server keeps on crashing and based on the performance, there are times where it uses almost 90% of CPU and memory. Thanks. --- ## [XY Chart - moving the chart with the mouse](https://forum.inductiveautomation.com/t/xy-chart-moving-the-chart-with-the-mouse/81220)
**Author:** [@Rafal\_Samoraj](https://forum.inductiveautomation.com/u/Rafal_Samoraj)\ **Replies:** 1\ **Last updated:** [October 31, 2023, 10:43am UTC](https://forum.inductiveautomation.com/t/xy-chart-moving-the-chart-with-the-mouse/81220 "2023-10-31T10:43:30Z")
Hello, Is it possible too move xy chart with the mouse? You can see on the photo that data is cut compering to table. There are many records so, chart is illegible. How to do to show fe. 5 days and move y axis to the le… --- ## [Adding a banner notice and footer HTML to gateway login page (Security Requirement)](https://forum.inductiveautomation.com/t/adding-a-banner-notice-and-footer-html-to-gateway-login-page-security-requirement/82442)
**Author:** [@tremor](https://forum.inductiveautomation.com/u/tremor)\ **Replies:** 2\ **Last updated:** [November 28, 2023, 11:16pm UTC](https://forum.inductiveautomation.com/t/adding-a-banner-notice-and-footer-html-to-gateway-login-page-security-requirement/82442 "2023-11-28T23:16:36Z")
Due to IT Security compliance requirements on ALL web apps deployed on our network, our company (and legal department) is requiring that on the Ignition Gateways where we login, to place a standard login notice message t… --- ## [The devices disappear from the Connected Devices list](https://forum.inductiveautomation.com/t/the-devices-disappear-from-the-connected-devices-list/27082)
**Author:** [@juan.guerrero](https://forum.inductiveautomation.com/u/juan.guerrero)\ **Replies:** 5\ **Last updated:** [November 28, 2023, 10:35pm UTC](https://forum.inductiveautomation.com/t/the-devices-disappear-from-the-connected-devices-list/27082 "2023-11-28T22:35:20Z")
Hello everyone I have a problem with the Ignition Gateway, I usually have 35 devices connected, but now only 18 appear. I don’t know what happened to the other devices. I have already restarted the service more than 5… --- ## [Omron NJ PLC using FINS/TCP Cant See Tags](https://forum.inductiveautomation.com/t/omron-nj-plc-using-fins-tcp-cant-see-tags/82409)
**Author:** [@Saad\_Ali\_Hassan](https://forum.inductiveautomation.com/u/Saad_Ali_Hassan)\ **Replies:** 3\ **Last updated:** [November 28, 2023, 10:09pm UTC](https://forum.inductiveautomation.com/t/omron-nj-plc-using-fins-tcp-cant-see-tags/82409 "2023-11-28T22:09:27Z")
Hi all, I am using Omron NJ Driver for my Omron NJ101 PLC to read/write tags in Ignition. The response time is very slow (4-5 secs) e.g. any button for turn off/on. Could be a network-related issue. On the side, I d… --- ## [When does a gateway timer script start?](https://forum.inductiveautomation.com/t/when-does-a-gateway-timer-script-start/82449)
**Author:** [@Derek\_Reees](https://forum.inductiveautomation.com/u/Derek_Reees)\ **Replies:** 5\ **Last updated:** [November 28, 2023, 9:24pm UTC](https://forum.inductiveautomation.com/t/when-does-a-gateway-timer-script-start/82449 "2023-11-28T21:24:48Z")
I have a script I need to run at the top of the hour but say the gateway restarts at the 59th minute. Would It not be executed again until another hour has passed? --- ## [Trying to move from InTouch to Ignition and have some questions](https://forum.inductiveautomation.com/t/trying-to-move-from-intouch-to-ignition-and-have-some-questions/82331)
**Author:** [@emilioc](https://forum.inductiveautomation.com/u/emilioc)\ **Replies:** 10\ **Last updated:** [November 28, 2023, 8:22pm UTC](https://forum.inductiveautomation.com/t/trying-to-move-from-intouch-to-ignition-and-have-some-questions/82331 "2023-11-28T20:22:19Z")
Hi everyone, I'm trying to learn how to use Ignition. I've always used Wonderware InTouch or Foxboro FoxView for HMI design in my projects, and I'm interested in exploring whether Ignition is a suitable alternative. Be… --- ## [Save OPC Quick Client Subscriptions](https://forum.inductiveautomation.com/t/save-opc-quick-client-subscriptions/82434)
**Author:** [@wpmccormick](https://forum.inductiveautomation.com/u/wpmccormick)\ **Replies:** 6\ **Last updated:** [November 28, 2023, 8:16pm UTC](https://forum.inductiveautomation.com/t/save-opc-quick-client-subscriptions/82434 "2023-11-28T20:16:06Z")
Is there no way to save the tabs that are created when a Subscription Name is Set in the OPC Quick Client? --- ## [Force authentication outside IP Range](https://forum.inductiveautomation.com/t/force-authentication-outside-ip-range/82048)
**Author:** [@Calvin\_Piche](https://forum.inductiveautomation.com/u/Calvin_Piche)\ **Replies:** 2\ **Last updated:** [November 28, 2023, 6:48pm UTC](https://forum.inductiveautomation.com/t/force-authentication-outside-ip-range/82048 "2023-11-28T18:48:52Z")
I am wanting to setup my perspective project so that if we are on our local network the project would be accessible without authentication. If a user is connecting to the project outside of our network, it would force th… --- ## [httpPost() not sending content in 7.9.17](https://forum.inductiveautomation.com/t/httppost-not-sending-content-in-7-9-17/82406)
**Author:** [@Kavi\_Sen](https://forum.inductiveautomation.com/u/Kavi_Sen)\ **Replies:** 2\ **Last updated:** [November 28, 2023, 6:05pm UTC](https://forum.inductiveautomation.com/t/httppost-not-sending-content-in-7-9-17/82406 "2023-11-28T18:05:14Z")
I'm using 7.9.17 and am trying to post to a URL using httpPost() - system.net.httpPost - Ignition User Manual 7.9 - Ignition Documentation val = system.net.httpPost("http://localhost:5000/available\_tasks", {"status":"re… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=528) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=530)