function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Shruti NigamShruti Nigam 

soql query in lightning controller.js

Hi all,

Is there any way we can write soql query in lightning controller,js ?

Thanks in advance
karthikeyan perumalkarthikeyan perumal
Hello, 

you can not directly use SOQL auery in lightning javascript controller.  you need to write server side controller with @auraEnabled method. 

For Example: 

Class:  
public with sharing class Books4EveryoneHomeController {
  @AuraEnabled
  public static List<Book__c> getBooks(){
    return; 
}
}

in Component controller: 

  
({
  doInit: function(component, event, helper) {
    var action = component.get("c.getBooks");
    action.setCallback(this, function(data) {
      component.set("v.Books", data.getReturnValue());
      console.log(data.getReturnValue());
    });
    $A.enqueueAction(action);
  }
})


   Hope this will helps you. 

Thanks
karthik
 
Deepali KulshresthaDeepali Kulshrestha
Hi Shruti,

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 :

Javascript code:
  
{!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.

Javascript code:
  
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); 
}

I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.

Thanks and Regards,
Deepali Kulshrestha