# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=696 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 697 --- ## [Perspective Workstation Primary Display](https://forum.inductiveautomation.com/t/perspective-workstation-primary-display/70190)
**Author:** [@michael.flagler](https://forum.inductiveautomation.com/u/michael.flagler)\ **Replies:** 8\ **Last updated:** [February 24, 2023, 4:59pm UTC](https://forum.inductiveautomation.com/t/perspective-workstation-primary-display/70190 "2023-02-24T16:59:23Z")
I've dug around and I'm not finding an answer anywhere unless I'm overlooking something. Is there a way to retrieve the monitor number (ideally), or a boolean property of if the view is being displayed on the primary di… --- ## [Echo Emulation and Tag Browsing in Ignition Designer](https://forum.inductiveautomation.com/t/echo-emulation-and-tag-browsing-in-ignition-designer/70259)
**Author:** [@David.Reed.Schmidt](https://forum.inductiveautomation.com/u/David.Reed.Schmidt)\ **Replies:** 2\ **Last updated:** [February 24, 2023, 4:53pm UTC](https://forum.inductiveautomation.com/t/echo-emulation-and-tag-browsing-in-ignition-designer/70259 "2023-02-24T16:53:57Z")
We have a licensed version of Rockwell Echo Emulation software. Our Ignition server can connect to the emulated PLC. When I open the Ignition designer I can browse for the device but I cannot browse for any tags inside t… --- ## [Display duration as 'hh:mm:ss' in chart y axis](https://forum.inductiveautomation.com/t/display-duration-as-hhss-in-chart-y-axis/70267)
**Author:** [@Dharani\_T](https://forum.inductiveautomation.com/u/Dharani_T)\ **Replies:** 1\ **Last updated:** [February 24, 2023, 4:20pm UTC](https://forum.inductiveautomation.com/t/display-duration-as-hhss-in-chart-y-axis/70267 "2023-02-24T16:20:54Z")
Hi, I have written the below query to display duration vs loss in a vision chart, SELECT l.Category as label, SEC\_TO\_TIME(COALESCE(SUM(m.RunTime), 0)) as value FROM tbl\_losscategory l LEFT JOIN tbl\_machinestatus m ON … --- ## [Column Container Align Bottom](https://forum.inductiveautomation.com/t/column-container-align-bottom/70285)
**Author:** [@jacob.ramirez](https://forum.inductiveautomation.com/u/jacob.ramirez)\ **Replies:** 2\ **Last updated:** [February 24, 2023, 3:31pm UTC](https://forum.inductiveautomation.com/t/column-container-align-bottom/70285 "2023-02-24T15:31:04Z")
Is there any way to align a component to the bottom of the row when using the column container in perspective? There are multiple components with different heights in the same row, and I want to align one to the bottom … --- ## [Alarm timezone stored in database](https://forum.inductiveautomation.com/t/alarm-timezone-stored-in-database/70277)
**Author:** [@louagejasper](https://forum.inductiveautomation.com/u/louagejasper)\ **Replies:** 5\ **Last updated:** [February 24, 2023, 2:06pm UTC](https://forum.inductiveautomation.com/t/alarm-timezone-stored-in-database/70277 "2023-02-24T14:06:19Z")
Hi, We are storing alarms in an alarm journal. The alarm journal table is auto created with the field 'eventtime' being a timestamp without timezone, just regular Ignition. My gateway time is set at the physical timezo… --- ## ["gwcmd" command in powershell not found](https://forum.inductiveautomation.com/t/gwcmd-command-in-powershell-not-found/70282)
**Author:** [@Emile\_Laplante](https://forum.inductiveautomation.com/u/Emile_Laplante)\ **Replies:** 1\ **Last updated:** [February 24, 2023, 1:53pm UTC](https://forum.inductiveautomation.com/t/gwcmd-command-in-powershell-not-found/70282 "2023-02-24T13:53:32Z")
Hi, When I try the "gwcmd" command in power shell on windows, I get a "command not found": However, the command works fine in windows cmd. What is the issue? Thank you! --- ## [Is it possible to have multiple gateway networks?](https://forum.inductiveautomation.com/t/is-it-possible-to-have-multiple-gateway-networks/70280)
**Author:** [@hewking32](https://forum.inductiveautomation.com/u/hewking32)\ **Replies:** 2\ **Last updated:** [February 24, 2023, 1:46pm UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-have-multiple-gateway-networks/70280 "2023-02-24T13:46:26Z")
Can gateway network have multiple networks/layers eg. Lets say a country has 10 gateways connected on 1 gateway network but one of these gateways is also connected to the international gateway networks? --- ## [Database connection issue](https://forum.inductiveautomation.com/t/database-connection-issue/70156)
**Author:** [@T\_Hat](https://forum.inductiveautomation.com/u/T_Hat)\ **Replies:** 7\ **Last updated:** [February 24, 2023, 12:24pm UTC](https://forum.inductiveautomation.com/t/database-connection-issue/70156 "2023-02-24T12:24:45Z")
After our client's database stopped due to luck of disk space, Ignition was unable to reconnect to it after the issue has been resolved. We needed to restart the gateway to reconnect to database, is there any setting tha… --- ## [Ignition Gateway not starting](https://forum.inductiveautomation.com/t/ignition-gateway-not-starting/70276)
**Author:** [@Michael\_Jones](https://forum.inductiveautomation.com/u/Michael_Jones)\ **Replies:** 3\ **Last updated:** [February 24, 2023, 12:21pm UTC](https://forum.inductiveautomation.com/t/ignition-gateway-not-starting/70276 "2023-02-24T12:21:02Z")
Hi, we are having trouble with our gateway not starting. --- ## [Import csv in perspective with file path?](https://forum.inductiveautomation.com/t/import-csv-in-perspective-with-file-path/70254)
**Author:** [@IgnitionNewbie](https://forum.inductiveautomation.com/u/IgnitionNewbie)\ **Replies:** 3\ **Last updated:** [February 24, 2023, 12:05pm UTC](https://forum.inductiveautomation.com/t/import-csv-in-perspective-with-file-path/70254 "2023-02-24T12:05:29Z")
So I know you can use the file upload component to import csvs and have that set up and working but that method we would need a person to manually put the csvs into the component. What I am really looking for is for a … --- ## [Modify Translation](https://forum.inductiveautomation.com/t/modify-translation/70247)
**Author:** [@Arnaud\_Declerck](https://forum.inductiveautomation.com/u/Arnaud_Declerck)\ **Replies:** 2\ **Last updated:** [February 24, 2023, 11:58am UTC](https://forum.inductiveautomation.com/t/modify-translation/70247 "2023-02-24T11:58:28Z")
Hi, I'm using the system.util.modifyTranslation to modify some terms at the frontend. The modification are immediately updated into the designer translation manager but are only available in the perspective session afte… --- ## [Problems with components layouts](https://forum.inductiveautomation.com/t/problems-with-components-layouts/70046)
**Author:** [@Miguel\_Cimildoro](https://forum.inductiveautomation.com/u/Miguel_Cimildoro)\ **Replies:** 2\ **Last updated:** [February 24, 2023, 8:21am UTC](https://forum.inductiveautomation.com/t/problems-with-components-layouts/70046 "2023-02-24T08:21:12Z")
hello everyone, i have a problem with the design in my ignition designer, i'm placing all the main layout in a group and at the same time setting relative \> Maintain Aspect Ratio \> Center and i can't get the result i wa… --- ## [Get row index of Selected Tab in Tab Data of Tab Strip](https://forum.inductiveautomation.com/t/get-row-index-of-selected-tab-in-tab-data-of-tab-strip/24712)
**Author:** [@bboth](https://forum.inductiveautomation.com/u/bboth)\ **Replies:** 1\ **Last updated:** [February 24, 2023, 12:23am UTC](https://forum.inductiveautomation.com/t/get-row-index-of-selected-tab-in-tab-data-of-tab-strip/24712 "2023-02-24T00:23:32Z")
on propertyChange, I want to check whether the selected tab of a tab strip is “HIDDEN” or not. In other words, I want to read the value of the cell at row of selected tab and column “HIDDEN” (in Tab Data). I am trying t… --- ## [\[BUG\] Unable to deserialize resource](https://forum.inductiveautomation.com/t/bug-unable-to-deserialize-resource/66011)
**Author:** [@kgamble](https://forum.inductiveautomation.com/u/kgamble)\ **Replies:** 4\ **Last updated:** [February 23, 2023, 11:52pm UTC](https://forum.inductiveautomation.com/t/bug-unable-to-deserialize-resource/66011 "2023-02-23T23:52:41Z")
This has been posted 12 different ways, with 12 different errors and looking through I couldn't find my exact error except here where it was resolved with a restart but always restarting the designer multiple times is un… --- ## [Applying theme colors to XY chart properties](https://forum.inductiveautomation.com/t/applying-theme-colors-to-xy-chart-properties/70251)
**Author:** [@Zachary\_Zipper](https://forum.inductiveautomation.com/u/Zachary_Zipper)\ **Replies:** 3\ **Last updated:** [February 23, 2023, 10:55pm UTC](https://forum.inductiveautomation.com/t/applying-theme-colors-to-xy-chart-properties/70251 "2023-02-23T22:55:56Z")
I have a perspective app that currently takes advantage of the built in themes for styling. Unfortunately, it seems the title color and axis colors for the XY chart do not want to use these themes. (putting in "--neutral… --- ## [Populating Text Fields With Query Results](https://forum.inductiveautomation.com/t/populating-text-fields-with-query-results/70245)
**Author:** [@Robert\_Hellner](https://forum.inductiveautomation.com/u/Robert_Hellner)\ **Replies:** 4\ **Last updated:** [February 23, 2023, 9:56pm UTC](https://forum.inductiveautomation.com/t/populating-text-fields-with-query-results/70245 "2023-02-23T21:56:48Z")
I have a Named Query "SelectData": Select short , long , part , length , location , height , number , position01 , position02, position03, position04 , position05 , position06 , position07 , position08 , position09 ,… --- ## [Gold Certification and Core Certification](https://forum.inductiveautomation.com/t/gold-certification-and-core-certification/47566)
**Author:** [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\ **Replies:** 15\ **Last updated:** [February 23, 2023, 4:23pm UTC](https://forum.inductiveautomation.com/t/gold-certification-and-core-certification/47566 "2023-02-23T16:23:21Z")
Hello Everyone, I just finished the core training; however, I am not quite sure about the next steps. I feel like the gold test requires more advanced knowledge which cannot be accomplished by only finishing the online … --- ## [system.date.getMonth()?](https://forum.inductiveautomation.com/t/system-date-getmonth/70243)
**Author:** [@Alan\_Cannon](https://forum.inductiveautomation.com/u/Alan_Cannon)\ **Replies:** 2\ **Last updated:** [February 23, 2023, 8:42pm UTC](https://forum.inductiveautomation.com/t/system-date-getmonth/70243 "2023-02-23T20:42:22Z")
Extracts the month from a date, where January is month 0. Why is January "0"? print "datetime from system.date.now "+ str(system.date.now()) = datetime from system.date.now Thu Feb 23 14:27:09 EST 2023 print "Month fr… --- ## [When did reports go from client side vision objects to gateway side objects?](https://forum.inductiveautomation.com/t/when-did-reports-go-from-client-side-vision-objects-to-gateway-side-objects/70230)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 5\ **Last updated:** [February 23, 2023, 5:34pm UTC](https://forum.inductiveautomation.com/t/when-did-reports-go-from-client-side-vision-objects-to-gateway-side-objects/70230 "2023-02-23T17:34:17Z")
Working on updating a 7.9.9 gateway to a 8.1.2X gateway. This gateway has been in production since I think 7.7.X or earlier. It still (in the current 7.9.9 version) uses legacy reporting components to make reports. I … --- ## [Expression language: lookup equivalent for json arrays](https://forum.inductiveautomation.com/t/expression-language-lookup-equivalent-for-json-arrays/70233)
**Author:** [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\ **Replies:** 2\ **Last updated:** [February 23, 2023, 5:17pm UTC](https://forum.inductiveautomation.com/t/expression-language-lookup-equivalent-for-json-arrays/70233 "2023-02-23T17:17:27Z")
I have a tag, say tableTag, which is of type Document: it's an array of json objects, all objects with the same structure. I'd like to define some more tags which are expression tags and get their value from tableTag loo… --- ## [Local time in gateway](https://forum.inductiveautomation.com/t/local-time-in-gateway/70232)
**Author:** [@William\_Mejia](https://forum.inductiveautomation.com/u/William_Mejia)\ **Replies:** 1\ **Last updated:** [February 23, 2023, 4:44pm UTC](https://forum.inductiveautomation.com/t/local-time-in-gateway/70232 "2023-02-23T16:44:26Z")
Hello! a pleasure to greet you. I am having the following problem, as a context i am running ignition in an Azure virtual machine, the problem is that the local time of my gateway is not the same of my virtual machine. h… --- ## [ClientLauncher Container](https://forum.inductiveautomation.com/t/clientlauncher-container/70228)
**Author:** [@kevinmarchand](https://forum.inductiveautomation.com/u/kevinmarchand)\ **Replies:** 2\ **Last updated:** [February 23, 2023, 4:08pm UTC](https://forum.inductiveautomation.com/t/clientlauncher-container/70228 "2023-02-23T16:08:49Z")
Hi, Is there a docker container for the ClientLauncher? kind regards --- ## [Import excel data into table](https://forum.inductiveautomation.com/t/import-excel-data-into-table/70225)
**Author:** [@aman\_sharma](https://forum.inductiveautomation.com/u/aman_sharma)\ **Replies:** 2\ **Last updated:** [February 23, 2023, 3:20pm UTC](https://forum.inductiveautomation.com/t/import-excel-data-into-table/70225 "2023-02-23T15:20:15Z")
i want to import my excel file into perspective ignition. i am using this script: def excelToDataSet(fileName, hasHeaders = False, sheetNum = 0, firstRow = None, lastRow = None, firstCol = None, lastCol = None): impor… --- ## [SQL Query Filter options](https://forum.inductiveautomation.com/t/sql-query-filter-options/70217)
**Author:** [@Divya\_Chorge](https://forum.inductiveautomation.com/u/Divya_Chorge)\ **Replies:** 1\ **Last updated:** [February 23, 2023, 3:11pm UTC](https://forum.inductiveautomation.com/t/sql-query-filter-options/70217 "2023-02-23T15:11:20Z")
I am logging the data from SQL Server Database into the timeseries chart but I wanted to display only one day value on chart and after completing one day it should get refreshed. What SQL Query should I use to filter onl… --- ## [Standard Group, DB to OPC - Intermittent OPC data write issue](https://forum.inductiveautomation.com/t/standard-group-db-to-opc-intermittent-opc-data-write-issue/69940)
**Author:** [@Bryon\_Borges](https://forum.inductiveautomation.com/u/Bryon_Borges)\ **Replies:** 5\ **Last updated:** [February 23, 2023, 3:07pm UTC](https://forum.inductiveautomation.com/t/standard-group-db-to-opc-intermittent-opc-data-write-issue/69940 "2023-02-23T15:07:24Z")
Hello All. Long time troll, first post. Usually I can find the answers to my questions here or by reviewing the Inductive University videos. Thanks for all the info! I am using a standard transaction group to perform a … --- ## [Float data type in Omron driver](https://forum.inductiveautomation.com/t/float-data-type-in-omron-driver/70201)
**Author:** [@NII](https://forum.inductiveautomation.com/u/NII)\ **Replies:** 1\ **Last updated:** [February 23, 2023, 2:19pm UTC](https://forum.inductiveautomation.com/t/float-data-type-in-omron-driver/70201 "2023-02-23T14:19:15Z")
I'm using Omron FIN/TCP to read DM area which data type is a float, it returns a wrong value (negative number) but the same DM returns a good float value when using Kepware. Does IA Omron driver support float? or am I m… --- ## [Using \`timeBetween\` seems to be returning \`false\` when it should be returning \`true\`](https://forum.inductiveautomation.com/t/using-timebetween-seems-to-be-returning-false-when-it-should-be-returning-true/26664)
**Author:** [@md.szyman](https://forum.inductiveautomation.com/u/md.szyman)\ **Replies:** 6\ **Last updated:** [February 23, 2023, 1:10pm UTC](https://forum.inductiveautomation.com/t/using-timebetween-seems-to-be-returning-false-when-it-should-be-returning-true/26664 "2023-02-23T13:10:03Z")
I’m using timeBetween with full date objects and from what I’ve tested with manual values, even if the dates don’t match up, as long as the time is within the range, it should work. However, I’m getting all three values … --- ## [How to apply filter in Alarm Analysis view for Individual Machine](https://forum.inductiveautomation.com/t/how-to-apply-filter-in-alarm-analysis-view-for-individual-machine/70218)
**Author:** [@Bharat\_Vinchwekar1](https://forum.inductiveautomation.com/u/Bharat_Vinchwekar1)\ **Replies:** 0\ **Last updated:** [February 23, 2023, 12:55pm UTC](https://forum.inductiveautomation.com/t/how-to-apply-filter-in-alarm-analysis-view-for-individual-machine/70218 "2023-02-23T12:55:32Z")
Hi, As I am having 30+ machines dashboard with ignition perspective, How can I use the standard alarm analysis perspective view for each machine to make the analysis for the fault along with all the machines? or can I … --- ## [Get current desktop handle in an Expression](https://forum.inductiveautomation.com/t/get-current-desktop-handle-in-an-expression/70168)
**Author:** [@coffee732](https://forum.inductiveautomation.com/u/coffee732)\ **Replies:** 5\ **Last updated:** [February 23, 2023, 12:39pm UTC](https://forum.inductiveautomation.com/t/get-current-desktop-handle-in-an-expression/70168 "2023-02-23T12:39:22Z")
I have two monitors with independent desktops showing the same window. I want to create an expression binding on the background color of the window so that the background color changes to Red if I'm on Screen 1, and Blu… --- ## [Issue with Reporting Version Key](https://forum.inductiveautomation.com/t/issue-with-reporting-version-key/70200)
**Author:** [@srb](https://forum.inductiveautomation.com/u/srb)\ **Replies:** 0\ **Last updated:** [February 23, 2023, 3:18am UTC](https://forum.inductiveautomation.com/t/issue-with-reporting-version-key/70200 "2023-02-23T03:18:16Z")
I'm on 8.1.25 and use Version Keys to set row colors on the report table. As soon as I set the version key, table's row auto-adjustment and column dateformat break: Edit: Figured out the dateformat issue, I didn't enabl… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=695) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=697)