JQGrid in VF Page
This post will help you to show your data in a tabular format without creating the controller. The data will be queried on the VisualForce page and pushed into a table using jQuery Grid. Please follow the below steps:
1. Create a VisualForce page.
<apex:page>
</apex:page>
2. Now import the JavaScript and jQuery Libraries and CSS.
<apex:page>
<script src="/soap/ajax/24.0/connection.js" type="text/javascript"></script>
<script src="/soap/ajax/24.0/apex.js" type="text/javascript"></script>
<link rel="stylesheet" type="text/css" media="screen" href="http://trirand.com/blog/jqgrid/themes/redmond/jquery-ui-1.8.1.custom.css" />
<link rel="stylesheet" type="text/css" media="screen" href="http://trirand.com/blog/jqgrid/themes/ui.jqgrid.css" />
<link rel="stylesheet" type="text/css" media="screen" href="http://trirand.com/blog/jqgrid/themes/ui.multiselect.css" />
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<script src="http://trirand.com/blog/jqgrid/js/jquery.layout.js" type="text/javascript"></script>
<script src="http://trirand.com/blog/jqgrid/js/i18n/grid.locale-en.js" type="text/javascript"></script>
<script src="http://trirand.com/blog/jqgrid/js/ui.multiselect.js" type="text/javascript"></script>
<script src="http://trirand.com/blog/jqgrid/js/jquery.jqGrid.min.js" type="text/javascript"></script>
<script src="http://trirand.com/blog/jqgrid/js/jquery.tablednd.js" type="text/javascript"></script>
<script src="http://trirand.com/blog/jqgrid/js/jquery.contextmenu.js" type="text/javascript"></script>
<apex:page>
NOTE: The above scripts won't be loaded successfully because these are unsafe. Temporarily you can allow your browser to load unsafe scripts by clicking on the Shield icon. This shield icon is located on the top right of Chrome and top left of Firefox. For permanent fix you can upload these scripts and css as a static resource and change the references above.
3. Now create a JavaScript function as given below which will return the data.
<script type="text/javascript">
function acountListData()
{
// prepare the data
sforce.connection.sessionId = '{!$Api.Session_ID}';
var query = "SELECT Id, Name, StageName, Amount, CloseDate, Probability FROM Opportunity WHERE tageName!='Negotiation/Review' AND StageName!='Closed Won' AND StageName!='Closed Lost'";
var records = sforce.connection.query(query);
var accList = records.getArray('records');
var data = [];
for (var i = 0; i < accList.length; i++) {
var currentAccList = accList[i];
var row = {
Name : currentAccList.Name,
StageName : currentAccList.StageName,
Amount : currentAccList.Amount,
CloseDate : currentAccList.CloseDate,
Probability : currentAccList.Probability,
};
data[i] = row;
}
return data; // Array data contains the List of Opportunity records.
}
</script>
4. Now add the jQuery Grid code below the above function which will push the data into table.
<script type="text/javascript">
function acountListData()
{
// prepare the data
sforce.connection.sessionId = '{!$Api.Session_ID}';
var query = "SELECT Id, Name, StageName, Amount, CloseDate, Probability FROM Opportunity WHERE tageName!='Negotiation/Review' AND StageName!='Closed Won' AND StageName!='Closed Lost'";
var records = sforce.connection.query(query);
var accList = records.getArray('records');
var data = [];
for (var i = 0; i < accList.length; i++) {
var currentAccList = accList[i];
var row = {
Name : currentAccList.Name,
StageName : currentAccList.StageName,
Amount : currentAccList.Amount,
CloseDate : currentAccList.CloseDate,
Probability : currentAccList.Probability,
};
data[i] = row;
}
return data; // Array data contains the List of Opportunity records.
}
$(document).ready(function () {
var mydata = acountListData();
jQuery("#list4").jqGrid({
datatype: "local",
data: mydata,
width:1000,
height: 500,
colNames:['Name', 'Stage', 'Amount','Close Date','Probability'],
colModel:[
{name:'Name',index:'Name', width:100, sorttype:"int",align:"center"},
{name:'StageName',index:'StageName', width:100,align:"center", sorttype:"string"},
{name:'Amount',index:'Amount', width:100,align:"center"},
{name:'CloseDate',index:'CloseDate', width:100, align:"center",sorttype:"float"},
{name:'Probability',index:'Probability', width:100,align:"center",sorttype:"float"}
],
caption: "Due Proposals",
});
});
</script>
5. Add the HTML table tag inside the Body tags.
<body>
<table id="list4"><tr><td></td></tr></table>
<div id="pager"></div>
</body>
6. Here is the full code:
<apex:page>
<script src="/soap/ajax/24.0/connection.js" type="text/javascript"></script>
<script src="/soap/ajax/24.0/apex.js" type="text/javascript"></script>
<link rel="stylesheet" type="text/css" media="screen" href="http://trirand.com/blog/jqgrid/themes/redmond/jquery-ui-1.8.1.custom.css" />
<link rel="stylesheet" type="text/css" media="screen" href="http://trirand.com/blog/jqgrid/themes/ui.jqgrid.css" />
<link rel="stylesheet" type="text/css" media="screen" href="http://trirand.com/blog/jqgrid/themes/ui.multiselect.css" />
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<script src="http://trirand.com/blog/jqgrid/js/jquery.layout.js" type="text/javascript"></script>
<script src="http://trirand.com/blog/jqgrid/js/i18n/grid.locale-en.js" type="text/javascript"></script>
<script src="http://trirand.com/blog/jqgrid/js/ui.multiselect.js" type="text/javascript"></script>
<script src="http://trirand.com/blog/jqgrid/js/jquery.jqGrid.min.js" type="text/javascript"></script>
<script src="http://trirand.com/blog/jqgrid/js/jquery.tablednd.js" type="text/javascript"></script>
<script src="http://trirand.com/blog/jqgrid/js/jquery.contextmenu.js" type="text/javascript"></script>
<script type="text/javascript">
function acountListData()
{
// prepare the data
//alert(sforce.connection);
sforce.connection.sessionId = '{!$Api.Session_ID}';
var query = "SELECT Id, Name, StageName, Amount, CloseDate, Probability FROM Opportunity WHERE StageName!='Quote Sent' AND StageName!='Negotiation/Review' AND StageName!='Closed Won' AND StageName!='Closed Lost'";
var records = sforce.connection.query(query);
var accList = records.getArray('records');
var data = [];
for (var i = 0; i < accList.length; i++) {
var currentAccList = accList[i];
var row = {
Name : currentAccList.Name,
StageName : currentAccList.StageName,
Amount : currentAccList.Amount,
CloseDate : currentAccList.CloseDate,
Probability : currentAccList.Probability,
};
data[i] = row;
}
return data;
}
$(document).ready(function () {
var mydata = acountListData();
jQuery("#list4").jqGrid({
datatype: "local",
data: mydata,
width:1000,
height: 500,
colNames:['Name', 'Stage', 'Amount','Close Date','Probability'],
colModel:[
{name:'Name',index:'Name', width:100, sorttype:"int",align:"center"},
{name:'StageName',index:'StageName', width:100,align:"center", sorttype:"string"},
{name:'Amount',index:'Amount', width:100,align:"center"},
{name:'CloseDate',index:'CloseDate', width:100, align:"center",sorttype:"float"},
{name:'Probability',index:'Probability', width:100,align:"center",sorttype:"float"}
],
caption: "Due Proposals",
});
});
</script>
<body>
<table id="list4"><tr><td></td></tr></table>
<div id="pager"></div>
</body>
</apex:page>
7. To see how jQGrid and and SubGrid looks, click this link: http://gaurishgopalgoel-developer-edition.ap1.force.com/
1. Create a VisualForce page.
<apex:page>
</apex:page>
2. Now import the JavaScript and jQuery Libraries and CSS.
<apex:page>
<script src="/soap/ajax/24.0/connection.js" type="text/javascript"></script>
<script src="/soap/ajax/24.0/apex.js" type="text/javascript"></script>
<link rel="stylesheet" type="text/css" media="screen" href="http://trirand.com/blog/jqgrid/themes/redmond/jquery-ui-1.8.1.custom.css" />
<link rel="stylesheet" type="text/css" media="screen" href="http://trirand.com/blog/jqgrid/themes/ui.jqgrid.css" />
<link rel="stylesheet" type="text/css" media="screen" href="http://trirand.com/blog/jqgrid/themes/ui.multiselect.css" />
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<script src="http://trirand.com/blog/jqgrid/js/jquery.layout.js" type="text/javascript"></script>
<script src="http://trirand.com/blog/jqgrid/js/i18n/grid.locale-en.js" type="text/javascript"></script>
<script src="http://trirand.com/blog/jqgrid/js/ui.multiselect.js" type="text/javascript"></script>
<script src="http://trirand.com/blog/jqgrid/js/jquery.jqGrid.min.js" type="text/javascript"></script>
<script src="http://trirand.com/blog/jqgrid/js/jquery.tablednd.js" type="text/javascript"></script>
<script src="http://trirand.com/blog/jqgrid/js/jquery.contextmenu.js" type="text/javascript"></script>
<apex:page>
NOTE: The above scripts won't be loaded successfully because these are unsafe. Temporarily you can allow your browser to load unsafe scripts by clicking on the Shield icon. This shield icon is located on the top right of Chrome and top left of Firefox. For permanent fix you can upload these scripts and css as a static resource and change the references above.
3. Now create a JavaScript function as given below which will return the data.
<script type="text/javascript">
function acountListData()
{
// prepare the data
sforce.connection.sessionId = '{!$Api.Session_ID}';
var query = "SELECT Id, Name, StageName, Amount, CloseDate, Probability FROM Opportunity WHERE tageName!='Negotiation/Review' AND StageName!='Closed Won' AND StageName!='Closed Lost'";
var records = sforce.connection.query(query);
var accList = records.getArray('records');
var data = [];
for (var i = 0; i < accList.length; i++) {
var currentAccList = accList[i];
var row = {
Name : currentAccList.Name,
StageName : currentAccList.StageName,
Amount : currentAccList.Amount,
CloseDate : currentAccList.CloseDate,
Probability : currentAccList.Probability,
};
data[i] = row;
}
return data; // Array data contains the List of Opportunity records.
}
</script>
4. Now add the jQuery Grid code below the above function which will push the data into table.
<script type="text/javascript">
function acountListData()
{
// prepare the data
sforce.connection.sessionId = '{!$Api.Session_ID}';
var query = "SELECT Id, Name, StageName, Amount, CloseDate, Probability FROM Opportunity WHERE tageName!='Negotiation/Review' AND StageName!='Closed Won' AND StageName!='Closed Lost'";
var records = sforce.connection.query(query);
var accList = records.getArray('records');
var data = [];
for (var i = 0; i < accList.length; i++) {
var currentAccList = accList[i];
var row = {
Name : currentAccList.Name,
StageName : currentAccList.StageName,
Amount : currentAccList.Amount,
CloseDate : currentAccList.CloseDate,
Probability : currentAccList.Probability,
};
data[i] = row;
}
return data; // Array data contains the List of Opportunity records.
}
$(document).ready(function () {
var mydata = acountListData();
jQuery("#list4").jqGrid({
datatype: "local",
data: mydata,
width:1000,
height: 500,
colNames:['Name', 'Stage', 'Amount','Close Date','Probability'],
colModel:[
{name:'Name',index:'Name', width:100, sorttype:"int",align:"center"},
{name:'StageName',index:'StageName', width:100,align:"center", sorttype:"string"},
{name:'Amount',index:'Amount', width:100,align:"center"},
{name:'CloseDate',index:'CloseDate', width:100, align:"center",sorttype:"float"},
{name:'Probability',index:'Probability', width:100,align:"center",sorttype:"float"}
],
caption: "Due Proposals",
});
});
</script>
5. Add the HTML table tag inside the Body tags.
<body>
<table id="list4"><tr><td></td></tr></table>
<div id="pager"></div>
</body>
6. Here is the full code:
<apex:page>
<script src="/soap/ajax/24.0/connection.js" type="text/javascript"></script>
<script src="/soap/ajax/24.0/apex.js" type="text/javascript"></script>
<link rel="stylesheet" type="text/css" media="screen" href="http://trirand.com/blog/jqgrid/themes/redmond/jquery-ui-1.8.1.custom.css" />
<link rel="stylesheet" type="text/css" media="screen" href="http://trirand.com/blog/jqgrid/themes/ui.jqgrid.css" />
<link rel="stylesheet" type="text/css" media="screen" href="http://trirand.com/blog/jqgrid/themes/ui.multiselect.css" />
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<script src="http://trirand.com/blog/jqgrid/js/jquery.layout.js" type="text/javascript"></script>
<script src="http://trirand.com/blog/jqgrid/js/i18n/grid.locale-en.js" type="text/javascript"></script>
<script src="http://trirand.com/blog/jqgrid/js/ui.multiselect.js" type="text/javascript"></script>
<script src="http://trirand.com/blog/jqgrid/js/jquery.jqGrid.min.js" type="text/javascript"></script>
<script src="http://trirand.com/blog/jqgrid/js/jquery.tablednd.js" type="text/javascript"></script>
<script src="http://trirand.com/blog/jqgrid/js/jquery.contextmenu.js" type="text/javascript"></script>
<script type="text/javascript">
function acountListData()
{
// prepare the data
//alert(sforce.connection);
sforce.connection.sessionId = '{!$Api.Session_ID}';
var query = "SELECT Id, Name, StageName, Amount, CloseDate, Probability FROM Opportunity WHERE StageName!='Quote Sent' AND StageName!='Negotiation/Review' AND StageName!='Closed Won' AND StageName!='Closed Lost'";
var records = sforce.connection.query(query);
var accList = records.getArray('records');
var data = [];
for (var i = 0; i < accList.length; i++) {
var currentAccList = accList[i];
var row = {
Name : currentAccList.Name,
StageName : currentAccList.StageName,
Amount : currentAccList.Amount,
CloseDate : currentAccList.CloseDate,
Probability : currentAccList.Probability,
};
data[i] = row;
}
return data;
}
$(document).ready(function () {
var mydata = acountListData();
jQuery("#list4").jqGrid({
datatype: "local",
data: mydata,
width:1000,
height: 500,
colNames:['Name', 'Stage', 'Amount','Close Date','Probability'],
colModel:[
{name:'Name',index:'Name', width:100, sorttype:"int",align:"center"},
{name:'StageName',index:'StageName', width:100,align:"center", sorttype:"string"},
{name:'Amount',index:'Amount', width:100,align:"center"},
{name:'CloseDate',index:'CloseDate', width:100, align:"center",sorttype:"float"},
{name:'Probability',index:'Probability', width:100,align:"center",sorttype:"float"}
],
caption: "Due Proposals",
});
});
</script>
<body>
<table id="list4"><tr><td></td></tr></table>
<div id="pager"></div>
</body>
</apex:page>
7. To see how jQGrid and and SubGrid looks, click this link: http://gaurishgopalgoel-developer-edition.ap1.force.com/
First published on Blogger in 2015. Some screenshots and APIs have changed since; the code is kept as written.