¶

Using the Conductor Administration Interface, we are going to make and save a query to an XML template in WebDav, and then demonstration its use from a browser.

First we will make a new WebDAV directory. From Web Application Server -> Content Management -> Repository click the "New folder" icon and in the shown form enter for "Folder Name": xmlt. Choose for "Owner" dav and click the "Create" button.

Next we need to configure a virtual directory mapping to this so that XML Templates can be executed later. Go to Web Application Server / Virtual Domains & Directories and for your {Default Web Site} click the link "New Directory". In the shown form click "Next".

The programmatic equivalent for creating a virtual directory is the command in iSQL:

SQL>vhost_define(lpath=>'/DAV/xmlt',
                 ppath=>'/DAV/xmlt/',
                 is_dav=>1,
                 vsp_user=>'demo',
                 opts=>vector('xml_templates', 'yes'));

Now we go to Database/Interactive SQL and will use a simple query. Here we are assuming that the Demo database is being used, so we will query the Customers table:

Now go to XML -> SQL-XML and enter in the query area the sql statement from above. Here we can supply some "FOR XML" clause, "FOR XML AUTO" being the simplest. Enter in the field "WebDAV resource path for the result" the directory we created earlier, i.e. it should be /DAV/xmlt and add the name of the xmltemplate to which the result will be saved, for example: sql-template.xml So finally the value should be /DAV/xmlt/sql-template.xml .

Once the template has been saved we can test it. Point your browser at you newly created file, a URL similar to: http://host:port/DAV/xmlt/sql-template.xml :