You need to sign in to do that
Don't have an account?
Adil_SFDC
SOQL Query re use
Hi I have a SOQL query that i want to reuse by changing the where clause. I dont want to repeat the SOQL multiple times. How can this be acheived.
Here is my query
and another query I need results without Photographer_Contact__r.id = :con.id
so that i can use respective results for further processing.
Or is there a way i can process the resultlist 'groupedcases' not to include them .?
Here is my query
List<Case> groupedCases = [Select Photographer_Contact__r.Name,Scheduled_Date__c from Case where RecordType.DeveloperName In('Time_Booking', 'Media_Package', 'Photography') and Scheduled_Date__c =:dates and Photographer_Contact__r.id = :con.id];In the above query i need results without Scheduled_Date__c =:dates
and another query I need results without Photographer_Contact__r.id = :con.id
so that i can use respective results for further processing.
Or is there a way i can process the resultlist 'groupedcases' not to include them .?
And in other requirement where you want to exclude those field so you can exclude them by using != for ex . where cheduled_Date__c =:dates
My query returns different results if i change my where.
how can i get more explicit soql results.
can you give an example