Binding SQL query to a template repeater

Ignition
,
1

Hi all
Is there a way to binding a SQL query to template parameters, in a template repeater? Currently I have this 3x4 static dataset to define all the template parameters but I would like to use a SQL query to replace it.

1
1697×973 48.9 KB

2

Welcome @JJJ, you can use a named query or SQL query binding on the Template Parameters, you just need to make sure you column names match your parameter names.

Here is a tutorial on the Template Repeater

Here is a tutorial on database SQL query bindings

Here is a tutorial on database Named query bindings

Hopefully, these should be enough to get you started. But let me know if you have anymore questions.