Using the Query Browser

The Query Browser is a very convenient tool that lets you make simple edits in a database table, and interact with all of the databases that Ignition is connected to, for example running queries and browsing tables and schemas. Because Ignition is so heavily integrated with databases, it is very common in the course of project design to need to inspect the database directly, or to experiment with a SQL query to get it just right.

To Edit the Database using the Query Browser

  1. In Designer, go to the Tools > Database Query Browser menu item.
    The Database Query Browser is displayed which lets you see a list of databases that Ignition is connected to plus a text box area so you can enter your queries.

  2. Choose a database from the list under Schema.
    Notice the database is expanded and the Query textbox shows a SELECT query which includes the table's primary key(s) such as, Select * From database_name.

  3. Click Execute.
    See the data that gets filled in the Resultset tab.

  4. Click Edit to change the values in the Resultset, and click Apply to commit your edits or Discard to back out.
    Note: You can Edit the values only when the table is displaying the id numbers (table's primary keys), otherwise you can not Edit the table values.

  5. To verify the changes you made, click Execute.
    You should now see what you have modified is actually applied.

To Monitor the Database using the Query Browser

The Query Browser also lets you monitor a database table for changes by using the Auto Refresh button.

This is often convenient when designing Transaction Groups. As the group runs, you can view the table that it is targeting with auto-refresh turned on to watch how the group is altering the table.