# General Discussion **URL:** https://forum.inductiveautomation.com/c/general-discussion/5.md?page=41 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 42 --- ## [Limiting result to the first row returned in query](https://forum.inductiveautomation.com/t/limiting-result-to-the-first-row-returned-in-query/73598)
**Author:** [@Javontez\_Robinson](https://forum.inductiveautomation.com/u/Javontez_Robinson)\ **Replies:** 3\ **Last updated:** [May 11, 2023, 4:22pm UTC](https://forum.inductiveautomation.com/t/limiting-result-to-the-first-row-returned-in-query/73598 "2023-05-11T16:22:53Z")
I have a SQL statement that I want to linit my results to the top row of returned data, but I am getting an error. SELECT \* FROM BACON\_ASSEMBLY\_LOG with (nolock) Where StationID = '137' order by StartTimeStamp desc F… --- ## [Translation manager do not show up](https://forum.inductiveautomation.com/t/translation-manager-do-not-show-up/73591)
**Author:** [@patrick.hamel.sbei](https://forum.inductiveautomation.com/u/patrick.hamel.sbei)\ **Replies:** 3\ **Last updated:** [May 11, 2023, 3:23pm UTC](https://forum.inductiveautomation.com/t/translation-manager-do-not-show-up/73591 "2023-05-11T15:23:26Z")
Translation manager do not show up once selected in designer/tools ? Anyone has this issue in the past ? --- ## [MySQL Database Faulted](https://forum.inductiveautomation.com/t/mysql-database-faulted/14418)
**Author:** [@gglenn](https://forum.inductiveautomation.com/u/gglenn)\ **Replies:** 1\ **Last updated:** [September 18, 2017, 1:02pm UTC](https://forum.inductiveautomation.com/t/mysql-database-faulted/14418 "2017-09-18T13:02:40Z")
Just this past Friday the database connection was reported as faulted. Up till then my Ignition application has been working perfectly and there have been no recent changes or updates. Looking at the Gateway it indicate… --- ## [Siemens, OPC UA Write in Array of Data type](https://forum.inductiveautomation.com/t/siemens-opc-ua-write-in-array-of-data-type/69612)
**Author:** [@MaximePuntis](https://forum.inductiveautomation.com/u/MaximePuntis)\ **Replies:** 8\ **Last updated:** [May 10, 2023, 9:58am UTC](https://forum.inductiveautomation.com/t/siemens-opc-ua-write-in-array-of-data-type/69612 "2023-05-10T09:58:13Z")
Hi, Configuration : PLC Siemens 1500, OPC UA communication . I love the possibilities of the native OPC UA in the siemens and ignition. But when a great tool, we always try to do more and I came across a problem: I can… --- ## [New to Linux, basic questions](https://forum.inductiveautomation.com/t/new-to-linux-basic-questions/73497)
**Author:** [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Replies:** 1\ **Last updated:** [May 9, 2023, 7:53pm UTC](https://forum.inductiveautomation.com/t/new-to-linux-basic-questions/73497 "2023-05-09T19:53:39Z")
I am reading that Microsoft uses Linux servers to run Azure. I read Headless Linux Install\] I was wondering how beneficial switching to running gateways on Linux is. I also wondered if I have a gateway that is being r… --- ## [Found a funny folder someone left in a project](https://forum.inductiveautomation.com/t/found-a-funny-folder-someone-left-in-a-project/73370)
**Author:** [@andrews](https://forum.inductiveautomation.com/u/andrews)\ **Replies:** 1\ **Last updated:** [May 7, 2023, 8:35pm UTC](https://forum.inductiveautomation.com/t/found-a-funny-folder-someone-left-in-a-project/73370 "2023-05-07T20:35:56Z")
So I was making some updates to a customers project. Which led me to browsing image folders. Among some of their other customers "stuff" (They probably should have removed) I found this gold. And I just had to share it. … --- ## [Create conveyor moving visually in ignition designer](https://forum.inductiveautomation.com/t/create-conveyor-moving-visually-in-ignition-designer/73362)
**Author:** [@kevin\_Kuruvilla](https://forum.inductiveautomation.com/u/kevin_Kuruvilla)\ **Replies:** 5\ **Last updated:** [May 7, 2023, 2:23am UTC](https://forum.inductiveautomation.com/t/create-conveyor-moving-visually-in-ignition-designer/73362 "2023-05-07T02:23:51Z")
Hi, I am new to ignition designer, i would like to know how to create a conveyor rotating visually using the designer tool. I tried once approach by placing a rectangle object on top of the conveyor block from library w… --- ## [Topics I created that are not marked with solution / solved](https://forum.inductiveautomation.com/t/topics-i-created-that-are-not-marked-with-solution-solved/73210)
**Author:** [@rfolkes](https://forum.inductiveautomation.com/u/rfolkes)\ **Replies:** 6\ **Last updated:** [May 3, 2023, 5:05pm UTC](https://forum.inductiveautomation.com/t/topics-i-created-that-are-not-marked-with-solution-solved/73210 "2023-05-03T17:05:09Z")
Can you add a way to look at your own profile and see all topics I have started that have not been marked with a solution and/or solved? I hate finding questions through search and not finding a marked solution. I try… --- ## [Replacing national characters in the string with ASCII symbols](https://forum.inductiveautomation.com/t/replacing-national-characters-in-the-string-with-ascii-symbols/73193)
**Author:** [@Gediminas\_Labutis](https://forum.inductiveautomation.com/u/Gediminas_Labutis)\ **Replies:** 5\ **Last updated:** [May 3, 2023, 12:34pm UTC](https://forum.inductiveautomation.com/t/replacing-national-characters-in-the-string-with-ascii-symbols/73193 "2023-05-03T12:34:21Z")
We want to display logged in user on machine HMI. User name is retrieved from database and includes national characters. However, HMI accepts only ASCII symbols. How can I replace national symbols in Ignition string type… --- ## [Ignition Certification Badge disabled?](https://forum.inductiveautomation.com/t/ignition-certification-badge-disabled/73035)
**Author:** [@PRAMANJ](https://forum.inductiveautomation.com/u/PRAMANJ)\ **Replies:** 12\ **Last updated:** [May 2, 2023, 3:55pm UTC](https://forum.inductiveautomation.com/t/ignition-certification-badge-disabled/73035 "2023-05-02T15:55:31Z")
I observe that the Ignition certification badge that used to appear on our web pages on embedding a URL provided by IA, is not visible anymore! Only a place holder icon for image appears! Is it disabled by IA now a days … --- ## [Tunneller integration and connection to OPC DA server](https://forum.inductiveautomation.com/t/tunneller-integration-and-connection-to-opc-da-server/72530)
**Author:** [@Gourav\_Kumar](https://forum.inductiveautomation.com/u/Gourav_Kumar)\ **Replies:** 1\ **Last updated:** [May 1, 2023, 11:08pm UTC](https://forum.inductiveautomation.com/t/tunneller-integration-and-connection-to-opc-da-server/72530 "2023-05-01T23:08:22Z")
Dear Team, I have to integrate remote OPC DA server, so i understand that i will use "Tunneler driver "on my local ignition PC and remote PC and in remote PC, i need to integrate OPC DA using Ignition OPC DA driver. In… --- ## [How to get remote tag provider name within a transaction group](https://forum.inductiveautomation.com/t/how-to-get-remote-tag-provider-name-within-a-transaction-group/72980)
**Author:** [@David\_Anderson](https://forum.inductiveautomation.com/u/David_Anderson)\ **Replies:** 2\ **Last updated:** [May 1, 2023, 2:28pm UTC](https://forum.inductiveautomation.com/t/how-to-get-remote-tag-provider-name-within-a-transaction-group/72980 "2023-05-01T14:28:16Z")
How can I get the name of the remote tag provider within a transaction group. I drag the desired tags from the browser onto the project grid (from 1 of many providers)... Those tags may come from a specific tag provi… --- ## [Dropdown Default Value](https://forum.inductiveautomation.com/t/dropdown-default-value/73052)
**Author:** [@Daniel\_Sheldon-Colli](https://forum.inductiveautomation.com/u/Daniel_Sheldon-Colli)\ **Replies:** 24\ **Last updated:** [May 1, 2023, 2:19am UTC](https://forum.inductiveautomation.com/t/dropdown-default-value/73052 "2023-05-01T02:19:23Z")
Hello, New to Ignition Hope everyone is well, i have two drop down menus, one selects the variable name i want to write to and the other is the variable value, the first defaults to the first in the list, but the seco… --- ## [Thanks you Documentation team](https://forum.inductiveautomation.com/t/thanks-you-documentation-team/73046)
**Author:** [@zacht](https://forum.inductiveautomation.com/u/zacht)\ **Replies:** 0\ **Last updated:** [April 28, 2023, 9:28pm UTC](https://forum.inductiveautomation.com/t/thanks-you-documentation-team/73046 "2023-04-28T21:28:51Z")
I was baffled today that an onCellEdited event seemed to be firing twice for every edit. I could not figure out why (no loops or anything). When I finally decided to RTFM the answer was just sitting there waiting for me. … --- ## [Report Save Function Issue](https://forum.inductiveautomation.com/t/report-save-function-issue/72941)
**Author:** [@hhbauss](https://forum.inductiveautomation.com/u/hhbauss)\ **Replies:** 3\ **Last updated:** [April 27, 2023, 12:50pm UTC](https://forum.inductiveautomation.com/t/report-save-function-issue/72941 "2023-04-27T12:50:50Z")
When I type in the 'settings' parameters following the example in the manual to save a report: # Executes and distributes the report to save a PDF settings = {"path":"C:\\\\Ignition Reports", "fileName":"Report.pdf", "for… --- ## [Delete data in a POSTGRES row](https://forum.inductiveautomation.com/t/delete-data-in-a-postgres-row/72932)
**Author:** [@enea\_aloise](https://forum.inductiveautomation.com/u/enea_aloise)\ **Replies:** 1\ **Last updated:** [April 27, 2023, 2:12am UTC](https://forum.inductiveautomation.com/t/delete-data-in-a-postgres-row/72932 "2023-04-27T02:12:08Z")
Hi all, I have the following problem. Practically in a power table connected to a POSTGRES table I can insert and modify data of any type. My problem is as follows. How can I go about deleting data in a table row via … --- ## [SQL Database Normalization design recommendations](https://forum.inductiveautomation.com/t/sql-database-normalization-design-recommendations/71284)
**Author:** [@rpavlicek](https://forum.inductiveautomation.com/u/rpavlicek)\ **Replies:** 11\ **Last updated:** [April 26, 2023, 5:18pm UTC](https://forum.inductiveautomation.com/t/sql-database-normalization-design-recommendations/71284 "2023-04-26T17:18:00Z")
I'm creating an internal inventory program and setting up the database tables using SQL Server. I would like to normalize the table structure to 3NF or BCNF standards. One issue I have is completely understanding what … --- ## [Is it possible to configure Ignition to stream gateway logs to third party database/ service](https://forum.inductiveautomation.com/t/is-it-possible-to-configure-ignition-to-stream-gateway-logs-to-third-party-database-service/72752)
**Author:** [@Rahul\_k](https://forum.inductiveautomation.com/u/Rahul_k)\ **Replies:** 2\ **Last updated:** [April 24, 2023, 2:27pm UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-configure-ignition-to-stream-gateway-logs-to-third-party-database-service/72752 "2023-04-24T14:27:34Z")
I am looking for a Ignition module which can stream gateway logs to third party resources like Kinesis. I found AWS Injector module which can publish tag values to kinesis. Is there a way to re-use AWS Injector or any o… --- ## [Has anybody run Ignition edge panel gateway in a docker?](https://forum.inductiveautomation.com/t/has-anybody-run-ignition-edge-panel-gateway-in-a-docker/72732)
**Author:** [@Simen\_Minerd](https://forum.inductiveautomation.com/u/Simen_Minerd)\ **Replies:** 5\ **Last updated:** [April 21, 2023, 7:50pm UTC](https://forum.inductiveautomation.com/t/has-anybody-run-ignition-edge-panel-gateway-in-a-docker/72732 "2023-04-21T19:50:46Z")
Have anybody run Ignition Edge Panel Gateway in a docker? What is the advantage of running Ignition in docker container? If I have a IGN300 pc with windows operating system, would it be easier just run Ignition Edge Pa… --- ## [Float swap reading](https://forum.inductiveautomation.com/t/float-swap-reading/72711)
**Author:** [@remus\_baylor](https://forum.inductiveautomation.com/u/remus_baylor)\ **Replies:** 10\ **Last updated:** [April 20, 2023, 7:34pm UTC](https://forum.inductiveautomation.com/t/float-swap-reading/72711 "2023-04-20T19:34:47Z")
Good Morning. I am having trouble reading float values to Ignition from a Schneider Electric PM5400. The modbus registers in PM5400 are 32bit. I can read these data through modscan (Swapped FP) but not in Ignition. I … --- ## [Convert unicode from API Endpoint (csv) to csv or jason or pydataset](https://forum.inductiveautomation.com/t/convert-unicode-from-api-endpoint-csv-to-csv-or-jason-or-pydataset/72721)
**Author:** [@Mahesh\_Madapathi](https://forum.inductiveautomation.com/u/Mahesh_Madapathi)\ **Replies:** 4\ **Last updated:** [April 20, 2023, 6:26pm UTC](https://forum.inductiveautomation.com/t/convert-unicode-from-api-endpoint-csv-to-csv-or-jason-or-pydataset/72721 "2023-04-20T18:26:06Z")
I made a HTTP request to a CSV API Endpoint. I used response = system.net.httpGet(url,'','','','',header) and the response received is of 'unicode type. type(response) \ How can I convert it to … --- ## [How can I subscribe to a webhook to receive data?](https://forum.inductiveautomation.com/t/how-can-i-subscribe-to-a-webhook-to-receive-data/72716)
**Author:** [@Mahesh\_Madapathi](https://forum.inductiveautomation.com/u/Mahesh_Madapathi)\ **Replies:** 1\ **Last updated:** [April 20, 2023, 4:57pm UTC](https://forum.inductiveautomation.com/t/how-can-i-subscribe-to-a-webhook-to-receive-data/72716 "2023-04-20T16:57:15Z")
I need to subscribe to a webhook and get data as data is changed or created at the source. How can I achieve this? --- ## [XY Chart: how to prevent long text getting clustered? Is there a way to break it into multiple lines?](https://forum.inductiveautomation.com/t/xy-chart-how-to-prevent-long-text-getting-clustered-is-there-a-way-to-break-it-into-multiple-lines/71273)
**Author:** [@Lalillo1](https://forum.inductiveautomation.com/u/Lalillo1)\ **Replies:** 4\ **Last updated:** [April 19, 2023, 5:32pm UTC](https://forum.inductiveautomation.com/t/xy-chart-how-to-prevent-long-text-getting-clustered-is-there-a-way-to-break-it-into-multiple-lines/71273 "2023-04-19T17:32:29Z")
Hello, This is my issue I am trying to correct in the x-axis label: The x axis label comes from my data source: "label" column... So, in my series setup, I call for the "label" column as my x-axis label. However … --- ## [Windows Authentication](https://forum.inductiveautomation.com/t/windows-authentication/41363)
**Author:** [@f1\_beto](https://forum.inductiveautomation.com/u/f1_beto)\ **Replies:** 4\ **Last updated:** [April 18, 2023, 3:52pm UTC](https://forum.inductiveautomation.com/t/windows-authentication/41363 "2023-04-18T15:52:12Z")
hi i have problem with Windows Authentication. I copied the file “JDBC Driver for SQL Servers” (qljdbc\_auth.dll) in the path C:\\Program Files\\Inductive Automation\\Ignition\\lib\\ but not work well. i have this error … --- ## [Change color of the text in ignition style](https://forum.inductiveautomation.com/t/change-color-of-the-text-in-ignition-style/72399)
**Author:** [@Senthoor\_Mani\_M](https://forum.inductiveautomation.com/u/Senthoor_Mani_M)\ **Replies:** 16\ **Last updated:** [April 18, 2023, 10:57am UTC](https://forum.inductiveautomation.com/t/change-color-of-the-text-in-ignition-style/72399 "2023-04-18T10:57:59Z")
Ignition style, Base Style Background color and Element State (Hover) Background color is working but, same format in text color is not working, text is only follow the base style color the hover text color was not acce… --- ## [AutomationDirect Clic Plus OPC Device driver with Ethernet/IP](https://forum.inductiveautomation.com/t/automationdirect-clic-plus-opc-device-driver-with-ethernet-ip/72533)
**Author:** [@Marcus\_Sternberg](https://forum.inductiveautomation.com/u/Marcus_Sternberg)\ **Replies:** 5\ **Last updated:** [April 17, 2023, 8:49pm UTC](https://forum.inductiveautomation.com/t/automationdirect-clic-plus-opc-device-driver-with-ethernet-ip/72533 "2023-04-17T20:49:35Z")
I have observed threads stating people are successful with connecting to the AutomationDirect Clic Plus PLCs over ModbusTCP. Has anyone been successful on a device driver using Ethernet/IP. If so, which OPC device driv… --- ## [Ignition not able to browse local Matrikon server](https://forum.inductiveautomation.com/t/ignition-not-able-to-browse-local-matrikon-server/72495)
**Author:** [@Gourav\_Kumar](https://forum.inductiveautomation.com/u/Gourav_Kumar)\ **Replies:** 2\ **Last updated:** [April 17, 2023, 2:08pm UTC](https://forum.inductiveautomation.com/t/ignition-not-able-to-browse-local-matrikon-server/72495 "2023-04-17T14:08:43Z")
I have installed Matrikon server simulator into local machine and when i try to browse the Matrikon server from Ignition - Client ..i am not able to get matrikon ..Can you pls help what the issue Refer image ...at b… --- ## [Network Setup Best Practices](https://forum.inductiveautomation.com/t/network-setup-best-practices/20351)
**Author:** [@jgoodwill](https://forum.inductiveautomation.com/u/jgoodwill)\ **Replies:** 13\ **Last updated:** [April 15, 2023, 9:00pm UTC](https://forum.inductiveautomation.com/t/network-setup-best-practices/20351 "2023-04-15T21:00:19Z")
Does anyone have any information/guides on best practices for setting up the network that Ignition and all other industrial ethernet equipment will be connected to? Basically looking for a guide on how to setup all the … --- ## [History log - Ignition Edge](https://forum.inductiveautomation.com/t/history-log-ignition-edge/72071)
**Author:** [@Joze\_Cvelbar](https://forum.inductiveautomation.com/u/Joze_Cvelbar)\ **Replies:** 1\ **Last updated:** [April 14, 2023, 10:15pm UTC](https://forum.inductiveautomation.com/t/history-log-ignition-edge/72071 "2023-04-14T22:15:24Z")
Hi, I have issues with memory overload of History log when MQTT connection is lost. Where can I check which tags and how many are to be transfered and are waiting in In-memory? I need to inspect the amount of memor… --- ## [Inactivey Timeout Settings](https://forum.inductiveautomation.com/t/inactivey-timeout-settings/72461)
**Author:** [@ahawes](https://forum.inductiveautomation.com/u/ahawes)\ **Replies:** 1\ **Last updated:** [April 14, 2023, 3:59pm UTC](https://forum.inductiveautomation.com/t/inactivey-timeout-settings/72461 "2023-04-14T15:59:22Z")
Good morning Team, Is there a way, other than project properties Perspective/Inactivity, to confiture a time out by role or maybe user signon? I have looked in the forums and see a few examples but not sure the best wa… [Previous page](https://forum.inductiveautomation.com/c/general-discussion/5.md?page=40) [Next page](https://forum.inductiveautomation.com/c/general-discussion/5.md?page=42)