From 1cffbc606643e859f1096a47e6b720e1a8100202 Mon Sep 17 00:00:00 2001 From: Jeff Godin Date: Mon, 3 Jun 2013 16:03:11 -0400 Subject: [PATCH] Add explicit sort to collections API with limit Add an explicit ORDER BY au.id ASC when limiting collections API calls. This ensures that the same users will be returned on subsequent calls, assuming no other relevant changes in the data. Signed-off-by: Jeff Godin --- Open-ILS/src/perlmods/lib/OpenILS/Application/Collections.pm | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/perlmods/lib/OpenILS/Application/Collections.pm b/Open-ILS/src/perlmods/lib/OpenILS/Application/Collections.pm index c66daba113..0140d16f1e 100644 --- a/Open-ILS/src/perlmods/lib/OpenILS/Application/Collections.pm +++ b/Open-ILS/src/perlmods/lib/OpenILS/Application/Collections.pm @@ -266,7 +266,8 @@ sub users_of_interest_warning_penalty { $query->{limit} = $limit; my $sort_order = $sort || "DESC"; $query->{order_by} = [ - {class => 'ausp', field => 'set_date', direction => $sort_order} + {class => 'ausp', field => 'set_date', direction => $sort_order}, + {class => 'au', field => 'id', direction => 'ASC'} ]; } -- 2.11.0