diff options
| author | Jeremy Benoist <jeremy.benoist@gmail.com> | 2017-03-28 14:07:42 +0200 |
|---|---|---|
| committer | Jeremy Benoist <jeremy.benoist@gmail.com> | 2017-03-28 14:07:42 +0200 |
| commit | 7d1d961267c129e2110ce9cc14c5a9d0a7d255cb (patch) | |
| tree | d260d7b4ffc8466d7d410ec61bd896bdadd8456e /src/Wallabag/CoreBundle/Repository | |
| parent | e1cc8fd79921fdff9999087ba896c88b14ffc0cd (diff) | |
| parent | 6ae579e43f6a4ffe607a6361191366410d19f806 (diff) | |
| download | wallabag-7d1d961267c129e2110ce9cc14c5a9d0a7d255cb.tar.gz wallabag-7d1d961267c129e2110ce9cc14c5a9d0a7d255cb.tar.zst wallabag-7d1d961267c129e2110ce9cc14c5a9d0a7d255cb.zip | |
Merge remote-tracking branch 'origin/master' into 2.3
Diffstat (limited to 'src/Wallabag/CoreBundle/Repository')
| -rw-r--r-- | src/Wallabag/CoreBundle/Repository/EntryRepository.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/Wallabag/CoreBundle/Repository/EntryRepository.php b/src/Wallabag/CoreBundle/Repository/EntryRepository.php index b9532fa2..4071301d 100644 --- a/src/Wallabag/CoreBundle/Repository/EntryRepository.php +++ b/src/Wallabag/CoreBundle/Repository/EntryRepository.php | |||
| @@ -106,8 +106,9 @@ class EntryRepository extends EntityRepository | |||
| 106 | $qb->andWhere('e.isArchived = true'); | 106 | $qb->andWhere('e.isArchived = true'); |
| 107 | } | 107 | } |
| 108 | 108 | ||
| 109 | // We lower() all parts here because PostgreSQL 'LIKE' verb is case-sensitive | ||
| 109 | $qb | 110 | $qb |
| 110 | ->andWhere('e.content LIKE :term OR e.title LIKE :term')->setParameter('term', '%'.$term.'%') | 111 | ->andWhere('lower(e.content) LIKE lower(:term) OR lower(e.title) LIKE lower(:term) OR lower(e.url) LIKE lower(:term)')->setParameter('term', '%'.$term.'%') |
| 111 | ->leftJoin('e.tags', 't') | 112 | ->leftJoin('e.tags', 't') |
| 112 | ->groupBy('e.id'); | 113 | ->groupBy('e.id'); |
| 113 | 114 | ||