# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=749 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 750 --- ## [IA how to guides, how to get current time in python](https://forum.inductiveautomation.com/t/ia-how-to-guides-how-to-get-current-time-in-python/66366)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 2\ **Last updated:** [November 11, 2022, 12:45am UTC](https://forum.inductiveautomation.com/t/ia-how-to-guides-how-to-get-current-time-in-python/66366 "2022-11-11T00:45:26Z")
I just came across the one. This should refer to the standard system library functions, right? It could also be formatted as code. Seems like a bit of a strange how to guide to have though! --- ## [Filters not immediately applied to Alarm Status Table](https://forum.inductiveautomation.com/t/filters-not-immediately-applied-to-alarm-status-table/66072)
**Author:** [@manuele.longhi](https://forum.inductiveautomation.com/u/manuele.longhi)\ **Replies:** 2\ **Last updated:** [November 10, 2022, 11:52pm UTC](https://forum.inductiveautomation.com/t/filters-not-immediately-applied-to-alarm-status-table/66072 "2022-11-10T23:52:32Z")
I have defined a bunch of alarms, each with a display path with the structure \/\/\[...\]/\ Examples: PlantName1/Finishing/Dispencer PlantName2/Foundry/Melting/Furnace After that, I have defined a… --- ## [Perspective Table Edit Dataset](https://forum.inductiveautomation.com/t/perspective-table-edit-dataset/66377)
**Author:** [@Isaac\_Hodgkins](https://forum.inductiveautomation.com/u/Isaac_Hodgkins)\ **Replies:** 4\ **Last updated:** [November 10, 2022, 11:42pm UTC](https://forum.inductiveautomation.com/t/perspective-table-edit-dataset/66377 "2022-11-10T23:42:34Z")
I'm trying to edit values of a dataset by converting it into a py dataset but I'm not having any luck. When I submit an edit to a cell I get this error. Is there a better way to edit a dataset in a table? Thanks! … --- ## [Edge Sync Status](https://forum.inductiveautomation.com/t/edge-sync-status/66065)
**Author:** [@Brian\_Seater](https://forum.inductiveautomation.com/u/Brian_Seater)\ **Replies:** 1\ **Last updated:** [November 10, 2022, 11:31pm UTC](https://forum.inductiveautomation.com/t/edge-sync-status/66065 "2022-11-10T23:31:48Z")
Is there a way to get the status of Edge Sync, either through scripting or system tags? I have an Edge gateway which is syncing tag history and audit trails back to a primary gateway. I'm trying to add something to a Vi… --- ## [Quarantined items String or Binary Data would be truncated - Store and Forward error help](https://forum.inductiveautomation.com/t/quarantined-items-string-or-binary-data-would-be-truncated-store-and-forward-error-help/66086)
**Author:** [@Sukhwant\_Singh](https://forum.inductiveautomation.com/u/Sukhwant_Singh)\ **Replies:** 2\ **Last updated:** [November 10, 2022, 10:44pm UTC](https://forum.inductiveautomation.com/t/quarantined-items-string-or-binary-data-would-be-truncated-store-and-forward-error-help/66086 "2022-11-10T22:44:06Z")
--- ## [Advanced SQL Query Help](https://forum.inductiveautomation.com/t/advanced-sql-query-help/66353)
**Author:** [@Gaurav.Shitole](https://forum.inductiveautomation.com/u/Gaurav.Shitole)\ **Replies:** 10\ **Last updated:** [November 10, 2022, 10:26pm UTC](https://forum.inductiveautomation.com/t/advanced-sql-query-help/66353 "2022-11-10T22:26:44Z")
Hello people, I want to achieve something like below snip: How can I do it through SQL? I am using MSSQL. Note that Col4 is also there for ID1 but since - (empty) value in Table 2, I have skipped it from Expected ta… --- ## [system.report.executeAndDistribute() NO imprime](https://forum.inductiveautomation.com/t/system-report-executeanddistribute-no-imprime/66087)
**Author:** [@JHON\_FLOREZ](https://forum.inductiveautomation.com/u/JHON_FLOREZ)\ **Replies:** 1\ **Last updated:** [November 10, 2022, 10:18pm UTC](https://forum.inductiveautomation.com/t/system-report-executeanddistribute-no-imprime/66087 "2022-11-10T22:18:17Z")
Saludos Tengo un codigo el cual me permite imprimir datos de una Power Table table = event.source.parent.getComponent('PROX\_MANTENIMIENTOS') rows = table.getSelectedRows() if rows: dataIn = system.dataset.toPyDataSe… --- ## [Component Custom Properties Not Inherited](https://forum.inductiveautomation.com/t/component-custom-properties-not-inherited/66329)
**Author:** [@Jordan\_Richardson](https://forum.inductiveautomation.com/u/Jordan_Richardson)\ **Replies:** 1\ **Last updated:** [November 10, 2022, 9:48pm UTC](https://forum.inductiveautomation.com/t/component-custom-properties-not-inherited/66329 "2022-11-10T21:48:56Z")
So long story short, see title. The longer story is that I have a Valuechange script that rearranges the instances in my view canvas when someone 'zooms' in on the map. I noticed it would work in the users project but no… --- ## [How to do prediction using dates in ignition](https://forum.inductiveautomation.com/t/how-to-do-prediction-using-dates-in-ignition/50727)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 35\ **Last updated:** [November 10, 2022, 8:43pm UTC](https://forum.inductiveautomation.com/t/how-to-do-prediction-using-dates-in-ignition/50727 "2022-11-10T20:43:44Z")
Hi, I have a value b = 500 created in table with date 07/01/2020 i have value 600 if my b value reaches greater than 600 i want to find the exact date when my value changed how to do my predicition can any one give… --- ## [Trying to OR multiple decimals to change button color](https://forum.inductiveautomation.com/t/trying-to-or-multiple-decimals-to-change-button-color/66367)
**Author:** [@Paul\_Melton](https://forum.inductiveautomation.com/u/Paul_Melton)\ **Replies:** 2\ **Last updated:** [November 10, 2022, 8:30pm UTC](https://forum.inductiveautomation.com/t/trying-to-or-multiple-decimals-to-change-button-color/66367 "2022-11-10T20:30:49Z")
Hi, I am trying to change a button color based on the decimal value from several tags. If the value of any of the tags is 3, the result will be red, If the value of any of the tags is not 3, the result will be yellow, … --- ## [UDT Bug for DisplayPath in Alarm?](https://forum.inductiveautomation.com/t/udt-bug-for-displaypath-in-alarm/66357)
**Author:** [@Shunning\_Ou](https://forum.inductiveautomation.com/u/Shunning_Ou)\ **Replies:** 1\ **Last updated:** [November 10, 2022, 7:46pm UTC](https://forum.inductiveautomation.com/t/udt-bug-for-displaypath-in-alarm/66357 "2022-11-10T19:46:46Z")
Hi, I have some problems copying UDT. If I create a new UDT instance, the displayPath in alarms will work, but when I copy this UDT instance and rename the instance to a different name. Even after I updated the paramete… --- ## [T\_stamp column storing as a "text" datatype](https://forum.inductiveautomation.com/t/t-stamp-column-storing-as-a-text-datatype/66360)
**Author:** [@Justin\_Szatkowski](https://forum.inductiveautomation.com/u/Justin_Szatkowski)\ **Replies:** 2\ **Last updated:** [November 10, 2022, 7:00pm UTC](https://forum.inductiveautomation.com/t/t-stamp-column-storing-as-a-text-datatype/66360 "2022-11-10T19:00:05Z")
Hello, I have configured a transaction group to collect data on a schedule. However, when automatically storing the time data to a "t\_stamp" column, the datatype gets put as "text". Therefore, when trying to run a selec… --- ## [Perspective File Upload skipping Files](https://forum.inductiveautomation.com/t/perspective-file-upload-skipping-files/64897)
**Author:** [@n.sabel](https://forum.inductiveautomation.com/u/n.sabel)\ **Replies:** 13\ **Last updated:** [November 10, 2022, 6:14pm UTC](https://forum.inductiveautomation.com/t/perspective-file-upload-skipping-files/64897 "2022-11-10T18:14:57Z")
I'm using the File upload component to load 10,000 files into a database. I have found this works fine with multiple files in very small groups 1-5 files has never caused an issue. When I try to do larger groups of say 1… --- ## [Leased Tags on Open But Not Visible Screens](https://forum.inductiveautomation.com/t/leased-tags-on-open-but-not-visible-screens/66359)
**Author:** [@kevin.puetz](https://forum.inductiveautomation.com/u/kevin.puetz)\ **Replies:** 1\ **Last updated:** [November 10, 2022, 5:54pm UTC](https://forum.inductiveautomation.com/t/leased-tags-on-open-but-not-visible-screens/66359 "2022-11-10T17:54:03Z")
Are leased tags refreshed at the leased rate if a Vision screen is open but not visible. For example, if a display is opened on top of another. --- ## [Data Set row -\> writing in a memory tag](https://forum.inductiveautomation.com/t/data-set-row-writing-in-a-memory-tag/66308)
**Author:** [@christgustavoe](https://forum.inductiveautomation.com/u/christgustavoe)\ **Replies:** 2\ **Last updated:** [November 10, 2022, 4:55pm UTC](https://forum.inductiveautomation.com/t/data-set-row-writing-in-a-memory-tag/66308 "2022-11-10T16:55:04Z")
Hello, I have this Dasaset bellow and i would like to know if is possible to make this script: When the button of the row 11 for example was pressed -\> write true in a memory tag, else false. Is it possible to do this… --- ## [Ignition as a modbus slave](https://forum.inductiveautomation.com/t/ignition-as-a-modbus-slave/66334)
**Author:** [@Elie\_Khananya](https://forum.inductiveautomation.com/u/Elie_Khananya)\ **Replies:** 3\ **Last updated:** [November 10, 2022, 4:08pm UTC](https://forum.inductiveautomation.com/t/ignition-as-a-modbus-slave/66334 "2022-11-10T16:08:32Z")
Is this possible? I have a plc that acts as a master only and I wanna pull its data through ignition. I am using modbus tcp. I connected it under devices. But the tags keep going green and red and it ain’t working and im… --- ## [Gateway Tag Change Event](https://forum.inductiveautomation.com/t/gateway-tag-change-event/66350)
**Author:** [@Kfoldesi](https://forum.inductiveautomation.com/u/Kfoldesi)\ **Replies:** 4\ **Last updated:** [November 10, 2022, 3:43pm UTC](https://forum.inductiveautomation.com/t/gateway-tag-change-event/66350 "2022-11-10T15:43:56Z")
Anyone know, which module enables this functionality? --- ## [Read from multiple databases based on dates](https://forum.inductiveautomation.com/t/read-from-multiple-databases-based-on-dates/66324)
**Author:** [@robb](https://forum.inductiveautomation.com/u/robb)\ **Replies:** 4\ **Last updated:** [November 10, 2022, 3:23pm UTC](https://forum.inductiveautomation.com/t/read-from-multiple-databases-based-on-dates/66324 "2022-11-10T15:23:17Z")
Due to size limitation of SQL express (10GB) I've had to make a new database to give the IT team time to figure out archiving of old data. In the meantime, I'd like to be able to read data from the old database and the n… --- ## [Alarm notification pipeline and HTML text](https://forum.inductiveautomation.com/t/alarm-notification-pipeline-and-html-text/66343)
**Author:** [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\ **Replies:** 2\ **Last updated:** [November 10, 2022, 2:33pm UTC](https://forum.inductiveautomation.com/t/alarm-notification-pipeline-and-html-text/66343 "2022-11-10T14:33:37Z")
Good morning, I would like to ask how is possible to send Email using the HTML, I try to add but it manage it as a simple text. Thank you --- ## [What is the Schneider M340 plc discrete input address (modbus tcp)](https://forum.inductiveautomation.com/t/what-is-the-schneider-m340-plc-discrete-input-address-modbus-tcp/66323)
**Author:** [@ANKIT\_BARAD](https://forum.inductiveautomation.com/u/ANKIT_BARAD)\ **Replies:** 3\ **Last updated:** [November 10, 2022, 2:48pm UTC](https://forum.inductiveautomation.com/t/what-is-the-schneider-m340-plc-discrete-input-address-modbus-tcp/66323 "2022-11-10T14:48:33Z")
what is the Schneider M340 plc discrete input address I want to get discrete input data from M340 modicon plc I can get holding register, coil data. But not sure what is the address for Input I0.2.0 TO I0.2.63 ? --- ## [Aliasing support](https://forum.inductiveautomation.com/t/aliasing-support/66188)
**Author:** [@Dominic\_Iadonisi](https://forum.inductiveautomation.com/u/Dominic_Iadonisi)\ **Replies:** 5\ **Last updated:** [November 10, 2022, 1:56pm UTC](https://forum.inductiveautomation.com/t/aliasing-support/66188 "2022-11-10T13:56:15Z")
How comprehensive is Aliasing in regards to tags? Customer wants to alias PT101 type tags to TIA format as TIA allows for more location information. Any input will be helpful. --- ## [Perspective tag binding script](https://forum.inductiveautomation.com/t/perspective-tag-binding-script/66275)
**Author:** [@Pofer\_Wang](https://forum.inductiveautomation.com/u/Pofer_Wang)\ **Replies:** 14\ **Last updated:** [November 10, 2022, 12:47pm UTC](https://forum.inductiveautomation.com/t/perspective-tag-binding-script/66275 "2022-11-10T12:47:29Z")
hello, everyone. I have a problem. I want to use script fast edit tag binding in perspective. Have function can do it? EX: self.getChild("root").getChild("BESS\_Buttery").props.params.CMU.tagbinding.tagbinding.tagpat… --- ## [1200 Tags import from S7-300 PLC](https://forum.inductiveautomation.com/t/1200-tags-import-from-s7-300-plc/65989)
**Author:** [@mukul](https://forum.inductiveautomation.com/u/mukul)\ **Replies:** 4\ **Last updated:** [November 10, 2022, 11:39am UTC](https://forum.inductiveautomation.com/t/1200-tags-import-from-s7-300-plc/65989 "2022-11-10T11:39:29Z")
Hi Guys, Are there tools to import around 1200-1500 Tags from a redundant S7-300 PLC ? How will the siemens driver of the ignition scada work with the redundant PLCs - What happens when there is a switching between the… --- ## [How to implement Modbus function code 6 to force write to sel 2411](https://forum.inductiveautomation.com/t/how-to-implement-modbus-function-code-6-to-force-write-to-sel-2411/66132)
**Author:** [@Elie\_Khananya](https://forum.inductiveautomation.com/u/Elie_Khananya)\ **Replies:** 4\ **Last updated:** [November 10, 2022, 10:20am UTC](https://forum.inductiveautomation.com/t/how-to-implement-modbus-function-code-6-to-force-write-to-sel-2411/66132 "2022-11-10T10:20:24Z")
I’m not understanding where this function is in the drop down of the modbus device under devices. All I see is coil input register and holding registers with float’s unsigned etc.. and I don’t what sel means by “the p… --- ## [Easy Chart Pen ToolTips](https://forum.inductiveautomation.com/t/easy-chart-pen-tooltips/52636)
**Author:** [@eckman.tech](https://forum.inductiveautomation.com/u/eckman.tech)\ **Replies:** 5\ **Last updated:** [November 10, 2022, 9:22am UTC](https://forum.inductiveautomation.com/t/easy-chart-pen-tooltips/52636 "2022-11-10T09:22:59Z")
Need some help with the Easy Chart configureChart method. I am trying to change the mouse hover over tooltip on pens to display the tag documentation property from the tag itself. The problem I’m having is figuring out … --- ## [XY Chart Tool Tip clipping](https://forum.inductiveautomation.com/t/xy-chart-tool-tip-clipping/56389)
**Author:** [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Replies:** 8\ **Last updated:** [November 10, 2022, 8:06am UTC](https://forum.inductiveautomation.com/t/xy-chart-tool-tip-clipping/56389 "2022-11-10T08:06:19Z")
Not sure if this classifies as a bug or lack of knowledge on my part. If the length of the tool tip extends outside of the viewport it is cut off. Is there a way to make the tool tip wrap when it will not fit inside th… --- ## [Customizing on hover color for Tree](https://forum.inductiveautomation.com/t/customizing-on-hover-color-for-tree/66250)
**Author:** [@agriner](https://forum.inductiveautomation.com/u/agriner)\ **Replies:** 7\ **Last updated:** [November 10, 2022, 7:25am UTC](https://forum.inductiveautomation.com/t/customizing-on-hover-color-for-tree/66250 "2022-11-10T07:25:44Z")
Pretty basic but I can't figure out how to change the on-hover color for Perspective Tree components. I think it's grey by default but I'd like to be able to change it if possible. Is there a property to do so? --- ## [IP camera issue](https://forum.inductiveautomation.com/t/ip-camera-issue/66023)
**Author:** [@athayer](https://forum.inductiveautomation.com/u/athayer)\ **Replies:** 1\ **Last updated:** [November 9, 2022, 9:38pm UTC](https://forum.inductiveautomation.com/t/ip-camera-issue/66023 "2022-11-09T21:38:51Z")
I am trying to use the Web Browser in Vision. I am getting an 'ERR\_CERT\_AUTHORITY\_INVALID' error. I get the same error when using Microsoft Edge but I can override it. Is there any way to do this via the Vision Web Br… --- ## [Licenses required for reporting only](https://forum.inductiveautomation.com/t/licenses-required-for-reporting-only/66303)
**Author:** [@g.jaime](https://forum.inductiveautomation.com/u/g.jaime)\ **Replies:** 3\ **Last updated:** [November 9, 2022, 8:56pm UTC](https://forum.inductiveautomation.com/t/licenses-required-for-reporting-only/66303 "2022-11-09T20:56:40Z")
I have an operation station with FactoryTalk Site Edition and I want to add the functionality to create reports. I want to generate the reports with Ignition. I currently have a SQL Server database. The question I have … --- ## [Database connections faulted due to java.lang.ClassNotFoundException](https://forum.inductiveautomation.com/t/database-connections-faulted-due-to-java-lang-classnotfoundexception/66306)
**Author:** [@L\_F](https://forum.inductiveautomation.com/u/L_F)\ **Replies:** 9\ **Last updated:** [November 9, 2022, 8:10pm UTC](https://forum.inductiveautomation.com/t/database-connections-faulted-due-to-java-lang-classnotfoundexception/66306 "2022-11-09T20:10:00Z")
My gateway (Ignition 8.1.10) has two database connections: the Sample\_SQLite\_Database and Test\_Tag\_DB. The databases have worked very well for a while, but have recently faulted with the following message: java.lang.Cla… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=748) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=750)