[SalesForce] How to add colon to a string value before dynamic soql query

I have a soql statement which is used to soql the result from a sObject but I need to mention the id in the soql how can add colon to the both side of id. my requirement

SELECT Result__c,Notes__c FROM Visits__c WHERE Is_latest__c = true and projectGroupId__c = '4390283nknfdkjs' and survey__c != null and Project_Group__c != null limit 1

But I am not getting the colon because of it the dynamic soql is getting error.
my string soql

soqlQuery = 'SELECT '+ survey.Included_Questions__c +' FROM Visits__c WHERE Project_Group__r.id ='+projectGroupId+' and Is_latest__c = true and survey__c != null and Project_Group__c != null limit 1';

please guide me how to achieve it.

Best Answer

One version of your dynamic SOQL that would work is to include the quotes that are required around a literal ID value like this:

soqlQuery = 'SELECT '+ survey.Included_Questions__c +' FROM Visits__c '
        + 'WHERE Project_Group__r.id =\''+projectGroupId+'\' and Is_latest__c = true and survey__c != null and Project_Group__c != null limit 1';

Another approach is to have the simple bind variable projectGroupId in scope when you execute the query, and then you can just have the variable name after a colon in the SOQL:

soqlQuery = 'SELECT '+ survey.Included_Questions__c +' FROM Visits__c '
        + 'WHERE Project_Group__r.id = :projectGroupId and Is_latest__c = true and survey__c != null and Project_Group__c != null limit 1';

This approach avoids the SOQL injection risk on that field.

Related Solutions

[SalesForce] How to take a field value after dynamic SOQL

You can use the get method, but this is not so simple when you need to access relationship fields.

In more details if you have the following SoQL

List <MyCustomObject__c> myList = [SELECT id, name, rel__r.Name FROM ....] ;

you can access the fields of MyCustomObject__c retrieved using the following notation

for (MyCustomObject__c mco:myList)
{
    system.debug('name:' + mco.get('name'));
}

However in your case you need to traverse relationships so its a little bit more complex. You need one more step to retrieve the related object using

SObject a = mco.getSObject('rel__c');

then you need to do one more step using get method on a.

For more details check this http://www.salesforce.com/us/developer/docs/apexcode/Content/apex_dynamic_dml.htm

[SalesForce] Query for a list of IDs using Dynamic SOQL from JavaScript

Since you're dealing with a list of IDs, you want to use 'IN' instead of '='. The SOQL statement needs to end up looking like this

SELECT name FROM obj__c WHERE id IN ('a0OaxxxxxxxxMRDy2', 'a0OaxxxxxxxxMRDy2')

Edit by OP: it's been a while since I had the problem, but I've put this in my original post and as per Ratan's suggestion, I should mark this as accepted answer:

var records = {!GETRECORDIDS($ObjectType.obj__c)}.toString().replace(/,/g , "','"); 
var soqlQ="SELECT name FROM obj__c WHERE Id in ('"+records+"')";

Best Answer

Related Solutions

[SalesForce] How to take a field value after dynamic SOQL

[SalesForce] Query for a list of IDs using Dynamic SOQL from JavaScript

Related Topic