# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=384 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 385 --- ## [Is it possible to create a application only with a database?](https://forum.inductiveautomation.com/t/is-it-possible-to-create-a-application-only-with-a-database/92498)
**Author:** [@Myasrama](https://forum.inductiveautomation.com/u/Myasrama)\ **Replies:** 1\ **Last updated:** [June 27, 2024, 9:02pm UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-create-a-application-only-with-a-database/92498 "2024-06-27T21:02:44Z")
Hello, I am new to Ignition and SCADA, I wanted to know is it possible to create a SCADA application in perspective only using a database and queries and no tags? I don't want to integrate any PLC/ device connections in… --- ## [Check OPC-UA certificate expire date on gateway scripts: possible?](https://forum.inductiveautomation.com/t/check-opc-ua-certificate-expire-date-on-gateway-scripts-possible/64661)
**Author:** [@n.meluccio](https://forum.inductiveautomation.com/u/n.meluccio)\ **Replies:** 1\ **Last updated:** [October 1, 2022, 1:21pm UTC](https://forum.inductiveautomation.com/t/check-opc-ua-certificate-expire-date-on-gateway-scripts-possible/64661 "2022-10-01T13:21:05Z")
Hello there, is there a way to get the expiration date of the OPC-UA in the gateway event scripts? or, at least, a way to show it on Vision client? Because it’ll be cool to prevent the expiration of this and prevent t… --- ## [Perspective table onKeyPress event not firing](https://forum.inductiveautomation.com/t/perspective-table-onkeypress-event-not-firing/92487)
**Author:** [@Tyler\_Dolan](https://forum.inductiveautomation.com/u/Tyler_Dolan)\ **Replies:** 3\ **Last updated:** [June 27, 2024, 7:56pm UTC](https://forum.inductiveautomation.com/t/perspective-table-onkeypress-event-not-firing/92487 "2024-06-27T19:56:06Z")
I am trying to use keyboard events when clicked on the cell of a table. I have a perspective table with an onKeyPress event script with just this line of code system.util.getLogger("testlogger").error("test") Pressing… --- ## [If I delete a preprocessed tag history table, can it be recreated?](https://forum.inductiveautomation.com/t/if-i-delete-a-preprocessed-tag-history-table-can-it-be-recreated/92489)
**Author:** [@Troy](https://forum.inductiveautomation.com/u/Troy)\ **Replies:** 0\ **Last updated:** [June 27, 2024, 6:59pm UTC](https://forum.inductiveautomation.com/t/if-i-delete-a-preprocessed-tag-history-table-can-it-be-recreated/92489 "2024-06-27T18:59:11Z")
I'm a database management novice, but I was able to figure out that the reason our database maintenance plan is failing. One of the pre-processed tag history tables has 4155 consistency errors. I don't have any good bac… --- ## [\[IGN-10241\] Customize number of table rows per page](https://forum.inductiveautomation.com/t/ign-10241-customize-number-of-table-rows-per-page/81201)
**Author:** [@Ryan\_Deardorff](https://forum.inductiveautomation.com/u/Ryan_Deardorff)\ **Replies:** 9\ **Last updated:** [June 27, 2024, 5:16pm UTC](https://forum.inductiveautomation.com/t/ign-10241-customize-number-of-table-rows-per-page/81201 "2024-06-27T17:16:26Z")
I would really like our users to be able to customize how many rows they see per page in a table, but binding a value to props.pager.initialOption does not work. I know I can change the various selections in the dropdow… --- ## [Passing UUID() to MySQL](https://forum.inductiveautomation.com/t/passing-uuid-to-mysql/92430)
**Author:** [@Eric\_Bauer](https://forum.inductiveautomation.com/u/Eric_Bauer)\ **Replies:** 5\ **Last updated:** [June 27, 2024, 4:38pm UTC](https://forum.inductiveautomation.com/t/passing-uuid-to-mysql/92430 "2024-06-27T16:38:42Z")
Hello, I would like to pass the UUID() to MySQL in a query to automatically create GUID's during insert queries. I've tried it like this sql = 'INSERT INTO tblMapGraphics(uidClusterId, iBlockNum, iRowNum, iColNum) VAL… --- ## [Did I pick the wrong container for my template?](https://forum.inductiveautomation.com/t/did-i-pick-the-wrong-container-for-my-template/92433)
**Author:** [@Anant\_Upadhyayula](https://forum.inductiveautomation.com/u/Anant_Upadhyayula)\ **Replies:** 8\ **Last updated:** [June 27, 2024, 4:36pm UTC](https://forum.inductiveautomation.com/t/did-i-pick-the-wrong-container-for-my-template/92433 "2024-06-27T16:36:45Z")
I am using cylindrical tank template tied to UDT that I place on various screens. The rendering is good however I hate the fact there is so much screen space in the tank, If could show % fill and the tank value inside th… --- ## [Poll Tag Historian At Midnight For 24 Hour Usage](https://forum.inductiveautomation.com/t/poll-tag-historian-at-midnight-for-24-hour-usage/92479)
**Author:** [@Chris\_Laurion](https://forum.inductiveautomation.com/u/Chris_Laurion)\ **Replies:** 0\ **Last updated:** [June 27, 2024, 4:32pm UTC](https://forum.inductiveautomation.com/t/poll-tag-historian-at-midnight-for-24-hour-usage/92479 "2024-06-27T16:32:58Z")
I have a project in Ignition 8.0 that is currently collecting totalizer data in a tag with history enabled. The end goal is to add a numerical readout on a vision dashboard that shows "Last 24 Hours" and "Current 24 Hour… --- ## [Database password change broke connection](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790)
**Author:** [@Salem\_Marshall](https://forum.inductiveautomation.com/u/Salem_Marshall)\ **Replies:** 34\ **Last updated:** [June 27, 2024, 4:24pm UTC](https://forum.inductiveautomation.com/t/database-password-change-broke-connection/63790 "2024-06-27T16:24:08Z")
I changed the username and password for our database connection. Immediately the connection faulted and now ignition and the database won’t communicate, pretty much breaking our project. I don’t know the old password or… --- ## [Adding major and minor ticks to y-axis for Time Series and Power Chart Component](https://forum.inductiveautomation.com/t/adding-major-and-minor-ticks-to-y-axis-for-time-series-and-power-chart-component/92166)
**Author:** [@Myasrama](https://forum.inductiveautomation.com/u/Myasrama)\ **Replies:** 12\ **Last updated:** [June 27, 2024, 4:01pm UTC](https://forum.inductiveautomation.com/t/adding-major-and-minor-ticks-to-y-axis-for-time-series-and-power-chart-component/92166 "2024-06-27T16:01:59Z")
Hello, I'm currently am using a time series chart and binding it to a query to display data vs time. On my y axis where my data is located I am trying to adjust the increments of the ticks. In the attached image I am w… --- ## [Alarm events - clears being missed](https://forum.inductiveautomation.com/t/alarm-events-clears-being-missed/92474)
**Author:** [@justin.huggins](https://forum.inductiveautomation.com/u/justin.huggins)\ **Replies:** 2\ **Last updated:** [June 27, 2024, 3:33pm UTC](https://forum.inductiveautomation.com/t/alarm-events-clears-being-missed/92474 "2024-06-27T15:33:01Z")
We are attempting to use the alarm events table to capture the timespan of active alarms. We have found entries in the table that have the alarm active and acknowledgement, but is never receiving a alarm clear. I have… --- ## [Importing Icon Picker POPUP component from IGNITION EXCHANGE to DESIRE PROJECT](https://forum.inductiveautomation.com/t/importing-icon-picker-popup-component-from-ignition-exchange-to-desire-project/92427)
**Author:** [@Esme\_Lopez](https://forum.inductiveautomation.com/u/Esme_Lopez)\ **Replies:** 16\ **Last updated:** [June 27, 2024, 3:15pm UTC](https://forum.inductiveautomation.com/t/importing-icon-picker-popup-component-from-ignition-exchange-to-desire-project/92427 "2024-06-27T15:15:04Z")
Hello, I just imported the component of icon picker but do not show any icon this is the url where get th info I guess and when I try to SEARCH some icons, don't show anything. --- ## [\[feature-12986, 15300\]Unacknowledged Alarm Sound](https://forum.inductiveautomation.com/t/feature-12986-15300-unacknowledged-alarm-sound/25460)
**Author:** [@nathan.hooper](https://forum.inductiveautomation.com/u/nathan.hooper)\ **Replies:** 36\ **Last updated:** [June 27, 2024, 3:05pm UTC](https://forum.inductiveautomation.com/t/feature-12986-15300-unacknowledged-alarm-sound/25460 "2024-06-27T15:05:10Z")
I am working on Perspective module, 8.0.1(but I am going to be updating it to 8.0.2 today). I would like to play an alarm sound when there is an unacknowledged alarm. I have been researching this, but this scripting en… --- ## [Connecting Kepserver to Ignition OPC Server](https://forum.inductiveautomation.com/t/connecting-kepserver-to-ignition-opc-server/70634)
**Author:** [@Ben\_Willson](https://forum.inductiveautomation.com/u/Ben_Willson)\ **Replies:** 5\ **Last updated:** [June 27, 2024, 3:04pm UTC](https://forum.inductiveautomation.com/t/connecting-kepserver-to-ignition-opc-server/70634 "2024-06-27T15:04:38Z")
I am having issue connecting to the Ignition OPC Server, I am trying to connect so I can manipulate some tags externally from Ignition. So far I have the OPC sever set up as default except for "Expose Tag Providers" = t… --- ## [\[Feature-1739\]Perspective Relative Path for Embedded View, Flex Repeater, etc](https://forum.inductiveautomation.com/t/feature-1739-perspective-relative-path-for-embedded-view-flex-repeater-etc/42918)
**Author:** [@joyja](https://forum.inductiveautomation.com/u/joyja)\ **Replies:** 12\ **Last updated:** [June 27, 2024, 2:56pm UTC](https://forum.inductiveautomation.com/t/feature-1739-perspective-relative-path-for-embedded-view-flex-repeater-etc/42918 "2024-06-27T14:56:11Z")
It would be nice to be able to optionally reference other views via a relative path in the path prop. For example, in this image if we could reference ‘./Realistic’ instead of ‘Components/Pump/Symbol/Realistic’ I could t… --- ## [Indirect Address Script](https://forum.inductiveautomation.com/t/indirect-address-script/92464)
**Author:** [@Kyle\_Metz](https://forum.inductiveautomation.com/u/Kyle_Metz)\ **Replies:** 6\ **Last updated:** [June 27, 2024, 2:30pm UTC](https://forum.inductiveautomation.com/t/indirect-address-script/92464 "2024-06-27T14:30:17Z")
I have a script attached for a button that resets a PM counter. Im making a template for each line. The Template has a custom property called "PMno" I would like the PMno to point at the "20" in "WeekADDVAR20" and Dat… --- ## [Report charts and page break](https://forum.inductiveautomation.com/t/report-charts-and-page-break/92469)
**Author:** [@Al\_MaBE](https://forum.inductiveautomation.com/u/Al_MaBE)\ **Replies:** 0\ **Last updated:** [June 27, 2024, 2:28pm UTC](https://forum.inductiveautomation.com/t/report-charts-and-page-break/92469 "2024-06-27T14:28:32Z")
Hello, In a report i have a dataset for consumption (let say fuel) per day per machine, like this : Machine name | Date | Consuption Machine A | 01-01-2024 | 56 Machine A | 01-02-2024 | 44 Machine A | 01-03-2024 | 3… --- ## [Reset tag values to zero](https://forum.inductiveautomation.com/t/reset-tag-values-to-zero/92270)
**Author:** [@Vijay\_Krishna\_G\_M1](https://forum.inductiveautomation.com/u/Vijay_Krishna_G_M1)\ **Replies:** 10\ **Last updated:** [June 27, 2024, 2:08pm UTC](https://forum.inductiveautomation.com/t/reset-tag-values-to-zero/92270 "2024-06-27T14:08:42Z")
Dear Team, Hope you are doing well. I am currently working on resetting all the tag values to zero irrespective of its data type. I am facing some difficulties can you help me with some logic please. I would like to cha… --- ## [\[Docker\] unable to find valid certification path to requested target](https://forum.inductiveautomation.com/t/docker-unable-to-find-valid-certification-path-to-requested-target/92400)
**Author:** [@Jae\_No](https://forum.inductiveautomation.com/u/Jae_No)\ **Replies:** 1\ **Last updated:** [June 27, 2024, 1:40pm UTC](https://forum.inductiveautomation.com/t/docker-unable-to-find-valid-certification-path-to-requested-target/92400 "2024-06-27T13:40:44Z")
I am running ignition gateway as docker container and it is acting as client to communicate with external services. When i run the gateway locally, I was able to avoid the error, "unable to find valid certification path… --- ## [SQL bridge and tag historian module](https://forum.inductiveautomation.com/t/sql-bridge-and-tag-historian-module/92438)
**Author:** [@Elias\_Ghadbane](https://forum.inductiveautomation.com/u/Elias_Ghadbane)\ **Replies:** 6\ **Last updated:** [June 27, 2024, 1:10pm UTC](https://forum.inductiveautomation.com/t/sql-bridge-and-tag-historian-module/92438 "2024-06-27T13:10:20Z")
hello everyone, when I buy the SQL bridge module, i can use the transaction and the named query? And no need for the tag historian module if I have knowledge in SQL to call a querry to binding a chart component for exam… --- ## [IP Camera Viewer IIOException: No SOF segment in stream](https://forum.inductiveautomation.com/t/ip-camera-viewer-iioexception-no-sof-segment-in-stream/92460)
**Author:** [@Patrick\_O\_Connor](https://forum.inductiveautomation.com/u/Patrick_O_Connor)\ **Replies:** 0\ **Last updated:** [June 27, 2024, 12:25pm UTC](https://forum.inductiveautomation.com/t/ip-camera-viewer-iioexception-no-sof-segment-in-stream/92460 "2024-06-27T12:25:31Z")
I am using ACTi cameras and the ones that are run PoE work fine, but the coax cameras via encoder work for about 30seconds and then gives the IIOException. Any ideas as to what I can do to remedy this? The URL i am usin… --- ## [View Ignition Report from Different Gateway](https://forum.inductiveautomation.com/t/view-ignition-report-from-different-gateway/43084)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 8\ **Last updated:** [June 27, 2024, 11:59am UTC](https://forum.inductiveautomation.com/t/view-ignition-report-from-different-gateway/43084 "2024-06-27T11:59:07Z")
Is it possible to have an Ignition report on one gateway using the reporting module be viewed from a project on a second gateway with or without the reporting module? --- ## [Share dropdown options in embedded table](https://forum.inductiveautomation.com/t/share-dropdown-options-in-embedded-table/92447)
**Author:** [@mmadariaga](https://forum.inductiveautomation.com/u/mmadariaga)\ **Replies:** 0\ **Last updated:** [June 27, 2024, 9:55am UTC](https://forum.inductiveautomation.com/t/share-dropdown-options-in-embedded-table/92447 "2024-06-27T09:55:42Z")
The first column has a dropdown in each row. I've binded the dropdown options to a query, so I have the same options in very row. I would like to share the info between dropdowns so that if I've selected an option in one… --- ## [Tooltip is not working on Label Component when used inside Column Container](https://forum.inductiveautomation.com/t/tooltip-is-not-working-on-label-component-when-used-inside-column-container/92445)
**Author:** [@ParmanandJ](https://forum.inductiveautomation.com/u/ParmanandJ)\ **Replies:** 0\ **Last updated:** [June 27, 2024, 9:40am UTC](https://forum.inductiveautomation.com/t/tooltip-is-not-working-on-label-component-when-used-inside-column-container/92445 "2024-06-27T09:40:24Z")
Tooltip is not working on Label Component when used inside Column Container. In designer preview mode we can able to see tooltip but in running session it's not visible. Anyone know this issue? --- ## [Text align center in dropdown](https://forum.inductiveautomation.com/t/text-align-center-in-dropdown/92444)
**Author:** [@mmadariaga](https://forum.inductiveautomation.com/u/mmadariaga)\ **Replies:** 0\ **Last updated:** [June 27, 2024, 9:22am UTC](https://forum.inductiveautomation.com/t/text-align-center-in-dropdown/92444 "2024-06-27T09:22:50Z")
I want to align the text in a dropdown to the center. I'm using textAlign which seems to put the start of text in the middle, which makes it uncentered. This dropdown is embedded in a table, if that helps. --- ## [Color Picker in Table Perspective](https://forum.inductiveautomation.com/t/color-picker-in-table-perspective/92436)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 2\ **Last updated:** [June 27, 2024, 8:59am UTC](https://forum.inductiveautomation.com/t/color-picker-in-table-perspective/92436 "2024-06-27T08:59:59Z")
Hi, i like to know is there any way we can use color picker in table row perspective below mentioned one is created in vision table. like that i want to create if any one have any idea please let me know --- ## [Help with - Transform string value](https://forum.inductiveautomation.com/t/help-with-transform-string-value/92428)
**Author:** [@Anant\_Upadhyayula](https://forum.inductiveautomation.com/u/Anant_Upadhyayula)\ **Replies:** 2\ **Last updated:** [June 27, 2024, 2:04am UTC](https://forum.inductiveautomation.com/t/help-with-transform-string-value/92428 "2024-06-27T02:04:19Z")
I get the value from a lookup table. It has a starting string "Form:" I wanted to try transform options and that got the output in the form of a dataset. how would I pick second row. --- ## [How to make a gauge in Perspective show an averaged value?](https://forum.inductiveautomation.com/t/how-to-make-a-gauge-in-perspective-show-an-averaged-value/92376)
**Author:** [@Erik\_Amundson](https://forum.inductiveautomation.com/u/Erik_Amundson)\ **Replies:** 2\ **Last updated:** [June 27, 2024, 1:46am UTC](https://forum.inductiveautomation.com/t/how-to-make-a-gauge-in-perspective-show-an-averaged-value/92376 "2024-06-27T01:46:57Z")
I have a gauge on a Perspective display that has the value bound to a modbus data point I'm grabbing from a sensor. This sensor happens to be a wind direction sensor that bounces around a lot. For that reason, I'd real… --- ## [Where is "Ignition temp directory"?](https://forum.inductiveautomation.com/t/where-is-ignition-temp-directory/92123)
**Author:** [@robby.tanner](https://forum.inductiveautomation.com/u/robby.tanner)\ **Replies:** 2\ **Last updated:** [June 27, 2024, 12:47am UTC](https://forum.inductiveautomation.com/t/where-is-ignition-temp-directory/92123 "2024-06-27T00:47:09Z")
I enabled the Media Debug option. It says "If true, call audio will be recorded to the Ignition temp directory." Where is the Ignition temp directory? --- ## [Formatting Dates in a Report Bar Chart](https://forum.inductiveautomation.com/t/formatting-dates-in-a-report-bar-chart/92357)
**Author:** [@rprice](https://forum.inductiveautomation.com/u/rprice)\ **Replies:** 1\ **Last updated:** [June 26, 2024, 11:31pm UTC](https://forum.inductiveautomation.com/t/formatting-dates-in-a-report-bar-chart/92357 "2024-06-26T23:31:23Z")
Hi, I am creating a report using Historical Tags. In this report, I'd like to have a bar chart displaying my data. When I created this chart, the dates along the x-axis are very long and illegible. I was able to creat… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=383) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=385)