How To: Filter Lookup Field Values by Current User

I had been struggling with SharePoint 2007 trying to get the current user’s ID using SPServices and jQuery. I wanted to filter results based on a SharePoint user lookup field in a custom list. The issue I was struggling with, using SPServices, was that I wasn’t able to get the current user ID. I’m not sure, but I think it’s because I’m still using SharePoint 2007.

However, I stumbled across this solution which didn’t require me to know the ID of the user. And it worked like a charm (with one small change).

var userName = $().SPServices.SPGetCurrentUser({ fieldName: "Name" });
 
var query = '<Query>' +
                '<Where>' + 
                    '<Eq>' +
                        '<FieldRef Name="SharePointUser" />' +
                            '<Value Type="User">' + userName + '</Value>' +
                    '</Eq>' +
                '</Where>' +
            '</Query>'; 
 
$().SPServices({
    operation: "GetListItems",
    async: false,
    listName: "UserAccessList",
    CAMLViewFields: "<ViewFields><FieldRef Name='Title' /></ViewFields>",
    CAMLQuery: query,
    completefunc: function (xData, Status) {
      $(xData.responseXML).SPFilterNode("z:row").each(function() {
            // will return only results that match the current logged in user
            // in the 'SharePointUser' column
            console.log($(this).attr("ows_Title"));
      });
    }
});

This entry was posted on Wednesday, May 14th, 2014 at 3:00 pm and is filed under how to. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site. Tags: .

7 Comments (newest first)

  1. specialising in treatment of woodworm dry rot wet rot drybrook says:
    December 31, 2018 at 7:24 pm

    severe penetrating damp issue or damp under hydrostatic pressure cheltenham

    How To: Filter Lookup Field Values by Current User

  2. Connect new oven gloucester says:
    November 24, 2018 at 12:00 am

    bristol

    How To: Filter Lookup Field Values by Current User

  3. motor vehicle transportation and storage stroud says:
    November 23, 2018 at 8:26 pm

    Flat Battery jump start car gloucestershire

    How To: Filter Lookup Field Values by Current User

  4. regular police says:
    October 21, 2014 at 12:17 am

    regular police

    How To: Filter Lookup Field Values by Current User « damontimm.com

  5. unclebuck says:
    October 1, 2014 at 2:26 am

    unclebuck

    How To: Filter Lookup Field Values by Current User « damontimm.com

  6. garageurselfbuild says:
    September 26, 2014 at 8:25 am

    garageurselfbuild

    How To: Filter Lookup Field Values by Current User « damontimm.com

  7. simply click the following article says:
    September 23, 2014 at 7:44 am

    simply click the following article

    How To: Filter Lookup Field Values by Current User « damontimm.com