Apex Code Development You need to sign in to do that
Don't have an account?
mxalix258 Custom controller to display related records
So, what I'd like to do in my controller is query the current user id, pull the related contactid from that user, and display all Applications related to that Contact ID. (is there an easier way to do this?) Here is my code, but it doesn't seem to be working:
public class CurrentApps {
String userid = UserInfo.getUserId();
User firstuser;
public List<User> getCurrentUser(){
//Declare a new list
List<User> CurrentUser = new List<User>();
//Set the list equal to the results of the SOQL query
CurrentUser =
[SELECT
FirstName, LastName, ContactId
FROM User
WHERE Id =:userid ];
firstuser = CurrentUser.get(0);
//Return the List
return CurrentUser;
}
public List<Application__c> getUserApps(){
//Declare a new list
List<Application__c> UserApps = new List<Application__c>();
//Set the list equal to the results of the SOQL query
UserApps =
[SELECT
Name
FROM Application__c
WHERE Contact__c =:firstuser.ContactId ];
//Return the List
return UserApps;
}
}
Hi,
You can update your code as follows.
public class CurrentApps {
String userid = UserInfo.getUserId();
public List<Application__c> getUserApps(){
User CurrentUser = new User();
CurrentUser = [SELECT FirstName, LastName, ContactId FROM User WHERE Id =:userid];
//Declare a new list
List<Application__c> UserApps = new List<Application__c>();
//Set the list equal to the results of the SOQL query
UserApps = [SELECT Name FROM Application__c WHERE Contact__c =:CurrentUser.ContactId ];
//Return the List
return UserApps;
}
}
All Answers
Hi,
You can update your code as follows.
public class CurrentApps {
String userid = UserInfo.getUserId();
public List<Application__c> getUserApps(){
User CurrentUser = new User();
CurrentUser = [SELECT FirstName, LastName, ContactId FROM User WHERE Id =:userid];
//Declare a new list
List<Application__c> UserApps = new List<Application__c>();
//Set the list equal to the results of the SOQL query
UserApps = [SELECT Name FROM Application__c WHERE Contact__c =:CurrentUser.ContactId ];
//Return the List
return UserApps;
}
}
Works great...thank you!