I've been pulling out my hair trying to figure out why my query list has been returning a limited number of rows. Turns out that if i either leave out my DISTINCT_ROOT_ENTITY result transformer or leave out SetMaxResults criteria, then i get the correct # of items... since i need both i want to know how to avoid this.

here is the scenario. in a simple query i get about 10 rows. If i add the max results criteria to lets say 5 i get 5 rows returned. If i add the result transformer i get 2 rows returned.

If i remove the max results criteria i get 6 rows returned (no duplicated) Which is correct but i need the max results for pagination.

It seems that the result transformer is being called after the "5" results are retrived and then trimming out the duplicates. Is there a way i can call the result transformer BEFORE the results are trimmed?