R – SharePoint CAML search on Modified By

camlmosssharepoint

What do I use in the value to return results using the following CAML query in MOSS2007? The query is currently not returning any results. I have tried using the Account Name and the name displayed in the list but to now avail.

<Eq><FieldRef Name='Modified_x0020_By' /><Value Type='User'>domain\someusername</Value></Eq>

Best Answer

First of all, I see the internal name for the "Modified By" column is actually "Editor".

This worked for me:

<Where><Eq><FieldRef Name='Editor'/><Value Type='Text'>LastName, FirstName</Value></Eq></Where>

Related Solutions

SharePoint list CAML query using CONTAINS

Leave out the surrounding Query tag, just use:

<Where><Contains><FieldRef Name='Title' /><Value Type='Text'>2</Value></Contains></Where>

SPQuery adds the Query tag itself.

Caml query to fetch data from Sharepoint list for a specific Date

Sharepoint accepts datetime in ISO 8601 Datetime form in UTC. The format is

yyyy-MM-ddTHH:mm:ssZ

So for your example you can use

2011-05-18T00:00:00Z

SPUtility does provide a method to do this conversion. For creating this in Java you can use the following method:

private String changeDateToISO8601(Date date) {
    TimeZone timeZone = TimeZone.getTimeZone("UTC");
    DateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss'Z'");
    dateFormat.setTimeZone(timeZone);
    String convertedDate = dateFormat.format(date);
    return convertedDate;
}

P.S. You may not be able to find both the items using this just by <Eq> tag as there may be time difference. For this to work you need to enclose the dates in <Leq> and <Geq> tags.

Best Answer

Related Solutions

SharePoint list CAML query using CONTAINS

Caml query to fetch data from Sharepoint list for a specific Date

Related Topic