/** * Creates a copy of this Query instance. */ public Query copy() { Query query = new Query(queryString); query.parameters.putAll(parameters); query.firstResult = firstResult; query.maxResults = maxResults; query.cacheable = cacheable; return query; }
LoadContext.Query query = new LoadContext.Query(queryStr); loadCtx.setQuery(query); if (firstResult != null)
LoadContext.Query query = new LoadContext.Query(queryString); if (limit != null) { query.setMaxResults(limit);
LoadContext.Query query = new LoadContext.Query(queryRequest.getQuery());
LoadContext.Query query = new LoadContext.Query(queryInfo.getJpql());
@Override public void actionPerform(Component component) { if (!isEnabled()) { return; } ReportGroup group = (ReportGroup) target.getSingleSelected(); if (group != null) { if (group.getSystemFlag()) { showNotification(getMessage("unableToDeleteSystemReportGroup"), NotificationType.WARNING); } else { LoadContext<Report> loadContext = new LoadContext<>(Report.class); loadContext.setView("report.view"); LoadContext.Query query = new LoadContext.Query("select r from report$Report r where r.group.id = :groupId"); query.setMaxResults(1); query.setParameter("groupId", group.getId()); loadContext.setQuery(query); DataSupplier dataService = getDsContext().getDataSupplier(); Report report = dataService.load(loadContext); if (report != null) { showNotification(getMessage("unableToDeleteNotEmptyReportGroup"), NotificationType.WARNING); } else { super.actionPerform(component); } } } } }
protected void assignRoleUsers(Role role, Collection<User> items) { if (items == null) return; List<Entity> toCommit = new ArrayList<>(); for (User user : items) { LoadContext<UserRole> ctx = LoadContext.create(UserRole.class) .setView("user.edit") .setQuery(new LoadContext.Query("select ur from sec$UserRole ur where ur.user.id = :userId") .setParameter("userId", user.getId()) ); List<UserRole> userRoles = dataManager.loadList(ctx); boolean roleExist = false; for (UserRole userRole : userRoles) { if (role.equals(userRole.getRole())) { roleExist = true; break; } } if (!roleExist) { UserRole ur = metadata.create(UserRole.class); ur.setUser(user); ur.setRole(role); toCommit.add(ur); } } if (!toCommit.isEmpty()) { dataManager.commit(new CommitContext(toCommit)); } showNotification(getMessage("rolesAssigned.msg")); }
protected List<Entity> loadItemsWithDirectKey(LoadDescriptor ld) { LoadContext.Query query = new LoadContext.Query( String.format("select e from %s e where e.%s in :ids", ld.getMetaClass(), metadataTools.getPrimaryKeyName(ld.getMetaClass()))); List<Object> ids = ld.getSelectedItems().stream() .map(Entity::getId) .collect(Collectors.toList()); query.setParameter("ids", ids); LoadContext<Entity> lc = new LoadContext<>(ld.getMetaClass()); lc.setSoftDeletion(false); lc.setQuery(query); lc.setView(ld.getView()); lc.setLoadDynamicAttributes(ld.isLoadDynamicAttributes()); return dataManager.secure().loadList(lc); } }
protected User loadUser(UUID userId, User user) { if (user.getId().equals(userId)) return user; LoadContext loadContext = new LoadContext(UserSubstitution.class); LoadContext.Query query = new LoadContext.Query("select su from sec$UserSubstitution us join us.user u " + "join us.substitutedUser su where u.id = :id and su.id = :userId and " + "(us.endDate is null or us.endDate >= :currentDate) and (us.startDate is null or us.startDate <= :currentDate)"); query.setParameter("id", user.getId()); query.setParameter("userId", userId); query.setParameter("currentDate", timeSource.currentTimestamp()); loadContext.setQuery(query); List<User> users = dataService.loadList(loadContext); return users.isEmpty() ? null : users.get(0); }
protected List<ProcDefinition> getProcDefinitionsByName(String name) { LoadContext ctx = new LoadContext(ProcDefinition.class); ctx.setQuery(new LoadContext.Query("select pd from bpm$ProcDefinition pd where pd.name = :name") .setParameter("name", name)); return dataManager.loadList(ctx); }
/** * @param queryString JPQL query string. Only named parameters are supported. * @return query definition object */ @Override public Query setQueryString(String queryString) { final Query query = new Query(queryString); setQuery(query); return query; }
protected User loadUser(UUID userId) { LoadContext<User> loadContext = new LoadContext<>(User.class); LoadContext.Query query = new LoadContext.Query("select u from sec$User u where u.id = :userId"); query.setParameter("userId", userId); loadContext.setQuery(query); List<User> users = dataService.loadList(loadContext); return users.isEmpty() ? null : users.get(0); }
/** * Factory method to create a LoadContext.Query instance for passing into {@link #setQuery(Query)} method. * * @param queryString JPQL query string. Only named parameters are supported. */ public static LoadContext.Query createQuery(String queryString) { return new LoadContext.Query(queryString); }