I’ve had huge trouble finding out why my Content Query WebPart wasn’t showing the data as I configured it to do.
Luckily I’ve found the following very interesting posts:
- Content Query Web Part (CQWP) SharePoint 2007 Performance
- Content Query Web Part (CQWP), Cross List Query Nightmare Part 1
- Content Query Web Part (CQWP), Cross List Query Nightmare Part 2
- Content Query Web Part (CQWP), Cross List Query Nightmare Part 3
Part 3 really helped me with my problems, but all the posts in this serie are very interesting.
It turns out that there is a inconsistancy in the way SharePoint saves its data in the database and the way SharePoint queries the same data. Item data gets saved in the AllUserData table. In this table there are collumns for general use e.g. the columns have names like nvarchar21, nvarchar22, etc. These columns will be used to store data of lists and libraries.
When a contenttype gets used by multiple subsites, there is no gaurantee that the fields get saved in the same columns. This wouldn’t be a problem, if SharePoint create the right query to retrieve the data from the right columns..
Well, I suggest just take the time to read the post. It really makes things clearer.
Well done!!! Amazing and Very informative post. I was lkooing for this.Author, I am also lkooing for the issue i am facing is I have a column of type RichText in content type in Sharepoint.The content in the word document is showing html tags instead of richtext format.I mean when I enter viz. “some italic text is in red” in sharepoint list and open word document. Word document shows “someitalic text is inred”.How do I show rich text in a word document?I would appreciate if you please reply me asap.Could you mention your twitter/hotmail for instant messaging.Thanks & RegardsKhushi
Erivania, I don’t think it’s possible to get formatted text from a richt text field into a Word document without loosing the formatting.