# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=871 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 872 --- ## [3D graphs in Perspective?](https://forum.inductiveautomation.com/t/3d-graphs-in-perspective/57192)
**Author:** [@SBL\_MC](https://forum.inductiveautomation.com/u/SBL_MC)\ **Replies:** 6\ **Last updated:** [March 24, 2022, 7:33am UTC](https://forum.inductiveautomation.com/t/3d-graphs-in-perspective/57192 "2022-03-24T07:33:12Z")
Hi all, Has anyone created 3D graphs in the Perspective module? Nader? :smiley: Something like these (stolen from the web): --- ## [Ignition OPC Quick Client not pulling new tags from external OPC Server](https://forum.inductiveautomation.com/t/ignition-opc-quick-client-not-pulling-new-tags-from-external-opc-server/57564)
**Author:** [@B.J](https://forum.inductiveautomation.com/u/B.J)\ **Replies:** 3\ **Last updated:** [March 23, 2022, 10:48pm UTC](https://forum.inductiveautomation.com/t/ignition-opc-quick-client-not-pulling-new-tags-from-external-opc-server/57564 "2022-03-23T22:48:24Z")
I inherited a solution where Ignition OPC-UA server is used to connect to another OPC Server (FASOPC) and it was able to pull tags into Ignition. Recently, I added some new tags to the FASOPC Server and I can read the ta… --- ## ["Virtual Alarms"?](https://forum.inductiveautomation.com/t/virtual-alarms/57555)
**Author:** [@kgamble](https://forum.inductiveautomation.com/u/kgamble)\ **Replies:** 7\ **Last updated:** [March 23, 2022, 10:11pm UTC](https://forum.inductiveautomation.com/t/virtual-alarms/57555 "2022-03-23T22:11:29Z")
With the tag historian, you have the ability to store abstract time series data as a “Virtual Tag” (phrase taken from documentation) via using system.tag.storeTagHistory directly I have recently started on a project, th… --- ## [Gateway Network - Unable To Establish Connection](https://forum.inductiveautomation.com/t/gateway-network-unable-to-establish-connection/57457)
**Author:** [@scott.stamps](https://forum.inductiveautomation.com/u/scott.stamps)\ **Replies:** 2\ **Last updated:** [March 23, 2022, 8:14pm UTC](https://forum.inductiveautomation.com/t/gateway-network-unable-to-establish-connection/57457 "2022-03-23T20:14:09Z")
We have a Gateway (A) which was cloned to give us Gateway (B). Within Config \> Network \> Gateway Network Settings, when attempting to set up a Gateway Network from A \> B, you are presented with the usual options to appr… --- ## [Help With Date Formatting in Report](https://forum.inductiveautomation.com/t/help-with-date-formatting-in-report/57556)
**Author:** [@Ryan\_Corey](https://forum.inductiveautomation.com/u/Ryan_Corey)\ **Replies:** 2\ **Last updated:** [March 23, 2022, 8:00pm UTC](https://forum.inductiveautomation.com/t/help-with-date-formatting-in-report/57556 "2022-03-23T20:00:51Z")
I am using Ignition 8.1.15. I have a date parameter that has an experssion of: dateFormat(“2022-03-07 00:01:00”,“yyyy-MM-dd 00:01:00”) When I drag this parameter onto the report and give it formatting of MMMM d, yyyy … --- ## [Gateway Metrics without a module](https://forum.inductiveautomation.com/t/gateway-metrics-without-a-module/57557)
**Author:** [@kgamble](https://forum.inductiveautomation.com/u/kgamble)\ **Replies:** 0\ **Last updated:** [March 23, 2022, 7:03pm UTC](https://forum.inductiveautomation.com/t/gateway-metrics-without-a-module/57557 "2022-03-23T19:03:46Z")
I know that within a module you can add custom metrics, that can be shown on the gateway webpages dashboard. However I have a project that is using a singleton to manage a bunch of variant threads performing specific ta… --- ## [Please add ids to perspective components for writing tests](https://forum.inductiveautomation.com/t/please-add-ids-to-perspective-components-for-writing-tests/46949)
**Author:** [@tony.petruzzi1](https://forum.inductiveautomation.com/u/tony.petruzzi1)\ **Replies:** 22\ **Last updated:** [March 23, 2022, 6:45pm UTC](https://forum.inductiveautomation.com/t/please-add-ids-to-perspective-components-for-writing-tests/46949 "2022-03-23T18:45:53Z")
I don’t know why this was overlooked during the design of Perspective :face\_with\_raised\_eyebrow: , but this is caused major heartaches when trying to write tests. Currently there is no way to add an id to a component in … --- ## [Two Ignition Projects on Same gateway with different timezones?](https://forum.inductiveautomation.com/t/two-ignition-projects-on-same-gateway-with-different-timezones/57543)
**Author:** [@tmahaf](https://forum.inductiveautomation.com/u/tmahaf)\ **Replies:** 3\ **Last updated:** [March 23, 2022, 6:28pm UTC](https://forum.inductiveautomation.com/t/two-ignition-projects-on-same-gateway-with-different-timezones/57543 "2022-03-23T18:28:07Z")
Project 1 and Project 2 Timezones screenshot of using system.date.getTimezone() from the script console: Both projects have the Perspective timezone set as “Gateway Timezone” I’m missing something here, please he… --- ## [Number format perspective percent](https://forum.inductiveautomation.com/t/number-format-perspective-percent/56675)
**Author:** [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Replies:** 7\ **Last updated:** [March 23, 2022, 6:17pm UTC](https://forum.inductiveautomation.com/t/number-format-perspective-percent/56675 "2022-03-23T18:17:01Z")
trying #0.00’%’ in a table from a query that used Select \* getting 350.00000% instead of 3.5% It is multiplying by 100 even though I am using the quotes. Is this because I am writing it wrong or 8.1.0 doesn’t do this? … --- ## [Reading tags and creating a table - VISION](https://forum.inductiveautomation.com/t/reading-tags-and-creating-a-table-vision/57421)
**Author:** [@Esme\_Lopez](https://forum.inductiveautomation.com/u/Esme_Lopez)\ **Replies:** 30\ **Last updated:** [March 23, 2022, 5:28pm UTC](https://forum.inductiveautomation.com/t/reading-tags-and-creating-a-table-vision/57421 "2022-03-23T17:28:05Z")
Hello everyone, I am reading tags and these tags are visible in a label but I want to save every data in a table to see the all numbers that I am receiving in my label or saving everything in an auxiliar String and then … --- ## [Display Appearance?](https://forum.inductiveautomation.com/t/display-appearance/57547)
**Author:** [@John\_Whited](https://forum.inductiveautomation.com/u/John_Whited)\ **Replies:** 2\ **Last updated:** [March 23, 2022, 5:26pm UTC](https://forum.inductiveautomation.com/t/display-appearance/57547 "2022-03-23T17:26:59Z")
Hi, I have a vision application running in parallel with an existing FactoryTalk HMI application. Both display units are setup the same (resolution, model, brand, etc.) and the application was developed to copy the FT … --- ## [Ms sql compare hours as integer](https://forum.inductiveautomation.com/t/ms-sql-compare-hours-as-integer/57544)
**Author:** [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Replies:** 4\ **Last updated:** [March 23, 2022, 4:13pm UTC](https://forum.inductiveautomation.com/t/ms-sql-compare-hours-as-integer/57544 "2022-03-23T16:13:56Z")
My where clause is throwing errors when I try to see if the hour is after 20. where datepart(Hour,RecordedDate) \> 20 where cast(format(RecordedDate,'HH') as int) \>20 without the where clause the query works fine. --- ## [\[BUG-5699\] Ignition 8.1.15 will not load our Vision Projects](https://forum.inductiveautomation.com/t/bug-5699-ignition-8-1-15-will-not-load-our-vision-projects/57542)
**Author:** [@jtdfan](https://forum.inductiveautomation.com/u/jtdfan)\ **Replies:** 1\ **Last updated:** [March 23, 2022, 3:42pm UTC](https://forum.inductiveautomation.com/t/bug-5699-ignition-8-1-15-will-not-load-our-vision-projects/57542 "2022-03-23T15:42:44Z")
Our vision clients are failing to load after the Igntition 8.1.15 upgrade. Here is the error we are receiving. Any ideas? com.inductiveautomation.ignition.common.xmlserialization.SerializationException: Error deserializ… --- ## [HttpPost to API using Dictionary](https://forum.inductiveautomation.com/t/httppost-to-api-using-dictionary/57532)
**Author:** [@RonB](https://forum.inductiveautomation.com/u/RonB)\ **Replies:** 11\ **Last updated:** [March 23, 2022, 2:54pm UTC](https://forum.inductiveautomation.com/t/httppost-to-api-using-dictionary/57532 "2022-03-23T14:54:41Z")
postDictionary is being compiled from two separate lists using zip in a for loop. Result is: {‘Barcode1’: ‘0190076338816517320100078911220322213609008158’, ‘Barcode2’: ‘0190076338816517320100079111220322213609008157’,… --- ## [Multiple clients editing/viewing same form/database](https://forum.inductiveautomation.com/t/multiple-clients-editing-viewing-same-form-database/57335)
**Author:** [@rpavlicek](https://forum.inductiveautomation.com/u/rpavlicek)\ **Replies:** 2\ **Last updated:** [March 23, 2022, 2:49pm UTC](https://forum.inductiveautomation.com/t/multiple-clients-editing-viewing-same-form-database/57335 "2022-03-23T14:49:27Z")
In Vision (8.1.10), what would be the best way to handle multiple users editing or viewing a form and still updating live values as they change? It’s similar to this thread - multiple users/clients single database, but … --- ## [Event - perspective page fully loaded](https://forum.inductiveautomation.com/t/event-perspective-page-fully-loaded/57506)
**Author:** [@mojoeswa](https://forum.inductiveautomation.com/u/mojoeswa)\ **Replies:** 23\ **Last updated:** [March 23, 2022, 2:30pm UTC](https://forum.inductiveautomation.com/t/event-perspective-page-fully-loaded/57506 "2022-03-23T14:30:16Z")
Hi. I want to activate a script when a page has finished loading in perspective. How can I do that? I have a parameter on the page to which I send a value. I want a script to run when the value of the parameter changes.… --- ## [Source of builtin images? Accidentally deleted one](https://forum.inductiveautomation.com/t/source-of-builtin-images-accidentally-deleted-one/57527)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 4\ **Last updated:** [March 23, 2022, 1:49pm UTC](https://forum.inductiveautomation.com/t/source-of-builtin-images-accidentally-deleted-one/57527 "2022-03-23T13:49:46Z")
Coworker was making changes to a button. This image Builtin/icons/16/exit.png was referenced in the image label path. She went to erase it from the property, it asked her if she wanted to delete it, and it apparently d… --- ## [Update table content after httpDelete is called](https://forum.inductiveautomation.com/t/update-table-content-after-httpdelete-is-called/57513)
**Author:** [@Marouene\_Dakhlaoui](https://forum.inductiveautomation.com/u/Marouene_Dakhlaoui)\ **Replies:** 11\ **Last updated:** [March 23, 2022, 1:37pm UTC](https://forum.inductiveautomation.com/t/update-table-content-after-httpdelete-is-called/57513 "2022-03-23T13:37:52Z")
Hello, I have a table that is getting data from a get API, under the table I have created a delete button that takes the ID of the selected row and runs a httpDelete to delete that row. While the HTTPDelte is working fi… --- ## [Time query of the maximum value of a Calculation Query Tag in the report](https://forum.inductiveautomation.com/t/time-query-of-the-maximum-value-of-a-calculation-query-tag-in-the-report/57517)
**Author:** [@Jefferson\_Nascimento](https://forum.inductiveautomation.com/u/Jefferson_Nascimento)\ **Replies:** 4\ **Last updated:** [March 23, 2022, 1:26pm UTC](https://forum.inductiveautomation.com/t/time-query-of-the-maximum-value-of-a-calculation-query-tag-in-the-report/57517 "2022-03-23T13:26:27Z")
Hi, In the report, I’m using the Tag Calculaion Query query type, querying the Maximo of a tag. The value of this tag is ok, but in addition to the value, I also need to consult the recording time of that value. How to … --- ## [Perspective Table Pager Locale](https://forum.inductiveautomation.com/t/perspective-table-pager-locale/57525)
**Author:** [@SMcIntosh](https://forum.inductiveautomation.com/u/SMcIntosh)\ **Replies:** 1\ **Last updated:** [March 23, 2022, 12:48pm UTC](https://forum.inductiveautomation.com/t/perspective-table-pager-locale/57525 "2022-03-23T12:48:50Z")
I’ve been able to work through the problem of localization for most of the assets within perspective tables, but I have been running into difficulties translating the “rows” pagination text. Is there any way to localize … --- ## [Transform the value of a reference tag with a script](https://forum.inductiveautomation.com/t/transform-the-value-of-a-reference-tag-with-a-script/57519)
**Author:** [@jamesennis](https://forum.inductiveautomation.com/u/jamesennis)\ **Replies:** 2\ **Last updated:** [March 23, 2022, 12:29pm UTC](https://forum.inductiveautomation.com/t/transform-the-value-of-a-reference-tag-with-a-script/57519 "2022-03-23T12:29:10Z")
Hello, I am wondering whether there is a good way to transform the value of a reference tag using a Python script? Just like we can do with property bindings in Perspective. As an example, let’s say I have the memory t… --- ## [Any ideas for including GPS track in report and dashboard?](https://forum.inductiveautomation.com/t/any-ideas-for-including-gps-track-in-report-and-dashboard/57523)
**Author:** [@johannes.bo](https://forum.inductiveautomation.com/u/johannes.bo)\ **Replies:** 0\ **Last updated:** [March 23, 2022, 12:09pm UTC](https://forum.inductiveautomation.com/t/any-ideas-for-including-gps-track-in-report-and-dashboard/57523 "2022-03-23T12:09:58Z")
Hi all, My priority goal is to generate a report containing both a trace of the GPS position of a vessel and some tabular data for a given period. I would like to create a page in my Vision application showing a map an… --- ## [Perspective Query Binding - Performance Question](https://forum.inductiveautomation.com/t/perspective-query-binding-performance-question/57484)
**Author:** [@Joe\_Kelly](https://forum.inductiveautomation.com/u/Joe_Kelly)\ **Replies:** 3\ **Last updated:** [March 23, 2022, 11:17am UTC](https://forum.inductiveautomation.com/t/perspective-query-binding-performance-question/57484 "2022-03-23T11:17:47Z")
I have an XY chart that has 2 series that each relate to a single Named Query. It’s actually the Paretto chart from the IA Exchange. Currently, one dataset has a query binding that grabs the data, but then there’s a tr… --- ## [Designer launcher can't find localhost](https://forum.inductiveautomation.com/t/designer-launcher-cant-find-localhost/25757)
**Author:** [@indenkleefj](https://forum.inductiveautomation.com/u/indenkleefj)\ **Replies:** 12\ **Last updated:** [March 23, 2022, 7:50am UTC](https://forum.inductiveautomation.com/t/designer-launcher-cant-find-localhost/25757 "2022-03-23T07:50:57Z")
Hi, I want to use the Designer launcher to start the designer of my localhost. This works when i am in the office using Wi-Fi. But when i’m using my mobile hotspot at an customer i can’t find my localhost. Do i need … --- ## [Ignition gateway](https://forum.inductiveautomation.com/t/ignition-gateway/52655)
**Author:** [@ahmadmaftuhin11](https://forum.inductiveautomation.com/u/ahmadmaftuhin11)\ **Replies:** 2\ **Last updated:** [March 23, 2022, 7:52am UTC](https://forum.inductiveautomation.com/t/ignition-gateway/52655 "2022-03-23T07:52:56Z")
why can’t i log in to ignition gateway. I’ve tried to stop ignition and start again…but the result is the same? --- ## [Different datetime data types when running script in designer and on gateway as "gateway event script"](https://forum.inductiveautomation.com/t/different-datetime-data-types-when-running-script-in-designer-and-on-gateway-as-gateway-event-script/57373)
**Author:** [@szcz](https://forum.inductiveautomation.com/u/szcz)\ **Replies:** 6\ **Last updated:** [March 23, 2022, 6:56am UTC](https://forum.inductiveautomation.com/t/different-datetime-data-types-when-running-script-in-designer-and-on-gateway-as-gateway-event-script/57373 "2022-03-23T06:56:57Z")
Hi all, we have Ignition 7.9.16 running on Windows Server 2019 with OpenJDK. Now, after enjoying several hours of bug hunting, I came to interesting conclusion. Let’s say I want to populate 2 variables: One variable g… --- ## [S7-1500 driver issue](https://forum.inductiveautomation.com/t/s7-1500-driver-issue/57460)
**Author:** [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\ **Replies:** 0\ **Last updated:** [March 22, 2022, 3:02pm UTC](https://forum.inductiveautomation.com/t/s7-1500-driver-issue/57460 "2022-03-22T15:02:20Z")
I’m using Ignition version 8.1.13 on a S7-1500 PLC. One of the PLC’s datablocks have up to 1200 variables, first half DINT, second half REAL. In the REAL part of the datablock I’m experiencing the following issue: suppos… --- ## [Vision PowerTable table edit abnormal](https://forum.inductiveautomation.com/t/vision-powertable-table-edit-abnormal/57497)
**Author:** [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\ **Replies:** 0\ **Last updated:** [March 23, 2022, 6:28am UTC](https://forum.inductiveautomation.com/t/vision-powertable-table-edit-abnormal/57497 "2022-03-23T06:28:19Z")
I have a scripting for a vision table to edit the cell, here is the scripting id = self.data.getValueAt(rowIndex, 'id') query = "UPDATE \[dbo\].\[NTSplice\_DATA\] SET %s = ? WHERE \[id\] = ?" % (colName) args = \[newValue… --- ## [Audit Profile Data Store and Forward errors: com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated](https://forum.inductiveautomation.com/t/audit-profile-data-store-and-forward-errors-com-microsoft-sqlserver-jdbc-sqlserverexception-string-or-binary-data-would-be-truncated/57401)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 2\ **Last updated:** [March 22, 2022, 11:58pm UTC](https://forum.inductiveautomation.com/t/audit-profile-data-store-and-forward-errors-com-microsoft-sqlserver-jdbc-sqlserverexception-string-or-binary-data-would-be-truncated/57401 "2022-03-22T23:58:28Z")
I’m trying to work out why I’m getting truncation errors in some audit log inserts as reported by S+F, but the exported quarantine XML of the errors is all encrypted. How can I find out exactly what queries are failing s… --- ## [Python Script to convert varbinary in SQL Server to base64 for Perspective Image Component](https://forum.inductiveautomation.com/t/python-script-to-convert-varbinary-in-sql-server-to-base64-for-perspective-image-component/57478)
**Author:** [@tmahaf](https://forum.inductiveautomation.com/u/tmahaf)\ **Replies:** 4\ **Last updated:** [March 22, 2022, 11:19pm UTC](https://forum.inductiveautomation.com/t/python-script-to-convert-varbinary-in-sql-server-to-base64-for-perspective-image-component/57478 "2022-03-22T23:19:21Z")
I have file data stored in my database as varbinary. Sometimes the files are images. I want my image component to display the images, but I think I’m having an issue converting from the varbinary data to base64. I can co… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=870) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=872)