[jira] [Created] (DELTASPIKE-1352) Get count of items with Criteria after filtering.

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (DELTASPIKE-1352) Get count of items with Criteria after filtering.

JIRA jira@apache.org
juan jimenez created DELTASPIKE-1352:
----------------------------------------

             Summary: Get count of items with Criteria after filtering.
                 Key: DELTASPIKE-1352
                 URL: https://issues.apache.org/jira/browse/DELTASPIKE-1352
             Project: DeltaSpike
          Issue Type: Test
            Reporter: juan jimenez


Hi. I'm filtering using "Criteria" by some  conditions It works correctly and get the list of item that meets the conditions. I would like to get the count of items which meets the conditions without getting this list in memory, I just want to query this count number.

Thanks in advance.

""

    int findUserByCriteria(String name, Boolean active,  Integer idrol){

        Criteria<User, User> c = criteria();
         
         if(name != null)
             c.likeIgnoreCase(User_.name, name + "%");
         
         if(active != null)
             c.eq(User_.active, active);
         
         if(idrol != null)
             c.eq(User_.idRol, idrol);

.....

    {color:#ff0000}  int count = ¿?{color}

.....

return count;

}

""



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)