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
Gaurav IdnaniGaurav Idnani 

Please spot error in SOQL query

SELECT Id
                                  FROM Leave_Request__c
WHERE
                                  from_date__c>= :reqApp.from_date__c AND from_date__c <= :reqApp.to_date__c                              
OR
                                  to_date__c>= :reqApp.from_date__c AND to_date__c <= :reqApp.to_date__c
AND
                                  Resource__c = :UserInfo.getUserId()


 
Raj VakatiRaj Vakati
Try this
  
SELECT Id
                                  FROM Leave_Request__c
WHERE (from_date__c>= :reqApp.from_date__c AND from_date__c <= :reqApp.to_date__c )                             
OR  ( to_date__c>= :reqApp.from_date__c AND to_date__c <= :reqApp.to_date__c )
AND   Resource__c = :UserInfo.getUserId()

 
Ajay K DubediAjay K Dubedi
Hi Gaurav,

Below Query can fulfill your requirements, Hope this will work for you. 
SELECT Id FROM Leave_Request__c
WHERE (from_date__c>= :reqApp.from_date__c AND from_date__c <= :reqApp.to_date__c                              
OR o_date__c>= :reqApp.from_date__c AND to_date__c <= :reqApp.to_date__c
AND Resource__c = :UserInfo.getUserId())

 Please mark this as best answer if this solves your problem.

Thank you,
Ajay Dubedi