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
lakslaks 

Malformed query exception in OnClick javacript code

Hi,

Can anybody please tell me what is wrong in this OnClick javacript code.

 

I require to get the Status__c field on the Work objects for checking something down the line.

 

I am getting all the record ids for object Work__c and then trying to retrieve all Work objects whose ids are present in records.

However it is not working and throwing malformed query exception.

var records = {!GetRecordIds($ObjectType.Work__c)}

var result1 = sforce.connection.query("select id, Status__c from Work_Order__c where Id IN ("+records+")") ;

Exception thrown:

A problem with the OnClick JavaScript for this button or link was encountered:

{faultcode:'sf:MALFORMED_QUERY', faultstring:'MALFORMED_QUERY:
from Work_Order__c where Id IN (a0wQ0000002hdyv)
                               ^
ERROR at Row:1:Column:53
unexpected token: 'a0wQ0000002hdyv'', detail:{MalformedQueryFault:{exceptionCode:'MALFORMED_QUERY', exceptionMessage:'
from Work_Order__c where Id IN (a0wQ0000002hdyv)
                               ^
ERROR at Row:1:Column:53
unexpected token: 'a0wQ0000002hdyv'', row:'1', column:'53', }, }, }

Best Answer chosen by Admin (Salesforce Developers) 
lakslaks

Ok..i got the solution.

 

  

var idArr = {!GetRecordIds($ObjectType.Work_Order__c)}
var queryPart = "'" + idArr.join("','") + "'"
var result1 = sforce.connection.query("select id, Status__c from Work_Order__c where Id IN ("+queryPart+")") ;

 

 

All Answers

lakslaks

Ok..i got the solution.

 

  

var idArr = {!GetRecordIds($ObjectType.Work_Order__c)}
var queryPart = "'" + idArr.join("','") + "'"
var result1 = sforce.connection.query("select id, Status__c from Work_Order__c where Id IN ("+queryPart+")") ;

 

 

This was selected as the best answer
Milan SanghaniMilan Sanghani

Thanks a lot...dude....