0 Replies Latest reply on Jun 23, 2016 10:08 PM by MisterPB

    Testing for Deleted Files in portal.wwdoc_document$

    MisterPB

      Hello everyone

       

      I have been asked to put together a page that lists the number of uploaded files and the space they occupy within a page and its sub-pages.  The query is written but I am still not absolutely clear how I should constrain it to show only files that are not in a Deleted state.

       

      IS_MARKED_FOR_DELETE=1 in portal.wwdoc_document$ seemed a likely first candidate, but seemingly only lists those files that are awaiting a Purge.

       

      So I suppose my question is how I'd pick up files that are deleted but not purged.  I am planning to embed this in an Application Express report for ad-hoc access so I can't depend upon a Purge being pending.

       

      Testing seems to suggest that a deleted file has DAV_ID = -1 (and gets a value > 1 when I Undelete) but is this the best test I can use?  Would IS_ACTIVE be a better choice?

       

      Any pointers/suggestions will be appreciated.

       

      PB