Hi Pedro, Framework allow create dynamic query with paging, I not have sure if possible create QueryResult like you expect. I need to check it, give me time and I'll check it later. For now, I recommend using JPA Criteria API Support.
On Fri, Feb 26, 2016 at 4:34 AM, Pedro Belmino <[email protected]> wrote: > THAT'S IT. Daniel Cunha is right. It's very common that a screen that uses > paging is filled with dynamic filters. > So the framework allow not make a dynamic query with paging ? > > 2016-02-26 9:20 GMT-03:00 Daniel Cunha <[email protected]>: > > > I don't know why the javadoc is not published for last version. > > > > Someone can see that? > > > > On Fri, Feb 26, 2016 at 4:18 AM, Daniel Cunha <[email protected]> > > wrote: > > > > > If I get it, he want to use QueryResult to have easy way to navigate[1] > > on > > > pages. > > > I proposed that he use the Criteria API, but it not sound good for he. > > > > > > I don't know a > > > > > > [1] > > > > > > https://deltaspike.apache.org/javadoc/1.5.2/org/apache/deltaspike/data/api/QueryResult.html#nextPage() > > > > > > On Fri, Feb 26, 2016 at 4:13 AM, John D. Ament <[email protected]> > > > wrote: > > > > > >> Hi, > > >> > > >> Are you sure you need to return query result? Seems like you're > crossing > > >> boundaries. > > >> > > >> typedQuery("").setFirstResult(2).setMaxResults(4).getResultList() > > >> > > >> That should take care of the pagination for you. > > >> > > >> John > > >> > > >> On Fri, Feb 26, 2016 at 6:58 AM Pedro Belmino <[email protected] > > > > >> wrote: > > >> > > >> > Hi, > > >> > Daniel Cunha, > > >> > > > >> > I appreciate the support but this solution to make the logic in the > > >> > business layer is not viable for me , I would have to combine all > the > > >> > possible filters. > > >> > > > >> > I'm at that point, but still no solution. > > >> > public QueryResult<Person> > findByNameLikeIgnoreCaseAndAssigment(String > > >> > name, Assigment assigment, @FirstResult int start, @MaxResults int > > >> > pageSize){ String queryString = "select p "+ " FROM Person p " + > > "WHERE > > >> > p.name = :name and p.assigment = :assigment"; > javax.persistence.Query > > >> > query > > >> > = entityManager().createQuery(queryString); > query.setParameter("name", > > >> > name); query.setParameter("assigment", assigment); > QueryResult<Person> > > >> d = > > >> > new DefaultQueryResult<>(new QueryBuilder() { @Override protected > > Object > > >> > execute(CdiQueryInvocationContext ctx) { > > >> > ctx.applyJpaQueryPostProcessors(query); return > > ctx.executeQuery(query); > > >> } > > >> > }, cdiQueryContextHolder.get());// OCCURS NullPointerException > return > > >> d; } > > >> > > > >> > Can someone help me? > > >> > > > >> > 2016-02-25 15:11 GMT-03:00 Daniel Cunha <[email protected]>: > > >> > > > >> > > Hi Pedro, > > >> > > > > >> > > You can try that: > > >> > > > > >> > > > > >> > > > >> > > > https://github.com/apache/deltaspike/blob/master/deltaspike/modules/data/impl/src/test/java/org/apache/deltaspike/data/test/service/SimpleRepository.java#L103 > > >> > > > > >> > > > > >> > > > >> > > > https://github.com/apache/deltaspike/blob/master/deltaspike/modules/data/impl/src/test/java/org/apache/deltaspike/data/impl/QueryResultTest.java#L167 > > >> > > > > >> > > So, you'll create methods on your repository, something like: > > >> > > findByNameLikeIgnoreCase > > >> > > findByAssigment > > >> > > findByNameLikeIgnoreCaseAndAssigment > > >> > > > > >> > > > > >> > > So you can put your business logic on your business class. > > >> > > > > >> > > You'll call the method that you need: > > >> > > > > >> > > @Inject > > >> > > private RepositoryClass repository > > >> > > > > >> > > if (YOUR_LOGIC) > > >> > > repository.findByNameLikeIgnoreCaseAndAssigment > > >> > > ... > > >> > > > > >> > > To be honest, I don't know if possible to do like you was trying. > > >> > > I needed checking it. > > >> > > > > >> > > > > >> > > On Thu, Feb 25, 2016 at 2:04 PM, Pedro Belmino < > > >> [email protected]> > > >> > > wrote: > > >> > > > > >> > > > Daniel, > > >> > > > OK to return an object of type List<Person>. > > >> > > > > > >> > > > However i need return an QueryResult<Person>, because the > > >> pagination is > > >> > > > important for me. > > >> > > > > > >> > > > > > >> > > > > > >> > > > 2016-02-25 13:59 GMT-03:00 Daniel Cunha <[email protected]>: > > >> > > > > > >> > > > > Hi Pedro, > > >> > > > > > > >> > > > > JPA Criteria API Support sounds better for this cases: > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > http://deltaspike.apache.org/documentation/data.html#JPACriteriaAPISupport > > >> > > > > > > >> > > > > On Thu, Feb 25, 2016 at 1:50 PM, Pedro Belmino < > > >> > [email protected] > > >> > > > > > >> > > > > wrote: > > >> > > > > > > >> > > > > > Hello, > > >> > > > > > I need construct an method that receive dynamic parameters > for > > >> HQL > > >> > > > query > > >> > > > > > construct. > > >> > > > > > > > >> > > > > > For example: > > >> > > > > > @Repository(forEntity = Person.class) > > >> > > > > > public abstract class PersonCustomRepository extends > > >> > > > > > AbstractEntityRepository<Person, Long> { > > >> > > > > > > > >> > > > > > public QueryResult<Person> > > >> > > > > > findByNameLikeIgnoreCaseAndAssigment(String name, > > >> > > > > > Assigment assigment, @FirstResult int start, @MaxResults int > > >> > > pageSize){ > > >> > > > > > String query = "select p from person p WHERE 1 = 1 "; > > >> > > > > > if(name!=null&&!name.equals("")){ > > >> > > > > > query+= " and name = ?1 "; > > >> > > > > > } > > >> > > > > > if(assigment!=null){ > > >> > > > > > query+= " and assigment = ?2 "; > > >> > > > > > } > > >> > > > > > // WHAT IS NECESSARY CODE FOR RETURN paginated object of > type > > >> > > > > > QueryResult<Person>. > > >> > > > > > } > > >> > > > > > } > > >> > > > > > > > >> > > > > > I'm doing something wrong? I do otherwise? > > >> > > > > > > > >> > > > > > -- > > >> > > > > > > > >> > > > > > > > >> > > > > > > > >> > > > > > *Pedro Belmino *System Analist > > >> > > > > > Laboratory of Mobile Computing and Design > > >> > > > > > Federal University of Ceará > > >> > > > > > Office: + 55 85 3366-9797 > > >> > > > > > E-mail: [email protected] < > > >> [email protected]> > > >> > > > > > > > >> > > > > > > >> > > > > > > >> > > > > > > >> > > > > -- > > >> > > > > Daniel Cunha > > >> > > > > https://twitter.com/dvlc_ > > >> > > > > http://www.tomitribe.com > > >> > > > > > > >> > > > > > >> > > > > > >> > > > > > >> > > > -- > > >> > > > > > >> > > > > > >> > > > > > >> > > > *Pedro Belmino *System Analist > > >> > > > Laboratory of Mobile Computing and Design > > >> > > > Federal University of Ceará > > >> > > > Office: + 55 85 3366-9797 > > >> > > > E-mail: [email protected] < > [email protected] > > > > > >> > > > > > >> > > > > >> > > > > >> > > > > >> > > -- > > >> > > Daniel Cunha > > >> > > https://twitter.com/dvlc_ > > >> > > http://www.tomitribe.com > > >> > > > > >> > > > >> > > > >> > > > >> > -- > > >> > > > >> > > > >> > > > >> > *Pedro Belmino *System Analist > > >> > Laboratory of Mobile Computing and Design > > >> > Federal University of Ceará > > >> > Office: + 55 85 3366-9797 > > >> > E-mail: [email protected] <[email protected]> > > >> > > > >> > > > > > > > > > > > > -- > > > Daniel Cunha > > > https://twitter.com/dvlc_ > > > http://www.tomitribe.com > > > > > > > > > > > -- > > Daniel Cunha > > https://twitter.com/dvlc_ > > http://www.tomitribe.com > > > > > > -- > > > > *Pedro Belmino *System Analist > Laboratory of Mobile Computing and Design > Federal University of Ceará > Office: + 55 85 3366-9797 > E-mail: [email protected] <[email protected]> > -- Daniel Cunha https://twitter.com/dvlc_ http://www.tomitribe.com
