# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=647 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 648 --- ## [Getting session custom property in Gateway Timer Script](https://forum.inductiveautomation.com/t/getting-session-custom-property-in-gateway-timer-script/73778)
**Author:** [@John\_John](https://forum.inductiveautomation.com/u/John_John)\ **Replies:** 7\ **Last updated:** [May 17, 2023, 1:26pm UTC](https://forum.inductiveautomation.com/t/getting-session-custom-property-in-gateway-timer-script/73778 "2023-05-17T13:26:19Z")
Can anyone suggest how to get the session custom property and the logged in user name in the gateway timer script? Thanks --- ## [OPC-AE support](https://forum.inductiveautomation.com/t/opc-ae-support/7797)
**Author:** [@jypsilantis](https://forum.inductiveautomation.com/u/jypsilantis)\ **Replies:** 13\ **Last updated:** [May 17, 2023, 12:27pm UTC](https://forum.inductiveautomation.com/t/opc-ae-support/7797 "2023-05-17T12:27:36Z")
I am currently assessing Ignition as a middleware option to allow bridging of SCADA data for external application interface. Specifically, I am interested in using OPC-UA as a common interface standard for this, as it is… --- ## [Display a single result Query](https://forum.inductiveautomation.com/t/display-a-single-result-query/73795)
**Author:** [@hw79](https://forum.inductiveautomation.com/u/hw79)\ **Replies:** 20\ **Last updated:** [May 17, 2023, 12:14pm UTC](https://forum.inductiveautomation.com/t/display-a-single-result-query/73795 "2023-05-17T12:14:40Z")
I'm running a query in which I only expect one row to match the WHERE clauses. I want to display this as a "card" in my perspective view. \*I'm using DISTI|NCT in the SELECT clause to help clean up the result. What wou… --- ## [Perspective Breakpoint qeustion](https://forum.inductiveautomation.com/t/perspective-breakpoint-qeustion/73821)
**Author:** [@jiyoung\_hwang1](https://forum.inductiveautomation.com/u/jiyoung_hwang1)\ **Replies:** 1\ **Last updated:** [May 17, 2023, 8:09am UTC](https://forum.inductiveautomation.com/t/perspective-breakpoint-qeustion/73821 "2023-05-17T08:09:54Z")
Hi. When running as a lunch project, I want to make the side menu on the left invisible when it gets smaller, such as "Picture No. 3." So I put a invisible script in "Picture No. 2." However, as soon as the lun… --- ## [Ignition Alarm Journal component going into error](https://forum.inductiveautomation.com/t/ignition-alarm-journal-component-going-into-error/73205)
**Author:** [@rkumar](https://forum.inductiveautomation.com/u/rkumar)\ **Replies:** 4\ **Last updated:** [May 17, 2023, 7:53am UTC](https://forum.inductiveautomation.com/t/ignition-alarm-journal-component-going-into-error/73205 "2023-05-17T07:53:08Z")
Hello, We are trying to use Ignition Alarm Journal component but it is going into error. We are using Oracle database for storing the journal data. Initially we thought that it is date parameter issue which is being pa… --- ## [Error Font (Vietnamese) When import to power table in ignition](https://forum.inductiveautomation.com/t/error-font-vietnamese-when-import-to-power-table-in-ignition/73632)
**Author:** [@haidang2015007](https://forum.inductiveautomation.com/u/haidang2015007)\ **Replies:** 6\ **Last updated:** [May 17, 2023, 7:08am UTC](https://forum.inductiveautomation.com/t/error-font-vietnamese-when-import-to-power-table-in-ignition/73632 "2023-05-17T07:08:52Z")
I have an Excel file, I save as it to csv file ( CSV UTF-8). When i import to power table using code below: " import csv path = system.file.openFile("csv") csvData = csv.reader(open(path)) header = csvData.next() d… --- ## [XYChart scrollbar issue - extra X-axis labels showing up](https://forum.inductiveautomation.com/t/xychart-scrollbar-issue-extra-x-axis-labels-showing-up/73380)
**Author:** [@Jay\_Baker](https://forum.inductiveautomation.com/u/Jay_Baker)\ **Replies:** 3\ **Last updated:** [May 17, 2023, 5:57am UTC](https://forum.inductiveautomation.com/t/xychart-scrollbar-issue-extra-x-axis-labels-showing-up/73380 "2023-05-17T05:57:30Z")
I've got a little stacked bar graph which shows plant state over time, with a scrollbar to zoom in with: On first loading the page, it works great. However - when I refresh the source data (which happens via a bindin… --- ## [Implementation question](https://forum.inductiveautomation.com/t/implementation-question/73748)
**Author:** [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Replies:** 4\ **Last updated:** [May 17, 2023, 12:32am UTC](https://forum.inductiveautomation.com/t/implementation-question/73748 "2023-05-17T00:32:40Z")
I want to open a popup task list in the browser when a user opens a certain page. I want to populate this popup page the names of the pages they have looked at recently. Are these two things something I can do for user… --- ## [Multiple Popups](https://forum.inductiveautomation.com/t/multiple-popups/73763)
**Author:** [@PRASHANTH\_KAKKIRALA](https://forum.inductiveautomation.com/u/PRASHANTH_KAKKIRALA)\ **Replies:** 6\ **Last updated:** [May 17, 2023, 12:23am UTC](https://forum.inductiveautomation.com/t/multiple-popups/73763 "2023-05-17T00:23:17Z")
Ignition Perspective is not allowing to view multiple popups on single view/session. Is there any setting which will change this behavior. ? I tried both script and popup actions from a Button click. --- ## [Product Tracking/Gap Table Creation](https://forum.inductiveautomation.com/t/product-tracking-gap-table-creation/72794)
**Author:** [@Andrew\_Kitson](https://forum.inductiveautomation.com/u/Andrew_Kitson)\ **Replies:** 1\ **Last updated:** [May 16, 2023, 11:01pm UTC](https://forum.inductiveautomation.com/t/product-tracking-gap-table-creation/72794 "2023-05-16T23:01:13Z")
Hey Everyone, I have a piece of equipment used for washing product as a group through multiple stages. The machine has one conveyor from start to finish. When the machine runs the conveyor is always 100% full and if the… --- ## [Ignition Historian Query Data](https://forum.inductiveautomation.com/t/ignition-historian-query-data/73377)
**Author:** [@mandeep\_gill](https://forum.inductiveautomation.com/u/mandeep_gill)\ **Replies:** 1\ **Last updated:** [May 16, 2023, 10:59pm UTC](https://forum.inductiveautomation.com/t/ignition-historian-query-data/73377 "2023-05-16T22:59:01Z")
Hi I am trying to understand how historian module handles the data. Current Version of ignition vision 8.1.17 . windows server 2019 on VM. Data is logged into historian and then going to SQL server (separate server). … --- ## [Calling Stored Procedure](https://forum.inductiveautomation.com/t/calling-stored-procedure/73809)
**Author:** [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\ **Replies:** 4\ **Last updated:** [May 16, 2023, 10:51pm UTC](https://forum.inductiveautomation.com/t/calling-stored-procedure/73809 "2023-05-16T22:51:49Z")
I am attempting to call an SP using a button script event, and testing using a Named Query. Server: MSSQL Button Script: def runAction(self, event): item = self.parent.parent.getChild("Spacer\_1").getChild("Label\_0").… --- ## [\[FEATURE\]Log tag edits for alarm changes](https://forum.inductiveautomation.com/t/feature-log-tag-edits-for-alarm-changes/52565)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 1\ **Last updated:** [May 16, 2023, 10:40pm UTC](https://forum.inductiveautomation.com/t/feature-log-tag-edits-for-alarm-changes/52565 "2023-05-16T22:40:38Z")
The audit logging of changes to alarm configuration of a tag is non-functional. It would be great if this could be fixed and show what actually changed. This is how it is now: TagEdit\[path=\[default\]Testing/expression, … --- ## [Call MSSQL Stored Procedure from Gateway Event Script](https://forum.inductiveautomation.com/t/call-mssql-stored-procedure-from-gateway-event-script/45059)
**Author:** [@israel.jordan](https://forum.inductiveautomation.com/u/israel.jordan)\ **Replies:** 4\ **Last updated:** [May 16, 2023, 10:39pm UTC](https://forum.inductiveautomation.com/t/call-mssql-stored-procedure-from-gateway-event-script/45059 "2023-05-16T22:39:05Z")
Hello I am trying to call a Stored Procedure from a Gateway Event Script and I keep getting the following: (\, java.lang.Exception: Error executing system.db.execSProcCall(), \ **Author:** [@rrebro](https://forum.inductiveautomation.com/u/rrebro)\ **Replies:** 5\ **Last updated:** [December 22, 2020, 10:03pm UTC](https://forum.inductiveautomation.com/t/parameter-list-substitute/41730 "2020-12-22T22:03:22Z") I am trying to create templates to replace HMIs that we have done in FactoryTalk View. One feature that FT View has is parameter lists. You can load a list of parameters that can be used throughout the screen.I understan… --- ## [httpPut json payload escaping](https://forum.inductiveautomation.com/t/httpput-json-payload-escaping/73814)
**Author:** [@wpmccormick](https://forum.inductiveautomation.com/u/wpmccormick)\ **Replies:** 1\ **Last updated:** [May 16, 2023, 9:47pm UTC](https://forum.inductiveautomation.com/t/httpput-json-payload-escaping/73814 "2023-05-16T21:47:46Z")
I'm having an issue making a simple json payload work for an API. This curl works: curl -X PUT "http://lac-00-0060/control/v1/jobs/6bdd1116-3c07-445d-a158-0a2aec6dbb6a" -H "accept: application/json" -H "Content-type: … --- ## [Data in a table from Database](https://forum.inductiveautomation.com/t/data-in-a-table-from-database/73788)
**Author:** [@Luna](https://forum.inductiveautomation.com/u/Luna)\ **Replies:** 6\ **Last updated:** [May 16, 2023, 8:04pm UTC](https://forum.inductiveautomation.com/t/data-in-a-table-from-database/73788 "2023-05-16T20:04:45Z")
Hello community, I'm working on a project in Perspective, and I'm having trouble loading data into a table from a database query. I currently have the Query created, but when I call it from the Data section of the Table… --- ## [PDF Viewer Reading PDF From Database?](https://forum.inductiveautomation.com/t/pdf-viewer-reading-pdf-from-database/68711)
**Author:** [@Sean\_Woolnough](https://forum.inductiveautomation.com/u/Sean_Woolnough)\ **Replies:** 5\ **Last updated:** [May 16, 2023, 8:02pm UTC](https://forum.inductiveautomation.com/t/pdf-viewer-reading-pdf-from-database/68711 "2023-05-16T20:02:08Z")
Hi Guys, I have been playing around with Ignition for a while and seem to be stuck on this one issue, I have a SQL Database setup in which I was able to load different pdfs into it using a simple script within Ignition: … --- ## [Can an external app call an SDK module in Ignition?](https://forum.inductiveautomation.com/t/can-an-external-app-call-an-sdk-module-in-ignition/73807)
**Author:** [@Zak\_Taylor](https://forum.inductiveautomation.com/u/Zak_Taylor)\ **Replies:** 1\ **Last updated:** [May 16, 2023, 7:09pm UTC](https://forum.inductiveautomation.com/t/can-an-external-app-call-an-sdk-module-in-ignition/73807 "2023-05-16T19:09:50Z")
Is it possible for our external Java application to make a call to Ignition to clear/ack an alarm? If so, what is the proper way to connect to the gateway for this sort of action? I can only seem to find documentation a… --- ## [\[IGN-7725\] Perspective table has trouble displaying tiny double/float values](https://forum.inductiveautomation.com/t/ign-7725-perspective-table-has-trouble-displaying-tiny-double-float-values/73602)
**Author:** [@justin.brzozoski](https://forum.inductiveautomation.com/u/justin.brzozoski)\ **Replies:** 1\ **Last updated:** [May 16, 2023, 6:07pm UTC](https://forum.inductiveautomation.com/t/ign-7725-perspective-table-has-trouble-displaying-tiny-double-float-values/73602 "2023-05-16T18:07:02Z")
Bumped into this one on production... :disappointed: We had a table with a column that was so close to zero as to be irrelevant, and the Perspective table just shows NaN... Paste this into a table's data property and y… --- ## [Report simple table text color or fill not working](https://forum.inductiveautomation.com/t/report-simple-table-text-color-or-fill-not-working/73762)
**Author:** [@Brian\_Cockrell](https://forum.inductiveautomation.com/u/Brian_Cockrell)\ **Replies:** 2\ **Last updated:** [May 16, 2023, 5:30pm UTC](https://forum.inductiveautomation.com/t/report-simple-table-text-color-or-fill-not-working/73762 "2023-05-16T17:30:38Z")
I cannot seem to get the reports keychains to work properly. I have a simple table with multiple columns using the header , data, and summary I want to change each data cells color either fill or text based on its valu… --- ## [What permissions/role needed for ignition to insert data to MSSQL table?](https://forum.inductiveautomation.com/t/what-permissions-role-needed-for-ignition-to-insert-data-to-mssql-table/73760)
**Author:** [@hewking32](https://forum.inductiveautomation.com/u/hewking32)\ **Replies:** 11\ **Last updated:** [May 16, 2023, 5:04pm UTC](https://forum.inductiveautomation.com/t/what-permissions-role-needed-for-ignition-to-insert-data-to-mssql-table/73760 "2023-05-16T17:04:51Z")
I hope i am not asking silly question but i have scenario when insert from mssql management studio to remote database (i have no control of) works but the insert from the ignition sql browser generates an error (it does … --- ## [Rotating graphic is changing sizes at random](https://forum.inductiveautomation.com/t/rotating-graphic-is-changing-sizes-at-random/71822)
**Author:** [@steven.rehnborg](https://forum.inductiveautomation.com/u/steven.rehnborg)\ **Replies:** 42\ **Last updated:** [May 16, 2023, 4:49pm UTC](https://forum.inductiveautomation.com/t/rotating-graphic-is-changing-sizes-at-random/71822 "2023-05-16T16:49:58Z")
Has anyone seen this? my graphic was rotating correctly and then suddenly starts changing sizes. --- ## [Swap to Popup with Different Dimensions](https://forum.inductiveautomation.com/t/swap-to-popup-with-different-dimensions/73790)
**Author:** [@tnichols](https://forum.inductiveautomation.com/u/tnichols)\ **Replies:** 7\ **Last updated:** [May 16, 2023, 3:45pm UTC](https://forum.inductiveautomation.com/t/swap-to-popup-with-different-dimensions/73790 "2023-05-16T15:45:42Z")
Many of my popups include navigation to other popups. For example, if a given pressure sensor is used to determine the position of a valve, I can get to the valve popup from the sensor popup and vice versa. Most of my po… --- ## [Accessing Sharepoint Data/Files from Ignition](https://forum.inductiveautomation.com/t/accessing-sharepoint-data-files-from-ignition/73783)
**Author:** [@ccorrea](https://forum.inductiveautomation.com/u/ccorrea)\ **Replies:** 1\ **Last updated:** [May 16, 2023, 3:31pm UTC](https://forum.inductiveautomation.com/t/accessing-sharepoint-data-files-from-ignition/73783 "2023-05-16T15:31:45Z")
Hi guys, Read all posts about the same issue, but couldn't extract a fully working solution from any of them combined. Despite all the recommendations :(, we use and will keep using Sharepoint to manage a lot of useful … --- ## [Is there a way to suppress certain errors in the Logs](https://forum.inductiveautomation.com/t/is-there-a-way-to-suppress-certain-errors-in-the-logs/73777)
**Author:** [@Dalton\_Adams](https://forum.inductiveautomation.com/u/Dalton_Adams)\ **Replies:** 4\ **Last updated:** [May 16, 2023, 3:30pm UTC](https://forum.inductiveautomation.com/t/is-there-a-way-to-suppress-certain-errors-in-the-logs/73777 "2023-05-16T15:30:26Z")
Hello, I was wondering if there was a way to suppress certain errors from appearing in the Log. I have a RFID tag reading system and sometimes one of the fields being read from the tags is returned as a NULL value causi… --- ## [Limit certain person to open a particular project only in designer](https://forum.inductiveautomation.com/t/limit-certain-person-to-open-a-particular-project-only-in-designer/73757)
**Author:** [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\ **Replies:** 3\ **Last updated:** [May 16, 2023, 2:53pm UTC](https://forum.inductiveautomation.com/t/limit-certain-person-to-open-a-particular-project-only-in-designer/73757 "2023-05-16T14:53:16Z")
Currently all projects are in the cloud gateway. If the client want their engineer to be able to access one particular project, is it possible to create the required user role/limit in ignition? the client account can… --- ## [Error Saving Container - Vision 8.1](https://forum.inductiveautomation.com/t/error-saving-container-vision-8-1/73789)
**Author:** [@AIO](https://forum.inductiveautomation.com/u/AIO)\ **Replies:** 2\ **Last updated:** [May 16, 2023, 2:42pm UTC](https://forum.inductiveautomation.com/t/error-saving-container-vision-8-1/73789 "2023-05-16T14:42:02Z")
Hey folks, Getting this error saving a window, having no luck deciphering the issue. Anyone offer advice on what the error is / how to resolve it? Much appreciated com.inductiveautomation.ignition.common.xmlserializati… --- ## [Add a Wildcard Cert to Java Runtime](https://forum.inductiveautomation.com/t/add-a-wildcard-cert-to-java-runtime/73780)
**Author:** [@nellis1](https://forum.inductiveautomation.com/u/nellis1)\ **Replies:** 1\ **Last updated:** [May 16, 2023, 2:13pm UTC](https://forum.inductiveautomation.com/t/add-a-wildcard-cert-to-java-runtime/73780 "2023-05-16T14:13:13Z")
I need to add a wildcard certificate to Ignition so that the Kymera InfluxDB module can connect to the InfluxDB server that is running with a secure connection. For context I have added the wildcard certificate to the U… --- ## [Internal plant network DNS setup in Ignition config](https://forum.inductiveautomation.com/t/internal-plant-network-dns-setup-in-ignition-config/73781)
**Author:** [@Levi\_Overmyer](https://forum.inductiveautomation.com/u/Levi_Overmyer)\ **Replies:** 1\ **Last updated:** [May 16, 2023, 2:10pm UTC](https://forum.inductiveautomation.com/t/internal-plant-network-dns-setup-in-ignition-config/73781 "2023-05-16T14:10:45Z")
I am working to get my Ignition Gateway to communicate with a server outside of our local plant network for a new module to communicate with their remote server. I can currently reach the ignition gateway through my loca… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=646) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=648)