• #17304
    Salesforce | sushant sushant #238
    Forcetalks

    In Salesforce, how can we execute query in javascript function?

    Hi All,

    How can we execute query in javascript function?

    please give suggestions

    Thanks

     

    #17920
    Salesforce | Vikas Kumar Vikas Kumar #356
    Forcetalks

    Hi sushant,

    SOQL query in javascript example
    You can use SOQL in java-script on your VF pages or any kind of java-script that you write, like we can get it executed on click of a button or link present on your detail page of a record. Below is the simple example and you can use it and modify it accordingly :

    {!REQUIRESCRIPT(“/soap/ajax/24.0/connection.js”)}
    {!REQUIRESCRIPT(“/soap/ajax/24.0/apex.js”)}
    try{
    var query = “SELECT Id,Name from Account LIMIT 2″;
    var records = sforce.connection.query(query);
    var records1 = records.getArray(‘records’);
    alert(records);
    var accountNames = ”;
    for(var i=0;i<records1.length;i++){
    accountNames = accountNames + records1[i].Name + ‘,’;
    }
    alert(accountNames);
    if(records1.length == 1){
    //window.location.href = ‘http://www.google.com’;
    }
    else{
    alert(‘There is no Account’);
    }
    }
    catch(e){
    alert(‘An Error has Occured. Error:’ +e);
    }

    you need to use .js files that are in first two lines in order to use the api of salesforce to connect and fetch the records using SOQL. In the example you will see result of SOQL in alert statement. The result that is returned contains a ‘records’ named array component that can be used to iterate over and go through all the records and use it in the same manner as we do in usual apex program. For ex account.id, account.Name etc.

    You can also use merge fields to create dynamic queries.

    Similarly you can use javascript to create, update or delete the salesforce object’s records using API. Below is the sample code you can use to create a new account record in your org.

    try{
    var accounts = [];
    var account = new sforce.SObject(“Account”);
    account.Name = “my new account Test”;
    accounts.push(account);
    var results = sforce.connection.create(accounts);
    if (results[0].getBoolean(“success”)) {
    alert(“new account created with id ” + results[0].id);
    } else {
    alert(“failed to create account ” + results[0]);
    }
    }
    catch(e){
    alert(‘An Error has Occured. Error:’ +e);
    }

    #51922
     William #11
    Forcetalks

    Try this one –

     

    <apex:page id=”page”>

    <script src=”/soap/ajax/38.0/connection.js” type=”text/javascript”>

    </script>

    <script>

    function show(){

    sforce.connection.sessionId='{!GETSESSIONID()}’;

    var queryResult=sforce.connection.query(‘select name,amount,closeDate,stageName from Opportunity’);

    var records=queryResult.getArray(‘records’);

    var result=”;

    var amt=0;

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

    result=result+'<br/>’+records[i].Name;

    }

    document.getElementById(‘page:fm:res’).innerHTML=result;

    document.getElementById(‘page:fm:amt’).innerHTML=amt;

    }

    </script>

    <apex:form id=”fm”>

    Click to See Opportunity Names

    <apex:commandButton value=”Submit” oncomplete=”show()” />

    <apex:outputLabel id=”res”/>

    </apex:form>

    </apex:page>

Viewing 3 posts - 1 through 3 (of 3 total)

Please to reply to this topic.

CONTACT US

We're not around right now. But you can send us an email and we'll get back to you, asap.

Sending

About Us

Forcetalks is a Salesforce collaboration platform for coders & developers, geeks & nerds, consultants & business heads, admins & architects, managers & marketers and of course the business owners. A community where you can learn from, where you can contribute to. For you. For Salesforce. Read More...

Copyright 2018 Forcetalks. All Right Reserved.

Log in with your credentials

or    

Forgot your details?