I just knocked up a quick extension to make it easier to create A to Z indexes of entries.

It creates a new column in exp_weblog_titles and adds the first character of the entry’s title.

You get a new parameter “title_alpha” to add to your exp:weblog:entries tag.  Example:

You can see it in action here.  Just change the third segment to a letter to filter.  There’s no support for foreign characters.

I’ve tested it on a couple of sites without problems but don’t try it on anything critical until I’ve gained some feedback.

Any suggestions for improvement?

wiki’d twice. Thank you.

haha, it’s beer not bear

I totally knew that.  I blame misplacing beer with bear on WoW. *whistles*

This is why other people should be adding to the wiki.  See? Oooh. =)

You’re just too quick for us Lisa

BTW, the only reason I say don’t try it on critical stuff now is that when the extension is enabled it runs through all your entries and adds the first character to the title_alpha column.  I could probably improve the performance of this query as I’m not sure how it’ll handle sites with 1000s of existing entries.

I would probably prefix the new column name.  It’s not likely that we will add a column with that name, but by prefixing it with some something short and unique, you can be more assured that you are protected against potential collision, not only with first party changes, but with other third party add-ons a user might be using.  And yes, one query per entry, all at once, is probably not the best implementation.  As a matter of fact, I believe that you could do this with a single query, using MySQL’s built in string functions.

How about

?

Edit: I’d probably add either LOWER() or UPPER() to enforce one character case..

Thanks Andy, and Derek for your suggestions.

Could you localize it for UK = atozed ? 

The only international way would be a2z, where pronounciation is left as an excercise to the reader

come on people, it took me close to 2 minutes to think of a name with ‘ee’ in there.

Wow, I totally failed to realise/appreciate that… Well done, in this case.

Hm.. come to think of it, I probably wouldn’t create another column unless its really neccessary for performance.
I’ll have to extend Derek’s line of though here, it’s potentially hasardous to alter the core tables, compared to adding a cpu-cycle and a half to each query.

What are your thoughts on this?

Andy I think that’s a much better idea.  Unless anyone suggests otherwise in the meantime I’ll update the extension later today.

smallbeer, Is the currently linked extension the updated version?

edit: Also does dynamic have to be set to “off” or am I able to use this in conjunction with pagination which seems to require dynamic to be set to “on”?

Anybody know if the linked extension is the current version? I’m having trouble getting it to work.

No the attached file isn’t the updated version.  I’ve been too busy the past few days.  It won’t take long though so I’ll try find the time tomorrow.

And no, the dynamic parameter doesn’t necessarily have to be set to ‘off’.

smallbeer - 15 January 2007 01:59 PM

No the attached file isn’t the updated version.  I’ve been too busy the past few days.  It won’t take long though so I’ll try find the time tomorrow.

Ok, that could explain why I’m having trouble getting it to work. I’m looking forward to the updated version.

smallbeer - 15 January 2007 01:59 PM

And no, the dynamic parameter doesn’t necessarily have to be set to ‘off’.

Good to know, thanks.

Gentle reminder, the file attached to this message has not been updated. It’s still dated January 6th.