# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1294 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1295 --- ## [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… --- ## [system.util.sendMessage() perspective scripting](https://forum.inductiveautomation.com/t/system-util-sendmessage-perspective-scripting/38799)
**Author:** [@matthew.ayre](https://forum.inductiveautomation.com/u/matthew.ayre)\ **Replies:** 5\ **Last updated:** [September 21, 2020, 3:34pm UTC](https://forum.inductiveautomation.com/t/system-util-sendmessage-perspective-scripting/38799 "2020-09-21T15:34:52Z")
I have a script that calls system.util.sendMessage(). When scope is not provided (default: GCS) I get a return value of:\[type=Gateway,project=myProject,messageHandler=test,filterParams={userRoles=, userZones=},isRequest=… --- ## [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… --- ## [Delab DM-50 Modbus](https://forum.inductiveautomation.com/t/delab-dm-50-modbus/38879)
**Author:** [@IBRAHIM](https://forum.inductiveautomation.com/u/IBRAHIM)\ **Replies:** 0\ **Last updated:** [September 18, 2020, 10:03am UTC](https://forum.inductiveautomation.com/t/delab-dm-50-modbus/38879 "2020-09-18T10:03:30Z")
--- ## [Example OCP-UA Device classNotFoundException](https://forum.inductiveautomation.com/t/example-ocp-ua-device-classnotfoundexception/38873)
**Author:** [@kgoodwin](https://forum.inductiveautomation.com/u/kgoodwin)\ **Replies:** 6\ **Last updated:** [September 20, 2020, 7:46pm UTC](https://forum.inductiveautomation.com/t/example-ocp-ua-device-classnotfoundexception/38873 "2020-09-20T19:46:30Z")
Trying to get the OPC-UA device example to work. Running Ignition 8.0.16, cloned the git repository, built the example. This resulted in a version error. Changed the pom.xml ignition-version to 8.0.16, built again. Now I… --- ## [Docker usage with ignition](https://forum.inductiveautomation.com/t/docker-usage-with-ignition/38871)
**Author:** [@jmoniz](https://forum.inductiveautomation.com/u/jmoniz)\ **Replies:** 2\ **Last updated:** [September 20, 2020, 7:36pm UTC](https://forum.inductiveautomation.com/t/docker-usage-with-ignition/38871 "2020-09-20T19:36:30Z")
Watching some of the ICC videos on docker was a bit of an eye opener. Always knew about docker but was too focused on VM’s. We are struggling with prod/dev workflow and docker looks like it would massively help with … --- ## [Syntax Error in the Expression](https://forum.inductiveautomation.com/t/syntax-error-in-the-expression/38856)
**Author:** [@Saddakirankumar](https://forum.inductiveautomation.com/u/Saddakirankumar)\ **Replies:** 5\ **Last updated:** [September 20, 2020, 7:05pm UTC](https://forum.inductiveautomation.com/t/syntax-error-in-the-expression/38856 "2020-09-20T19:05:12Z")
I am trying to display the Text in the Display path along with the tag value. It is giving error. This is what is written in Display path expression editor. “Fan speed :” {\[.\]Fan Status.Fan Speed} It is giving error Sy… --- ## [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 --- ## [Perspective - Top dock view issue](https://forum.inductiveautomation.com/t/perspective-top-dock-view-issue/38869)
**Author:** [@luc.martin](https://forum.inductiveautomation.com/u/luc.martin)\ **Replies:** 0\ **Last updated:** [September 20, 2020, 12:01pm UTC](https://forum.inductiveautomation.com/t/perspective-top-dock-view-issue/38869 "2020-09-20T12:01:58Z")
I try to configure an onDemand push TOP dock view. The problem is that the zone of the dock view always stay on top. When I hide my view the zone still visible and my top dock don’t push my left dock view when I put my… --- ## [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… --- ## [How to automatically size perspective window to device application is being accessed](https://forum.inductiveautomation.com/t/how-to-automatically-size-perspective-window-to-device-application-is-being-accessed/23493)
**Author:** [@ndani](https://forum.inductiveautomation.com/u/ndani)\ **Replies:** 9\ **Last updated:** [September 19, 2020, 2:17pm UTC](https://forum.inductiveautomation.com/t/how-to-automatically-size-perspective-window-to-device-application-is-being-accessed/23493 "2020-09-19T14:17:55Z")
Hello, is there a way to automatically size perspective window/page to device application is being accessed from. Need to be able to move containers based on pixels available to make better use of system depending on dev… --- ## [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… --- ## [Posting on the Ignition Forum](https://forum.inductiveautomation.com/t/posting-on-the-ignition-forum/37825)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 4\ **Last updated:** [September 18, 2020, 8:34pm UTC](https://forum.inductiveautomation.com/t/posting-on-the-ignition-forum/37825 "2020-09-18T20:34:30Z")
Anytime I post a question or reply, I know that @pturmel is lurking, and waiting to drop the truth hammer :slight\_smile: \[Posts code with curly quotes instead of straight quotes\]…Its Hammer Time! Seriously, shout out 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… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1293) [Next page](https://forum.inductiveautomation.com/latest.md?page=1295)