# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1599 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1600 --- ## [Multi-filtering option, Table component similar to IADemo](https://forum.inductiveautomation.com/t/multi-filtering-option-table-component-similar-to-iademo/5382)
**Author:** [@skallepalli](https://forum.inductiveautomation.com/u/skallepalli)\ **Replies:** 2\ **Last updated:** [November 22, 2012, 8:26am UTC](https://forum.inductiveautomation.com/t/multi-filtering-option-table-component-similar-to-iademo/5382 "2012-11-22T08:26:34Z")
Inductive Team, We had a look at Ignition Demo \> Quality Demo \> SPC Control Charts available on website and amazed to see the power of Ignition. We had a similar development requirement for filtering like SPC Settings. … --- ## [Minimum Client Height? Can't get any lower than 103?](https://forum.inductiveautomation.com/t/minimum-client-height-cant-get-any-lower-than-103/5439)
**Author:** [@cswett](https://forum.inductiveautomation.com/u/cswett)\ **Replies:** 2\ **Last updated:** [November 21, 2012, 11:11pm UTC](https://forum.inductiveautomation.com/t/minimum-client-height-cant-get-any-lower-than-103/5439 "2012-11-21T23:11:49Z")
I'm trying to make a client open at a size of 800x70 but can't seem to be able to get the designer to accept any value lower than 103? After opening the client, I can manually resize to the height I want just fine, but… --- ## [Dropdown functions](https://forum.inductiveautomation.com/t/dropdown-functions/5462)
**Author:** [@cacordova](https://forum.inductiveautomation.com/u/cacordova)\ **Replies:** 6\ **Last updated:** [November 21, 2012, 9:33pm UTC](https://forum.inductiveautomation.com/t/dropdown-functions/5462 "2012-11-21T21:33:39Z")
I have two dropdown lists, what i need to happen is when i choose an item on the first dropdown, it will populate the items i enter in the if condition in the second dropdown, here’s my code if event.propertyName == "s… --- ## [Scheduled Transactions Still Triggering Twice](https://forum.inductiveautomation.com/t/scheduled-transactions-still-triggering-twice/5450)
**Author:** [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\ **Replies:** 5\ **Last updated:** [November 21, 2012, 7:50pm UTC](https://forum.inductiveautomation.com/t/scheduled-transactions-still-triggering-twice/5450 "2012-11-21T19:50:29Z")
Hey guys, I’m still having the double triggering problem on scheduled transactions, this is the same problem as this post. (I would have just unsolved it and continued but I don’t have the option to unsolve. FYI) It wa… --- ## [Is there a Maximum component limit on a window](https://forum.inductiveautomation.com/t/is-there-a-maximum-component-limit-on-a-window/5457)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 2\ **Last updated:** [November 21, 2012, 12:00am UTC](https://forum.inductiveautomation.com/t/is-there-a-maximum-component-limit-on-a-window/5457 "2012-11-21T00:00:37Z")
I have a window I am trying to create that has a size of 4000x12750 (this lets the user scroll to see more of the components in the client). On the window I created a container with about 94 components (just labels and … --- ## [Table How To](https://forum.inductiveautomation.com/t/table-how-to/5454)
**Author:** [@cacordova](https://forum.inductiveautomation.com/u/cacordova)\ **Replies:** 9\ **Last updated:** [November 20, 2012, 9:15pm UTC](https://forum.inductiveautomation.com/t/table-how-to/5454 "2012-11-20T21:15:42Z")
Hi, how do i tell a tag value to be inserted to the table? i have a dropdown list where example the value "Test" is selected, what i want to happen is when that value is selected from the drop down, the value of the tag… --- ## [Updating 1 of 2 columns in db from query?](https://forum.inductiveautomation.com/t/updating-1-of-2-columns-in-db-from-query/5445)
**Author:** [@rcorkern](https://forum.inductiveautomation.com/u/rcorkern)\ **Replies:** 3\ **Last updated:** [November 20, 2012, 8:53pm UTC](https://forum.inductiveautomation.com/t/updating-1-of-2-columns-in-db-from-query/5445 "2012-11-20T20:53:52Z")
I have a table that is pulling in alert info based on a db query from the sqlt\_as table. I'm trying to allow editing directly from the table but my problem is that the Table I'm pulling the info into has 3 Columns - Ala… --- ## [Expression based on hour meter count value](https://forum.inductiveautomation.com/t/expression-based-on-hour-meter-count-value/5448)
**Author:** [@Brett\_Yeomans](https://forum.inductiveautomation.com/u/Brett_Yeomans)\ **Replies:** 1\ **Last updated:** [November 20, 2012, 5:15pm UTC](https://forum.inductiveautomation.com/t/expression-based-on-hour-meter-count-value/5448 "2012-11-20T17:15:40Z")
I have a hour meter in a transaction group that records downtime to SQL, I'd like to have an additional column updated with a modified value of the hour meter - i.e. record the hour meter (duration) but then divide the h… --- ## [Property Editor dropdowns need 2 clicks](https://forum.inductiveautomation.com/t/property-editor-dropdowns-need-2-clicks/5449)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 1\ **Last updated:** [November 20, 2012, 4:42pm UTC](https://forum.inductiveautomation.com/t/property-editor-dropdowns-need-2-clicks/5449 "2012-11-20T16:42:32Z")
Server: Ignition 7.5.2 OpenJDK Java 1.6.24 Ubuntu 12.04 64-bit Client: Sun Java 1.6.26 Ubuntu 11.04 64-bit with Gnome When I click on a dropdown list in the Property Editor (Horizontal Alignment for example), the lis… --- ## [system.opc.readValues](https://forum.inductiveautomation.com/t/system-opc-readvalues/5446)
**Author:** [@njsd](https://forum.inductiveautomation.com/u/njsd)\ **Replies:** 2\ **Last updated:** [November 19, 2012, 11:32pm UTC](https://forum.inductiveautomation.com/t/system-opc-readvalues/5446 "2012-11-19T23:32:08Z")
Hello, I am reading through a RXLinx Gateway to a SLC 5/04. I want to read 5 ASCII file locations to come up with a 10 character serial number string. Here is the code: import system opc\_server = "S90P" SerialNumber… --- ## [Modbus Plus](https://forum.inductiveautomation.com/t/modbus-plus/2547)
**Author:** [@rfbuehler](https://forum.inductiveautomation.com/u/rfbuehler)\ **Replies:** 11\ **Last updated:** [November 19, 2012, 10:55pm UTC](https://forum.inductiveautomation.com/t/modbus-plus/2547 "2012-11-19T22:55:33Z")
I have a project I will be bidding on that has 74 nodes (PLCs) on a Modbus Plus Network. These nodes will be converted one at a time to MB Ethernet which will work with the OPC-UA server just fine. My question is what is… --- ## [Float numbers in MySQL](https://forum.inductiveautomation.com/t/float-numbers-in-mysql/5441)
**Author:** [@jhortig](https://forum.inductiveautomation.com/u/jhortig)\ **Replies:** 8\ **Last updated:** [November 19, 2012, 9:54pm UTC](https://forum.inductiveautomation.com/t/float-numbers-in-mysql/5441 "2012-11-19T21:54:11Z")
I'm storing tag values (Float4) in a MySQL DB, using a historical transaction group. When I view the stored data with the database query browser in the designer the format has changed to integer and the numbers after the… --- ## [Calendar not formatting/latching correctly](https://forum.inductiveautomation.com/t/calendar-not-formatting-latching-correctly/5415)
**Author:** [@scott\_stc](https://forum.inductiveautomation.com/u/scott_stc)\ **Replies:** 5\ **Last updated:** [November 19, 2012, 6:51pm UTC](https://forum.inductiveautomation.com/t/calendar-not-formatting-latching-correctly/5415 "2012-11-19T18:51:50Z")
In V7.5.3, the Calendar component doesn't: 1) display the time as formatted in the Format String property, and 2) with the Show OK Button checked, the Latched Date doesn't have any affect on the calendar. I.e. - during … --- ## [SQLTags CSV separator character](https://forum.inductiveautomation.com/t/sqltags-csv-separator-character/5440)
**Author:** [@pat.stave](https://forum.inductiveautomation.com/u/pat.stave)\ **Replies:** 1\ **Last updated:** [November 19, 2012, 6:44pm UTC](https://forum.inductiveautomation.com/t/sqltags-csv-separator-character/5440 "2012-11-19T18:44:57Z")
It seems that the CSV separator of the SQLtags export file is always a semicolon, regardless of what the Windows regional settings "list separator" is set to. This makes the list quite troublesome to open/edit as excel w… --- ## [Export a String into a .txt File](https://forum.inductiveautomation.com/t/export-a-string-into-a-txt-file/5438)
**Author:** [@caritoel27](https://forum.inductiveautomation.com/u/caritoel27)\ **Replies:** 1\ **Last updated:** [November 18, 2012, 8:27am UTC](https://forum.inductiveautomation.com/t/export-a-string-into-a-txt-file/5438 "2012-11-18T08:27:47Z")
Hi, I write to you because a need to export a string or a sentence, from a text field in a .txt file, i didn't find a function to make this posible :frowning: Can you help me with this? Please. I'll appreciate your h… --- ## [History Query Deadlocks](https://forum.inductiveautomation.com/t/history-query-deadlocks/5437)
**Author:** [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\ **Replies:** 4\ **Last updated:** [November 17, 2012, 12:57pm UTC](https://forum.inductiveautomation.com/t/history-query-deadlocks/5437 "2012-11-17T12:57:07Z")
Hey guys, I’ve been getting these deadlock errors more frequently (I think because I’ve been putting a lot of Sparkline Charts on pages): Is there a way to add the MSSQL “WITH (NOLOCK)” command when reading and wr… --- ## [NullPointerException when running Find/Replace](https://forum.inductiveautomation.com/t/nullpointerexception-when-running-find-replace/5434)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 10\ **Last updated:** [November 16, 2012, 11:51pm UTC](https://forum.inductiveautomation.com/t/nullpointerexception-when-running-find-replace/5434 "2012-11-16T23:51:20Z")
I am running Find/Replace on a window and get a "Uncaught NullPointerException" Error when I do. Any ideas on why? I can run Find/Replace on other windows without any issues. I assume I have an issue with one of my co… --- ## [Custom themes](https://forum.inductiveautomation.com/t/custom-themes/5323)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 7\ **Last updated:** [November 16, 2012, 7:51pm UTC](https://forum.inductiveautomation.com/t/custom-themes/5323 "2012-11-16T19:51:20Z")
Let's suppose I'd like to bind color properties to tag values in order to synchronize my project's color theme either to make project-wide color changes a breeze or just to let the user customize his/her viewer. How mig… --- ## [Clear values from txt field script](https://forum.inductiveautomation.com/t/clear-values-from-txt-field-script/5436)
**Author:** [@rcorkern](https://forum.inductiveautomation.com/u/rcorkern)\ **Replies:** 4\ **Last updated:** [November 16, 2012, 6:18pm UTC](https://forum.inductiveautomation.com/t/clear-values-from-txt-field-script/5436 "2012-11-16T18:18:59Z")
I have an Alert pop page allowing a user to select tags and create an alert, this happens after selecting a Tag, Name, Location, setting alert type, etc... then clicking on a button to execute this. What script can I ad… --- ## [Store only when tags change](https://forum.inductiveautomation.com/t/store-only-when-tags-change/5435)
**Author:** [@Sergio.Estevez](https://forum.inductiveautomation.com/u/Sergio.Estevez)\ **Replies:** 1\ **Last updated:** [November 16, 2012, 3:53pm UTC](https://forum.inductiveautomation.com/t/store-only-when-tags-change/5435 "2012-11-16T15:53:29Z")
Hi Guys! I need help with the transaction groups. I have 1500 tags and I want to create a table that historize every time that the value of the tags changes. I know that I can do it in 1500 different transaction groups… --- ## [Error updating DB from runUpdateQuery](https://forum.inductiveautomation.com/t/error-updating-db-from-runupdatequery/5426)
**Author:** [@0sm0](https://forum.inductiveautomation.com/u/0sm0)\ **Replies:** 2\ **Last updated:** [November 15, 2012, 9:59pm UTC](https://forum.inductiveautomation.com/t/error-updating-db-from-runupdatequery/5426 "2012-11-15T21:59:50Z")
Hi Guys, I have the below action script on a button that takes the updated text in a text area and updates the DB table. It works fine most of the time but when some specific characters are used it errors. ID = even… --- ## [Caching windows on StartUp](https://forum.inductiveautomation.com/t/caching-windows-on-startup/5413)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 8\ **Last updated:** [November 15, 2012, 9:50pm UTC](https://forum.inductiveautomation.com/t/caching-windows-on-startup/5413 "2012-11-15T21:50:15Z")
I have a number of layouts that need to be opened, closed, and cached on Startup so they don't bog the project down when switching between them. I have set these windows caching to ALWAYS. I also thought the method to do… --- ## [Row and Column Selectors in Series](https://forum.inductiveautomation.com/t/row-and-column-selectors-in-series/5428)
**Author:** [@TCK](https://forum.inductiveautomation.com/u/TCK)\ **Replies:** 3\ **Last updated:** [November 15, 2012, 9:08pm UTC](https://forum.inductiveautomation.com/t/row-and-column-selectors-in-series/5428 "2012-11-15T21:08:13Z")
Can the Data Out of the Row Selector be used as a property for the Data In for the Column Selector to allow data selection by rows and then data selection by column? The Column Selector would then have all columns exclud… --- ## [OPC-DCOM Stability Problems](https://forum.inductiveautomation.com/t/opc-dcom-stability-problems/5321)
**Author:** [@cvaldi](https://forum.inductiveautomation.com/u/cvaldi)\ **Replies:** 28\ **Last updated:** [November 15, 2012, 7:23pm UTC](https://forum.inductiveautomation.com/t/opc-dcom-stability-problems/5321 "2012-11-15T19:23:48Z")
After some time of running some clients Ignition stop working and in System Console log appears this error: Failed to post the message to the thread. ThreadID = 1584, errorCode = 1816 com.jniwrapper.win32.LastErrorExcept… --- ## [Long running transaction](https://forum.inductiveautomation.com/t/long-running-transaction/5422)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 6\ **Last updated:** [November 15, 2012, 4:33pm UTC](https://forum.inductiveautomation.com/t/long-running-transaction/5422 "2012-11-15T16:33:14Z")
Isn't this supposed to timeout? SELECT st.tagpath as "Point", COALESCE(CASE st.datatype WHEN 0 THEN sd.intvalue WHEN 1 THEN sd.floatvalue end,0) AS "State", CASE sd.dataintegrity WHEN 192 THEN 'Good' WHEN 32 THEN 'Not… --- ## [Alerts, Events, Transactions](https://forum.inductiveautomation.com/t/alerts-events-transactions/5423)
**Author:** [@ccooper](https://forum.inductiveautomation.com/u/ccooper)\ **Replies:** 4\ **Last updated:** [November 15, 2012, 4:30pm UTC](https://forum.inductiveautomation.com/t/alerts-events-transactions/5423 "2012-11-15T16:30:57Z")
I am trying to decide the best way to log and keep track of Alerts and what we call 'Events' (machine events). We have existing systems in which I am trying to convert the functionality to Ignition. Our existing systems … --- ## [Text Area Tab Handling](https://forum.inductiveautomation.com/t/text-area-tab-handling/5424)
**Author:** [@phassler](https://forum.inductiveautomation.com/u/phassler)\ **Replies:** 1\ **Last updated:** [November 15, 2012, 1:56pm UTC](https://forum.inductiveautomation.com/t/text-area-tab-handling/5424 "2012-11-15T13:56:15Z")
I would like a setting on a Text Area that would cause focus to go to the next component when the user presses TAB. Also, it should not insert the tab character into the text area. (The default value of the setting sho… --- ## [One-shot buttons and security?](https://forum.inductiveautomation.com/t/one-shot-buttons-and-security/3895)
**Author:** [@scott\_rister](https://forum.inductiveautomation.com/u/scott_rister)\ **Replies:** 6\ **Last updated:** [November 14, 2012, 9:31pm UTC](https://forum.inductiveautomation.com/t/one-shot-buttons-and-security/3895 "2012-11-14T21:31:05Z")
i am having a problem with my one-shot buttons and disabling them with my security parameters. My one shots are set up to be disabled unless the operator is logged in as one of two roles. However they are not disabled. W… --- ## [Pasting component into container](https://forum.inductiveautomation.com/t/pasting-component-into-container/5396)
**Author:** [@pat.stave](https://forum.inductiveautomation.com/u/pat.stave)\ **Replies:** 5\ **Last updated:** [November 14, 2012, 9:14pm UTC](https://forum.inductiveautomation.com/t/pasting-component-into-container/5396 "2012-11-14T21:14:26Z")
Pasting a component into a container will only work while the designer window has a zoom level of 100%. If the zoom level is anything other than 100% the component will simply paste to the root container instead of the c… --- ## [Script to view OPCItemPath for a single tag?](https://forum.inductiveautomation.com/t/script-to-view-opcitempath-for-a-single-tag/5421)
**Author:** [@jasonpdavid](https://forum.inductiveautomation.com/u/jasonpdavid)\ **Replies:** 2\ **Last updated:** [November 14, 2012, 8:02pm UTC](https://forum.inductiveautomation.com/t/script-to-view-opcitempath-for-a-single-tag/5421 "2012-11-14T20:02:16Z")
Is there a way to view the OPC Item Path? I am using the IALABS Scripting Module to add a new tag with an analog alert but I need to bind the OPCItemPath to a referenced tag. I've successfully ran the following script… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1598) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1600)