I am writing a method for retrieving clients with sum of their orders (order.total) higher and less than input values. All its okay, but, sometimes i am get an error: How can i correcting this method, or, maybe, convert this in full criteria style? Answer In the end, i solved this problem by this way, using sql restriction: