# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=461 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 462 --- ## [Ignition Edge Historian Information](https://forum.inductiveautomation.com/t/ignition-edge-historian-information/87239)
**Author:** [@Apxea](https://forum.inductiveautomation.com/u/Apxea)\ **Replies:** 1\ **Last updated:** [March 14, 2024, 3:25am UTC](https://forum.inductiveautomation.com/t/ignition-edge-historian-information/87239 "2024-03-14T03:25:24Z")
Can anyone tell me about the Ignition Edge Historian's capabilities ? Where can I find the information about Ignition Edge Historian ? Thank you for your time. Have a wonderful day. --- ## [M580 OPC-UA Module](https://forum.inductiveautomation.com/t/m580-opc-ua-module/46179)
**Author:** [@jay](https://forum.inductiveautomation.com/u/jay)\ **Replies:** 5\ **Last updated:** [March 14, 2024, 12:14am UTC](https://forum.inductiveautomation.com/t/m580-opc-ua-module/46179 "2024-03-14T00:14:51Z")
Has anyone used the OPC-AU module that is available for the Modicon M580 PLC. Does it work with Ignition? Any snags? BMENUA0100 --- ## [Divide by zero error encountered, SQL query in Power Table](https://forum.inductiveautomation.com/t/divide-by-zero-error-encountered-sql-query-in-power-table/87307)
**Author:** [@rigoberto.reyes](https://forum.inductiveautomation.com/u/rigoberto.reyes)\ **Replies:** 1\ **Last updated:** [March 13, 2024, 11:22pm UTC](https://forum.inductiveautomation.com/t/divide-by-zero-error-encountered-sql-query-in-power-table/87307 "2024-03-13T23:22:45Z")
Hi. I have the following query into a Power Table object, which returns divide by zero error encountered message. how can it be solved? Select MAchineID, MIN(\[CurrTotalGasConsumption\]) as 'Inicial Consumption', MAX(\[C… --- ## [Timeseries chart issue](https://forum.inductiveautomation.com/t/timeseries-chart-issue/87111)
**Author:** [@Govind\_Suthar1](https://forum.inductiveautomation.com/u/Govind_Suthar1)\ **Replies:** 3\ **Last updated:** [March 13, 2024, 10:36pm UTC](https://forum.inductiveautomation.com/t/timeseries-chart-issue/87111 "2024-03-13T22:36:06Z")
Hello, I have created a timeseries chart in the report module. In this chart a value is logged in the database at a specific time. SQL query. Timeseries chart configuration. Report. Problem :-In this Re… --- ## [Using system.date.now() as default parameter](https://forum.inductiveautomation.com/t/using-system-date-now-as-default-parameter/87306)
**Author:** [@Tyler\_Shoemake](https://forum.inductiveautomation.com/u/Tyler_Shoemake)\ **Replies:** 4\ **Last updated:** [March 13, 2024, 10:14pm UTC](https://forum.inductiveautomation.com/t/using-system-date-now-as-default-parameter/87306 "2024-03-13T22:14:52Z")
It seems to me like using system.date.now() as a default parameter in a function is bad practice because... This is easy to see within the script console, but when you apply this concept to the script library, you coul… --- ## [Tag quality codes in tag historian](https://forum.inductiveautomation.com/t/tag-quality-codes-in-tag-historian/64714)
**Author:** [@louagejasper](https://forum.inductiveautomation.com/u/louagejasper)\ **Replies:** 6\ **Last updated:** [August 4, 2023, 7:59pm UTC](https://forum.inductiveautomation.com/t/tag-quality-codes-in-tag-historian/64714 "2023-08-04T19:59:39Z")
Hi all, We are on version 8.1.18. We are starting to work with tag quality codes. We looked at the tag quality codes of our currently stored tags, and the codes don't seem to match the documentation. We expected to se… --- ## [Making a kwh report](https://forum.inductiveautomation.com/t/making-a-kwh-report/87287)
**Author:** [@O\_E](https://forum.inductiveautomation.com/u/O_E)\ **Replies:** 4\ **Last updated:** [March 13, 2024, 9:15pm UTC](https://forum.inductiveautomation.com/t/making-a-kwh-report/87287 "2024-03-13T21:15:30Z")
Hi i am wondering what would be the best way of making a kwh report in Ignition Reportig ? I have come as fare as getting a report to give me a table with logged numbers bewteene two given dates. Where im getting stuc… --- ## [Tag Binding with Expression](https://forum.inductiveautomation.com/t/tag-binding-with-expression/87292)
**Author:** [@Aron\_Grzywaczewski](https://forum.inductiveautomation.com/u/Aron_Grzywaczewski)\ **Replies:** 16\ **Last updated:** [March 13, 2024, 9:14pm UTC](https://forum.inductiveautomation.com/t/tag-binding-with-expression/87292 "2024-03-13T21:14:58Z")
Is it possible to link the binding to a tag with an expression like the below: I can't figure this out. I am actually able to link with expression when expression is selected on the left, but not able to link with ex… --- ## [Update query for file upload component](https://forum.inductiveautomation.com/t/update-query-for-file-upload-component/87266)
**Author:** [@Ben522326](https://forum.inductiveautomation.com/u/Ben522326)\ **Replies:** 4\ **Last updated:** [March 13, 2024, 7:41pm UTC](https://forum.inductiveautomation.com/t/update-query-for-file-upload-component/87266 "2024-03-13T19:41:38Z")
I'm creating a view similar to a form where the user can fill in text fields, select buttons, and upload files. I want to store all this into a database with a 'submit' button click. However I can't figure out how to sto… --- ## [Table columns width auto?](https://forum.inductiveautomation.com/t/table-columns-width-auto/81807)
**Author:** [@etlikmilos](https://forum.inductiveautomation.com/u/etlikmilos)\ **Replies:** 3\ **Last updated:** [March 13, 2024, 3:54pm UTC](https://forum.inductiveautomation.com/t/table-columns-width-auto/81807 "2024-03-13T15:54:19Z")
Hi, I need advice on how to set the column width property on the table to auto. When I set anything, it doesn't work and when I shrink the window, the property is set to 100px v element.style ? Can this be removed? Versi… --- ## [Value Mapping to Change Text Color](https://forum.inductiveautomation.com/t/value-mapping-to-change-text-color/87265)
**Author:** [@ahawes](https://forum.inductiveautomation.com/u/ahawes)\ **Replies:** 10\ **Last updated:** [March 13, 2024, 3:52pm UTC](https://forum.inductiveautomation.com/t/value-mapping-to-change-text-color/87265 "2024-03-13T15:52:26Z")
Good morning Team, I have a tag that with the query listed. I have mapped it to change it to a percentage but I would like the color of text to change when it is over certain percent/value. I have tried adding an addi… --- ## [Questions about the Web Dev module](https://forum.inductiveautomation.com/t/questions-about-the-web-dev-module/87277)
**Author:** [@Bushmatic](https://forum.inductiveautomation.com/u/Bushmatic)\ **Replies:** 1\ **Last updated:** [March 13, 2024, 3:46pm UTC](https://forum.inductiveautomation.com/t/questions-about-the-web-dev-module/87277 "2024-03-13T15:46:10Z")
I'm trying to get a firm understanding of the Web Dev module, and some ideas are still a cloudy in my mind, so I'm hoping someone might be able to help clear things up. I found the below post on the forum which explains… --- ## [Unable to see JFK Certificate loading option in MQTT Distributor](https://forum.inductiveautomation.com/t/unable-to-see-jfk-certificate-loading-option-in-mqtt-distributor/87244)
**Author:** [@narayan.naik](https://forum.inductiveautomation.com/u/narayan.naik)\ **Replies:** 2\ **Last updated:** [March 13, 2024, 3:34pm UTC](https://forum.inductiveautomation.com/t/unable-to-see-jfk-certificate-loading-option-in-mqtt-distributor/87244 "2024-03-13T15:34:21Z")
I have installed MQTT Cirrus Link Distributor module (4.0.21) in Ignition (8.7.35) but I don't see the option to load JFK certificate in Distributor setting. Any Idea? \[image\] --- ## [Use Template Repeater](https://forum.inductiveautomation.com/t/use-template-repeater/87271)
**Author:** [@sebastien\_ng](https://forum.inductiveautomation.com/u/sebastien_ng)\ **Replies:** 6\ **Last updated:** [March 13, 2024, 3:32pm UTC](https://forum.inductiveautomation.com/t/use-template-repeater/87271 "2024-03-13T15:32:24Z")
Template Param of template : Main Window: What I want to do is when I change Value of temperature of dropdown list, value of Thermometer muste change. For exemple on Main Window, if I choose Temperature = 50 … --- ## [Alarm Ack by "Live Event Limit" Causes wrong alarm label](https://forum.inductiveautomation.com/t/alarm-ack-by-live-event-limit-causes-wrong-alarm-label/87276)
**Author:** [@BVTV](https://forum.inductiveautomation.com/u/BVTV)\ **Replies:** 0\ **Last updated:** [March 13, 2024, 3:08pm UTC](https://forum.inductiveautomation.com/t/alarm-ack-by-live-event-limit-causes-wrong-alarm-label/87276 "2024-03-13T15:08:49Z")
Hi, I am using the Alarm Journal element in Ignition perspective. I have noticed an unwanted behaviour that happens when an alarm is automatically acknowledged by the system due to more than 5 unacknowledged instances ex… --- ## [Anyway to make daily alarm pipelines carry over after server restart?](https://forum.inductiveautomation.com/t/anyway-to-make-daily-alarm-pipelines-carry-over-after-server-restart/87274)
**Author:** [@Cole\_Townsend](https://forum.inductiveautomation.com/u/Cole_Townsend)\ **Replies:** 0\ **Last updated:** [March 13, 2024, 2:50pm UTC](https://forum.inductiveautomation.com/t/anyway-to-make-daily-alarm-pipelines-carry-over-after-server-restart/87274 "2024-03-13T14:50:24Z")
Hello there, I have run into an issue with my alarm pipelines that I'm curious if anyone has had a similar issue with before. My pipeline is set up as shown: The notification should be repeated daily until the alar… --- ## [Report Module Dynamic Colors](https://forum.inductiveautomation.com/t/report-module-dynamic-colors/87242)
**Author:** [@scadafan](https://forum.inductiveautomation.com/u/scadafan)\ **Replies:** 3\ **Last updated:** [March 13, 2024, 2:42pm UTC](https://forum.inductiveautomation.com/t/report-module-dynamic-colors/87242 "2024-03-13T14:42:51Z")
Hello all, I may just be missing something but in Ignition Report Module is there a way to change background colors of a column in a table based on a condition. So for instance if it's 1 turn red if its 2 turn yellow? --- ## [\[BUG- \] Gauge flickers when data updates](https://forum.inductiveautomation.com/t/bug-gauge-flickers-when-data-updates/76959)
**Author:** [@jparish](https://forum.inductiveautomation.com/u/jparish)\ **Replies:** 3\ **Last updated:** [March 13, 2024, 2:38pm UTC](https://forum.inductiveautomation.com/t/bug-gauge-flickers-when-data-updates/76959 "2024-03-13T14:38:41Z")
I have an embedded graphic that I was playing around with that has the third range end value of the outer axis set to the props.value. When I run it using live data the whole gauge graphic flickers every time the data u… --- ## [Transferring Data from dropdowns and numeric entry fields to a query table](https://forum.inductiveautomation.com/t/transferring-data-from-dropdowns-and-numeric-entry-fields-to-a-query-table/86784)
**Author:** [@Tyler\_Britt](https://forum.inductiveautomation.com/u/Tyler_Britt)\ **Replies:** 38\ **Last updated:** [March 13, 2024, 2:16pm UTC](https://forum.inductiveautomation.com/t/transferring-data-from-dropdowns-and-numeric-entry-fields-to-a-query-table/86784 "2024-03-13T14:16:01Z")
I have a view in perspective that is intended to be a way for production workers to submit downtime. I have 2 numeric entry fields and one drop down. I am trying to figure out how to store all the data that is input by t… --- ## [UDT tags modification](https://forum.inductiveautomation.com/t/udt-tags-modification/87165)
**Author:** [@chandra\_srikanth](https://forum.inductiveautomation.com/u/chandra_srikanth)\ **Replies:** 4\ **Last updated:** [March 13, 2024, 1:47pm UTC](https://forum.inductiveautomation.com/t/udt-tags-modification/87165 "2024-03-13T13:47:53Z")
Hi, I have added UDT defination as machine and under i have added N:7.0 and F:8.0, but when add this into UDT instances for machine-1, its showing the same as N:70 and F:80 and for machine-2 also showing the same as N:7… --- ## [Numeric Display shows NaN for very small number](https://forum.inductiveautomation.com/t/numeric-display-shows-nan-for-very-small-number/74596)
**Author:** [@jimschaefer](https://forum.inductiveautomation.com/u/jimschaefer)\ **Replies:** 5\ **Last updated:** [March 13, 2024, 1:46pm UTC](https://forum.inductiveautomation.com/t/numeric-display-shows-nan-for-very-small-number/74596 "2024-03-13T13:46:03Z")
I have a numeric entry field component bound to a float memory tag called "memoryTag05\_float". When the float memory tag has a value of -6.79168362355791e-7 the numeric display shows NaN. When I click in the numeri… --- ## [Identical queries but one doesn't return records](https://forum.inductiveautomation.com/t/identical-queries-but-one-doesnt-return-records/87262)
**Author:** [@Miguel\_Villasenor\_Es](https://forum.inductiveautomation.com/u/Miguel_Villasenor_Es)\ **Replies:** 1\ **Last updated:** [March 13, 2024, 1:34pm UTC](https://forum.inductiveautomation.com/t/identical-queries-but-one-doesnt-return-records/87262 "2024-03-13T13:34:38Z")
Hello, I have this script: # CHECKING IF SHEET TEXTBOX IS FILLED OUT elif self.getSibling("TextField\_Sheet").props.text is not None and len( self.getSibling("TextField\_Sheet").props.text) \>2: txt = "%… --- ## [Permission restriction using system.db.runPrepQuery in component event script](https://forum.inductiveautomation.com/t/permission-restriction-using-system-db-runprepquery-in-component-event-script/87183)
**Author:** [@Om33](https://forum.inductiveautomation.com/u/Om33)\ **Replies:** 7\ **Last updated:** [March 13, 2024, 1:15pm UTC](https://forum.inductiveautomation.com/t/permission-restriction-using-system-db-runprepquery-in-component-event-script/87183 "2024-03-13T13:15:03Z")
Hello, I' m getting the error below due to this line in my component event script: result = system.db.runPrepQuery("SELECT DISTINCT id FROM Stoermeldungen\_10713 WHERE t\_stamp BETWEEN ? AND ?", \[start, ende\]) Traceback … --- ## [Regarding RS232C communication](https://forum.inductiveautomation.com/t/regarding-rs232c-communication/1804)
**Author:** [@ajay](https://forum.inductiveautomation.com/u/ajay)\ **Replies:** 6\ **Last updated:** [March 13, 2024, 12:11pm UTC](https://forum.inductiveautomation.com/t/regarding-rs232c-communication/1804 "2024-03-13T12:11:37Z")
Hi, I would like to know modbus drive in ignition supports RS 232C communication or not. --- ## [Igntion edge to Standard Ignition Tag Historian](https://forum.inductiveautomation.com/t/igntion-edge-to-standard-ignition-tag-historian/86955)
**Author:** [@Adarsh\_Shelar](https://forum.inductiveautomation.com/u/Adarsh_Shelar)\ **Replies:** 2\ **Last updated:** [March 13, 2024, 9:30am UTC](https://forum.inductiveautomation.com/t/igntion-edge-to-standard-ignition-tag-historian/86955 "2024-03-13T09:30:57Z")
Hi Connection, Since Ignition edge Doesn't support the Data base and Tag Historian So, we need to Store the Tag Histrion of Ignition Edge in Standard Ignition. If yes it Possible How we can Store the Tag Histrion data… --- ## [Blank editor windows on Mac](https://forum.inductiveautomation.com/t/blank-editor-windows-on-mac/87251)
**Author:** [@Virgar\_Poulsen](https://forum.inductiveautomation.com/u/Virgar_Poulsen)\ **Replies:** 0\ **Last updated:** [March 13, 2024, 9:06am UTC](https://forum.inductiveautomation.com/t/blank-editor-windows-on-mac/87251 "2024-03-13T09:06:50Z")
It's getting more frequent, that I get blank editor windows, whenever I try to do some work. Even the "save project" window is blank, if I try to close the designer. It's not a RAM issue, since I've got plenty available… --- ## [\[Feature-789\] Perspective component extensibility](https://forum.inductiveautomation.com/t/feature-789-perspective-component-extensibility/29459)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 36\ **Last updated:** [March 13, 2024, 7:56am UTC](https://forum.inductiveautomation.com/t/feature-789-perspective-component-extensibility/29459 "2024-03-13T07:56:12Z")
Being new to web dev, this may be a dumb question… In Vision, I’m able to hack around and break change things in a given component to better suit my needs. For example, allow the dropdown component to support disabling … --- ## [Flashing stroke paint color on svg](https://forum.inductiveautomation.com/t/flashing-stroke-paint-color-on-svg/40512)
**Author:** [@chelton](https://forum.inductiveautomation.com/u/chelton)\ **Replies:** 3\ **Last updated:** [March 13, 2024, 1:55am UTC](https://forum.inductiveautomation.com/t/flashing-stroke-paint-color-on-svg/40512 "2024-03-13T01:55:01Z")
I’m trying to animate a very basic svg in perspective and would like some colours to flash . I created a binding with a map transform on the stroke paint property of my object. I can set fixed colours, is there an easy w… --- ## [Perspective On-screen Keyboard on Linux](https://forum.inductiveautomation.com/t/perspective-on-screen-keyboard-on-linux/50474)
**Author:** [@tim.schultz](https://forum.inductiveautomation.com/u/tim.schultz)\ **Replies:** 7\ **Last updated:** [March 13, 2024, 12:27am UTC](https://forum.inductiveautomation.com/t/perspective-on-screen-keyboard-on-linux/50474 "2024-03-13T00:27:05Z")
Hello - I’m using Perspective Workstation on Linux with a touch screen. The On-Screen keyboard does not launch when I try to login. I do have an OSK installed. --- ## [Write into an UDT alarm](https://forum.inductiveautomation.com/t/write-into-an-udt-alarm/87233)
**Author:** [@Florin\_Radu](https://forum.inductiveautomation.com/u/Florin_Radu)\ **Replies:** 0\ **Last updated:** [March 13, 2024, 12:00am UTC](https://forum.inductiveautomation.com/t/write-into-an-udt-alarm/87233 "2024-03-13T00:00:22Z")
Hello, I am using Ignition 8.1.22 trying to write a value into the properties of a UDT Alarms Properties using the system.tag.writeBlocked function but when trying to access the Alarms section provides Bad\_NotFound erro… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=460) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=462)