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
Ajitkumar Pradhan 9Ajitkumar Pradhan 9 

Select id,AccountId,Account_Company_Id__c,JobDiva_ID__c from Opportunity where JobDiva_ID__c!=null AND Stage==Open

What's wrong in this query?
Best Answer chosen by Ajitkumar Pradhan 9
RKSalesforceRKSalesforce
Hi Ajitkumar,

Please change ypur query as below: 
Select id,AccountId,Account_Company_Id__c,JobDiva_ID__c, StageName  from Opportunity where JobDiva_ID__c != null AND StageName ='Open'
PLease mark as best answer if helped.

Regards,
Ramakant

All Answers

Vinod ChoudharyVinod Choudhary
Hi,

What Error you are getting ?

try this:

Select id,AccountId,Account_Company_Id__c,JobDiva_ID__c from Opportunity where JobDiva_ID__c!=null AND Stage='Open'

or
String stage = 'Open';
Select id,AccountId,Account_Company_Id__c,JobDiva_ID__c from Opportunity where JobDiva_ID__c!=null AND Stage=:stage

Hope this will help you :)

Thanks
Vinod
RKSalesforceRKSalesforce
Hi Ajitkumar,

Please change ypur query as below: 
Select id,AccountId,Account_Company_Id__c,JobDiva_ID__c, StageName  from Opportunity where JobDiva_ID__c != null AND StageName ='Open'
PLease mark as best answer if helped.

Regards,
Ramakant
This was selected as the best answer
Ajitkumar Pradhan 9Ajitkumar Pradhan 9
Thanks. I got that correct.