This tutorial will introduce you to the SQL Wizard, and teach you how you can use it to select data for a ForEach tag in a table, a task you previously learned in the ForEach Tag tutorial. This tutorial opens up the pathway to several other tutorials relating to the SQL Wizard which allows you to make advanced data selections through SQL.
Now that you know what the SQL Wizard is and at least have had a glimpse of its power, you can jump right into some of the great things it offers by starting off with a simple sort operation. In this tutorial we’ll teach you how to sort your data using the Great and Powerful Wizard of SQL.
The next great feature is filtering. This is great because sometimes you don’t want all of you data. Here, we’ll teach you exactly how to filter values when your criteria depends on data that will always be the same.
Along with filtering with static values, as seen in Part 3 of the SQL Wizard tutorials, you can filter using a Parameter which is a convenient way to generate the same document multiple times using different set values.
In this final tutorial on filters in the SQL Wizard, we’ll show you how to make more complex filters which combine logical operators such as and and or. For example, we want to filter data based on this condition AND either that condition or the other. Open this tutorial to get more specifics instead of a general vague idea.
The last box in the SQL Wizard not touched on in any of the above tutorials is the Join Tables box. Here is an informational box which shows you how joins have been automatically applied. In this tutorial, we will perform a simple data selection operation which will cause two tables to be joined so you can see this effect in its natural habitat.