CS10 Livereport - Document Metadata

Jaswinder_Davies

I would like to either write a LiveReport or a SQL query to identify the metadata for all the documents in a folder.  We have 26 folders from A-Z and a category called the “Landlord Services” category is applied to these folders.  So I would like to run the report for each folder.  The metadata contained in the category is as below:

 

 

Colin_Schmidt

There should be some attached in this Forum.

 

It’s a connection between the DTREECORE and LLATTRDATA.  The CATREGIONMAP can be used for Category names, as well, in the list.  Is this Oracle or SQL Server?  Do you want to list all values for all of the Folders or just a selected Folder?

 

DTREECORE.dataid = LLATTRDATA.ID and DTREECORE.Versionnum = LLATTRDATA.Vernum

 

LLATTRDATA.DefID = CATREGIONMAP.CatID   and CATREGIONMAP.Catname gives the name of the Category and CATREGIONMAP.Attrname gives you the name of the Attribute.

 

Then you need to know which attributes are Dates, Integer, String, etc.  Those values should also be an attachment in the Forum somewhere(not an OT contribution or tech article).

 

Colin J. Schmidt

Knowledgelink Support

CapitalOne | Collaboration Technology

 

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, August 02, 2016 7:04 AM
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: CS10 Livereport - Document Metadata

 

CS10 Livereport - Document Metadata

Posted by Davies, Jaswinder On 08/02/2016 06:57 AM

 

I would like to either write a LiveReport or a SQL query to identify the metadata for all the documents in a folder.  We have 26 folders from A-Z and a category called the “Landlord Services” category is applied to these folders.  So I would like to run the report for each folder.  The metadata contained in the category is as below:

---

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

 

---

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.