CategoryHandler.GetCategorizedItems vs. GetQueryResult

Jonas Eriksson

Vote:

Hi,

I have some code that I would think works in a similar way - but turns out to give me different outpu. I am now quite confused and would relly like some help here!

Code A:
CategoryCollection categories = new CategoryCollection();
categories.Add(CategoryHandler.GetCategory(categoryId));
this.TheRepeater.DataSource =
CategoryHandler.GetCategorizedItems(typeof(Club), categories, page, pagesPerPage, out totalItems);

Returns wanted result.

Code B:
ClubQuery clubQuery = new ClubQuery();
clubQuery.Categories = new CategoryCollectionCriterion();
clubQuery.Categories.Containing = new CategoryCriterion();
clubQuery.Categories.Containing.ID = new IntegerCriterion();
clubQuery.Categories.Containing.ID.Value = categoryId;
this.TheRepeater.DataSource = ClubHandler.GetQueryResult(clubQuery, page, pagesPerPage, out totalItems);

Does not return anything.

#23328

Sep 03, 2008 14:00

Vote:

Hi Jonas,

It should result in the same data being returned, except for the matter of sorting.

Have you verified what the value of totalItems is after running GetQueryResult?

#23421

Sep 05, 2008 10:06

Jonas Eriksson

Vote:

Hmm... the ClubQuery method seems to work rather randomized for me. Exactly the same query on the same page produces different results. If I search using one criteria, A, then searches using another criteria, and finally search using A again, A produces different result. Is this a cache issue perhaps?

#23507

Sep 08, 2008 13:33

Vote:

There is a cache issue in the query system that has been resolved and will be fixed with an update in a near future. This sounds like the problem in question.

You could work around this problem by clearing the query cache before executing the query by calling QueryHandler.RemoveQueryResultCache(query);

#23545

Sep 09, 2008 10:43

Erik Täck

Vote:

QueryHandler.RemoveQueryResultCache(query);

Where is this method located?

As in wich dll? We have searched for this quite extensively, but not found it.

We ended up using:

StarSuite.Core.Cache.CacheHandler.RemoveCachedObject(new string[] { "StarCommunityQueries", "Query" });

wich is quite inefficient and dirty, but atleast it works.

#25461

Oct 27, 2008 14:21