# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=865 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 866 --- ## [Tag Change Script Help](https://forum.inductiveautomation.com/t/tag-change-script-help/57887)
**Author:** [@beckya](https://forum.inductiveautomation.com/u/beckya)\ **Replies:** 5\ **Last updated:** [April 1, 2022, 1:39pm UTC](https://forum.inductiveautomation.com/t/tag-change-script-help/57887 "2022-04-01T13:39:32Z")
I have an OPC tag capturing photo eye sensor information and the value is the total number of items seen since the photo eye was installed. For example, it might read 9,456,789 and when it sees an item it changes to 9,45… --- ## [Change border color from mouse entered/exit script](https://forum.inductiveautomation.com/t/change-border-color-from-mouse-entered-exit-script/57924)
**Author:** [@Urvish\_Mehta](https://forum.inductiveautomation.com/u/Urvish_Mehta)\ **Replies:** 2\ **Last updated:** [April 1, 2022, 12:40pm UTC](https://forum.inductiveautomation.com/t/change-border-color-from-mouse-entered-exit-script/57924 "2022-04-01T12:40:44Z")
Hello Everyone, I am trying to show that a container is clickable and to do so,I am thinking to change the border color when mouse enters there and goes back to normal when mouse exit. How do I do this? I found somethin… --- ## [Edit Database with Power Table](https://forum.inductiveautomation.com/t/edit-database-with-power-table/57915)
**Author:** [@andreia\_chiurato](https://forum.inductiveautomation.com/u/andreia_chiurato)\ **Replies:** 1\ **Last updated:** [April 1, 2022, 9:14am UTC](https://forum.inductiveautomation.com/t/edit-database-with-power-table/57915 "2022-04-01T09:14:26Z")
Hi, I did this like the example but I have an error… https://docs.inductiveautomation.com/display/DOC80/Updating+the+Database+through+the+Power+Table Someone had the same problem ? Could you help me ? Thanks 10:40:… --- ## [Not secure connection - Certificates](https://forum.inductiveautomation.com/t/not-secure-connection-certificates/57796)
**Author:** [@Mario\_M](https://forum.inductiveautomation.com/u/Mario_M)\ **Replies:** 4\ **Last updated:** [April 1, 2022, 7:24am UTC](https://forum.inductiveautomation.com/t/not-secure-connection-certificates/57796 "2022-04-01T07:24:50Z")
I have a private network where ignition is installed. For that reason I’m not interested in paying a CA. I’m looking for installing my own certificate but I’m not being able to do it. On “Networking” \< “Web Server” \< “S… --- ## [Pipeline – Passing Associated Data to Calculated Roster](https://forum.inductiveautomation.com/t/pipeline-passing-associated-data-to-calculated-roster/57792)
**Author:** [@FreddyR](https://forum.inductiveautomation.com/u/FreddyR)\ **Replies:** 2\ **Last updated:** [April 1, 2022, 7:07am UTC](https://forum.inductiveautomation.com/t/pipeline-passing-associated-data-to-calculated-roster/57792 "2022-04-01T07:07:21Z")
Hi everyone, I am using system.db.runQuery in my calculated roster to build a roster to Alarm notification. I have already added an associated data in my alarm. Is there any way to pass that associated data into my qu… --- ## [system.perspective.sendMessage not triggering Session Events Message Handlers](https://forum.inductiveautomation.com/t/system-perspective-sendmessage-not-triggering-session-events-message-handlers/57847)
**Author:** [@richardNZ15](https://forum.inductiveautomation.com/u/richardNZ15)\ **Replies:** 8\ **Last updated:** [April 1, 2022, 3:07am UTC](https://forum.inductiveautomation.com/t/system-perspective-sendmessage-not-triggering-session-events-message-handlers/57847 "2022-04-01T03:07:37Z")
What a title… So i am trying to set session properties via a system.perspective.sendMessage call. My call is defined as follows: system.perspective.sendMessage(messageType= "SetNavProps\_Area", payload=payload, scope =… --- ## [Best Practices for Querying Tag History Data \[SOLVED\]](https://forum.inductiveautomation.com/t/best-practices-for-querying-tag-history-data-solved/43427)
**Author:** [@nicholas.robinson](https://forum.inductiveautomation.com/u/nicholas.robinson)\ **Replies:** 14\ **Last updated:** [April 1, 2022, 12:09am UTC](https://forum.inductiveautomation.com/t/best-practices-for-querying-tag-history-data-solved/43427 "2022-04-01T00:09:58Z")
I have a query that I use to populate a table, it does several things but its source of data is the “sqlth\_te” to get tag paths and “sqlt\_data\_1\_2021\_xx”. If its necessary to know, its Maria DB. Everything will work as… --- ## [Importing Named Queries issue](https://forum.inductiveautomation.com/t/importing-named-queries-issue/56419)
**Author:** [@Alfred\_Thayer](https://forum.inductiveautomation.com/u/Alfred_Thayer)\ **Replies:** 6\ **Last updated:** [March 31, 2022, 10:26pm UTC](https://forum.inductiveautomation.com/t/importing-named-queries-issue/56419 "2022-03-31T22:26:06Z")
I imported several Named Queries from another Project. They show up as a choice when I use the Report Module yet I do not see the listed under Named Queries. I can see them to export them and if I try to import them ag… --- ## [How to assign/bind tags to a component in scripting](https://forum.inductiveautomation.com/t/how-to-assign-bind-tags-to-a-component-in-scripting/57897)
**Author:** [@Dilhan\_Bulegoda](https://forum.inductiveautomation.com/u/Dilhan_Bulegoda)\ **Replies:** 2\ **Last updated:** [March 31, 2022, 10:20pm UTC](https://forum.inductiveautomation.com/t/how-to-assign-bind-tags-to-a-component-in-scripting/57897 "2022-03-31T22:20:42Z")
Hello, I am new to Ignition and having trouble finding the system command to bind tags to a component in scripting. I want one button’s action to assign tags to another component in the same window. Please advise. Tha… --- ## [Writing to a tag issues](https://forum.inductiveautomation.com/t/writing-to-a-tag-issues/57902)
**Author:** [@Alfred\_Thayer](https://forum.inductiveautomation.com/u/Alfred_Thayer)\ **Replies:** 1\ **Last updated:** [March 31, 2022, 10:12pm UTC](https://forum.inductiveautomation.com/t/writing-to-a-tag-issues/57902 "2022-03-31T22:12:24Z")
Several weeks ago I add some toggle switches to a project. Some write to a DINT and others toggle a Boolean. The worked with no issue. Today the customer reported an issue with them. They don’t respond at all and cau… --- ## [Popup Window Dragging Over Docked Windows](https://forum.inductiveautomation.com/t/popup-window-dragging-over-docked-windows/57898)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 2\ **Last updated:** [March 31, 2022, 9:09pm UTC](https://forum.inductiveautomation.com/t/popup-window-dragging-over-docked-windows/57898 "2022-03-31T21:09:02Z")
Is there any way to allow users to drag popups over a docked window? Right now, the popup is constrained to the smaller window that is left between the docked windows. Also, I’m getting some weird behavior with a popup … --- ## [Export data to excel from reports viewer](https://forum.inductiveautomation.com/t/export-data-to-excel-from-reports-viewer/57859)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 3\ **Last updated:** [March 31, 2022, 8:48pm UTC](https://forum.inductiveautomation.com/t/export-data-to-excel-from-reports-viewer/57859 "2022-03-31T20:48:48Z")
Hi, when i export the data to excel, the images and text alignement is not good @PGriffith why this is happening any way to resolve it? when data exported in excel format alignement is not good how to reslove th… --- ## [Generate a report by selecting historical tag](https://forum.inductiveautomation.com/t/generate-a-report-by-selecting-historical-tag/57466)
**Author:** [@jamshidzade](https://forum.inductiveautomation.com/u/jamshidzade)\ **Replies:** 31\ **Last updated:** [March 31, 2022, 7:57pm UTC](https://forum.inductiveautomation.com/t/generate-a-report-by-selecting-historical-tag/57466 "2022-03-31T19:57:22Z")
Hi everyone, I am looking to create a report by selecting a historical tag, which means I would like to design a page that has a tag view component and report component if the operator selected a tag, the report would g… --- ## [Expression for UDT Instance Documentation from Subfolders](https://forum.inductiveautomation.com/t/expression-for-udt-instance-documentation-from-subfolders/57755)
**Author:** [@deon.korb](https://forum.inductiveautomation.com/u/deon.korb)\ **Replies:** 5\ **Last updated:** [March 31, 2022, 7:01pm UTC](https://forum.inductiveautomation.com/t/expression-for-udt-instance-documentation-from-subfolders/57755 "2022-03-31T19:01:24Z")
I’m trying to reference the documentation of a UDT instance (UDTInstance.Documentation) in a UDT tag expression (ultimately in an alarm label binding) Getting the documentation from a flat structure is easy using \[.\].Do… --- ## [Issue with Oracle function](https://forum.inductiveautomation.com/t/issue-with-oracle-function/57788)
**Author:** [@Delia\_Edith\_Ponce\_Vi](https://forum.inductiveautomation.com/u/Delia_Edith_Ponce_Vi)\ **Replies:** 1\ **Last updated:** [March 31, 2022, 6:39pm UTC](https://forum.inductiveautomation.com/t/issue-with-oracle-function/57788 "2022-03-31T18:39:28Z")
Hello: I would like to ask for help: I’m working in a project using only named querys and I added a function to get only the hour of a date for example: substr(date\_field,11) between ('07:00:00) and (‘15:00:00’). The… --- ## [Show Tag name in vision client](https://forum.inductiveautomation.com/t/show-tag-name-in-vision-client/57886)
**Author:** [@jamshidzade](https://forum.inductiveautomation.com/u/jamshidzade)\ **Replies:** 2\ **Last updated:** [March 31, 2022, 5:06pm UTC](https://forum.inductiveautomation.com/t/show-tag-name-in-vision-client/57886 "2022-03-31T17:06:35Z")
I created a report which is dynamically works I would like to show the tag name in my report too How can I show the tag name? how I can access the tag name in the script --- ## [Gateway Event Script not triggering batch file](https://forum.inductiveautomation.com/t/gateway-event-script-not-triggering-batch-file/22643)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 13\ **Last updated:** [March 31, 2022, 4:57pm UTC](https://forum.inductiveautomation.com/t/gateway-event-script-not-triggering-batch-file/22643 "2022-03-31T16:57:29Z")
I am trying to trigger a batch file 5 pm everyday. It works while using a button that has the same exact script run when it is pressed, but not for a tag value change. I have set up logs and I know the script IS runnin… --- ## [Passing Parameters to Embedded View via Scripting - Perspective](https://forum.inductiveautomation.com/t/passing-parameters-to-embedded-view-via-scripting-perspective/57881)
**Author:** [@Brit](https://forum.inductiveautomation.com/u/Brit)\ **Replies:** 2\ **Last updated:** [March 31, 2022, 4:53pm UTC](https://forum.inductiveautomation.com/t/passing-parameters-to-embedded-view-via-scripting-perspective/57881 "2022-03-31T16:53:08Z")
Hi, I’m currently using Ignition 8.1.14 and I’m working on a Perspective project. I have a view that I’m using as a template and displaying in another embedded view. The view has a few view parameters that I’m using in t… --- ## [Historian Queries take very long, easy chart times out](https://forum.inductiveautomation.com/t/historian-queries-take-very-long-easy-chart-times-out/57884)
**Author:** [@quartzFarm](https://forum.inductiveautomation.com/u/quartzFarm)\ **Replies:** 5\ **Last updated:** [March 31, 2022, 4:43pm UTC](https://forum.inductiveautomation.com/t/historian-queries-take-very-long-easy-chart-times-out/57884 "2022-03-31T16:43:59Z")
As our gateway has been growing our historian is getting incredibly slow. If I try to query more than 4 hours of data for a single analog tag the easy chart component will time out. I’m only historizing 465 tags, the ma… --- ## [Making a row unselectable in a table](https://forum.inductiveautomation.com/t/making-a-row-unselectable-in-a-table/57883)
**Author:** [@SOPerator](https://forum.inductiveautomation.com/u/SOPerator)\ **Replies:** 3\ **Last updated:** [March 31, 2022, 4:02pm UTC](https://forum.inductiveautomation.com/t/making-a-row-unselectable-in-a-table/57883 "2022-03-31T16:02:11Z")
I’m using a regular table that uses a SELECT \* query for its data, and users are able to select any row right now. However, some of these rows are no longer used and in an effort to prevent mistakes, I’d like to remove t… --- ## [FactoryTalk Historian SE migrate to Ignition](https://forum.inductiveautomation.com/t/factorytalk-historian-se-migrate-to-ignition/57873)
**Author:** [@Adam\_Verellen](https://forum.inductiveautomation.com/u/Adam_Verellen)\ **Replies:** 0\ **Last updated:** [March 31, 2022, 2:42pm UTC](https://forum.inductiveautomation.com/t/factorytalk-historian-se-migrate-to-ignition/57873 "2022-03-31T14:42:07Z")
Hi all I’m curious if anyone has migrated FT Historian SE to Ignition Historian? Rockwell seems to stand in the way any way they can in the off the shelf version. I see there are other tools that can be purchased. Ther… --- ## [Dynamic Image path](https://forum.inductiveautomation.com/t/dynamic-image-path/57869)
**Author:** [@Urvish\_Mehta](https://forum.inductiveautomation.com/u/Urvish_Mehta)\ **Replies:** 4\ **Last updated:** [March 31, 2022, 2:26pm UTC](https://forum.inductiveautomation.com/t/dynamic-image-path/57869 "2022-03-31T14:26:02Z")
Hello Everyone, I am using Image component and I have tag name fault, Whenever I see 1 in fault I would show red cross image otherwise green checkmark image. I need to change image path in Image component, I want to bin… --- ## [Syntax - long string/line contiuation in Python script](https://forum.inductiveautomation.com/t/syntax-long-string-line-contiuation-in-python-script/57711)
**Author:** [@jeff.ryan](https://forum.inductiveautomation.com/u/jeff.ryan)\ **Replies:** 15\ **Last updated:** [March 31, 2022, 1:27pm UTC](https://forum.inductiveautomation.com/t/syntax-long-string-line-contiuation-in-python-script/57711 "2022-03-31T13:27:18Z")
I’m still fairly new to Python and the syntax. If I have a fairly long SQL statement string I need to build (don’t want to put it in named query yet), what is the syntax for building a long string on multiple lines (con… --- ## [Is there a way to rotate the text in a power table header](https://forum.inductiveautomation.com/t/is-there-a-way-to-rotate-the-text-in-a-power-table-header/17231)
**Author:** [@mjcostel](https://forum.inductiveautomation.com/u/mjcostel)\ **Replies:** 3\ **Last updated:** [March 31, 2022, 1:06pm UTC](https://forum.inductiveautomation.com/t/is-there-a-way-to-rotate-the-text-in-a-power-table-header/17231 "2022-03-31T13:06:36Z")
I think the answer is probably no - but is there a way to rotate the power table header text using the extension functions? Can I rotate text in the table itself? I have tried to line up a series of label components a… --- ## [Need help with error code and named queries](https://forum.inductiveautomation.com/t/need-help-with-error-code-and-named-queries/57863)
**Author:** [@Tyler\_Muckley](https://forum.inductiveautomation.com/u/Tyler_Muckley)\ **Replies:** 2\ **Last updated:** [March 31, 2022, 12:29pm UTC](https://forum.inductiveautomation.com/t/need-help-with-error-code-and-named-queries/57863 "2022-03-31T12:29:41Z")
Hello everyone, I have a named query I am trying to run and I am getting an error I can’t seem to find the answer to. I have mediocre ignition experience and I haven’t used it in 8 months so I am a bit rusty here and ne… --- ## [2nd arg can't be coerced to org.python.core.PySequence\[\] for addRows function](https://forum.inductiveautomation.com/t/2nd-arg-cant-be-coerced-to-org-python-core-pysequence-for-addrows-function/19547)
**Author:** [@agweb.salinas](https://forum.inductiveautomation.com/u/agweb.salinas)\ **Replies:** 14\ **Last updated:** [March 31, 2022, 11:59am UTC](https://forum.inductiveautomation.com/t/2nd-arg-cant-be-coerced-to-org-python-core-pysequence-for-addrows-function/19547 "2022-03-31T11:59:03Z")
Thought this might be a good topic since I couldn't find it on the forum. Here's what I'm trying to do since the notation is a little confusing 1. delete a row/rows from tableT1 (lines 1-5) (this code works) 2. take th… --- ## [Textarea, adapt height to text lenght](https://forum.inductiveautomation.com/t/textarea-adapt-height-to-text-lenght/57861)
**Author:** [@SBL\_MC](https://forum.inductiveautomation.com/u/SBL_MC)\ **Replies:** 3\ **Last updated:** [March 31, 2022, 11:55am UTC](https://forum.inductiveautomation.com/t/textarea-adapt-height-to-text-lenght/57861 "2022-03-31T11:55:34Z")
Hi all, I'm using a viewcanvas to list a set of views with a text area, in some ways like a feed/blog entry. I'd like to have the text field adjust the height to match the content text. The canvas will add scrollbars wh… --- ## [Table date format change when select row](https://forum.inductiveautomation.com/t/table-date-format-change-when-select-row/55176)
**Author:** [@flavien](https://forum.inductiveautomation.com/u/flavien)\ **Replies:** 1\ **Last updated:** [March 31, 2022, 9:10am UTC](https://forum.inductiveautomation.com/t/table-date-format-change-when-select-row/55176 "2022-03-31T09:10:30Z")
Hi, I’ve created a table with date format “DD/MM/YYYY” in first column. When I double-click in a cell to update it, format change to “MM/DD/YYYY”. It’s confusing for user. Is it possible to change value format on cel… --- ## [Alarm Name displayed in Alarm Journal Table instead of Label](https://forum.inductiveautomation.com/t/alarm-name-displayed-in-alarm-journal-table-instead-of-label/24519)
**Author:** [@erikmb](https://forum.inductiveautomation.com/u/erikmb)\ **Replies:** 4\ **Last updated:** [March 31, 2022, 7:46am UTC](https://forum.inductiveautomation.com/t/alarm-name-displayed-in-alarm-journal-table-instead-of-label/24519 "2022-03-31T07:46:10Z")
Hi all, I am using the Alarm Journal and Alarm Journal Table for the first time in Ignition 8 and I noticed something in the Alarm Journal Table object. It seems to display the value of the Alarm Name property in the L… --- ## [Automate new gateway configuration](https://forum.inductiveautomation.com/t/automate-new-gateway-configuration/53312)
**Author:** [@wdougmiller](https://forum.inductiveautomation.com/u/wdougmiller)\ **Replies:** 6\ **Last updated:** [March 31, 2022, 6:27am UTC](https://forum.inductiveautomation.com/t/automate-new-gateway-configuration/53312 "2022-03-31T06:27:44Z")
Is it possible to fully automate a new gateway’s configuration. Device boots up with Ignition installed. Given the devices IP address, can we remotely trigger configuration of the new gateway to do the following, at min… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=864) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=866)