# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=725 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 726 --- ## [Tag History Binding or Named Query](https://forum.inductiveautomation.com/t/tag-history-binding-or-named-query/68330)
**Author:** [@anthony\_ho](https://forum.inductiveautomation.com/u/anthony_ho)\ **Replies:** 2\ **Last updated:** [January 7, 2023, 9:38am UTC](https://forum.inductiveautomation.com/t/tag-history-binding-or-named-query/68330 "2023-01-07T09:38:38Z")
We have SQL Server with monthly partitions logging analog every 5 seconds. The QA user would like to select any time range and find out the percentage of temperature above the setpoint during the hot rinse is on. I am tr… --- ## [Drawing Conveyor System Layout in Perspective Ignition](https://forum.inductiveautomation.com/t/drawing-conveyor-system-layout-in-perspective-ignition/68313)
**Author:** [@Ahmed\_Fattah](https://forum.inductiveautomation.com/u/Ahmed_Fattah)\ **Replies:** 2\ **Last updated:** [January 7, 2023, 5:23am UTC](https://forum.inductiveautomation.com/t/drawing-conveyor-system-layout-in-perspective-ignition/68313 "2023-01-07T05:23:35Z")
Hi, I am new to Ignition and I am wondering if there is anyway to draw or import conveyor system layout and animate them in Ignition Perspective. thanks --- ## [Distribution Curve on Chart](https://forum.inductiveautomation.com/t/distribution-curve-on-chart/68338)
**Author:** [@Aaron\_Shivne](https://forum.inductiveautomation.com/u/Aaron_Shivne)\ **Replies:** 2\ **Last updated:** [January 7, 2023, 1:13am UTC](https://forum.inductiveautomation.com/t/distribution-curve-on-chart/68338 "2023-01-07T01:13:57Z")
I am trying to create a chart to show a Normal Distribution of station cycle times. Using the tip from @JordanCClark in the below discussion I was able to produce this chart. My main issue here is the X - axis, my data… --- ## [Add Nested Query to Existing Nested Query in Report Scripted Data](https://forum.inductiveautomation.com/t/add-nested-query-to-existing-nested-query-in-report-scripted-data/68335)
**Author:** [@denji26](https://forum.inductiveautomation.com/u/denji26)\ **Replies:** 1\ **Last updated:** [January 6, 2023, 10:50pm UTC](https://forum.inductiveautomation.com/t/add-nested-query-to-existing-nested-query-in-report-scripted-data/68335 "2023-01-06T22:50:28Z")
I have had success adding a nested query to an existing datasource using a scripted datasource, but what I have not been able to do is to add a nested query to an existing nested query. I have a Query Data Source "Paren… --- ## [Perspective array custom properties](https://forum.inductiveautomation.com/t/perspective-array-custom-properties/68306)
**Author:** [@CTavakoli](https://forum.inductiveautomation.com/u/CTavakoli)\ **Replies:** 5\ **Last updated:** [January 6, 2023, 9:02pm UTC](https://forum.inductiveautomation.com/t/perspective-array-custom-properties/68306 "2023-01-06T21:02:17Z")
I wish someone could help me understand what is happening in this simplified sample code here. I have an array, arr0, defined as a custom property (on view, root, etc. same result), read it to local arr1, and modify one… --- ## [Perspective Table - Date Columns semi-auto formatting](https://forum.inductiveautomation.com/t/perspective-table-date-columns-semi-auto-formatting/68315)
**Author:** [@MartinezAlan](https://forum.inductiveautomation.com/u/MartinezAlan)\ **Replies:** 1\ **Last updated:** [January 6, 2023, 7:59pm UTC](https://forum.inductiveautomation.com/t/perspective-table-date-columns-semi-auto-formatting/68315 "2023-01-06T19:59:39Z")
After struggling (unnecessarily) with Date formatting in Perspective Tables, solution in the forum is to manually add the field in the 'columns' property of the table and select your desired format. It works, for fixed d… --- ## [Recommendations for using a barcode scanner in a Perspective view](https://forum.inductiveautomation.com/t/recommendations-for-using-a-barcode-scanner-in-a-perspective-view/68323)
**Author:** [@CTrenkamp](https://forum.inductiveautomation.com/u/CTrenkamp)\ **Replies:** 5\ **Last updated:** [January 6, 2023, 7:56pm UTC](https://forum.inductiveautomation.com/t/recommendations-for-using-a-barcode-scanner-in-a-perspective-view/68323 "2023-01-06T19:56:21Z")
I am looking for recommendations regarding using a module for barcode scanning in a Perspective window. --- ## [Query tag to alleviate some query workloads on perspective pages](https://forum.inductiveautomation.com/t/query-tag-to-alleviate-some-query-workloads-on-perspective-pages/59302)
**Author:** [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Replies:** 11\ **Last updated:** [January 6, 2023, 6:59pm UTC](https://forum.inductiveautomation.com/t/query-tag-to-alleviate-some-query-workloads-on-perspective-pages/59302 "2023-01-06T18:59:51Z")
I think I want to alleviate some of the query workload using a query tag. However, at least in Ignition 8.1.0, the execution mode is complicated as I look at it. I have transaction groups that happen at the end of a sh… --- ## [How to show quotation marks in a string binding](https://forum.inductiveautomation.com/t/how-to-show-quotation-marks-in-a-string-binding/68257)
**Author:** [@bwhite](https://forum.inductiveautomation.com/u/bwhite)\ **Replies:** 5\ **Last updated:** [January 6, 2023, 6:54pm UTC](https://forum.inductiveautomation.com/t/how-to-show-quotation-marks-in-a-string-binding/68257 "2023-01-06T18:54:04Z")
I want to make “hg in a binding for the units. I need the units to change between psi when positive and “hg when negative. I have this in the binding, but I don’t know how to show the “ for inches. If(value\> 0 , “psi… --- ## [Dynamic Y axis range from the datasource on the XY Charg](https://forum.inductiveautomation.com/t/dynamic-y-axis-range-from-the-datasource-on-the-xy-charg/67943)
**Author:** [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Replies:** 5\ **Last updated:** [January 6, 2023, 4:36pm UTC](https://forum.inductiveautomation.com/t/dynamic-y-axis-range-from-the-datasource-on-the-xy-charg/67943 "2023-01-06T16:36:30Z")
Sometimes, I get this clipping effect that I want to eliminate. 8.1.19 My thought is that I want to set the range as 0 and then {max(stops)} + 3,000 somehow. My datasource is a query binding. I have had bad lu… --- ## [Average value display using Expression Tag](https://forum.inductiveautomation.com/t/average-value-display-using-expression-tag/68292)
**Author:** [@KEERTHANA\_HEMANTH](https://forum.inductiveautomation.com/u/KEERTHANA_HEMANTH)\ **Replies:** 1\ **Last updated:** [January 6, 2023, 4:48pm UTC](https://forum.inductiveautomation.com/t/average-value-display-using-expression-tag/68292 "2023-01-06T16:48:02Z")
I have a summary dashboard. It has to display the average value of individual plant sites. I have assigned expression tag with average. However it shows as null value if one of the plant site is down. How to get the ave… --- ## [LinearScale does not use the same styling in the Designer as it does in browser](https://forum.inductiveautomation.com/t/linearscale-does-not-use-the-same-styling-in-the-designer-as-it-does-in-browser/68303)
**Author:** [@Thomas\_Mulcahy](https://forum.inductiveautomation.com/u/Thomas_Mulcahy)\ **Replies:** 6\ **Last updated:** [January 6, 2023, 4:02pm UTC](https://forum.inductiveautomation.com/t/linearscale-does-not-use-the-same-styling-in-the-designer-as-it-does-in-browser/68303 "2023-01-06T16:02:31Z")
When using a LinearScale. The tick labels can be coloured, if these tick labels are changed from their default (black) to white (for example), then this change is visible in the designer. An issue arises when viewing th… --- ## [Tag value not updating after Tagwrite](https://forum.inductiveautomation.com/t/tag-value-not-updating-after-tagwrite/68275)
**Author:** [@gsconfienza](https://forum.inductiveautomation.com/u/gsconfienza)\ **Replies:** 7\ **Last updated:** [January 6, 2023, 1:53pm UTC](https://forum.inductiveautomation.com/t/tag-value-not-updating-after-tagwrite/68275 "2023-01-06T13:53:36Z")
Hello everyone, I am facing a really odd issue. I build a text box where you can input a number and then with a button I will run a script to change the value of a memory tag. When I check the tag browser the value has … --- ## [Joining 2 query tags](https://forum.inductiveautomation.com/t/joining-2-query-tags/68226)
**Author:** [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\ **Replies:** 7\ **Last updated:** [January 6, 2023, 1:46pm UTC](https://forum.inductiveautomation.com/t/joining-2-query-tags/68226 "2023-01-06T13:46:49Z")
Good day all. Can you join 2 query tags? I know I can do it in the named query with a combinedDataset python code, only issue with this is the query take too long to do what I want in a timely manner. So, I have the quer… --- ## [TimeSeriesChart change legend label](https://forum.inductiveautomation.com/t/timeserieschart-change-legend-label/53177)
**Author:** [@flavien](https://forum.inductiveautomation.com/u/flavien)\ **Replies:** 2\ **Last updated:** [January 6, 2023, 1:41pm UTC](https://forum.inductiveautomation.com/t/timeserieschart-change-legend-label/53177 "2023-01-06T13:41:55Z")
Hi, In my legend below I would like to change label without changing my chart series. Is it possible ? “converted” =\> “Conso réelle” “expected” =\> Conso attendue" “a0” =\> “DJU” --- ## [Siemens Server Interface](https://forum.inductiveautomation.com/t/siemens-server-interface/68211)
**Author:** [@Michael\_Johannsen](https://forum.inductiveautomation.com/u/Michael_Johannsen)\ **Replies:** 2\ **Last updated:** [January 6, 2023, 1:16pm UTC](https://forum.inductiveautomation.com/t/siemens-server-interface/68211 "2023-01-06T13:16:53Z")
Hi. Does anyone have tried to work with Siemens Server interfaces with OPC ua I can easy create tags, just like when creating tage direct in the DB also woth OPC ua. But when making UDT all the tags from the Server in… --- ## [How to bind the property of a table in one window into another window in vision](https://forum.inductiveautomation.com/t/how-to-bind-the-property-of-a-table-in-one-window-into-another-window-in-vision/68299)
**Author:** [@aman\_sharma](https://forum.inductiveautomation.com/u/aman_sharma)\ **Replies:** 3\ **Last updated:** [January 6, 2023, 1:10pm UTC](https://forum.inductiveautomation.com/t/how-to-bind-the-property-of-a-table-in-one-window-into-another-window-in-vision/68299 "2023-01-06T13:10:15Z")
i have one window in which there is a power table bind with SQL query.i have also one popup window which includes label text. i want to open a popop by clicking on button(named add ) and write the text on label and click… --- ## [Tag path length VS System Performance](https://forum.inductiveautomation.com/t/tag-path-length-vs-system-performance/68293)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 1\ **Last updated:** [January 6, 2023, 7:42am UTC](https://forum.inductiveautomation.com/t/tag-path-length-vs-system-performance/68293 "2023-01-06T07:42:14Z")
Hi It may sound strange question, but I've always wondered if I use long strings for my tags does it affect performance or not? As I understand, in the Ignition the tag path is an actual pointer to it as we pass the st… --- ## [Tag binding, adding transform, if value = 0](https://forum.inductiveautomation.com/t/tag-binding-adding-transform-if-value-0/68245)
**Author:** [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\ **Replies:** 18\ **Last updated:** [January 6, 2023, 5:54am UTC](https://forum.inductiveautomation.com/t/tag-binding-adding-transform-if-value-0/68245 "2023-01-06T05:54:58Z")
Hello all, If a tag returns a zero, I would like the label to display nothing instead of a zero. I used a transform to format the decimal numbers such as '##.#0'. I was attempting to add an Expression transform to that… --- ## [Checkbox enabled](https://forum.inductiveautomation.com/t/checkbox-enabled/67993)
**Author:** [@KEERTHANA\_HEMANTH](https://forum.inductiveautomation.com/u/KEERTHANA_HEMANTH)\ **Replies:** 7\ **Last updated:** [January 6, 2023, 3:56am UTC](https://forum.inductiveautomation.com/t/checkbox-enabled/67993 "2023-01-06T03:56:15Z")
I have a checkbox for each day of the week. I need to log the selected day name to my database when the checkbox is enabled and the ticket is created by clicking on create ticket button . How to proceed with this. --- ## [Printing report viewer](https://forum.inductiveautomation.com/t/printing-report-viewer/68276)
**Author:** [@Esmeralda\_Lopez](https://forum.inductiveautomation.com/u/Esmeralda_Lopez)\ **Replies:** 10\ **Last updated:** [January 6, 2023, 1:24am UTC](https://forum.inductiveautomation.com/t/printing-report-viewer/68276 "2023-01-06T01:24:09Z")
Hello everyone, I need to print a report viewer that is located only here: I am not using the component inside a window part of the project, I just need to call the report and print it by a button and I have this code… --- ## [How do you list active perspective sessions in a perspective view table?](https://forum.inductiveautomation.com/t/how-do-you-list-active-perspective-sessions-in-a-perspective-view-table/68288)
**Author:** [@CTrenkamp](https://forum.inductiveautomation.com/u/CTrenkamp)\ **Replies:** 7\ **Last updated:** [January 5, 2023, 10:54pm UTC](https://forum.inductiveautomation.com/t/how-do-you-list-active-perspective-sessions-in-a-perspective-view-table/68288 "2023-01-05T22:54:59Z")
I am trying to list the active perspective sessions for my project in a perspective view table. After looking at the forum I did not see an example. --- ## [Printing Report With Button](https://forum.inductiveautomation.com/t/printing-report-with-button/9307)
**Author:** [@jreynolds](https://forum.inductiveautomation.com/u/jreynolds)\ **Replies:** 5\ **Last updated:** [January 5, 2023, 8:41pm UTC](https://forum.inductiveautomation.com/t/printing-report-with-button/9307 "2023-01-05T20:41:16Z")
I'm trying to print a report with a button on the screen, this is what I have so far. report = event.source.parent.getComponent('Report Viewer') report.showPrintDialog=0 report.print() When I run this code it prints… --- ## [Where to check used tags which are shown in Tag counts in device connection status?](https://forum.inductiveautomation.com/t/where-to-check-used-tags-which-are-shown-in-tag-counts-in-device-connection-status/68267)
**Author:** [@Aman\_Pawar](https://forum.inductiveautomation.com/u/Aman_Pawar)\ **Replies:** 5\ **Last updated:** [January 5, 2023, 7:38pm UTC](https://forum.inductiveautomation.com/t/where-to-check-used-tags-which-are-shown-in-tag-counts-in-device-connection-status/68267 "2023-01-05T19:38:07Z")
I've one device connection which is showing Tag counts as 177886 and Load factor 373% for tags scheduled at 1000ms. But in the Tag browser only 32 tags are used for that device connection. Where to check used tags which … --- ## [NullPointerException when opening a different project in the Designer and closing a project](https://forum.inductiveautomation.com/t/nullpointerexception-when-opening-a-different-project-in-the-designer-and-closing-a-project/61695)
**Author:** [@eaolson](https://forum.inductiveautomation.com/u/eaolson)\ **Replies:** 2\ **Last updated:** [January 5, 2023, 7:34pm UTC](https://forum.inductiveautomation.com/t/nullpointerexception-when-opening-a-different-project-in-the-designer-and-closing-a-project/61695 "2023-01-05T19:34:52Z")
I’ve recently upgraded from 7.9 to 8.1.17. I’m checking over some Vision projects and every time I open a new project, I’m getting a NullPointerException. I also get an NPE when closing the Designer and it doesn’t actual… --- ## [Gateway scripting project modification](https://forum.inductiveautomation.com/t/gateway-scripting-project-modification/68274)
**Author:** [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\ **Replies:** 2\ **Last updated:** [January 5, 2023, 7:26pm UTC](https://forum.inductiveautomation.com/t/gateway-scripting-project-modification/68274 "2023-01-05T19:26:44Z")
Hello Ignition fans! Simple question: When I change this parameter, do I need to restart the gateway? Thanks! --- ## [\[SOLVED\] Saving File by script whitout ask user](https://forum.inductiveautomation.com/t/solved-saving-file-by-script-whitout-ask-user/68108)
**Author:** [@Esmeralda\_Lopez](https://forum.inductiveautomation.com/u/Esmeralda_Lopez)\ **Replies:** 2\ **Last updated:** [January 5, 2023, 7:15pm UTC](https://forum.inductiveautomation.com/t/solved-saving-file-by-script-whitout-ask-user/68108 "2023-01-05T19:15:02Z")
Hello everyone, I have this code: I want to save the file whitout asking to user, just save it directly when a tag change table =event.source.parent.getComponent("tblEstadisticasPedidos") table2=event.source.parent.get… --- ## [Perspective, Trying to reduce thread count per session](https://forum.inductiveautomation.com/t/perspective-trying-to-reduce-thread-count-per-session/43708)
**Author:** [@ryan.white](https://forum.inductiveautomation.com/u/ryan.white)\ **Replies:** 10\ **Last updated:** [January 5, 2023, 5:31pm UTC](https://forum.inductiveautomation.com/t/perspective-trying-to-reduce-thread-count-per-session/43708 "2023-01-05T17:31:07Z")
I’ve restarted work on a project that shelved a while ago due to low priority. Part of my update work has been reducing the load of the session on our gateway. I’m managed to reduce the amount of DB polls from ~400/s per… --- ## [Perspective symbols](https://forum.inductiveautomation.com/t/perspective-symbols/52527)
**Author:** [@mokam](https://forum.inductiveautomation.com/u/mokam)\ **Replies:** 6\ **Last updated:** [January 5, 2023, 4:35pm UTC](https://forum.inductiveautomation.com/t/perspective-symbols/52527 "2023-01-05T16:35:05Z")
Hi, Is there new symbols. Is there way to made our own modules. I the last version I found just 4 groups of symbols nothing else. Thanks. --- ## [Aspect Ratio and Screen Resolution](https://forum.inductiveautomation.com/t/aspect-ratio-and-screen-resolution/68263)
**Author:** [@David\_Gonsior](https://forum.inductiveautomation.com/u/David_Gonsior)\ **Replies:** 2\ **Last updated:** [January 5, 2023, 4:13pm UTC](https://forum.inductiveautomation.com/t/aspect-ratio-and-screen-resolution/68263 "2023-01-05T16:13:08Z")
Hello, New to Ignition here. Starting creating a project in Designer yesterday and have a template pretty well-built so far. When beginning building the windows, I created a layout size of 1600x900 for a 16:9 aspect rat… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=724) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=726)