Qdabra Database Accelerator

Re: Versions in DB ?

ErnestoM — Tue, 24 Jun 2008 21:01:46 GMT

Only the latest version of the document will be shredded into the database, but the previous versions will be stored by DBXL.

By entering the URL of the DBXL DocHandler
http://<servername:port>/QdabraWebService/documents/<docid>/<docid>.xml
you can open the latest version of the document for that DocID.

But because you have enabled history for this Document Type, you can get the previous versions of this document.

To get one version before the latest version use the following URL:
http://<servername:port>/Qdabrawebservice/Documents/<DocID>v-1/<DocID>v-1.xml.
The URL would be the same as before, other than the text v-1 added after both occurrences of DocID.

If you want to get the second to last version of the document, then the URL would be http://<servername:port>/Qdabrawebservice/Documents/<DocID>v-2/<DocID>v-2.xml

And so on.

In addition, if you know the specific version number that you seek, you can specify the URL as
http://<servername:port>/Qdabrawebservice/Documents/<DocID>v<x>/<DocID>v<x>.xml
where <x> is the version of the document.

Re: Versions in DB ?

Catharine — Thu, 19 Jun 2008 15:55:50 GMT

I have ENABLE History ticked and have saved the catalogue item. I have created a document and changed it so I am now on version 3 – when I open the DBXL Document table there is only the latest version listed in the table .

When you say it will preserve each version - does that mean that when a new version is created the data should be shredded to my DB in addition to the old data ? - so if I am shredding to one table and am at v3 of document I should have 3 records in my DB table?

Catharine

Re: Versions in DB ?

Clay Fox — Thu, 19 Jun 2008 15:46:47 GMT

You can turn on Document History with the check box on the general tab in DAT.

This will preserve each version not just the latest.

Versions in DB ?

Catharine — Thu, 19 Jun 2008 14:45:13 GMT

I am assuming that only the content of the latest version of the InfoPath document is stored in the Database – is that correct ?

Thanks

Catharine