Recently, we had a requirement from one of our clients, wherein they wanted a page where user had to enter the Account Name. We were required to validate that account name and then do further processing.
In below code snippets, we are checking if the Account name entered by the user is valid by querying on Account table/object directly in the JavaScript code. To simplify the code, we have used the variable AccountName in JavaScript to specify the account name.
———————————————————————-<snip>
<apex:page >
<script language=”JavaScript1.2″ src=”/js/functions.js”></script>
<script src=”/soap/ajax/9.0/connection.js” type=”text/javascript”></script>
<script id=”clientEventHandlersJS” language=”javascript”>
function CallSOQL()
{
sforce.connection.sessionId = ‘{!$Api.Session_ID}’;
try
{
alert(‘Select Name, Id From Account ORDER BY Name’);
var AccountName=” TEST ACCOUNT”;
var qr = sforce.connection.query(“SELECT id,name FROM Account where Name='”+ AccountName +”‘”);
var records = qr.getArray(“records”);
alert(‘qr ‘+qr);
}
catch (error)
{
alert(error.faultstring);
}
if (qr.size == 0)
{
alert(“No Record found.”);
}
else
{
for (var i=0;i<qr.records.length;i++)
{
alert(qr.records[i].Name);
}
}
}
</script>
<input type=”button” onclick=”CallSOQL();” value=”Call SOQL Query”/></apex:page>
———————————————————————-<snip>
By using the above given code, you can query on any object or custom object of Salesforce without writing code on controller side.
Greytrix offers GUMU™ for Salesforce – Sage 300 (Accpac) Integration a best of breed solution for organizations to enhance their customer interaction.
About Us
Greytrix as a Salesforce Product development partner offers a wide variety of integration products and services to the end users as well as to the Partners across the globe. We offers Consultation, Configuration, Training and support services in out-of-the-box functionality as well as customizations to incorporate custom business rules and functionalities that requires apex code incorporation into the Salesforce platform.
Greytrix has some unique solutions for Cloud CRM such as Salesforce integration with Sage Enterprise Management (Sage X3), Sage Intacct, Sage 100 and Sage 300 (Sage Accpac). We also offer best-in-class Cloud CRM Salesforce customization and development services along with services such as Salesforce Data Migration, Integrated App development, Custom App development and Technical Support to business partners and end users.
Greytrix GUMU™ integration for Sage ERP – Salesforce is a 5-star app listed on Salesforce AppExchange.
For more information, please contact us at salesforce@greytrix.com. We will be glad to assist you.