# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=636 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 637 --- ## [Perspective XY bar chart talking to a Modbus device](https://forum.inductiveautomation.com/t/perspective-xy-bar-chart-talking-to-a-modbus-device/74591)
**Author:** [@dan\_mueller](https://forum.inductiveautomation.com/u/dan_mueller)\ **Replies:** 0\ **Last updated:** [June 5, 2023, 7:43pm UTC](https://forum.inductiveautomation.com/t/perspective-xy-bar-chart-talking-to-a-modbus-device/74591 "2023-06-05T19:43:37Z")
Is there a way to not show a zero value in a perspective xy bar chart. Value is zero instead of null. Tag is pointing to a modbus device --- ## [Scripting Perspective to add events for Equipment Schedule](https://forum.inductiveautomation.com/t/scripting-perspective-to-add-events-for-equipment-schedule/74511)
**Author:** [@Grace\_Tarler](https://forum.inductiveautomation.com/u/Grace_Tarler)\ **Replies:** 7\ **Last updated:** [June 5, 2023, 6:17pm UTC](https://forum.inductiveautomation.com/t/scripting-perspective-to-add-events-for-equipment-schedule/74511 "2023-06-05T18:17:42Z")
I am trying to use the equipment schedule in perspective for employees to see what they have done throughout the day for various jobs. I have two items right now one for their jobs and another for indirect chores. What I… --- ## [\[FEATURE-1570\] User lockout feature](https://forum.inductiveautomation.com/t/feature-1570-user-lockout-feature/30413)
**Author:** [@justin.brzozoski](https://forum.inductiveautomation.com/u/justin.brzozoski)\ **Replies:** 12\ **Last updated:** [June 5, 2023, 4:37pm UTC](https://forum.inductiveautomation.com/t/feature-1570-user-lockout-feature/30413 "2023-06-05T16:37:27Z")
We’re running Ignition 8.0.6. Users login to our Perspective projects through the built-in ID provider referencing back to a manual-mode user DB. One of our employees couldn’t login. He then asked an admin to reset his… --- ## [Banner DXM via modbus](https://forum.inductiveautomation.com/t/banner-dxm-via-modbus/74571)
**Author:** [@Thomas\_Salisbury](https://forum.inductiveautomation.com/u/Thomas_Salisbury)\ **Replies:** 2\ **Last updated:** [June 5, 2023, 4:18pm UTC](https://forum.inductiveautomation.com/t/banner-dxm-via-modbus/74571 "2023-06-05T16:18:51Z")
HI all again. I have a banner DXM100 I am storing on time for a digital input in a holding register. When trying to grab that data from the DXM via modbus, I can't seem to get them to match values, or I keep getting in… --- ## [setTime/getDate error](https://forum.inductiveautomation.com/t/settime-getdate-error/74438)
**Author:** [@lyhkch](https://forum.inductiveautomation.com/u/lyhkch)\ **Replies:** 12\ **Last updated:** [June 5, 2023, 4:05pm UTC](https://forum.inductiveautomation.com/t/settime-getdate-error/74438 "2023-06-05T16:05:37Z")
Hi, how to solve these error: setTime function expected a 'date' first argument, but got null getDate function expected a 'int' first argument, but got null I have check the tags scripts，like this "getDate({\[.\]START\_Y… --- ## [Change operator password during runtime](https://forum.inductiveautomation.com/t/change-operator-password-during-runtime/21267)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 6\ **Last updated:** [June 5, 2023, 3:43pm UTC](https://forum.inductiveautomation.com/t/change-operator-password-during-runtime/21267 "2023-06-05T15:43:39Z")
Hello In user management component there is option to change password for internal profile. I want this option in script so operator can change their password through HMI when they need. I can't find any system.securit… --- ## [Keystore/trustore file of certs loaded in supplemental folder](https://forum.inductiveautomation.com/t/keystore-trustore-file-of-certs-loaded-in-supplemental-folder/74433)
**Author:** [@derrickdvdsn](https://forum.inductiveautomation.com/u/derrickdvdsn)\ **Replies:** 8\ **Last updated:** [June 5, 2023, 2:31pm UTC](https://forum.inductiveautomation.com/t/keystore-trustore-file-of-certs-loaded-in-supplemental-folder/74433 "2023-06-05T14:31:22Z")
After placing certificates in "Ignition\\data\\certificates\\supplemental" in which keystore/truststore are they loaded to? I don't see them in Ignition\\lib\\runtime\\jre-win\\lib\\security\\cacerts nor do I see them in metro-k… --- ## [Import and use POI Java](https://forum.inductiveautomation.com/t/import-and-use-poi-java/20794)
**Author:** [@ciso9014](https://forum.inductiveautomation.com/u/ciso9014)\ **Replies:** 9\ **Last updated:** [June 5, 2023, 1:42pm UTC](https://forum.inductiveautomation.com/t/import-and-use-poi-java/20794 "2023-06-05T13:42:36Z")
hi, how can i import and use POI library to work with excel files ? --- ## [System.util.retarget() with JVM Arguments](https://forum.inductiveautomation.com/t/system-util-retarget-with-jvm-arguments/60231)
**Author:** [@zbinder](https://forum.inductiveautomation.com/u/zbinder)\ **Replies:** 2\ **Last updated:** [June 5, 2023, 12:59pm UTC](https://forum.inductiveautomation.com/t/system-util-retarget-with-jvm-arguments/60231 "2023-06-05T12:59:54Z")
I’m currently running Ignition 8.1.17 and using the JVM argument “-Dsun.java2d.uiScale=2.0” within Vision Client Launcher to ensure that font scaling works appropriately with Windows scaling set to 250% (as opposed to a … --- ## [Nube to Mitsubishi iQ-R connection to Ignition - need help](https://forum.inductiveautomation.com/t/nube-to-mitsubishi-iq-r-connection-to-ignition-need-help/19094)
**Author:** [@rzuniga](https://forum.inductiveautomation.com/u/rzuniga)\ **Replies:** 8\ **Last updated:** [June 5, 2023, 12:46pm UTC](https://forum.inductiveautomation.com/t/nube-to-mitsubishi-iq-r-connection-to-ignition-need-help/19094 "2023-06-05T12:46:47Z")
I am currently working with a customer that has Mitsubishi iQ PCL's connected to Ignition through KepServerEX for an automated assembly line (not built by our company) that has 2 to 3 second delays waiting on data collec… --- ## [How to create internal account and reset password in AD/Internal Hybrid resources](https://forum.inductiveautomation.com/t/how-to-create-internal-account-and-reset-password-in-ad-internal-hybrid-resources/74543)
**Author:** [@Lina\_Su](https://forum.inductiveautomation.com/u/Lina_Su)\ **Replies:** 2\ **Last updated:** [June 5, 2023, 12:34pm UTC](https://forum.inductiveautomation.com/t/how-to-create-internal-account-and-reset-password-in-ad-internal-hybrid-resources/74543 "2023-06-05T12:34:53Z")
I have created an AD/Internal Hybrid type User Source in my Gateway. Inside this User Source, I have created an "administrator" role and added my domain account, and everything is working fine. Now, I want to create an … --- ## [Multiple rows with different timestamp in sqlth\_partitions](https://forum.inductiveautomation.com/t/multiple-rows-with-different-timestamp-in-sqlth-partitions/74469)
**Author:** [@Dharani\_T](https://forum.inductiveautomation.com/u/Dharani_T)\ **Replies:** 9\ **Last updated:** [June 5, 2023, 12:32pm UTC](https://forum.inductiveautomation.com/t/multiple-rows-with-different-timestamp-in-sqlth-partitions/74469 "2023-06-05T12:32:46Z")
Hi, I could see multiple entries with same pname in sqlth\_partitions but with different time stamp. Setup: Results: If this is a problem, what should i have to modify? --- ## [OPC UA Tags with Value Changed Script does not reconnect after FAILOVER endpoint connection with the Secondary Igniton is stablished](https://forum.inductiveautomation.com/t/opc-ua-tags-with-value-changed-script-does-not-reconnect-after-failover-endpoint-connection-with-the-secondary-igniton-is-stablished/74553)
**Author:** [@Carlos\_Valencia](https://forum.inductiveautomation.com/u/Carlos_Valencia)\ **Replies:** 1\ **Last updated:** [June 5, 2023, 12:32pm UTC](https://forum.inductiveautomation.com/t/opc-ua-tags-with-value-changed-script-does-not-reconnect-after-failover-endpoint-connection-with-the-secondary-igniton-is-stablished/74553 "2023-06-05T12:32:34Z")
Running Ignition 8.1.22 with redundancy enable.Redundancy is Warm & Full. After FAILOVER endpoint is stablished , the OPC Tags in which Value Change Script is present, doesn´t not recover the connection to their source… --- ## [How to keep one Row of table on first page and not to be repated on second page](https://forum.inductiveautomation.com/t/how-to-keep-one-row-of-table-on-first-page-and-not-to-be-repated-on-second-page/74558)
**Author:** [@Romsha\_Anand](https://forum.inductiveautomation.com/u/Romsha_Anand)\ **Replies:** 0\ **Last updated:** [June 5, 2023, 11:28am UTC](https://forum.inductiveautomation.com/t/how-to-keep-one-row-of-table-on-first-page-and-not-to-be-repated-on-second-page/74558 "2023-06-05T11:28:25Z")
Hi Team , Suppose there is Class with A, B , C, D sections . I want to show details of all Sections in one single report one by one . I want to show XYZ Details for "Each Section" along with other details . So I have … --- ## [Is there any way to have Perspective tables automatically initialize column widths (auto-fit) based on content?](https://forum.inductiveautomation.com/t/is-there-any-way-to-have-perspective-tables-automatically-initialize-column-widths-auto-fit-based-on-content/73045)
**Author:** [@tyler.bennett](https://forum.inductiveautomation.com/u/tyler.bennett)\ **Replies:** 3\ **Last updated:** [June 5, 2023, 11:04am UTC](https://forum.inductiveautomation.com/t/is-there-any-way-to-have-perspective-tables-automatically-initialize-column-widths-auto-fit-based-on-content/73045 "2023-06-05T11:04:07Z")
Is there any way to have Perspective tables automatically initialize column widths (autofit) based on content, or is it just manual sizing only? I keep feeling like autofit should be there as a natural option (ideally t… --- ## [How to Earn the Core & Gold Certification free?](https://forum.inductiveautomation.com/t/how-to-earn-the-core-gold-certification-free/74547)
**Author:** [@GSK](https://forum.inductiveautomation.com/u/GSK)\ **Replies:** 2\ **Last updated:** [June 5, 2023, 5:26am UTC](https://forum.inductiveautomation.com/t/how-to-earn-the-core-gold-certification-free/74547 "2023-06-05T05:26:38Z")
I had Completed the Ignition V8.1 Tutorial Videos. How to earn the Core & Gold Certification free of Cost? Since i'm financially unstable i wanted this ignition certification very badly because it will atleast help to … --- ## [Multi-input dynamic Template Repeaters: is this possible?](https://forum.inductiveautomation.com/t/multi-input-dynamic-template-repeaters-is-this-possible/74519)
**Author:** [@sherman](https://forum.inductiveautomation.com/u/sherman)\ **Replies:** 7\ **Last updated:** [June 5, 2023, 12:17am UTC](https://forum.inductiveautomation.com/t/multi-input-dynamic-template-repeaters-is-this-possible/74519 "2023-06-05T00:17:47Z")
I'm trying to build a template of a Template Repeater (TR) that will be capable of populating itself with repeatable templates for each instance of a UDT in a folder. For example, I have a path structure like: \[HMI\] d… --- ## [Property Binding Based On Whether an Active Alarm Exists Within a Subset of Alarms](https://forum.inductiveautomation.com/t/property-binding-based-on-whether-an-active-alarm-exists-within-a-subset-of-alarms/74492)
**Author:** [@Chanse\_Meyer](https://forum.inductiveautomation.com/u/Chanse_Meyer)\ **Replies:** 1\ **Last updated:** [June 4, 2023, 3:39am UTC](https://forum.inductiveautomation.com/t/property-binding-based-on-whether-an-active-alarm-exists-within-a-subset-of-alarms/74492 "2023-06-04T03:39:16Z")
I made Ignition Vision UDT's for my different device types which exist in the system (e.g. motor, photoeye, etc.). These UDT's have tags that pull their values from the PLC. There are alarms associated with some of these… --- ## [Designer Launcher launch error occurred](https://forum.inductiveautomation.com/t/designer-launcher-launch-error-occurred/74531)
**Author:** [@Carolyn\_Zhou](https://forum.inductiveautomation.com/u/Carolyn_Zhou)\ **Replies:** 2\ **Last updated:** [June 3, 2023, 3:52pm UTC](https://forum.inductiveautomation.com/t/designer-launcher-launch-error-occurred/74531 "2023-06-03T15:52:26Z")
When I was trying to Open Designer an error message showed up "Downloading of Launchclient.jar failed, launching will not occur." I then looked for the java folder and found that the JavaVirtueMachines folder is empty. --- ## [Ignition client DB connection](https://forum.inductiveautomation.com/t/ignition-client-db-connection/74525)
**Author:** [@y.parashchuk](https://forum.inductiveautomation.com/u/y.parashchuk)\ **Replies:** 2\ **Last updated:** [June 3, 2023, 10:09am UTC](https://forum.inductiveautomation.com/t/ignition-client-db-connection/74525 "2023-06-03T10:09:13Z")
If gateway has connection to DB (separate server) but ignition clients has no connection to a DB server but has to gateway - is they will be able access data from a DB ? Is there any restrictions for this case? --- ## [Passing Literal Values Via Expression Binding Instead Of Binding An Existing Tag](https://forum.inductiveautomation.com/t/passing-literal-values-via-expression-binding-instead-of-binding-an-existing-tag/74512)
**Author:** [@Chanse\_Meyer](https://forum.inductiveautomation.com/u/Chanse_Meyer)\ **Replies:** 6\ **Last updated:** [June 3, 2023, 5:30am UTC](https://forum.inductiveautomation.com/t/passing-literal-values-via-expression-binding-instead-of-binding-an-existing-tag/74512 "2023-06-03T05:30:51Z")
I have a template for a conveyor illustration. It takes a parameter which is a UDT type I created called motor, which has tags for Motor Running Status (integer; 0=idle, 1=running forward, 2=running reverse), HOA status … --- ## [Table cell displays NaN for small number (Bug ?)](https://forum.inductiveautomation.com/t/table-cell-displays-nan-for-small-number-bug/74503)
**Author:** [@jimschaefer](https://forum.inductiveautomation.com/u/jimschaefer)\ **Replies:** 9\ **Last updated:** [June 3, 2023, 12:36am UTC](https://forum.inductiveautomation.com/t/table-cell-displays-nan-for-small-number-bug/74503 "2023-06-03T00:36:13Z")
I have linked a dataset to a table in perspective. The table does not show scientific notation. When I enter values is removes the scientific notation. Example: The value in the dataset is 6.9592e-8. The table displ… --- ## [OPC UA Connection Faulted After Upgrade](https://forum.inductiveautomation.com/t/opc-ua-connection-faulted-after-upgrade/40561)
**Author:** [@controlng](https://forum.inductiveautomation.com/u/controlng)\ **Replies:** 10\ **Last updated:** [June 2, 2023, 11:08pm UTC](https://forum.inductiveautomation.com/t/opc-ua-connection-faulted-after-upgrade/40561 "2023-06-02T23:08:31Z")
Upgraded Ignition Edge 8.0.16 with a working standard OPC-UA Server running to 8.1.0 and got the following: java.lang.Exception: OPC server connection is faulted. Type "com.inductiveautomation.OpcUaServerType" is not a… --- ## [Expression for Value in Array](https://forum.inductiveautomation.com/t/expression-for-value-in-array/49467)
**Author:** [@deon.korb](https://forum.inductiveautomation.com/u/deon.korb)\ **Replies:** 4\ **Last updated:** [June 2, 2023, 8:46pm UTC](https://forum.inductiveautomation.com/t/expression-for-value-in-array/49467 "2023-06-02T20:46:46Z")
Hi, After the dropdown bi-directional binding to array tags have been fixed, I want to test if something is in the selected array. As a test I have a dropdown where days of the week are selected. I want to make an expr… --- ## [Issue with object member bindings](https://forum.inductiveautomation.com/t/issue-with-object-member-bindings/74380)
**Author:** [@justin.brzozoski](https://forum.inductiveautomation.com/u/justin.brzozoski)\ **Replies:** 4\ **Last updated:** [June 2, 2023, 8:39pm UTC](https://forum.inductiveautomation.com/t/issue-with-object-member-bindings/74380 "2023-06-02T20:39:58Z")
We've bumped into an issue on 8.1.26 related to bindings on non-persistent members of property objects... We've seen this in a bunch of situations, some not related to sub-views, but my minimal example below happens to … --- ## [Sum/aggregate expression on a array of json data property?](https://forum.inductiveautomation.com/t/sum-aggregate-expression-on-a-array-of-json-data-property/32638)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 8\ **Last updated:** [June 2, 2023, 8:18pm UTC](https://forum.inductiveautomation.com/t/sum-aggregate-expression-on-a-array-of-json-data-property/32638 "2023-06-02T20:18:22Z")
I have a table in perspective that’s data property is a array of json objects. We do this so we’re able to manipulate row background colors. In this same table, I want to get a sum of a column, in this case, a boolean… --- ## [Web Dev Python Resources - Shared or Dedicated Thread?](https://forum.inductiveautomation.com/t/web-dev-python-resources-shared-or-dedicated-thread/74508)
**Author:** [@dustin.cooper](https://forum.inductiveautomation.com/u/dustin.cooper)\ **Replies:** 2\ **Last updated:** [June 2, 2023, 7:50pm UTC](https://forum.inductiveautomation.com/t/web-dev-python-resources-shared-or-dedicated-thread/74508 "2023-06-02T19:50:31Z")
Hi all, I imagine the subject line expresses my query pretty succinctly, but just in case, I've had no luck figuring out from the user manual or perusing this forum if python resources run in a dedicated or shared threa… --- ## [Multiple runNamedQueries or Stored Procedure?](https://forum.inductiveautomation.com/t/multiple-runnamedqueries-or-stored-procedure/35610)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 1\ **Last updated:** [June 2, 2023, 5:18pm UTC](https://forum.inductiveautomation.com/t/multiple-runnamedqueries-or-stored-procedure/35610 "2023-06-02T17:18:00Z")
If I need to run +3 runNamedQueries in a row for a single operation, is it more efficient to just create a stored procedure and call it once to handle all the of the queries? I’ve only used a stored procedure call once … --- ## [Gateway Script Automating Table Insert/Update](https://forum.inductiveautomation.com/t/gateway-script-automating-table-insert-update/74484)
**Author:** [@Robert\_Hrynciw](https://forum.inductiveautomation.com/u/Robert_Hrynciw)\ **Replies:** 12\ **Last updated:** [June 2, 2023, 5:32pm UTC](https://forum.inductiveautomation.com/t/gateway-script-automating-table-insert-update/74484 "2023-06-02T17:32:37Z")
Hello all, I have been working on a scheduled gateway script that will take values from one table and insert them into another table with some additional values in order to automate a "Charge Hours" page where the manag… --- ## [Finding Error Within Projects](https://forum.inductiveautomation.com/t/finding-error-within-projects/74493)
**Author:** [@Muhammad\_Saim](https://forum.inductiveautomation.com/u/Muhammad_Saim)\ **Replies:** 2\ **Last updated:** [June 2, 2023, 3:00pm UTC](https://forum.inductiveautomation.com/t/finding-error-within-projects/74493 "2023-06-02T15:00:25Z")
Hello I'm trying to find the location of this error that is constantly streaming in our logs, but I'm not sure where it's located. There are ~9,000 screens and it doesn't give me much information to narrow down my s… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=635) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=637)