# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1350 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1351 --- ## [Failing to catch exceptions from smart card reader](https://forum.inductiveautomation.com/t/failing-to-catch-exceptions-from-smart-card-reader/19819)
**Author:** [@Claus\_Nielsen](https://forum.inductiveautomation.com/u/Claus_Nielsen)\ **Replies:** 5\ **Last updated:** [September 25, 2018, 7:56pm UTC](https://forum.inductiveautomation.com/t/failing-to-catch-exceptions-from-smart-card-reader/19819 "2018-09-25T19:56:56Z")
Hi all, Working on a script for using smart card readers with my application using the javax.smartcardio package. However the huge amount of exceptions thrown here when reading from the smart card is 50% of the time no… --- ## [Change Text Field FOCUS Inner Border Color](https://forum.inductiveautomation.com/t/change-text-field-focus-inner-border-color/19822)
**Author:** [@raymond1982](https://forum.inductiveautomation.com/u/raymond1982)\ **Replies:** 0\ **Last updated:** [September 25, 2018, 7:34pm UTC](https://forum.inductiveautomation.com/t/change-text-field-focus-inner-border-color/19822 "2018-09-25T19:34:06Z")
Any way to change the default focus inner border color? its \[Orange\]. It seems that when the focus is gained a compound border is created and then replaced when the focus is lost. I need a way to hook in and change the c… --- ## [2 Radio buttons to control 1 boolean tag](https://forum.inductiveautomation.com/t/2-radio-buttons-to-control-1-boolean-tag/19821)
**Author:** [@dion.botha](https://forum.inductiveautomation.com/u/dion.botha)\ **Replies:** 1\ **Last updated:** [September 25, 2018, 7:23pm UTC](https://forum.inductiveautomation.com/t/2-radio-buttons-to-control-1-boolean-tag/19821 "2018-09-25T19:23:45Z")
Hi guys, Is it possible to control a boolean tag with 2 radio buttons? Regards, D.Botha --- ## [Button color on client](https://forum.inductiveautomation.com/t/button-color-on-client/19762)
**Author:** [@lyhkch](https://forum.inductiveautomation.com/u/lyhkch)\ **Replies:** 2\ **Last updated:** [September 25, 2018, 12:38pm UTC](https://forum.inductiveautomation.com/t/button-color-on-client/19762 "2018-09-25T12:38:01Z")
Hi , when I click button ,change it's color on one client , but when I use another client to check , this button color don't change. Why ? event.source.buttonBG = (71,255,71,255) event.source.parent.getComponent('bt\_un… --- ## [Reporting: combine data sources via scripting for chart dataset](https://forum.inductiveautomation.com/t/reporting-combine-data-sources-via-scripting-for-chart-dataset/19803)
**Author:** [@vanko25](https://forum.inductiveautomation.com/u/vanko25)\ **Replies:** 1\ **Last updated:** [September 25, 2018, 10:38am UTC](https://forum.inductiveautomation.com/t/reporting-combine-data-sources-via-scripting-for-chart-dataset/19803 "2018-09-25T10:38:04Z")
Hi all, I am having a report that I need to do for a client. I have various SQL queries that return single values to populate text boxes on the report. A pareto bar chart is also required to visually represent these v… --- ## [SQL query WHERE column = property value (string)](https://forum.inductiveautomation.com/t/sql-query-where-column-property-value-string/19794)
**Author:** [@dion.botha](https://forum.inductiveautomation.com/u/dion.botha)\ **Replies:** 1\ **Last updated:** [September 24, 2018, 10:37pm UTC](https://forum.inductiveautomation.com/t/sql-query-where-column-property-value-string/19794 "2018-09-24T22:37:41Z")
Hi guys, Can someone tell me why I can execute this SQL query: SELECT vsf\_grades.designator FROM vsf\_products INNER JOIN (vsf\_grades INNER JOIN vsf\_grade\_products ON vsf\_grades.db\_id = vsf\_grade\_products.vsf\_grades\_d… --- ## [Pulling date range out of report table](https://forum.inductiveautomation.com/t/pulling-date-range-out-of-report-table/19791)
**Author:** [@christopher.raphael](https://forum.inductiveautomation.com/u/christopher.raphael)\ **Replies:** 2\ **Last updated:** [September 24, 2018, 8:36pm UTC](https://forum.inductiveautomation.com/t/pulling-date-range-out-of-report-table/19791 "2018-09-24T20:36:04Z")
Here is my code. Parameter TimeHolder is set to now(). I get an error: WARN: Simple Query could not be completed. Incorrect syntax near 'Sep' which is the current month but I don't know how to correct it. I can tell that… --- ## [Nested Historical Query in Report works, issues with Graphically Presenting Data](https://forum.inductiveautomation.com/t/nested-historical-query-in-report-works-issues-with-graphically-presenting-data/19769)
**Author:** [@dano38291](https://forum.inductiveautomation.com/u/dano38291)\ **Replies:** 1\ **Last updated:** [September 24, 2018, 7:15pm UTC](https://forum.inductiveautomation.com/t/nested-historical-query-in-report-works-issues-with-graphically-presenting-data/19769 "2018-09-24T19:15:09Z")
Hello, So I worked from the following post to get my Nested Child queries working. http://forum.inductiveautomation.com/t/report-with-scripted-nested-data/11801 Doing a few named queries using above idea. I am also … --- ## [Copy a record via a push button](https://forum.inductiveautomation.com/t/copy-a-record-via-a-push-button/19689)
**Author:** [@ssilk76](https://forum.inductiveautomation.com/u/ssilk76)\ **Replies:** 12\ **Last updated:** [September 24, 2018, 3:22pm UTC](https://forum.inductiveautomation.com/t/copy-a-record-via-a-push-button/19689 "2018-09-24T15:22:41Z")
I have a recipe table set up which services several machines. I have a transaction that is triggered by the PLC and uses a where clause for the part number to do a DB-\>OPC transfer. Everything works there, no problem. … --- ## [Find running process OR see if specific computer user logged in?](https://forum.inductiveautomation.com/t/find-running-process-or-see-if-specific-computer-user-logged-in/19786)
**Author:** [@StefanGronberg](https://forum.inductiveautomation.com/u/StefanGronberg)\ **Replies:** 2\ **Last updated:** [September 24, 2018, 1:39pm UTC](https://forum.inductiveautomation.com/t/find-running-process-or-see-if-specific-computer-user-logged-in/19786 "2018-09-24T13:39:26Z")
Hi. Which would be the best way to see if a specific .EXE is running or if a specific computer user where the gateway runs at, is logged in? Customer wish to see in the hmi weather the server is logged in (so a speci… --- ## [Database failover not working](https://forum.inductiveautomation.com/t/database-failover-not-working/19710)
**Author:** [@Andrew\_P](https://forum.inductiveautomation.com/u/Andrew_P)\ **Replies:** 2\ **Last updated:** [September 24, 2018, 8:56am UTC](https://forum.inductiveautomation.com/t/database-failover-not-working/19710 "2018-09-24T08:56:30Z")
Hi, I am having trouble with database failover. I have set up 3 connections: "a" (primary db) which is ok, "b" (secondary db) which is ok (and connecting to a different machine) and c which connects to the same db as "a… --- ## [Tag Browser Filtering](https://forum.inductiveautomation.com/t/tag-browser-filtering/19760)
**Author:** [@Andrew\_P](https://forum.inductiveautomation.com/u/Andrew_P)\ **Replies:** 6\ **Last updated:** [September 23, 2018, 1:41am UTC](https://forum.inductiveautomation.com/t/tag-browser-filtering/19760 "2018-09-23T01:41:33Z")
Does anyone know how to get filtering to work for UDTs on the Tag Browse Tree component? I want to filter on tags that contain a specific string. using the components builtin filter function, I can filter on tag name, … --- ## [Property Editor](https://forum.inductiveautomation.com/t/property-editor/19772)
**Author:** [@lupitatorres632](https://forum.inductiveautomation.com/u/lupitatorres632)\ **Replies:** 1\ **Last updated:** [September 21, 2018, 9:21pm UTC](https://forum.inductiveautomation.com/t/property-editor/19772 "2018-09-21T21:21:19Z")
Can I get an explanation as to why Background Color is in red? Thank you. --- ## [Issues loading demo Perspective project](https://forum.inductiveautomation.com/t/issues-loading-demo-perspective-project/19748)
**Author:** [@WillMT10](https://forum.inductiveautomation.com/u/WillMT10)\ **Replies:** 9\ **Last updated:** [September 21, 2018, 9:04pm UTC](https://forum.inductiveautomation.com/t/issues-loading-demo-perspective-project/19748 "2018-09-21T21:04:54Z")
--- ## [Highlight interval on easy chart](https://forum.inductiveautomation.com/t/highlight-interval-on-easy-chart/19764)
**Author:** [@nicholas](https://forum.inductiveautomation.com/u/nicholas)\ **Replies:** 7\ **Last updated:** [September 21, 2018, 7:31pm UTC](https://forum.inductiveautomation.com/t/highlight-interval-on-easy-chart/19764 "2018-09-21T19:31:00Z")
Hello everyone, Does anyone know the best way to go about adding a highlight overlay for a specific time interval to an easy chart? It should look something along the lines of this image below. A bar or something at the… --- ## [Set cell background by script](https://forum.inductiveautomation.com/t/set-cell-background-by-script/12811)
**Author:** [@StepanenkoPaul](https://forum.inductiveautomation.com/u/StepanenkoPaul)\ **Replies:** 6\ **Last updated:** [September 21, 2018, 12:01pm UTC](https://forum.inductiveautomation.com/t/set-cell-background-by-script/12811 "2018-09-21T12:01:14Z")
Can I set the color for a row in a specific column by script? --- ## [Power Table Column Drop Down Query Using configureEditor Extension Function](https://forum.inductiveautomation.com/t/power-table-column-drop-down-query-using-configureeditor-extension-function/19594)
**Author:** [@jshaffer09](https://forum.inductiveautomation.com/u/jshaffer09)\ **Replies:** 7\ **Last updated:** [September 21, 2018, 11:27am UTC](https://forum.inductiveautomation.com/t/power-table-column-drop-down-query-using-configureeditor-extension-function/19594 "2018-09-21T11:27:30Z")
How do you setup a drop down in a column and get the data for the drop down in a database table. I see the example in configureEditor but I am not for sure on the query side of it to make it work. --- ## [Set entire column to value with button](https://forum.inductiveautomation.com/t/set-entire-column-to-value-with-button/19530)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 20\ **Last updated:** [September 21, 2018, 11:15am UTC](https://forum.inductiveautomation.com/t/set-entire-column-to-value-with-button/19530 "2018-09-21T11:15:51Z")
I'm trying to set an entire column of values equal to 0. I've tried about 50 different ways, and keep failing miserably. I've found several snippets that are close to what I want, but I can't get any to work. tabl… --- ## [Store and Forward a prep-statement?](https://forum.inductiveautomation.com/t/store-and-forward-a-prep-statement/19732)
**Author:** [@Julio.Bautista](https://forum.inductiveautomation.com/u/Julio.Bautista)\ **Replies:** 3\ **Last updated:** [September 21, 2018, 2:43am UTC](https://forum.inductiveautomation.com/t/store-and-forward-a-prep-statement/19732 "2018-09-21T02:43:29Z")
If my database connection faulted would a prep-statement query be stored in cache till my connection is reestablished? I', running this code on a global shared script if that makes any difference. --- ## [Power table - Help coloring specific cells based on boolean tags value](https://forum.inductiveautomation.com/t/power-table-help-coloring-specific-cells-based-on-boolean-tags-value/18642)
**Author:** [@n.meluccio](https://forum.inductiveautomation.com/u/n.meluccio)\ **Replies:** 11\ **Last updated:** [September 21, 2018, 12:28am UTC](https://forum.inductiveautomation.com/t/power-table-help-coloring-specific-cells-based-on-boolean-tags-value/18642 "2018-09-21T00:28:19Z")
Hello sirs, i want to color just one cell of a power table, based on a boolean tag value. Below you can find the code: Numeri = \[1,2,3,4,5\] for x in Numeri: TAG = "\[Client\]NOK\_Pressione\_%s" % (x) Valore = syste… --- ## [Alarm Event Data - Get Custom Property](https://forum.inductiveautomation.com/t/alarm-event-data-get-custom-property/19756)
**Author:** [@WillMT10](https://forum.inductiveautomation.com/u/WillMT10)\ **Replies:** 0\ **Last updated:** [September 20, 2018, 9:48pm UTC](https://forum.inductiveautomation.com/t/alarm-event-data-get-custom-property/19756 "2018-09-20T21:48:43Z")
I've read various posts regarding fetching alarm event properties and discussions on grabbing custom properties, but the only solution I've seen is either sticking with the built in Extension Functions on the alarm statu… --- ## [Change x position of an object with mouse holding click](https://forum.inductiveautomation.com/t/change-x-position-of-an-object-with-mouse-holding-click/19707)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 2\ **Last updated:** [September 20, 2018, 9:04pm UTC](https://forum.inductiveautomation.com/t/change-x-position-of-an-object-with-mouse-holding-click/19707 "2018-09-20T21:04:49Z")
Hi everyone I want to create my new slider. The only thing I cant figure it out is how to apply mouse grape or slide animation on my svg object. I want to change the x position of my SVG object with mouse holding left … --- ## [Expression tag e dropdown](https://forum.inductiveautomation.com/t/expression-tag-e-dropdown/19750)
**Author:** [@Giuseppe.mollica](https://forum.inductiveautomation.com/u/Giuseppe.mollica)\ **Replies:** 1\ **Last updated:** [September 20, 2018, 8:00pm UTC](https://forum.inductiveautomation.com/t/expression-tag-e-dropdown/19750 "2018-09-20T20:00:44Z")
Good evening, It is possible to create an exprescion tag which, as a value, shows the selected text in a dropdown box thank you --- ## [Screen capture error window](https://forum.inductiveautomation.com/t/screen-capture-error-window/19747)
**Author:** [@rgarcher](https://forum.inductiveautomation.com/u/rgarcher)\ **Replies:** 2\ **Last updated:** [September 20, 2018, 7:36pm UTC](https://forum.inductiveautomation.com/t/screen-capture-error-window/19747 "2018-09-20T19:36:30Z")
Is there anyway to do a screen capture on an event that causes a scripting error message to appear? I have a button that takes a screen image of the screen that then emails the image but it doesn't capture the error. --- ## [Scripting Row Background color](https://forum.inductiveautomation.com/t/scripting-row-background-color/19738)
**Author:** [@agweb.salinas](https://forum.inductiveautomation.com/u/agweb.salinas)\ **Replies:** 9\ **Last updated:** [September 20, 2018, 6:01pm UTC](https://forum.inductiveautomation.com/t/scripting-row-background-color/19738 "2018-09-20T18:01:00Z")
So I have gotten a little stuck in scripting for changing the background color of entire rows in a table (I am using a standard table not a Power table). I would like it to iterate through the rows of my existing tab… --- ## [MySQL Query - UNION several tables and Trying to SUM() one column](https://forum.inductiveautomation.com/t/mysql-query-union-several-tables-and-trying-to-sum-one-column/19647)
**Author:** [@paulm1](https://forum.inductiveautomation.com/u/paulm1)\ **Replies:** 12\ **Last updated:** [September 20, 2018, 5:11am UTC](https://forum.inductiveautomation.com/t/mysql-query-union-several-tables-and-trying-to-sum-one-column/19647 "2018-09-20T05:11:59Z")
I have a query where we have UNION several tables into one Table Component. We now want to get a Balance of one of these columns. Here is a pic of the Table results without the SUM() function. Here is my query with… --- ## [Column reverts to null?](https://forum.inductiveautomation.com/t/column-reverts-to-null/19723)
**Author:** [@AIO](https://forum.inductiveautomation.com/u/AIO)\ **Replies:** 1\ **Last updated:** [September 19, 2018, 9:39pm UTC](https://forum.inductiveautomation.com/t/column-reverts-to-null/19723 "2018-09-19T21:39:00Z")
Hey folks, We have a fairly widely used table in MSSQL that we just added several columns to, all REAL. I am writing the data to these columns every 5 seconds with query tags, and am having a funny time with one of the… --- ## [OPC - The security token request type is not valid](https://forum.inductiveautomation.com/t/opc-the-security-token-request-type-is-not-valid/19739)
**Author:** [@james.vosler](https://forum.inductiveautomation.com/u/james.vosler)\ **Replies:** 1\ **Last updated:** [September 19, 2018, 7:42pm UTC](https://forum.inductiveautomation.com/t/opc-the-security-token-request-type-is-not-valid/19739 "2018-09-19T19:42:58Z")
What is the underlying issue and workaround to the "The security token request type is not valid" issue as mentioned in the below issue? http://forum.inductiveautomation.com/t/opc-connection-fail-from-opc-tag-browse… --- ## [RunPrepQuery in a "not default" SQL server](https://forum.inductiveautomation.com/t/runprepquery-in-a-not-default-sql-server/19735)
**Author:** [@valet81](https://forum.inductiveautomation.com/u/valet81)\ **Replies:** 2\ **Last updated:** [September 19, 2018, 4:05pm UTC](https://forum.inductiveautomation.com/t/runprepquery-in-a-not-default-sql-server/19735 "2018-09-19T16:05:13Z")
Hi all, I've searched online and in this forum an answer to this problem,but I couldn't find one, so I try to ask you. What I'm trying to do is to extract results from a query, using a script (the example is simple b… --- ## [Using a scanner / Need event to happen on key press](https://forum.inductiveautomation.com/t/using-a-scanner-need-event-to-happen-on-key-press/19734)
**Author:** [@dholt](https://forum.inductiveautomation.com/u/dholt)\ **Replies:** 5\ **Last updated:** [September 19, 2018, 2:58pm UTC](https://forum.inductiveautomation.com/t/using-a-scanner-need-event-to-happen-on-key-press/19734 "2018-09-19T14:58:24Z")
Greetings. I am creating a screen that will be used at our facility that will log what's been scanned, and who scanned it. Everything works fine with the exception I don't know how to have this script fire after the ente… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1349) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1351)