# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=796 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 797 --- ## [Convert return format query to DOCUMENT type](https://forum.inductiveautomation.com/t/convert-return-format-query-to-document-type/62948)
**Author:** [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\ **Replies:** 5\ **Last updated:** [August 13, 2022, 9:46am UTC](https://forum.inductiveautomation.com/t/convert-return-format-query-to-document-type/62948 "2022-08-13T09:46:51Z")
Good morning, I’m using Apex Chart to show data and I have some problems trying to populate data series with a query. If I use a Tag History I’m able to show it selecting the tag, setting to Value Format to “DOCUMENT” … --- ## [Desktop on second monitor is opened AFTER invokeLater](https://forum.inductiveautomation.com/t/desktop-on-second-monitor-is-opened-after-invokelater/62898)
**Author:** [@Check](https://forum.inductiveautomation.com/u/Check)\ **Replies:** 3\ **Last updated:** [August 13, 2022, 1:41am UTC](https://forum.inductiveautomation.com/t/desktop-on-second-monitor-is-opened-after-invokelater/62898 "2022-08-13T01:41:35Z")
I want to open a maximized popup window on monitors 1 and 2 BEFORE I open a third-party application on monitor 1. We don’t want the users to click anywhere else on the Ignition application on monitor 1 or on other applic… --- ## [Getting values from NULLs](https://forum.inductiveautomation.com/t/getting-values-from-nulls/62970)
**Author:** [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\ **Replies:** 2\ **Last updated:** [August 12, 2022, 9:05pm UTC](https://forum.inductiveautomation.com/t/getting-values-from-nulls/62970 "2022-08-12T21:05:40Z")
I have this Query: SELECT COUNT(x.dwActualNumberOfDoffings) AS 'DoffCount' ,x.sRecipeName AS 'Denier' ,SUM(Shift\_Weight) AS 'Shift\_LBS' ,SUM(Shift\_Length) AS 'Shift\_Meters' FROM ( SELECT … --- ## [Gateway name is not persisting upon power cycle](https://forum.inductiveautomation.com/t/gateway-name-is-not-persisting-upon-power-cycle/62967)
**Author:** [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\ **Replies:** 5\ **Last updated:** [August 12, 2022, 6:51pm UTC](https://forum.inductiveautomation.com/t/gateway-name-is-not-persisting-upon-power-cycle/62967 "2022-08-12T18:51:35Z")
As title; On 7th at lunchtime I changed my gateway name from 8.1.19 to randdserver. Later that evening I was installing a UPS bypass switch in the server rack so I brought the entire rack down. Upon bringing it up ag… --- ## [First cell in report not populating with data](https://forum.inductiveautomation.com/t/first-cell-in-report-not-populating-with-data/62932)
**Author:** [@Raymond\_Sipes](https://forum.inductiveautomation.com/u/Raymond_Sipes)\ **Replies:** 13\ **Last updated:** [August 12, 2022, 6:46pm UTC](https://forum.inductiveautomation.com/t/first-cell-in-report-not-populating-with-data/62932 "2022-08-12T18:46:48Z")
Hello! I have built out a report that shows certain data given the cell i put the parameter in. Although, I have one cell at the top that does not want to bring in any information when I see it in the DB. Any ideas as t… --- ## [Dataset export to Excel datetime conversion issue](https://forum.inductiveautomation.com/t/dataset-export-to-excel-datetime-conversion-issue/33617)
**Author:** [@Luca](https://forum.inductiveautomation.com/u/Luca)\ **Replies:** 5\ **Last updated:** [August 12, 2022, 6:33pm UTC](https://forum.inductiveautomation.com/t/dataset-export-to-excel-datetime-conversion-issue/33617 "2022-08-12T18:33:19Z")
Hello, I’m currently developing on Ignition version 8.0.9 and I am having issues exporting a chart dataset to excel by using both functions “system.dataset.exportExcel” and “system.dataset.toExcel”. The main problem is t… --- ## [Perspective - Equipment Schedule downtimeEvents right/bottom margin not working](https://forum.inductiveautomation.com/t/perspective-equipment-schedule-downtimeevents-right-bottom-margin-not-working/62962)
**Author:** [@Curtis\_Turley](https://forum.inductiveautomation.com/u/Curtis_Turley)\ **Replies:** 1\ **Last updated:** [August 12, 2022, 6:11pm UTC](https://forum.inductiveautomation.com/t/perspective-equipment-schedule-downtimeevents-right-bottom-margin-not-working/62962 "2022-08-12T18:11:33Z")
Hello, I have been playing around with the equipment schedule component in perspective and I noticed that the marginRight and marginBottom values do not seem to do anything, while the marginLeft and marginTop seem to mo… --- ## [Ignition Metrics Not Showing Up in Ignition Web Interface and Ignition Designer](https://forum.inductiveautomation.com/t/ignition-metrics-not-showing-up-in-ignition-web-interface-and-ignition-designer/62938)
**Author:** [@Snsn\_Nsns](https://forum.inductiveautomation.com/u/Snsn_Nsns)\ **Replies:** 5\ **Last updated:** [August 12, 2022, 4:26pm UTC](https://forum.inductiveautomation.com/t/ignition-metrics-not-showing-up-in-ignition-web-interface-and-ignition-designer/62938 "2022-08-12T16:26:46Z")
Dear All Hello. I am working on a flow in NODE RED. The aim is to establish a reliable SparkplugB based MQTT communication. The initial flow is (@kcollins1 thank you for your help with this) It does show all the met… --- ## [Calling a System tag from a template](https://forum.inductiveautomation.com/t/calling-a-system-tag-from-a-template/62873)
**Author:** [@mrutten](https://forum.inductiveautomation.com/u/mrutten)\ **Replies:** 10\ **Last updated:** [August 12, 2022, 4:21pm UTC](https://forum.inductiveautomation.com/t/calling-a-system-tag-from-a-template/62873 "2022-08-12T16:21:11Z")
Is it possible to read a system tag in a template and see the value in the designer in run mode? I am trying to read the \[System\].Client.User.RoleString, but in the designer in run mode it gives me a “None” value eventh… --- ## [Vision - closing error box popup via scripting](https://forum.inductiveautomation.com/t/vision-closing-error-box-popup-via-scripting/62902)
**Author:** [@richardNZ15](https://forum.inductiveautomation.com/u/richardNZ15)\ **Replies:** 4\ **Last updated:** [August 12, 2022, 3:18pm UTC](https://forum.inductiveautomation.com/t/vision-closing-error-box-popup-via-scripting/62902 "2022-08-12T15:18:17Z")
I have tried following as recommended in this post (Auto - Close Error Box). But i think something has changed in version 8.1 + from 7.9.as it no longer works. I have manually triggered an error popup from a Vision cli… --- ## [Excel data to a tables Dataset](https://forum.inductiveautomation.com/t/excel-data-to-a-tables-dataset/62951)
**Author:** [@sebastien\_ng](https://forum.inductiveautomation.com/u/sebastien_ng)\ **Replies:** 2\ **Last updated:** [August 12, 2022, 12:55pm UTC](https://forum.inductiveautomation.com/t/excel-data-to-a-tables-dataset/62951 "2022-08-12T12:55:59Z")
Hello, I want to know if it is possible copying a Excel file to a tables Dataset in ignition perspective --- ## [Trigger script from tag configuration change](https://forum.inductiveautomation.com/t/trigger-script-from-tag-configuration-change/59516)
**Author:** [@JohnIrving](https://forum.inductiveautomation.com/u/JohnIrving)\ **Replies:** 3\ **Last updated:** [August 12, 2022, 12:19pm UTC](https://forum.inductiveautomation.com/t/trigger-script-from-tag-configuration-change/59516 "2022-08-12T12:19:17Z")
Is there a timestamp or way to trigger generation of a timestamp of the last time any tag properties including custom properties and properties of alarms for that tag have been changed? (but not the value) I have some p… --- ## [Stacked bar chart from dataset](https://forum.inductiveautomation.com/t/stacked-bar-chart-from-dataset/62841)
**Author:** [@fanselm](https://forum.inductiveautomation.com/u/fanselm)\ **Replies:** 2\ **Last updated:** [August 12, 2022, 10:00am UTC](https://forum.inductiveautomation.com/t/stacked-bar-chart-from-dataset/62841 "2022-08-12T10:00:21Z")
Hi all, I’d like to display the following dataset using an XYChart as a stacked bar chart: I’m having issues figuring out how to configure the XYChart. Column WMS\_CUTOFF should be x-axis, y-axis would be the stacke… --- ## [In alarms, the {fullItemPath} property does not return the brackets that surround the provider](https://forum.inductiveautomation.com/t/in-alarms-the-fullitempath-property-does-not-return-the-brackets-that-surround-the-provider/62638)
**Author:** [@ISEMAREN\_AAG](https://forum.inductiveautomation.com/u/ISEMAREN_AAG)\ **Replies:** 8\ **Last updated:** [August 12, 2022, 8:58am UTC](https://forum.inductiveautomation.com/t/in-alarms-the-fullitempath-property-does-not-return-the-brackets-that-surround-the-provider/62638 "2022-08-12T08:58:34Z")
Good afternoon. In Ingition 8.1.15, in Alarms, I’ve noticed that the {fullitemPath} property does not return the brackets that surround the provider. Example: Result: Best Regards. --- ## [Write message in log](https://forum.inductiveautomation.com/t/write-message-in-log/62908)
**Author:** [@pick](https://forum.inductiveautomation.com/u/pick)\ **Replies:** 5\ **Last updated:** [August 12, 2022, 7:31am UTC](https://forum.inductiveautomation.com/t/write-message-in-log/62908 "2022-08-12T07:31:15Z")
Hello, I have a script attach to a tag wich is not working, i would like to print message in the log but when i try it in the script console i have nothing in the log. Do i have to create first the logger named “myL… --- ## [Vertical slide bar remove](https://forum.inductiveautomation.com/t/vertical-slide-bar-remove/62815)
**Author:** [@Amruth\_Jois](https://forum.inductiveautomation.com/u/Amruth_Jois)\ **Replies:** 2\ **Last updated:** [August 12, 2022, 5:45am UTC](https://forum.inductiveautomation.com/t/vertical-slide-bar-remove/62815 "2022-08-12T05:45:22Z")
i want to remove the vertical slide bar as you can see in the attached screenshot. How to do that? but you cannot see it in designer view. --- ## [Metrics not showing up on Ignition Designer and Ignition Web Interface](https://forum.inductiveautomation.com/t/metrics-not-showing-up-on-ignition-designer-and-ignition-web-interface/62888)
**Author:** [@Snsn\_Nsns](https://forum.inductiveautomation.com/u/Snsn_Nsns)\ **Replies:** 4\ **Last updated:** [August 10, 2022, 8:40pm UTC](https://forum.inductiveautomation.com/t/metrics-not-showing-up-on-ignition-designer-and-ignition-web-interface/62888 "2022-08-10T20:40:37Z")
Dear All Hello. I am working on a flow in NODE RED. The aim is to establish a reliable SparkplugB based MQTT communication. The initial flow is (@kcollins1 thank you for your help with this) It does show all the met… --- ## [Multiple databases](https://forum.inductiveautomation.com/t/multiple-databases/62725)
**Author:** [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Replies:** 14\ **Last updated:** [August 11, 2022, 10:12pm UTC](https://forum.inductiveautomation.com/t/multiple-databases/62725 "2022-08-11T22:12:52Z")
If I have 100 machines, the Microsoft SQL database cpu is spiking 75%, and I have multiple projects using both the same database, tag provider, and historian- Then, would I benefit from having a second SQL database for … --- ## [2 State Toggle button not working with Template](https://forum.inductiveautomation.com/t/2-state-toggle-button-not-working-with-template/62350)
**Author:** [@tgish](https://forum.inductiveautomation.com/u/tgish)\ **Replies:** 9\ **Last updated:** [August 11, 2022, 9:55pm UTC](https://forum.inductiveautomation.com/t/2-state-toggle-button-not-working-with-template/62350 "2022-08-11T21:55:55Z")
I made a UDT and one of the tags inside is a boolean OPC tag. On my template, I set up the custom property to link it to my UDT type then I added a 2-state toggle button and linked it to the proper boolean tag property.… --- ## [Chart with user-selected tag pens](https://forum.inductiveautomation.com/t/chart-with-user-selected-tag-pens/62934)
**Author:** [@Rusty](https://forum.inductiveautomation.com/u/Rusty)\ **Replies:** 2\ **Last updated:** [August 11, 2022, 7:50pm UTC](https://forum.inductiveautomation.com/t/chart-with-user-selected-tag-pens/62934 "2022-08-11T19:50:20Z")
Hello everyone, I’m seeking a method in Vision of enabling users to select any given tag from the tag browser tree as a possible tag history pen in a chart. I am trending many tags with the historian- way too many to wa… --- ## [\[FEATURE\]\[IGN-2121\] Perspective in browser add push notifications for alarms (and custom?)](https://forum.inductiveautomation.com/t/feature-ign-2121-perspective-in-browser-add-push-notifications-for-alarms-and-custom/62899)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 3\ **Last updated:** [August 11, 2022, 4:51pm UTC](https://forum.inductiveautomation.com/t/feature-ign-2121-perspective-in-browser-add-push-notifications-for-alarms-and-custom/62899 "2022-08-11T16:51:37Z")
I just saw a demo of another SCADA platform (sorry to blaspheme!) but I thought this particular feature could be quite useful. The app is web-based and new alarms are able to be pushed as browser notifications. This woul… --- ## [\[BUG\] Tag Report Tool shows Good Folders and UDTInstances when filtered out](https://forum.inductiveautomation.com/t/bug-tag-report-tool-shows-good-folders-and-udtinstances-when-filtered-out/62900)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 2\ **Last updated:** [August 11, 2022, 4:41pm UTC](https://forum.inductiveautomation.com/t/bug-tag-report-tool-shows-good-folders-and-udtinstances-when-filtered-out/62900 "2022-08-11T16:41:07Z")
I’ve got Good quality filtered out, but folders and UDT Instances are still included. --- ## [Restore and Close option disable in drawing tools](https://forum.inductiveautomation.com/t/restore-and-close-option-disable-in-drawing-tools/62859)
**Author:** [@Dharani\_T](https://forum.inductiveautomation.com/u/Dharani_T)\ **Replies:** 3\ **Last updated:** [August 11, 2022, 3:25pm UTC](https://forum.inductiveautomation.com/t/restore-and-close-option-disable-in-drawing-tools/62859 "2022-08-11T15:25:31Z")
Hi, I am using drawing tools like rectangle in the vision window. When i right click on the component after launching, i am getting options like ‘Restore, Close’. Please refer the picture below, Is there any possibil… --- ## [Fix button size of a tab strip](https://forum.inductiveautomation.com/t/fix-button-size-of-a-tab-strip/62917)
**Author:** [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\ **Replies:** 1\ **Last updated:** [August 11, 2022, 3:10pm UTC](https://forum.inductiveautomation.com/t/fix-button-size-of-a-tab-strip/62917 "2022-08-11T15:10:10Z")
Hello, I’m using the tab strip to create a 3 levels navigation menu. I would like to fix the button size to align them. Actually, the size mode is “Automatic” and I have this behaviour: Is there a way to do that? T… --- ## [Query Binding to Transform Indirect Tag](https://forum.inductiveautomation.com/t/query-binding-to-transform-indirect-tag/62915)
**Author:** [@jwilliams](https://forum.inductiveautomation.com/u/jwilliams)\ **Replies:** 3\ **Last updated:** [August 11, 2022, 1:35pm UTC](https://forum.inductiveautomation.com/t/query-binding-to-transform-indirect-tag/62915 "2022-08-11T13:35:28Z")
I dont know why I am having issues with this I know I have done it before but cant seem to get it to work on this project, I am confusing something simple I am sure. I have a query binding that returns an integer, say l… --- ## [What is going on with my text? Why is it not showing up properly?](https://forum.inductiveautomation.com/t/what-is-going-on-with-my-text-why-is-it-not-showing-up-properly/62914)
**Author:** [@jfchicat](https://forum.inductiveautomation.com/u/jfchicat)\ **Replies:** 6\ **Last updated:** [August 11, 2022, 1:33pm UTC](https://forum.inductiveautomation.com/t/what-is-going-on-with-my-text-why-is-it-not-showing-up-properly/62914 "2022-08-11T13:33:51Z")
This is my Inkscape file This is what Ignition shows --- ## [XY Chart yAxes useStrict range settings not being applied](https://forum.inductiveautomation.com/t/xy-chart-yaxes-usestrict-range-settings-not-being-applied/62910)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 2\ **Last updated:** [August 11, 2022, 1:02pm UTC](https://forum.inductiveautomation.com/t/xy-chart-yaxes-usestrict-range-settings-not-being-applied/62910 "2022-08-11T13:02:07Z")
Can anyone see why I’m not getting 0 - 100 on the y-axis? Is it me or a bug? --- ## [Collating tag usage from an active page?](https://forum.inductiveautomation.com/t/collating-tag-usage-from-an-active-page/62903)
**Author:** [@simon](https://forum.inductiveautomation.com/u/simon)\ **Replies:** 13\ **Last updated:** [August 11, 2022, 12:35pm UTC](https://forum.inductiveautomation.com/t/collating-tag-usage-from-an-active-page/62903 "2022-08-11T12:35:18Z")
Does anyone know if there is a practical way to capture the tags that a Perspective page (with its constituent views and components) is referencing while the page is viewed? I am hoping that there is a means within the … --- ## [Whether there will be a performance impact, If we subscribe for large amount of tag value change (e.g. 20k)](https://forum.inductiveautomation.com/t/whether-there-will-be-a-performance-impact-if-we-subscribe-for-large-amount-of-tag-value-change-e-g-20k/62824)
**Author:** [@Salman\_Faris](https://forum.inductiveautomation.com/u/Salman_Faris)\ **Replies:** 3\ **Last updated:** [August 11, 2022, 9:25am UTC](https://forum.inductiveautomation.com/t/whether-there-will-be-a-performance-impact-if-we-subscribe-for-large-amount-of-tag-value-change-e-g-20k/62824 "2022-08-11T09:25:13Z")
In my module, I have a requirement to listen for the change in tag value for around 20K PLC tags inorder to validate the tag value. I am worried does subscribing for 20K tag change listeners will create an Performance i… --- ## [Flex wrap enlarges my container (even when not wrapping)](https://forum.inductiveautomation.com/t/flex-wrap-enlarges-my-container-even-when-not-wrapping/62162)
**Author:** [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Replies:** 18\ **Last updated:** [August 11, 2022, 9:09am UTC](https://forum.inductiveautomation.com/t/flex-wrap-enlarges-my-container-even-when-not-wrapping/62162 "2022-08-11T09:09:56Z")
Hello folks, I’m facing a very frustrating behavior with flex containers and flex wrap, and it’s driving me a tiny bit mad. Here’s a container in a container: let’s call it middle container, and here are its proper… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=795) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=797)