# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=896 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 897 --- ## [How to make a perspective table text column not wrap](https://forum.inductiveautomation.com/t/how-to-make-a-perspective-table-text-column-not-wrap/55674)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 4\ **Last updated:** [February 2, 2022, 8:08pm UTC](https://forum.inductiveautomation.com/t/how-to-make-a-perspective-table-text-column-not-wrap/55674 "2022-02-02T20:08:05Z")
I have a perspective table populated by a named query on the data binding. The last column is a pretty large xml-ish text string that makes the whole column much taller when really I would rather it just go to the right… --- ## [Gateway Timer script stopped](https://forum.inductiveautomation.com/t/gateway-timer-script-stopped/18729)
**Author:** [@oisin.gribben](https://forum.inductiveautomation.com/u/oisin.gribben)\ **Replies:** 6\ **Last updated:** [February 2, 2022, 7:44pm UTC](https://forum.inductiveautomation.com/t/gateway-timer-script-stopped/18729 "2022-02-02T19:44:47Z")
Hi, I have a few gateway timer scripts that run every few seconds. After around 10-15 minutes of running, some scripts stop executing. When restarted they continue as usual until they freeze again. The 2 scripts affe… --- ## [Indirect Property Bindings](https://forum.inductiveautomation.com/t/indirect-property-bindings/55665)
**Author:** [@agriner](https://forum.inductiveautomation.com/u/agriner)\ **Replies:** 2\ **Last updated:** [February 2, 2022, 6:55pm UTC](https://forum.inductiveautomation.com/t/indirect-property-bindings/55665 "2022-02-02T18:55:25Z")
I have a docked view that passes sample information between itself and the main view. I have it set to a bi-directional property view (which works perfectly for one sample). I need a way to dynamically set the sample nu… --- ## [JWT Library on Python for API](https://forum.inductiveautomation.com/t/jwt-library-on-python-for-api/36845)
**Author:** [@Rendi.Yohanes](https://forum.inductiveautomation.com/u/Rendi.Yohanes)\ **Replies:** 2\ **Last updated:** [February 2, 2022, 6:53pm UTC](https://forum.inductiveautomation.com/t/jwt-library-on-python-for-api/36845 "2022-02-02T18:53:54Z")
Hi all, I need a little bit of help on JWT Library on Python for API. First of all, please pardon me if I use some wrong terminology, as my background is on PLC/SCADA and I’m relatively new to Python and scripting in ge… --- ## [Connection error to Maria DB](https://forum.inductiveautomation.com/t/connection-error-to-maria-db/55673)
**Author:** [@Alfred\_Thayer](https://forum.inductiveautomation.com/u/Alfred_Thayer)\ **Replies:** 1\ **Last updated:** [February 2, 2022, 6:28pm UTC](https://forum.inductiveautomation.com/t/connection-error-to-maria-db/55673 "2022-02-02T18:28:18Z")
I am trying to connect to a Maria DB that resides on another system. Below is the error that I receive via the Gateway. This is my current issue. java.sql.SQLException: Cannot create PoolableConnectionFactory (Host ‘p… --- ## [How to remove a variable from the database](https://forum.inductiveautomation.com/t/how-to-remove-a-variable-from-the-database/55671)
**Author:** [@patricio.rojas.bolom](https://forum.inductiveautomation.com/u/patricio.rojas.bolom)\ **Replies:** 3\ **Last updated:** [February 2, 2022, 6:11pm UTC](https://forum.inductiveautomation.com/t/how-to-remove-a-variable-from-the-database/55671 "2022-02-02T18:11:25Z")
I had a variable which history, this variable was removed from the history and the variable was removed. The problem is that I don’t know how to delete it from the database (only that variable). The reason is that it ke… --- ## [Database not working after upgrading to 8.1 from 7.9](https://forum.inductiveautomation.com/t/database-not-working-after-upgrading-to-8-1-from-7-9/55450)
**Author:** [@christopher.raphael](https://forum.inductiveautomation.com/u/christopher.raphael)\ **Replies:** 26\ **Last updated:** [February 2, 2022, 5:40pm UTC](https://forum.inductiveautomation.com/t/database-not-working-after-upgrading-to-8-1-from-7-9/55450 "2022-02-02T17:40:41Z")
I am using the same connections for my database as before but 8.1 won’t connect. Here is the error report. I tried creating a JTDS as a connection (saw this in the forum) but it did not help. All my settings are exactly … --- ## [Is there a feature to make a Status Chart scroll?](https://forum.inductiveautomation.com/t/is-there-a-feature-to-make-a-status-chart-scroll/55657)
**Author:** [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Replies:** 4\ **Last updated:** [February 2, 2022, 5:20pm UTC](https://forum.inductiveautomation.com/t/is-there-a-feature-to-make-a-status-chart-scroll/55657 "2022-02-02T17:20:46Z")
Good morning, I have a Status Chart with 100 series lines I want to add to it. The font gets extremely tiny after 25 series are added though. Is there a built-in feature or another way to have the Status Chart scroll th… --- ## [\[Bug-5505\] Find/Replace does not skip to next item consistently](https://forum.inductiveautomation.com/t/bug-5505-find-replace-does-not-skip-to-next-item-consistently/55654)
**Author:** [@johannes.bo](https://forum.inductiveautomation.com/u/johannes.bo)\ **Replies:** 1\ **Last updated:** [February 2, 2022, 4:54pm UTC](https://forum.inductiveautomation.com/t/bug-5505-find-replace-does-not-skip-to-next-item-consistently/55654 "2022-02-02T16:54:14Z")
When using the \[Replace\] button the next element in the “Results” list usually gets selected. -However this only works 1 time / if the Results list is in focus. pick your choice. -Next time I press \[Replace\], the next … --- ## [How to see who last saved a project?](https://forum.inductiveautomation.com/t/how-to-see-who-last-saved-a-project/55662)
**Author:** [@iceberg](https://forum.inductiveautomation.com/u/iceberg)\ **Replies:** 5\ **Last updated:** [February 2, 2022, 4:30pm UTC](https://forum.inductiveautomation.com/t/how-to-see-who-last-saved-a-project/55662 "2022-02-02T16:30:28Z")
Is there a way to see who last saved a project? I can’t find this in the literature anywhere. --- ## [Report StartDate and EndDate Parameters](https://forum.inductiveautomation.com/t/report-startdate-and-enddate-parameters/55658)
**Author:** [@batuhan.parlakay](https://forum.inductiveautomation.com/u/batuhan.parlakay)\ **Replies:** 3\ **Last updated:** [February 2, 2022, 3:55pm UTC](https://forum.inductiveautomation.com/t/report-startdate-and-enddate-parameters/55658 "2022-02-02T15:55:22Z")
hello, I’m going to ask about the start and end date parameters in the reports module. I write this for report startdate parameter for the beginning of each month and it works. dateFormat(dateArithmetic(now(0),0,‘days… --- ## [Remove dashed border around File Upload](https://forum.inductiveautomation.com/t/remove-dashed-border-around-file-upload/55652)
**Author:** [@jburgess](https://forum.inductiveautomation.com/u/jburgess)\ **Replies:** 5\ **Last updated:** [February 2, 2022, 3:47pm UTC](https://forum.inductiveautomation.com/t/remove-dashed-border-around-file-upload/55652 "2022-02-02T15:47:37Z")
The File Upload component in our Perspective app has a gray dashed border around it. See below. How do I turn this off? The Border and Outline properties in the “style” editor control lines inside this dashed box, and… --- ## [\[Feature\] Add Tag Provider column to alarm status/journal table](https://forum.inductiveautomation.com/t/feature-add-tag-provider-column-to-alarm-status-journal-table/55659)
**Author:** [@Cory.grube](https://forum.inductiveautomation.com/u/Cory.grube)\ **Replies:** 0\ **Last updated:** [February 2, 2022, 2:38pm UTC](https://forum.inductiveautomation.com/t/feature-add-tag-provider-column-to-alarm-status-journal-table/55659 "2022-02-02T14:38:40Z")
v8.1.13 Vision/Perspective One of my projects uses tag providers to distinguish different utility buildings across a campus. Any building can view their own alarms, another building’s alarms, or campus level alarms (all… --- ## [Two decimals sql to table on the perspective page](https://forum.inductiveautomation.com/t/two-decimals-sql-to-table-on-the-perspective-page/55615)
**Author:** [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Replies:** 4\ **Last updated:** [February 2, 2022, 2:09pm UTC](https://forum.inductiveautomation.com/t/two-decimals-sql-to-table-on-the-perspective-page/55615 "2022-02-02T14:09:21Z")
cast(coalesce(100.0\*(Rejects)/nullif(attemped,0),0)as numeric(38,2)) as '% Rejects/Attempted' So I both used a cast and tried to make sure I used a float. I also went to format the number as 4 decimals, and then delet… --- ## [JProgressBar.foreground doesn't work like in Ignition 7](https://forum.inductiveautomation.com/t/jprogressbar-foreground-doesnt-work-like-in-ignition-7/30874)
**Author:** [@informatica](https://forum.inductiveautomation.com/u/informatica)\ **Replies:** 13\ **Last updated:** [February 1, 2022, 11:09pm UTC](https://forum.inductiveautomation.com/t/jprogressbar-foreground-doesnt-work-like-in-ignition-7/30874 "2022-02-01T23:09:41Z")
Good afternoon. In Ignition 7.9.9, in a “PowerTable”, you can use “JProgressBar” class to draw a progress bar in a cell. The “foreground” property is the color of the progress bar: Ignition 7 (Power Table): Ign… --- ## [Import Socket error](https://forum.inductiveautomation.com/t/import-socket-error/29353)
**Author:** [@oisin.gribben](https://forum.inductiveautomation.com/u/oisin.gribben)\ **Replies:** 7\ **Last updated:** [February 1, 2022, 11:08pm UTC](https://forum.inductiveautomation.com/t/import-socket-error/29353 "2022-02-01T23:08:58Z")
Hi, I keep getting this error when running my FTP script. ImportError: Error loading module FTP: Traceback(most recent call last): File "C:\\Program Files\\Inductive Automation\\Ignition\\user-lib\\pylib\\ftplib.py", line … --- ## [Expose User Script Functions in Auto Complete](https://forum.inductiveautomation.com/t/expose-user-script-functions-in-auto-complete/55621)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 5\ **Last updated:** [February 1, 2022, 9:02pm UTC](https://forum.inductiveautomation.com/t/expose-user-script-functions-in-auto-complete/55621 "2022-02-01T21:02:27Z")
I was thinking that it would be nice to allow user script packages/functions to be added to auto complete. Is this something that would have to be a custom module? I also wonder if you could write a script that could l… --- ## [Time Series Chart X-Trace show second and milliseconds](https://forum.inductiveautomation.com/t/time-series-chart-x-trace-show-second-and-milliseconds/53904)
**Author:** [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\ **Replies:** 1\ **Last updated:** [February 1, 2022, 8:52pm UTC](https://forum.inductiveautomation.com/t/time-series-chart-x-trace-show-second-and-milliseconds/53904 "2022-02-01T20:52:34Z")
Hello, Is it possible to show the time with seconds and even millliseconds in the time series chart in perspective? Thanks. --- ## [Button 3D effect](https://forum.inductiveautomation.com/t/button-3d-effect/54644)
**Author:** [@Edgar\_Rodriguez](https://forum.inductiveautomation.com/u/Edgar_Rodriguez)\ **Replies:** 1\ **Last updated:** [February 1, 2022, 8:34pm UTC](https://forum.inductiveautomation.com/t/button-3d-effect/54644 "2022-02-01T20:34:39Z")
Where can I find an example of the scripting .backgorund3D to give a 3d appearance to buttons? --- ## [Set Perspective table selection from script/code](https://forum.inductiveautomation.com/t/set-perspective-table-selection-from-script-code/55618)
**Author:** [@Ivar](https://forum.inductiveautomation.com/u/Ivar)\ **Replies:** 3\ **Last updated:** [February 1, 2022, 8:27pm UTC](https://forum.inductiveautomation.com/t/set-perspective-table-selection-from-script-code/55618 "2022-02-01T20:27:46Z")
Let me start by mentioning that I searched through the forum before posting this… I can’t figure out how to set the selected column on a Perspective table in such a way that the cell is highlighted in the same way that … --- ## [List Tags in a Tag Group](https://forum.inductiveautomation.com/t/list-tags-in-a-tag-group/54674)
**Author:** [@eric.peery](https://forum.inductiveautomation.com/u/eric.peery)\ **Replies:** 1\ **Last updated:** [February 1, 2022, 8:26pm UTC](https://forum.inductiveautomation.com/t/list-tags-in-a-tag-group/54674 "2022-02-01T20:26:26Z")
Is there any way to list the tags that are currently part of a given Tag Group? i.e. If I make a change to the Rate for a given Tag Group, which tags will I be affecting? --- ## [Easy chart that shows names instead of numbers in Y Axis](https://forum.inductiveautomation.com/t/easy-chart-that-shows-names-instead-of-numbers-in-y-axis/55619)
**Author:** [@PRAMANJ](https://forum.inductiveautomation.com/u/PRAMANJ)\ **Replies:** 2\ **Last updated:** [February 1, 2022, 5:20pm UTC](https://forum.inductiveautomation.com/t/easy-chart-that-shows-names-instead-of-numbers-in-y-axis/55619 "2022-02-01T17:20:40Z")
I have an easy chart component in vision that shows an integer tag say status of a multi-state button (say 0,1,2 etc). I want to show names of state like on,off,trip, etc.. instead of numbers on Y Axis. How to achieve t… --- ## [Not able to lauch anything after importing gateway 8.0.10 from Linux to windows server fails](https://forum.inductiveautomation.com/t/not-able-to-lauch-anything-after-importing-gateway-8-0-10-from-linux-to-windows-server-fails/55542)
**Author:** [@hewking32](https://forum.inductiveautomation.com/u/hewking32)\ **Replies:** 2\ **Last updated:** [February 1, 2022, 5:06pm UTC](https://forum.inductiveautomation.com/t/not-able-to-lauch-anything-after-importing-gateway-8-0-10-from-linux-to-windows-server-fails/55542 "2022-02-01T17:06:23Z")
hi All I am looking again for ideas how to further troubleshoot serious issue which i had several month ago and i am looking into this again to solve it properly. This issue was bypassed by creating fresh gateway and ma… --- ## [Invalid Key name in tables](https://forum.inductiveautomation.com/t/invalid-key-name-in-tables/55609)
**Author:** [@Faiz\_Mohamed](https://forum.inductiveautomation.com/u/Faiz_Mohamed)\ **Replies:** 2\ **Last updated:** [February 1, 2022, 4:48pm UTC](https://forum.inductiveautomation.com/t/invalid-key-name-in-tables/55609 "2022-02-01T16:48:39Z")
I’m trying to make a table on perspective, but when I enter the key for the data (translating to the column header on the table), it will not let me enter spaces or special characters such as %, (, etc. and tells me that… --- ## [Java Heap Space Error in report viewer](https://forum.inductiveautomation.com/t/java-heap-space-error-in-report-viewer/15449)
**Author:** [@william.maclane](https://forum.inductiveautomation.com/u/william.maclane)\ **Replies:** 3\ **Last updated:** [February 1, 2022, 3:31pm UTC](https://forum.inductiveautomation.com/t/java-heap-space-error-in-report-viewer/15449 "2022-02-01T15:31:52Z")
I've been working on a report and had the report working and displaying 5 or 6 pages of data. I wanted to edit the design, but when I tried to link the report to the report viewer Ignition locked and did nothing. After … --- ## [Tag provider is not visible in "OPC Quick Client"](https://forum.inductiveautomation.com/t/tag-provider-is-not-visible-in-opc-quick-client/55592)
**Author:** [@Sanket](https://forum.inductiveautomation.com/u/Sanket)\ **Replies:** 6\ **Last updated:** [February 1, 2022, 3:17pm UTC](https://forum.inductiveautomation.com/t/tag-provider-is-not-visible-in-opc-quick-client/55592 "2022-02-01T15:17:35Z")
Hello All, With the same name conflict for OPC UA device connection and tag provider. Hence not able to access the tag provider in external OPC UA client. --- ## [Can Ignition run on Windows CE 5.0?](https://forum.inductiveautomation.com/t/can-ignition-run-on-windows-ce-5-0/55607)
**Author:** [@Sean\_Tesch](https://forum.inductiveautomation.com/u/Sean_Tesch)\ **Replies:** 2\ **Last updated:** [February 1, 2022, 2:53pm UTC](https://forum.inductiveautomation.com/t/can-ignition-run-on-windows-ce-5-0/55607 "2022-02-01T14:53:41Z")
Is it possible to run Ignition, namely an Ignition webpage, on a device running Windows CE 5.0? We’ve got a handheld scanning device we’re trying to open an Ignition webpage on, but the browser installed is its version … --- ## [Gateway Event Scripts File Location](https://forum.inductiveautomation.com/t/gateway-event-scripts-file-location/55559)
**Author:** [@besaliealprince](https://forum.inductiveautomation.com/u/besaliealprince)\ **Replies:** 6\ **Last updated:** [February 1, 2022, 2:32pm UTC](https://forum.inductiveautomation.com/t/gateway-event-scripts-file-location/55559 "2022-02-01T14:32:04Z")
Where in Windows OS File system does the gateway event script get stored ? Trying to use git version control on the scripts which I have under gateway events. What would be the best method to do this ? --- ## [Power Table add 2 columns value](https://forum.inductiveautomation.com/t/power-table-add-2-columns-value/55595)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 1\ **Last updated:** [February 1, 2022, 1:46pm UTC](https://forum.inductiveautomation.com/t/power-table-add-2-columns-value/55595 "2022-02-01T13:46:36Z")
tableComponent = event.source.parent.getComponent('Power Table') table = tableComponent.getTable() selectedRows = table.getSelectedRows() print selectedRows selectedColumns = table.getSelectedColumns() print selectedCol… --- ## [Perspective Alarm Status Display newest alarm index](https://forum.inductiveautomation.com/t/perspective-alarm-status-display-newest-alarm-index/55488)
**Author:** [@RC23](https://forum.inductiveautomation.com/u/RC23)\ **Replies:** 4\ **Last updated:** [February 1, 2022, 6:48am UTC](https://forum.inductiveautomation.com/t/perspective-alarm-status-display-newest-alarm-index/55488 "2022-02-01T06:48:44Z")
Hi there, I am wondering if there is a certain rule how Alarm Status Display items are indexed. At first, I thought index\[-1\] would give me the newest alarm in the list but I was wrong. Index\[0\] doesn’t give me the old… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=895) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=897)