# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=699 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 700 --- ## [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… --- ## [Multiple Filter Keys in reports](https://forum.inductiveautomation.com/t/multiple-filter-keys-in-reports/68941)
**Author:** [@wschauer](https://forum.inductiveautomation.com/u/wschauer)\ **Replies:** 2\ **Last updated:** [February 23, 2023, 12:30am UTC](https://forum.inductiveautomation.com/t/multiple-filter-keys-in-reports/68941 "2023-02-23T00:30:13Z")
Is there a way to use multiple filter keys within a report table? I have one Query that pulls data for the week and I am currently filtering it by day, I would also like to filter by shift. Both are rows returned withi… --- ## [Timezone in Vision Alarm Status Table](https://forum.inductiveautomation.com/t/timezone-in-vision-alarm-status-table/69862)
**Author:** [@poresky](https://forum.inductiveautomation.com/u/poresky)\ **Replies:** 5\ **Last updated:** [February 23, 2023, 12:08am UTC](https://forum.inductiveautomation.com/t/timezone-in-vision-alarm-status-table/69862 "2023-02-23T00:08:39Z")
Hello, I have a Gateway that is set to UTC time and we have some reasons to keep it that way. This has been fine for users because both Vision and Perspective clients running on this Gateway are configured to show local… --- ## [Flex Repeater Instance - View Parameter vs Custom Property](https://forum.inductiveautomation.com/t/flex-repeater-instance-view-parameter-vs-custom-property/70187)
**Author:** [@john.glynn](https://forum.inductiveautomation.com/u/john.glynn)\ **Replies:** 1\ **Last updated:** [February 22, 2023, 11:02pm UTC](https://forum.inductiveautomation.com/t/flex-repeater-instance-view-parameter-vs-custom-property/70187 "2023-02-22T23:02:35Z")
PERSPECTIVE I have a flex repeater that shows instances of a view. This view has both view parameters and custom properties. When the number of instances changes on the flex repeater, the view parameters for each insta… --- ## [Ignition architecture question DEV to PROD](https://forum.inductiveautomation.com/t/ignition-architecture-question-dev-to-prod/70182)
**Author:** [@rahman.tarek](https://forum.inductiveautomation.com/u/rahman.tarek)\ **Replies:** 9\ **Last updated:** [February 22, 2023, 9:13pm UTC](https://forum.inductiveautomation.com/t/ignition-architecture-question-dev-to-prod/70182 "2023-02-22T21:13:36Z")
Hello i currently have an Ignition DEV instance and SQL Server DEV instance. At the same time i have an Ignition PROD instance and a SQL Server PROD instance. (4 VMS in total) The goal was to do all development in the D… --- ## [Way to export the client log to the server?](https://forum.inductiveautomation.com/t/way-to-export-the-client-log-to-the-server/70172)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 3\ **Last updated:** [February 22, 2023, 7:15pm UTC](https://forum.inductiveautomation.com/t/way-to-export-the-client-log-to-the-server/70172 "2023-02-22T19:15:36Z")
Using 7.9.9 for now until the system gets upgraded to 8.1.19 in the near future. I have an issue currently where this system uses old legacy reporting components to make reports. The rpeort is supposed to print and be … --- ## [Twilio Account Faults After v8.1.24 Gateway Restarts](https://forum.inductiveautomation.com/t/twilio-account-faults-after-v8-1-24-gateway-restarts/70181)
**Author:** [@edward.fowler](https://forum.inductiveautomation.com/u/edward.fowler)\ **Replies:** 0\ **Last updated:** [February 22, 2023, 7:11pm UTC](https://forum.inductiveautomation.com/t/twilio-account-faults-after-v8-1-24-gateway-restarts/70181 "2023-02-22T19:11:31Z")
After each restart of the gateway a Dispatcher error appears in the logs. Error sending SMS; account faulted., SMS messages aren't being sent. Opening the gateway Config --\> Twilio --\> Accounts --\> (my account) editor a… --- ## [Python to Retrieve list of file on a Network Folder](https://forum.inductiveautomation.com/t/python-to-retrieve-list-of-file-on-a-network-folder/10905)
**Author:** [@jmoniz](https://forum.inductiveautomation.com/u/jmoniz)\ **Replies:** 9\ **Last updated:** [February 22, 2023, 7:04pm UTC](https://forum.inductiveautomation.com/t/python-to-retrieve-list-of-file-on-a-network-folder/10905 "2023-02-22T19:04:16Z")
Is is possible to have a gateway function to retrieve a list of file names and/or folders within a networked dive the gateway has access to? --- ## [Passing parameter back to a date picker view in a table column](https://forum.inductiveautomation.com/t/passing-parameter-back-to-a-date-picker-view-in-a-table-column/70169)
**Author:** [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\ **Replies:** 0\ **Last updated:** [February 22, 2023, 3:07pm UTC](https://forum.inductiveautomation.com/t/passing-parameter-back-to-a-date-picker-view-in-a-table-column/70169 "2023-02-22T15:07:47Z")
I have a perspective table that is being fed by a database, one of the columns is a datetime. I'm using a datetime picker view to dislay the date in the table with the idea that I want it to be editable. The table works… --- ## [\[BUG-7239\] Remote unattended install (8.1.25) on windows (via powershell) breaks because of splash screen?](https://forum.inductiveautomation.com/t/bug-7239-remote-unattended-install-8-1-25-on-windows-via-powershell-breaks-because-of-splash-screen/70083)
**Author:** [@hunterdg](https://forum.inductiveautomation.com/u/hunterdg)\ **Replies:** 4\ **Last updated:** [February 22, 2023, 6:56pm UTC](https://forum.inductiveautomation.com/t/bug-7239-remote-unattended-install-8-1-25-on-windows-via-powershell-breaks-because-of-splash-screen/70083 "2023-02-22T18:56:14Z")
I'm attempting to script an v7.9\>v8.1 upgrade process (and rollback scenario) across multiple gateways, and wish to kick off the script from my workstation. I can perform remote unattended un/reinstall of 7.9 via powers… --- ## [Reporting in Ignition Perspective](https://forum.inductiveautomation.com/t/reporting-in-ignition-perspective/69843)
**Author:** [@Bharat\_Vinchwekar1](https://forum.inductiveautomation.com/u/Bharat_Vinchwekar1)\ **Replies:** 4\ **Last updated:** [February 22, 2023, 5:58pm UTC](https://forum.inductiveautomation.com/t/reporting-in-ignition-perspective/69843 "2023-02-22T17:58:16Z")
Hence I was having multiple machines of 4 categories in Ignition SCADA, Machine Type 1 (8 nos.) Machine Type 2 (3 nos.) Machine Type 3 (3 nos.) Machine Type 4 (5 nos.) I am trying to prepare the Tag History report f… --- ## [Comparing Nested Object Properties in Perspective](https://forum.inductiveautomation.com/t/comparing-nested-object-properties-in-perspective/70173)
**Author:** [@Josh\_Davidson](https://forum.inductiveautomation.com/u/Josh_Davidson)\ **Replies:** 4\ **Last updated:** [February 22, 2023, 5:54pm UTC](https://forum.inductiveautomation.com/t/comparing-nested-object-properties-in-perspective/70173 "2023-02-22T17:54:38Z")
My issue is in trying to compare two custom properties configured on the top level of a view I am building in perspective. I have a button whose display property is bound to one of the properties and compared in a scr… --- ## [Perspective How to Hide Column on a Table](https://forum.inductiveautomation.com/t/perspective-how-to-hide-column-on-a-table/70175)
**Author:** [@jmonter](https://forum.inductiveautomation.com/u/jmonter)\ **Replies:** 2\ **Last updated:** [February 22, 2023, 5:54pm UTC](https://forum.inductiveautomation.com/t/perspective-how-to-hide-column-on-a-table/70175 "2023-02-22T17:54:37Z")
How does one hide a column on a table in perspective? Lets say I want to hide id. --- ## [Script writing to a memory tag dataset](https://forum.inductiveautomation.com/t/script-writing-to-a-memory-tag-dataset/70133)
**Author:** [@Nick\_Heiting](https://forum.inductiveautomation.com/u/Nick_Heiting)\ **Replies:** 5\ **Last updated:** [February 22, 2023, 5:25pm UTC](https://forum.inductiveautomation.com/t/script-writing-to-a-memory-tag-dataset/70133 "2023-02-22T17:25:07Z")
I have a series of tags that are reading values from a plc. I'd like to consolidate these tags into a single dataset with the intention of binding a table's data to the dataset for easy display. My thought would be to h… --- ## [CheckBox Template repeater](https://forum.inductiveautomation.com/t/checkbox-template-repeater/65832)
**Author:** [@Dharani\_T](https://forum.inductiveautomation.com/u/Dharani_T)\ **Replies:** 26\ **Last updated:** [February 22, 2023, 4:46pm UTC](https://forum.inductiveautomation.com/t/checkbox-template-repeater/65832 "2023-02-22T16:46:35Z")
Hi, I would like to use checkbox as a template in vision and it will be repeated as per the selection in a radio button. For eg: If i have selected 'Equipment Failure' , i should be able to select only one option from … --- ## [Project Auditing Works But Gateway Auditing does not 8.1 (Version: 8.1.18 )](https://forum.inductiveautomation.com/t/project-auditing-works-but-gateway-auditing-does-not-8-1-version-8-1-18/68868)
**Author:** [@bfeas](https://forum.inductiveautomation.com/u/bfeas)\ **Replies:** 2\ **Last updated:** [February 22, 2023, 2:54pm UTC](https://forum.inductiveautomation.com/t/project-auditing-works-but-gateway-auditing-does-not-8-1-version-8-1-18/68868 "2023-02-22T14:54:59Z")
Does redundancy interfere with gateway auditing? We activated auditing on our test server and everything works great. Both Project and gateway changes are captured. Our production server is an exact replica of our tes… --- ## [\[IGN-5231\] jsonEncode issue](https://forum.inductiveautomation.com/t/ign-5231-jsonencode-issue/44603)
**Author:** [@dandersen](https://forum.inductiveautomation.com/u/dandersen)\ **Replies:** 26\ **Last updated:** [February 22, 2023, 2:44pm UTC](https://forum.inductiveautomation.com/t/ign-5231-jsonencode-issue/44603 "2023-02-22T14:44:51Z")
I must be missing something here. I call a function that returns a dictionary that I then encode into JSON. If I use the dictionary object returned by the function and pass it into the JSON encode, I hit a recursion er… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=698) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=700)