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

SharePoint Framework extensions to Call Azure Function

In this article, we will talk about prerequisites, how to call Azure Function from SPFX extension, How to Create HHTP function, connect Visual Styuid editor to Azure and publish them, and Set Up CORS on the Azure Function, Create SharePoint Framework Extension, Azure Function, etc. Prerequisites :  Azure Subscriptions   VS code  Spfx Development Env  -   Step by steps details: https://docs.microsoft.com/en-us/sharepoint/dev/spfx/set-up-your-development-environment  Follow the below steps to create Azure Functions in the Azure portal.  Steps by steps guide:  https://docs.microsoft.com/en-us/sharepoint/dev/spfx/use-aadhttpclient-enterpriseapi    Reference :  https://docs.microsoft.com/en-us/answers/questions/430645/how-to-access-sharepoint-rest-api-in-my-function-a.html Step-1 : Login to Azure Portal (https://portal.azure.com/)   Step-2 : As highlighted below, click on the  + Create a resource, and click on “Compute”. Now, choose the “Function App”.   Or, for the same Option, you can sea

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(string masterPageUrl, string logoUrl)         {             masterPageUrl = GetMasterPageServerRelativeUrl(masterPageUrl);             Web.MasterUrl = masterPageUrl;