Overview

In this lesson, we will review the Query Analyzer tool on Wayfast. This can be used to monitor SQL queries and it can help developers to create or edit database objects (functions, views, jobs, partitions, stored procedures) improving database performance inside the Wayfast application. This is very helpful on those cases where developers don’t have the SQL Server installed in the environment.

How to use the Query Analyzer in Wayfast?

In Wayfast, turn to “Database” icon at top menu and click on “Query Analyzer” tab

Open

A new tab is opened on the browser, we can observe a navigation bar at the left. This contains 3 dropdown filters that we can use to select the Database and the corresponding Tables associated.

Open

We are now ready to write SQL queries against your database. We can use this interface to create database objects, insert data into a database table, select data, update data, delete data. Once the statement is made, click on “Execute” button to run the script or “Synchronize” in case you need to update something that was modified in Database and you want to include in Wayfast.

Access to Query Analyzer from different sections in Wayfast

In the previous lessons related to functions, views, jobs, partitions and stored procedures, we observed that there are links to “Edit Script” or “View Script”. These options are redirecting to the query analyzer and they are displaying the statements from SQL into Wayfast.

In this example, under Stored Procedure’s dashboard, we can click on lookup icon and it will open automatically the Query Analyzer

Recap

In this lesson, we learnt about the Query Analyzer in Wayfast and we realize that this tool acts as an interface to run SQL queries against our own database. We can use it to create and run adhoc scripts, or we can create new SQL scripts and save them for later. We need to be careful on this actions that can modify most of the controls created in our application.