Content Script: Retrive information

def node = docman.getNode(2000, //NodeID (on most of the environments 2000 identifies the Enterprise Workspace)
                      true, //'true' if Reference information shall be loaded
                      true, //'true' if Reservation information shall be loaeded
                      true, //'true' if Versions information shall be loaeded
                      true, //-true- if Current Version  shall be loaeded
                      true, //'true' if Node's features shall be loaeded
                      true, //'true' if Metadata  shall be loaeded
                      true, //'true' if Permissions information shall be loaeded
                     )

node = docman.getNode(2000) //this is a shortcut for docman.getNode(2000, true, true, false, false, true, true, true) (loads the node without its versions)

node = docman.getNodeFast(2000) //this is a shortcut for docman.getNode(2000, false, false, false, false, false, false, false) (loads just the base node's information)

node = asCSNode(id:2000) //this is a shortcut for docman.getNode(2000)

node = asCSNode(2000)//this is a shortcut for asCSNode(id:2000)

docman.getNodesFastWith(
                        [2000L, 2006L], // List of nodes IDs
                        ["GIF", "promotedCmds", "defaultLink", "size", "tableName"], // List of additional features to retrive
                        params, //Current request parameters
                        true, //'true' if Versions information shall be loaeded
                        true, //'true' if Node's features shall be loaeded
                        true //'true' if Permissions information shall be loaeded
                       )

docman.getNodesFast(2000L, 2006L) //this is a shortcut for docman.getNodesFastWith([2000L,2006L], [], [:], false, false, false)

docman.getNodes(2000L, 2006L) //this is a shortcut for docman.getNodesFastWith([2000L, 2006L], [], [:], true, true, true)

docman.getEnterpriseWS() //Enterprise Workspace

docman.getPersonalWS()   //Personal Workspace

docman.getCategoryWS()   //Category Workspace

docman.getContentScriptVolume() //Content Script Volume

/*
 161 -- Workflow Volume    
 198 -- Classification Volume
 211 -- Reports Volume
 233 -- Database Lookups
 236 -- Database Connections
 274 -- Best Bets
 405 -- Recycle Bin
 541 -- Content Server Templates
 862 -- Connected Workspaces
 863 -- Workspace Types
*/

def node =  docman.getNodeFast(sql.runSQLFast("""Select "DataID" 
                  FROM DTree 
                  Where SubType = 161""", false, false, 0
              ).rows[0].DataID)

def ews = docman.getEnterpriseWS()

node = docman.getNodeByPath(ews, "Training:Folder")

node = docman.getNodeByPath( "Training:Folder") //this is a shortcut for docman.getNodeByPath(docman.getEnterpriseWS(), "Training:Folder")

node = asCSNode(path:"Training:Folder")//this is a shortcut for docman.getNodeByPath("Training:Folder")

def user = users.current // Will return CSUser object of the user that is executing the script

CSMember member

// Pass User or Group by ID. Method will return CSUser or CSGroup class objects

//Pass ID of the Content Server User
member = users.getMemberById(1000) 
out << member instanceof CSUserImpl // will display true

//Pass ID of the Content Server User
member = users.getMemberById(1001) 
out << ( member instanceof CSGroupImpl ) // will return true

//Get User by ID
member = users.getUserById(1000) // will return CSUser class object

//Get group by ID
member = users.getGroupById(1001) // will return CSGroup class object

CSMember member

//Get Member using User Login Name
member = users.getMemberByLoginName("Admin") // Will return CSUser class object

//Get Member using Group Name
member = users.getMemberByLoginName("DefaultGroup") // Will return CSGroup class object

//Get User by UserName
member = users.getUserByLoginName("Admin")

//Get Group by Name
member = users.getGroupByName("DefaultGroup")

def members

//Get by IDs
members = users.getMembersByID(1000,1001)

//members[0] - is object of CSUser class
//members[1] - is object of CSGroup class

CSNode node = asCSNode(33561)
//Node permissions can be retrieved either
//calling CSNode getRigths() method
CSNodeRights nodeRights = node.getRights()

//or by calling docman method and passing node as an attribute
nodeRights = docman.getRights(node)

//To get Owner Permissions
out << nodeRights.ownerRight.permissions

//To get Assignemt Permissions Users with their permissions
def assignedAccessUsers = [:]

nodeRights.ACLRights.each{ right ->
    def currUser = users.getMemberById(right.rightID);
    assignedAccessUsers[currUser.name] = right.permissions
}

out << assignedAccessUsers

CSNode node = asCSNode(33561)

out << node.hasDeletePermission() //will return TRUE if current user has Delete pemissions on a node

def category = docman.getCategory(self.parent, "User Info") // Object of type CSCategory

def attributesMap = category.getAttributes() // Get map with Category Attributes

def firstNameAttr = category.getAttribute(attributesMap[2 as Long]) // get definition of the attribute with ID 2 CSCategoryAttribute

out <<  "Attribute ${firstNameAttr.getDisplayName()} has default value set to: ${firstNameAttr.values()}" // get default value for the attribue

def node = docman.getNodeByName(self.parent, "Folder With Categoty")

//Get Attribute value
def attrValue = node."User Info"."First Name" as String
out << "The current value of First Name is now ${attrValue} <br/>"

//get first attribute value
attrValue = node."User Info".Phone
out << "Get first Phone attribute value ${attrValue} <br/>"

//get all attribute values
attrValue = node."User Info".Phone as List
out << "Get all Phone attribute values ${attrValue} <br/>"

out << node."User Info" as Map

def node = docman.getNodeByName( self.parent, "Test Folder")

//Check if Classification can be applied to the node
out << "Classification can be applied to a node: ${classification.isClassifiable(node)}"
out << "<br>"

//List classifialbe subtypes
out << "Classification can be applied to following node subtypes:"
out << "<br>"
out << classification.listClassifiebleSubTypes()

def node = docman.getNodeByName( self.parent, "Test Folder")

// get node classifications
def classifications = classification.getClassifications(node)

//Will return list of classifications applied to a node
out << classifications.collect { it.name }

out << sql.runSQL("""select * from DTree where %1 and ParentID = %2 and ModifyDate > %3""", //SQL Code to be executed
           true, // true if the query must be executed using a cursor
           true, // true if the query must be wrapped in a transaction (required administrative privilagies)
           10,   // numer of records to be returned

                              // Below the list of optional parameters
           "#FilterObject:0", // Parameters can be a LiveReport query template expression
           2000,              // Integers
           1.year.ago).rows   // Dates
                              // Strings 

def sqlProjections = "DataID, Name" 
def fromClause = "DTree dt"
def whereClause = "SubType = 0"
def pageSize = 5
def transaction = true

def runPaginatedQuery = { firstRow ->

    def sqlResult = sql.runPaginatedSql(sqlProjections, fromClause, whereClause, firstRow, pageSize, "dt", "DataID", "ASC", transaction)

    out << "<br>"
    out << "Start row ${firstRow}"
    sqlResult.rows.each { row ->
        out << "<br>"   
        out << "Folder Name: ${row.name}. Name: ${row.dataid}"
    }
}

runPaginatedQuery(1)
runPaginatedQuery(6)

def formNode = docman.getNodeByName(self.parent, "User Info Form") //returns a CSFormImpl node
def submittedData = formNode.listFormData()

    //List sumbitted data
    //Access Form fields
    submittedData.each {form ->
        out << "User ${form.firstName[0]} ${form.lastName as String}. Age ${form.age as String}"
        out << "<br>"
    }

    out << "List Form data as a Map <br>"

    //List all form Records as a Map
    submittedData.each {form ->
        out << "<br>"
        out << "${forms.formToMap(form)}"
    }