@Override @DB public List<VMInstanceVO> listByStoragePool(long storagePoolId) { SearchCriteria<VMInstanceVO> sc = StoragePoolSearch.create(); sc.setJoinParameters("vmVolume", "volumeType", Volume.Type.ROOT); sc.setJoinParameters("vmVolume", "poolId", storagePoolId); sc.setJoinParameters("vmVolume", "state", Volume.State.Ready); return _vmInstanceDao.search(sc, null); }
sc.addAnd("templateId", SearchCriteria.Op.EQ, id); sc.addAnd("state", SearchCriteria.Op.NEQ, State.Expunging); List<VMInstanceVO> vms = _vmInstanceDao.search(sc, null); if (vms != null && !vms.isEmpty()) { for (VMInstanceVO vm: vms) {