thekid.me.uk

Thanks for this, saved me a lot of time!

Thanks a ton! This is really helpful.

Hey Kai, I just found a way to aggregate the blog posts in case you haven't figured it out yet - http://blog.henryong.com/2008/06/15/how-to-customize-the-content-query-web-part-xsl-to-aggregate-blog-posts/

i want to get Published Date ?

The Pubished date is part of the publishing feature and so is not in the default fields in SharePoint. I believe the Publishing date is 'PublishingStartDate' and the end date is 'PublishingExpirationDate'. These values will be NULL if none were specified when the page was published.

Thank you...great effort!!

I'm trying to run a CAML-based SPQuery on a document list, to search within the actual contents of the documents. I do not know which field contains these contents to use as my FieldRef for this type of search, any ideas? Or am I on a completely wrong track here?? Thanks in advance....

Unfortunately you are on the wrong track. You can only use the SPQuery to query metadata, not the actual content of the document. You might want to look at the FullTextSqlQuery class.

Hi, I'm trying to get a overview about the latest Blog entries via the Content Query Web Part. The Title and the PublishingRollupImage are no prob to display but the needed Body-Tag does not appear in the following list: P:ListId P:WebId P:ID P:Title P:FileRef P:_x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_ P:Modified P:Author P:Editor P:Created P:PublishingRollupImage P:_Level P:Comments P:ImageUrl P:LinkUrl P:PubDate P:Description P:Style P:GroupStyle P:__begincolumn P:__begingroup So the question is: where is the body-data stored (just for blog entries)? Thanks in advance

Kai, The post body is stored in a column called 'Body' and should be available. Where did you get this list from? --Vince

Vince, I added a new xsl-template to the itemstyle.xsl <xsl:template name="Fields" match="Row[@Style='Fields']" mode="itemstyle"> <xsl:for-each select="@*"> P:<xsl:value-of select="name()" /> </xsl:for-each> </xsl:template> The CQWP has only the right to show data from one List (the blog) Kai

Vince, I added a new xsl-template to the itemstyle.xsl <xsl:template name="Fields" match="Row[@Style='Fields']" mode="itemstyle"> <xsl:for-each select="@*"> P:<xsl:value-of select="name()" /> </xsl:for-each> </xsl:template> The CQWP has only the right to show data from one List (the blog) Kai

Vince, I know that in most of the lists there is a field / column called body but as you can see in my first post - the body-tag is missing..... Has anyone an idea where to get the data from? --Kai

Kai, My initial guess (without checking) would be to change the default view of the Posts list to include the Body field. It maybe that that is defining the fields you get in the CBQWP. --Vince

Vince, I changed the default view but I didn't get the expected result... But thanks for your support! I try to figure it out - and let you know --Kai

Hi! I try the follow query: <QueryPacket xmlns='urn:Microsoft.Search.Query'> <Query> <SupportedFormats> <Format>urn:Microsoft.Search.Response.Documentocument</Format> </SupportedFormats> <Context> <QueryText language='en-US' type='MSSQLFT'>select path, author, editor from scope() where (contains(path, '"*.doc"') or contains(path, '"*.pdf"'))--</QueryText> </Context> <TrimDuplicates>false</TrimDuplicates> <Range> <StartAt>1</StartAt> <Count>1024</Count> </Range> </Query> </QueryPacket> And the an error: <ResponsePacket xmlns=\"urn:Microsoft.Search.Response\"> <Response domain=\"\"> <Status>ERROR_SERVER</Status> <DebugErrorMessage>Microsoft.SharePoint.Search.Query.InvalidPropertyException</DebugErrorMessage> </Response> </ResponsePacket> This happens if I ask for "editor" otherwise I get an error. Does any know why? Or a workaround for this? TIA. Regards, Julio

Both file size internal names do not work.

The very easy way to display costum tabs: 1. find out how the name of the tab is; 2. insert a CQWP into the Page 2.5 export the webpart 3. edit the CommonViewFields property insert the tabname and the datatype 4. import the webpart again 5. Edit the Itemstyle.xsl

I have an application in which I make reference to search.asmx to obtain different results of scopés that they are in the servant sharepoin 2007, but of 4 scopés which I have single I can consult 1 of them,somebody knows so that. In addition to that only scope, single I can consult the fields by default(title, path, etc), if I add some other gives the error me of invalid property, somebody can help me and if I do not occur to understand says to me.

I've the same problem of Kai, I don't have a field/column name called "Body" and I can't get the body of the blog post with the "Description" field. I've followed the steps on the blog http://blog.henryong.com/2008/06/15/how-to-customize-the-content-query-web-part-xsl-to-aggregate-blog-posts/ of Henry Ong (very usefull, thanks Henry!!) but I still can get the CQWP working... :( I'm using Community Kit for SharePoint Blogs of http://www.codeplex.com/CKS I was checking too the post of Heather Solomon http://www.heathersolomon.com/blog/articles/customitemstyle.aspx but I can't get it works!! If I use the XSL: <xsl:for-each select="@*"> P:<xsl:value-of select="name()" /> </xsl:for-each> I can see a field called "Description" and if I check the content type, the internal name of this field is "Body" but I've tried with different values for the "fieldtype" (Note/RichHTML/Description/Body/Text) and still trying to make it works. Did you find any solution Kai ??? Thanks :)

I've the same problem of Kai, I don't have a field/column name called "Body" and I can't get the body of the blog post with the "Description" field. I've followed the steps on the blog http://blog.henryong.com/2008/06/15/how-to-customize-the-content-query-web-part-xsl-to-aggregate-blog-posts/ of Henry Ong (very usefull, thanks Henry!!) but I still can get the CQWP working... :( I'm using Community Kit for SharePoint Blogs of http://www.codeplex.com/CKS I was checking too the post of Heather Solomon http://www.heathersolomon.com/blog/articles/customitemstyle.aspx but I can't get it works!! If I use the XSL: <xsl:for-each select="@*"> P:<xsl:value-of select="name()" /> </xsl:for-each> I can see a field called "Description" and if I check the content type, the internal name of this field is "Body" but I've tried with different values for the "fieldtype" (Note/RichHTML/Description/Body/Text) and still trying to make it works. Did you find any solution Kai ??? Thanks :)

How to get a item url. I create a article list. The list include: Title, ImageUrl, Summary, Body. The brief list include: Title, ImageUrl, Summary. How to get Item Url for display Article Detail when I click Image (src=ImageUrl). If I used: <HTML><![CDATA[<a href="/Lists/]]></HTML> <ListProperty Select="Title" /> <HTML><![CDATA[/ViewDetail.aspx?ID=]]></HTML> <Column Name="ID" /> the link is work well but when I rename List (<ListProperty Select="Title" /> is changed) the link is not worked.

How to get a item url. I create a article list. The list include: Title, ImageUrl, Summary, Body. The brief list include: Title, ImageUrl, Summary. How to get Item Url for display Article Detail when I click Image (src=ImageUrl). If I used: <HTML><![CDATA[<a href="/Lists/]]></HTML> <ListProperty Select="Title" /> <HTML><![CDATA[/ViewDetail.aspx?ID=]]></HTML> <Column Name="ID" /> the link is work well but when I rename List (<ListProperty Select="Title" /> is changed) the link is not worked.

In these variable there is field called Editor , which gives us user name with email (hyperlinked) i just want to get modified user name only not email address, so can i get this

hi, iunable to get field post title and post from blog site "Comments" list. can any one guide me in right way.

What is the actual object being used when you say 'User'?