[DELTASPIKE-1352] Support count in Criteria

• Type: New Feature
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: Data-Module
• Assignee: Unassigned
• Reporter: mojo code
• Created: 06/Jul/18 16:59
• Updated: 25/Sep/18 15:10

Description

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);

.....

      int count = ¿?

.....

return count;

}

""