Returning Count() from SOQL Query in a Javascript Function

Question

I am trying to return the number of products of with the ProductName = EAP related to an Opportunity. Here is my code:

function getProductTypes (oppId) { 

var result = sforce.connection.query("Select COUNT() From OpportunityLineItem where OpportunityId = '" + oppId + "' and PricebookEntry.Product2.Name IN ('EAP') "); 

return result; 

}

What I want to do is return the number of number of "EAP" products related to the opportunity so then in the below code block, I can determine another piece of code to run:

if(getProductTypes('{!Opportunity.Id}') >= 1){ 
//run this code!
}else{
//run this code instead!
}

eyescream · Accepted Answer · 2014-05-07 17:17:25Z

1

In case of doubt - alert() or console.log() is your best friend ;) Closely followed by specification of the QueryResult object (it's in different document than the AJAX toolkit developer guide...)

This should work:

function getProductTypes (oppId) { 

    var result = sforce.connection.query(...);

    alert(result); // remove it once you're happy
    return result == null ? 0 : result.size;
}

answered May 7, 2014 at 17:17

eyescream

19.8k3 gold badges39 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Returning Count() from SOQL Query in a Javascript Function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related