I was looking to modify the module to allow alphabetical sorting of FAQs, when I found that was already built in, and just required the following edit - was this a release oversight?

1) Back up DesktopModules/FAQs/Settings.ascx

2) Under the sorting options (<asp:dropdownlist...) add the following line:

<asp:ListItem Value="4" resourcekey="OrderBy.Text">Question Text</asp:ListItem>

3) Save and replace the Settings.ascx file in your site, and you will now be able to sort alphabetically.

The OrderBy.Text is already coded in (see App_LocalResources/FAQs.ascx.resx, line 138) and seems to work perfectly.

Many apologies - I've discovered that the process above causes FAQs to be sorted by the order of entry (which for our sites happened to be alphabetical).

To sort alphabetically, you'll need to do the following:

1) Follow the above process, but instead of OrderBy.Text, use OrderByAlphabet.Text.

2) Modify the stored procedure FAQSearch, and add the following line at the end:

CASE WHEN @OrderBy=4 THEN CAST(f.Question as VarChar(8000)) END ASC

Remember to add a comma at the end of the preceding line, and you should be in business.

I have tried both above methods for adding Alphabetic sorting, but neither methods work.  I have modified Settings.ascx as well as the FAQSearch stored procedure yet the alphabetic sort does not work.  Is there any other method?