Creating reports for data stored usinf Livelink Versions..

Hello,I am creating a form and will be storing the data using Livelink versions on SQL Table.The reason for this is because I need to have the ability to add dynamic rows to my form. This feature is currently not working with SQL table and only works when storage is Livelink versions..I've found out that this method of storage stoes data in the LL_Blob data tables??Is there any way of creating reports for data stored this way??Please let me know if anyone is able to help!Thanks,Asha

Find more posts tagged with

Comments

Bhupinder_Singh

Message from Bhupinder Singh via eLinkIf a customer has stored form data via the submission mechanism of Livelinkversions, would it be possible to write a LiveReport to retrieve thisinformation?A short answer to your question is "You can't write reports on form datastored in the BLOBData table, since it stores the form data in a binaryformat which is not readable using SQL". A more detailed explanation of thisis provided below:Using a Livelink instance with External Storage (Livelink 9.0.0.1 in thiscase), here is what I did:1. Created a form template with 2 fields (text and integer)2. Created a form based on the template with Revision mechanism of LivelinkVersions and Submission mechanism of None.3. Filled out the form twice.4. Placed the mouse over the original form and looked at the status bar ofthe browser to determine what the objID (object ID, or data ID) of the formwas. In this case the object ID was 1150801.Next I queried the database to trace where the exactly the data is stored inthe BLOBData table. This requires first querying the ProviderData table asfollows for each of the 2 form versions:SELECT providerData FROM ProviderData WHERE (providerID IN (SELECTproviderid FROM dversdata WHERE docid = 150801 AND version = 1))Results of above query:PROVIDERDATA150804150807Results of above query:SELECT providerData FROM ProviderData WHERE (providerID IN (SELECTproviderid FROM dversdata WHERE docid = 150801 AND version = 2))PROVIDERDATA150810150813Next, using the ProviderData data obtained from the above queries, check theBLOBData table to see what it contains:SELECT * FROM BlobData WHERE LongID in (150802, 150805, 150808, 150811) OWNERID LONGID SEGMENTID SEGMENT 0 150813 0 [feff03000200000000000000ffff02003100] 0 150810 0[feff03000200000000000000ffff9500413c312c3f2c27446174614173736f63273d413c312c3f2c274944273d312c2756616c756573273d7b413c312c3f2c323d413c312c3f2c274944273d322c2756616c756573273d7b274261726e657920527562626c65277d3e2c333d413c312c3f2c274944273d332c2756616c756573273d7b393837367d3e3e7d3e2c274c4c5f54656d706c61746556657273696f6e273d313e00] 0 150807 0 [feff03000200000000000000ffff02003100] 0 150804 0[feff03000200000000000000ffff9700413c312c3f2c27446174614173736f63273d413c312c3f2c274944273d312c2756616c756573273d7b413c312c3f2c323d413c312c3f2c274944273d322c2756616c756573273d7b274672656420466c696e7473746f6e277d3e2c333d413c312c3f2c274944273d332c2756616c756573273d7b36373839307d3e3e7d3e2c274c4c5f54656d706c61746556657273696f6e273d313e00]So, as you can see, the SEGMENT column which contains the actual form data,is not very conducive to reporting...- Bhupinder-------------------------------------------------------------------------Bhupinder Singh, B.Math., B.Ed. Customer SupportOpen Text Corporation Waterloo, Ontario, CanadaCustomer support e-mail: support@opentext.comCustomer Support Telephone: 800-540-7292------------------------------------------------------------------------------Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Sunday, December 07, 2003 6:23 PMTo: eLink RecipientSubject: Creating reports for data stored usinf Livelink Versions..Creating reports for data stored usinf Livelink Versions..Posted by DeloitteAdmin on 12/07/2003 05:30 PMHello,I am creating a form and will be storing the data using Livelink versions onSQL Table.The reason for this is because I need to have the ability to add dynamicrows to my form. This feature is currently not working with SQL table andonly works when storage is Livelink versions..I've found out that this method of storage stoes data in the LL_Blob datatables??Is there any way of creating reports for data stored this way??Please let me know if anyone is able to help!Thanks,Asha[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe