caml query is not working to get checked out files by specific user only

Question

Loop through all the folders in document library and fetch checked out files by specific user only

Have you tried the userID instead of the userName? – Danny '365CSI' Engelman Apr 20 '17 at 7:42 — Danny '365CSI' Engelman, Apr 20 '17 at 7:42
Danny is right you just need $user.Id – Bunzab Apr 20 '17 at 8:10 — Bunzab, Apr 20 '17 at 8:10

Divya Sharma · Accepted Answer · 2017-04-20 08:33:54Z

2

<Where>
    <Eq>
        <FieldRef Name="CheckoutUser" LookupId="True" />
        <Value Type="Integer">USERID</Value>
    </Eq>
</Where>

Use the above where clause to find the checked out file by a specific user and replace "USERID" with that user's id.

answered Apr 20 '17 at 8:27

Divya Sharma

8354 silver badges17 bronze badges

Thanks a million Divya, Danny and Bunzab, It solved my problem. – raju Apr 20 '17 at 11:02
You can use camljs.codeplex.com link for creating a CAML query. It shows how one can create CAML query using CamlJs-Console which is a Chrome extension. – Divya Sharma Apr 21 '17 at 4:19

add a comment |

1 Answer 1