http://www.endusersharepoint.com/STP/ Paul Grenier, Lead Moderator en Wed, 01 Apr 2009 02:11:45 +0000 http://www.endusersharepoint.com/STP/topic/share-annoucement-from-main-site-with-sub-sites-filtered#post-5511 Mon, 30 Mar 2009 15:45:52 +0000 bensch 5511@http://www.endusersharepoint.com/STP/ <p>Cool!</p> <p>Now you're talking ... it's a bit involved but is totally doable.</p> <p>I would start here if I were you:</p> <p><a href="http://www.heathersolomon.com/blog/articles/CustomItemStyle.aspx" rel="nofollow">http://www.heathersolomon.com/blog/articles/CustomItemStyle.aspx</a></p> <p><a href="http://blogs.msdn.com/ecm/archive/2006/10/25/configuring-and-customizing-the-content-query-web-part.aspx" rel="nofollow">http://blogs.msdn.com/ecm/archive/2006/10/25/configuring-and-customizing-the-content-query-web-part.aspx</a></p> <p><a href="http://blogs.sharepointguys.com/brendon/sharepoint-2007/programming/connecting-the-cqwp-without-changing-itemstyle-xsl/" rel="nofollow">http://blogs.sharepointguys.com/brendon/sharepoint-2007/programming/connecting-the-cqwp-without-changing-itemstyle-xsl/</a></p> <p>I have used that info to create exactly what you described re. summaries.</p> <p>Cheers<br /> Ben </p> http://www.endusersharepoint.com/STP/topic/share-annoucement-from-main-site-with-sub-sites-filtered#post-5509 Mon, 30 Mar 2009 15:24:08 +0000 illegal operation 5509@http://www.endusersharepoint.com/STP/ <p>Thank You!<br /> That did it!</p> <p>I had originally added the columns to my list before i created the site column. So I didn't use the 'Add from existing site columns option'. It all makes sense now!</p> <p>Now I need to figure out how to get a summary of the announcements on the page. The first so many words or something. </p> http://www.endusersharepoint.com/STP/topic/share-annoucement-from-main-site-with-sub-sites-filtered#post-5503 Mon, 30 Mar 2009 14:31:51 +0000 bensch 5503@http://www.endusersharepoint.com/STP/ <p>Hi</p> <p>I'd do the following - (NB. you must set up the site column first then add that column to your lists using the 'Add from existing site columns option')</p> <p>1] Set up your site column at the top level of your site collection as a choice type with values Yes + No as radio buttons (the default yes/no checkbox field type is not my fave)</p> <p>2] Add your site column to your lists (or better still content type - this is another discussion though) and ensure that you update some announcements to Broadcast* [or whatever your column name is] =Yes</p> <p>3] Add a content query web part to your web part pages and set the query to display</p> <p>-----&gt; Show all items from all sites in this site collection<br /> -----&gt; Show items from this list type: Announcements<br /> -----&gt; Show items of this content type: &lt;All Content Types&gt;<br /> -----&gt; Additional Filters: Show items when: Broadcast* - is equal to - Yes<br /> -----&gt; And: Expires is greater than or equal to [Today] === this is optional, it will stop old announcements appearing though.</p> <p>Good luck!</p> <p>Cheers<br /> Ben </p> http://www.endusersharepoint.com/STP/topic/share-annoucement-from-main-site-with-sub-sites-filtered#post-5502 Mon, 30 Mar 2009 13:59:15 +0000 illegal operation 5502@http://www.endusersharepoint.com/STP/ <p>Did I stump the panel :)<br /> What do I win!!!</p> <p>It really seems like it should work tho, but for some reason the filter won't work within the content query, always no records when I try and use it on my flag field.</p> <p>I posted my steps above, does anyone see anything I may have missed? </p> http://www.endusersharepoint.com/STP/topic/share-annoucement-from-main-site-with-sub-sites-filtered#post-5489 Mon, 30 Mar 2009 08:39:50 +0000 illegal operation 5489@http://www.endusersharepoint.com/STP/ <p>Does anyone have an idea to what I could have done wrong? </p> http://www.endusersharepoint.com/STP/topic/share-annoucement-from-main-site-with-sub-sites-filtered#post-5482 Sat, 28 Mar 2009 13:07:28 +0000 illegal operation 5482@http://www.endusersharepoint.com/STP/ <p>I'm not sure what I'm doing wrong, here is what I've done.</p> <p>1. Created an annoucement list in the main site. (Added a column 'flag' yes/no)<br /> 2. Created an annoucement list in the sub site. (Added a column 'flag' yes/no)<br /> 3. Created a new site column to include 'flag'<br /> 4. Created a new page, added the content query web part.<br /> 5. Configured the web part to look at all annoucement lists starting with the main site and all sub sites.<br /> 6. Added a filter in the content query web part, saying if 'flag' equals 1</p> <p>Is this correct? Right now as soon as I put anything in the filter area (1 or 0) it stops working and displays nothing on the page. </p> http://www.endusersharepoint.com/STP/topic/share-annoucement-from-main-site-with-sub-sites-filtered#post-5481 Sat, 28 Mar 2009 11:14:30 +0000 illegal operation 5481@http://www.endusersharepoint.com/STP/ <p>Anyone have any ideas why the filter doesn't work within the content query webpart, but does work in a custom view?</p> <p>I'm so close to having this done, but can't get the filter to work :( </p> http://www.endusersharepoint.com/STP/topic/share-annoucement-from-main-site-with-sub-sites-filtered#post-5472 Fri, 27 Mar 2009 17:15:23 +0000 illegal operation 5472@http://www.endusersharepoint.com/STP/ <p>This is wierd, </p> <p>So if I create a view on either of those lists, and then under the filter area 'flag' equals 1</p> <p>it works for that list, but if I got to the content query and do the same thing. It doesn't work, returns no results no matter what I put in that field.</p> <p>Is there something different for the content query that needs to be done to filter a yes/no field? </p> http://www.endusersharepoint.com/STP/topic/share-annoucement-from-main-site-with-sub-sites-filtered#post-5461 Fri, 27 Mar 2009 15:36:05 +0000 illegal operation 5461@http://www.endusersharepoint.com/STP/ <p>Thanks, I've added the site column and now see it listed in the content query.</p> <p>So the field I have, is a yes/no box.<br /> In the filter I set it to display where 'flag' equals=1</p> <p>but nothing is appearing, a yes/no field is 1/0 right?</p> <p>I also tried using Yes, and it didn't work either. </p> http://www.endusersharepoint.com/STP/topic/share-annoucement-from-main-site-with-sub-sites-filtered#post-5457 Fri, 27 Mar 2009 14:13:38 +0000 gmaass 5457@http://www.endusersharepoint.com/STP/ <p>Content Query web part can only filter on Site Columns, so if you just added a column to your list, you will need to create a site column (or, for long term maintainability, create a content type and have it use your site columns). </p> http://www.endusersharepoint.com/STP/topic/share-annoucement-from-main-site-with-sub-sites-filtered#post-5456 Fri, 27 Mar 2009 14:11:40 +0000 gmaass 5456@http://www.endusersharepoint.com/STP/ <p>Oops, yep, Content Query Web Part... </p> http://www.endusersharepoint.com/STP/topic/share-annoucement-from-main-site-with-sub-sites-filtered#post-5455 Fri, 27 Mar 2009 13:47:54 +0000 illegal operation 5455@http://www.endusersharepoint.com/STP/ <p>I've got the content query on the page, but under filter there is a dropdown of all these different items, but the field I want to filter on isn't there.</p> <p>Is that where I should be looking?<br /> or is there somewhere else I need to go? </p> http://www.endusersharepoint.com/STP/topic/share-annoucement-from-main-site-with-sub-sites-filtered#post-5454 Fri, 27 Mar 2009 13:00:57 +0000 illegal operation 5454@http://www.endusersharepoint.com/STP/ <p>[quote]@gmaass: you mean Content Query Web Part... [/quote]</p> <p>Thanks, I had a feeling that's what he meant, but just wanted to make sure.</p> <p>So I have the content query part on a page, and I have it set to show annoucements from the main site, and it's including all the annoucements for the sub sites. But how do I filter for it to only show certain announcements from each department, when the requirement is met? </p> http://www.endusersharepoint.com/STP/topic/share-annoucement-from-main-site-with-sub-sites-filtered#post-5453 Fri, 27 Mar 2009 12:47:17 +0000 illegal operation 5453@http://www.endusersharepoint.com/STP/ <p>Thanks for replying,</p> <p>Ya, after I posted that, I thought export was not what I wanted to do.</p> <p>I've added the Content Editor webpart to a page, now where do I have the options to query?</p> <p>I only see the Rich text editor button, and Source editor.</p> <p>Or did you mean the content Query webpart? </p> http://www.endusersharepoint.com/STP/topic/share-annoucement-from-main-site-with-sub-sites-filtered#post-5452 Fri, 27 Mar 2009 12:45:51 +0000 Christophe 5452@http://www.endusersharepoint.com/STP/ <p>@gmaass: you mean Content Query Web Part... </p> http://www.endusersharepoint.com/STP/topic/share-annoucement-from-main-site-with-sub-sites-filtered#post-5451 Fri, 27 Mar 2009 12:26:48 +0000 gmaass 5451@http://www.endusersharepoint.com/STP/ <p>This is what Content Editor Web Parts are designed to do.</p> <p>It is important to remember that Sharepoint is at its core a database, so the concept of "exporting" so that something appears in more than one place does not apply. You should never be in the position of having more than one instance of any entity- you can make one entity appear in multiple places. Content Editor Web Part essentially allows you to query the content database for any content type that meets a specific criteria- for example, any announcement from Site X that has Column Y marked as true.</p> <p>We use this to aggregate announcements flagged as "general interest" from all of our department sites to our main portal page </p> http://www.endusersharepoint.com/STP/topic/share-annoucement-from-main-site-with-sub-sites-filtered#post-5450 Fri, 27 Mar 2009 12:10:54 +0000 illegal operation 5450@http://www.endusersharepoint.com/STP/ <p>I don't see a way to edit my post, but I need to change the request.</p> <p>What we would really like to do is this, </p> <p>Have an announcement list in our main site, and also a annoucement list in our sub site.<br /> What we would like to do is make it so, sometimes the annoucements in the sub site lists should appear in the main site list.</p> <p>Is there a way to either export an annoucement from the sub site list to the main site announcement list? Or a way for the main list, to look for a flag or somesort of marker in the sub sites lists and get any that are marked? </p> http://www.endusersharepoint.com/STP/topic/share-annoucement-from-main-site-with-sub-sites-filtered#post-5447 Fri, 27 Mar 2009 11:33:20 +0000 illegal operation 5447@http://www.endusersharepoint.com/STP/ <p>Hi,</p> <p>I'm hoping someone knows how to do this.</p> <p>We have an annoucement list on our main site, and what we would like to do is share the annoucements with sub sites.</p> <p>So what I did so far was use the content query web part, and was able to display the main list in the sub site. </p> <p>But next, what we would like to do is have only certain annoucements appear in the sub sites pages. I was thinking I could create a column in the main list, that the user could check if they want it to show in the sub site too.</p> <p>But I'm not sure how to filter the list within the sub site to look at that column. Is there a way to do this? Or another method to do this? </p>