locked
Sharepoint 2007 Custom Alert Template Group By Clause RRS feed

  • Question

  • We have created a custom sharepoint alert which shows data in a digest format. The data is categorized in a manner that traditional reporting SQL would leverage as a group by.

    Is anyone aware of a way to change a custom List Email Alert Tempate to show and form the email with the caregory (group) as subheaders ? (CAML query groupby?)


    Sharepoint List Content
    Date      |              Group   |              Description
    1/1/2012              Red                        Item 1 about Red
    1/1/2012              Red                        Item 2 about Red
    1/1/2012              Blue                       Item 1 about Blue

    Alert Email Format Currently:
    1/1/2012              Red                        Item 1 about Red
    1/1/2012              Red                        Item 2 about Red
    1/1/2012              Blue                       Item 1 about Blue

    Alert Email Format Desired:

    Red
    1/1/2012              Item 1 about Red
    1/1/2012              Item 2 about Red

    Blue

    1/1/2012              Item 1 about Blue

    Monday, April 22, 2013 8:14 PM

All replies

  • Hi,

    Thank you for your question. I am trying to involve someone familiar with this topic to further look at this issue. There might be some time delay. Appreciate your patience. Thank you for your understanding and support.

    Thanks,

    Entan Ming

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contacttnmff@microsoft.com.


    Entan Ming
    TechNet Community Support

    Tuesday, April 23, 2013 2:49 AM
    Moderator
  • I am trying to involve someone familiar with this topic to further look at this issue

    Great, I found a bit more information about what may be the solution and the term CrossTab (excel) came up. I also have seen SharePoint list views show this format. Thanks for your reply I await any assistance you can provide.
    Tuesday, April 23, 2013 6:44 PM
  • Hi If you need to customize the alert template you can look under the 12 hive at the AlertTemplates.xml file. Perhaps some XSL styling can help you with the formatting you want
    Thursday, May 9, 2013 2:30 PM