You can help by commenting or suggesting your edit directly into the transcript. We'll review any changes before posting them. All comments are completely anonymous. For any comments that need a reply, consider emailing training@inductiveautomation.com.
Version:
LESSON LIST
Autoplay
Off
-
2:47Property Binding
-
2:15Property Binding – Bidirectional
-
2:19Tag Binding
-
2:17Tag Binding – Drag and Drop
-
2:19Tag Binding – Bidirectional
-
1:40Tag and Component Overlays
-
3:20Indirect Tag Binding
-
2:17Tag Historian Binding
-
3:21Expression Binding
-
1:24Expression Binding – Concat Strings
-
1:01Expression Binding – Celsius to Fahrenheit
-
2:01Expression Binding – Format Date
-
2:46Expression Binding – Date Manipulations
-
1:23Expression Binding – Bit Functions
-
2:06Expression Binding – Switch
-
1:43Expression Binding – Checking Conditions
-
2:40DB Browse Binding
-
2:05DB Browse Binding – Dynamic Filters
-
1:16SQL Query Binding
-
2:26SQL Query Binding – Polling
-
1:47SQL Query Binding – Dynamic Filters
-
1:55SQL Query Binding – Scalar Query and Fallback
-
1:47SQL Query Binding – Scalar Query and Update
-
2:24Cell Update Binding
-
2:07Function Binding
-
4:22Component Styles
Take topic challenge
Take topic challenge
LESSON
SQL Query Binding
Description
The SQL Query binding is a polling binding type that will run a SQL Query against any of the database connections configured in the Gateway.
Video recorded using: Ignition 7.7
Transcript
(open in window)[00:00] The SQL Query Binding is a polling binding type that will run a SQL query against any other database connections configured in the ignition gateway. You can bind any property to a SQL query to retrieve data from a database. So here I have a table. I can bind the data property of the table to SQL query. You do have to know the SQL language in order to use this binding type. If you don't know the language, you can use a DB Browse binding that helps you build the SQL query. Otherwise, you type in the query directly into this field. In the right-hand side, you can bring in any property value from the screen, as well as, you can bring any tag value into the query making it dynamic. So here's an example query. I'm going to select the first name, the last name, and the email from our customer table, and I'm going to order it by the first name in ascending order. At the bottom, you specify which database connection you want to run this query through. If you leave this blank, Ignition will choose the default connections attached to this project. There's a project property for that. Otherwise, you can specify the connection directly. So here all of my data is in the Data, Database Connection. At the very bottom you have Polling Mode, which is how often you want this query to run.
[01:06] We're going to look at this one in another lesson. Once you have the query in there, you press OK, you should see your data come back in the table.