Dave Burke : Online Community and Social Business Specialist

6/13/2009 1:45:06 AM Permalink

I really like the custom query implementation route.  Create a class implementing QueryImplementationBase , get the query in the original queryoverrides by casting the query object to the appropiate type.  Do your stuff then return your results.  Then just implement your custom query implementation by adding it to the QueryOverrides

<QueryOverrides>
   <DRIVEostSectionFavorableContentQuery FavoriteType="Post" runat="server" />
</QueryOverrides>

Alex Crome |

6/13/2009 1:45:59 AM Permalink

hmm, the :p is supposed to be a colon followed by a p - i.e. DRIVE : PostSectionFavorableContentQuery (without the spaces)

Alex Crome |

6/13/2009 11:29:31 AM Permalink

It isn't exactly post query processor - it replaces the actual execution of the query from the list control.  The query that's provided into the GetQueryResults<T> method is the query object built internally by Community Server, but it hasn't been executed yet.

Below is a quick sample - this is based off the SortThreadsByGroupForumSortOrderQueryImplementation (horrible name I know) used for the Improved Active Topics page in my CS addons - alexcrome.co.uk/.../...ved-active-topics-page.aspx .  All the below sample does is reverse the order of posts in a ThreadList control.

public override List<T> GetQueryResults<T>(object query, out int totalResults)
{
    if (query is ForumThreadQuery)
    {
        ThreadSet threadSet = Threads.GetThreads(query as ForumThreadQuery);
        List<Post> posts = threadSet.AllThreads;

        List<Post> orderedPosts = new List<Post>();
        
        posts.Reverse();

        List<T> results = new List<T>();

        if (orderedPosts != null)
        {
            foreach (object o in orderedPosts)
            {
                if (!(o is T))
                    throw new InvalidCastException("The custom query results are not of the expected type.");
                else
                    results.Add(o as T);
            }
        }

        totalResults = threadSet.TotalRecords;
        return results;
    }
    else
    {
        totalResults = 0;
        return null;
    }
}

(N.B. I haven't actually tested this sample - it's a simplified version of the QueryImplementation in my CS Addons to show the main features.  You might also like to look at the source for that for further inspiration.)

Alex |