Soql for list of id until result

apexforsoql

So i have list id and query soql until I get the result. It looks like that, i want to query that soql for each id until i get result. It doesn't work good, but no error. FieldId__c is id from another object.

List<String> ids = new List<String>(); //just for example, i am getting id with method.
for (String id : ids) {
    Object__c objList = [SELECT Id FROM Object__c WHERE field__c = 'something'  and FieldId__c = :id];
    if (objList.id != null) break;
}

Best Answer

According to updated question with details, you can make one SOQL query with IN:

List<String> ids = new List<String>(); 
List<Object__c> objList = [SELECT Id FROM Object__c WHERE field__c = 'something' AND FieldId__c IN :ids];
if (objList.size() > 0) {
    //it is the same as breaking from for-loop
}

You can also make a map that matches initial Id with retrieved Object__c, if you need it later:

Map<Id, Object__c> m = new Map<Id, Object__c>();
for (Object__c o : [SELECT Id, FieldId__c FROM Object__c WHERE field__c = 'something' AND FieldId__c IN :ids]) {
    m.put(o.FieldId__c, o);
}

Related Solutions

[SalesForce] Get a list of one column from a SOQL result

I found my answer while trying very hard about how to fit it all into one query, thanks to @crmprogdev's prodding.

List<PatronTicket__Venue__c> venues = [Select Id,Name,
    (SELECT Id,Name,PatronTicket__InstanceDate__c
     FROM PatronTicket__Event_Instances__r 
     WHERE PatronTicket__TicketableEvent__c = :id
    ),
    (SELECT Id,Name 
     FROM Campaigns__r
    )
    FROM PatronTicket__Venue__c 
    WHERE Id IN 
    (SELECT PatronTicket__Venue__c 
     FROM PatronTicket__EventInstance__c 
     WHERE PatronTicket__TicketableEvent__c = :id
    )
];

List<PatronTicket__EventInstance__c> instances = new List<PatronTicket__EventInstance__c>();
List<Campaign> campaigns = new List<Campaign>();

for(PatronTicket__Venue__c v:venues) {
    instances.addAll((List<PatronTicket__EventInstance__c>)v.getSobjects('PatronTicket__Event_Instances__r'));
    campaigns.addAll((List<Campaign>) v.getSobjects('Campaigns__r'));
}

This method uses Venue__c as a sort of junction, and the getSobjects method that is inherited from SObject to get the subquery members.

One of the tricks was remembering to look for the Child Relationship Name in the relationship definition (and remembering that it doesn't always follow a reasonable pattern...)

Still, the criteria for WHICH event instances are being queried needs to be repeated in the first subquery and in the overall, otherwise we get too many records. But, it's all one query!

[SalesForce] SOQL SELECT result to Boolean variable

Extract the IsParent__c value from the SOQL at the end

Boolean isParent = [SELECT IsParent__c FROM Tab__c WHERE Id = 123456].IsParent__c;

If you are not always sure that this SOQL will return a record(record with that id could be deleted) then this way of accessing will return in an QueryException

If this is true, i would assign it to a list sObject variable and then extract value from there that way i know my code is clean and wont error out

Best Answer

Related Solutions

[SalesForce] Get a list of one column from a SOQL result

[SalesForce] SOQL SELECT result to Boolean variable

Related Topic