LiveReport that Lists all documents and attributes

Samantha_Whelan

I've been asked to create a report that will list all documents with the associated attributes. The documents will be pulled from a specific folder node and the category ID is the same on all documents. Has anyone created a report like this in MS SQL?

Appu_Nair

Obviously Livelink advanced search is not giving you what you are looking for is this why you want to write a LR.I would imagine if you set the scope to a folder and put the category correctly you would get that.First I will create a view of that particular category based on this articlehttps://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=3498953&objAction=ArticleView&viewType=1Then I will use this recent one by Bob(Good post),so that I now have a proc,udf given a folder will give me its childrenhttps://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=16729716&objAction=view&show=0Then you could do a simple join I beleive between the two tables.Maybe sombody is alreday doing this who would share the actual query.