How to Define an Application Basket

To be able to define an application basket, first make sure:

·	There is a repository version that is a production version.

·	For this production version, the application model is generated.

To define an application basket:

1.	From the Repository Manager menu, select Define, Application Baskets.

The Application Baskets window opens.

ALTERNATIVE:

You can also open this window from the Manage tab of the catalog, by double-clicking Application Baskets.

2.	Specify a Name for the application basket, and optionally a Description.

For example: Closed Contracts 2009.

NOTE:

The name of a basket cannot contain any of the following characters:

\ / : * ? " < >

3.	Select a Production Version from the dropdown list.

4.	Save your changes.

All business areas and tables of this application (production version) are inserted as basket sections and basket tables. Also, an Export Model is generated in XML format, and the Model Generated field is set to the current date and time.

The Export Model is also written to a file that is used when exporting a (part of an) application using this basket. For example to:

C:\XML Repository Manager\models\Closed Contracts 2009_basket.xml

5.	In the Sections Exported part of the window, delete or Exclude all sections that you do NOT want to be exported.

6.	Likewise, for each included section, in the Tables Exported in this Section part of the window, delete or Exclude all tables that you do NOT need.

7.	Save your changes.

The Export Model is adapted automatically.

If you want to export specific columns only, or if you want to put restrictions on the records exported in your basket, it is possible to specify an additional SELECT and a WHERE clause. To do this:

8.	In the Tables Exported in this Section part of the window, select the table for which you want to change the SELECT or WHERE clause.

9.	Click the SELECT and WHERE Clause button.

The Basket Table SQL Clauses window opens.

10.	In the SELECT clause field, type the column names to be selected. For example:

contract_date, start_date, end_date, owner, total_amount

11.	In the WHERE clause field, you can type a SQL condition. For example:

closed='Y' AND end_date < '31-12-2009'

12.	Save your changes.

The Export Model for the application basket is regenerated. In the example above, this model would contain the following line:

<Contracts table="CONTRACT" pk="1"

select="contract_date, start_date, end_date, owner, total_amount"

where="closed='Y' AND end_date < '31-12-2009'"/>