Display all checked out files from current user (en)


Display all checked out files from current user en Title

This post should help you to get all the checked out documents of the current user.
I will show you how to display them in an Content Search web part for the entire Site Collection.

1. You need to create a new Managed Property in your Search Schema.
2. Open you SharePoint Central Administration and under your Search Service click on Search Schema.

Display all checked out files from current user (en)_1

3. Click on New Managed Property

Display all checked out files from current user (en)_2

4. You need to configure the settings here like in the picture below.
a. Property name (1): I typed in “CheckedOutByUser” (to find it later easily)
b. Description (2): Not needed but you know: “More information is always better”
c. Type (3): Text
d. Searchable (4): Yes
e. Queryable (5): Yes
f. Retrievable (6): Yes

All the other values could be left by default.

Display all checked out files from current user (en)_3

Display all checked out files from current user (en)_4

 

 

5. Under Mappings to crawled properties select Include content from all crawl properties and then click on Add a mapping (7).

Display all checked out files from current user (en)_5

 

6. The Crawled property selection dialog should open and under the Search for a crawled property name, enter the text “check” (8) and click on find (9). Then select “ows_CheckoutUser” (10) and click OK (11).

Display all checked out files from current user (en)_6

 

7. The property is now mapped. Click the OK button and you created a new managed property. Good Job!
8. Now it’s time to do a crawl. (For me an incremtal crawl was enough).

9. Next navigate to the page where you need to add the Content Search web part. Edit the page click on Add a Web part, under the categories tab in the web part gallery select Content Rollup and then select Content Search and click on Add.

10. Once the Web part is added to the page, edit the web part, you will get a Content Search property window. Click on Change Query and the Query Building Dialog should appear. (The following pictures are in German, but you should get it to work, otherwise don’t be afraIT to ask).

Display all checked out files from current user (en)_7

 

11. In the opened dialog your query text should look quite similar to the picture below. Of course the path could be different of your SharePoint.

12. First set the path (1) to your SharePoint url. Next add the Keywordfilter (2) with the value “Only Items”.

Hint: If you switch into the Quickmode (A) you can choose Documents (System) in the Select a Query field. Then you should get in the advanced mode something similar like:

FileExtension:doc OR FileExtension:docx OR FileExtension:xls OR FileExtension:xlsx OR FileExtension:ppt OR FileExtension:pptx OR FileExtension:pdf

13. Last step is to select the right property filter. Select the created metadata property “CheckOutByUser” from the list. And set the query as “CheckOutNyUser contains Name of the user who runs the query” (3).

Display all checked out files from current user (en)_8

 

14. Click on OK then save the web part.

15. In the picture below you can see my result.

I used a custom display template to show the checked out documents, but you can stick with the default one to test it.

Display all checked out files from current user (en)_9

 

As always: Don’t be afraIT to ask if you have some issues or want a Step-by-Step guide in German.

4 responses to “Display all checked out files from current user (en)”

  1. Hi, Patrick!

    I have tried to do this on our SharePoint Online tenant but it doesn’t work.
    I follow your steps but the CheckOutByUser property doesn’t show up in “Property filter”-list (Eigenshaftenfilter). Any ideas why?

    BTW; I noticed there already is a managed property named CheckoutUserOWSUSER, which looks promising, Unfortunately, that doesn’t show either.

    Thanks!
    /Fredrik

    • Hey, i only tried the blog post with my SharePoint 2013 Environment. If you figure out who to do that in SPO, any feedback is appreciated!

  2. Hi Patrick,

    Thanks for this! It worked! But, in my SharePoint 2016, I don’t have the “List Table Control”/”List Table Item” options. Did you create this yourself?

Leave a Reply

Your email address will not be published. Required fields are marked *