Developing - Creating Fusion Operations

Using SQL to create operations:

SQL is used to gather the necessary data the charts need. Most of the SQL queries used here and the SQL that you will typically use to create your charts, is rather basic. This documentation assumes you have basic knowledge of SQL (using SELECT statements to obtain data). Any complex SQL that is used in this document will be explained briefly. For more information on how to use SQL, it is recommended you visit http://www.w3schools.com/sql/.

For the following examples, we will be using a sample database as the source of data for our charts. The sample schema is called dillsample and the table is named employee. This database contains various employee information such as an employee ID number, job title, gender, date of birth, etc.