I'm working with 2 custom objects A and B. A has only one Text Field. B has 4 Text Fields. My controller program is such that every A's Field has been mapped to one of the 4 Text Fields in B. During system.debug I can see all the mapped values. But I couldnt get a proper way to print the same mapped values in a visualforce page. Is there a way to print my map in a visualforce page?

I'm working with 2 custom objects A and B. A has only one Text Field. B has 4 Text Fields. My controller program is such that every A's Field has been mapped to one of the 4 Text Fields in B. During system.debug I can see all the mapped values. But I couldnt get a proper way to print the same mapped values in a visualforce page. Is there a way to print my map in a visualforce page?

Hi,

Can anyone please tell me the solution for duplicate value display in VisualForce page.

The SOQL query retrieve the correct output.But in VisualForce page ,it display the N-number of times of same output.

SOQL Output:


VisualForce Page Output:(It display more than one times)


Apex Controller:
 

public with sharing class CollegeCourseClassic {
    
    Public List <CSM_Courses_By_Colleges__c> courses{get;set;} 
  // the soql without the order and limit
  private String soql {get;set;}
  // the collection of contacts to display
   public List<String> listOfCourseName {get;set;}
	public List<String> listCollegeName {get;set;}
    public List<String> listDistrictName {get;set;}
  // the current sort direction. defaults to asc
 public string college{get;set;}
     public string course{get;set;}
    public string state{get;set;}
       public string level{get;set;}
     public string district{get;set;}
  // the current field to sort by. defaults to last name
 

  // format the soql for display on the visualforce page
  public String debugSoql {
    get { return soql + 'limit 100'; }
    set;
  }

  // init the controller and display some sample data when the page loads
  public CollegeCourseClassic() {
      
   listOfCourseName = new List<String>();
        listCollegeName = new List<String>();
        listDistrictName = new List<String>();
        for(CSM_Courses_By_Colleges__c courseName: [select id,name from ICSM_Courses_By_Colleges__c ])
			listOfCourseName.add(courseName.name);
        for(CSM_COLLEGES__C clgname: [select id,College_Name__c from CSM_COLLEGES__C limit:500])
            listCollegeName.add(clgname.College_Name__c);
        for(CSM_COLLEGES__C distName: [select id, District__c from CSM_COLLEGES__C])
        	listDistrictName.add(distName.District__c);
    soql = 'Select id,name,College_UGC_Id__r.College_UGC_Id__c,College_UGC_Id__r.state__c,College_UGC_Id__r.College_Name__c,College_UGC_Id__r.District__c,College_UGC_Id__r.Name,College_UGC_Id__r.City_Town__c ,Course_Level__c,Degree_Conferred__c,Department__c,Student_Intake__c From CSM_Courses_By_Colleges__c';
   runQuery();
  }


 
  // runs the actual query
  public void runQuery() {

    try {
         System.debug(soql);
      courses = Database.query(soql +' limit 100');
       
    } catch (Exception e) {
      ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.ERROR, 'Ooops!'+e));
    }

  }

  // runs the search with parameters passed via Javascript
  public void search_method() {

      
    soql = 'Select id,name,College_UGC_Id__r.College_UGC_Id__c,College_UGC_Id__r.state__c,College_UGC_Id__r.College_Name__c,College_UGC_Id__r.District__c,College_UGC_Id__r.Name,College_UGC_Id__r.City_Town__c ,Course_Level__c,Degree_Conferred__c,Department__c,Student_Intake__c From CSM_Courses_By_Colleges__c where College_UGC_Id__r.College_Name__c != null';
    if (!college.equals(''))
         System.debug('college'+college);
      soql += ' and College_UGC_Id__r.College_Name__c  LIKE \''+String.escapeSingleQuotes(college)+'%\'';
         

    if (!course.equals(''))
      soql += ' and name LIKE \''+String.escapeSingleQuotes(course)+'%\'';
    if (!district.equals(''))
      soql += ' and College_UGC_Id__r.District__c LIKE \''+String.escapeSingleQuotes(district)+'%\'';  
    if (!level.equals('select'))
      soql += ' and Course_Level__c LIKE \''+String.escapeSingleQuotes(level)+'%\'';
 	if (!state.equals('selectst'))
      soql += ' and College_UGC_Id__r.state__c LIKE \''+String.escapeSingleQuotes(State)+'%\'';
    
    // run the query again
    runQuery();


  }


     public List<SelectOption> getcourselevel() {
         list<selectoption> options = new list<selectoption>();            
    Schema.DescribeFieldResult fieldResult = CSM_COURSES_BY_COLLEGES__c.Course_Level__c.getDescribe();
    list<schema.picklistentry> values = fieldResult.getPickListValues(); 
         options.add(new SelectOption('select','--Select Course Level--')); 
    for (Schema.PicklistEntry a : values) 
    {                  
        options.add(new SelectOption(a.getLabel(), a.getValue()));
    } 
  
    return options;
}
    public List<selectoption> getStates()
{           
    list<selectoption> options = new list<selectoption>();            
    Schema.DescribeFieldResult fieldResult = CSM_COLLEGES__c.State__c.getDescribe();
    list<schema.picklistentry> values = fieldResult.getPickListValues(); 
        options.add(new SelectOption('selectst','--Select State--')); 
    for (Schema.PicklistEntry a : values) 
    {     
        options.add(new SelectOption(a.getLabel(), a.getValue()));
    } 
  
    return options; 


}

}

VisualForcePage 
 

<apex:page controller="CollegeCourseClassic" title="College Courses" sidebar="false" docType="html-5.0">

    <apex:includeScript value="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js" />
    <apex:includeScript value="https://cdn.datatables.net/1.10.11/js/jquery.dataTables.min.js" />
    <apex:stylesheet value="{!URLFOR($Resource.SLDS0120, 'assets/styles/salesforce-lightning-design-system-vf.css')}" />
    <apex:stylesheet value="https://maxcdn.bootstrapcdn.com/font-awesome/4.5.0/css/font-awesome.min.css"/>
    <html xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
<apex:form >
   <script>
        function ChangeMode(mode){
            if(mode=='Awardees'){
                document.getElementById('awardees').style.display = 'block';
                document.getElementById('applicants').style.display = 'none';
                initAwardeesTableSearch();
                ApplicantsTableSearhDestroy();
            }
            if(mode=='Applicants'){
                document.getElementById('awardees').style.display = 'none';
                document.getElementById('applicants').style.display = 'block';
                initApplicantsTableSearch();
                AwardeesTableSearchDestroy();
            }

            quickSearch("text-input-01");
        }
            </script> 

    <style>
        #header{
            font-size:24px !important;
            text-align:center;
            margin-bottom:16px;
            margin-top:16px;
        }
        .filterlist{
            width: 16%;
            float:right;
            font-size: 16px;
            margin-left: 1px;
            margin-right: 20px;
        }
        .orgnamefilter{
            width: 25%;
            float:right;
            font-size: 16px;
            margin-right: 10px;
        margin-left: 10px;
        
        }
         .orgnamefilter1{
            width: 25%;
            float:right;
            font-size: 16px;
            margin-right: 10px;
        margin-left: 200px;
        
        }
        .issueArealist {
            width: 15%;
            
        margin-right: 450px;
        

        }
        .issueArealist1 {
            width: 15%;
          
        margin-right: 100px;
        

        }
        .profilelisting{
            width:97%;
            margin-left:1%;
            margin-right:3%;
        }
        .profilelisting td{
            vertical-align:middle !important;
            font-size:12px;
        }
        .tablecontainer{
            position:relative;
            top:20px;
        }
        #select-01{
            height:36px;
            line-height:36px;
            cursor: pointer;
        }
        #select-issue-area{
            height:36px;
            line-height:36px;
            cursor: pointer;
        }
        .buttonclass{
            font-size:12px;
        }
        .logo{
            width:50px;
            margin-right:10px;
        }
        .redbutton{
            background-color:#89211B !important;
            white-space:nowrap;
            border-style:none !important;
            font-weight:normal !important;
        }
        .yellowbutton{
            background-color:#FAA418 !important;
            white-space:nowrap;
            color:#89211B !important;
            border-style:none !important;
            font-weight:normal !important;
        }
        .orangebutton{
            background-color:#F15323 !important;
            border-style:none !important;
            font-weight:normal !important;
        }
        .btn:hover{
            opacity:0.8;
        }
        .link{color:#89211B !important;}
        .link:hover{color:#F15323 !important;}
        .slds img {
            max-width: none !important;
        }
        .fa-star {
            color: #8C1D04;
        }
        .center{text-align:center;}
    </style>
    <script type="text/javascript">
    function changeMe(sel)
    {
      sel.style.color = "#000";              
    }
</script>
    <!-- REQUIRED SLDS WRAPPER -->
    <div class="slds" style="margin-bottom:100px">
        <div id="header">
           Find Colleges and Courses
        </div>
        <table>
            <tr>
                <td > <apex:inputText id="text-input-01" list="{!listCollegeName}" value="{!college}" html-placeholder="Enter College Name" /></td> 
                <td >
                                       
                        <apex:inputText id="text-input-02" list="{!listOfCourseName}" value="{!course}" html-placeholder="Enter Course Name"/> 
           
                
            </td>
                <td >
              
                             	<apex:selectList value="{!level}" size="1"> 
                    				   <apex:selectOptions value="{!courselevel}"  />
          						</apex:selectList>

            </td>
                <td >   <apex:selectList value="{!state}" size="1"> 
                    				<apex:selectOptions value="{!States}" />
          						</apex:selectList></td>
               <td> 
               <apex:inputText id="select-01" list="{!listDistrictName}" value="{!district}" html-placeholder="Enter District"/> </td> 
              <td >  <apex:commandButton value="Go!" action="{!search_method}"    /></td>       
            </tr>
        </table>
       <apex:outputPanel title="">
     <apex:pageMessages ></apex:pageMessages>
     </apex:outputPanel>
        <div id="awardees" width="95%" class="tablecontainer">
        <table id="awardeesTable" class="slds-table slds-table--bordered profilelisting" cellpadding="3px !important">
                <thead>
                    <tr class="slds-text-heading--label">
                        <th onclick="simulateTHclick('1');" colspan="1" class="slds-is-sortable" scope="col" width="12%">
                            College Name
                            <button class="slds-button slds-button--icon-bare">
                                <svg aria-hidden="true" class="slds-button__icon slds-button__icon--small">
                                    <use xlink:href="{!URLFOR($Resource.SLDS0120, '/assets/icons/utility-sprite/svg/symbols.svg#arrowdown')}"></use>
                                </svg>
                                <span class="slds-assistive-text">Sort</span>
                            </button>
                        </th>
                        
                        <th width="10%" onclick="simulateTHclick('3');" class="slds-is-sortable slds-cell-wrap" scope="col">Distict
                            <button class="slds-button slds-button--icon-bare">
                                <svg aria-hidden="true" class="slds-button__icon slds-button__icon--small">
                                    <use xlink:href="{!URLFOR($Resource.SLDS0120, '/assets/icons/utility-sprite/svg/symbols.svg#arrowdown')}"></use>
                                </svg>
                                <span class="slds-assistive-text">Sort</span>
                            </button>
                        </th>
                        <th onclick="simulateTHclick('4');" width="10%" class="slds-is-sortable slds-cell-wrap" scope="col">
                            <apex:outputtext value="State" id="LastPublished"/>
                            <button class="slds-button slds-button--icon-bare">
                                <svg aria-hidden="true" class="slds-button__icon slds-button__icon--small">
                                    <use xlink:href="{!URLFOR($Resource.SLDS0120, '/assets/icons/utility-sprite/svg/symbols.svg#arrowdown')}"></use>
                                </svg>
                                <span class="slds-assistive-text">Sort</span>
                            </button>
                        </th>
                                </tr>
                    <tr style="display:none;">
                        <th column-valueAwd="0" scope="col">&nbsp;</th>
                        <th column-valueAwd="1" scope="col">&nbsp;</th>
                        <th column-valueAwd="2" scope="col">&nbsp;</th>
                                                                  </tr>
                </thead>
                <tbody>
                   <!--LIST OUT ALL THE colleges and courses-->
                    <!-- COllege Name with State and District -->
                   
                    <apex:repeat value="{!courses}" var="ccourse" >
                    <tr >
                        <td class="slds-cell-wrap">
                               {!ccourse.College_UGC_Id__r.College_Name__c}
                        </td>
                         <td class="slds-cell-shrink">  {!ccourse.College_UGC_Id__r.District__c}</td>
                         <td class="slds-cell-shrink">  {!ccourse.College_UGC_Id__r.state__c}</td> 
                       <!--  <td class="slds-cell-wrap">  {!ccourse.CSM_Courses_By_Colleges__c.Name}</td> -->
                     </tr>
                     <tr>
                     <td colspan ="3">
                         
                        <!-- List of   Course  display under college  -->
                       <table id="coursesTable" class="slds-table slds-table--bordered profilelisting" cellpadding="3px !important">
                       <apex:repeat value="{!courses}" var="cont">
                        <tr>
                           <td class="slds-cell-wrap">  {!cont.Name}</td> 
                            
                           <td class="slds-cell-wrap">  {!cont.Course_Level__c}</td>
                           <td class="slds-cell-shrink"> {!cont.Degree_Conferred__c}</td>
                          <td  class="slds-cell-shrink"> {!cont.Department__c}</td>
                          <td class="slds-cell-shrink">{!cont.Student_Intake__c}</td>
                        
                         </tr>
                              </apex:repeat>
                            </table> 
                          </td>              </tr>
                    </apex:repeat>
               </tbody>
        </table>
        </div>

           </div>
             

</apex:form>
    </html>
        
</apex:page>

Thanks,
Sivapriyaa M S


 

Please guide how to display collection items on vf page with iteration. Also while developing this what things I must remember?