Create a Blog EntryQuery fetching entries created by a user, either anonumously or not anonymously?
Vote:
Hello,
We're struggling a little bit with getting the following issue working. What we'd like to do is to, in one query using BlogHandler.GetQueryResult, retrieve BlogEntries created by a certain user, either anonymously (AnonymousAuthor) or not anonymously (UserAuthor). So far we've had to do two queries and then combine the result from these queries but we'd really like it if it's possible to do this in one query?
Here's the code for this:
AnonymousAuthorCriterion anonymousCriteria = new AnonymousAuthorCriterion();
anonymousCriteria.User = new UserCriterion();
anonymousCriteria.User.ID = new IntegerCriterion();
anonymousCriteria.User.ID.Value = anonymousAuthor.User.ID;
EntryQuery entryQueryAnonymous = new EntryQuery();
entryQueryAnonymous.Author = anonymousCriteria;
entryQueryAnonymous.Created = new DateTimeCriterion();
entryQueryAnonymous.OrderBy.Add(new CriterionSortOrder(entryQueryAnonymous.Created, SortingDirection.Descending));
int anonymousCount;
EntryCollection entriesAnonymous = BlogHandler.GetQueryResult(entryQueryAnonymous, page, pageSize, out anonymousCount);
UserAuthorCriterion userCriterion = new UserAuthorCriterion();
userCriterion.User = new UserCriterion();
userCriterion.User.ID = new IntegerCriterion();
userCriterion.User.ID.Value = userid;
EntryQuery entryUser = new EntryQuery();
entryUser.Author = userCriterion;
entryUser.Created = new DateTimeCriterion();
entryUser.OrderBy.Add(new CriterionSortOrder(entryUser.Created, SortingDirection.Descending));
int userCount;
EntryCollection entriesUser = BlogHandler.GetQueryResult(entryUser, page, pageSize, out userCount);
We've tried using CriteriaGroups and stuff but without any success, is there anybody out there who can help us?
Hello,
We're struggling a little bit with getting the following issue working. What we'd like to do is to, in one query using BlogHandler.GetQueryResult, retrieve BlogEntries created by a certain user, either anonymously (AnonymousAuthor) or not anonymously (UserAuthor). So far we've had to do two queries and then combine the result from these queries but we'd really like it if it's possible to do this in one query?
Here's the code for this:
We've tried using CriteriaGroups and stuff but without any success, is there anybody out there who can help us?
Best regards
Martin