Hello all, Is there a limitation on how many items...
# general
d
Hello all, Is there a limitation on how many items are used when using a criteria max search? In my case I'm landing up with a top end of records when I do the following for field setCalibValue. What I'm trying to do is check the database field for the highest number on that column. This column is made up of either null, numbers, or numbers and a letter (for example a variant of value 9 would be 9a, 9b, 9c). This seems to work properly using the database query, and if I populate test data into the database including nulls, numbers, numbers and letters; but not for my actual number. When I do the below, I always get 999 regardless of the total number of records... Any thoughts out there? def currentMax= critBuilder.list{ projections{ max 'setCalibValue' } }