function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Hannah CampbellHannah Campbell 

can i ask for help with this one?

I was trying to select the Position Name, Candidate Name, Candidate Phone, and Candidate Email for all the Job Application where the status is Approved

public class jobApplicationTempt{
    public Id JobApplicationId {get;set;}
    public List<Job_Application__c> getJobApplication(){
        List<Job_Application__c> listOfJobApp;
        listOfJobApp=[SELECT Name__c,Phone__c, Email__c From Job_Application__c WHERE status=="Approved"];
        return listOfJobApp;
    }
}
Best Answer chosen by Hannah Campbell
v varaprasadv varaprasad
Hi Hannah,

Please check once below code : 

 
public class jobApplicationTempt{
    public Id JobApplicationId {get;set;}
    public List<Job_Application__c> getJobApplication(){
        List<Job_Application__c> listOfJobApp;
        listOfJobApp=[SELECT Name,Phone__c, Email__c From Job_Application__c WHERE status__c = 'Approved'];
        return listOfJobApp;
    }
}

Execute below query in developer console and check query is working or not : 

SELECT Name,Phone__c, Email__c From Job_Application__c WHERE status__c = 'Approved'


Hope this helps you!
If my answer helps resolve your query, please mark it as the 'Best Answer' & upvote it to benefit others.

Thanks
Varaprasad
@For  Support: varaprasad4sfdc@gmail.com

All Answers

Hannah CampbellHannah Campbell
User-added image
v varaprasadv varaprasad
Hi Hannah,

Please check once below code : 

 
public class jobApplicationTempt{
    public Id JobApplicationId {get;set;}
    public List<Job_Application__c> getJobApplication(){
        List<Job_Application__c> listOfJobApp;
        listOfJobApp=[SELECT Name,Phone__c, Email__c From Job_Application__c WHERE status__c = 'Approved'];
        return listOfJobApp;
    }
}

Execute below query in developer console and check query is working or not : 

SELECT Name,Phone__c, Email__c From Job_Application__c WHERE status__c = 'Approved'


Hope this helps you!
If my answer helps resolve your query, please mark it as the 'Best Answer' & upvote it to benefit others.

Thanks
Varaprasad
@For  Support: varaprasad4sfdc@gmail.com
This was selected as the best answer