# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1608 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1609 --- ## [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… --- ## [Table Bug in Version 7.9.4](https://forum.inductiveautomation.com/t/table-bug-in-version-7-9-4/19722)
**Author:** [@RohanPalshikar](https://forum.inductiveautomation.com/u/RohanPalshikar)\ **Replies:** 3\ **Last updated:** [September 19, 2018, 2:11pm UTC](https://forum.inductiveautomation.com/t/table-bug-in-version-7-9-4/19722 "2018-09-19T14:11:58Z")
Once you have created a table and assigned a binding to the data property. (for e.g. a SQL query) there is no way to remove or change the binding. You make any change and click the OK button nothing happens. Only way is … --- ## [Get Current Day of the Month and Write to a tag](https://forum.inductiveautomation.com/t/get-current-day-of-the-month-and-write-to-a-tag/19712)
**Author:** [@jshaffer09](https://forum.inductiveautomation.com/u/jshaffer09)\ **Replies:** 6\ **Last updated:** [September 19, 2018, 12:25pm UTC](https://forum.inductiveautomation.com/t/get-current-day-of-the-month-and-write-to-a-tag/19712 "2018-09-19T12:25:25Z")
How do you get the current day of the month and write it to a tag in a gateway script? This is what I have so far now = system.date.now() dayOfMonth = system.date.getDayOfMonth(now) system.tag.write("\[default\]Current… --- ## [Is Ignition compatible with Oracle database 18c?](https://forum.inductiveautomation.com/t/is-ignition-compatible-with-oracle-database-18c/19702)
**Author:** [@Edwin\_Guevara](https://forum.inductiveautomation.com/u/Edwin_Guevara)\ **Replies:** 2\ **Last updated:** [September 18, 2018, 4:02am UTC](https://forum.inductiveautomation.com/t/is-ignition-compatible-with-oracle-database-18c/19702 "2018-09-18T04:02:05Z")
Does someone already tested Oracle 18c succesfully with Ignition? A customer asked us if Ignition is compatible with Oracle Database 18c. They are planning a database migration. Best regards. Edwin Guevara --- ## [Trend X-Trace mode](https://forum.inductiveautomation.com/t/trend-x-trace-mode/9426)
**Author:** [@AE2S\_Sanden](https://forum.inductiveautomation.com/u/AE2S_Sanden)\ **Replies:** 10\ **Last updated:** [September 18, 2018, 7:13pm UTC](https://forum.inductiveautomation.com/t/trend-x-trace-mode/9426 "2018-09-18T19:13:37Z")
The first thing I do when I view a trend is change to X-Trace mode. Is there a way to enable the X-Trace mode on a chart through scripting so it's there automatically there on open? I can't find the correct attribute. --- ## [In depth documentation](https://forum.inductiveautomation.com/t/in-depth-documentation/19717)
**Author:** [@pandreoli](https://forum.inductiveautomation.com/u/pandreoli)\ **Replies:** 3\ **Last updated:** [September 18, 2018, 6:04pm UTC](https://forum.inductiveautomation.com/t/in-depth-documentation/19717 "2018-09-18T18:04:41Z")
Hello. While trying to solve a problem I had today I stumbled upon this help thread where user PGriffith gave an answer to a problem. In the code he posted, the last line of his code is lbl3.setIcon He uses the setI… --- ## [Tag alarm properties are not updating](https://forum.inductiveautomation.com/t/tag-alarm-properties-are-not-updating/19718)
**Author:** [@rpulsifer](https://forum.inductiveautomation.com/u/rpulsifer)\ **Replies:** 0\ **Last updated:** [September 18, 2018, 5:45pm UTC](https://forum.inductiveautomation.com/t/tag-alarm-properties-are-not-updating/19718 "2018-09-18T17:45:32Z")
I’m wondering if I’m missing something fundamental here - or need to press a “refresh” button or something. Maybe someone can point out what I’m doing sideways. It started out that an alarm I had created wouldn’t trigger… --- ## [Conditional statement in expression tag](https://forum.inductiveautomation.com/t/conditional-statement-in-expression-tag/19714)
**Author:** [@wschauer](https://forum.inductiveautomation.com/u/wschauer)\ **Replies:** 2\ **Last updated:** [September 18, 2018, 5:22pm UTC](https://forum.inductiveautomation.com/t/conditional-statement-in-expression-tag/19714 "2018-09-18T17:22:02Z")
I am trying to choose between values in an expression tag. Previously i have just created intermediate memory tags for this but from reading the manual this should be possible all in one step. I tag errors even when i u… --- ## [Troubleshooting Intermittent Tag Update Problems](https://forum.inductiveautomation.com/t/troubleshooting-intermittent-tag-update-problems/19685)
**Author:** [@Dryhops](https://forum.inductiveautomation.com/u/Dryhops)\ **Replies:** 3\ **Last updated:** [September 18, 2018, 4:33pm UTC](https://forum.inductiveautomation.com/t/troubleshooting-intermittent-tag-update-problems/19685 "2018-09-18T16:33:24Z")
I have recently added a new device, a ControlLogix 1756-L72 5570 which is running on firmware 21.11, to an older Ignition project. The gateway is version 7.7.3. The existing project is rather large, with nearly 90,000 … --- ## [Python float division, then binding, returns rounded int](https://forum.inductiveautomation.com/t/python-float-division-then-binding-returns-rounded-int/19716)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 4\ **Last updated:** [September 18, 2018, 3:45pm UTC](https://forum.inductiveautomation.com/t/python-float-division-then-binding-returns-rounded-int/19716 "2018-09-18T15:45:36Z")
My code: price = system.db.runNamedQuery('Costing/FabricPricing', params) if qty \>= 15: price = float(price)/2 event.source.parent.getComponent('Price 3').floatValue = price the price returned in this situation… --- ## [Bi-direction synchronization to send DB entries to PLC as they show up](https://forum.inductiveautomation.com/t/bi-direction-synchronization-to-send-db-entries-to-plc-as-they-show-up/19713)
**Author:** [@shane2977](https://forum.inductiveautomation.com/u/shane2977)\ **Replies:** 2\ **Last updated:** [September 18, 2018, 3:18pm UTC](https://forum.inductiveautomation.com/t/bi-direction-synchronization-to-send-db-entries-to-plc-as-they-show-up/19713 "2018-09-18T15:18:22Z")
Hello, How can I send the latest DB entries of a column to a PLC if the DB table is a historical table? A little about the process..... This involves an annealing furnace that can hold 12 boats. A boat is just a meta… --- ## [How can we better deal with "Ack Notes" with the "Alarm Status Table"](https://forum.inductiveautomation.com/t/how-can-we-better-deal-with-ack-notes-with-the-alarm-status-table/19715)
**Author:** [@ffournier](https://forum.inductiveautomation.com/u/ffournier)\ **Replies:** 0\ **Last updated:** [September 18, 2018, 2:18pm UTC](https://forum.inductiveautomation.com/t/how-can-we-better-deal-with-ack-notes-with-the-alarm-status-table/19715 "2018-09-18T14:18:23Z")
On the following page, here, it states, about "Ack Notes Required" that you should "Select this option to require operators to provide some explanation when the alarm is acknowledged". When set to true, when working wi… --- ## [Connection path for allen bradley compact logix](https://forum.inductiveautomation.com/t/connection-path-for-allen-bradley-compact-logix/9116)
**Author:** [@cja7928](https://forum.inductiveautomation.com/u/cja7928)\ **Replies:** 7\ **Last updated:** [September 18, 2018, 1:58pm UTC](https://forum.inductiveautomation.com/t/connection-path-for-allen-bradley-compact-logix/9116 "2018-09-18T13:58:55Z")
Im having trouble connecting to a compact logix 1769-L32E through a network address translation device: http://ab.rockwellautomation.com/Networks-and-Communications/Network-Address-Translation-Device I have tried a num… --- ## [Natural Gas & Steam meters](https://forum.inductiveautomation.com/t/natural-gas-steam-meters/19708)
**Author:** [@vanko25](https://forum.inductiveautomation.com/u/vanko25)\ **Replies:** 0\ **Last updated:** [September 18, 2018, 8:37am UTC](https://forum.inductiveautomation.com/t/natural-gas-steam-meters/19708 "2018-09-18T08:37:45Z")
Hi all, My customer is planning to start monitoring natural gas and steam usage by machine in the upcoming months and I was wondering are there any units that are proved to work well with Ignition? All the controls … --- ## [S7-1500 OPC-UA - Ignition, problem - chunk count? - Ticket 66417](https://forum.inductiveautomation.com/t/s7-1500-opc-ua-ignition-problem-chunk-count-ticket-66417/17471)
**Author:** [@jcroxton](https://forum.inductiveautomation.com/u/jcroxton)\ **Replies:** 16\ **Last updated:** [September 17, 2018, 2:09pm UTC](https://forum.inductiveautomation.com/t/s7-1500-opc-ua-ignition-problem-chunk-count-ticket-66417/17471 "2018-09-17T14:09:00Z")
Hello Forum, I am using the OPC-UA Server on board a Siemens S7-1500 rather than the inbuilt Ignition Server as it supports OPC browsing and doesn’t require addressing etc. I am using v7.9.6 of ignition. Generally it w… --- ## [Project and shared scripts - scripting outside of functions](https://forum.inductiveautomation.com/t/project-and-shared-scripts-scripting-outside-of-functions/19701)
**Author:** [@mrogers](https://forum.inductiveautomation.com/u/mrogers)\ **Replies:** 2\ **Last updated:** [September 18, 2018, 4:01am UTC](https://forum.inductiveautomation.com/t/project-and-shared-scripts-scripting-outside-of-functions/19701 "2018-09-18T04:01:18Z")
I've only used project & shared scripts by referring directly to a function inside them. I know you can declare variables outside of the functions, but when does that declaration run? To clarify, lets say I have a fun… --- ## [Lost Property Editor](https://forum.inductiveautomation.com/t/lost-property-editor/19699)
**Author:** [@dion.botha](https://forum.inductiveautomation.com/u/dion.botha)\ **Replies:** 1\ **Last updated:** [September 17, 2018, 8:08pm UTC](https://forum.inductiveautomation.com/t/lost-property-editor/19699 "2018-09-17T20:08:29Z")
Hi guys, Not sure what I have done but I cannot see the property editor even though it is checked under View -\> Panels. Unchecking and checking it again does nothing. Is there a way to reset this to default? Rega… --- ## [Easy Chart Multiple Y-axis (different scale) - Remove Ticks](https://forum.inductiveautomation.com/t/easy-chart-multiple-y-axis-different-scale-remove-ticks/19691)
**Author:** [@dion.botha](https://forum.inductiveautomation.com/u/dion.botha)\ **Replies:** 1\ **Last updated:** [September 17, 2018, 6:42pm UTC](https://forum.inductiveautomation.com/t/easy-chart-multiple-y-axis-different-scale-remove-ticks/19691 "2018-09-17T18:42:32Z")
Hi Guys, I am trying to superimpose all the analog values (of different scales) for a system on 1 easy chart. I have it working pretty good except that I would like to get rid of the Y-axis tick marks. Is this possibl… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1607) [Next page](https://forum.inductiveautomation.com/latest.md?page=1609)