kernel/classes/eznodeassignment.php
static function fetchChildListByVersionStatus( $parentNodeIDList, $status = eZContentObjectVersion::STATUS_PENDING, $asObject = true )
    {
        $db = eZDB::instance();
        $parentIDStatement = $db->generateSQLINStatement( $parentNodeIDList );

        $sql = "SELECT DISTINCT eznode_assignment.*
                FROM ezcontentobject_version, eznode_assignment
                WHERE ezcontentobject_version.contentobject_id = eznode_assignment.contentobject_id
                AND ezcontentobject_version.version = eznode_assignment.contentobject_version
                AND ezcontentobject_version.status = $status
                AND eznode_assignment.parent_node $parentIDStatement
                ORDER BY eznode_assignment.contentobject_id";
        $nodeAssignmentArray = $db->arrayQuery( $sql );
        if( $asObject )
        {
            $result = array();
            foreach( $nodeAssignmentArray as $nodeAssignment )
            {
                $result[] = new eZNodeAssignment( $nodeAssignment );
            }
            return $result;
        }
        else
        {
            return $nodeAssignmentArray;
        }
    }
static function fetchChildListByVersionStatus( $parentNodeIDList, $status = eZContentObjectVersion::STATUS_PENDING, $asObject = true )
    {
        $db = eZDB::instance();
        $parentIDStatement = $db->generateSQLINStatement( $parentNodeIDList );

        $sql = "SELECT DISTINCT eznode_assignment.*
                FROM ezcontentobject_version, eznode_assignment
                WHERE ezcontentobject_version.contentobject_id = eznode_assignment.contentobject_id
                AND ezcontentobject_version.version = eznode_assignment.contentobject_version
                AND ezcontentobject_version.status = $status
                AND eznode_assignment.parent_node $parentIDStatement
                ORDER BY eznode_assignment.contentobject_id";
        $nodeAssignmentArray = $db->arrayQuery( $sql );
        if( $asObject )
        {
            $result = array();
            foreach( $nodeAssignmentArray as $nodeAssignment )
            {
                $result[] = new eZNodeAssignment( $nodeAssignment );
            }
            return $result;
        }
        else
        {
            return $nodeAssignmentArray;
        }
    }
static function fetchChildListByVersionStatus ( $ parentNodeIDList , $ status = eZContentObjectVersion :: STATUS_PENDING , $ asObject = true ) { $ db = eZDB :: instance ( ) ; $ parentIDStatement = $ db -> generateSQLINStatement ( $ parentNodeIDList ) ; $ sql = "SELECT DISTINCT eznode_assignment.*
                FROM ezcontentobject_version, eznode_assignment
                WHERE ezcontentobject_version.contentobject_id = eznode_assignment.contentobject_id
                AND ezcontentobject_version.version = eznode_assignment.contentobject_version
                AND ezcontentobject_version.status = $status
                AND eznode_assignment.parent_node $parentIDStatement
                ORDER BY eznode_assignment.contentobject_id" ; $ nodeAssignmentArray = $ db -> arrayQuery ( $ sql ) ; if ( $ asObject ) { $ result = array ( ) ; foreach ( $ nodeAssignmentArray as $ nodeAssignment ) { $ result [ ] = new eZNodeAssignment ( $ nodeAssignment ) ; } return $ result ; } else { return $ nodeAssignmentArray ; } }
Fetch node assignment list by version status, giving parent node id list.

@param array $idList node id array
@param int $status status of the object version
@param boolean $count
@param boolean $asObject valid only when $count is false
@return array|int
Fetch node assignment list by version status giving parent node id list .