Skip to main content

GetListItem and UpdateListItem using SPServices in MOSS 2007

GetListItem and UpdateListItem using SPServices in MOSS 2007

$(document).ready(function() {
var itemToUpdate = GetListItem();
UpdateListItem(itemToUpdate);
});

function GetListItem(){

var today = new Date();
var dayOfWeek = today.getDay();
var itemID = 0;
var out = "";

var titleField = "<FieldRef Name='Title' />";
var descriptionField = "<FieldRef Name='Description' />";

var viewFields = "<ViewFields>" + titleField + descriptionField + "</ViewFields>";
var myQuery = "<Query>" +
"<OrderBy>" +
"<FieldRef Name='ItemOrder' Ascending='True'/>" +
"</OrderBy>" +
"</Query>";

$().SPServices({
operation: "GetListItems",
async: false,
listName: "MyList",
CAMLQuery: myQuery,
  CAMLViewFields: viewFields,
completefunc: function (xData, Status) {
var activeItemAvailable = false;
$(xData.responseXML).SPFilterNode("z:row").each(function() {
strTitle = $(this).attr("ows_Title");
strDescription = $(this).attr("ows_Description");
itemID = $(this).attr("ows_ID");
});

$("#divID").html(out);
}
});
return itemID;
}

function UpdateListItem(itemToBeUpdated)
{
var today = new Date();
var lastTuesdayDate = today.GetLastTuesdayOfWeek().toISOString();
$().SPServices({
operation:"UpdateListItems",
async: false,
listName: "MyList",
ID: itemToBeUpdated,
valuepairs:[["IsActive", true], ["DateMadeActive", lastTuesdayDate]],
completefunc:function(xData, Status)
{
}
});
}

Date.prototype.GetLastTuesdayOfWeek = function() {
    return (new Date(this.setDate(this.getDate() - this.getDay() + 2)));
}

Comments

  1. I simply couldn’t depart your site before suggesting that I really enjoyed the usual information an individual supply in your visitors? Is going to be again steadily to check out new posts.

    CRO Agency in Chennai

    ReplyDelete

Post a Comment

Popular posts from this blog

Permission audit report for site and all sub sites using PowerShell

Use below script to get Permission audit report for site and all sub sites using PowerShell, Add-PSSnapin "Microsoft.SharePoint.PowerShell" $URL="https://intranet.contoso.com/sales/mysite/"      $site = Get-SPSite $URL      #Write the Header to "Tab Separated Text File"         "Site Name`t  URL `t Group Name `t User Account `t User Name `t E-Mail" | out-file "E:\Ulhas\UsersandGroupsRpt.txt"          #Iterate through all Webs       foreach ($web in $site.AllWebs)       {         #Write the Header to "Tab Separated Text File"         "$($web.title) `t $($web.URL) `t  `t  `t `t " | out-file "E:\Ulhas\UsersandGroupsRpt.txt" -append          #Get all Groups and Iterate through            foreach ($group in $Web.groups)         ...

Populate people picker field with logged in user in SharePoint using JS

Please use below code to populate people picker in SharePoint online, <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <script type="text/javascript"> ExecuteOrDelayUntilScriptLoaded(function () { setTimeout(function () { SetUserFieldValue('AuthorName'); }, 1000); }, 'clientpeoplepicker.js'); //Set PeoplePicker Value function SetUserFieldValue(fieldName) { try{ var userAccountName = _spPageContextInfo.userLoginName; //PeoplePicker Object var peoplePicker = $("div[title='" + fieldName + "']"); //PeoplePicker ID var peoplePickerTopId = peoplePicker.attr('id'); //People PickerEditor var peoplePickerEditor = $("input[title='" + fieldName + "']"); //Set Value to Editor peoplePickerEditor.val(userAccountName); //Get Client PeoplePicker Dict var peoplePickerObject = SPClientPeoplePicke...