@Override protected void executeQueryCommand() { List<VmTemplate> vmTemplateList = getDbFacade().getVmTemplateDao().getAllForNetwork(getParameters().getId()); List<VmNetworkInterface> vmNetworkInterfaceList = getDbFacade() .getVmNetworkInterfaceDao() .getAllForTemplatesByNetwork(getParameters().getId()); final Map<Guid, VmTemplate> vmTemplatesById = Entities.businessEntitiesById(vmTemplateList); List<PairQueryable<VmNetworkInterface, VmTemplate>> vmInterfaceVmPairs = new ArrayList<PairQueryable<VmNetworkInterface, VmTemplate>>(); for (VmNetworkInterface vmNetworkInterface : vmNetworkInterfaceList) { vmInterfaceVmPairs.add( new PairQueryable<VmNetworkInterface, VmTemplate>( vmNetworkInterface, vmTemplatesById.get(vmNetworkInterface.getVmTemplateId()))); } getQueryReturnValue().setReturnValue(vmInterfaceVmPairs); }