# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1484 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1485 --- ## [SQL Express Database Question](https://forum.inductiveautomation.com/t/sql-express-database-question/27156)
**Author:** [@grietveld](https://forum.inductiveautomation.com/u/grietveld)\ **Replies:** 2\ **Last updated:** [August 6, 2019, 7:40pm UTC](https://forum.inductiveautomation.com/t/sql-express-database-question/27156 "2019-08-06T19:40:22Z")
I’m not the strongest DB guy, especially in SQL, but figured I might be able to get some help here. I’ve got an SQL Express instance running side by side with Ignition on a development computer. Once we have a few trans… --- ## [Modbus TCP and SQLTag String](https://forum.inductiveautomation.com/t/modbus-tcp-and-sqltag-string/7485)
**Author:** [@gnguyen](https://forum.inductiveautomation.com/u/gnguyen)\ **Replies:** 3\ **Last updated:** [August 6, 2019, 7:20pm UTC](https://forum.inductiveautomation.com/t/modbus-tcp-and-sqltag-string/7485 "2019-08-06T19:20:39Z")
Hi, A SQLTag, string type, 20 char. long, ex. HRS1:20. When you write it, let say '1234', so less than the 20 maxi. char, the empty char are replaced by space (x20), not null (x00), causing some difficulties to my plc. … --- ## [V8 API: browseAsync returns null values](https://forum.inductiveautomation.com/t/v8-api-browseasync-returns-null-values/27194)
**Author:** [@fyousuf](https://forum.inductiveautomation.com/u/fyousuf)\ **Replies:** 9\ **Last updated:** [August 6, 2019, 7:14pm UTC](https://forum.inductiveautomation.com/t/v8-api-browseasync-returns-null-values/27194 "2019-08-06T19:14:49Z")
I’m attempting to find tagpaths in one of my tagproviders. With this code. public void setup(GatewayContext gatewayContext) { try { provider=TagPathParser.parseSafe("\[default\]"); CompletableFuture\ **Author:** [@tbraun](https://forum.inductiveautomation.com/u/tbraun)\ **Replies:** 1\ **Last updated:** [August 6, 2019, 5:30pm UTC](https://forum.inductiveautomation.com/t/power-table-cell-edit-v8/27198 "2019-08-06T17:30:25Z") Hi, I have a power table, and am unable to edit the cells. I don’t see a parameter in the power table properties that enables cell editing. Additionally, is it possible to have a ‘color select’ box in a power table? Cu… --- ## [Backfeeding Data into a central Ignition gateway](https://forum.inductiveautomation.com/t/backfeeding-data-into-a-central-ignition-gateway/27202)
**Author:** [@Harikrishna\_Patadiya](https://forum.inductiveautomation.com/u/Harikrishna_Patadiya)\ **Replies:** 0\ **Last updated:** [August 6, 2019, 5:01pm UTC](https://forum.inductiveautomation.com/t/backfeeding-data-into-a-central-ignition-gateway/27202 "2019-08-06T17:01:28Z")
Hi, Here’s an interesting thought. The remote site has data from the past 2 years. We’re trying to spin up a central gateway (hosted on AWS or elsewhere) which will connect to the site gateway through the “Gateway Netw… --- ## [Remove orange rectangle focus on slider component](https://forum.inductiveautomation.com/t/remove-orange-rectangle-focus-on-slider-component/27183)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 1\ **Last updated:** [August 6, 2019, 2:09pm UTC](https://forum.inductiveautomation.com/t/remove-orange-rectangle-focus-on-slider-component/27183 "2019-08-06T14:09:54Z")
Hi How can I remove the orange rectangle focus on slider component permanently? --- ## [Using variables in a SQL WHERE IN() operator (scripting)](https://forum.inductiveautomation.com/t/using-variables-in-a-sql-where-in-operator-scripting/27130)
**Author:** [@hachjessed](https://forum.inductiveautomation.com/u/hachjessed)\ **Replies:** 9\ **Last updated:** [August 6, 2019, 11:49am UTC](https://forum.inductiveautomation.com/t/using-variables-in-a-sql-where-in-operator-scripting/27130 "2019-08-06T11:49:43Z")
I am trying to use a variable in a SQL SELECT query with an IN() operator in the WHERE clause. This is written in scripting on an action performed event handler of a button component. I am able to make this work with o… --- ## [Reseting table data](https://forum.inductiveautomation.com/t/reseting-table-data/17368)
**Author:** [@carolineuchoa.estuda](https://forum.inductiveautomation.com/u/carolineuchoa.estuda)\ **Replies:** 16\ **Last updated:** [August 6, 2019, 11:26am UTC](https://forum.inductiveautomation.com/t/reseting-table-data/17368 "2019-08-06T11:26:28Z")
Hello! Is it possible to create a button to reset the table data that is recorded until that moment, and start picking up new data from the time I press the button? In other words, I have a table recording 1 hour of re… --- ## [WebDev login, and forward to user specific project](https://forum.inductiveautomation.com/t/webdev-login-and-forward-to-user-specific-project/23679)
**Author:** [@SBL\_MC](https://forum.inductiveautomation.com/u/SBL_MC)\ **Replies:** 6\ **Last updated:** [August 6, 2019, 6:50am UTC](https://forum.inductiveautomation.com/t/webdev-login-and-forward-to-user-specific-project/23679 "2019-08-06T06:50:47Z")
Hi all, We are planning to use the webdev module to create an log in screen, and forward users to their project. Does anyone have samples on how to do this? Thanks! --- ## [Partial Pixels Ignition 8.02](https://forum.inductiveautomation.com/t/partial-pixels-ignition-8-02/27163)
**Author:** [@kwingert](https://forum.inductiveautomation.com/u/kwingert)\ **Replies:** 7\ **Last updated:** [August 5, 2019, 8:29pm UTC](https://forum.inductiveautomation.com/t/partial-pixels-ignition-8-02/27163 "2019-08-05T20:29:10Z")
Is there a way to prevent objects height and width from having decimal places? I’m developing the project at the maximum resolution and I’m finding that the decimal places make it difficult to align objects correctly. T… --- ## [Exporting UDTs crashes OPC UA Server and drivers](https://forum.inductiveautomation.com/t/exporting-udts-crashes-opc-ua-server-and-drivers/27180)
**Author:** [@roger\_larson](https://forum.inductiveautomation.com/u/roger_larson)\ **Replies:** 2\ **Last updated:** [August 5, 2019, 10:47pm UTC](https://forum.inductiveautomation.com/t/exporting-udts-crashes-opc-ua-server-and-drivers/27180 "2019-08-05T22:47:28Z")
Hi all, We have an enterprise system with about 30 tag providers (currently all local, but they will all be remote eventually). When trying to copy UDTs from one provider to another, or exporting tags or anything except… --- ## [Alarm Page Navigation using Vision's Tab Nav](https://forum.inductiveautomation.com/t/alarm-page-navigation-using-visions-tab-nav/27162)
**Author:** [@ryanastiefes](https://forum.inductiveautomation.com/u/ryanastiefes)\ **Replies:** 2\ **Last updated:** [August 5, 2019, 9:05pm UTC](https://forum.inductiveautomation.com/t/alarm-page-navigation-using-visions-tab-nav/27162 "2019-08-05T21:05:36Z")
Ignition 7.8.5 I’m using the Project Templates “Vision Tab Nav” on a project and would like to interface components with the pressing of the Alarm Button in the top right corner but I cant figure out where the south do… --- ## [\[BUG-14621\]System Gateway Tags have no values](https://forum.inductiveautomation.com/t/bug-14621-system-gateway-tags-have-no-values/27168)
**Author:** [@jpark](https://forum.inductiveautomation.com/u/jpark)\ **Replies:** 2\ **Last updated:** [August 5, 2019, 8:57pm UTC](https://forum.inductiveautomation.com/t/bug-14621-system-gateway-tags-have-no-values/27168 "2019-08-05T20:57:33Z")
In the latest 8.0.4 nightly, it looks like system gateway tags do not have values. --- ## [Ephemeral port exhaustion with 8.0.3 and 8.0.4](https://forum.inductiveautomation.com/t/ephemeral-port-exhaustion-with-8-0-3-and-8-0-4/27109)
**Author:** [@waldner](https://forum.inductiveautomation.com/u/waldner)\ **Replies:** 3\ **Last updated:** [August 5, 2019, 7:49pm UTC](https://forum.inductiveautomation.com/t/ephemeral-port-exhaustion-with-8-0-3-and-8-0-4/27109 "2019-08-05T19:49:09Z")
Happens with 8.0.3 rc2 and 8.0.4 nightly, OS is windows server 2016, both with designer and the vision client launcher. See the attached video for an example of what happens. Looking at netstat -a shows thousands of conn… --- ## [Historian Tag Data - Calculating Runtime](https://forum.inductiveautomation.com/t/historian-tag-data-calculating-runtime/27173)
**Author:** [@mnoll](https://forum.inductiveautomation.com/u/mnoll)\ **Replies:** 2\ **Last updated:** [August 5, 2019, 7:46pm UTC](https://forum.inductiveautomation.com/t/historian-tag-data-calculating-runtime/27173 "2019-08-05T19:46:48Z")
I am trying to generate some very basic OEE data for some machines that we are monitoring. We are pulling of about a dozen sensor values in real time, and I have determined that if one of the sensors is reading above a … --- ## [Prespective: Add values to dropdown from tag (Query based)](https://forum.inductiveautomation.com/t/prespective-add-values-to-dropdown-from-tag-query-based/27172)
**Author:** [@David.Bell](https://forum.inductiveautomation.com/u/David.Bell)\ **Replies:** 5\ **Last updated:** [August 5, 2019, 6:41pm UTC](https://forum.inductiveautomation.com/t/prespective-add-values-to-dropdown-from-tag-query-based/27172 "2019-08-05T18:41:03Z")
Hello, I cannot find any information on how to add values to a dropdown in Perspective using the tag (Query). This would be very helpful. I do not want to write a named query or manually add items. Thanks, David --- ## [\[FEATURE\] Casting function for Perspective properties](https://forum.inductiveautomation.com/t/feature-casting-function-for-perspective-properties/27146)
**Author:** [@andrea.morando](https://forum.inductiveautomation.com/u/andrea.morando)\ **Replies:** 4\ **Last updated:** [August 5, 2019, 6:03pm UTC](https://forum.inductiveautomation.com/t/feature-casting-function-for-perspective-properties/27146 "2019-08-05T18:03:45Z")
Dear all, I often have some troubles in managing the property datatypes in Perspective. In some cases, I need to convert them in python standard datatypes (list, dictionary, etc.), for example for using the “system.tag.… --- ## [Print out screens for use in manual](https://forum.inductiveautomation.com/t/print-out-screens-for-use-in-manual/27141)
**Author:** [@Marisa](https://forum.inductiveautomation.com/u/Marisa)\ **Replies:** 7\ **Last updated:** [August 5, 2019, 5:42pm UTC](https://forum.inductiveautomation.com/t/print-out-screens-for-use-in-manual/27141 "2019-08-05T17:42:38Z")
Is there any easy way to print out all the screens within a project? Also my customer has asked for this while the machine is in a container on the Pacific Ocean somewhere, so is there a way to print the screens out whil… --- ## [Client event script (keystroke) doesn´t run on screen2 (multiple monitors)](https://forum.inductiveautomation.com/t/client-event-script-keystroke-doesn-t-run-on-screen2-multiple-monitors/16733)
**Author:** [@lmis](https://forum.inductiveautomation.com/u/lmis)\ **Replies:** 4\ **Last updated:** [August 5, 2019, 5:02pm UTC](https://forum.inductiveautomation.com/t/client-event-script-keystroke-doesn-t-run-on-screen2-multiple-monitors/16733 "2019-08-05T17:02:45Z")
Hi, I have a project running on dual monitors. (open with system.gui.openDesktop(..) In my project I have a Client Event script, Keystroke Script. (that´s muting my Alarm Sound) Everything works fine when the prim… --- ## [\[BUG-14643\] SDK - Identity Providers - OKTA](https://forum.inductiveautomation.com/t/bug-14643-sdk-identity-providers-okta/27165)
**Author:** [@pocewar](https://forum.inductiveautomation.com/u/pocewar)\ **Replies:** 3\ **Last updated:** [August 5, 2019, 4:42pm UTC](https://forum.inductiveautomation.com/t/bug-14643-sdk-identity-providers-okta/27165 "2019-08-05T16:42:57Z")
Hi, We have 3 apps (iOS, Android and node JS) interacting with a custom Ignition 8 module (there’s also a web service involved which is the one communicating directly with Ignition backend through custom module). Apps … --- ## [Adding an option to sequel results](https://forum.inductiveautomation.com/t/adding-an-option-to-sequel-results/27169)
**Author:** [@ammermanbrittanyf](https://forum.inductiveautomation.com/u/ammermanbrittanyf)\ **Replies:** 2\ **Last updated:** [August 5, 2019, 3:46pm UTC](https://forum.inductiveautomation.com/t/adding-an-option-to-sequel-results/27169 "2019-08-05T15:46:11Z")
I am currently using this SQL Query to populate a drop down in ignition. SELECT DISTINCT VLAN FROM FA\_ECA\_MASTER ORDER BY VLAN ASC I was wondering if it was possible to add another row to the results. I have a few opti… --- ## [Auto-rotate through windows](https://forum.inductiveautomation.com/t/auto-rotate-through-windows/7388)
**Author:** [@dfarnes](https://forum.inductiveautomation.com/u/dfarnes)\ **Replies:** 8\ **Last updated:** [August 5, 2019, 3:24pm UTC](https://forum.inductiveautomation.com/t/auto-rotate-through-windows/7388 "2019-08-05T15:24:41Z")
Greetings All, I'm working on an existing project that will auto-rotate through several screens on a big screen TV. Below is the existing script, however it throws an "uncaught exception" error. I would appreciate any he… --- ## [\[BUG-14638\] ManagedTagProvider.shutdown method does not seem to work](https://forum.inductiveautomation.com/t/bug-14638-managedtagprovider-shutdown-method-does-not-seem-to-work/27107)
**Author:** [@Yogini\_Marathe](https://forum.inductiveautomation.com/u/Yogini_Marathe)\ **Replies:** 1\ **Last updated:** [August 5, 2019, 2:04pm UTC](https://forum.inductiveautomation.com/t/bug-14638-managedtagprovider-shutdown-method-does-not-seem-to-work/27107 "2019-08-05T14:04:19Z")
I am using ManagedTagProvider to create custom Tag provider as below from the module : ProviderConfiguration config = new ProviderConfiguration(\_providerName) .setAllowTagCustomization(true) .setPersistTags(fa… --- ## [Ignition Pie Chart](https://forum.inductiveautomation.com/t/ignition-pie-chart/27157)
**Author:** [@ammermanbrittanyf](https://forum.inductiveautomation.com/u/ammermanbrittanyf)\ **Replies:** 3\ **Last updated:** [August 5, 2019, 1:07pm UTC](https://forum.inductiveautomation.com/t/ignition-pie-chart/27157 "2019-08-05T13:07:55Z")
Hello. I am looking to use a pie chart for a visual analysis, however, I can't figure out how to get it to run. I was hoping to run a simply query like below: SELECT COUNT(VLAN) FROM FA\_ECA\_MASTER or SELECT VLAN FR… --- ## [Crash report on Ignition Edge on Moxa device](https://forum.inductiveautomation.com/t/crash-report-on-ignition-edge-on-moxa-device/26908)
**Author:** [@lorenzo.milesi](https://forum.inductiveautomation.com/u/lorenzo.milesi)\ **Replies:** 5\ **Last updated:** [August 5, 2019, 12:11pm UTC](https://forum.inductiveautomation.com/t/crash-report-on-ignition-edge-on-moxa-device/26908 "2019-08-05T12:11:12Z")
Hi. We’re doing some tests with Ignition 7.9.12 on Moxa devices. Unfortunately we’re occasionally noticing web interface crashes. It seems to happen more often when there are errors (like when the device is disconnecte… --- ## [Report Pie chart script option](https://forum.inductiveautomation.com/t/report-pie-chart-script-option/27144)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 1\ **Last updated:** [August 5, 2019, 11:59am UTC](https://forum.inductiveautomation.com/t/report-pie-chart-script-option/27144 "2019-08-05T11:59:16Z")
The Report Pie chart component has no scripting option and I need to scale(multiply value) my Tag Calculation query before passing to Pie chart. How can I do it? --- ## [Raspberry Pi OPC-UA Server](https://forum.inductiveautomation.com/t/raspberry-pi-opc-ua-server/9290)
**Author:** [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Replies:** 35\ **Last updated:** [March 13, 2018, 11:43am UTC](https://forum.inductiveautomation.com/t/raspberry-pi-opc-ua-server/9290 "2018-03-13T11:43:22Z")
I built a very simple OPC-UA server that exposes the Raspberry Pi GPIO this afternoon... thought some of you might get a kick out of it. It's just for the GPIO - there's no free PLC drivers or anything like that, so don'… --- ## [\[FEATURE\] Alarms Timestamp](https://forum.inductiveautomation.com/t/feature-alarms-timestamp/27148)
**Author:** [@andrea.morando](https://forum.inductiveautomation.com/u/andrea.morando)\ **Replies:** 0\ **Last updated:** [August 5, 2019, 8:10am UTC](https://forum.inductiveautomation.com/t/feature-alarms-timestamp/27148 "2019-08-05T08:10:50Z")
Dear all, Just a curiosity: why the timestamp in the Alarms DB is in local time and not in UTC, while the Historical DB is in UTC? It would be nice to have the UTC timestamp everywhere. Thank you so much, Andrea --- ## [Disable Edge License Through Scripting](https://forum.inductiveautomation.com/t/disable-edge-license-through-scripting/27143)
**Author:** [@wazzucoug763](https://forum.inductiveautomation.com/u/wazzucoug763)\ **Replies:** 0\ **Last updated:** [August 4, 2019, 3:19pm UTC](https://forum.inductiveautomation.com/t/disable-edge-license-through-scripting/27143 "2019-08-04T15:19:52Z")
I am looking at providing an edge device on a rental basis to a customer and then host his application in the cloud. They are a small customer with minimal IT support and are looking for a means of getting some specific… --- ## [Return data from Table in Perspective from user click](https://forum.inductiveautomation.com/t/return-data-from-table-in-perspective-from-user-click/27129)
**Author:** [@David.Bell](https://forum.inductiveautomation.com/u/David.Bell)\ **Replies:** 2\ **Last updated:** [August 3, 2019, 11:50am UTC](https://forum.inductiveautomation.com/t/return-data-from-table-in-perspective-from-user-click/27129 "2019-08-03T11:50:33Z")
Hello, I am trying to collect the data from a row that the user clicks on in Perspective (Ignition v 8.0.2). When a user clicks on a row of the table, I want to be able to use the values from each column in an SQL quer… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1483) [Next page](https://forum.inductiveautomation.com/latest.md?page=1485)