Edit SQL content

Maker
8

All views and components have properties. These can be explored using the Perspective Property Editor.

Ignition allows you to create custom properties on views and components. You will see the usefulness of this as you work through your project.

Custom properties
Custom properties344×511 26.5 KB

  1. The Perspective Property Editor panel.
  2. CUSTOM section.
  3. Create batchNum. Give it a value of 1 for now.
  4. Create a batchData custom property. The values will be populated by the query so you don't need to create those manually.
  5. Create bindings on batchNum and batchData as I described earlier. Monitor the changes here when you interact with your form.

... isnt it an idea to filter out the column i want for each field?

And run 12 queries instead of one? I don't think so!