List of All Category ID

I need to retrive all the Category ID existing in livelink system. I am not able to get any function which will give me that list. Can anyone please help me on that?

Find more posts tagged with

Comments

Kyle_Swidrovich

Quoted sunitha_iyer@infosys.com on 11/08/2011 11:19 AM:

I need to retrive all the Category ID existing in livelink system. I am not able to get any function which will give me that list. Can anyone please help me on that?

There's no one function that directly provides that list, however, you could create a LiveReport in Livelink that queries for all items with SubType=131 (a category) then use LAPI to call that LiveReport.

Regards,
Kyle

Sunitha_Iyer

Can you tell me which function can provide me that information instead of live report?

Kyle_Swidrovich

Quoted sunitha_iyer@infosys.com on 11/08/2011 01:21 PM:

Can you tell me which function can provide me that information instead of live report?

As I mentioned earlier, there's no one function that directly provides that list.

Sunitha_Iyer

ops, sorry i skipped NO :P

Colin_Schmidt

Here is the SQL of a LR that lets you browse to a container and it will dump out the Categories and values. Maybe you can modify it to fit your needs should you want a lot of detail.

select dt1.parentid, dt3.name "Parent Folder", dt1.dataid, dt1.name "Folder", llad1.valstr "Category", llad1.defid, NVL(crm.attrname, llad2.valstr) "Attribute name", llad2.attrid "AttrID", case when llad2.attrtype=-18 then 'Category: ['||llad2.valstr||']' when llad2.attrtype=-4 then '{'||to_char(llad2.attrtype)||'}'||to_char(llad2.valreal) when llad2.attrtype=-1 then '{'||to_char(llad2.attrtype)||'}'||llad2.valstr when llad2.attrtype=2 then '{'||to_char(llad2.attrtype)||'}'||to_char(llad2.valint) when llad2.attrtype=5 and llad2.valint=0 then '{'||to_char(llad2.attrtype)||'}'||'False' when llad2.attrtype=5 and llad2.valint=1 then '{'||to_char(llad2.attrtype)||'}'||'True' when llad2.attrtype=5 and llad2.valint is NULL then '{'||to_char(llad2.attrtype)||'}'||'n/a' when llad2.attrtype=10 then '{'||to_char(llad2.attrtype)||'}'||llad2.valstr when llad2.attrtype=12 then '{'||to_char(llad2.attrtype)||'}'||to_char(llad2.valint) when llad2.attrtype=14 then '{'||to_char(llad2.attrtype)||'} User ['||to_char(llad2.valint)||' ]'||k.name when llad2.attrtype=10013 then '{'||to_char(llad2.attrtype)||'}'||llad2.valstr else 'Other AttrType ['||to_char(llad2.attrtype)||']' end AttributeValue from livelink.llattrdata llad1 left outer join livelink.dtree dt1 on llad1.id=dt1.dataid and dt1.subtype=0 left outer join livelink.dtree dt2 on llad1.defid=dt2.dataid left outer join livelink.dtree dt3 on dt1.parentid=dt3.dataid left outer join livelink.llattrdata llad2 on llad1.id=llad2.id and dt2.dataid=llad2.defid join livelink.catregionmap crm on crm.catid=llad2.defid and crm.regionname='Attr_'||llad2.defid||'_'||llad2.attrid left outer join livelink.kuaf k on llad2.valint=k.id where llad1.id in (select dt4.dataid from livelink.dtree dt4 where dt4.parentid=%1) and llad1.attrtype=-18 and llad1.parentkeyid=-1 order by dt1.name, llad2.defid, llad2.attrid

Abdulrahman_Murad

How can I update the Category values of pdf document using a webservice?