SpServices with JqGrid in in button click event with where condition sharepoint

-
Hi friends,
Here is code to display spservices getlistitems in jqgrid Sharepoint page load event.
Here is the code. here my list name is ProjectDetails.
<html dir="ltr" xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">
<meta name="WebPartPageExpansion" content="full" />
<meta http-equiv="X-UA-Compatible" content="IE=10" />
<SharePoint:CssRegistration Name="default" runat="server"/>

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script>
<style type="text/css" src="https://cdnjs.cloudflare.com/ajax/libs/jqgrid/4.6.0/css/ui.jqgrid.css"></style>
<link rel="stylesheet" type="text/css" href="/Style%20Library/Jqgrid.css"></link>

<script src="https://cdnjs.cloudflare.com/ajax/libs/jqgrid/4.6.0/js/i18n/grid.locale-el.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jqgrid/4.6.0/js/jquery.jqGrid.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/json2/20140204/json2.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery.SPServices/2014.02/jquery.SPServices-2014.02.min.js"></script>
<script>

</script>
<script>
$(document).ready(function() {
var mydata;
var JqData1=[];
 var counter = 0;
});

</script>

</head>

<body>

<form id="form1" runat="server">
<table>
<tr>
<td><input name="Text1" type="text"  id="txtdata"/></td>
<td><asp:DropDownList runat="server" id="DropDownList1">
<asp:ListItem Text="Approved" Value="Approved" Selected="True"></asp:ListItem>
<asp:ListItem Text="Pending" Value="Pending"></asp:ListItem>
<asp:ListItem Text="All" Value=""></asp:ListItem>
</asp:DropDownList>
</td>
<td><input name="Button1" type="button" value="button" onclick="Button()"/></td>
</tr>
</table>

<div id='tblMain' style="float:left;width:600px">
  <table  id="list" ></table>
  <div id="pager" style="text-align:center;"></div>
</div>

</form>

</body>

<script>
function Button()
{
//alert('hi');
var a=$('#DropDownList1').val();
var b=$('#txtdata').val();
  sortIdexName = jQuery("#list").getGridParam("sortname"); //Maintaining Consitant SortName after the Sortcol event
  sortOrderName = jQuery("#list").getGridParam("sortorder"); //Maintaining Consistant Sort Order
  Query = "<Query> <Where><And><Eq><FieldRef Name='ApprovalStatus' /><Value Type='Text'>"+a+"</Value></Eq> <Eq><FieldRef Name='ProjectName' />"+
            "<Value Type='Text'>"+b+"</Value></Eq></And></Where></Query>";

 var mydata;
var JqData1=[];
 var counter = 0;

  var CAMLViewFields ="<ViewFields>"+" <FieldRef Name='ProjectId' />"+
  "<FieldRef Name='ProjectName' /><FieldRef Name='DeliveryManager' /><FieldRef Name='ApprovalStatus' /></ViewFields>"
  $().SPServices({
      operation : "GetListItems",
      async : false,
      listName : "ProjectDetails",
      CAMLQuery : Query,
      CAMLViewFields : CAMLViewFields,
     completefunc: function (xData, Status) {
    // alert(xData.responseText);
      //var counter = 0;
      $(xData.responseXML).SPFilterNode("z:row").each(function() {
        var JqData={};
    if (counter == 0) {
     JqData.PID= $(this).attr("ows_ID");
     JqData.PName=$(this).attr("ows_ProjectName");
     JqData.PManager=$(this).attr("ows_DeliveryManager");
JqData.PStatus=$(this).attr("ows_ApprovalStatus");
      counter = counter + 1;
    } else {
      JqData.PID= $(this).attr("ows_ID");
      JqData.PName=$(this).attr("ows_ProjectName");
      JqData.PManager=$(this).attr("ows_DeliveryManager");
JqData.PStatus=$(this).attr("ows_ApprovalStatus");

      counter = counter + 1;  
      }
      JqData1.push(JqData);
      });
    }  
    });
    $('#list').jqGrid('GridUnload');
   // $('#list').jqGrid('clearGridData');
    jQuery("#list").jqGrid({
  data: JqData1,
  datatype: "local",
   height: 150,
   width:900,
         hidegrid: false,
  colNames: ['PID', 'PName','PManager','PStatus'],
         colModel: [
             { name: 'PID', index: 'PID', width: 100, align: "center", sorttype: 'int' },
             { name: 'PName', index: 'PName', width: 100, align: "left" },
             { name: 'PManager', index: 'PManager', width: 100, align: "left" },
             { name: 'PStatus', index: 'PStatus', width: 100, align: "left" }
                   ],

  pager: true,
  pager: '#pager',
  pageinput: true,
  rowNum: 2,
  rowList: [5, 10, 20, 50, 100],
  sortname: 'ApprovalStatus',
  sortorder: "asc",
  viewrecords: true,
  autowidth: true,
  emptyrecords: "No records to view",
  loadtext: "Loading..."
});
jQuery("#list").jqGrid('navGrid', "#pager", { edit: false, add: false, del: false, search: true, refresh: true });


}

</script>

</html>

Comments

Post a Comment

Popular posts from this blog

WCF interview questions

-
Windows Communication Foundation is... Some Important points I have collected from MSDN site are: A part of the .NET Framework that provides a unified programming model for rapidly building service-oriented applications that communicate across the web and the enterprise. The global acceptance of Web services, which includes standard protocols for application-to-application communication, has changed software development. For example, the functions that Web services now provide include security, distributed transaction coordination, and reliable communication. The benefits of the changes in Web services should be reflected in the tools and technologies that developers use. Windows Communication Foundation (WCF) is designed to offer a manageable approach to distributed computing, broad interoperability, and direct support for service orientation. WCF simplifies development of connected applications through a new service-oriented programming model. WCF supports many styles of...
Read more

The term 'Connect-MsolService' is not recognized as the name of a cmdlet, function, script file, or operable program

-
Following worked for me: Uninstall the previously installed ‘Microsoft Online Service Sign-in Assistant’ and ‘Windows Azure Active Directory Module for Windows PowerShell’. Install 64-bit versions of ‘Microsoft Online Service Sign-in Assistant’ and ‘Windows Azure Active Directory Module for Windows PowerShell’. https://littletalk.wordpress.com/2013/09/23/install-and-configure-the-office-365-powershell-cmdlets/ If you get the following error  In order to install Windows Azure Active Directory Module for Windows PowerShell, you must have Microsoft Online Services Sign-In Assistant version 7.0 or greater installed on this computer , then install the Microsoft Online Services Sign-In Assistant for IT Professionals BETA:  http://www.microsoft.com/en-us/download/details.aspx?id=39267 Copy the folders called MSOnline and MSOnline Extended from the source C:\Windows\System32\WindowsPowerShell\v1.0\Modules\ to the folder C:\Windows\SysWOW64\WindowsPowerShell\v1.0...
Read more

what is Event Cache table in sharepoint

-
Every Content database in SharePoint Contains an EventCache table that is the change log for objects contained in the database. Each row in this table is depicting a change in an object where columns usually contain information such as the date and time of a change, the type of object that was changed, the nature of the change, and a unique identifier for the object. EventCache table is important because it stores the list of site events for which users might have requested alerts.
Read more