Custom Browse Menu - No Alphabetical Sorting In Albums Sub-Menus

[kiwibrucie]

Hi Erland.

Thank you very much for for that, it works great on the PC web interface. Haven't got access to my iphones at the moment so can't check Ipeng functionality.

Cheers........... Bruce

[bobertuk]

I don't want to change that as default, as I think it might be bad on a Boom where the the display isn't that wide so you might end up to only display artist names, but you can select the "Customize" option in the bottom of the menu configuration and see if you can figure out how to adjust it. I guess it might be hard to do the customization unless you are familiar with XML and SQL, but that's the way to handle it in case you like to change this behavior.

I have tried using the customize option but I know only a little SQL and nothing about XML - I may investigate though. Any hints?

Bob

[bobertuk]

Hi again erland,

I think I've found the code block used by Custom Browse to sort albums by artist...

<option>
	<id>byartist</id>
	<name>Sort by artist</name>
	<itemformat>albumconcat</itemformat>
	<menulinks>number</menulinks>
	<menudata>
		select albums.id,if(albums.compilation,' ',concat('(', group_concat(distinct contributors.name) ,')')) from albums,contributor_album,contributors
		where 
			albums.id=contributor_album.album and
			contributor_album.contributor=contributors.id and
			contributor_album.role in (1,5)
		group by albums.id
		order by contributors.namesort asc,albums.year desc,albums.titlesort asc,albums.disc asc
	</menudata>
</option>

If I wanted to swap around the order text output is displayed in the WebUI:

From: Album (Artist)

To: Artist (Album)

Would that be an easy thing to do? If so - how?

Thanks

Bob

[erland]

Hi again erland,

I think I've found the code block used by Custom Browse to sort albums by artist...

...

If I wanted to swap around the order text output is displayed in the WebUI:

From: Album (Artist)

To: Artist (Album)

Would that be an easy thing to do? If so - how?

Thanks

Bob

Try something like this:

<option>
	<id>byartist</id>
	<name>Sort by artist</name>
	<itemformat>albumcustom</itemformat>
	<menulinks>number</menulinks>
	<menudata>
		select albums.id,concat(group_concat(distinct contributors.name), '(', albums.name ,')') from albums,contributor_album,contributors
		where 
			albums.id=contributor_album.album and
			contributor_album.contributor=contributors.id and
			contributor_album.role in (1,5)
		group by albums.id
		order by contributors.namesort asc,albums.year desc,albums.titlesort asc,albums.disc asc
	</menudata>
</option>

I have not verified this myself, I'm just trying to give you some ideas, they key changes are:
- Change itemformat from "albumconcat" to "albumcustom", I think this is needed because "albumconcat" will add the album title first. If "albumcustom" doesn't work, you can try to remove the <itemformat>...</itemformat> row completely and see if that works, but I think albumcustom should give you albumcovers while removing itemformat row won't.
- Adjust the first line of the SQL so it starts by adding artist names, then (, the name of the album, and )

The above doesn't handle compilations, so there is a risk compilation albums are going to look strange.