To start the Visual Query Builder – you have to be editing the Query Scripts. When in Edit mode – the buttons in the upper right hand side of the Script Editor will be enabled. Note the Visual Query Builder button at the top in the screen capture above.
When you click the button the screen below is shown. You will have to Load the query into the Visual Query Builder after the window appears.
The above screen capture shows what the Visual Query Builder window looks like. in this case a query has already been loaded (using the Load from Query button at the bottom).
The upper right hand side has the list of database tables and views in the database – and you can drag/drop them into the design area on the left. You can then select which fields to include, what conditions to select records, groupings, sorting, etc. in the middle area.
The bottom area shows the SQL that is being built from the visual windows above.
This can be a far more efficient way of writing queries than creating them by hand.
It is important to note that the Visual Query Builder supports the Re-usable Query SQL Extensions of the Script Editor.
In the above screen capture you can see the use of the LUSTRING extension. When you click the Visual Query Builder button – the screen below is shown.
The above screen capture shows you that the Visual Query Builder supports InSights SQL Extensions. You can see the SQL at the bottom – and note it includes a LUSTRING extension – and the in the middle box – you can see that the criteria contains the LUSTRING parameter. InSights is able to automatically place the SQL Extensions in this area for you when it loads the SQL from the Query.
