Livereport on all available category and attributes in each folder

Lucy_Nikitina

Hello,

I need to report on all category and attributes available per each folder in our system. Is it possible to create a livereport in this format?

Folder	Sub-Folder	Attribute name	Attribute type	Required	Multi-valued	Valid values
Folder Name	Sub-Folder Name	Document Type	Text: Popup	Yes	No	Value 1, Value 2, Value 3, Value 4

So far I've joined CatRegionMap,DTree,LLAttrData, DTree d1, DTree d2, DTree d3 on

dtree.DataID=LLAttrData.ID

and dtree.VersionNum = LLAttrData.VerNum

and LLAttrData.DefID=CatRegionMap.CatID

and Dtree.SubType=0

I've been able to pick up folders/categories but am getting stuck on available attributes and their types. Especially since multiple values may be selected, and there are some using DB lookups. Any suggestions would be appreciated if anyone has done something similiar..

Thank you

Lucy

 

 

 

 

Colin_Schmidt

Here are two sets  of LRs.  One has a “main” that lists all Categories with a link to the SubLR that lists the Attributes and their type.

The second is one that lists out the Attributes of a single object ID regardless of the type of data or Attribute Type.  You could modify it to fit your needs.

 

Colin J. Schmidt

 

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, July 28, 2017 11:53 AM
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: Livereport on all available category and attributes in each folder

 

Livereport on all available category and attributes in each folder

Posted by Nikitina, Lucy On 07/28/2017 11:51 AM

 

Hello, I need to report on all category and attributes available per each folder in our system. Is it possible to create a livereport in this format? Folder Sub-Folder Attribute name Attribute type Required Multi-valued Valid values Folder Name Sub-Folder Name Document Type Text: Popup Yes No Value 1, Value 2, Value 3, Value 4 So far I've joined CatRegionMap,DTree,LLAttrData, DTree d1, DTree d2, DTree d3 on dtree.DataID=LLAttrData.ID and dtree.VersionNum= LLAttrData.VerNum and LLAttrData.DefID=CatRegionMap.CatID and Dtree.SubType=0 I've been able to pick up folders/categories but am getting stuck on available attributes and their types. Especially since multiple values may be selected, and there are some using DB lookups. Any suggestions would be appreciated if anyone has done something similiar.. Thank you Lucy

---

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center CS16

 

---

The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.

Cats-n-their-Atts_LiveReport.rpt

Atts-of-Doc_LiveReport.rpt