Inserting Data Content
To insert content into the project:
Click the link for the data set on the project definition page.
Click the Insert Data button.
Use the Insert Data Content page to insert data content into the ADS project.
Field or Control
There are two types of fields in the grid.
Select the operation to use for this field. Valid operations are:
Enter the value for the SQL.
For every operation other than All you need to supply one or more values in this text box. Based on the operator and value, the system will build the actual WHERE clause for the filter condition on the root record of the data set definition.
Click the Search button to display the rows meeting the filter criteria and display them on the Search Results grid.
|Search Results Grid||
Use the Search Results grid to select the rows of data to include in the data set content.
Use the Select All button to select all rows.
Use the deselect All button to deselect all rows.
Click the Insert button to insert the selected rows into the data set content and remain on the page.
|Insert and Return||
Click the Insert button to insert the selected rows into the data set content and return to the Data Set Content page.
Insert Related Data Sets
If the data set selected contains relationships to other data sets, the Insert Related Data Sets grid is displayed. Depending on how the related data sets were defined, they will either always be included, or the user will be able to select which related data sets to include in the project.
See Defining Relations.
This section provides examples for building WHERE Clauses.
For any of the numeric operators, select the operator and provide a value.
The Between operator expects an AND keyword in the values field.
In interprets the , (comma) as the separator for the literals.
Like will implicitly add % (percent sign) with the string.