Saturday, 12 December 2015

Inserting and retrieving values for all types of Fields in ShrePoint 2013 using JSOM

//Inserting into all types of fields

function insertItem()
{
        var context=new SP.ClientContext.get_current();
var web=context.get_web();
context.load(web);
var list=web.get_lists().getByTitle("FieldsTypeDemo1");
context.load(list);
var itemCreateInfo = new SP.ListItemCreationInformation();
    var oListItem = list.addItem(itemCreateInfo);
oListItem.set_item("SingleText",SingleText);
oListItem.set_item("MultiPlainText",MultiPlainText);
oListItem.set_item('MultiRichText',MultiRichText);
oListItem.set_item('ChoiceDropDown',ChoiceDropDown);
oListItem.set_item('ChoiceRadio',ChoiceRadio);
oListItem.set_item('ChoiceCheckBox',ChoiceCheckBox);
oListItem.set_item('Num',Num);
oListItem.set_item('Currency',Currency);
//Convert date to SharePoint Date format
if(DateOnly!="")
{
var toDate=new Date(DateOnly);
var newDateOnly=(toDate.getMonth()+1)+"/"+toDate.getDate()+"/"+toDate.getFullYear();
oListItem.set_item('DateOnly',newDateOnly);
}
//Convert date and time to SharePoint DateTime format
if(DateAndTime!="")
{

//alert(time[0]);
var toDate1=new Date(DateAndTime);
var newDateTime=(toDate1.getMonth()+1)+"/"+toDate1.getDate()+"/"+toDate1.getFullYear()+" "+hr+min;
alert(newDateTime);
oListItem.set_item('DateAndTime',newDateTime);
}
var lookUp = new SP.FieldLookupValue();
    lookUp.set_lookupId(LookUpField);
    oListItem.set_item('LookUpField',lookUp);
oListItem.set_item('Y_x002f_N',YN);
if(HyperLink!="http://")
oListItem.set_item('HyperLink',HyperLink);
if(Picture!="http://")
oListItem.set_item('Picture',Picture);

//Converting to Taxonomy Managed metadata field
if(ManagedMetadata!="")
{
var field= list.get_fields().getByInternalNameOrTitle("ManagedMetadata");
var taxField = context.castTo(field, SP.Taxonomy.TaxonomyField);
   var termValue = new SP.Taxonomy.TaxonomyFieldValue();
   var id="";
   for(var i=0;i<termsLbl.length;i++)
   {
    if(termsLbl[i]==ManagedMetadata)
    {
    id=termsId[i];
    }
   }
   termValue.set_label(ManagedMetadata);
   termValue.set_termGuid(id);
   taxField.setFieldValueByValue(oListItem, termValue);
}
    oListItem.update();
context.load(oListItem);    
    context.executeQueryAsync(success,fail);
    function success()
    {
    alert("Row Inserted Successfully");
    window.location.reload();
    }
    function fail(sender,args)
{
alert(args);
window.location.reload();
}
}




//retriving from all types of fields
function getAllItems()
{
        

var context=new SP.ClientContext.get_current();
var web=context.get_web();
context.load(web);
var list=web.get_lists().getByTitle("FieldsTypeDemo1");
context.load(list);
var query = new SP.CamlQuery();
    var items = list.getItems(query);
    context.load(items);
context.executeQueryAsync(success,fail);
function fail(sender,args)
{
alert("Call failed:"+args.get_message());
}
function success()
{
var item = items.getEnumerator();
while(item.moveNext())
{
var row = item.get_current();
$("#SingleTextInfo").text(row.get_item("SingleText"));
$("#MultiPlainTextInfo").text(row.get_item("MultiPlainText"));
document.getElementById("MultiRichTextInfo").innerHTML=row.get_item("MultiRichText");
$("#ChoiceDropDownInfo").text(row.get_item("ChoiceDropDown"));
$("#ChoiceRadioInfo").text(row.get_item("ChoiceRadio"));
$("#ChoiceCheckBoxInfo").text(row.get_item("ChoiceCheckBox"));
$("#NumInfo").text(row.get_item("Num"));
$("#CurrencyInfo").text(row.get_item("Currency"));
var date1=new Date(row.get_item("DateOnly"));
$("#DateOnlyInfo").text(((date1.getMonth()+1)+"/"+date1.getDate()+"/"+date1.getFullYear()));
var date2=new Date(row.get_item("DateAndTime"));
$("#DateAndTimeInfo").text(((date2.getMonth()+1)+"/"+date2.getDate()+"/"+date2.getFullYear()+" "+date2.getHours()+":"+date2.getMinutes()));
                               
                               //get Lookup value for look up field
$("#LookUpFieldInfo").text(row.get_item("LookUpField").get_lookupValue());
if(row.get_item("Y_x002f_N")==true)
$("#YNInfo").text("Yes");
else
$("#YNInfo").text("No");

                                 //get URL for HyperLink an dPicture fields
var url1=row.get_item("HyperLink").get_url();
var url2=row.get_item("Picture").get_url();
document.getElementById("HyperLinkInfo").innerHTML='<a href="'+url1+'" target="new">'+url1+'</a>';
document.getElementById("PictureInfo").innerHTML='<a href="'+url2+'" target="new">'+url2+'</a>';

//display label name
                               $("#ManagedMetadataInfo").text(row.get_item("ManagedMetadata").$0_1); 
}
}
}


No comments:

Post a Comment