'non-private, non-sharing roles'

def _get_npns_roles(self, trans):

    return trans.sa_session.query(trans.app.model.Role).filter(and_((self.model.Role.table.c.deleted == false()), (self.model.Role.table.c.type != self.model.Role.types.PRIVATE), (self.model.Role.table.c.type != self.model.Role.types.SHARING))).order_by(self.model.Role.table.c.name)
