# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=365 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 366 --- ## [Querying Ignition Historian from SSRS](https://forum.inductiveautomation.com/t/querying-ignition-historian-from-ssrs/93793)
**Author:** [@Aron\_Grzywaczewski](https://forum.inductiveautomation.com/u/Aron_Grzywaczewski)\ **Replies:** 1\ **Last updated:** [July 26, 2024, 2:15pm UTC](https://forum.inductiveautomation.com/t/querying-ignition-historian-from-ssrs/93793 "2024-07-26T14:15:22Z")
Hi, My understanding of the Ignition Historian is that it creates multiple data partitions in the Historian database for better performance. Is there an easy way of querying the historian data from SSRS like there is … --- ## [Sum tag value for 24hr period](https://forum.inductiveautomation.com/t/sum-tag-value-for-24hr-period/92724)
**Author:** [@Karl\_Eckermann](https://forum.inductiveautomation.com/u/Karl_Eckermann)\ **Replies:** 25\ **Last updated:** [July 26, 2024, 2:09pm UTC](https://forum.inductiveautomation.com/t/sum-tag-value-for-24hr-period/92724 "2024-07-26T14:09:50Z")
I have a weather station that returns a total rainfall for a 5min period. What is the best create a tag that can sum the total rainfall from 00:00 to 12:00 (current day). I currently have the tag data in historian. --- ## [Need help with Siemens connection to ignition](https://forum.inductiveautomation.com/t/need-help-with-siemens-connection-to-ignition/93786)
**Author:** [@benjamin\_sales](https://forum.inductiveautomation.com/u/benjamin_sales)\ **Replies:** 2\ **Last updated:** [July 26, 2024, 12:26pm UTC](https://forum.inductiveautomation.com/t/need-help-with-siemens-connection-to-ignition/93786 "2024-07-26T12:26:27Z")
Looking for some help, i was task to get some out Older siemens plcs to communicate to Ignition. i personally haven't touched ignition much. we have a s7 cpu 412-2 that i need to connect to our network somehow... my qu… --- ## [Expression Tag runScript](https://forum.inductiveautomation.com/t/expression-tag-runscript/92205)
**Author:** [@Pat\_Cunningham](https://forum.inductiveautomation.com/u/Pat_Cunningham)\ **Replies:** 5\ **Last updated:** [July 26, 2024, 11:48am UTC](https://forum.inductiveautomation.com/t/expression-tag-runscript/92205 "2024-07-26T11:48:38Z")
Can someone please explain why this wont work in an Expression Tag? --- ## [Need to the blur the container in Vision](https://forum.inductiveautomation.com/t/need-to-the-blur-the-container-in-vision/93777)
**Author:** [@srinivasan\_s](https://forum.inductiveautomation.com/u/srinivasan_s)\ **Replies:** 2\ **Last updated:** [July 26, 2024, 10:00am UTC](https://forum.inductiveautomation.com/t/need-to-the-blur-the-container-in-vision/93777 "2024-07-26T10:00:59Z")
I have the container. That container has some symbol factory components, I need to blur the container that symbol factory component should not visible, any possible way? Is it possible to bind any stylesheet.CSS to visi… --- ## [\[IGN-6087\] Date picker issue (selected date - 1)](https://forum.inductiveautomation.com/t/ign-6087-date-picker-issue-selected-date-1/58345)
**Author:** [@Aditya\_Patil](https://forum.inductiveautomation.com/u/Aditya_Patil)\ **Replies:** 17\ **Last updated:** [July 26, 2024, 7:15am UTC](https://forum.inductiveautomation.com/t/ign-6087-date-picker-issue-selected-date-1/58345 "2024-07-26T07:15:34Z")
I am currently facing issue related to Date picking whenever i pick one date from calendar for first time it takes (selected date - 1) , so need to select twice .You can see this issue in attached video. I have 8.1.15 … --- ## [NamedQuery Failure](https://forum.inductiveautomation.com/t/namedquery-failure/93740)
**Author:** [@Boris\_Toyber](https://forum.inductiveautomation.com/u/Boris_Toyber)\ **Replies:** 3\ **Last updated:** [July 26, 2024, 4:41am UTC](https://forum.inductiveautomation.com/t/namedquery-failure/93740 "2024-07-26T04:41:24Z")
Hello Everybody, I'm using in Project named query, that ls pretty long and looks like stored procedure. It is running well in SQL Management studio, but when I'm triggering it from the button event I get a failure that… --- ## [Inheritance project naming](https://forum.inductiveautomation.com/t/inheritance-project-naming/93694)
**Author:** [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\ **Replies:** 10\ **Last updated:** [July 26, 2024, 2:47am UTC](https://forum.inductiveautomation.com/t/inheritance-project-naming/93694 "2024-07-26T02:47:42Z")
90% of my wasted time is on naming and here I am again asking more questions. I am trying to decide what to name my inherited project, i have seen global, core, etc... Do you have any naming standards or recommendations… --- ## [Add Key Listener on Power Table](https://forum.inductiveautomation.com/t/add-key-listener-on-power-table/93603)
**Author:** [@lcies](https://forum.inductiveautomation.com/u/lcies)\ **Replies:** 5\ **Last updated:** [July 26, 2024, 2:35am UTC](https://forum.inductiveautomation.com/t/add-key-listener-on-power-table/93603 "2024-07-26T02:35:13Z")
Hello, i should add onKeyPress event on Power Table component. To do this, from what i understand, i need to add a Listener on the Key side. I tried to do it using some code inside initialize extension function but it … --- ## [Scroll Window at TextArea Limits](https://forum.inductiveautomation.com/t/scroll-window-at-textarea-limits/93643)
**Author:** [@Devin\_Golberg](https://forum.inductiveautomation.com/u/Devin_Golberg)\ **Replies:** 5\ **Last updated:** [July 25, 2024, 5:57pm UTC](https://forum.inductiveautomation.com/t/scroll-window-at-textarea-limits/93643 "2024-07-25T17:57:44Z")
I have a list of various fields, laid out similar to a table, by way of a template canvas. Within it are various field types, including TextAreas. When I'm trying to scroll the window using the mouse scroll wheel, it w… --- ## [Pipeline Block Editor and HTML E-Mail](https://forum.inductiveautomation.com/t/pipeline-block-editor-and-html-e-mail/77329)
**Author:** [@maxime.guenet](https://forum.inductiveautomation.com/u/maxime.guenet)\ **Replies:** 7\ **Last updated:** [July 25, 2024, 7:51pm UTC](https://forum.inductiveautomation.com/t/pipeline-block-editor-and-html-e-mail/77329 "2024-07-25T19:51:18Z")
Hello everyone, I discovered that we could structure e-mail alarms in HTML. So I went to look for an HTML template on the internet and then wanted to integrate the properties of my alarms into it. The formatting resul… --- ## [Dropdown previous value](https://forum.inductiveautomation.com/t/dropdown-previous-value/93765)
**Author:** [@sathianandan.dharmas](https://forum.inductiveautomation.com/u/sathianandan.dharmas)\ **Replies:** 4\ **Last updated:** [July 25, 2024, 7:43pm UTC](https://forum.inductiveautomation.com/t/dropdown-previous-value/93765 "2024-07-25T19:43:54Z")
Hi Team, Is there any direct or indirect way to get the previousValue or oldValue from a dropdown. It can be either 'selected Value' or 'selected Label' property. Thanks in advance! Sam --- ## [Background Color Property Not Showing on Labels in Vision](https://forum.inductiveautomation.com/t/background-color-property-not-showing-on-labels-in-vision/93764)
**Author:** [@Pico\_Sankari](https://forum.inductiveautomation.com/u/Pico_Sankari)\ **Replies:** 2\ **Last updated:** [July 25, 2024, 6:44pm UTC](https://forum.inductiveautomation.com/t/background-color-property-not-showing-on-labels-in-vision/93764 "2024-07-25T18:44:27Z")
I typical use Perspective, but am modifying an old Vision project. When I add new labels they don't have a background color property: Based on Vision - Label | Ignition User Manual I assumed they would. I'm obviously … --- ## [Are there API functions related to the tag reference tool?](https://forum.inductiveautomation.com/t/are-there-api-functions-related-to-the-tag-reference-tool/93756)
**Author:** [@Nathan\_Foster](https://forum.inductiveautomation.com/u/Nathan_Foster)\ **Replies:** 3\ **Last updated:** [July 25, 2024, 6:30pm UTC](https://forum.inductiveautomation.com/t/are-there-api-functions-related-to-the-tag-reference-tool/93756 "2024-07-25T18:30:57Z")
Are there API functions (Python or Java) related to the tag reference tracker? In particular, getting the active subscriptions from a tag path. Would be useful for generating a tag report as part of a test suite I'm deve… --- ## [Vision client redundancy fails](https://forum.inductiveautomation.com/t/vision-client-redundancy-fails/29719)
**Author:** [@CraigP](https://forum.inductiveautomation.com/u/CraigP)\ **Replies:** 2\ **Last updated:** [July 25, 2024, 5:53pm UTC](https://forum.inductiveautomation.com/t/vision-client-redundancy-fails/29719 "2024-07-25T17:53:04Z")
I’m testing redundancy and am having trouble with my test vision client application. The master and backup gateway are connected and sync status is good. Force failover works, but my test vision client application cannot… --- ## [Sepasoft Batch and PLC linking problem](https://forum.inductiveautomation.com/t/sepasoft-batch-and-plc-linking-problem/85678)
**Author:** [@Ben\_Kennes](https://forum.inductiveautomation.com/u/Ben_Kennes)\ **Replies:** 3\ **Last updated:** [July 25, 2024, 5:37pm UTC](https://forum.inductiveautomation.com/t/sepasoft-batch-and-plc-linking-problem/85678 "2024-07-25T17:37:59Z")
Hello everyone, I'm facing an issue establishing a proper connection between Sepasoft and the PLC. Essentially, I need the PLC to receive the Command\_Number and respond with a State\_Number. Previously, I managed this u… --- ## [Changing Perspective component properties with scripting](https://forum.inductiveautomation.com/t/changing-perspective-component-properties-with-scripting/93754)
**Author:** [@Sawyer\_Jones](https://forum.inductiveautomation.com/u/Sawyer_Jones)\ **Replies:** 7\ **Last updated:** [July 25, 2024, 4:54pm UTC](https://forum.inductiveautomation.com/t/changing-perspective-component-properties-with-scripting/93754 "2024-07-25T16:54:36Z")
Hello, I'm having trouble finding information on how to edit properties with scripting. I have about 50 labels that need to have their tag binding switched to indirect, select a custom property in the container, and chan… --- ## [Switching From Military To Standard Time](https://forum.inductiveautomation.com/t/switching-from-military-to-standard-time/93624)
**Author:** [@AydHA](https://forum.inductiveautomation.com/u/AydHA)\ **Replies:** 10\ **Last updated:** [July 25, 2024, 4:46pm UTC](https://forum.inductiveautomation.com/t/switching-from-military-to-standard-time/93624 "2024-07-25T16:46:30Z")
I have a tag that's going into a label. It is military time and need it to convert to be converted to military time. The tag is formatted hhddss, I am trying to get it to format as hh:dd:ss AM/PM... the closest I have g… --- ## [Moving Perspective application from cloud to on-site](https://forum.inductiveautomation.com/t/moving-perspective-application-from-cloud-to-on-site/93741)
**Author:** [@Christopher\_Smith](https://forum.inductiveautomation.com/u/Christopher_Smith)\ **Replies:** 4\ **Last updated:** [July 25, 2024, 3:53pm UTC](https://forum.inductiveautomation.com/t/moving-perspective-application-from-cloud-to-on-site/93741 "2024-07-25T15:53:24Z")
I am looking at taking over an Ignition program that is running on a cloud based platform. Can I take that program and run it on a physical computer on site? The site wants to move away from any cloud based systems for… --- ## [Alarm journal event data 'sys:'](https://forum.inductiveautomation.com/t/alarm-journal-event-data-sys/93743)
**Author:** [@Kelltek](https://forum.inductiveautomation.com/u/Kelltek)\ **Replies:** 0\ **Last updated:** [July 25, 2024, 2:06pm UTC](https://forum.inductiveautomation.com/t/alarm-journal-event-data-sys/93743 "2024-07-25T14:06:27Z")
Forgive me if this is outlined somehwere but I am having a hard time getting specific results when searching. Diagnosing an issue with alarm journal syncing between backend gateways. Our front end alarm marquee will pop… --- ## [Error "TagHistoryDatasourceSink" caused by wrong storage provider](https://forum.inductiveautomation.com/t/error-taghistorydatasourcesink-caused-by-wrong-storage-provider/93731)
**Author:** [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\ **Replies:** 3\ **Last updated:** [July 25, 2024, 1:14pm UTC](https://forum.inductiveautomation.com/t/error-taghistorydatasourcesink-caused-by-wrong-storage-provider/93731 "2024-07-25T13:14:34Z")
Hi, I wrongly set the "History storage provider" property of some tags to the wrong database. As soon as I noticed the mistake I change the storage provider to the right one; since then I have this errors in the log Th… --- ## [Set focus in perspective table on specific row](https://forum.inductiveautomation.com/t/set-focus-in-perspective-table-on-specific-row/93738)
**Author:** [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\ **Replies:** 2\ **Last updated:** [July 25, 2024, 1:38pm UTC](https://forum.inductiveautomation.com/t/set-focus-in-perspective-table-on-specific-row/93738 "2024-07-25T13:38:41Z")
Good morning, I want to set the focus on a specific row in a perspective table. For example I have a table where I can see the first 5 rows (20 in total). I'm able with a script to retrieve the number of the row that I… --- ## [Installing SSL on Linux (Ubuntu)](https://forum.inductiveautomation.com/t/installing-ssl-on-linux-ubuntu/24920)
**Author:** [@Andrew.Zebic](https://forum.inductiveautomation.com/u/Andrew.Zebic)\ **Replies:** 21\ **Last updated:** [May 21, 2019, 11:15pm UTC](https://forum.inductiveautomation.com/t/installing-ssl-on-linux-ubuntu/24920 "2019-05-21T23:15:42Z")
Hi, I’ve got an SSL certificate in .pfx format, and I want to install it on Ubuntu. The instructions on the ignition website are for Windows, how would I go about this? Thanks, Andrew --- ## [Advice on Hardware Configuration](https://forum.inductiveautomation.com/t/advice-on-hardware-configuration/93729)
**Author:** [@Corne\_de\_Jonge](https://forum.inductiveautomation.com/u/Corne_de_Jonge)\ **Replies:** 5\ **Last updated:** [July 25, 2024, 12:53pm UTC](https://forum.inductiveautomation.com/t/advice-on-hardware-configuration/93729 "2024-07-25T12:53:58Z")
Hi everyone, We're currently evaluating different PC configurations for running SCADA Ignition Perspective and would appreciate some advice on the best hardware setup. We are considering three options, listed in order o… --- ## [Property binding of a row value in a table](https://forum.inductiveautomation.com/t/property-binding-of-a-row-value-in-a-table/93663)
**Author:** [@Christoph\_Schauer](https://forum.inductiveautomation.com/u/Christoph_Schauer)\ **Replies:** 5\ **Last updated:** [July 25, 2024, 12:24pm UTC](https://forum.inductiveautomation.com/t/property-binding-of-a-row-value-in-a-table/93663 "2024-07-25T12:24:42Z")
Hi everybody, I'm very close to reach the following: I have a testing table with two columns. The values are for testing only of type boolean (true, false) and defines, whether an icon is shown or not in the correspond… --- ## [Binding Dropdowns and Charts](https://forum.inductiveautomation.com/t/binding-dropdowns-and-charts/93668)
**Author:** [@drey](https://forum.inductiveautomation.com/u/drey)\ **Replies:** 6\ **Last updated:** [July 25, 2024, 12:08pm UTC](https://forum.inductiveautomation.com/t/binding-dropdowns-and-charts/93668 "2024-07-25T12:08:52Z")
I have list of sensor data, temperature and humidity, coming from my tags and is stored in history. I want to have options, temperature and humidity, on my dropdown list and when I select temperature, I want the chart to… --- ## [Send dynamic parameters to be displayed in EasyChart](https://forum.inductiveautomation.com/t/send-dynamic-parameters-to-be-displayed-in-easychart/93726)
**Author:** [@Sebastian\_Tobar](https://forum.inductiveautomation.com/u/Sebastian_Tobar)\ **Replies:** 1\ **Last updated:** [July 25, 2024, 12:06pm UTC](https://forum.inductiveautomation.com/t/send-dynamic-parameters-to-be-displayed-in-easychart/93726 "2024-07-25T12:06:18Z")
Hello everyone I have a question. It turns out that one of Perspective's DEMO applications has as an example an app called "Water Treatment", which is achieved by pressing on a symbol marked in red in the following pho… --- ## [How to calculate machine total hours and working hours using the tag history?](https://forum.inductiveautomation.com/t/how-to-calculate-machine-total-hours-and-working-hours-using-the-tag-history/93596)
**Author:** [@Govind\_Suthar1](https://forum.inductiveautomation.com/u/Govind_Suthar1)\ **Replies:** 10\ **Last updated:** [July 25, 2024, 11:17am UTC](https://forum.inductiveautomation.com/t/how-to-calculate-machine-total-hours-and-working-hours-using-the-tag-history/93596 "2024-07-25T11:17:29Z")
Hello all, I have a require to calculate machine total hours and working hours using the tag historian. created a two Boolean memory tags and log in the MySQL database on on-change sample mode. I want to calculate the… --- ## [OEE calculation in Ignition](https://forum.inductiveautomation.com/t/oee-calculation-in-ignition/84020)
**Author:** [@Anjali\_manogna](https://forum.inductiveautomation.com/u/Anjali_manogna)\ **Replies:** 9\ **Last updated:** [July 25, 2024, 6:27am UTC](https://forum.inductiveautomation.com/t/oee-calculation-in-ignition/84020 "2024-07-25T06:27:32Z")
How do we calculate OEE in ignition gateway is there any way for OEE calculation in ignition --- ## [Recreate Designer's Script Console in Perspective?](https://forum.inductiveautomation.com/t/recreate-designers-script-console-in-perspective/93631)
**Author:** [@DonPancoe](https://forum.inductiveautomation.com/u/DonPancoe)\ **Replies:** 8\ **Last updated:** [July 25, 2024, 6:01am UTC](https://forum.inductiveautomation.com/t/recreate-designers-script-console-in-perspective/93631 "2024-07-25T06:01:11Z")
I am having data analysts run scripts built around system.tag.queryTagHistory() in order to get "wide" tables out of our Historian (Postgres), suitable for use within analytics tools like JMP. I need to add more analyst… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=364) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=366)