Revize 31735389

Bug #8989 Řazení záznamů

application/controller/TableController.php

@@ -10 +10 @@
 $whereQuery = createWhereQuery($parArray);
 
 $results = $DB->select(
-        "SELECT w.id, w.context, w.date, w.description, w.description2, w.description3, w.ending, w.finished,
+        "SELECT DISTINCT w.id, w.context, w.date, w.description, w.description2, w.description3, w.ending, w.finished,
 w.namedentity, w.position1, w.position2, w.positiondetail, w.word, w.tag_id, w.lemma_id, t.tag, l.lemma, m.manuscript,
-l.pos FROM dd_manuscript as m left join dd_wordform as w on m.wordform_id = w.id left join dd_tag as t on w.tag_id = t.id left join dd_lemma as l on w.lemma_id = l.id ".$whereQuery." order by w.id", $parArray);
+l.pos FROM dd_manuscript as m left join dd_wordform as w on m.wordform_id = w.id left join dd_tag as t on w.tag_id = t.id left join dd_lemma as l on w.lemma_id = l.id ".$whereQuery." order by l.lemma", $parArray);
 
 $output = Array();
 $output["data"] = Array();