Skip to main content

SPServices Code Get Items From List in SharePoint 2013, 2010

$().SPServices({
        operation: "GetListItems",
        listName: "Episode Profile",
        CAMLViewFields: "<ViewFields>"+
         "<FieldRef Name='AirDate' /><FieldRef Name='Focus_x0020_ID' /><FieldRef Name='MR_x0020_Contact_x0020__x0023_1' /><FieldRef Name='MR_x0020_Contact_x0020__x0023_2' />"+
         "<FieldRef Name='PhotoEditor' /><FieldRef Name='AccountManager' /><FieldRef Name='Ingestor' /><FieldRef Name='Retoucher' /><FieldRef Name='Metadata' />"+
         "</ViewFields>",        
        CAMLQuery: "<Query><Where><Eq><FieldRef Name='ID'/><Value Type='Number'>"+ epid +"</Value></Eq></Where></Query>",
       
        completefunc: function (xData, Status) {
         //alert(Status);
    $(xData.responseXML).SPFilterNode("z:row").each(function() {
//Set Focus ID

//var airdate = $(this).attr("ows_AirDate");
var EAirDate = $(this).attr("ows_AirDate");
$("input[Title='ADate']").val(EAirDate);
//alert(EAirDate);
    var focus = $(this).attr("ows_Focus_x0020_ID");
         if(focus==null)
focus='';
else
focus=Math.round(focus);
    $("input[Title='Focus ID']").val(focus);
   
    var AccountManager= $(this).attr("ows_AccountManager");
if(AccountManager!= null)
{
  setpeoplefield("Account Manager",AccountManager);
}
    var retoucher = $(this).attr("ows_Retoucher");
             if(retoucher != null)
             {               
                setpeoplefield("Retoucher",retoucher);
                }
                var PhotoEditor= $(this).attr("ows_PhotoEditor");
                if(PhotoEditor != null)
                {
               setpeoplefield("Photo Editor",PhotoEditor);
}
var Ingestor = $(this).attr("ows_Ingestor");
                if(Ingestor != null)
                {
                setpeoplefield("Ingestor",Ingestor);
                }
                var Metadata= $(this).attr("ows_Metadata");
if(Metadata!= null)
{
setpeoplefield("Metadata",Metadata);
}
                var mrcontact1 =  $(this).attr("ows_MR_x0020_Contact_x0020__x0023_1");
                if(mrcontact1 != null)
                {
setpeoplefield("MR Contact #1",mrcontact1);
                }
               
                var mrcontact2 =  $(this).attr("ows_MR_x0020_Contact_x0020__x0023_2");
                if(mrcontact2 != null)
                {
setpeoplefield("MR Contact #2",mrcontact2);
                }
});
}
});

Comments

Popular posts from this blog

Build and Deploy a custom theme in SharePoint 2019: Using C# and Site features

Custom Theme and Branding are common to use cases and all kinds of business users like to have the personalized team and collaboration sites. today I am posting C# code that will help to build custom features for SharePoint 2019 site.   If need any assistance, I would be happy to help: kamal_pandey@outlook.com  ----------------------------- Code to build  custom features---------- using System; using System.Collections.Generic; using System.Globalization; using System.Linq; using System.Text; using System.Threading.Tasks; using Microsoft.SharePoint; using Microsoft.SharePoint.Utilities; namespace SharePointBranding.Code {     public class BrandingManager     {         public SPWeb Web { get; set; }         public BrandingManager(SPWeb web)         {             Web = web;         }         public void SetMasterPage(stri...

PowerShell For create Sub site in office 365

#Add references to SharePoint client assemblies and authenticate to Office 365 site Add-Type -Path "\Software\SharePoint 2013 Client Browser v1.7\Microsoft.SharePoint.Client.dll" Add-Type -Path "\Software\SharePoint 2013 Client Browser v1.7\Microsoft.SharePoint.Client.Runtime.dll" $Username = Read-Host -Prompt "Please enter your username" $Password = Read-Host -Prompt "Please enter your password" -AsSecureString $Site = "https://XXXXXXX.sharepoint.com/sites/Test2/" $Context = New-Object Microsoft.SharePoint.Client.ClientContext($Site) $Creds = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Username,$Password) $Context.Credentials = $Creds $csvLocation = "C:\Users\PS_SiteCollectionsToCreate.csv" $csv = Import-Csv $csvLocation #List Custom Templates $Templates = $Context.Site.GetWebTemplates("1033","0") $Context.Load($Templates) $Context.ExecuteQuery() $Templates | Whe...