Live Report to list objects without a Classification

Fiona_Foster

I'm looking for some assistance on how to create a livereport that would allow us to see if there any objects which DO NOT have a classification applied.

The report would need to use SQL

Has anyone created such a report?  Any help would be greatly appreciated.  Thanks!

eLink User

Classifications come in two flavo(u)rs  Regular(199) or RM(551)?

These are all your RM Classified Objects in Livelink

select NODEID,CLASSID,RSI from RM_MULTICLASS;

select dataid from dtreecore or dtree ; is all your objects

However classifications can only be applied to certain objects so you would eliminate the others

So assuming an organization is RM Classifying the document subtype(144) you can write

select dataid from dtree where subtype=144

    MINUS

select NODEID from RM_MULTICLASS;

Those are your documents that do not have RM classifications.

I have used SQL for the above but I don't know if you mean provide a query for Microsoft SQLserver

.....appu appnair appunair

Well, if I called the wrongnumber, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937 

On Thu, Feb 11, 2016 at 9:50 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Live Report to list objects without a Classification

Posted byFoster, FionaOn 02/11/2016 10:49 AM

I'm looking for some assistance on how to create a livereport that would allow us to see if there any objects which DO NOT have a classification applied.The report would need to use SQLHas anyone created such a report?  Any help would be greatly appreciated.  Thanks!

---

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