Why Content Query Web Part (CQWP) doesn’t return all results.

re: Why Content Query Web Part (CQWP) doesn’t return all results.

Alessandro — Fri, 23 Oct 2009 09:21:51 GMT

WOAH! UseCache worked for me too!

re: Why Content Query Web Part (CQWP) doesn’t return all results.

Michael — Fri, 23 Oct 2009 09:19:11 GMT

SP1 is definitely a reason of your issue, I reckon. SP1 is dated back to fall of 2007, but now is year 2009 - you are on the system without 2 years old updates.

My strongly recommendation is to update to SP2 and then test again. I bet the issue will be fixed.

re: Why Content Query Web Part (CQWP) doesn’t return all results.

Alessandro — Fri, 23 Oct 2009 09:14:16 GMT

SP1...

re: Why Content Query Web Part (CQWP) doesn’t return all results.

Michael — Fri, 23 Oct 2009 09:09:11 GMT

What's the version of Service Pack installed on SharePoint?! Is it SP2?!

re: Why Content Query Web Part (CQWP) doesn’t return all results.

Alessandro — Fri, 23 Oct 2009 09:05:02 GMT

Hi, I have a similar problem: I'm grouping the documents by a field (month). In anonymous navigation everything works fine (only approved items are shown), but if a contributor is logged and there are unapproved items, they aren't grouped together with the ones having the same month, but another grouping is created!

E.g.:

Doc Lib contains:

Doc 1 Month March Approved

Doc 2 Month March Approved

Doc 3 Month March Published

Doc 4 Month April Approved

Doc 5 Month April Approved

Doc 6 Month April Published

CQWP will show (with grouping field Month):

March

- Doc 1

- Doc 2

April

- Doc 4

- Doc 5

March

- Doc 3

April

- Doc 6

Any idea on this weird behaviour?

Thanks!

re: Why Content Query Web Part (CQWP) doesn’t return all results.

David Hamilton — Tue, 20 Oct 2009 19:15:22 GMT

Worked perfectly and very simple. Thanks.

David

re: Why Content Query Web Part (CQWP) doesn’t return all results.

Boris Gomiunik — Mon, 28 Sep 2009 07:29:09 GMT

Thank you! UseCache property to False did the trick!

re: Why Content Query Web Part (CQWP) doesn’t return all results.

Franck — Wed, 09 Sep 2009 13:57:46 GMT

I also got some weird behavior with CQWP on discussion boards with content approval:

1. Without any filtering, I only got all the approved items.

2. As Kate mentionned, using the filter "CreatedBy=[Me]" lists all my items even the pending or rejected ones!

3. Using the filter "CreatedBy=[Me] OR CreatedBy!=[Me]" outputs all my items (including the pending or rejected ones) and, oddly some but not all the approved ones!

MOSS version is 2007 SP2 April'09 CU (Enterprise ed)

re: Why Content Query Web Part (CQWP) doesn’t return all results.

Michael — Thu, 03 Sep 2009 15:22:32 GMT

hmmm, interesting.

Can you say the exact version of SharePoint 2007 you are using.

I think it might be fixed in one of the SP or updates, but need to know you version number where you have such behavior

re: Why Content Query Web Part (CQWP) doesn’t return all results.

kate — Thu, 03 Sep 2009 14:20:31 GMT

bizzarrely, if you add a filter on checkoutUser Not eq to [Me] then the checked out items will appear in display mode regardless of cache settings