Mavengers: August 2014

Thursday, August 21, 2014

Get Item count in array using jquery

GetItemCountInArray: function (myArr, item) {

num = 0;
for (i = 0; i <= myArr.length; i++) {
if (myArr[i] == item)
num++;
}
return num;

}

Wednesday, August 20, 2014

get unique values from array jquery

GetUnique: function (inputArray) {
var outputArray = [];
for (var i = 0; i < inputArray.length; i++) {
if ((jQuery.inArray(inputArray[i], outputArray)) == -1) {
outputArray.push(inputArray[i]);
}
}
return outputArray;
}

Find length (size) of an array in jquery

var itemArr = new Array();

alert(itemArr.length);

Delete Item From Custom list By caml query sharepoint 2013

deleteDataFromListByQuery: function (customListName, query, columns) {

var scriptbase = hostUrl + "/_layouts/15/";
$.getScript(scriptbase + 'SP.Runtime.js',
function () {
$.getScript(scriptbase + 'SP.js',
function () {
$.getScript(scriptbase + 'SP.RequestExecutor.js', deleteItem);
});
});

function deleteItem() {

var context;
var factory;
var appContextSite;
var mylist;
context = new SP.ClientContext(appweburl);
factory = new SP.ProxyWebRequestExecutorFactory(appweburl);
context.set_webRequestExecutorFactory(factory);
appContextSite = new SP.AppContextSite(context, hostUrl);
this.web = appContextSite.get_web();
mylist = this.web.get_lists().getByTitle(customListName);//Custom List Name
var camlQuery = new SP.CamlQuery();
camlQuery.set_viewXml(query);
var collListItem = mylist.getItems(camlQuery);
context.load(mylist);
context.load(collListItem);

context.executeQueryAsync(

function () {

var listItemEnumerator = collListItem.getEnumerator();
var counter = 0;
var itemArr = new Array();
var id;
while (listItemEnumerator.moveNext()) {

var listItem = listItemEnumerator.get_current();

//itemArr[counter] = listItem.get_item("ID");

//counter++;
id = listItem.get_item('ID');

var spItem = mylist.getItemById(id);

spItem.deleteObject();

}

// for (var id in itemArr) {

// var spItem = mylist.getItemById(itemArr[id]);

// spItem.deleteObject();

// }

context.executeQueryAsync(

function () {

alert('success');

},
function () {
error();
});

},
function () {
error();
});
}

}

Delete Item from custom list in sharepoint 2013 using Caml query and JSOM

1) function deleteItem(id) {

//REST.Common.deleteDataFromParentList(customlist.TravelRequestlist, id);
var department = 52;
var customListName = 'TMS_AirBooking';//Custom List Name
var query = '<View><Query><Where><Eq><FieldRef Name=\'Travel_Req_No\'/>' +
'<Value Type=\'Number\'>' + department + '</Value></Eq></Where></Query><RowLimit>10</RowLimit></View>';
var columns = ['Travel_Req_No'];

deleteDataFromChildList(customListName, query, columns);
// alert(id + ',' + 'TravelRequests');
}

2) deleteDataFromChildList: function (customListName, query, columns) {

var scriptbase = hostUrl + "/_layouts/15/";
$.getScript(scriptbase + 'SP.Runtime.js',
function () {
$.getScript(scriptbase + 'SP.js',
function () {
$.getScript(scriptbase + 'SP.RequestExecutor.js', deleteItem);
});
});

function deleteItem() {

var context;
var factory;
var appContextSite;
var mylist;
context = new SP.ClientContext(appweburl);
factory = new SP.ProxyWebRequestExecutorFactory(appweburl);
context.set_webRequestExecutorFactory(factory);
appContextSite = new SP.AppContextSite(context, hostUrl);
this.web = appContextSite.get_web();
mylist = this.web.get_lists().getByTitle(customListName);//Custom List Name
var camlQuery = new SP.CamlQuery();
camlQuery.set_viewXml(query);
var collListItem = mylist.getItems(camlQuery);
context.load(mylist);
context.load(collListItem);

context.executeQueryAsync(

function () {

var listItemEnumerator = collListItem.getEnumerator();
var counter = 0;
var itemArr = new Array();

while (listItemEnumerator.moveNext()) {

var listItem = listItemEnumerator.get_current();

itemArr[counter] = listItem.get_item("ID");

counter++;

}

for (var id in itemArr) {

var spItem = mylist.getItemById(itemArr[id]);

spItem.deleteObject();

}

context.executeQueryAsync(

function () {

alert('success');

},
function () {
error();
});

},
function () {
error();
});
}

}

Wednesday, August 13, 2014

Popup in sharepoint 2013 with ModalDialog

openDialog: function (id) {

SP.UI.ModalDialog.showModalDialog({
url: "Edit.aspx?ID=" + id + "&SPHostUrl=" + hostUrl + "&SPAppWebUrl=" + appweburl + "",
title: "Edit",
allowMaximize: false,
showClose: true,
width: 400,
height: 200
});

}

Tuesday, August 12, 2014

set textbox value in jquery

$("#s1").val("Glenn Quagmire");

get data row from custom list in sharepoint 2013

getDataRowFromCustomListUsingId: function (customListName, id) {

var scriptbase = hostUrl + "/_layouts/15/";
$.getScript(scriptbase + 'SP.Runtime.js',
function () {
$.getScript(scriptbase + 'SP.js',
function () {
$.getScript(scriptbase + 'SP.RequestExecutor.js', getDataById);
});
});

//Read Data From Custom List - Host Web
function getDataById() {

var context;
var factory;
var appContextSite;
var mylist;
var targetListItem;
context = new SP.ClientContext(appweburl);
factory = new SP.ProxyWebRequestExecutorFactory(appweburl);
context.set_webRequestExecutorFactory(factory);
appContextSite = new SP.AppContextSite(context, hostUrl);
this.web = appContextSite.get_web();
mylist = this.web.get_lists().getByTitle(customListName);//Custom List Name
targetListItem = mylist.getItemById(id);
context.load(targetListItem);
context.executeQueryAsync(

function () {

editsuccess(targetListItem);

},
function () {
error();
});
}
}

check undefined variable in jquery

var id = decodeURIComponent(getQueryStringParameter("ID"));

alert(id);
if (id != 'undefined') {
alert('success');
}
else {
alert('fail');
}

Monday, August 11, 2014

Get Peoplepicker content using JSOM in sharepoint 2013

var html = $("#ctl00_PlaceHolderMain_docReviewerUser_upLevelDiv"); params['DocReviewerLoginName'] = $("#divEntityData", html).attr("key");

Sunday, August 10, 2014

Caml query example with Person or Group (By Name) sharepoint 2013

1) Person or Group (By Name)
2) Value Type - Text
<Query>
<Where>
<Eq>

<FieldRef Name=\'Title\'/>'

'<Value Type=\'Text\'>Shekhar</Value>

</Eq>
</Where>
</Query>

Caml query example withMultiple Lines of Text sharepoint 2013

1) Multiple Lines of Text
2) Value Type - Text
<Query>
<Where>
<Contains>

<FieldRef Name=\'Title\'/>'

'<Value Type=\'Text\'>Shekhar</Value>

</Contains>
</Where>
</Query>

Caml query example with Single line of text sharepoint 2013

1) Single line of text

Value Type - Text

<Query>
<Where>
<Eq>
<FieldRef Name=\'Title\'/>'
'<Value Type=\'Text\'>Shekhar</Value>
</Eq>
</Where>

</Query>

Caml Query Operators Sharepoint 2013

Operators
Some list of operators used in SPQuery

Eq--Equals
Neq--Not equal
Gt--Greater than
Geq--Greater than or equal
Lt--Lower than
Leq--Lower than
IsNull--Is null
BeginsWith--Begins with
Contains--Contains

Thursday, August 7, 2014

return in javascript function

<!DOCTYPE html>
<html>
<body>

<p id="demo"></p>

<script>
function myFunction(a, b) {
return a * b;
}
document.getElementById("demo").innerHTML = myFunction(4, 3);
</script>

</body>
</html>
This example calls a function which performs a calculation, and returns the result:12

Wednesday, August 6, 2014

Jquery DatePicker example 2

<html lang="en">
<head>
<style >
div.ui-datepicker{
font-size:11px;
}
</style>
<title>jQuery UI Datepicker - Default functionality</title>
<link rel="stylesheet" href="http://code.jquery.com/ui/1.10.0/themes/base/jquery-ui.css" />
<script src="http://code.jquery.com/jquery-1.8.3.js"></script>
<script src="http://code.jquery.com/ui/1.10.0/jquery-ui.js"></script>

<script>

$(function() {
$( "#fromdatepicker" ).datepicker();
$( "#todatepicker" ).datepicker();
});
$(function() {
$("#btnFilter").click(function() {
var startDate = $("#fromdatepicker").datepicker("getDate");
startDate = startDate.getFullYear()+"-"+(startDate.getMonth()+1)+"-"+startDate.getDate();

var endDate = $("#todatepicker").datepicker("getDate");
endDate = endDate.getFullYear()+"-"+(endDate.getMonth()+1)+"-"+endDate.getDate();

alert(startDate +"-"+ endDate);
});
});
</script>
</head>
<body>

<p>
From Date: <input type="text" id="fromdatepicker" style="font-size:11px" />
To Date: <input type="text" id="todatepicker" style="font-size:11px" />    
<input type="button" id="btnFilter" value="Generate Report">
</p>

</body>
</html>
jQuery UI Datepicker - Default functionality From Date: To Date:

Datepicker example Jquery



<!doctype html>



<html lang="en">



<head>



  <meta charset="utf-8">



  <title>jQuery UI Datepicker - Default functionality</title>



  <link rel="stylesheet" href="//code.jquery.com/ui/1.11.0/themes/smoothness/jquery-ui.css">



  <script src="//code.jquery.com/jquery-1.10.2.js"></script>



  <script src="//code.jquery.com/ui/1.11.0/jquery-ui.js"></script>



  <link rel="stylesheet" href="/resources/demos/style.css">



  <script>



  $(function() {



    $( "#datepicker" ).datepicker();



  });



  </script>



</head>



<body>



 



<p>Date: <input type="text" id="datepicker"></p>



 



 



</body>



</html>

jQuery UI Datepicker - Default functionality Date:

add elements to array in javascript

<!DOCTYPE html>
<html>
<body>

<p>Click the button to add a new element to the array.</p>

<button onclick="myFunction()">Try it</button>

<p id="demo"></p>

<script>
var fruits = [];
document.getElementById("demo").innerHTML = fruits;

function myFunction() {
fruits.push("Kiwi","Shekhar");
document.getElementById("demo").innerHTML = fruits;
}
</script>

</body>
</html>
Click the button to add a new element to the array.

Use variables in one javascript file to other javascript file

1) // first.js

var colorCodes = {

  back  : "#fff",
  front : "#888",
  side  : "#369"

};

2) // second.js

alert (colorCodes.back); // alerts `#fff`

3) Your HTML

<script type="text/javascript" src="first.js"></script> 
<script type="text/javascript" src="second.js"></script>

Tuesday, August 5, 2014

The provided app differs from another app with the same version and product id sharepoint 2013 (Sample 2)

1) Click On Tools

2) Click on Create Guid

3) Click on Copy Button

4) Go To AppManifest.xml and Replace Product Id with New and See if it is working

The provided app differs from another app with the same version and product id sharepoint 2013 (Sample 1)

I solved it by increasing the version number in the AppManifest
Previously - It was Version 1-0

Create new item in custom list using JSOM sharepoint 2013

https://www.dropbox.com/s/r5q3j5s1fv6yxsb/TravelSystem.rar

1) Add your site URL in properties

2) Run Project

Sunday, August 3, 2014

Sharepoint 2013 Getting List Items using JSOM – Sharepoint-Hosted Application

1) Create Custom List in Sharepoint 2013(Office 2013 Account )

2) Copy & Paste below code in your App.js and deploy application

3) App.Js

// context: The ClientContext object provides access to

// the web and lists objects.

var context = SP.ClientContext.get_current();

//Get the URI decoded SharePoint site url from the SPHostUrl parameter.

//https://XXX.sharepoint.com/TravelApp

var hostUrl = decodeURIComponent(getQueryStringParameter("SPHostUrl"));

//https://XXX.sharepoint.com/TravelApp/TravelSystem

var appweburl = decodeURIComponent(getQueryStringParameter("SPAppWebUrl"));

var hostcontext = new SP.AppContextSite(context, hostUrl);

var web = hostcontext.get_web();

var lists = web.get_lists();

$(document).ready(function () {

var scriptbase = hostUrl + "/_layouts/15/";

$.getScript(scriptbase + 'SP.Runtime.js',

function () {

$.getScript(scriptbase + 'SP.js',

function () {

$.getScript(scriptbase + 'SP.RequestExecutor.js', execCrossDomainRequest);

});

function getQueryStringParameter(paramToRetrieve) {

var params =

document.URL.split("?")[1].split("&");

var strParams = "";

for (var i = 0; i < params.length; i = i + 1) {

var singleParam = params[i].split("=");

if (singleParam[0] == paramToRetrieve)

return singleParam[1];

}

function execCrossDomainRequest() {

var context;

var factory;

var appContextSite;

var mylist;

context = new SP.ClientContext(appweburl);

factory = new SP.ProxyWebRequestExecutorFactory(appweburl);

context.set_webRequestExecutorFactory(factory);

appContextSite = new SP.AppContextSite(context, hostUrl);

this.web = appContextSite.get_web();

mylist = this.web.get_lists().getByTitle('Test');

var camlQuery = new SP.CamlQuery();

camlQuery.set_viewXml('<View><RowLimit>10</RowLimit></View>');

var collListItem = mylist.getItems(camlQuery);

context.load(mylist);

context.load(collListItem);

context.executeQueryAsync(

Function.createDelegate(this, successHandler),

Function.createDelegate(this, errorHandler)

);

function successHandler() {

var listItemInfo = '';

var listItemEnumerator = collListItem.getEnumerator();

while (listItemEnumerator.moveNext()) {

var oListItem = listItemEnumerator.get_current();

listItemInfo += "<li style='height: 20px;'>" + oListItem.get_item('Title') + "</li>";

document.getElementById("message").innerHTML = '<h1>' + mylist.get_title() + '</h1><br />';

document.getElementById("message").innerHTML += listItemInfo.toString();

}

function errorHandler() {

alert('Request failed. ' + args.get_message() + '\n' + args.get_stackTrace());

}

Mavengers