# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=387 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 388 --- ## [0 values after casting varchar(50) to float in named query](https://forum.inductiveautomation.com/t/0-values-after-casting-varchar-50-to-float-in-named-query/92317)
**Author:** [@Rafal\_Samoraj](https://forum.inductiveautomation.com/u/Rafal_Samoraj)\ **Replies:** 2\ **Last updated:** [June 25, 2024, 9:46am UTC](https://forum.inductiveautomation.com/t/0-values-after-casting-varchar-50-to-float-in-named-query/92317 "2024-06-25T09:46:47Z")
Hello, In my named query I casted column ExternalLeakTestBackgroundResultmbarls which is varchar(50) to float. My column contain scientific notation of values. In SSMS it ok but in Ignition don\`t. My named query is: S… --- ## [Show the current screen button as Active in header](https://forum.inductiveautomation.com/t/show-the-current-screen-button-as-active-in-header/92302)
**Author:** [@Jon\_Martin](https://forum.inductiveautomation.com/u/Jon_Martin)\ **Replies:** 4\ **Last updated:** [June 25, 2024, 8:47am UTC](https://forum.inductiveautomation.com/t/show-the-current-screen-button-as-active-in-header/92302 "2024-06-25T08:47:32Z")
I have a header with multiple buttons so I can navigate different screens. I want the current screen button to be active. This is normally very easy with CSS but I am not seeing how to do this in Ignition. --- ## [\[BUG\] Adding documentation to Perspective View wipes all unsaved changes in open View](https://forum.inductiveautomation.com/t/bug-adding-documentation-to-perspective-view-wipes-all-unsaved-changes-in-open-view/92308)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 2\ **Last updated:** [June 25, 2024, 5:44am UTC](https://forum.inductiveautomation.com/t/bug-adding-documentation-to-perspective-view-wipes-all-unsaved-changes-in-open-view/92308 "2024-06-25T05:44:20Z")
v8.1.22 Not sure if this has been fixed yet, but I found out the hard way that when editing a View without saving (yet) and then adding documentation to the View and Committing the doco addition will reload the View in … --- ## [Alarm journal not showing AM/PM on client](https://forum.inductiveautomation.com/t/alarm-journal-not-showing-am-pm-on-client/92301)
**Author:** [@michael.black](https://forum.inductiveautomation.com/u/michael.black)\ **Replies:** 3\ **Last updated:** [June 25, 2024, 5:09am UTC](https://forum.inductiveautomation.com/t/alarm-journal-not-showing-am-pm-on-client/92301 "2024-06-25T05:09:24Z")
I am using an alarm journal on vision project, version 8.1.26. Whenever I run the screen within the project, both running and not running, it shows AM/PM. Whenever I run the screen on the actual client AM?PM goes away.… --- ## [Sparkline Aspect Ratio](https://forum.inductiveautomation.com/t/sparkline-aspect-ratio/92283)
**Author:** [@Andrew\_Hensley](https://forum.inductiveautomation.com/u/Andrew_Hensley)\ **Replies:** 5\ **Last updated:** [June 25, 2024, 5:22am UTC](https://forum.inductiveautomation.com/t/sparkline-aspect-ratio/92283 "2024-06-25T05:22:49Z")
Hello community! I've been having difficulties with the aspect ratio or positioning on some of my Sparklines in my project. I have a Sparkline overlayed on a Cylindrical Tank. I'm having issues with it displaying appropr… --- ## [Google Map Layers Won't Display](https://forum.inductiveautomation.com/t/google-map-layers-wont-display/92264)
**Author:** [@Eric\_Bauer](https://forum.inductiveautomation.com/u/Eric_Bauer)\ **Replies:** 2\ **Last updated:** [June 25, 2024, 1:31am UTC](https://forum.inductiveautomation.com/t/google-map-layers-wont-display/92264 "2024-06-25T01:31:49Z")
Hello, I am working on a project that uses the Google maps component. I have the map displaying, but I need to add a circle. This seems like a simple thing to so, but I can't see to make it happen. Here is how I have… --- ## [Script to create a new user and add them to a role?](https://forum.inductiveautomation.com/t/script-to-create-a-new-user-and-add-them-to-a-role/92303)
**Author:** [@Jason\_Crockett](https://forum.inductiveautomation.com/u/Jason_Crockett)\ **Replies:** 11\ **Last updated:** [June 24, 2024, 11:12pm UTC](https://forum.inductiveautomation.com/t/script-to-create-a-new-user-and-add-them-to-a-role/92303 "2024-06-24T23:12:01Z")
I am the worst with scripting. I am sure someone has already created a working script to create a new user and add them to a role. I've been trying all day but have not moved forward at all. I've used many posts here in… --- ## [Logger not logging](https://forum.inductiveautomation.com/t/logger-not-logging/92299)
**Author:** [@Herbert\_Augustiny](https://forum.inductiveautomation.com/u/Herbert_Augustiny)\ **Replies:** 7\ **Last updated:** [June 24, 2024, 10:11pm UTC](https://forum.inductiveautomation.com/t/logger-not-logging/92299 "2024-06-24T22:11:13Z")
Hi All I have a wired situation. At some areas in scripting, the logger functionality works, but wathever I try to make new, I never get anything to log. Now I tried in the Script console the following code: logger = s… --- ## [TimeSeries graph for 160 different robots](https://forum.inductiveautomation.com/t/timeseries-graph-for-160-different-robots/92254)
**Author:** [@thomas\_wallace](https://forum.inductiveautomation.com/u/thomas_wallace)\ **Replies:** 5\ **Last updated:** [June 24, 2024, 9:55pm UTC](https://forum.inductiveautomation.com/t/timeseries-graph-for-160-different-robots/92254 "2024-06-24T21:55:46Z")
I have a status screen of 160 battery powered AGVs. I made a timeline graph that you access by clicking on the voltage status of the AGV. I want to make a graph for each AGV. How can I do this without making 160 individu… --- ## [\[Feature Request\] - Moveable x-trace infobox](https://forum.inductiveautomation.com/t/feature-request-moveable-x-trace-infobox/92305)
**Author:** [@Adam\_Portmann](https://forum.inductiveautomation.com/u/Adam_Portmann)\ **Replies:** 0\ **Last updated:** [June 24, 2024, 9:16pm UTC](https://forum.inductiveautomation.com/t/feature-request-moveable-x-trace-infobox/92305 "2024-06-24T21:16:35Z")
I have done several searches and haven't come across this a feature request before now, which is surprising. It would be great to have the x-trace infobox moveable. There are times when I have to place several x-trace pi… --- ## [Locked out - urgent](https://forum.inductiveautomation.com/t/locked-out-urgent/38943)
**Author:** [@vipo](https://forum.inductiveautomation.com/u/vipo)\ **Replies:** 12\ **Last updated:** [June 24, 2024, 8:05pm UTC](https://forum.inductiveautomation.com/t/locked-out-urgent/38943 "2024-06-24T20:05:19Z")
So I was messing around with Identity Providers… And somehow, I’m now locked out of the gateway. Is there a way to set the IDP back to default, through CLI or some xml config file on the gateway itself ? Please help… … --- ## [Open View when Tag Changed](https://forum.inductiveautomation.com/t/open-view-when-tag-changed/92252)
**Author:** [@Francisco\_Ochoa](https://forum.inductiveautomation.com/u/Francisco_Ochoa)\ **Replies:** 26\ **Last updated:** [June 24, 2024, 5:30pm UTC](https://forum.inductiveautomation.com/t/open-view-when-tag-changed/92252 "2024-06-24T17:30:58Z")
Hello everyone. If anyone could help me. I want to open views/windows on Perspective when any tag (boolean) has change its value from OPC Tags. I was trying on tag editor window with the scripts of this forum but i can… --- ## [Create JSON Message format from tags](https://forum.inductiveautomation.com/t/create-json-message-format-from-tags/87868)
**Author:** [@Adekunle\_Bakare](https://forum.inductiveautomation.com/u/Adekunle_Bakare)\ **Replies:** 7\ **Last updated:** [March 25, 2024, 9:23pm UTC](https://forum.inductiveautomation.com/t/create-json-message-format-from-tags/87868 "2024-03-25T21:23:20Z")
I am still learning Ignition. Please I am trying to convert some set of tags (Picture 1) to Json format that I can send to our MES system in this format {"device": "CMN\_WELD", "good": 10, "bad": 0,"scrap": 1, "lot": "lot… --- ## [System Logs max events](https://forum.inductiveautomation.com/t/system-logs-max-events/92278)
**Author:** [@kaushik.shah](https://forum.inductiveautomation.com/u/kaushik.shah)\ **Replies:** 3\ **Last updated:** [June 24, 2024, 5:11pm UTC](https://forum.inductiveautomation.com/t/system-logs-max-events/92278 "2024-06-24T17:11:03Z")
Does anyone point on what am I missing? I made sure the logback.xml has 50000 max events configured for appender but the log file just keeps growing --- ## [Perspective XY Chart Duration Axis](https://forum.inductiveautomation.com/t/perspective-xy-chart-duration-axis/92287)
**Author:** [@Shane\_Peters](https://forum.inductiveautomation.com/u/Shane_Peters)\ **Replies:** 0\ **Last updated:** [June 24, 2024, 4:42pm UTC](https://forum.inductiveautomation.com/t/perspective-xy-chart-duration-axis/92287 "2024-06-24T16:42:21Z")
Is there anyway to use the Duration Axis for the XYChart. It exists in the amchart object but can Ignition use it? --- ## [Break script execution](https://forum.inductiveautomation.com/t/break-script-execution/92277)
**Author:** [@Vatsal\_Shah](https://forum.inductiveautomation.com/u/Vatsal_Shah)\ **Replies:** 11\ **Last updated:** [June 24, 2024, 3:18pm UTC](https://forum.inductiveautomation.com/t/break-script-execution/92277 "2024-06-24T15:18:41Z")
I have a script in my project library which I'm calling it whenever the session is launched. That script takes some time for execution. I want to break the script and navigate the user to a different URL if the script … --- ## [Export or copy Microsoft SQL Server data from Ignition?](https://forum.inductiveautomation.com/t/export-or-copy-microsoft-sql-server-data-from-ignition/91706)
**Author:** [@Arnold\_Harrison](https://forum.inductiveautomation.com/u/Arnold_Harrison)\ **Replies:** 5\ **Last updated:** [June 24, 2024, 2:25pm UTC](https://forum.inductiveautomation.com/t/export-or-copy-microsoft-sql-server-data-from-ignition/91706 "2024-06-24T14:25:53Z")
How can I export or copy my entire Microsoft SQL Server data from Ignition? --- ## [Assistance with PLC Tag Display Adjustments and tag histogram](https://forum.inductiveautomation.com/t/assistance-with-plc-tag-display-adjustments-and-tag-histogram/92279)
**Author:** [@Rajashekar\_Reddy](https://forum.inductiveautomation.com/u/Rajashekar_Reddy)\ **Replies:** 2\ **Last updated:** [June 24, 2024, 1:40pm UTC](https://forum.inductiveautomation.com/t/assistance-with-plc-tag-display-adjustments-and-tag-histogram/92279 "2024-06-24T13:40:54Z")
Hi. I am reaching out to seek assistance with the Perspective module. I need to display a tag that incorporates mathematical calculations to adjust the raw value obtained from a PLC. For instance, the raw value display… --- ## [Question about the organization and configuration of security to project resources by different users](https://forum.inductiveautomation.com/t/question-about-the-organization-and-configuration-of-security-to-project-resources-by-different-users/92274)
**Author:** [@Michal\_Goralczyk](https://forum.inductiveautomation.com/u/Michal_Goralczyk)\ **Replies:** 1\ **Last updated:** [June 24, 2024, 11:11am UTC](https://forum.inductiveautomation.com/t/question-about-the-organization-and-configuration-of-security-to-project-resources-by-different-users/92274 "2024-06-24T11:11:07Z")
Hello, I have one main Ignition project from which resources are inherited to other projects. These projects that inherit from the main project are for different companies. They are created for client accounts in our do… --- ## [Ribbon Chart Data Query Issue](https://forum.inductiveautomation.com/t/ribbon-chart-data-query-issue/37190)
**Author:** [@justin.casleton](https://forum.inductiveautomation.com/u/justin.casleton)\ **Replies:** 5\ **Last updated:** [June 24, 2024, 11:09am UTC](https://forum.inductiveautomation.com/t/ribbon-chart-data-query-issue/37190 "2024-06-24T11:09:45Z")
Hello, I am using an XY chart to display a ribbon chart that shows uptime/downtime of a machine. I am trying to use a dropdown to show data from the past day or past week based on selected option. Right now when I use … --- ## [\[Feature-4637\]idpAttributes Session Property](https://forum.inductiveautomation.com/t/feature-4637-idpattributes-session-property/60323)
**Author:** [@zacht](https://forum.inductiveautomation.com/u/zacht)\ **Replies:** 7\ **Last updated:** [June 24, 2024, 8:13am UTC](https://forum.inductiveautomation.com/t/feature-4637-idpattributes-session-property/60323 "2024-06-24T08:13:23Z")
We're using a SAML identity provider (Azure in this case). It would be convenient to get all the information provided by the IdP in one of my Perspective projects. The user manual suggests that the idpAttributes session … --- ## [Gateway Update 3.1.41: MS JDBC Auth Drivers are deleted](https://forum.inductiveautomation.com/t/gateway-update-3-1-41-ms-jdbc-auth-drivers-are-deleted/91128)
**Author:** [@diamond](https://forum.inductiveautomation.com/u/diamond)\ **Replies:** 14\ **Last updated:** [June 24, 2024, 7:55am UTC](https://forum.inductiveautomation.com/t/gateway-update-3-1-41-ms-jdbc-auth-drivers-are-deleted/91128 "2024-06-24T07:55:43Z")
Hello I just upgraded from Ignition 3.1.40 to Ignition 3.1.41, and noticed that the JDBC Auth drivers I installed (mssql-jdbc\_auth-9.4.0.x64, for Microsoft Integrated Authentication) have been deleted. Would it be possi… --- ## [Finding data type of Tag Path](https://forum.inductiveautomation.com/t/finding-data-type-of-tag-path/18328)
**Author:** [@harigobu.gb](https://forum.inductiveautomation.com/u/harigobu.gb)\ **Replies:** 10\ **Last updated:** [June 24, 2024, 7:41am UTC](https://forum.inductiveautomation.com/t/finding-data-type-of-tag-path/18328 "2024-06-24T07:41:59Z")
Hi, I am getting tag path from dataset column, then storing it to a variable. data = event.source.data tagPath = data.getValueAt(ClickedItem, "tagPath") For Eg. Value in tagPath variable will be like Pumps/Motor 1 N… --- ## [httpClient not sending proxy creditials](https://forum.inductiveautomation.com/t/httpclient-not-sending-proxy-creditials/72276)
**Author:** [@Brandon\_Bunch](https://forum.inductiveautomation.com/u/Brandon_Bunch)\ **Replies:** 5\ **Last updated:** [June 24, 2024, 4:31am UTC](https://forum.inductiveautomation.com/t/httpclient-not-sending-proxy-creditials/72276 "2024-06-24T04:31:08Z")
Hey all, I have a conundrum. Below is the API call I make using the httpClient and sending the proxy info, but i worked with the proxy team and it doesn't send the actual proxy username and password with the request, but… --- ## [Clients locking up, typically on accept update](https://forum.inductiveautomation.com/t/clients-locking-up-typically-on-accept-update/92258)
**Author:** [@robertm](https://forum.inductiveautomation.com/u/robertm)\ **Replies:** 8\ **Last updated:** [June 24, 2024, 2:54am UTC](https://forum.inductiveautomation.com/t/clients-locking-up-typically-on-accept-update/92258 "2024-06-24T02:54:20Z")
I have one app, running on two clients, and they have both locked up during update pushes. One PC is an onlogic, with 4GB, the other a thinkcenter with 8GB. I did find that the client setting in the project was default… --- ## [Create custom Alarm Event Table](https://forum.inductiveautomation.com/t/create-custom-alarm-event-table/92261)
**Author:** [@Eugene49](https://forum.inductiveautomation.com/u/Eugene49)\ **Replies:** 5\ **Last updated:** [June 23, 2024, 8:33pm UTC](https://forum.inductiveautomation.com/t/create-custom-alarm-event-table/92261 "2024-06-23T20:33:36Z")
To Ignition Alarm Expert: When an alarm became active, acknowledged or cleared, it will create a new row on Alarm Event Table on Database. I want to create my own table, for the alarms to be written to, similar to the … --- ## [Make a table's cell editable conditionally](https://forum.inductiveautomation.com/t/make-a-tables-cell-editable-conditionally/86968)
**Author:** [@Ajay\_Gupta](https://forum.inductiveautomation.com/u/Ajay_Gupta)\ **Replies:** 4\ **Last updated:** [June 23, 2024, 5:11pm UTC](https://forum.inductiveautomation.com/t/make-a-tables-cell-editable-conditionally/86968 "2024-06-23T17:11:00Z")
Hi, Is it possible to make a certain cell in a table editable or non-editable based on certain condition? Ex:- If I have a table which has 5 row and 5 cols. I want to check if cell at row #3, Col#2 has a particular val… --- ## [Alarm Status Table - Sort by state](https://forum.inductiveautomation.com/t/alarm-status-table-sort-by-state/45789)
**Author:** [@AnthonyF](https://forum.inductiveautomation.com/u/AnthonyF)\ **Replies:** 4\ **Last updated:** [June 23, 2024, 1:43pm UTC](https://forum.inductiveautomation.com/t/alarm-status-table-sort-by-state/45789 "2024-06-23T13:43:32Z")
Can anyone shed some light on how to sort the Alarm Status Table in Perspective? I’ve tried to sort by state (descending), but for some reason Active & Ack’d is listed first then Active & Unack’d, which is the opposite … --- ## [Help designing unit tests?](https://forum.inductiveautomation.com/t/help-designing-unit-tests/68544)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 6\ **Last updated:** [June 23, 2024, 11:54am UTC](https://forum.inductiveautomation.com/t/help-designing-unit-tests/68544 "2024-06-23T11:54:26Z")
How do people write unit tests with Ignition? I have finally, FINALLY, refactored this project and completely decoupled the business logic from the GUI and so the first thing I want to do is write some unit tests so any… --- ## [Customizing Text Data Storage in HISTORY](https://forum.inductiveautomation.com/t/customizing-text-data-storage-in-history/92249)
**Author:** [@Pofer\_Wang](https://forum.inductiveautomation.com/u/Pofer_Wang)\ **Replies:** 3\ **Last updated:** [June 23, 2024, 1:06am UTC](https://forum.inductiveautomation.com/t/customizing-text-data-storage-in-history/92249 "2024-06-23T01:06:33Z")
Hello everyone, I have a question about the HISTORY feature. Currently, I have a boolean data type, and I am using the HISTORY feature to store data in the "ON CHANGE" mode. However, the stored data is in the form of … [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=386) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=388)