Folders and RM Classifications

Alison_Bilton_(habis_-_(deleted))

I'm wanting to build a LiveReport to give me a list of folders whose RM classification name is not the same as the folder name. I can get a list of folders or a list of RM classifications from DTree but where does it tell me what classifications are attached to what folders?Thanks

Dan_Friend

You should be able to get that information from the rimsnodeclassificaton table. The nodeid in rimsnodeclassificaton table relates to the dataid in the dtree table. You should be able to get a list of items with those two tables. Maybe using a UNION query or a MINUS(if you're using Oracle).And if you need to join the rimsnodeclassificaton table to rm_classification table the classid relates to the nodeid column, respectively.Hope that helps.