# Ignition

**URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=910

[Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md)

**Page:** 911

---

## [Ignition 7.9 Dropdown - Selected Value From Column X](https://forum.inductiveautomation.com/t/ignition-7-9-dropdown-selected-value-from-column-x/54570)

<div class="topic-metadata">

**Author:** [@Russell\_Gibson](https://forum.inductiveautomation.com/u/Russell_Gibson)\
**Replies:** 4\
**Last updated:** [January 3, 2022, 10:26am UTC](https://forum.inductiveautomation.com/t/ignition-7-9-dropdown-selected-value-from-column-x/54570 "2022-01-03T10:26:32Z")

</div>

Hi - Newbie to Ignition (apologies) coming from a WinCC/FactoryTalk background and used to VBScript etc. I’ve got a dropdown control ‘cboRecipe’ which I’ve populated in ‘table’ form from an SQL query - all good it pulls…

---

## [Want to access transaction group's "source value" and "latched value" in separate memory tag](https://forum.inductiveautomation.com/t/want-to-access-transaction-groups-source-value-and-latched-value-in-separate-memory-tag/54595)

<div class="topic-metadata">

**Author:** [@suryawanshinilesh](https://forum.inductiveautomation.com/u/suryawanshinilesh)\
**Replies:** 0\
**Last updated:** [January 3, 2022, 8:38am UTC](https://forum.inductiveautomation.com/t/want-to-access-transaction-groups-source-value-and-latched-value-in-separate-memory-tag/54595 "2022-01-03T08:38:03Z")

</div>

I want to access transaction group’s source value and latched value in separate tag is it possible ?

---

## [Force Default Value "\<Select One\>" in the Dropdown List](https://forum.inductiveautomation.com/t/force-default-value-select-one-in-the-dropdown-list/54583)

<div class="topic-metadata">

**Author:** [@Sam.Naji](https://forum.inductiveautomation.com/u/Sam.Naji)\
**Replies:** 5\
**Last updated:** [January 3, 2022, 1:11am UTC](https://forum.inductiveautomation.com/t/force-default-value-select-one-in-the-dropdown-list/54583 "2022-01-03T01:11:56Z")

</div>

How do I force “Select One” to show up on each of the “Dropdown List” components so I can select the wildcard (\*) in my Query when there is no selection? I want the “Select One” to be the default value for the “Dropdown …

---

## [Ignition Client hangs intermittently](https://forum.inductiveautomation.com/t/ignition-client-hangs-intermittently/53050)

<div class="topic-metadata">

**Author:** [@gkchan](https://forum.inductiveautomation.com/u/gkchan)\
**Replies:** 10\
**Last updated:** [January 2, 2022, 9:15pm UTC](https://forum.inductiveautomation.com/t/ignition-client-hangs-intermittently/53050 "2022-01-02T21:15:29Z")

</div>

What are the possible reasons that cause ignition client to hang (have already checked that the CPU and Memory utilisations are acceptable)? Will the .ignition cache build up over time cause the client to hang? What ar…

---

## [Default text style for Perspective - make it smaller](https://forum.inductiveautomation.com/t/default-text-style-for-perspective-make-it-smaller/54572)

<div class="topic-metadata">

**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Replies:** 2\
**Last updated:** [January 2, 2022, 2:16am UTC](https://forum.inductiveautomation.com/t/default-text-style-for-perspective-make-it-smaller/54572 "2022-01-02T02:16:28Z")

</div>

Is there an easy way to reduce the size of the default Perspective font? Will this work across all components (tables, charts, etc.)? I know that a theme’s CSS can be edited but that will affect projects other than min…

---

## [Leased Tag Groups and Gateway Networks](https://forum.inductiveautomation.com/t/leased-tag-groups-and-gateway-networks/54575)

<div class="topic-metadata">

**Author:** [@dtompkins](https://forum.inductiveautomation.com/u/dtompkins)\
**Replies:** 0\
**Last updated:** [January 1, 2022, 3:44pm UTC](https://forum.inductiveautomation.com/t/leased-tag-groups-and-gateway-networks/54575 "2022-01-01T15:44:36Z")

</div>

Do leased tags work over a gateway network in the same fashion as when the vision client is directly connected to the gateway??

---

## [Help about gateway](https://forum.inductiveautomation.com/t/help-about-gateway/54574)

<div class="topic-metadata">

**Author:** [@onur\_uzuner](https://forum.inductiveautomation.com/u/onur_uzuner)\
**Replies:** 1\
**Last updated:** [January 1, 2022, 3:04pm UTC](https://forum.inductiveautomation.com/t/help-about-gateway/54574 "2022-01-01T15:04:23Z")

</div>

wrapper.log (354.9 KB) I cant start the gateway , ı have tried a lot of things . can you help me please

---

## [Efficient workflow for tag folder structure tidy-up](https://forum.inductiveautomation.com/t/efficient-workflow-for-tag-folder-structure-tidy-up/54533)

<div class="topic-metadata">

**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Replies:** 2\
**Last updated:** [December 31, 2021, 7:08pm UTC](https://forum.inductiveautomation.com/t/efficient-workflow-for-tag-folder-structure-tidy-up/54533 "2021-12-31T19:08:34Z")

</div>

I want to take advantage of the holiday shutdown to do a bit of a tidy-up our OPC tag folder structure which was badly set up initially and contains misplaced tags and spelling mistakes. As far as I can see I need to do…

---

## [Version Controlling at the Project Scope](https://forum.inductiveautomation.com/t/version-controlling-at-the-project-scope/54546)

<div class="topic-metadata">

**Author:** [@dillon](https://forum.inductiveautomation.com/u/dillon)\
**Replies:** 1\
**Last updated:** [December 31, 2021, 4:38pm UTC](https://forum.inductiveautomation.com/t/version-controlling-at-the-project-scope/54546 "2021-12-31T16:38:42Z")

</div>

Hello all, I have an idea of having a git repository per project folder (Ignition/data/projects/NAME) instead of one repo for the gateway. I am currently trying this methodology and so far so good… The reasoning behind …

---

## [ImportError: no module named shared](https://forum.inductiveautomation.com/t/importerror-no-module-named-shared/54550)

<div class="topic-metadata">

**Author:** [@jtyler](https://forum.inductiveautomation.com/u/jtyler)\
**Replies:** 1\
**Last updated:** [December 31, 2021, 3:25pm UTC](https://forum.inductiveautomation.com/t/importerror-no-module-named-shared/54550 "2021-12-31T15:25:58Z")

</div>

Hello, I am receiving this error: Traceback (most recent call last): File “event:propertyChange”, line 2, in File “”, line 8, in check ImportError: No module named shared at org.python.core.Py.ImportError(Py.java:…

---

## [SQL error 145 querying a sqlexpress database](https://forum.inductiveautomation.com/t/sql-error-145-querying-a-sqlexpress-database/54556)

<div class="topic-metadata">

**Author:** [@Scott\_Kay](https://forum.inductiveautomation.com/u/Scott_Kay)\
**Replies:** 11\
**Last updated:** [December 31, 2021, 2:09pm UTC](https://forum.inductiveautomation.com/t/sql-error-145-querying-a-sqlexpress-database/54556 "2021-12-31T14:09:03Z")

</div>

When ever I query the database and try to expand a entry in the database I get a sql query error 145. SQLunknown SQL type -145. The database shows a valid connection. Not sure what to do to solve this. Database is …

---

## [Perspective flex repeater, cannot handle dictionary input within the instance parameters](https://forum.inductiveautomation.com/t/perspective-flex-repeater-cannot-handle-dictionary-input-within-the-instance-parameters/54542)

<div class="topic-metadata">

**Author:** [@tordvd](https://forum.inductiveautomation.com/u/tordvd)\
**Replies:** 6\
**Last updated:** [December 31, 2021, 8:23am UTC](https://forum.inductiveautomation.com/t/perspective-flex-repeater-cannot-handle-dictionary-input-within-the-instance-parameters/54542 "2021-12-31T08:23:07Z")

</div>

Hi, I think this is a bug, this is how my instances looks in the flex repeater: The resulting view picks up the other parameters (“Type/Description”) but not anything under “Navigation” Here is the targeted view: …

---

## [MalformedInputException error trying to import tags from AB csv file](https://forum.inductiveautomation.com/t/malformedinputexception-error-trying-to-import-tags-from-ab-csv-file/54548)

<div class="topic-metadata">

**Author:** [@hhbauss](https://forum.inductiveautomation.com/u/hhbauss)\
**Replies:** 7\
**Last updated:** [December 30, 2021, 7:33pm UTC](https://forum.inductiveautomation.com/t/malformedinputexception-error-trying-to-import-tags-from-ab-csv-file/54548 "2021-12-30T19:33:18Z")

</div>

java.nio.charset.MalformedInputException: Input length = 1 at java.base/java.lang.StringCoding.throwMalformed(Unknown Source) at java.base/java.lang.StringCoding.decodeUTF8\_0(Unknown Source) at java.base/java.lang.Str…

---

## [How to drop delete sql table in ignition](https://forum.inductiveautomation.com/t/how-to-drop-delete-sql-table-in-ignition/54547)

<div class="topic-metadata">

**Author:** [@Sam.Naji](https://forum.inductiveautomation.com/u/Sam.Naji)\
**Replies:** 3\
**Last updated:** [December 30, 2021, 7:23pm UTC](https://forum.inductiveautomation.com/t/how-to-drop-delete-sql-table-in-ignition/54547 "2021-12-30T19:23:46Z")

</div>

I am having trouble finding the syntax of how to drop an SQL table in Ignition. When I use this code in my script “Drop Table \[Ignition\].\[dbo\].\[PT\_Downtimme\]” I get this error: (Parse error for event handler “actionP…

---

## [Access StringArray Tag elements from script](https://forum.inductiveautomation.com/t/access-stringarray-tag-elements-from-script/15097)

<div class="topic-metadata">

**Author:** [@patrick.maltais](https://forum.inductiveautomation.com/u/patrick.maltais)\
**Replies:** 8\
**Last updated:** [August 24, 2017, 3:35pm UTC](https://forum.inductiveautomation.com/t/access-stringarray-tag-elements-from-script/15097 "2017-08-24T15:35:09Z")

</div>

I'm looking for a way to access individual elements inside a tag that has been configured as StringArray. I want to access it from within a script. How can I do that? In fact, I need to know the uper bound which could be…

---

## [Markdown renderers property](https://forum.inductiveautomation.com/t/markdown-renderers-property/54545)

<div class="topic-metadata">

**Author:** [@djs](https://forum.inductiveautomation.com/u/djs)\
**Replies:** 0\
**Last updated:** [December 30, 2021, 4:05pm UTC](https://forum.inductiveautomation.com/t/markdown-renderers-property/54545 "2021-12-30T16:05:16Z")

</div>

Does anyone have an example of how to use the Markdown component’s renderers property? Can’t find much about it…

---

## [SQL: Error binding needs "double"](https://forum.inductiveautomation.com/t/sql-error-binding-needs-double/54544)

<div class="topic-metadata">

**Author:** [@Nicholas\_Fuglsby](https://forum.inductiveautomation.com/u/Nicholas_Fuglsby)\
**Replies:** 1\
**Last updated:** [December 30, 2021, 3:40pm UTC](https://forum.inductiveautomation.com/t/sql-error-binding-needs-double/54544 "2021-12-30T15:40:46Z")

</div>

I am having a tag quality Error\_DatabaseQuery. It is giving value however it is in red because of quality. Exception: Conversion error: query returned null, binding needs “double” on query binding for “Main Window.Roo…

---

## [Check role to open page](https://forum.inductiveautomation.com/t/check-role-to-open-page/54539)

<div class="topic-metadata">

**Author:** [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\
**Replies:** 2\
**Last updated:** [December 30, 2021, 2:33pm UTC](https://forum.inductiveautomation.com/t/check-role-to-open-page/54539 "2021-12-30T14:33:44Z")

</div>

Good afternoon, I would like to ask your help to understand which is the better way to check the actual role with a dataset of roles to open a page. I create a dataset memory tag where I add the roles I want to be able…

---

## [Data Binding in Status chart Perspective](https://forum.inductiveautomation.com/t/data-binding-in-status-chart-perspective/54476)

<div class="topic-metadata">

**Author:** [@manjuyadav95.m](https://forum.inductiveautomation.com/u/manjuyadav95.m)\
**Replies:** 2\
**Last updated:** [December 30, 2021, 11:08am UTC](https://forum.inductiveautomation.com/t/data-binding-in-status-chart-perspective/54476 "2021-12-30T11:08:36Z")

</div>

In the below status chart, under data sources, there are series0, series 1, unlike other charts where only example prop will be there for data binding…here I am confused that where to bind the dataset …plz help … @victo…

---

## [\[Bug 2735\] Designer sometimes launches with only 256MB memory](https://forum.inductiveautomation.com/t/bug-2735-designer-sometimes-launches-with-only-256mb-memory/48536)

<div class="topic-metadata">

**Author:** [@Cory.grube](https://forum.inductiveautomation.com/u/Cory.grube)\
**Replies:** 7\
**Last updated:** [December 29, 2021, 11:31pm UTC](https://forum.inductiveautomation.com/t/bug-2735-designer-sometimes-launches-with-only-256mb-memory/48536 "2021-12-29T23:31:43Z")

</div>

Launcher v1.1.7 I’ve noticed this problem on a few instances. If I leave my Designer Launcher open for long periods of time (days), any designer launched will have a max of 256MB memory, rather than whatever is specifie…

---

## [Forcing a Database prune](https://forum.inductiveautomation.com/t/forcing-a-database-prune/54529)

<div class="topic-metadata">

**Author:** [@doug.breshears](https://forum.inductiveautomation.com/u/doug.breshears)\
**Replies:** 1\
**Last updated:** [December 29, 2021, 11:10pm UTC](https://forum.inductiveautomation.com/t/forcing-a-database-prune/54529 "2021-12-29T23:10:56Z")

</div>

I have a version 7.9 install that has run out of disk space on the database partition. I enabled pruning in the gateway tag-\>history section but I am not seeing the condition change after more than an hour. I have reboot…

---

## [Designer freezes for ~3Min when attempting tag import/export](https://forum.inductiveautomation.com/t/designer-freezes-for-3min-when-attempting-tag-import-export/54519)

<div class="topic-metadata">

**Author:** [@Jacob\_Sanchez](https://forum.inductiveautomation.com/u/Jacob_Sanchez)\
**Replies:** 2\
**Last updated:** [December 29, 2021, 6:15pm UTC](https://forum.inductiveautomation.com/t/designer-freezes-for-3min-when-attempting-tag-import-export/54519 "2021-12-29T18:15:33Z")

</div>

Ignition 8.0.9 When right clicking on a tag in the tag explorer, and selecting either Import or Export, designer becomes unresponsive for approx 3-5 minutes after which the browse window appears. If i attempt to navigat…

---

## [MySql connection to a remote Ignition Gateway](https://forum.inductiveautomation.com/t/mysql-connection-to-a-remote-ignition-gateway/54515)

<div class="topic-metadata">

**Author:** [@ashwin.m](https://forum.inductiveautomation.com/u/ashwin.m)\
**Replies:** 5\
**Last updated:** [December 29, 2021, 5:48pm UTC](https://forum.inductiveautomation.com/t/mysql-connection-to-a-remote-ignition-gateway/54515 "2021-12-29T17:48:33Z")

</div>

If am not able to connect the gateway to a remote MySql server. Could you please help me to do the same. I checked the manual. It does not show the configuration at the server end.

---

## [Flex Repeater not refreshing when \`instances\` list changes](https://forum.inductiveautomation.com/t/flex-repeater-not-refreshing-when-instances-list-changes/54508)

<div class="topic-metadata">

**Author:** [@thewebpleb](https://forum.inductiveautomation.com/u/thewebpleb)\
**Replies:** 5\
**Last updated:** [December 29, 2021, 4:57pm UTC](https://forum.inductiveautomation.com/t/flex-repeater-not-refreshing-when-instances-list-changes/54508 "2021-12-29T16:57:04Z")

</div>

I'm trying to figure out why the flex repeater won't refresh what is displayed when the instances list changes. I have a flex repeater that starts out with 4 objects (the actual number of objects doesn't matter). I have…

---

## [Dynamically reading templates on a window](https://forum.inductiveautomation.com/t/dynamically-reading-templates-on-a-window/54509)

<div class="topic-metadata">

**Author:** [@szcz](https://forum.inductiveautomation.com/u/szcz)\
**Replies:** 3\
**Last updated:** [December 29, 2021, 2:13pm UTC](https://forum.inductiveautomation.com/t/dynamically-reading-templates-on-a-window/54509 "2021-12-29T14:13:18Z")

</div>

Hello dear Ignited, I can’t wrap my head around yet simple concept. I have 30+ templates within a “bigger” template (that “bigger” template is then placed on a Main window). Inside this “bigger” template, there is also …

---

## [Ignition 7.7.6 TCP Connection Lost](https://forum.inductiveautomation.com/t/ignition-7-7-6-tcp-connection-lost/25412)

<div class="topic-metadata">

**Author:** [@giulianacaula](https://forum.inductiveautomation.com/u/giulianacaula)\
**Replies:** 2\
**Last updated:** [December 29, 2021, 10:19am UTC](https://forum.inductiveautomation.com/t/ignition-7-7-6-tcp-connection-lost/25412 "2021-12-29T10:19:31Z")

</div>

Hi everyone! I’m having troubles with a TCP/IP device I’m connected to. The connection is succsesfull but in the logs every few seconds appears an ERROR message saying: ERROR \[TCPConnection\[1749\] \] \[10:35:03…

---

## [Siemens struct datatype](https://forum.inductiveautomation.com/t/siemens-struct-datatype/54496)

<div class="topic-metadata">

**Author:** [@Corentin.appart](https://forum.inductiveautomation.com/u/Corentin.appart)\
**Replies:** 5\
**Last updated:** [December 29, 2021, 8:15am UTC](https://forum.inductiveautomation.com/t/siemens-struct-datatype/54496 "2021-12-29T08:15:24Z")

</div>

Hello all, I need help to get value from a struct Datatype of a Siemens S7-1500 . i don’t know the syntax for getting “Vitesse” for exemple. Thanks in advance :slight\_smile:

---

## [Access single views in a Flex Repeater](https://forum.inductiveautomation.com/t/access-single-views-in-a-flex-repeater/31140)

<div class="topic-metadata">

**Author:** [@petar.zurzevic](https://forum.inductiveautomation.com/u/petar.zurzevic)\
**Replies:** 6\
**Last updated:** [December 29, 2021, 3:36am UTC](https://forum.inductiveautomation.com/t/access-single-views-in-a-flex-repeater/31140 "2021-12-29T03:36:40Z")

</div>

I am working with perspective and using a flex repeater. I am repeating a simple view composed by a checkBox and 2 input parameters (text:sets the checkbox text when i create it, select:the the checbox value default to …

---

## [What does the ignition performance chart means?](https://forum.inductiveautomation.com/t/what-does-the-ignition-performance-chart-means/54472)

<div class="topic-metadata">

**Author:** [@gkchan](https://forum.inductiveautomation.com/u/gkchan)\
**Replies:** 3\
**Last updated:** [December 29, 2021, 2:27am UTC](https://forum.inductiveautomation.com/t/what-does-the-ignition-performance-chart-means/54472 "2021-12-29T02:27:32Z")

</div>

Noticed the below performance charts for Tag throughput and memory has a gap. What does it mean by this gap and is it normal to see this? Thanks in advance for the advice.

---

## [SQL time convert error](https://forum.inductiveautomation.com/t/sql-time-convert-error/54467)

<div class="topic-metadata">

**Author:** [@Fernando\_Alonso\_Aram](https://forum.inductiveautomation.com/u/Fernando_Alonso_Aram)\
**Replies:** 4\
**Last updated:** [December 29, 2021, 2:14am UTC](https://forum.inductiveautomation.com/t/sql-time-convert-error/54467 "2021-12-29T02:14:03Z")

</div>

Hello. Im searching for help to run a script to sql database, i´m using 2 date time inputs as a range of time to search in sql but i get conversion error. some of you had an idea how to fix?

[Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=909)

[Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=911)