public List<Post> selectPostCriteria(PostSearchOptions options) {

        EntityManager manager = null;
        try{
            manager = factory.createEntityManager();
            CriteriaBuilder builder = manager.getCriteriaBuilder();
            CriteriaQuery<Post> criteriaQuery = builder.createQuery(Post.class);
            Root<Post> root = criteriaQuery.from(Post.class);

            criteriaQuery.select(root);
            criteriaQuery.where(toPredicate(builder, root, options));
            Order order = builder.asc(root.get(Post_.title));
            criteriaQuery.orderBy(order);

            TypedQuery<Post> query = manager.createQuery(criteriaQuery);

            if(options.getFirstResult() != null)
                query.setFirstResult(options.getFirstResult());

            if(options.getMaxResult() != null)
                query.setMaxResults(options.getMaxResult());


            List<Post> result = query.getResultList();
            return result;

        }finally{
            if(manager != null)
                try{
                    manager.close();
                }catch(RuntimeException e){}
        }
    }