Sign Up ›
  • Diane Carroll
  • NEWBIE
  • 0 Points
  • Member since 2014
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
4 replies

Help with custom controller?

Hello- I'm hoping for some help with a visualforce page.  I can't seem to find the answers in the documentation. 

What I need to do is diplay a specific subset of cases on a public visualforce page.  I need to be able to include the comments as well.  I can successfully display cases but can't quite get it to the point where it only displays the ones I need. (specific record type and 2 types)

For some reason the code (as shown at the bottom) shows right across the bottom of the screen and I just can't figure out how to add the comments in a column too. I've tried creating a custom controller, but my apex fell short of success. 

Code:
<apex:page id="GraniteChangeLog2" standardController="Case" recordSetvar="cases" sidebar="false" showHeader="false" standardStylesheets="true">
 <body style="background-image:url('{!$Resource.Logo}');" />
    <apex:define name="head">
        <title>Granite State College-Change Log v2</title>
    </apex:define>
    <apex:define name="content">
        <apex:variable var="width" value="850"/>
        <apex:variable var="border" value="0"/>
        <apex:variable var="cellspacing" value="0"/>
        <apex:variable var="cellpadding" value="5"/>
 <apex:form >  

    <apex:pageBlock >
  
    <b><h1>Change Management Cases</h1></b>
        <apex:pageBlockTable value="{!cases}" var="c">    
            <apex:column value="{!c.casenumber}"/>
            <apex:column value="{!c.CreatedDate}"/>
            <apex:column value="{!c.status}"/>
            <apex:column value="{!c.subject}"/>
            <apex:column value="{!c.type}"/>
            <apex:column value="{!c.BusinessCase__c}"/>
            <apex:column value="{!c.RiskAssesment__c}"/>
            <apex:column value="{!c.RollbackPlan__c}"/>
            <apex:column value="{!c.TestPlan__c}"/>
            <apex:column value="{!c.IsClosed}"/>
          
         </apex:pageBlockTable>
          </apex:pageBlock>

 </apex:form>
 </apex:define>
 
  public class retrieveCase {

        public List getCases() {
        return [SELECT status, subject FROM Case
                WHERE RecordTypeID='012M0000000D62J' AND status != 'Closed' limit 5];
    }

 
</apex:page>

Thank you.
4 replies

Help with custom controller?

Hello- I'm hoping for some help with a visualforce page.  I can't seem to find the answers in the documentation. 

What I need to do is diplay a specific subset of cases on a public visualforce page.  I need to be able to include the comments as well.  I can successfully display cases but can't quite get it to the point where it only displays the ones I need. (specific record type and 2 types)

For some reason the code (as shown at the bottom) shows right across the bottom of the screen and I just can't figure out how to add the comments in a column too. I've tried creating a custom controller, but my apex fell short of success. 

Code:
<apex:page id="GraniteChangeLog2" standardController="Case" recordSetvar="cases" sidebar="false" showHeader="false" standardStylesheets="true">
 <body style="background-image:url('{!$Resource.Logo}');" />
    <apex:define name="head">
        <title>Granite State College-Change Log v2</title>
    </apex:define>
    <apex:define name="content">
        <apex:variable var="width" value="850"/>
        <apex:variable var="border" value="0"/>
        <apex:variable var="cellspacing" value="0"/>
        <apex:variable var="cellpadding" value="5"/>
 <apex:form >  

    <apex:pageBlock >
  
    <b><h1>Change Management Cases</h1></b>
        <apex:pageBlockTable value="{!cases}" var="c">    
            <apex:column value="{!c.casenumber}"/>
            <apex:column value="{!c.CreatedDate}"/>
            <apex:column value="{!c.status}"/>
            <apex:column value="{!c.subject}"/>
            <apex:column value="{!c.type}"/>
            <apex:column value="{!c.BusinessCase__c}"/>
            <apex:column value="{!c.RiskAssesment__c}"/>
            <apex:column value="{!c.RollbackPlan__c}"/>
            <apex:column value="{!c.TestPlan__c}"/>
            <apex:column value="{!c.IsClosed}"/>
          
         </apex:pageBlockTable>
          </apex:pageBlock>

 </apex:form>
 </apex:define>
 
  public class retrieveCase {

        public List getCases() {
        return [SELECT status, subject FROM Case
                WHERE RecordTypeID='012M0000000D62J' AND status != 'Closed' limit 5];
    }

 
</apex:page>

Thank you.