# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=556 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 557 --- ## [Ignition Report - Version key is not working as intended](https://forum.inductiveautomation.com/t/ignition-report-version-key-is-not-working-as-intended/80426)
**Author:** [@Rohit\_Das](https://forum.inductiveautomation.com/u/Rohit_Das)\ **Replies:** 1\ **Last updated:** [October 13, 2023, 2:58pm UTC](https://forum.inductiveautomation.com/t/ignition-report-version-key-is-not-working-as-intended/80426 "2023-10-13T14:58:55Z")
While creating report, added 2 row versions - Standard and Completed The row versions depends on value of 3 different keys - x,y,z I added version key like - (x != NULL && y != NULL && z != NULL)?"Completed":"Standard… --- ## [System.db.RunNamedQuery on Tag Value Changed Not Working](https://forum.inductiveautomation.com/t/system-db-runnamedquery-on-tag-value-changed-not-working/80370)
**Author:** [@Ly17](https://forum.inductiveautomation.com/u/Ly17)\ **Replies:** 3\ **Last updated:** [October 13, 2023, 2:52pm UTC](https://forum.inductiveautomation.com/t/system-db-runnamedquery-on-tag-value-changed-not-working/80370 "2023-10-13T14:52:54Z")
I have the following script in the "Value Changed" under Value Events for one of my tags and it doesn't work but works fine when I run it on the script console. parameters = {"Takt":RRvalue, "ProdLine":ProdLine, "Prod… --- ## [How to change color of timestamp and line of X-Trace in Chart](https://forum.inductiveautomation.com/t/how-to-change-color-of-timestamp-and-line-of-x-trace-in-chart/80416)
**Author:** [@gpellicelli](https://forum.inductiveautomation.com/u/gpellicelli)\ **Replies:** 2\ **Last updated:** [October 13, 2023, 2:50pm UTC](https://forum.inductiveautomation.com/t/how-to-change-color-of-timestamp-and-line-of-x-trace-in-chart/80416 "2023-10-13T14:50:24Z")
Hello am formation a Chart and I change label color backround and font for X-trace but The font and color of my timestamp don't change and I don't know how to acces. Any one have an idea. --- ## [Weirdly ordered list](https://forum.inductiveautomation.com/t/weirdly-ordered-list/80302)
**Author:** [@Chad\_Gregory](https://forum.inductiveautomation.com/u/Chad_Gregory)\ **Replies:** 8\ **Last updated:** [October 13, 2023, 2:39pm UTC](https://forum.inductiveautomation.com/t/weirdly-ordered-list/80302 "2023-10-13T14:39:11Z")
I have been thinking as to how I could accomplish this weird list in Ignition. On our production line we have a conveyor where parts marked suspect are placed. These parts needs to be dispositioned by an associate. Wh… --- ## [Picking string out of dataset based on the value that is bound to it. not by selecting the row](https://forum.inductiveautomation.com/t/picking-string-out-of-dataset-based-on-the-value-that-is-bound-to-it-not-by-selecting-the-row/80451)
**Author:** [@Stef\_Velers](https://forum.inductiveautomation.com/u/Stef_Velers)\ **Replies:** 8\ **Last updated:** [October 13, 2023, 2:35pm UTC](https://forum.inductiveautomation.com/t/picking-string-out-of-dataset-based-on-the-value-that-is-bound-to-it-not-by-selecting-the-row/80451 "2023-10-13T14:35:40Z")
hello, I trying to get a string out of my dataset based on the value that is in the same row as the string not by selecting a row number. I want to do this with the value instead of the row number because I have a tag t… --- ## [How to Send Derived tag Value of String to PLC via OPC](https://forum.inductiveautomation.com/t/how-to-send-derived-tag-value-of-string-to-plc-via-opc/80392)
**Author:** [@SANJAY\_SAUNDATTIKAR](https://forum.inductiveautomation.com/u/SANJAY_SAUNDATTIKAR)\ **Replies:** 16\ **Last updated:** [October 13, 2023, 1:38pm UTC](https://forum.inductiveautomation.com/t/how-to-send-derived-tag-value-of-string-to-plc-via-opc/80392 "2023-10-13T13:38:07Z")
Hi Gents, Sorry if i ask a stupid question in this forum. I am just started developing some ignition project and would going in to more details. I ma having a tag which is derived tag , which i am converting Current d… --- ## [Time format on Easy Chart X-axis and X-Trace](https://forum.inductiveautomation.com/t/time-format-on-easy-chart-x-axis-and-x-trace/80437)
**Author:** [@LenRem1](https://forum.inductiveautomation.com/u/LenRem1)\ **Replies:** 12\ **Last updated:** [October 13, 2023, 1:28pm UTC](https://forum.inductiveautomation.com/t/time-format-on-easy-chart-x-axis-and-x-trace/80437 "2023-10-13T13:28:48Z")
I cannot find a property where I can set the default date/time format for the whole of Ignition or the date/time format used by EasyChart for X-axis times and X-Trace times. I am running v8.1.31 on W10 in Europe. W10 f… --- ## [Component/View Path Syntax](https://forum.inductiveautomation.com/t/component-view-path-syntax/80412)
**Author:** [@Felipe\_CRM](https://forum.inductiveautomation.com/u/Felipe_CRM)\ **Replies:** 2\ **Last updated:** [October 13, 2023, 1:14pm UTC](https://forum.inductiveautomation.com/t/component-view-path-syntax/80412 "2023-10-13T13:14:51Z")
Continuing the discussion from Page path displayed in Perspective sessions: Could someone go into a little more detail about the container syntax? It occasionally comes up on binding warnings and it would be nice to be… --- ## [Report Module takes a long time to generate PDF Report](https://forum.inductiveautomation.com/t/report-module-takes-a-long-time-to-generate-pdf-report/80443)
**Author:** [@Chad\_Beebe](https://forum.inductiveautomation.com/u/Chad_Beebe)\ **Replies:** 4\ **Last updated:** [October 13, 2023, 1:06pm UTC](https://forum.inductiveautomation.com/t/report-module-takes-a-long-time-to-generate-pdf-report/80443 "2023-10-13T13:06:43Z")
I am having an issue where the Reporting Module takes a very long time to generate a PDF Report. The report is a 2 page report with the first page being an overview page of the build options for the work order and part … --- ## [Swedish letter conversion](https://forum.inductiveautomation.com/t/swedish-letter-conversion/80438)
**Author:** [@Rickard\_Nordwall](https://forum.inductiveautomation.com/u/Rickard_Nordwall)\ **Replies:** 2\ **Last updated:** [October 13, 2023, 12:49pm UTC](https://forum.inductiveautomation.com/t/swedish-letter-conversion/80438 "2023-10-13T12:49:54Z")
Hi, I have problems with Swedish letters in Ignitions Perspective module. I'm working on a project where the customer wants the Swedish letters å, ä & ö to be displayed. I use widgets in a dashboard to display machine… --- ## [NFC to Badge Login](https://forum.inductiveautomation.com/t/nfc-to-badge-login/35818)
**Author:** [@deon.korb](https://forum.inductiveautomation.com/u/deon.korb)\ **Replies:** 5\ **Last updated:** [October 13, 2023, 12:30pm UTC](https://forum.inductiveautomation.com/t/nfc-to-badge-login/35818 "2023-10-13T12:30:03Z")
Hi, We are using the RFIdeas card readers for badge authentication and it works really well. I am trying to see if we can use the NFC readers on phones as a badge authentication. I can read the NFC card with the action… --- ## [I need to SELECT data from MsSQL table and then insert to Mysql](https://forum.inductiveautomation.com/t/i-need-to-select-data-from-mssql-table-and-then-insert-to-mysql/80397)
**Author:** [@Vitaliy\_Galiy](https://forum.inductiveautomation.com/u/Vitaliy_Galiy)\ **Replies:** 28\ **Last updated:** [October 13, 2023, 12:10pm UTC](https://forum.inductiveautomation.com/t/i-need-to-select-data-from-mssql-table-and-then-insert-to-mysql/80397 "2023-10-13T12:10:00Z")
Good day I have some problem when i try to work with tables, short: I have data that i take from Mssql and then i need to insert them to MySQL. If some data will change i need to hanlde the changes(Delete, Update, Add).… --- ## [Dynamic Report chart](https://forum.inductiveautomation.com/t/dynamic-report-chart/80373)
**Author:** [@Vatsal\_Shah](https://forum.inductiveautomation.com/u/Vatsal_Shah)\ **Replies:** 5\ **Last updated:** [October 13, 2023, 12:07pm UTC](https://forum.inductiveautomation.com/t/dynamic-report-chart/80373 "2023-10-13T12:07:25Z")
Is there any way to change to chart according to the report page which is currently visible? For e.g. I have a generated report of 10 pages, and it has a chart as well. The Timeseries chart displays the plotted chart fr… --- ## [Tooltips on Perspective table columns/cells?](https://forum.inductiveautomation.com/t/tooltips-on-perspective-table-columns-cells/77237)
**Author:** [@ian.sebryk](https://forum.inductiveautomation.com/u/ian.sebryk)\ **Replies:** 4\ **Last updated:** [October 13, 2023, 10:17am UTC](https://forum.inductiveautomation.com/t/tooltips-on-perspective-table-columns-cells/77237 "2023-10-13T10:17:07Z")
my overlords require tooltips on table column headers. i found a post indicating that such things are possible in the Vision world on 'Power Tables' (:tm:) but we're exclusively Perspective, so configureCell extensio… --- ## [How to switching the current language in a ignition report?](https://forum.inductiveautomation.com/t/how-to-switching-the-current-language-in-a-ignition-report/33262)
**Author:** [@luis1021](https://forum.inductiveautomation.com/u/luis1021)\ **Replies:** 5\ **Last updated:** [October 13, 2023, 8:34am UTC](https://forum.inductiveautomation.com/t/how-to-switching-the-current-language-in-a-ignition-report/33262 "2023-10-13T08:34:17Z")
Hello! I got a language selector in my project and it works for all windows, then I create a report and put it in a popup window with a PDF viewer but the language selector doesn’t work with the report. All the words in … --- ## [Use of HTML in datasets and tables](https://forum.inductiveautomation.com/t/use-of-html-in-datasets-and-tables/80427)
**Author:** [@Stef\_Velers](https://forum.inductiveautomation.com/u/Stef_Velers)\ **Replies:** 7\ **Last updated:** [October 13, 2023, 8:10am UTC](https://forum.inductiveautomation.com/t/use-of-html-in-datasets-and-tables/80427 "2023-10-13T08:10:19Z")
Hello, I have a dataset in my client tag and I also have the whole data set in a power table. it consist of strings that are longer than my label can show and I know that I can add in front of the label but as soon as … --- ## [Using the information of a Power Table in a label that is in another window](https://forum.inductiveautomation.com/t/using-the-information-of-a-power-table-in-a-label-that-is-in-another-window/80339)
**Author:** [@Stef\_Velers](https://forum.inductiveautomation.com/u/Stef_Velers)\ **Replies:** 22\ **Last updated:** [October 13, 2023, 7:04am UTC](https://forum.inductiveautomation.com/t/using-the-information-of-a-power-table-in-a-label-that-is-in-another-window/80339 "2023-10-13T07:04:57Z")
hello, I'm trying to get some string in my power table to be shown in a label in an other window than the power table itself. I found out about this https://docs.inductiveautomation.com/display/DOC/Finding+Components+on… --- ## [What is the best way to store data?](https://forum.inductiveautomation.com/t/what-is-the-best-way-to-store-data/80374)
**Author:** [@ignitionSL](https://forum.inductiveautomation.com/u/ignitionSL)\ **Replies:** 3\ **Last updated:** [October 13, 2023, 12:57am UTC](https://forum.inductiveautomation.com/t/what-is-the-best-way-to-store-data/80374 "2023-10-13T00:57:50Z")
Is it through the transaction group or Tag's history? Looking for comprehensive explanation. --- ## [Perspective themes and chart component colors](https://forum.inductiveautomation.com/t/perspective-themes-and-chart-component-colors/80419)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 0\ **Last updated:** [October 12, 2023, 10:45pm UTC](https://forum.inductiveautomation.com/t/perspective-themes-and-chart-component-colors/80419 "2023-10-12T22:45:01Z")
The AM Charts components on which the Perspective chart components are based don't understand CSS built-in theme variables such as --neutral-80, etc. In our applications we almost always allow the user to choose between … --- ## [Do Ignition upgrades change the user-lib?](https://forum.inductiveautomation.com/t/do-ignition-upgrades-change-the-user-lib/79188)
**Author:** [@CTrenkamp](https://forum.inductiveautomation.com/u/CTrenkamp)\ **Replies:** 7\ **Last updated:** [October 12, 2023, 10:24pm UTC](https://forum.inductiveautomation.com/t/do-ignition-upgrades-change-the-user-lib/79188 "2023-10-12T22:24:49Z")
Do Ignition upgrades change the user-lib? I have multiple plants which we just upgraded and the user-lib lost some pylib modules at some of them. --- ## [Resetting a user password - will this kick out other users logged in using these credentials?](https://forum.inductiveautomation.com/t/resetting-a-user-password-will-this-kick-out-other-users-logged-in-using-these-credentials/80414)
**Author:** [@Bushmatic](https://forum.inductiveautomation.com/u/Bushmatic)\ **Replies:** 1\ **Last updated:** [October 12, 2023, 9:39pm UTC](https://forum.inductiveautomation.com/t/resetting-a-user-password-will-this-kick-out-other-users-logged-in-using-these-credentials/80414 "2023-10-12T21:39:11Z")
We have a shared login used around our facility, like a general "shop floor" login. We don't actually know the password to this login as our previous gateway administrator did not record it. The projects that this login … --- ## [Scripting function takes a dict however the received datatype is DotReferenceJythonMap](https://forum.inductiveautomation.com/t/scripting-function-takes-a-dict-however-the-received-datatype-is-dotreferencejythonmap/80410)
**Author:** [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Replies:** 2\ **Last updated:** [October 12, 2023, 7:27pm UTC](https://forum.inductiveautomation.com/t/scripting-function-takes-a-dict-however-the-received-datatype-is-dotreferencejythonmap/80410 "2023-10-12T19:27:43Z")
I am using a Perspective onActionPerformed Script to open a popup: system.perspective.openPopup('def', 'facility/addTask/confirmation', params = {'new\_dict': new\_dict}, modal = True) In the gateway logger I have verifie… --- ## [Named Query - Int8 Parameter](https://forum.inductiveautomation.com/t/named-query-int8-parameter/80407)
**Author:** [@Chad\_Gregory](https://forum.inductiveautomation.com/u/Chad_Gregory)\ **Replies:** 0\ **Last updated:** [October 12, 2023, 6:42pm UTC](https://forum.inductiveautomation.com/t/named-query-int8-parameter/80407 "2023-10-12T18:42:15Z")
Nevermind. Figured it out --- ## [\[IGN-7506\]Unwanted behavior - dragging a script nowhere adds a (1) to it?](https://forum.inductiveautomation.com/t/ign-7506-unwanted-behavior-dragging-a-script-nowhere-adds-a-1-to-it/72270)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 4\ **Last updated:** [October 12, 2023, 6:38pm UTC](https://forum.inductiveautomation.com/t/ign-7506-unwanted-behavior-dragging-a-script-nowhere-adds-a-1-to-it/72270 "2023-10-12T18:38:04Z")
Think this is present at least from 7.9 and I just did it again in 8.1.19. How to replicate: Make at least two project library scripts. Name them whatever you want. Click to drag one, and go just on top of the other … --- ## [Chart Renderer Line for smooth view](https://forum.inductiveautomation.com/t/chart-renderer-line-for-smooth-view/80404)
**Author:** [@gpellicelli](https://forum.inductiveautomation.com/u/gpellicelli)\ **Replies:** 2\ **Last updated:** [October 12, 2023, 6:23pm UTC](https://forum.inductiveautomation.com/t/chart-renderer-line-for-smooth-view/80404 "2023-10-12T18:23:23Z")
Hello I found a post (Chart cubic interpolation) that was giving tip for using renderer into chart but I got weird line with precision 15 and I try different and its not better. When I got 2 data that are the same value … --- ## [How detect when new user is created in Ignition](https://forum.inductiveautomation.com/t/how-detect-when-new-user-is-created-in-ignition/80402)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 3\ **Last updated:** [October 12, 2023, 6:10pm UTC](https://forum.inductiveautomation.com/t/how-detect-when-new-user-is-created-in-ignition/80402 "2023-10-12T18:10:27Z")
Hi I want to have an event when anyone, creates a new user on a specific Usersource from the Web Page config in Ignition. Is there any way to detect it? If not how can I poll Ignition resources (for example every minut… --- ## [Adding more instances along X axis in Gantt Chart](https://forum.inductiveautomation.com/t/adding-more-instances-along-x-axis-in-gantt-chart/80327)
**Author:** [@Hema\_T](https://forum.inductiveautomation.com/u/Hema_T)\ **Replies:** 1\ **Last updated:** [October 12, 2023, 4:40pm UTC](https://forum.inductiveautomation.com/t/adding-more-instances-along-x-axis-in-gantt-chart/80327 "2023-10-12T16:40:36Z")
Hi , I need to do the above image, but there is no component as Gantt chart in perspective. In Gannt Chart, for same Y axis, how to add more than a instance along X axis. EG -In the uploaded image, top Y axis has tw… --- ## [Microsoft SQL Server on Linux with Ignition](https://forum.inductiveautomation.com/t/microsoft-sql-server-on-linux-with-ignition/14577)
**Author:** [@kcollins](https://forum.inductiveautomation.com/u/kcollins)\ **Replies:** 1\ **Last updated:** [October 12, 2023, 2:24pm UTC](https://forum.inductiveautomation.com/t/microsoft-sql-server-on-linux-with-ignition/14577 "2023-10-12T14:24:11Z")
Greetings all. I thought I'd share a small victory and also inquire as to whether anyone else has targeted any production deployments of MSSQL Server on Linux w/ Ignition. I just tried it out today and it worked just f… --- ## [OPC\_UA to SQL From Many](https://forum.inductiveautomation.com/t/opc-ua-to-sql-from-many/80345)
**Author:** [@Allen\_McDowell](https://forum.inductiveautomation.com/u/Allen_McDowell)\ **Replies:** 8\ **Last updated:** [October 12, 2023, 2:14pm UTC](https://forum.inductiveautomation.com/t/opc-ua-to-sql-from-many/80345 "2023-10-12T14:14:02Z")
I'm running version 8.1.32 with Sql Bridge and Perspective add on. I would like to take the data from 180 machines that all have (Item, ShiftCount, TotalCount, Condition, Operator, MachineID) as INT coming in as OPC da… --- ## [Perspective XY Chart Circle Bullet Size Not Changing](https://forum.inductiveautomation.com/t/perspective-xy-chart-circle-bullet-size-not-changing/72536)
**Author:** [@Jonathan\_Bennett](https://forum.inductiveautomation.com/u/Jonathan_Bennett)\ **Replies:** 6\ **Last updated:** [October 12, 2023, 1:31pm UTC](https://forum.inductiveautomation.com/t/perspective-xy-chart-circle-bullet-size-not-changing/72536 "2023-10-12T13:31:01Z")
I must be missing something simple, but how do you change the size of the circle bullets in the XY Chart? I've tried setting the height & width of the bullet property to everything from 0, 0.1, 1, 50 and more, but there… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=555) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=557)