in

InfoPath Dev

Versions in DB ?

Last post 06-24-2008 02:01 PM by ErnestoM. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 06-19-2008 07:45 AM

    Versions in DB ?

      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

  • 06-19-2008 08:46 AM In reply to

    Re: Versions in DB ?

    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.

     

  • 06-19-2008 08:55 AM In reply to

    Re: Versions in DB ?

    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

  • 06-24-2008 02:01 PM In reply to

    Re: Versions in DB ?

    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.

    Ernesto Machado / Software Test and Support Manager
    Qdabra® Software / Streamline data gathering to turn process into knowledge
    Filed under: ,
Page 1 of 1 (4 items)
Copyright © 2003-2007 Qdabra Software. All rights reserved.
View our Terms of Use.