Hi Simon,

I think there are two solutions for your problem. The easiest one is to add an attribute to each blog instance called something like "clubId". When you create a club, set the clubId for the blog that is created - this is best done in a HTTP module that listens to the Club created event. Now you can search for this attribute.

The other way is to build a custom Criteria and in this criteria make a join with clubs.

Best regards,
Tom

Having some more query related problems...

We have a blog that has an Attribute called 'BelongsToClub' I want to pass a number of possible clubs it can belong to, I can get this working fine.

entryQuery["BelongsToClub"] = GetClubCriterion(communitIDs) //returns ClubCriterion()

I also want to add the following

IntegerCriterion intC1 = new IntegerCriterion();
intC1.Value = (int)EPiServer.Community.Blog.BlogType.UserBlog;
IntegerCriterion intC2 = new IntegerCriterion();
intC2.Value = (int)EPiServer.Community.Blog.BlogType.ClubNews; 

CriteriaGroup cgBlog = new CriteriaGroup();
cgBlog.AddCriterion(blog1);
cgBlog.AddCriterion(LogicalOperator.Or, blog2);
entryQuery.AddCriteriaGroup(cgBlog);

When this runs I get the following error :

A criterion in the supplied ICriteriaGroup is not defined in this Query.
Parameter name: group
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: A criterion in the supplied ICriteriaGroup is not defined in this Query.
Parameter name: group

Source Error:

Line 483: cgBlog.AddCriterion(blog1);
Line 484: cgBlog.AddCriterion(LogicalOperator.Or, blog2);
Line 485: entryQuery.AddCriteriaGroup(cgBlog);

Any ideas?....  i've been finding some of this querying language quite hard to work out!

Thanks,

Simon

Ok, i've got most of that working, but where i'm really stuck now is on CriteriaGroup.

How do you group items together that are on different levels? eg.

entryQuery["BelongsToClub"] is set to the correct ClubCriterion that brings the results back i want.

then I set entryQuery.Blog["BlogTypeID"] to the IntegerCriterion i want, that also brings back the correct results on its own.

I want to group those two items together, using LogicalOperator.Or, does that make sense?  How do I do that, i've tried everything i can think of...

Thanks,

Simon

I've been trying to solve the issue of getting blog entries with title and content values which contain specified keywords AND belong to specified clubs AND have a blogType='ClubNews' OR
blogType = 'UserBlog'. I have coded the following which under limited testing appears to work - although its not pretty it might help :-)

It requires using System.Collections.Generic; using EPiServer.Community.Blog; using EPiServer.Community.Blog.Queries; 

        public EntryCollection SearchTopicsEntries(string searchText, int[] blogIds)
        {
            // Search Blogs

            EntryCollection entryCollection = new EntryCollection();
            EntryCollection result = new EntryCollection();

            EntryQuery eq = new EntryQuery();

            // Create title criteria

            StringCriterion titleCriterion = new StringCriterion();
            titleCriterion.Value = searchText;
            titleCriterion.WildCardType = WildCardType.Both;
            eq.Title = titleCriterion;

            // Create content criteria

            StringCriterion contentCriterion = new StringCriterion();
            contentCriterion.Value = searchText;
            contentCriterion.WildCardType = WildCardType.Both;
            eq.Content = contentCriterion;

            // Create and add criteriaGroup
           
            CriteriaGroup criteriaGroup = new CriteriaGroup();
            criteriaGroup.AddCriterion(eq.Title);
            criteriaGroup.AddCriterion(LogicalOperator.Or, eq.Content);

            eq.AddCriteriaGroup(criteriaGroup);

            // Get searched for entries in with keyword in title or contents 

            int totalTopicItems = 0;
            entryCollection = QueryHandler.GetQueryResult<Community.Blog.Entry, EntryCollection>(eq, Utils.CacheTimeOut.Search, 1, 12, out totalTopicItems);
           
            // Filter returned entryCollection for blogs with the right ID values and blogType

            IList<int> blogIdsAsList = blogIds as IList<int>;

            foreach (Entry entry in entryCollection)
            {
                int blogId = entry.Blog.ID;
                if (blogIdsAsList.Contains(blogId))
                {
                    if (BlogOfTypeRequired(blogId))
                    {
                        // if blog has ID = blogId and blogtype UserBlog or ClubNews add to result,
                        result.Add(entry);
                    }
                }
            }
            return result;
        }

        public bool BlogOfTypeRequired(int blogId)
        {
            bool result = false;

            BlogCollection blogCollection = new BlogCollection();
            BlogQuery bq = new BlogQuery();

            // Create ID criterion
           
            IntegerCriterion idCriterion = new IntegerCriterion();
            idCriterion.Value = blogId;
            bq.ID = idCriterion;

            // Create first BlogTypeCriterion - UserBlog

            BlogTypeCriterion userBlogCriterion = new BlogTypeCriterion();
            userBlogCriterion.Value = BlogType.UserBlog;
            bq.BlogType = userBlogCriterion;

            // Create and add criteriaGroup

            CriteriaGroup criteriaGroup = new CriteriaGroup();
            criteriaGroup.AddCriterion(bq.ID);
            criteriaGroup.AddCriterion(LogicalOperator.And, bq.BlogType);

            bq.AddCriteriaGroup(criteriaGroup);

            // Collect results

            int totalTopicItems = 0;
            blogCollection = QueryHandler.GetQueryResult<Community.Blog.Blog, BlogCollection>(bq, Utils.CacheTimeOut.Search, 1, 12, out totalTopicItems);

            if (blogCollection.Count > 0)
            {
                result = true;
            }
            else
            {
                // try ClubsNews as a BlogType
               
                userBlogCriterion.Value = BlogType.ClubNews;
                criteriaGroup = new CriteriaGroup();
                criteriaGroup.AddCriterion(bq.ID);
                criteriaGroup.AddCriterion(LogicalOperator.And, bq.BlogType);
                bq.AddCriteriaGroup(criteriaGroup);

                // Collect the results

                totalTopicItems = 0;
                blogCollection = QueryHandler.GetQueryResult<Community.Blog.Blog, BlogCollection>(bq, Utils.CacheTimeOut.Search, 1, 12, out totalTopicItems);

                if (blogCollection.Count > 0)
                {
                    result = true;
                }
            }

            return result;
        }