How to Define an Application Basket
To be able to define an application basket, first make sure:
To define an application basket:
The Application Baskets window opens.
For example: Closed Contracts 2009.
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
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:
The Basket Table SQL Clauses window opens.
contract_date, start_date, end_date, owner, total_amount
closed='Y' AND end_date < '31-12-2009'
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'"/>