로그인
 
홈라이브러리학습다운로드지원커뮤니티포럼
Resources for IT Professionals >
> 
> 
Checked Out column in Content Query Web part filter is missing, It was in SharePoint 2007 but missing in 2010?

Answered Checked Out column in Content Query Web part filter is missing, It was in SharePoint 2007 but missing in 2010?

  • 2012년 5월 2일 수요일 오후 6:43
     
     
    로그인하여 투표
    0

    SharePoint 2007 Content Query Out of Box Web Part does show Checked Out To column in the filters drop down, But SharePoint 2010 is not showing this column.  I am selecting all content types to see all columns in filter but i don't see checked out to column in there. Is it by design in SharePoint 2010 OR a defect OR am i missing any step?

    Moonis Tahir MVP SharePoint,MCTS SharePoint 2010/2007, MCPD.net, MCSD.net, MCTS BizTalk 2006,SQL 2005

     

모든 응답

  • 2012년 5월 3일 목요일 오전 5:19
    중재자
     
     
    로그인하여 투표
    0

    Hi Moonis,

    I understand that the Checked Out To column is missing in the filters drop down of your content query web part in SharePoint 2010  .The fact is that when you set the content query web part to display items from a SharePoint Document Library ,the Checked Out To column is there .But when you set the content query web part to show items in a SharePoint List ,the  column will not show up .This is by design .Because the list items cannot be checked out . Check in/out is only available on libraries .So there won’t be any Checked Out to column in a list .

    Thanks,

    Entan Ming

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contacttnmff@microsoft.com.

    Entan Ming

    TechNet Community Support

     
  • 2012년 5월 3일 목요일 오후 3:55
     
     
    로그인하여 투표
    0

    I am trying to pull documents based on Content Query web part that are checked out to me for a particular meta data from accross the site. This is working for SP 2007 but there is no way i could acheive it in 2010 using out of box web part. You mentioned about list. Just to clarify, i am not in the list. I am selecting  document content type in content query web part in 2010, It does not give me checked out to column.

    Moonis Tahir MVP SharePoint,MCTS SharePoint 2010/2007, MCPD.net, MCSD.net, MCTS BizTalk 2006,SQL 2005

     
  • 2012년 5월 4일 금요일 오전 1:44
    중재자
     
     답변됨
    로그인하여 투표
    0

    Hi  Moonis ,

    I can reproduce your issue when select the content query web part source as ‘Show items form all sites in this site collection ’ or ‘Show items from the following site and all subsites ’ .The columns in the filters are get form the site columns .But  the Checked Out To column is not a site column  .When you point to a specific document library ,the Checked Out To column will show up .

    Thanks,

    Entan Ming

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contacttnmff@microsoft.com.

    Entan Ming

    TechNet Community Support

     
  • 2012년 5월 15일 화요일 오후 7:07
     
     
    로그인하여 투표
    0
    I need to pull all documents that are checked out to logged in user using content query web part. Suggestion mentioned above only work on a single document library selection in CQWP. Checked Out To column does not appear if i want to say All documents etc.

    Moonis Tahir MVP SharePoint,MCTS SharePoint 2010/2007, MCPD.net, MCSD.net, MCTS BizTalk 2006,SQL 2005

     
  • 2012년 5월 16일 수요일 오전 1:52
    중재자
     
     
    로그인하여 투표
    0

    Hi ,

    The OOTB content query web part will not show the checked out to column as a filter when you choose to show documents from multiple document libraries .You need to customize the content query web part or create a new web part .Creating a new web part to query  items will use the SPSiteDataQuery Class .You can query from a specific list type and add filters to get specific items .

    For more information ,please refer to this site:

    SPSiteDataQuery Class: http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spsitedataquery.aspx

    SharePoint 2010: get All checked out documents report with checkedOut column: http://aanuwizard.wordpress.com/2010/07/22/sharepoint-2010-get-all-checked-out-documents-report-with-checkedout-column/

    Thanks,

    Entan Ming

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contacttnmff@microsoft.com.

    Entan Ming

    TechNet Community Support

     
  • 2012년 5월 16일 수요일 오후 3:10
     
     
    로그인하여 투표
    0

    Thanks Entan,

    I am well aware of the other approach of custom web part and using SPSiteDataQuery etc. My point was that a functionality was in the SharePoint 2007, It is no longer in SP 2010, this simply frustrate the customer as they are heavily using Checked Out To column in SP 2007. Customer use only out of box features of SharePoint, they do not allow custom development. I am not convinced on why SP2010 does not have it for CQWP if SP 2007 had it.

    Moonis Tahir MVP SharePoint,MCTS SharePoint 2010/2007, MCPD.net, MCSD.net, MCTS BizTalk 2006,SQL 2005

     
  • 2012년 5월 25일 금요일 오전 8:28
     
     제안된 답변 코드 있음
    로그인하여 투표
    2

    Hi,

    You can get all checked out to me documents if you do like this:

    • Add the CQWP to your page
    • Set it to filter on Document libraries
    • Give it a name in "Description"
    • Export it and open it in Notepad
    • Replace the property-row of "QueryOverride" with this
    <property name="QueryOverride" type="string"><![CDATA[<Where><Eq><FieldRef Name="CheckoutUser" LookupId="TRUE"/><Value Type="Integer"><UserID/></Value></Eq></Where>]]> </property>

    Now, either add it to your web part library or upload it while adding it to the page.

    There is also a property called "UseCache" that you could set to "false", depending on what load you have on your site. That way, any changes will be reflected at once when you refresh the page.

    Blog: Married to SharePoint Twitter: @SPNiax

    • 답변으로 제안됨 leSasch 2013년 4월 7일 일요일 오전 9:39
    •