Apex Code Development You need to sign in to do that
Don't have an account?
MVJ Custom Controller for cases
I have created a custome VF page to display a summary of cases for a specific account.
I have a custom controller and evrything is wroking just fine except I can not find a way to get the Case Owner name.
Since cases can be owned by either a Queu or a user how do I return the name to display that in my VF page.
The page and controller are below for refrence.
How do I get the Owner Name?
Here is the VF Page:
Code:
<apex:page Controller="CaseController" tabstyle="Account">
<apex:pageBlock title="Account">
<apex:pageBlockSection title="Account Detail" columns="2" collapsible="true">
<apex:outputField value="{!Account.Name}" id="AccountName"></apex:OutputField>
<apex:pageBlockSectionItem>
<apex:outputLabel value="Account Owner" for="AccountOwner"></apex:outputLabel>
<apex:outputField value="{!Account.Owner.name}" id="AccountOwner"></apex:OutputField>
</apex:pageBlockSectionItem>
<apex:outputField value="{!Account.Site}"></apex:OutputField><apex:outputText></apex:outputText>
<apex:outputField value="{!Account.BillingStreet}"></apex:OutputField><apex:outputText></apex:outputText>
<apex:outputField value="{!Account.BillingCity}"></apex:OutputField><apex:outputText></apex:outputText>
<apex:outputField value="{!Account.BillingState}"></apex:OutputField><apex:outputText></apex:outputText>
<apex:outputField value="{!Account.BillingPostalCode}"></apex:OutputField><apex:outputText></apex:outputText>
</apex:pageBlockSection>
</apex:pageBlock>
<apex:pageBlock title="Summary of cases">
<table class="list" border="0" cellspacing="0" cellpadding="0">
<tr class="headerRow"><th scope="col" class=""></th><th scope="col" class="">Total Number<br>Cases</br></th><th scope="col" class="">Cases<br></br>Open to date</th><th scope="col" class="">Cases<br></br>This Week</th><th scope="col" class="">Last Case Opened<br></br>Request #</th><th scope="col" class=""><br></br>Date Opened</th><th scope="col" class=""><br></br>Description</th></tr>
<tr><td scope="col">Service</td><td scope="col" class="">{!ServiceCount}</td><td scope="col" class="">{!ServiceCountOpen}</td><td scope="col" class="">{!ServiceCountOpenThisWeek}</td><td scope="col" class=""><a href="/{!LastOpenServiceCase.Id}">{!LastOpenServiceCase.CaseNumber}</a></td><td scope="col" class="">{!LastOpenServiceCase.CreatedDate}</td><td scope="col" class="">{!LastOpenServiceCase.subject}</td></tr>
<tr><td scope="col">Project</td><td scope="col" class="">{!ProjectCount}</td><td scope="col" class="">{!ProjectCountOpen}</td><td scope="col" class="">{!ProjectCountOpenThisWeek}</td><td scope="col" class=""><a href="/{!LastOpenProjectCase.Id}">{!LastOpenProjectCase.CaseNumber}</a></td><td scope="col" class="">{!LastOpenProjectCase.CreatedDate}</td><td scope="col" class="">{!LastOpenProjectCase.subject}</td></tr>
</table>
</apex:pageBlock>
<apex:pageBlock title="Service / Project Cases" >
<apex:pageBlockSection title="Open Service Requests" columns="1" collapsible="true">
<apex:dataTable value="{!ServiceCases}" var="each" cellpadding="10" border="0" styleClass="list">
<apex:column headerValue="Action"><a href="/{!each.Id}/e—retURL=/apex/CaseSummaryView–Id={!account.Id}"><b>Edit</b></a><b> | </b><a href="/{!each.Id}/s˜retURL=/apex/CaseSummaryView™Id={!account.Id}"><b>Cls</b></a> </apex:column>
<apex:column headerValue="Case"><a href="/{!each.Id}">{!each.CaseNumber}</a></apex:column>
<apex:column headerValue="Contact Name">{!each.Contact.Name}</apex:column>
<apex:column headerValue="Subject">{!each.subject}</apex:column>
<apex:column headerValue="Priority">{!each.Priority}</apex:column>
<apex:column headerValue="Status">{!each.Status}</apex:column>
<apex:column headerValue="OwnerId">{!each.OwnerId}</apex:column>
</apex:dataTable>
</apex:pageBlockSection>
<apex:pageBlockSection title="Open Timekeeper Projects" columns="1" collapsible="true">
<apex:dataTable value="{!ProjectCases}" var="each" cellpadding="10" border="0" styleClass="list">
<apex:column headerValue="Action"><a href="/{!each.Id}/e?retURL=/apex/CaseSummaryView?Id={!account.Id}"><b>Edit</b></a><b> | </b><a href="/{!each.Id}/s?retURL=/apex/CaseSummaryView?Id={!account.Id}"><b>Cls</b></a> </apex:column>
<apex:column headerValue="Case"><a href="/{!each.Id}">{!each.CaseNumber}</a></apex:column>
<apex:column headerValue="Contact Name">{!each.Contact.Name}</apex:column>
<apex:column headerValue="Subject">{!each.subject}</apex:column>
<apex:column headerValue="Priority">{!each.Priority}</apex:column>
<apex:column headerValue="Status">{!each.Status}</apex:column>
<apex:column headerValue="OwnerId">{!each.OwnerId}</apex:column>
</apex:dataTable>
</apex:pageBlockSection>
</apex:pageBlock>
<apex:pageBlock title="Customer Service Center Cases" >
<apex:pageBlockSection title="Service Cases" columns="1" collapsible="true">
</apex:pageBlockSection>
<apex:pageBlockSection title="Adjustment Cases" columns="1" collapsible="true">
</apex:pageBlockSection>
<apex:pageBlockSection title="Trouble Tickets" columns="1" collapsible="true">
</apex:pageBlockSection>
<apex:pageBlockSection title="Orders" columns="1" collapsible="true">
</apex:pageBlockSection>
</apex:pageBlock>
</apex:page>Here is the Controller:
Code:
public class CaseController{
//** Service Request Functions
Public Integer getServiceCount(){
return [Select Count() from Case where AccountId= :System.currentPageReference().getParameters().get('id')and RecordType.Name = 'Service Request'];
}
Public Integer getServiceCountOpen(){
return [Select Count() from Case where AccountId= :System.currentPageReference().getParameters().get('id') and isClosed = false and RecordType.Name = 'Service Request' ];
}
Public Integer getServiceCountOpenThisWeek(){
return [Select Count() from Case where AccountId= :System.currentPageReference().getParameters().get('id') and isClosed = false and CreatedDate = THIS_WEEK and RecordType.Name = 'Service Request'];
}
Public Case getLastOpenServiceCase(){
return [Select Id, CaseNumber, Subject, CreatedDate from Case where AccountId= :System.currentPageReference().getParameters().get('id') and isClosed = false and RecordType.Name = 'Service Request' Order By CreatedDate desc limit 1];
}
Public Case[] getServiceCases(){
return [Select id, CaseNumber, ContactId, Contact.Name, OwnerId, Priority, Status, Subject from Case where accountid = :System.currentPageReference().getParameters().get('id') and isclosed = false and RecordType.Name = 'Service Request'];
}
//** TimeKeeper Project Functions
Public Integer getProjectCount(){
return [Select Count() from Case where AccountId= :System.currentPageReference().getParameters().get('id')and RecordType.Name = 'TimeKeeper Project'];
}
Public Integer getProjectCountOpen(){
return [Select Count() from Case where AccountId= :System.currentPageReference().getParameters().get('id') and isClosed = false and RecordType.Name = 'Timekeeper Project' ];
}
Public Integer getProjectCountOpenThisWeek(){
return [Select Count() from Case where AccountId= :System.currentPageReference().getParameters().get('id') and isClosed = false and CreatedDate = THIS_WEEK and RecordType.Name = 'Timekeeper Project'];
}
Public Case getLastOpenProjectCase(){
return [Select Id, CaseNumber, Subject, CreatedDate from Case where AccountId= :System.currentPageReference().getParameters().get('id') and isClosed = false and RecordType.Name = 'Timekeeper Project' Order By CreatedDate desc limit 1];
}
Public Case[] getProjectCases(){
return [Select id, CaseNumber, ContactId, Contact.Name, OwnerId, Priority, Status, Subject from Case where accountid = :System.currentPageReference().getParameters().get('id') and isClosed = false and RecordType.Name = 'Timekeeper Project'];
}
//** Other functions
Public Account getAccount(){
//return [Select id, name from Account where id = :System.currentPageReference().getParameters().get('id')];
return [Select id, name, Owner.Name, Site, BillingStreet, BillingCity, BillingState, BillingPostalCode
from Account where id = :System.currentPageReference().getParameters().get('id')];
}
Public Case[] getAccountCases(){
return [Select id, CaseNumber, ContactId, Contact.Name, OwnerId, Priority, Status, Subject from Case where accountid = :System.currentPageReference().getParameters().get('id')];
}
}
But how do I pass a variable to the getter so it knows what user to pull?
I want this to be in the repeat function where I am currently displaying the OwnerId.
Any thoughts?
You can use Owner.Name in the SOQL statement and SFDC will pull back the correct user name regardless of if it is a users or Queue.