Which items in a slice are missing a category?

Marcia_Gillespie-Norder_(tokeleuser7_-_(deleted))

Howdy,We have a folder that has hundreds of subfolders and thousands of documents. In an effort to clean up some legacy stuff, we're trying to find out how many documents under this folder are missing the category they're supposed to have.We have a slice set up for this folder.What we'd like to do is write a LiveReport that will tell us which documents from that slice are missing the category.This sounds great in English, but we're having trouble putting this into SQL terms. In the past, we've been able to walk down a folder structure in a LiveReport using a recursive query that uses 'connect by' to string together parent ids, but that is unfortunately too cumbersome to use with this folder because of the size.Has anyone done this? Does anyone have some SQL to share, or some ideas on how to pull this off?We're on 9.1 SP3, using Oracle.Thanks and best regards,Marcia A. NorderTokyo Electron America.