LiveReports on Forms Values without SQL Table

Philip_Schneider_(x-kpmgbe011_-_(deleted))

Hello, I created a Workflow with a short form template.I have not used the sql strorage mechanism. Is there the possibility to query the form field values? I want to create a cklick-through sub report and I transmit the work ID but don´t find the LL tables containing the form field values.Thank you for any help.Veronika

Bhupinder_Singh

Message from Bhupinder Singh via eLinkThe short answer is "No, not possible". In tracking down the form data entered, on my Livelink instance using External Storage, the data was stored in .dat files, andwithin the files it was stored as an assoc, i.e. for form data "Oranges" and "123" it appeared as:A<1,?,2=A<1,?,'ID'=2,'Values'={'Oranges'}>,3=A<1,?,'ID'=3,'Values'={123}>>If you are using internal storage, the form data is stored in a binary format in the BlobData table. An example is shown below:If a customer, with Livelink configured for internal storage, has stored form data via the submission mechanism of Livelinkversions, would it be possible to write a LiveReport to retrieve this information? You can't write reports on form data stored inthe BLOBData table, since it stores the form data in a binary format which is not readable using SQL. Using a Livelink instance withinternal storage (Livelink 9.0.0.1 in this case), 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 Livelink Versions 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 of the browser to determine what the objID (object ID, ordata ID) of the form was. In this case the object ID was 1150801.Next I queried the database to trace where the exactly the data is stored in the BLOBData table. This requires first querying theProviderData table as follows for each of the 2 form versions:SELECT providerData FROM ProviderData WHERE (providerID IN (SELECT providerid FROM dversdata WHERE docid = 150801 AND version = 1))Results of above query:PROVIDERDATA 150804 150807 SELECT providerData FROM ProviderData WHERE (providerID IN (SELECT providerid FROM dversdata WHERE docid = 150801 AND version = 2))Results of above query:PROVIDERDATA 150810 150813 Next, using the ProviderData data obtained from the above queries, check the BLOBData 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. Senior Product Specialist, Customer Support Open Text Corporation, Waterloo, Ontario, Canada Customer support e-mail: support@opentext.com Customer Support Telephone: 800-540-7292 ------------------------------------------------------------------------- -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Wednesday, April 14, 2004 9:18 AMTo: eLink RecipientSubject: LiveReports on Forms Values without SQL TableLiveReports on Forms Values without SQL TablePosted by Schneider, Philip on 04/14/2004 09:15 AMHello, I created a Workflow with a short form template.I have not used the sql strorage mechanism. Is there the possibility to query the form field values? I want to create acklick-through sub report and I transmit the work ID but don´t find the LL tables containing the form field values.Thank you for any help.Veronika[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