Service Builder

The Service Builder allows you to create service pages. To begin the process of creating a service page, click on the Service Builder option in Builders tab.

Step 1: Selecting a Type of service page

Settings

Click Next to proceed to step 2.

Step 2: Creating a Database Connection

Select or create a database connection from where the data shown in the Service page will be retrieved. You can select one of the existing database connections, create a new connection or select one of the sample databases.

Click Next to proceed to step 3.

Step 3: Data Source

You now have to select a data source as well as the fields to be included in the Service page.

Data Source Settings

Parameter	Description
Data Source	Select the table or view to use as the data source.
Build Query	Opens the Visual Query Builder window where you can setup a SQL query that will act as the data source.
Available Fields	This list-box shows all the fields available in the table or view.
Fields for the Grid	These are the fields to be shown in the grid. They are selected from among the Available Fields.
	Select an Available Field then click this button to add it to the grid.
	Click this button to add ALL Available Fields to the grid.
	Select a grid field then click this button to remove it from the grid.
	Click this button to remove all fields from the grid.
	Select a grid field then click this button to move it upwards in the order of appearance.
	Select a grid field then click this button to move it downwards in the order of appearance./td>
	Refreshes the connection if you make changes to the database after having begun using the builder.
Order by	Select a field by which the records will be ordered by when initially displayed.

Once done, click Finish to close the builder and generate the service page.