# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1500 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1501 --- ## [Filtering data from system.net.httpGet](https://forum.inductiveautomation.com/t/filtering-data-from-system-net-httpget/9572)
**Author:** [@Micky.Franks](https://forum.inductiveautomation.com/u/Micky.Franks)\ **Replies:** 5\ **Last updated:** [January 21, 2015, 1:46pm UTC](https://forum.inductiveautomation.com/t/filtering-data-from-system-net-httpget/9572 "2015-01-21T13:46:03Z")
I am trying to use the example in the manual for system.net.httpGet and I am unable to figure out the correct expression and match to pull the data values I need. I am able to reach the page and get the string of info b… --- ## [7.7.0 - SQLTags$ClientSubscriptionProxy Error](https://forum.inductiveautomation.com/t/7-7-0-sqltags-clientsubscriptionproxy-error/9578)
**Author:** [@jmartell](https://forum.inductiveautomation.com/u/jmartell)\ **Replies:** 1\ **Last updated:** [January 21, 2015, 8:30am UTC](https://forum.inductiveautomation.com/t/7-7-0-sqltags-clientsubscriptionproxy-error/9578 "2015-01-21T08:30:07Z")
We are having some problems on a redundant pair of servers. Many of our issues have known causes, but I logged on today and found a log full of this message: 3:55:45 PM SQLTags$ClientSubscriptionProxy Client subscr… --- ## [Linking Ignition to iFix](https://forum.inductiveautomation.com/t/linking-ignition-to-ifix/9577)
**Author:** [@dandandan](https://forum.inductiveautomation.com/u/dandandan)\ **Replies:** 1\ **Last updated:** [January 21, 2015, 3:18am UTC](https://forum.inductiveautomation.com/t/linking-ignition-to-ifix/9577 "2015-01-21T03:18:40Z")
I am looking for the best way to share tags between Ignition and iFix. Ideally, I would want everything to be moved to Ignition, since iFix is a hassle, but for now I am only using pieces of Ignition that are clear upgra… --- ## [Select Query Binding Question](https://forum.inductiveautomation.com/t/select-query-binding-question/9564)
**Author:** [@Don\_t\_shoot](https://forum.inductiveautomation.com/u/Don_t_shoot)\ **Replies:** 4\ **Last updated:** [January 21, 2015, 3:11am UTC](https://forum.inductiveautomation.com/t/select-query-binding-question/9564 "2015-01-21T03:11:43Z")
I want to binding a query to the component’s data , but in the select query I used different database’s table ,but the different database are setup in one Mysql software as the picture ,and I used the select query and … --- ## [SQL Assistance, Changing "true" to 1, "false" to 0 leave oth](https://forum.inductiveautomation.com/t/sql-assistance-changing-true-to-1-false-to-0-leave-oth/9576)
**Author:** [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\ **Replies:** 1\ **Last updated:** [January 20, 2015, 8:54pm UTC](https://forum.inductiveautomation.com/t/sql-assistance-changing-true-to-1-false-to-0-leave-oth/9576 "2015-01-20T20:54:10Z")
Ok I have a column AttrValue In that Column, I have various values 3.124 0 2.451 3.1 true 1.15 false 4.23 Here is the SQL query so far (at least part of it dealing with true false).. SELECT TimeStamp, AttrName, (… --- ## [Using python help function](https://forum.inductiveautomation.com/t/using-python-help-function/9482)
**Author:** [@Blefe001](https://forum.inductiveautomation.com/u/Blefe001)\ **Replies:** 4\ **Last updated:** [January 20, 2015, 8:00pm UTC](https://forum.inductiveautomation.com/t/using-python-help-function/9482 "2015-01-20T20:00:35Z")
I am trying to dig into the hidden component features using python scripting. I can see all the available function in the component when I use "print dir(component)" however once I find the function I want to use I do no… --- ## [Failed Executions on writing to DB](https://forum.inductiveautomation.com/t/failed-executions-on-writing-to-db/9575)
**Author:** [@jjt\_mo](https://forum.inductiveautomation.com/u/jjt_mo)\ **Replies:** 0\ **Last updated:** [January 20, 2015, 6:59pm UTC](https://forum.inductiveautomation.com/t/failed-executions-on-writing-to-db/9575 "2015-01-20T18:59:40Z")
Looking for some help on diagnosing random 'Failed Executions' on writing info to MSSQL. Systems have been installed for several years now and never paid much attention to the failures before. New data has become more … --- ## [Modbus TCP device problem](https://forum.inductiveautomation.com/t/modbus-tcp-device-problem/9543)
**Author:** [@manuwestern](https://forum.inductiveautomation.com/u/manuwestern)\ **Replies:** 1\ **Last updated:** [January 20, 2015, 3:46pm UTC](https://forum.inductiveautomation.com/t/modbus-tcp-device-problem/9543 "2015-01-20T15:46:06Z")
Hello, I've the same problem, i use an Advantech EKI-1221 gateway to connect our old Modicon 984 modbus rtu rs-232 to tcp/ip. I added the device to the ignition configuration site, the connection state changes frequent… --- ## [hasRole() not working in component script](https://forum.inductiveautomation.com/t/hasrole-not-working-in-component-script/9549)
**Author:** [@qversa](https://forum.inductiveautomation.com/u/qversa)\ **Replies:** 3\ **Last updated:** [January 20, 2015, 3:40pm UTC](https://forum.inductiveautomation.com/t/hasrole-not-working-in-component-script/9549 "2015-01-20T15:40:53Z")
Hi, I am trying to use the following script snippet in a visionWindowOpened script: if hasRole("Supervisor"): system.gui.messageBox("True","Alert") else: system.gui.messageBox("False","Alert") It does not seem to… --- ## [Report Serch Condition Question](https://forum.inductiveautomation.com/t/report-serch-condition-question/9527)
**Author:** [@Don\_t\_shoot](https://forum.inductiveautomation.com/u/Don_t_shoot)\ **Replies:** 3\ **Last updated:** [January 20, 2015, 7:46am UTC](https://forum.inductiveautomation.com/t/report-serch-condition-question/9527 "2015-01-20T07:46:00Z")
I want to create a report by using Report Viewer, and I want give user some condition to serch what they want . Like the picture in attachement ,I have three questions in the picture,thank all the friends ! … --- ## [Expression Question for Removing Portion of Part Number](https://forum.inductiveautomation.com/t/expression-question-for-removing-portion-of-part-number/9567)
**Author:** [@pknox](https://forum.inductiveautomation.com/u/pknox)\ **Replies:** 2\ **Last updated:** [January 19, 2015, 7:02pm UTC](https://forum.inductiveautomation.com/t/expression-question-for-removing-portion-of-part-number/9567 "2015-01-19T19:02:19Z")
We have a query that returns part number CC830750-000395-849 inside a label. We have another label and only want to display the CC830750. The part # CC830750-000395-849 is contained in {Root Container.Label 2.text} Is t… --- ## [Version mismatch in initI18N when debugging Designer](https://forum.inductiveautomation.com/t/version-mismatch-in-initi18n-when-debugging-designer/9565)
**Author:** [@rforbes](https://forum.inductiveautomation.com/u/rforbes)\ **Replies:** 0\ **Last updated:** [January 19, 2015, 4:54pm UTC](https://forum.inductiveautomation.com/t/version-mismatch-in-initi18n-when-debugging-designer/9565 "2015-01-19T16:54:19Z")
Hi, When I try to debug the Designer in Eclipse per the Developer's Guide I get the following error which repeats indefinitely. I tried cleaning/rebuilding in Eclipse and clearing the jnlp cache, but no luck. Any idea … --- ## [Spell Check?](https://forum.inductiveautomation.com/t/spell-check/6559)
**Author:** [@stuartd](https://forum.inductiveautomation.com/u/stuartd)\ **Replies:** 5\ **Last updated:** [January 19, 2015, 4:26pm UTC](https://forum.inductiveautomation.com/t/spell-check/6559 "2015-01-19T16:26:01Z")
So it has been requested from multiple people of the possibility of a spell check for text fields. Is there any way to do this? Or is a feature coming soon that is going to have the ability to have a spell check system d… --- ## [South Docked Window moves off screen](https://forum.inductiveautomation.com/t/south-docked-window-moves-off-screen/9471)
**Author:** [@qversa](https://forum.inductiveautomation.com/u/qversa)\ **Replies:** 2\ **Last updated:** [January 17, 2015, 9:08pm UTC](https://forum.inductiveautomation.com/t/south-docked-window-moves-off-screen/9471 "2015-01-17T21:08:22Z")
Hi, I have a North docked and a South docked window. When I open a popup in the Main window and drag it down, it pushed the South docked window off the screen by expanding the Main window. Is there a way to keep the Sout… --- ## [Change cursor in confirmation box](https://forum.inductiveautomation.com/t/change-cursor-in-confirmation-box/9556)
**Author:** [@Blefe001](https://forum.inductiveautomation.com/u/Blefe001)\ **Replies:** 2\ **Last updated:** [January 16, 2015, 5:33pm UTC](https://forum.inductiveautomation.com/t/change-cursor-in-confirmation-box/9556 "2015-01-16T17:33:02Z")
Is there a way to change the cursor in the confirmation box to something other than the default? e.g.)The hand I have the confirmation box appear from inside a script when a button is pushed so is there a way to edit t… --- ## [Scripting a property change](https://forum.inductiveautomation.com/t/scripting-a-property-change/9552)
**Author:** [@arawtani](https://forum.inductiveautomation.com/u/arawtani)\ **Replies:** 3\ **Last updated:** [January 16, 2015, 1:36pm UTC](https://forum.inductiveautomation.com/t/scripting-a-property-change/9552 "2015-01-16T13:36:46Z")
Hello, I just started working with ignition probably one week ago so I'm extremely new to the software. In fact, I have never programmed anything before in my entire life. That being said, my apologies if the question… --- ## [Template that OUTPUTS data (common search filters)](https://forum.inductiveautomation.com/t/template-that-outputs-data-common-search-filters/7521)
**Author:** [@george](https://forum.inductiveautomation.com/u/george)\ **Replies:** 6\ **Last updated:** [January 16, 2015, 9:43am UTC](https://forum.inductiveautomation.com/t/template-that-outputs-data-common-search-filters/7521 "2015-01-16T09:43:43Z")
I'm got a project with various different screens to analyse production data. On these screens I want to put certain common filters, e.g. start date, end date, line, shift etc. It seems logical to create a template that… --- ## [Need help with simple select statement](https://forum.inductiveautomation.com/t/need-help-with-simple-select-statement/9548)
**Author:** [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\ **Replies:** 2\ **Last updated:** [January 15, 2015, 8:58pm UTC](https://forum.inductiveautomation.com/t/need-help-with-simple-select-statement/9548 "2015-01-15T20:58:45Z")
I have a project that defaults to DB1 database. I need to create a SQL statement that pulls data from DB2 connection. SQL \* DB2.MachineWorkOrders Doesn't work for me. What am I missing?? I am assuming DB1 and DB2… --- ## [Deleting component translation terms](https://forum.inductiveautomation.com/t/deleting-component-translation-terms/9546)
**Author:** [@Vita](https://forum.inductiveautomation.com/u/Vita)\ **Replies:** 2\ **Last updated:** [January 15, 2015, 3:32pm UTC](https://forum.inductiveautomation.com/t/deleting-component-translation-terms/9546 "2015-01-15T15:32:10Z")
Hi, in Translatable terms window there are 2 types of translation. Component and Global. My question is how to suppress component translation? Because when i use component translation first and then delete the text (no… --- ## [TCP Driver Writable tag issue](https://forum.inductiveautomation.com/t/tcp-driver-writable-tag-issue/9542)
**Author:** [@DNP3](https://forum.inductiveautomation.com/u/DNP3)\ **Replies:** 7\ **Last updated:** [January 14, 2015, 10:52pm UTC](https://forum.inductiveautomation.com/t/tcp-driver-writable-tag-issue/9542 "2015-01-14T22:52:33Z")
I'm using the TCP driver to connect to a device that sends out data. The device requires an "ACK" message so I'm using the "Writable" tag that is created with the TCP driver. Be default this tag is a String. The last l… --- ## [Dataset with a Interger to lookup bit location](https://forum.inductiveautomation.com/t/dataset-with-a-interger-to-lookup-bit-location/9540)
**Author:** [@DSI600](https://forum.inductiveautomation.com/u/DSI600)\ **Replies:** 1\ **Last updated:** [January 14, 2015, 10:04pm UTC](https://forum.inductiveautomation.com/t/dataset-with-a-interger-to-lookup-bit-location/9540 "2015-01-14T22:04:24Z")
I created a Internal Custom property of a Dataset inside a template. Inside the dataset column 1 contains the values 0-31. Column 2 has a string value - Running, Stopped, Paused....etc... I want to do a lookup in the dat… --- ## [Binding text property to Dataset](https://forum.inductiveautomation.com/t/binding-text-property-to-dataset/9536)
**Author:** [@saish](https://forum.inductiveautomation.com/u/saish)\ **Replies:** 1\ **Last updated:** [January 14, 2015, 4:57pm UTC](https://forum.inductiveautomation.com/t/binding-text-property-to-dataset/9536 "2015-01-14T16:57:58Z")
Is it possible to bind text property of Label component to Dataset's particular field column. Or an example for how to use custom property which has datatype as Dataset --- ## [Logging flow totals](https://forum.inductiveautomation.com/t/logging-flow-totals/9525)
**Author:** [@Micky.Franks](https://forum.inductiveautomation.com/u/Micky.Franks)\ **Replies:** 3\ **Last updated:** [January 14, 2015, 2:54pm UTC](https://forum.inductiveautomation.com/t/logging-flow-totals/9525 "2015-01-14T14:54:23Z")
I have a dump scale that's measuring flow rate of a stream of rice which has a accumulator to poll. Right now I am using Wonderware to poll every hour and take the current total and previous total and move the differenc… --- ## [Dynamic Document Display Rotation](https://forum.inductiveautomation.com/t/dynamic-document-display-rotation/9539)
**Author:** [@Automator59](https://forum.inductiveautomation.com/u/Automator59)\ **Replies:** 3\ **Last updated:** [January 14, 2015, 2:41pm UTC](https://forum.inductiveautomation.com/t/dynamic-document-display-rotation/9539 "2015-01-14T14:41:26Z")
I have a requirement to have a screen that will cycle through documents (PDF Viewer) that can be shown at any time range selected by the supervisor. There will be more than one document to cycle and each one can have a … --- ## [SQL query syntax when using scripting](https://forum.inductiveautomation.com/t/sql-query-syntax-when-using-scripting/9538)
**Author:** [@TomPedlar](https://forum.inductiveautomation.com/u/TomPedlar)\ **Replies:** 3\ **Last updated:** [January 13, 2015, 8:48pm UTC](https://forum.inductiveautomation.com/t/sql-query-syntax-when-using-scripting/9538 "2015-01-13T20:48:45Z")
Hi, I'm trying to export data from an SQL database to an excel spread sheet. Using posts on the forum this is working OK, the problem is when I try to select a data range using the "Where" command I keep getting syntax e… --- ## [Weird Template Behavior on inactivity](https://forum.inductiveautomation.com/t/weird-template-behavior-on-inactivity/9466)
**Author:** [@MCC](https://forum.inductiveautomation.com/u/MCC)\ **Replies:** 3\ **Last updated:** [January 13, 2015, 5:10pm UTC](https://forum.inductiveautomation.com/t/weird-template-behavior-on-inactivity/9466 "2015-01-13T17:10:17Z")
We have noticed some very strange behavior in the Vision Client when a window that includes template-based graphics is displayed. If the window is left open long enough for the logged-in user to be logged out automatical… --- ## [Socket Connection Read Data as Byte Array](https://forum.inductiveautomation.com/t/socket-connection-read-data-as-byte-array/9533)
**Author:** [@DNP3](https://forum.inductiveautomation.com/u/DNP3)\ **Replies:** 3\ **Last updated:** [January 13, 2015, 3:40pm UTC](https://forum.inductiveautomation.com/t/socket-connection-read-data-as-byte-array/9533 "2015-01-13T15:40:23Z")
I'm trying to create a socket connection and read the buffer as an array of bytes. The socket connection works fine. So performering a simple socket.recv (returns a string) works fine, however, when I perform a socket.… --- ## [Using workorder selector component select all selections](https://forum.inductiveautomation.com/t/using-workorder-selector-component-select-all-selections/9537)
**Author:** [@Don\_t\_shoot](https://forum.inductiveautomation.com/u/Don_t_shoot)\ **Replies:** 0\ **Last updated:** [January 13, 2015, 8:03am UTC](https://forum.inductiveautomation.com/t/using-workorder-selector-component-select-all-selections/9537 "2015-01-13T08:03:53Z")
I use the version of 7.7.2-rc1. I want to add a new selection called ‘all’ in the workorder component ,this selection include all the workorders in this component .And ‘all’ is the defult selection. How to work th… --- ## [Self-defined dropdown selection](https://forum.inductiveautomation.com/t/self-defined-dropdown-selection/9534)
**Author:** [@Don\_t\_shoot](https://forum.inductiveautomation.com/u/Don_t_shoot)\ **Replies:** 1\ **Last updated:** [January 13, 2015, 1:52am UTC](https://forum.inductiveautomation.com/t/self-defined-dropdown-selection/9534 "2015-01-13T01:52:06Z")
if I want to put a component to my report table ,which can self-defined some dropdown selections ,which component can I use ? And how to use it make these seil defined selections? --- ## [7.7.2 - Data Type Inheritance Issue](https://forum.inductiveautomation.com/t/7-7-2-data-type-inheritance-issue/9529)
**Author:** [@MCC](https://forum.inductiveautomation.com/u/MCC)\ **Replies:** 1\ **Last updated:** [January 13, 2015, 12:52am UTC](https://forum.inductiveautomation.com/t/7-7-2-data-type-inheritance-issue/9529 "2015-01-13T00:52:33Z")
I have a user-defined data type that includes alarming. I have other user-defined types that include instances of the alarm type. I renamed the alarm extension in the parent type. In most instances the rename inherited … [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1499) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1501)