Tuesday, June 7, 2016

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)));
}

Select and Delete text vertically in bigger text OR flat file

If you want to Select and Delete text vertically in bigger text OR any flat file use below command to do it. Example below: A BCEDF CDEF...