Top
Top
LibraryEASYProcess Reference Manual 5ToolsRun Query

Run Query Overview

The Run Query tool is used to create queries for the sake of testing. This is incredibly useful to use during development because you can easily test queries you are writing to see if they are working and returning records as expected. The Run Query tool is also used when debugging issues in process logs you can right click a query log and select run query. This will take you to the Run Query tool with the query you are inspecting automatically copied and pasted into the Query String textbox.


How to Use Run Query Tool

How to Use Run Query Tool

The Run Query Tool has 3 input fields that must be properly filled in in order to properly use the tool. Those fields are: Db Type, Connection String, and Query String.

The Db Type and and Connection String should be filled out by using the Config. Settings widget on the right side of your screen. In the Config Settings you can select the Database you would like to query and then you can drag and drop the Db Type and Connection string for that database into the corresponding input fields.

 

Once you have entered the Db Type and Connection String, you can begin writing the actual query in the Query String field. Note that you must drag and drop the DbName config from the same database config and preface the table name with it. Also, the output of the columns is in random order and will not match the order of your select statement.

Finally, here are a few things to note about running multiple queries:

  1. You can run multiple queries in the query box.
  2. If you select a particular query and select run or press F5 it will run the selected query.
  3. If you do not select a query and run it, it will always run first in the query box.
  4. If you select a query and run it, it will keep the query selected.
  5. If you select a query and press query builder, you can edit this selected query.


Powered by EASYProcess (© 2019 K-Rise Systems, Inc).