# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1122 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1123 --- ## [invokeAsynchronous wait()](https://forum.inductiveautomation.com/t/invokeasynchronous-wait/38906)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 6\ **Last updated:** [September 21, 2020, 10:09pm UTC](https://forum.inductiveautomation.com/t/invokeasynchronous-wait/38906 "2020-09-21T22:09:27Z")
How do I call wait() from inside a function that is called using invokeAsynchronous? I have my class inheriting from java.lang.Thread. It looks like I need my code to be inside a synchronized block, but ignition does not… --- ## [Timediff SQL Ignition](https://forum.inductiveautomation.com/t/timediff-sql-ignition/38899)
**Author:** [@DD\_Chelsea](https://forum.inductiveautomation.com/u/DD_Chelsea)\ **Replies:** 1\ **Last updated:** [September 21, 2020, 9:31pm UTC](https://forum.inductiveautomation.com/t/timediff-sql-ignition/38899 "2020-09-21T21:31:40Z")
Hello, good afternoon everyone. I’m actually working on a parts management system and i have a doubt about how to update a column: The column fecha is the date when the call was initiated. I need to update every 5 min… --- ## [Help with containers](https://forum.inductiveautomation.com/t/help-with-containers/38905)
**Author:** [@bellm](https://forum.inductiveautomation.com/u/bellm)\ **Replies:** 2\ **Last updated:** [September 21, 2020, 9:03pm UTC](https://forum.inductiveautomation.com/t/help-with-containers/38905 "2020-09-21T21:03:46Z")
When using the Vision module, I was able to create a template that had a Label and Text Field that setup so that I could resize the template and it still maintain the 5px space between the two elements by using the const… --- ## [Expression/Calculation in OPC Item Path (Need Help)](https://forum.inductiveautomation.com/t/expression-calculation-in-opc-item-path-need-help/34978)
**Author:** [@dmalec](https://forum.inductiveautomation.com/u/dmalec)\ **Replies:** 2\ **Last updated:** [September 21, 2020, 8:22pm UTC](https://forum.inductiveautomation.com/t/expression-calculation-in-opc-item-path-need-help/34978 "2020-09-21T20:22:22Z")
Got 2 questions here: How can i change the OPC Path the be a tag variable? Specifically a HMI variable, so that if its changed it applies to everywhere in the project How can I set a expression or equiation in … --- ## [Convert timestamp to datetime](https://forum.inductiveautomation.com/t/convert-timestamp-to-datetime/38877)
**Author:** [@Yfactor](https://forum.inductiveautomation.com/u/Yfactor)\ **Replies:** 5\ **Last updated:** [September 21, 2020, 8:20pm UTC](https://forum.inductiveautomation.com/t/convert-timestamp-to-datetime/38877 "2020-09-21T20:20:27Z")
Hi there is there anyway to convert the timestamp to a datetime? I have a table with datetime column (sql query) in it and I want to pass the value with payload when click on the table row to a datepicker. It passes the… --- ## [Ignition 8.0.16 - Perspective - onActionPerformed - read the new selected value on dropdown component](https://forum.inductiveautomation.com/t/ignition-8-0-16-perspective-onactionperformed-read-the-new-selected-value-on-dropdown-component/38901)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 2\ **Last updated:** [September 21, 2020, 7:42pm UTC](https://forum.inductiveautomation.com/t/ignition-8-0-16-perspective-onactionperformed-read-the-new-selected-value-on-dropdown-component/38901 "2020-09-21T19:42:43Z")
Perspective. For a dropdown component when the action Performed script event is triggered if we read self.props.value we don’t have the new selected value but the old value. Is there a way to obtain the new Value ? --- ## [Programmatic rosters/pipeline notifications](https://forum.inductiveautomation.com/t/programmatic-rosters-pipeline-notifications/10545)
**Author:** [@khanley](https://forum.inductiveautomation.com/u/khanley)\ **Replies:** 14\ **Last updated:** [September 21, 2020, 4:53pm UTC](https://forum.inductiveautomation.com/t/programmatic-rosters-pipeline-notifications/10545 "2020-09-21T16:53:00Z")
I have a hypothetical (gold certification exam) system of hundreds of sensors, each sensor is assigned operators, when a sensor faults it is supposed to email the operators assigned to it and allow them to acknowledge it… --- ## [Regarding dynamic views optimal design in ignition perspective](https://forum.inductiveautomation.com/t/regarding-dynamic-views-optimal-design-in-ignition-perspective/38890)
**Author:** [@Avanti.awate](https://forum.inductiveautomation.com/u/Avanti.awate)\ **Replies:** 5\ **Last updated:** [September 21, 2020, 3:40pm UTC](https://forum.inductiveautomation.com/t/regarding-dynamic-views-optimal-design-in-ignition-perspective/38890 "2020-09-21T15:40:27Z")
I have one left view that contains 4 section. I have a doughty that how could I resize the component in that view dynamically. for example on left view 4 plant like plant 1,plant 2,plant 3,plant 4 and I want show only pl… --- ## [MQTT Recorder module does not create tables by set template](https://forum.inductiveautomation.com/t/mqtt-recorder-module-does-not-create-tables-by-set-template/38893)
**Author:** [@aamrc](https://forum.inductiveautomation.com/u/aamrc)\ **Replies:** 0\ **Last updated:** [September 21, 2020, 12:11pm UTC](https://forum.inductiveautomation.com/t/mqtt-recorder-module-does-not-create-tables-by-set-template/38893 "2020-09-21T12:11:26Z")
Hi, I’m new to Ignition. I’ve linked Ignition with MQTT Recorder and a MariaDB. And am able to see some data come into the database when I publish under a tag using the Sparkplug Node-RED library. My issue is that all… --- ## [\[TAGs\] Unknown last value](https://forum.inductiveautomation.com/t/tags-unknown-last-value/38892)
**Author:** [@n.meluccio](https://forum.inductiveautomation.com/u/n.meluccio)\ **Replies:** 1\ **Last updated:** [September 21, 2020, 12:48pm UTC](https://forum.inductiveautomation.com/t/tags-unknown-last-value/38892 "2020-09-21T12:48:45Z")
Hello there, i have a big problem with tags when i plug the ETH cable after the client is already started. Those tags have an overlay that says “unknown last value” (see img) The PLC is properly connected and worki… --- ## [Perspective: Displaying Label centre-aligned for small and left-aligned otherwise for Column Container](https://forum.inductiveautomation.com/t/perspective-displaying-label-centre-aligned-for-small-and-left-aligned-otherwise-for-column-container/38883)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 3\ **Last updated:** [September 21, 2020, 5:37am UTC](https://forum.inductiveautomation.com/t/perspective-displaying-label-centre-aligned-for-small-and-left-aligned-otherwise-for-column-container/38883 "2020-09-21T05:37:38Z")
v8.1.0 I have a column container with a bunch of labels and input fields, and for mobile I want these to stack and be centred; for larger displays, they will be side-by-side (label, input field) and I want them to then … --- ## [\[BUG\] Perspective errors for Dropdown when embedded in Column Container and spans more than a single column](https://forum.inductiveautomation.com/t/bug-perspective-errors-for-dropdown-when-embedded-in-column-container-and-spans-more-than-a-single-column/38882)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 0\ **Last updated:** [September 21, 2020, 2:50am UTC](https://forum.inductiveautomation.com/t/bug-perspective-errors-for-dropdown-when-embedded-in-column-container-and-spans-more-than-a-single-column/38882 "2020-09-21T02:50:02Z")
v8.0.15 I’m getting these errors on a Dropdown component which is embedded into a Column Container: Minified React error #185 and #152 When the View is first loaded, it’s ok, but when I click on it to select an item… --- ## [First-out alarm pareto](https://forum.inductiveautomation.com/t/first-out-alarm-pareto/38854)
**Author:** [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\ **Replies:** 2\ **Last updated:** [September 21, 2020, 2:47am UTC](https://forum.inductiveautomation.com/t/first-out-alarm-pareto/38854 "2020-09-21T02:47:41Z")
Hello Ignition’s community :slight\_smile: We have a plc that return the first out alarm in a register. This register is an integer relative to the first alarm that cause the stop of the machine. This integer can be mat… --- ## [Timeseries Chart doesn't work as Bar Chart as normal Bar Chart](https://forum.inductiveautomation.com/t/timeseries-chart-doesnt-work-as-bar-chart-as-normal-bar-chart/38684)
**Author:** [@vrush.dahivalkar](https://forum.inductiveautomation.com/u/vrush.dahivalkar)\ **Replies:** 4\ **Last updated:** [September 21, 2020, 1:03am UTC](https://forum.inductiveautomation.com/t/timeseries-chart-doesnt-work-as-bar-chart-as-normal-bar-chart/38684 "2020-09-21T01:03:38Z")
V8.0.15 I am generating Production reports and using historical data from SQL and need to show Bar chart. The client was use to excel charts and they want same looks in new reports. Any suggestion how to achive beter … --- ## [Vision: Find used/unused Templates](https://forum.inductiveautomation.com/t/vision-find-used-unused-templates/38880)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 0\ **Last updated:** [September 20, 2020, 10:22pm UTC](https://forum.inductiveautomation.com/t/vision-find-used-unused-templates/38880 "2020-09-20T22:22:19Z")
v7.9.14 Is it possible to get a list of unused/used Templates? I have a whole bunch that I don’t think are used anymore and want to do some spring cleaning on them. Ideally I’d like to search for them throughout the who… --- ## [Perspective Dock view - Show on breakpoint small](https://forum.inductiveautomation.com/t/perspective-dock-view-show-on-breakpoint-small/38859)
**Author:** [@luc.martin](https://forum.inductiveautomation.com/u/luc.martin)\ **Replies:** 2\ **Last updated:** [September 20, 2020, 12:08pm UTC](https://forum.inductiveautomation.com/t/perspective-dock-view-show-on-breakpoint-small/38859 "2020-09-20T12:08:37Z")
Is there a way to show a dockview only when size of window in under the breakpoint ? dor now the dock is trigged only when size is at least the breakpoint. I’m on 8.0.16 --- ## [Read xlsx file without paid modules](https://forum.inductiveautomation.com/t/read-xlsx-file-without-paid-modules/37202)
**Author:** [@h.sumrain](https://forum.inductiveautomation.com/u/h.sumrain)\ **Replies:** 9\ **Last updated:** [September 20, 2020, 11:39am UTC](https://forum.inductiveautomation.com/t/read-xlsx-file-without-paid-modules/37202 "2020-09-20T11:39:48Z")
Hi everyone! Up to now and at the current version of Ignition, what is a good/easy way to read a xlsx file without using 3rd party paid modules if possible? Thanks a bunch! --- ## [Run time bindability](https://forum.inductiveautomation.com/t/run-time-bindability/2056)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 4\ **Last updated:** [September 20, 2020, 12:25am UTC](https://forum.inductiveautomation.com/t/run-time-bindability/2056 "2020-09-20T00:25:35Z")
Is there a way to find out, at run time, what a property is bound to? Can it be changed? I could use a dynamic property and check the value of it, but I'd be more interested in finding out which dynamic property a prop… --- ## [Configuring db connection for Windows Authentication causes JVM to crash](https://forum.inductiveautomation.com/t/configuring-db-connection-for-windows-authentication-causes-jvm-to-crash/27757)
**Author:** [@james.vosler](https://forum.inductiveautomation.com/u/james.vosler)\ **Replies:** 8\ **Last updated:** [September 18, 2020, 8:51pm UTC](https://forum.inductiveautomation.com/t/configuring-db-connection-for-windows-authentication-causes-jvm-to-crash/27757 "2020-09-18T20:51:32Z")
This weekend I attempted to add a new db connection to a running gateway. Two db connections with sql authentication were up and running, and I wanted to add a third db connection using windows authentication. I used t… --- ## [Error forwarding data: Duplicate entry for key 'PRIMARY'](https://forum.inductiveautomation.com/t/error-forwarding-data-duplicate-entry-for-key-primary/9385)
**Author:** [@fran.alija](https://forum.inductiveautomation.com/u/fran.alija)\ **Replies:** 18\ **Last updated:** [September 18, 2020, 7:51pm UTC](https://forum.inductiveautomation.com/t/error-forwarding-data-duplicate-entry-for-key-primary/9385 "2020-09-18T19:51:24Z")
Hello, In one of our Ignition projects, the Gateway keeps logging the following error: \[i\] 06:35:13 MemoryForwardTransaction Error forwarding data: Duplicate entry '24062-1416977712044' for key 'PRIMARY' java.sql.B… --- ## [Oil & Gas Ideas](https://forum.inductiveautomation.com/t/oil-gas-ideas/32556)
**Author:** [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Replies:** 29\ **Last updated:** [September 18, 2020, 6:42pm UTC](https://forum.inductiveautomation.com/t/oil-gas-ideas/32556 "2020-09-18T18:42:49Z")
Hello, I work for a small Oil & Gas producer in the central US. I would love to hear from other Oil & Gas people to discuss how they are using Ignition. We use a cellular edge of network unit for each of our remote loca… --- ## [SQL Query: Searching for a String in the Where command](https://forum.inductiveautomation.com/t/sql-query-searching-for-a-string-in-the-where-command/38841)
**Author:** [@mreal](https://forum.inductiveautomation.com/u/mreal)\ **Replies:** 3\ **Last updated:** [September 18, 2020, 6:38pm UTC](https://forum.inductiveautomation.com/t/sql-query-searching-for-a-string-in-the-where-command/38841 "2020-09-18T18:38:06Z")
I’m trying to filter the a column of strings base on if it contains a specific word. Here is a simple example of what I’m drying to do. I’m trying to find the right syntax for the WHERE command. Select id, strvalue F… --- ## [Edge 8.0 or 8.1 on a Raspberry Pi](https://forum.inductiveautomation.com/t/edge-8-0-or-8-1-on-a-raspberry-pi/38844)
**Author:** [@rschantell](https://forum.inductiveautomation.com/u/rschantell)\ **Replies:** 3\ **Last updated:** [September 18, 2020, 6:30pm UTC](https://forum.inductiveautomation.com/t/edge-8-0-or-8-1-on-a-raspberry-pi/38844 "2020-09-18T18:30:07Z")
We have roughly 10 Edge nodes running 7.9.10 and the MQTT transmission module on Raspberry Pi 3+ around our plants and we are looking at upgrading to 8.0 or 8.1. I have installed 8.0.8 on one and 8.1.0 rc1 on our testing… --- ## [Tag import from older version (error\_configuration)](https://forum.inductiveautomation.com/t/tag-import-from-older-version-error-configuration/38788)
**Author:** [@gerben.t.de.boer](https://forum.inductiveautomation.com/u/gerben.t.de.boer)\ **Replies:** 2\ **Last updated:** [September 18, 2020, 6:12pm UTC](https://forum.inductiveautomation.com/t/tag-import-from-older-version-error-configuration/38788 "2020-09-18T18:12:55Z")
Hello, I am importing a xml file but after importing the tag is created but it gives me “Error\_Configuration”. The xml file comes from an older version of Ignition, I think the configuration is not compatible any more w… --- ## [Easy Chart "Operator Roles" error when running client](https://forum.inductiveautomation.com/t/easy-chart-operator-roles-error-when-running-client/38818)
**Author:** [@PLCINC\_NY](https://forum.inductiveautomation.com/u/PLCINC_NY)\ **Replies:** 2\ **Last updated:** [September 18, 2020, 5:33pm UTC](https://forum.inductiveautomation.com/t/easy-chart-operator-roles-error-when-running-client/38818 "2020-09-18T17:33:10Z")
I created two separate Vision windows that will simply display individual “Easy Chart” components. The charts access SQL data from Transaction Groups. In development they work great. When I run the client and open the “P… --- ## [Tool for Bulk Language Translation](https://forum.inductiveautomation.com/t/tool-for-bulk-language-translation/38436)
**Author:** [@harigobu.gb](https://forum.inductiveautomation.com/u/harigobu.gb)\ **Replies:** 2\ **Last updated:** [September 18, 2020, 4:50pm UTC](https://forum.inductiveautomation.com/t/tool-for-bulk-language-translation/38436 "2020-09-18T16:50:33Z")
Hi, Are there any best tool available to translate the xml export provided by Ignition Translation manager and the tool has to return back translated language xml file. or Any work around/good practices to do this. –Har… --- ## [Report Problems - Can't get historian data to populate table](https://forum.inductiveautomation.com/t/report-problems-cant-get-historian-data-to-populate-table/30501)
**Author:** [@dkauffman](https://forum.inductiveautomation.com/u/dkauffman)\ **Replies:** 6\ **Last updated:** [September 18, 2020, 3:57pm UTC](https://forum.inductiveautomation.com/t/report-problems-cant-get-historian-data-to-populate-table/30501 "2020-09-18T15:57:32Z")
I have been fighting for days with settings and cannot resolve this. It will show the count of items in the table, but I can’t get it to show the actual values. I can see it in the code (see screenshot to right are the a… --- ## [Simple gauge value color](https://forum.inductiveautomation.com/t/simple-gauge-value-color/27048)
**Author:** [@craigb](https://forum.inductiveautomation.com/u/craigb)\ **Replies:** 8\ **Last updated:** [September 18, 2020, 2:51pm UTC](https://forum.inductiveautomation.com/t/simple-gauge-value-color/27048 "2020-09-18T14:51:40Z")
How do you change the color of the value on the simple gauge? Ive tried adding the props color, the manual says use a RGB code, tried that. Cant get it to change. The manual seems to have some errors for the props for l… --- ## [Imp.load\_dynamic failing from the escripting console](https://forum.inductiveautomation.com/t/imp-load-dynamic-failing-from-the-escripting-console/38832)
**Author:** [@patricia.mendez](https://forum.inductiveautomation.com/u/patricia.mendez)\ **Replies:** 3\ **Last updated:** [September 18, 2020, 1:04pm UTC](https://forum.inductiveautomation.com/t/imp-load-dynamic-failing-from-the-escripting-console/38832 "2020-09-18T13:04:04Z")
Hello, Can the experts help me to solve the following mystery?. I have a 3rd party lib, which I have installed in /var/lib/ignition/user-lib/pylib/ following the advices of the documentation. It is called dimc.py which… --- ## [Declaration of an initial environment in Ignition](https://forum.inductiveautomation.com/t/declaration-of-an-initial-environment-in-ignition/38828)
**Author:** [@patricia.mendez](https://forum.inductiveautomation.com/u/patricia.mendez)\ **Replies:** 2\ **Last updated:** [September 18, 2020, 12:47pm UTC](https://forum.inductiveautomation.com/t/declaration-of-an-initial-environment-in-ignition/38828 "2020-09-18T12:47:26Z")
Dear Supporters, is there a way to define an environment variable, in particular LD\_LIBRARY\_PATH to ensure it is taken by the Ignition gateway at start time?. I did it by adding to ignition.sh the name of a file includi… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1121) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1123)