After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 729378 - Disregard "The" in titles
Disregard "The" in titles
Status: RESOLVED FIXED
Product: gnome-music
Classification: Applications
Component: general
3.12.x
Other Linux
: Normal enhancement
: 3.14
Assigned To: gnome-music-maint
gnome-music-maint
available
Depends on:
Blocks:
 
 
Reported: 2014-05-02 10:54 UTC by Marcus Lundblad
Modified: 2014-11-04 22:01 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
changed 'order by' for query.artists() and query.albums(): sorting now disregards 'the' at beginning of artist/album name (1.74 KB, patch)
2014-10-22 16:29 UTC, Maia
none Details | Review
ORDER BY statements generated by order_by_statement function, nested if statements to ignore multiple articles, _('the') for translatability (3.61 KB, patch)
2014-10-29 16:41 UTC, Maia
none Details | Review
ORDER BY statements generated by order_by_statement function, nested if statements to ignore multiple articles, _('the') for translatability. INCLUDES 'IMPORT GETTEXT'. (3.86 KB, patch)
2014-11-04 16:54 UTC, Maia
none Details | Review

Description Marcus Lundblad 2014-05-02 10:54:01 UTC
It would be nice if Music sorted albums (and perhaps artists and tracks) starting with "The" after the string following "the".
It could also change the presentation, so an album named "The Album" would show up as "Album, the".
Searching should probably find both variants.
Comment 1 Vadim Rutkovsky 2014-05-05 10:55:47 UTC
Yeah, we definitely should implement this, extending the same to artists, though I'm not sure about the tracks
Comment 2 Vadim Rutkovsky 2014-10-16 10:23:32 UTC
We should also make sure this is translatable - see https://github.com/gnumdk/lollypop/issues/3#issuecomment-59149670
Comment 3 Maia 2014-10-22 16:29:01 UTC
Created attachment 289149 [details] [review]
changed 'order by' for query.artists() and query.albums(): sorting now disregards 'the' at beginning of artist/album name
Comment 4 Vadim Rutkovsky 2014-10-23 10:39:06 UTC
(In reply to comment #3)
> Created an attachment (id=289149) [details] [review]
> changed 'order by' for query.artists() and query.albums(): sorting now
> disregards 'the' at beginning of artist/album name

Good job, pushed as https://git.gnome.org/browse/gnome-music/commit/?id=7f0dc8d

Keeping the bug open as we still need to implement translations for this
Comment 5 Maia 2014-10-29 16:41:55 UTC
Created attachment 289599 [details] [review]
ORDER BY statements generated by order_by_statement function, nested if statements to ignore multiple articles, _('the') for translatability
Comment 6 Vadim Rutkovsky 2014-11-03 10:42:42 UTC
(In reply to comment #5)
> Created an attachment (id=289599) [details] [review]
> ORDER BY statements generated by order_by_statement function, nested if
> statements to ignore multiple articles, _('the') for translatability

Looks good, but query.py lacks 'from gettext import gettext as _'
Comment 7 Maia 2014-11-04 16:54:54 UTC
Created attachment 289982 [details] [review]
ORDER BY statements generated by order_by_statement function, nested if statements to ignore multiple articles, _('the') for translatability. INCLUDES 'IMPORT GETTEXT'.
Comment 8 Maia 2014-11-04 16:55:50 UTC
(In reply to comment #6)
> (In reply to comment #5)
> > Created an attachment (id=289599) [details] [review] [details] [review]
> > ORDER BY statements generated by order_by_statement function, nested if
> > statements to ignore multiple articles, _('the') for translatability
> 
> Looks good, but query.py lacks 'from gettext import gettext as _'

Whoops, my bad! Put in the import statement and reposted the patch--see comment #7.
Comment 9 Vadim Rutkovsky 2014-11-04 22:01:23 UTC
Thanks, pushed as https://git.gnome.org/browse/gnome-music/commit/?id=93555cf in master