From 9eeea926906089887b422a9e378a39d18e193976 Mon Sep 17 00:00:00 2001 From: titima15 Date: Wed, 25 Jan 2017 17:31:40 +0000 Subject: [PATCH] added list sorting --- lib/SGN/Controller/AJAX/Search/Cross.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/SGN/Controller/AJAX/Search/Cross.pm b/lib/SGN/Controller/AJAX/Search/Cross.pm index 371d38f18..ff359fa4f 100644 --- a/lib/SGN/Controller/AJAX/Search/Cross.pm +++ b/lib/SGN/Controller/AJAX/Search/Cross.pm @@ -31,7 +31,7 @@ sub search_male_parents :Path('/ajax/search/male_parents') :Args(0){ AND stock_relationship1.type_id= '$female_parent_typeid' INNER JOIN stock_relationship AS stock_relationship2 ON (stock_relationship1.object_id=stock_relationship2.object_id) INNER JOIN stock AS male_parent ON (male_parent.stock_id=stock_relationship2.subject_id) AND stock_relationship2.type_id= '$male_parent_typeid' - WHERE female_parent.uniquename= '$female_parent'"; + WHERE female_parent.uniquename= '$female_parent' ORDER BY male_parent.uniquename ASC"; my $h = $dbh->prepare($q); -- 2.11.4.GIT