Looking for some help ... Finding any Locked Elements in a database’s design

March 25 2007

So I am looking for some help. I am looking for a piece of code/database, where I can point it at another database or template, and have it report all locked design elements. It would be preferrable to have it list them by locked by person and design element type and name.

Anyone have any code lying around that does this? Sounds like a great OpenNTF.org project :-)

3 Responses to “Looking for some help ... Finding any Locked Elements in a database’s design”

  1. 1) Tim Tripcony says:

    I don't have (or know of) any existing code that does this, but I can perhaps nudge you in the right direction: the NotesNoteCollection has a SelectAllDesignElements method and a SelectionFormula property. If you initialize the collection with a parameter of False (to initially select nothing), then call SelectAllDesignElements with a SelectionFormula of "@IsAvailable($Writers)", that should set the collection to contain all locked design elements in the database/template. You can then loop through the collection, getting a handle on each as a NotesDocument object and glean any info you wish to report (i.e. NoteID, UniversalID, $TITLE, etc.). Hope that helps...

  2. 2) John Head says:

    thanks for the reply Tim ... I will see what I can come up with and post what I find

  3. 3) Jean-Yves says:

    A good function to work with

    { Link }

    JYR

Leave a Reply