Monday, February 6, 2012

Querying Account details using Salesforce Connection.js


<apex:page standardController="case">
<script src="/soap/ajax/23.0/connection.js" type="text/javascript"></script>
<script type="Text/javascript">
sforce.connection.login("prakumar123@progress.com", "welcome123KfENXmgve3IefdHP5ZNr2f9Gc");
function setupPage()
{
var qry="Select Id, Name, Industry From Account";
var result=sforce.connection.query(qry,layoutResults);
}
function layoutResults(queryResult, source)
{
if (queryResult.size > 0)
{
var output = "";
var records = queryResult.getArray('records');
for (var i = 0; i < records.length; i++)
{
var account = records[i];
output += account.Id + " " + account.Name +" [Industry - " + account.Industry + "]<br>";
document.getElementById("out").innerHTML=output;
}
}
}
</script>
<apex:pageBlock >
<input type="button" Title="Get Accounts" Value="Click me" OnClick="setupPage()"/>
<div id="out">test</div>
<apex:includeScript value="/soap/ajax/23.0/connection.js"/>
</apex:pageBlock>
</apex:page>

No comments:

Post a Comment