You need to sign in to do that
Don't have an account?

searching Record is not working
Hi
I have created a page which is search record based on date.i have created but when i click there no return of record .any one can help me out .
I have created a page which is search record based on date.i have created but when i click there no return of record .any one can help me out .
<apex:page sidebar="false" Controller="BankBookSectionsController" showHeader="false"> <apex:form > <apex:pageMessages ></apex:pageMessages> <style type="text/css" media="print"> @media print { #non-printable { display: none; } #printable { display: block; width: 100%; height: 100%; } } </style> <style type = "text/css"> .colHeadr {text-align:center;} .colHeadrRight{ text-align:right; } } </style> <apex:define name="body"> <div style="width:800px;margin: 0px auto 10px auto;border: 1px solid black;"> <center><h1><apex:sectionHeader title="This is Party/Master Group Report"/></h1></center> <apex:outputLink style="font-weight: bold;float:right;" value="{!URLFOR($Page.LoginPage)}"><b>Back To Home</b> </apex:outputLink> <b>Start Date</b><apex:inputField value="{!j.Date__c}"/> <b>End Date</b><apex:inputField value="{!j.Date__c}"/> <apex:commandButton value="Go" action="{!displaingTable}" reRender="dt" style="background:green"/> <b><apex:commandLink id="printable" onclick="JavaScript:window.print();" value="Print"/></b> <apex:repeat value="{!Groups }" var="state" > <apex:pageBlock title="{!state}"> <apex:repeat value="{!accounts}" var="account"> <apex:outputPanel rendered="{!IF(state=account.Group__c,true,false)}" style="color:red;"> {!account.Name} - {!account.Master_Code__c}<br/> </apex:outputPanel> </apex:repeat> </apex:pageBlock> </apex:repeat> </div> </apex:define> </apex:form> </apex:page>
public with sharing class BankBookSectionsController { public MasterTest__c j { get; set; } public List<MasterTest__c> accounts {get;set;} public String[] Groups {get;set;} public BankBookSectionsController (){ accounts =new List<MasterTest__c>(); j=new MasterTest__c(); } public date startdate1; public date enddate1; public void displaingTable(){ startdate1=j.Date__c; enddate1=j.Date__c; accounts = [select ID,name,Group__c,Master_Code__c,Date__c from MasterTest__c where (Date__c>=:startdate1) AND (Date__c<=:enddate1)order by Date__c ASC]; // accounts = [Select ID, Name,Group__c,Master_Code__c,Date__c From MasterTest__c // Where Group__c IN ('Group 00','Group 01','Group 02','Group 03','Group 04','Group 05','Group 06','Group 07','Group 08','Group 09','Group 10','Group 11','Group 12','Group 13' // ,'Group 14','Group 15','Group 16','Group 17','Group 18','Group 19','Group 20','Group 21','Group 22','Group 23','Group 24','Group 25','Group 26','Group 27','Group 28', //'Group 29','Group 30','Group 31','Group 32','Group 33','Group 34','Group 35','Group 36','Group 37','Group 38','Group 39','Group 40') ]; // dynamically create set of unique states from query Set<String> stateSet = new Set<String>(); for (MasterTest__c a : accounts) stateSet.add(a.Group__c); // convert the set into a string array Groups = new String[stateSet.size()]; Integer i = 0; for (String state : stateSet) { Groups [i] = state; i++; } } // for demo purposes limit the states }