Scenario:
Can we generate a list of documents checked out to anyone – a list of all checked out documents not just Checked Out To me
Steps ( MOSS only ) :
1. Navigate to Home > View All Site Content > Content and Structures Reports > Create a new report with following CAML Query
<Where><Geq><FieldRef Name="CheckoutUser" LookupId="TRUE"/><Value Type="int">0</Value></Geq></Where>
2. Navigate to Site Action > Manage Content and Structure > Change the view to All Checked Out documents ( from right side view drop down)
12 comments:
Nice one Sandeep.
-nn
Kinky :)
Thank you!
You are great!
How to limit those to a Document library?
Check out concept applies to Document Library only
I just use instead of greater than zero. Also it should be noted that your query cannot have any spaces outside the tags. If your query doesn't work don't give up, keep checking that your fomatting is correct.
The query I am using to get a list of documents that have been checked out more than seven days:
CJ , I think there is one such Query already with OOTB installation.
Last Sever Days checked out documents
Is there a way to display who has the document checked out with this report?
hmm.. with custom webpart = yes
How to limit to subsite? means I need to see all checked-out documents from subsite only not from all sites? How do I modify where clause?
I need to validate but if you set CAML List Type to Web it should work.
Also in the treeview when you click a particular site and select the proper report from the View Drop Down then it should limit to that site only.
Can you explain how to do 'set CAML List Type to Web'? Is it possible to edit these reports into designer? if yes then please give me steps. Can you post your email address?
Post a Comment