# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1483 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1484 --- ## [SQL query working in Named Queries, not as a binding](https://forum.inductiveautomation.com/t/sql-query-working-in-named-queries-not-as-a-binding/27217)
**Author:** [@kai.brudevoll86](https://forum.inductiveautomation.com/u/kai.brudevoll86)\ **Replies:** 4\ **Last updated:** [August 8, 2019, 12:06pm UTC](https://forum.inductiveautomation.com/t/sql-query-working-in-named-queries-not-as-a-binding/27217 "2019-08-08T12:06:25Z")
Dear Sirs I’m trying to read all data from a table. I want to be able to select the table from a different component, by changing a parameter I have made the following query: SELECT {analyse}.\* FROM {analyse} This w… --- ## [How to see the OPCUA connection with wireshark](https://forum.inductiveautomation.com/t/how-to-see-the-opcua-connection-with-wireshark/5686)
**Author:** [@afasika](https://forum.inductiveautomation.com/u/afasika)\ **Replies:** 12\ **Last updated:** [January 17, 2013, 8:59pm UTC](https://forum.inductiveautomation.com/t/how-to-see-the-opcua-connection-with-wireshark/5686 "2013-01-17T20:59:41Z")
Hi everyone, I am trying to monitor the OPC UA connection between Ignition and client with wireshark, i set wireshark to check ports 4096 and 8088 but i am only seeing TCP/UDP communications :frowning: , i am trying to… --- ## [Blocking progress bar](https://forum.inductiveautomation.com/t/blocking-progress-bar/27200)
**Author:** [@waldner](https://forum.inductiveautomation.com/u/waldner)\ **Replies:** 8\ **Last updated:** [August 8, 2019, 6:37am UTC](https://forum.inductiveautomation.com/t/blocking-progress-bar/27200 "2019-08-08T06:37:21Z")
I understand the use of invokeAsynchronous()/invokeLater() to display some sort of progress to the user during a long running operation but without locking up the GUI. The fact here is, in my case I DO want the GUI to r… --- ## [\[BUG-14268\] Comment in query causes "index is out of range" error](https://forum.inductiveautomation.com/t/bug-14268-comment-in-query-causes-index-is-out-of-range-error/26009)
**Author:** [@md.szyman](https://forum.inductiveautomation.com/u/md.szyman)\ **Replies:** 20\ **Last updated:** [August 7, 2019, 11:33pm UTC](https://forum.inductiveautomation.com/t/bug-14268-comment-in-query-causes-index-is-out-of-range-error/26009 "2019-08-07T23:33:55Z")
I was trying to comment out a line in a query to try something different, and found that commenting this line causes an "index is out of range" error. Here is the query that causes the error: --SELECT TOP(:limit\*(SELECT… --- ## [Ignition Perspective Event Driven Query Tag](https://forum.inductiveautomation.com/t/ignition-perspective-event-driven-query-tag/27229)
**Author:** [@David.Bell](https://forum.inductiveautomation.com/u/David.Bell)\ **Replies:** 9\ **Last updated:** [August 7, 2019, 9:41pm UTC](https://forum.inductiveautomation.com/t/ignition-perspective-event-driven-query-tag/27229 "2019-08-07T21:41:06Z")
Hello, I cannot find an example of how to tie a mouse click in Perspective to an EVENT DRIVEN query tag. Can you link me to an example for this? David --- ## [OptimizedDataSet cannot be cast to BasicDataset?](https://forum.inductiveautomation.com/t/optimizeddataset-cannot-be-cast-to-basicdataset/26206)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 3\ **Last updated:** [August 7, 2019, 8:10pm UTC](https://forum.inductiveautomation.com/t/optimizeddataset-cannot-be-cast-to-basicdataset/26206 "2019-08-07T20:10:07Z")
I have a client scope script function which invoke with RPC a gateway calculation which return a BasicDataset. It was working fine in 7.9.10. Now I have the following error : java.lang.ClassCastException: com.inductive… --- ## [Binding through scripting](https://forum.inductiveautomation.com/t/binding-through-scripting/27206)
**Author:** [@jramirez3](https://forum.inductiveautomation.com/u/jramirez3)\ **Replies:** 6\ **Last updated:** [August 7, 2019, 7:55pm UTC](https://forum.inductiveautomation.com/t/binding-through-scripting/27206 "2019-08-07T19:55:43Z")
I have a flex repeater with buttons in it. When clicking on a button i need its action to write to a parameter on the window the flex repeater is in. I understand i can do a binding on the parameters on the repeater with… --- ## [\[BUG-13224 13940\] Booleans displaying as True for json table data](https://forum.inductiveautomation.com/t/bug-13224-13940-booleans-displaying-as-true-for-json-table-data/23229)
**Author:** [@SMcIntosh](https://forum.inductiveautomation.com/u/SMcIntosh)\ **Replies:** 6\ **Last updated:** [August 7, 2019, 6:48pm UTC](https://forum.inductiveautomation.com/t/bug-13224-13940-booleans-displaying-as-true-for-json-table-data/23229 "2019-08-07T18:48:10Z")
I am having some trouble with table booleans. They display as True in Perspective tables, regardless of whether the value is actually True or False. This seems to be happening in tables with a json formatted data paramet… --- ## [Getting TagPath from Graphic Display Object](https://forum.inductiveautomation.com/t/getting-tagpath-from-graphic-display-object/9676)
**Author:** [@ChrisGray](https://forum.inductiveautomation.com/u/ChrisGray)\ **Replies:** 6\ **Last updated:** [August 2, 2019, 7:04pm UTC](https://forum.inductiveautomation.com/t/getting-tagpath-from-graphic-display-object/9676 "2019-08-02T19:04:48Z")
Is there a scripting method to get the Tag Path from a elementary graphic display object? Example Graphic Object component: Numeric Label: Value attribute is say set to some tag with pathname "myPath\\myTag" \<--Tag Pat… --- ## [Ignition Edge on Windows IoT Enterprise?](https://forum.inductiveautomation.com/t/ignition-edge-on-windows-iot-enterprise/14188)
**Author:** [@pphillips](https://forum.inductiveautomation.com/u/pphillips)\ **Replies:** 21\ **Last updated:** [August 7, 2019, 6:33pm UTC](https://forum.inductiveautomation.com/t/ignition-edge-on-windows-iot-enterprise/14188 "2019-08-07T18:33:53Z")
I'd be interested to know if it's possible to run ignition Edge on Windows IoT? I haven't been able to determine if an appropriate Java SE will run on it. I've pretty much only used Linux with Ignition, but the new Allen… --- ## [How to add line breaks in an emails?](https://forum.inductiveautomation.com/t/how-to-add-line-breaks-in-an-emails/27238)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 3\ **Last updated:** [August 7, 2019, 5:37pm UTC](https://forum.inductiveautomation.com/t/how-to-add-line-breaks-in-an-emails/27238 "2019-08-07T17:37:29Z")
I have a window with a text area that is prefilled in and isn’t changed by the user. I have tried adding line breaks to the preset text with both \\n\\n python style and by using \Sentence one.\\ style, however… --- ## [\[Feature-10734\] In Perspective Styles, Opacity is only a slider](https://forum.inductiveautomation.com/t/feature-10734-in-perspective-styles-opacity-is-only-a-slider/27239)
**Author:** [@md.szyman](https://forum.inductiveautomation.com/u/md.szyman)\ **Replies:** 1\ **Last updated:** [August 7, 2019, 4:48pm UTC](https://forum.inductiveautomation.com/t/feature-10734-in-perspective-styles-opacity-is-only-a-slider/27239 "2019-08-07T16:48:15Z")
In Perspective styles, it seems that Opacity cannot be set to a number, only with a slider that has no value indication at all. It would be much more useful to actually have a number to set. --- ## [Perspective dropdown schema](https://forum.inductiveautomation.com/t/perspective-dropdown-schema/26027)
**Author:** [@tyrel.parker](https://forum.inductiveautomation.com/u/tyrel.parker)\ **Replies:** 6\ **Last updated:** [August 7, 2019, 4:16pm UTC](https://forum.inductiveautomation.com/t/perspective-dropdown-schema/26027 "2019-08-07T16:16:39Z")
I have a dropdown menu that is utilizing a query to populate what should be in the dropdown list based on the user logged in. The dropdown properties make it seem like I could have a third, fourth, fifth column that woul… --- ## [Seeing the transaction group command that is being sent to SQL in the gateway logs](https://forum.inductiveautomation.com/t/seeing-the-transaction-group-command-that-is-being-sent-to-sql-in-the-gateway-logs/27234)
**Author:** [@tyrel.parker](https://forum.inductiveautomation.com/u/tyrel.parker)\ **Replies:** 0\ **Last updated:** [August 7, 2019, 3:07pm UTC](https://forum.inductiveautomation.com/t/seeing-the-transaction-group-command-that-is-being-sent-to-sql-in-the-gateway-logs/27234 "2019-08-07T15:07:15Z")
Does anyone know if there is a way to see the actual query that a transaction group submits? I keep randomly getting a unique key constraint error from a transaction group that is only triggering once per the change of a… --- ## [Pie Chart Refresh](https://forum.inductiveautomation.com/t/pie-chart-refresh/27236)
**Author:** [@ammermanbrittanyf](https://forum.inductiveautomation.com/u/ammermanbrittanyf)\ **Replies:** 3\ **Last updated:** [August 7, 2019, 3:46pm UTC](https://forum.inductiveautomation.com/t/pie-chart-refresh/27236 "2019-08-07T15:46:13Z")
hello. I am trying to update a pie chart as the data in the database table changes and updates. I am currently getting this error: 10:20:54.057 \[MainThread\] WARN com.inductiveautomation.factorypmi.application.components… --- ## [Using BrowseFilter in browseAsync (v8 API)](https://forum.inductiveautomation.com/t/using-browsefilter-in-browseasync-v8-api/27235)
**Author:** [@fyousuf](https://forum.inductiveautomation.com/u/fyousuf)\ **Replies:** 1\ **Last updated:** [August 7, 2019, 3:29pm UTC](https://forum.inductiveautomation.com/t/using-browsefilter-in-browseasync-v8-api/27235 "2019-08-07T15:29:28Z")
I’m attempting to find the tagpaths inside the gateway’s default tagprovider. Using: CompletableFuture\\> node=context.getTagManager().getTagProvider("default").browseAsync(TagPath,BrowseFilter);… --- ## [NAS Best Implementation Practices](https://forum.inductiveautomation.com/t/nas-best-implementation-practices/27209)
**Author:** [@rcortes](https://forum.inductiveautomation.com/u/rcortes)\ **Replies:** 3\ **Last updated:** [August 7, 2019, 3:29pm UTC](https://forum.inductiveautomation.com/t/nas-best-implementation-practices/27209 "2019-08-07T15:29:07Z")
Hello there! I would like to move a running Ignition db (PostgreSQL) to a RAID configuration in a NAS to get a more fault tolerant system, but I didn’t find any documentation about this. Do you have any recommendations o… --- ## [Ignition Perspective need to find character in text](https://forum.inductiveautomation.com/t/ignition-perspective-need-to-find-character-in-text/27228)
**Author:** [@David.Bell](https://forum.inductiveautomation.com/u/David.Bell)\ **Replies:** 5\ **Last updated:** [August 7, 2019, 3:11pm UTC](https://forum.inductiveautomation.com/t/ignition-perspective-need-to-find-character-in-text/27228 "2019-08-07T15:11:50Z")
Hello, I searched Ignition and internet and cannot see usable find string inside of text field. I need to do a CHARINDEX() (from SQL) or a FIND() (from EXCEL) to find a “-” in a text field. Thanks --- ## [Mobile Client MAC Address](https://forum.inductiveautomation.com/t/mobile-client-mac-address/23037)
**Author:** [@rrowe](https://forum.inductiveautomation.com/u/rrowe)\ **Replies:** 11\ **Last updated:** [August 7, 2019, 2:35pm UTC](https://forum.inductiveautomation.com/t/mobile-client-mac-address/23037 "2019-08-07T14:35:38Z")
I know that I can get the client IP Address in a tag, but I would like to see if I can do the same for a Client’s MAC address. Anyone know of any ways of obtaining this perhaps via scripting with some python modules? --- ## [All my tags are showing bad](https://forum.inductiveautomation.com/t/all-my-tags-are-showing-bad/27225)
**Author:** [@sjanes9](https://forum.inductiveautomation.com/u/sjanes9)\ **Replies:** 4\ **Last updated:** [August 7, 2019, 1:40pm UTC](https://forum.inductiveautomation.com/t/all-my-tags-are-showing-bad/27225 "2019-08-07T13:40:43Z")
I am running Ignition version 8.0.2. I have connected a Compactlogix Revision 20 PLC that I can successfully browse to in my vision client. I can see the tags from the plc. But when I bring them into my client. It shows … --- ## [Perspective: Dynamically resize window based on device (i.e tablet or phone)](https://forum.inductiveautomation.com/t/perspective-dynamically-resize-window-based-on-device-i-e-tablet-or-phone/27177)
**Author:** [@David.Bell](https://forum.inductiveautomation.com/u/David.Bell)\ **Replies:** 7\ **Last updated:** [August 7, 2019, 1:19pm UTC](https://forum.inductiveautomation.com/t/perspective-dynamically-resize-window-based-on-device-i-e-tablet-or-phone/27177 "2019-08-07T13:19:08Z")
Hello, is it possible to determine screen width/height and dynamically adjust the view in Perspective? Thanks, David --- ## [Tag Calculation query vs Tag History Query](https://forum.inductiveautomation.com/t/tag-calculation-query-vs-tag-history-query/27220)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 0\ **Last updated:** [August 7, 2019, 8:31am UTC](https://forum.inductiveautomation.com/t/tag-calculation-query-vs-tag-history-query/27220 "2019-08-07T08:31:28Z")
Hello I set a Tag History Query to Range aggregation mode with sample size = 1, so I can get a single valve of my tag(Tmax-Tmin) I also set Tag Calculation Query to Range aggregation mode with the sample time range of … --- ## [How to read memory register from a PLC?](https://forum.inductiveautomation.com/t/how-to-read-memory-register-from-a-plc/27105)
**Author:** [@miculacristianradu](https://forum.inductiveautomation.com/u/miculacristianradu)\ **Replies:** 7\ **Last updated:** [August 7, 2019, 7:08am UTC](https://forum.inductiveautomation.com/t/how-to-read-memory-register-from-a-plc/27105 "2019-08-07T07:08:14Z")
Hi guys, Does anyone have an idea on how to read the memory register of an PLC? There is a special program that can export these registers? I want to create these register in Ignition after. Thank you in advance! --- ## [Perspective Table: Render boolean and analog values](https://forum.inductiveautomation.com/t/perspective-table-render-boolean-and-analog-values/27215)
**Author:** [@wade.dunham](https://forum.inductiveautomation.com/u/wade.dunham)\ **Replies:** 0\ **Last updated:** [August 7, 2019, 2:28am UTC](https://forum.inductiveautomation.com/t/perspective-table-render-boolean-and-analog-values/27215 "2019-08-07T02:28:31Z")
I’m having a bit of trouble getting a table to render differently for each row. The auto rendering appears to render the entire column based on the data type of the first row only. I’m using a script to generate the … --- ## [External application gets retained in process manager after closing](https://forum.inductiveautomation.com/t/external-application-gets-retained-in-process-manager-after-closing/27213)
**Author:** [@juuuuunjie07](https://forum.inductiveautomation.com/u/juuuuunjie07)\ **Replies:** 0\ **Last updated:** [August 7, 2019, 12:47am UTC](https://forum.inductiveautomation.com/t/external-application-gets-retained-in-process-manager-after-closing/27213 "2019-08-07T00:47:49Z")
I am using system.util.execute\[(path to app.exe)\] to call the external app. However, after closing the application and attempting to re-launch it via ignition, the error message showed up and from the task manager windo… --- ## [How to have fixed axes on a bar chart in a report](https://forum.inductiveautomation.com/t/how-to-have-fixed-axes-on-a-bar-chart-in-a-report/27207)
**Author:** [@marianjel\_11](https://forum.inductiveautomation.com/u/marianjel_11)\ **Replies:** 1\ **Last updated:** [August 6, 2019, 8:53pm UTC](https://forum.inductiveautomation.com/t/how-to-have-fixed-axes-on-a-bar-chart-in-a-report/27207 "2019-08-06T20:53:49Z")
I have a pareto graph in which I need the ‘y’ axis to be fixed at 24 and I don’t know how to do the script --- ## [PDF Viewer & Event Handlers](https://forum.inductiveautomation.com/t/pdf-viewer-event-handlers/26795)
**Author:** [@FLi](https://forum.inductiveautomation.com/u/FLi)\ **Replies:** 7\ **Last updated:** [August 6, 2019, 8:05pm UTC](https://forum.inductiveautomation.com/t/pdf-viewer-event-handlers/26795 "2019-08-06T20:05:30Z")
Hello everyone, I want to retrieve the active PDF page of the PDF Viewer component. I’ve already done this inside a script of a button: target = event.source.parent.getComponent('PDF Viewer') swingController = target.g… --- ## [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\