how to retrive blobdata.segment for cetegory

[ujjval090683]

Hi,
How to retrive following kind of data from Livelink for Category.
Where this data is stored, how to retrive it?
Here's an example BlobData.segment:

A<1,?,'Children'={A<1,?,'Children'={A<1,?,'DisplayLen'=32,'DisplayName'='Text Field Attribute in Set','FixedRows'=true,'ID'=3,'Length'=32,'MaxRows'=1,'NumRows'=1,'Required'=false,'Search'=true,'Type'=-1>,A<1,?,'DisplayName'='Integer Popup Attribute in Set','FixedRows'=true,'ID'=4,'MaxRows'=1,'NumRows'=1,'Required'=false,'Search'=true,'Type'=12,'ValidValues'={1,2,3}>},'DisplayName'='Attribute Set 1','FixedRows'=false,'ID'=2,'MaxRows'=2,'NumRows'=1,'Type'=-

 

[ggriffit]

you will need to pull all of the segments together in the correct order and that will give you the datastructure which you can then interact with using standard Livelink OScript. If you are doing this outside LL then you will need to seperate out all the data correctly.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[ujjval090683]

Hi,
Can I retrivfe segment.blob information for cateogry using some query? which query will give me that result, also I am not familar with OScript, can you please guide me the steps to retrive this information from server?

I am looking for cateogry information including searchable\required\locked\etc.

 

[ggriffit]

Looking at the DB Schema, you can pull out by LONGID, which is the Version number and then order by SegmentID, only on Oracle, if you stitch them all together then you will have the complete set for a single version.

There are a few simple ways in OScript, but if you don't have the builder then you may be better off using LAPI / WebServices instead to get the information via a managed API.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[ujjval090683]

Hey thanks a ton for showing the way to retrive using schema. Can you please tell me from which table I need to retrive LONGID? and then orderby ver?

Can you please give some idea about those two queries? Since long I was waiting for this and so happy that finally I am going to get it thanks a lot.

 

[appnair]

I echo Greg's comments.Do you or can you get a hold of the lapi sdk. It is a windows executable that you put in your computer.Using its libraries you will be writing code in C#,Javd or VB.net and you will be able to locate and parse info of categories much easier.As it stands you are trying to re-invent the wheel by using only database retrieval methods as that part of code is not geared to be manipulated to anything user friendly or understandable by database tools. I can also expand my showwebnode oscript code that shows more stuff than attributes.dump which you chanced upon in the KB but that would mean that you have to install that module in your livelink server.using lapi it would be just a very simple affair.

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[ujjval090683]

Thanks a ton. lapi is really a good way, I tried my first Lapi program and I was able to retrive information for perticular category.

But................ THis program gives me information for given category ID. I am not able to retrive all the categoryh ID existing in Livelink using API. Using ?function=attributes.dump in URL I am able to retrive that, but using API how can I retrive all Category IDs? If I get list of CatID then my code will give me details of them easily.

 

[ujjval090683]

Thanks a ton. lapi is really a good way, I tried my first Lapi program and I was able to retrive information for perticular category.

But................ THis program gives me information for given category ID. I am not able to retrive all the categoryh ID existing in Livelink using API. Using ?function=attributes.dump in URL I am able to retrive that, but using API how can I retrive all Category IDs? If I get list of CatID then my code will give me details of them easily.

 

[appnair]

There is ono direct call to do that,however if you look atall my orginal postings a category object is subtype=131

so if you run this query select * from dtree where subtype=131 you will get all the dataid's.For each of the dataid's youu can them call FetchCategoryVersion and you will get the category definition.There is these method also FetchCategoryVersionXML which will look like proper xml

Here's some code I wrote several years how to run a livereport

http://greggriffiths.org/livelink/development/lapi/livereport/

if you search Greg's site or the KB you should find plenty of lapi samples that will show you how to do a FetchVersion


Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[ujjval090683]

Thanks.SO it is the combination of Query and LAPI function, no direct function from LAPI.
GOt it. I was actully thinking is any, but anyway, thanks for your reply.