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

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...

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 “Comput...

SharePoint Capacity Management and Sizing Overview

Capacity management   is an ongoing process, because no implementation remains static with regard to content and usage. You need to plan for growth and change, so that your SharePoint Server 2013–based environment can continue to deliver an effective business solution. Capacity Planning  is only one part of the capacity management cycle. It is the initial set of activities that brings the design architect to the point where there is an initial architecture that the architect believes will best serve the SharePoint Server 2013 deployment. The capacity management model includes additional steps to help you validate and tune the initial architecture, and provides a feedback loop for re-planning and optimizing the production environment until it can support design goals with optimal choices of hardware, topology, and configuration. Capacity management versus capacity planning Capacity management extends the concept of capacity planning to express a cyclical appr...