# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=741 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 742 --- ## [Speed comparison of script and sql](https://forum.inductiveautomation.com/t/speed-comparison-of-script-and-sql/66992)
**Author:** [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Replies:** 5\ **Last updated:** [November 28, 2022, 8:41pm UTC](https://forum.inductiveautomation.com/t/speed-comparison-of-script-and-sql/66992 "2022-11-28T20:41:31Z")
Has someone done some testing on the speeds of SQL vs Scripting? I don't really know the speed differences. In a few spots I run a query at about 0.035s. I run a script transform to add a row infrequently to spotlight… --- ## [Run Tag Event Script from Button Press (Gateway and Project Scope)](https://forum.inductiveautomation.com/t/run-tag-event-script-from-button-press-gateway-and-project-scope/66990)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 6\ **Last updated:** [November 28, 2022, 6:44pm UTC](https://forum.inductiveautomation.com/t/run-tag-event-script-from-button-press-gateway-and-project-scope/66990 "2022-11-28T18:44:15Z")
I would like to put a button on the screen to manually fire the script that typically runs automatically based on a tag event. Is there a way to manually call the tag event script directly from the tag? Or, will I have… --- ## [Which to install first - kepware or ignition](https://forum.inductiveautomation.com/t/which-to-install-first-kepware-or-ignition/66991)
**Author:** [@hewking32](https://forum.inductiveautomation.com/u/hewking32)\ **Replies:** 2\ **Last updated:** [November 28, 2022, 6:20pm UTC](https://forum.inductiveautomation.com/t/which-to-install-first-kepware-or-ignition/66991 "2022-11-28T18:20:51Z")
Hi All I heard that its recommended to install kepware and then restart pc before installing ignition. I was told that it is to do with the opc components and how they are installed - kepware has some components like n… --- ## [Is system.tag.getTagValue() still a thing?](https://forum.inductiveautomation.com/t/is-system-tag-gettagvalue-still-a-thing/16096)
**Author:** [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Replies:** 5\ **Last updated:** [November 28, 2022, 5:18pm UTC](https://forum.inductiveautomation.com/t/is-system-tag-gettagvalue-still-a-thing/16096 "2022-11-28T17:18:17Z")
Been looking over some of the stuff I've written over the past 8+ years, and for the past few, I've been using some variant of system.tag.read() over system.tag.getTagValue(). While getTagValue() still works, should I co… --- ## [Issue creating dataset](https://forum.inductiveautomation.com/t/issue-creating-dataset/66984)
**Author:** [@sharan](https://forum.inductiveautomation.com/u/sharan)\ **Replies:** 2\ **Last updated:** [November 28, 2022, 5:15pm UTC](https://forum.inductiveautomation.com/t/issue-creating-dataset/66984 "2022-11-28T17:15:41Z")
ds = system.dataset.toDataSet(\['Bin\_No','Actual','Target'\], \[stringArray,TargetArray,ActualArray\]) event.source.templateParams = ds This creates a dataset of 3 columns- 'Bin\_No','Actual','Target'. But the problem her… --- ## [Change Vision client window form another client?](https://forum.inductiveautomation.com/t/change-vision-client-window-form-another-client/66986)
**Author:** [@jason\_kensett](https://forum.inductiveautomation.com/u/jason_kensett)\ **Replies:** 5\ **Last updated:** [November 28, 2022, 4:44pm UTC](https://forum.inductiveautomation.com/t/change-vision-client-window-form-another-client/66986 "2022-11-28T16:44:58Z")
I am looking for some guidance on changing the window of one vision client from another. All my clients auto log and are restricted. I would like to be able to log into vision and then change the window of a display clie… --- ## [Dataset is not updating with updateRow?](https://forum.inductiveautomation.com/t/dataset-is-not-updating-with-updaterow/51754)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 4\ **Last updated:** [October 8, 2021, 4:30pm UTC](https://forum.inductiveautomation.com/t/dataset-is-not-updating-with-updaterow/51754 "2021-10-08T16:30:20Z")
Using Ignition 7.9.9. I have a situation where I make a copy of an existing ReadData datatset, iterate through templates that are on screen, and then update a WriteData dataset. However, it seems like my changes are no… --- ## [How to Change Gateway Timer script settings from Prespective screen?](https://forum.inductiveautomation.com/t/how-to-change-gateway-timer-script-settings-from-prespective-screen/66980)
**Author:** [@Ashish\_Narula](https://forum.inductiveautomation.com/u/Ashish_Narula)\ **Replies:** 5\ **Last updated:** [November 28, 2022, 4:03pm UTC](https://forum.inductiveautomation.com/t/how-to-change-gateway-timer-script-settings-from-prespective-screen/66980 "2022-11-28T16:03:03Z")
We would like to change the timer delay setting in the Gateway timer event script, From the front end of the perspective screen. --- ## [Alarm pipeline: calculated roster and consolidation](https://forum.inductiveautomation.com/t/alarm-pipeline-calculated-roster-and-consolidation/66574)
**Author:** [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Replies:** 8\ **Last updated:** [November 28, 2022, 3:58pm UTC](https://forum.inductiveautomation.com/t/alarm-pipeline-calculated-roster-and-consolidation/66574 "2022-11-28T15:58:29Z")
Hello folks ! So, I've been wondering about a few things concerning pipelines' notification blocks. Imagine I have 2 users, one wants only critical notifications, the other one wants anything above medium. For some re… --- ## [Named Query vs Stored Procedure Performance at scale](https://forum.inductiveautomation.com/t/named-query-vs-stored-procedure-performance-at-scale/58878)
**Author:** [@kgamble](https://forum.inductiveautomation.com/u/kgamble)\ **Replies:** 11\ **Last updated:** [November 28, 2022, 3:00pm UTC](https://forum.inductiveautomation.com/t/named-query-vs-stored-procedure-performance-at-scale/58878 "2022-11-28T15:00:50Z")
Question similar to: Named Queries vs. Stored Procedures, but more focused on the performance aspect of things. I have an application with about 150 different named queries of all shapes and sizes. That are all scoped t… --- ## [JSON return format for Named query in script](https://forum.inductiveautomation.com/t/json-return-format-for-named-query-in-script/33923)
**Author:** [@Phil\_B](https://forum.inductiveautomation.com/u/Phil_B)\ **Replies:** 7\ **Last updated:** [November 28, 2022, 2:59pm UTC](https://forum.inductiveautomation.com/t/json-return-format-for-named-query-in-script/33923 "2022-11-28T14:59:10Z")
Is there an easy way to get a named query called from within a script to have a return format of JSON similar to the option given if calling a named query from a property binding? Currently i loop through the returned d… --- ## [Dropdown confirmation not working?](https://forum.inductiveautomation.com/t/dropdown-confirmation-not-working/5485)
**Author:** [@scott\_stc](https://forum.inductiveautomation.com/u/scott_stc)\ **Replies:** 8\ **Last updated:** [November 28, 2022, 2:49pm UTC](https://forum.inductiveautomation.com/t/dropdown-confirmation-not-working/5485 "2022-11-28T14:49:32Z")
Will someone double-check me on this: When a dropdown component has the comfirmation enabled, and during runtime the user selects NO in the confirmation box, the event will not change the tag or property it would have c… --- ## [Pulling column value from a Perspective table](https://forum.inductiveautomation.com/t/pulling-column-value-from-a-perspective-table/66966)
**Author:** [@christopher\_wray](https://forum.inductiveautomation.com/u/christopher_wray)\ **Replies:** 2\ **Last updated:** [November 28, 2022, 12:30pm UTC](https://forum.inductiveautomation.com/t/pulling-column-value-from-a-perspective-table/66966 "2022-11-28T12:30:17Z")
Hi sorry for the noob question. If I have a perspective table component, with a query binding on it. and I wanted to get the value of one of the columns returned from the query. Can you get that information from one of … --- ## [Convert a string to int in the dataset](https://forum.inductiveautomation.com/t/convert-a-string-to-int-in-the-dataset/66964)
**Author:** [@saravanan\_Manickam](https://forum.inductiveautomation.com/u/saravanan_Manickam)\ **Replies:** 4\ **Last updated:** [November 28, 2022, 11:17am UTC](https://forum.inductiveautomation.com/t/convert-a-string-to-int-in-the-dataset/66964 "2022-11-28T11:17:23Z")
perspective-report-scrpit rawDataset = data\['named\_query'\].getCoreResults() data\[a\] = str(rawDataset.getValueAt(0,'TotalLoss')) // 107 3--value data\[b\] = str(rawDataset.getValueAt(1,'TotalLoss')) // 109 2--value I ne… --- ## [Carousel, programmatically change page with transition](https://forum.inductiveautomation.com/t/carousel-programmatically-change-page-with-transition/66882)
**Author:** [@AGOSTINO\_SCLAUZERO](https://forum.inductiveautomation.com/u/AGOSTINO_SCLAUZERO)\ **Replies:** 3\ **Last updated:** [November 27, 2022, 4:33pm UTC](https://forum.inductiveautomation.com/t/carousel-programmatically-change-page-with-transition/66882 "2022-11-27T16:33:09Z")
I've got a user interface that is meant to be viewed on a tablet so there is not much room. It contains a data entry and a menù with some buttons. The idea is to create a separate view for the buttons; this way not onl… --- ## [URL in Perspective](https://forum.inductiveautomation.com/t/url-in-perspective/66936)
**Author:** [@Saurabh\_Giratkar](https://forum.inductiveautomation.com/u/Saurabh_Giratkar)\ **Replies:** 7\ **Last updated:** [November 27, 2022, 4:24pm UTC](https://forum.inductiveautomation.com/t/url-in-perspective/66936 "2022-11-27T16:24:08Z")
Hello everyone, I'm new with ignition and trying currently working on a project. I have a memory tag which has a string vale (string value will be different every time) ex : "https://www.google.com/" I want to pass this… --- ## [Clustered columns with XY Chart](https://forum.inductiveautomation.com/t/clustered-columns-with-xy-chart/43666)
**Author:** [@ShaneH](https://forum.inductiveautomation.com/u/ShaneH)\ **Replies:** 4\ **Last updated:** [November 26, 2022, 11:03pm UTC](https://forum.inductiveautomation.com/t/clustered-columns-with-xy-chart/43666 "2022-11-26T23:03:09Z")
Using Perspective 8.1 Any idea how to create clustered columns like this AM Chart example: I can create multiple columns (using multiple series), but I can not get the extra spacing between groups. Thanks for any sug… --- ## [Connecting DNP3 Device First Time - No ports opening](https://forum.inductiveautomation.com/t/connecting-dnp3-device-first-time-no-ports-opening/66945)
**Author:** [@lee.griffiths](https://forum.inductiveautomation.com/u/lee.griffiths)\ **Replies:** 5\ **Last updated:** [November 26, 2022, 10:23pm UTC](https://forum.inductiveautomation.com/t/connecting-dnp3-device-first-time-no-ports-opening/66945 "2022-11-26T22:23:04Z")
Hi Im setting up a test DNP3 device without a fixed IP address on the remote side. That device has an private IP. What Im trying is to get that device to communicate with the DNP3 Master (Ignition) but I can see that p… --- ## [Disable all components of a perspective flex container?](https://forum.inductiveautomation.com/t/disable-all-components-of-a-perspective-flex-container/66930)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 2\ **Last updated:** [November 26, 2022, 3:22pm UTC](https://forum.inductiveautomation.com/t/disable-all-components-of-a-perspective-flex-container/66930 "2022-11-26T15:22:31Z")
Is there a way to disable all components of a perspective flex container ? --- ## [Change the Perspective Table row background color based on the one column's data value](https://forum.inductiveautomation.com/t/change-the-perspective-table-row-background-color-based-on-the-one-columns-data-value/66878)
**Author:** [@Krishnapriya\_K\_S](https://forum.inductiveautomation.com/u/Krishnapriya_K_S)\ **Replies:** 5\ **Last updated:** [November 26, 2022, 3:09pm UTC](https://forum.inductiveautomation.com/t/change-the-perspective-table-row-background-color-based-on-the-one-columns-data-value/66878 "2022-11-26T15:09:14Z")
Hai all, This is my table i need to change the color based on the value of status. If the Status=Open the color of the row is red ,Status=In Progress Color is yellow and the Status is Delegated the color is green P… --- ## [Strange time shift problem](https://forum.inductiveautomation.com/t/strange-time-shift-problem/66931)
**Author:** [@ruevit](https://forum.inductiveautomation.com/u/ruevit)\ **Replies:** 2\ **Last updated:** [November 26, 2022, 8:49am UTC](https://forum.inductiveautomation.com/t/strange-time-shift-problem/66931 "2022-11-26T08:49:16Z")
I have strange shift on my vision clients. They have +1 hour to the time displayed on the screen. Also the trends are shifted with 1 hour. I also have time dependant reports, which also not working as expected. Here are … --- ## [Label on Moving Analog Indicator Getting Cutoff in Perspective](https://forum.inductiveautomation.com/t/label-on-moving-analog-indicator-getting-cutoff-in-perspective/41885)
**Author:** [@gjack1978](https://forum.inductiveautomation.com/u/gjack1978)\ **Replies:** 3\ **Last updated:** [November 26, 2022, 4:17am UTC](https://forum.inductiveautomation.com/t/label-on-moving-analog-indicator-getting-cutoff-in-perspective/41885 "2022-11-26T04:17:23Z")
Hi All, Is there any way I can prevent the last digit on the moving analog indicator label from getting cuttoff like it is in the screenshot? Any label parameters I can tweak? Thanks, Greg --- ## [DNP3 port 20000 for incoming connections](https://forum.inductiveautomation.com/t/dnp3-port-20000-for-incoming-connections/66863)
**Author:** [@martin200261](https://forum.inductiveautomation.com/u/martin200261)\ **Replies:** 5\ **Last updated:** [November 26, 2022, 3:18am UTC](https://forum.inductiveautomation.com/t/dnp3-port-20000-for-incoming-connections/66863 "2022-11-26T03:18:06Z")
I'm new to ignition so apologies if this is a dumb question. We need to use DNP3 with unsolicited events as our remote devices are not on fixed IP addresses so we are reliant on them to initiate the connection. Using n… --- ## [data.getColumnNames() vs system.dataset.getColumnHeaders(data)](https://forum.inductiveautomation.com/t/data-getcolumnnames-vs-system-dataset-getcolumnheaders-data/66933)
**Author:** [@bfreeman](https://forum.inductiveautomation.com/u/bfreeman)\ **Replies:** 5\ **Last updated:** [November 25, 2022, 10:08pm UTC](https://forum.inductiveautomation.com/t/data-getcolumnnames-vs-system-dataset-getcolumnheaders-data/66933 "2022-11-25T22:08:49Z")
Hi, I am trying a create a new dataset from an existing one. I first tried using the following code: system.dataset.toDataSet(data.getColumnNames(), new\_data) But I get a TypeError: toDataSet(): 1st arg can't be coer… --- ## [Perspective finger print login](https://forum.inductiveautomation.com/t/perspective-finger-print-login/66901)
**Author:** [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\ **Replies:** 2\ **Last updated:** [November 25, 2022, 9:08pm UTC](https://forum.inductiveautomation.com/t/perspective-finger-print-login/66901 "2022-11-25T21:08:57Z")
Just to check how is the status of adding finger print login function to perspective. I saw it is added as planned function in 2020. The operator loves the perspective platform but really hate login the screen each time… --- ## [Parameter in JSON path query](https://forum.inductiveautomation.com/t/parameter-in-json-path-query/66919)
**Author:** [@henning.e.heine](https://forum.inductiveautomation.com/u/henning.e.heine)\ **Replies:** 4\ **Last updated:** [November 25, 2022, 5:35pm UTC](https://forum.inductiveautomation.com/t/parameter-in-json-path-query/66919 "2022-11-25T17:35:03Z")
Hi there! I would like to use a json path query in a named query, but I can't figure out how to use the named query paramters in the path query. My query looks like this: SELECT jsonb\_path\_query(payload-\>'Parameters',… --- ## [Refreshing TagBrowseTree component in perspective](https://forum.inductiveautomation.com/t/refreshing-tagbrowsetree-component-in-perspective/66935)
**Author:** [@nellis1](https://forum.inductiveautomation.com/u/nellis1)\ **Replies:** 1\ **Last updated:** [November 25, 2022, 5:10pm UTC](https://forum.inductiveautomation.com/t/refreshing-tagbrowsetree-component-in-perspective/66935 "2022-11-25T17:10:56Z")
I am attempting to create a view in Ignition Perspective 8.1.20 where a use can enter text into a text field and when the text is entered a tag browse tree will be automatically refreshed and will use the text from the t… --- ## [Multiple PDF Viewer](https://forum.inductiveautomation.com/t/multiple-pdf-viewer/66922)
**Author:** [@Inken\_Kestler](https://forum.inductiveautomation.com/u/Inken_Kestler)\ **Replies:** 1\ **Last updated:** [November 25, 2022, 2:57pm UTC](https://forum.inductiveautomation.com/t/multiple-pdf-viewer/66922 "2022-11-25T14:57:55Z")
Hi together, I have a table where I have in each row a filepath of a PDF document and some further information about it. When I select a row in this table, I want to show the PDF in TWO PDF Viewer. Why two? In one of … --- ## [EAM - Send Project Inherited Combines projects?](https://forum.inductiveautomation.com/t/eam-send-project-inherited-combines-projects/66906)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 1\ **Last updated:** [November 25, 2022, 2:36pm UTC](https://forum.inductiveautomation.com/t/eam-send-project-inherited-combines-projects/66906 "2022-11-25T14:36:19Z")
If you want to send a project and inherited projects with EAM, it looks like it will smoosh it all into a single project... this seems a bit silly - why would anyone want to do this? I wish the project selections wer… --- ## [4k 32” - bid daddy monitors](https://forum.inductiveautomation.com/t/4k-32-bid-daddy-monitors/66915)
**Author:** [@Ash\_Power](https://forum.inductiveautomation.com/u/Ash_Power)\ **Replies:** 2\ **Last updated:** [November 25, 2022, 12:27pm UTC](https://forum.inductiveautomation.com/t/4k-32-bid-daddy-monitors/66915 "2022-11-25T12:27:41Z")
Hello all I want to buy 2x 4K monitors 32”, and in Jurassic park style…. Spare no expense I don’t want to find that scaling issues or other stuff ruin my new toys as I live in designer pretty much full time…. Is anyo… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=740) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=742)