search

netgen / TagsBundle

Netgen Tags Bundle is an eZ Platform bundle for taxonomy management and easier classification of content, providing more functionality for tagging content than ezkeyword field type included in eZ Platform kernel.
https://netgen.io
GNU General Public License v2.0
48 stars 44 forks source link

Order column should be in select #64

Closed MarioBlazek closed 7 years ago

MarioBlazek commented 7 years ago

Currently keyword column is missing from select query in DoctrineDatabase.php, with this fix query is properly generated:

SELECT DISTINCT eztags.id, eztags.keyword
FROM `eztags`
  LEFT JOIN `eztags_keyword`
    ON ( `eztags_keyword`.`keyword_id` = `eztags`.`id` AND `eztags_keyword`.`status` = 1 )
WHERE ( `eztags`.`parent_id` = 0
AND `eztags`.`main_tag_id` = 0 )
ORDER BY `eztags`.`keyword` ASC
LIMIT 25 OFFSET 0;
emodric commented 7 years ago

Thanks @MarioBlazek ! However, please rebase to 3.0-release branch, since this needs to go to 3.0.8 :)

emodric commented 7 years ago

Thanks @MarioBlazek !