Discussion Board - How to get last posted by info and first 50 characters of message posted<p>We have a discussion board under its own site collection. We want to display the last three postings on another site collection, so we are using the CQWP to get that info displayed. My question is, how can we display the person's name that posted the last reply to that subject and how can we get to the actual text that person entered in his/her reply?<br/><br/>We are able to display the title of the subject, the number of replies but we are strugling to get the 'Editor' and 'Body' of the last entry to display... I guess we need to get the internal name for these fields but we are having difficulty finding that. Any help is appreciated.</p>© 2009 Microsoft Corporation. All rights reserved.Mon, 03 Aug 2009 16:45:05 Z639d1249-c099-4417-b9be-c20b965e934fhttp://social.technet.microsoft.com/Forums/en-US/sharepointcollaboration/thread/639d1249-c099-4417-b9be-c20b965e934f#639d1249-c099-4417-b9be-c20b965e934fhttp://social.technet.microsoft.com/Forums/en-US/sharepointcollaboration/thread/639d1249-c099-4417-b9be-c20b965e934f#639d1249-c099-4417-b9be-c20b965e934fricardo_plcmhttp://social.technet.microsoft.com/Profile/en-US/?user=ricardo_plcmDiscussion Board - How to get last posted by info and first 50 characters of message posted<p>We have a discussion board under its own site collection. We want to display the last three postings on another site collection, so we are using the CQWP to get that info displayed. My question is, how can we display the person's name that posted the last reply to that subject and how can we get to the actual text that person entered in his/her reply?<br/><br/>We are able to display the title of the subject, the number of replies but we are strugling to get the 'Editor' and 'Body' of the last entry to display... I guess we need to get the internal name for these fields but we are having difficulty finding that. Any help is appreciated.</p>Thu, 16 Apr 2009 16:52:53 Z2009-04-16T16:52:53Zhttp://social.technet.microsoft.com/Forums/en-US/sharepointcollaboration/thread/639d1249-c099-4417-b9be-c20b965e934f#4463753c-883f-4795-a602-7503636ac8behttp://social.technet.microsoft.com/Forums/en-US/sharepointcollaboration/thread/639d1249-c099-4417-b9be-c20b965e934f#4463753c-883f-4795-a602-7503636ac8beSteve Sofianhttp://social.technet.microsoft.com/Profile/en-US/?user=Steve%20SofianDiscussion Board - How to get last posted by info and first 50 characters of message posted<p>Yes you would need to get the internal name of these fields in order to display them.  And in order to do that, you would to export your CQWP, edit the web part markup and import the web part back.<br/><br/>Heather Solomon has a good article on how to do this.  You can find the article at : <a href="http://www.heathersolomon.com/blog/articles/CustomItemStyle.aspx">http://www.heathersolomon.com/blog/articles/CustomItemStyle.aspx</a><br/><br/>Hope this helps.</p>Fri, 03 Jul 2009 01:31:01 Z2009-07-03T01:31:01Zhttp://social.technet.microsoft.com/Forums/en-US/sharepointcollaboration/thread/639d1249-c099-4417-b9be-c20b965e934f#12b4bd12-f02b-4b6b-b470-bece0cc045dahttp://social.technet.microsoft.com/Forums/en-US/sharepointcollaboration/thread/639d1249-c099-4417-b9be-c20b965e934f#12b4bd12-f02b-4b6b-b470-bece0cc045daJenny Fergeushttp://social.technet.microsoft.com/Profile/en-US/?user=Jenny%20FergeusDiscussion Board - How to get last posted by info and first 50 characters of message posted<p>Hi Ricardo!</p> <p>Regarding you question on how to display the first 50 characters, this blogpost might be helpful for you:</p> <p><a href="http://mdasblog.wordpress.com/2009/01/20/displaying-the-first-n-words-of-a-long-text-column-with-xsl/">http://mdasblog.wordpress.com/2009/01/20/displaying-the-first-n-words-of-a-long-text-column-with-xsl/</a><br/><br/>Good Luck!<br/>Jenny</p>Mon, 06 Jul 2009 11:26:29 Z2009-07-06T11:26:29Zhttp://social.technet.microsoft.com/Forums/en-US/sharepointcollaboration/thread/639d1249-c099-4417-b9be-c20b965e934f#36ee220a-950f-44b0-b13d-437a20f39f55http://social.technet.microsoft.com/Forums/en-US/sharepointcollaboration/thread/639d1249-c099-4417-b9be-c20b965e934f#36ee220a-950f-44b0-b13d-437a20f39f55ricardo_plcmhttp://social.technet.microsoft.com/Profile/en-US/?user=ricardo_plcmDiscussion Board - How to get last posted by info and first 50 characters of message postedthank you for the link jenny--this is exactly what i was looking for.Mon, 03 Aug 2009 16:44:17 Z2009-08-03T16:44:17Zhttp://social.technet.microsoft.com/Forums/en-US/sharepointcollaboration/thread/639d1249-c099-4417-b9be-c20b965e934f#f6087b56-6e68-4542-9822-dc96566b027fhttp://social.technet.microsoft.com/Forums/en-US/sharepointcollaboration/thread/639d1249-c099-4417-b9be-c20b965e934f#f6087b56-6e68-4542-9822-dc96566b027fricardo_plcmhttp://social.technet.microsoft.com/Profile/en-US/?user=ricardo_plcmDiscussion Board - How to get last posted by info and first 50 characters of message postedthanks steve, this helps find the internal names.Mon, 03 Aug 2009 16:45:05 Z2009-08-03T16:45:05Z