How to get list of documents checked out by me in view?

Question

I have created a document library definition in which I want to insert a view that shows all documents which are checked out by me.

The declarative code is:

<View BaseViewID="140" Type="HTML" WebPartZoneID="Main" DisplayName="CheckedOutView" DefaultView="FALSE" MobileView="FALSE" MobileDefaultView="FALSE" SetupPath="pages\viewpage.aspx" ImageUrl="/_layouts/15/images/dlicon.png?rev=23" Url="Forms/Checkedout.aspx" Hidden="FALSE">
   <Toolbar Type="Standard" />
    <ViewFields>
      <FieldRef Name="DocIcon"/>
      <FieldRef Name="LinkFilename"/>
      <FieldRef Name="Modified"/>
      <FieldRef Name="Editor"/>         
    </ViewFields>
    <RowLimit>20</RowLimit>
    <Query>
      <OrderBy>
        <FieldRef Name="Created"/>
      </OrderBy>
      <Where>
        <Eq>
          <FieldRef Name="CheckoutUser"/>
          <Value Type="Integer">
            <UserID Type="Integer"/>
          </Value>
        </Eq>
  </View>

Now what query should I write to list all documents that are checked out by me?

The reason behind achieving this by creating view is because I found one comment here. I created the view with the condition by UI and copied the declarative code by opening that view using SharePoint Designer. But not working in my case.

Answer 1

I'm having results with this query, please try it:

<Where><Eq><FieldRef Name="CheckoutUser" LookupId="TRUE"/><Value Type="Integer"><UserID/></Value></Eq></Where>

Answer 2

I don't have the VM available right now. But you could try the following:

Create the view from UI and then open the view by using SharePoint manager. Copy the query which is generated and then use it in your XML definition.

Answer 3

Please check if the following query helps:

<Query><Where><Eq><FieldRef Name="CheckoutUser"/><Value Type="Integer"><UserID Type="Integer"/></Value></Eq></Where></Query>