Versions in DB ? - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

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

    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

    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

    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
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


Page 1 of 1 (4 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.