You need to sign in to do that
Don't have an account?
Vignesh Ramshetty
unable to decleare child objects fields getting Error: Unknown property 'VisualforceArrayList.Life_Insurances__r'
APEX CLASS :
Public with sharing class viewholderdetails{
public string name{set;get;}
public list<Policy_Holder__c> Message {set;get;}
Public list<Policy_Holder__c> Message2 {set;get;}
public void getdata() {
Message = [SELECT id,(SELECT id, Name, Due_date__c, Premium_Start_Date__c, Premium_End_date__c, Premium_Type__c, Total_amt_paid__c FROM Life_Insurances__r)
FROM Policy_Holder__c WHERE Policy_ID__c =: name];
Message2 = [SELECT id,(SELECT id, Name, Due_date__c, Premium_Start_Date__c, Premium_End_date__c, Premium_Type__c, Total_amt_paid__c FROM Motor_Insurances__r)
FROM Policy_Holder__c WHERE Policy_ID__c =: name];
}
}
Visualforce page :
<apex:page Controller="viewholderdetails">
<apex:form >
<apex:pageBlock title="Life Insurance Project">
<apex:pageMessages />
<apex:pageBlockSection title="Insurance datiles">
Enter Policy holder ID :<apex:inputtext value="{!name}"/>
<apex:commandButton value="Submit" action="{!getdata}"/>
</apex:pageBlockSection>
<apex:pageBlock >
<apex:pageMessages />
<apex:pageBlockTable value="{!Message.Life_Insurances__r}" var="me" >
<apex:column value="{!me.Name}" />
<apex:column value="{!me.Due_date__c}"/>
<apex:column value="{!me.Premium_Start_Date__c}"/>
<apex:column value="{!me.Premium_End_date__c}"/>
<apex:column value="{!me.Premium_Type__c}"/>
<apex:column value="{!me.Total_amt_paid__c }">
</apex:column>
</apex:pageBlockTable>
</apex:pageBlock >
<apex:pageBlock >
<apex:pageBlockTable value="{!Message2.Motor_Insurances__r}" var="m1" >
<apex:column value="{!m1.Name}" />
<apex:column value="{!m1.Due_date__c}"/>
<apex:column value="{!m1.Premium_Start_Date__c}"/>
<apex:column value="{!m1.Premium_End_date__c}"/>
<apex:column value="{!m1.Premium_Type__c}"/>
<apex:column value="{!m1.Total_amt_paid__c }">
</apex:column>
</apex:pageBlockTable>
</apex:pageBlock >
</apex:pageBlock>
</apex:form>
</apex:page>
Public with sharing class viewholderdetails{
public string name{set;get;}
public list<Policy_Holder__c> Message {set;get;}
Public list<Policy_Holder__c> Message2 {set;get;}
public void getdata() {
Message = [SELECT id,(SELECT id, Name, Due_date__c, Premium_Start_Date__c, Premium_End_date__c, Premium_Type__c, Total_amt_paid__c FROM Life_Insurances__r)
FROM Policy_Holder__c WHERE Policy_ID__c =: name];
Message2 = [SELECT id,(SELECT id, Name, Due_date__c, Premium_Start_Date__c, Premium_End_date__c, Premium_Type__c, Total_amt_paid__c FROM Motor_Insurances__r)
FROM Policy_Holder__c WHERE Policy_ID__c =: name];
}
}
Visualforce page :
<apex:page Controller="viewholderdetails">
<apex:form >
<apex:pageBlock title="Life Insurance Project">
<apex:pageMessages />
<apex:pageBlockSection title="Insurance datiles">
Enter Policy holder ID :<apex:inputtext value="{!name}"/>
<apex:commandButton value="Submit" action="{!getdata}"/>
</apex:pageBlockSection>
<apex:pageBlock >
<apex:pageMessages />
<apex:pageBlockTable value="{!Message.Life_Insurances__r}" var="me" >
<apex:column value="{!me.Name}" />
<apex:column value="{!me.Due_date__c}"/>
<apex:column value="{!me.Premium_Start_Date__c}"/>
<apex:column value="{!me.Premium_End_date__c}"/>
<apex:column value="{!me.Premium_Type__c}"/>
<apex:column value="{!me.Total_amt_paid__c }">
</apex:column>
</apex:pageBlockTable>
</apex:pageBlock >
<apex:pageBlock >
<apex:pageBlockTable value="{!Message2.Motor_Insurances__r}" var="m1" >
<apex:column value="{!m1.Name}" />
<apex:column value="{!m1.Due_date__c}"/>
<apex:column value="{!m1.Premium_Start_Date__c}"/>
<apex:column value="{!m1.Premium_End_date__c}"/>
<apex:column value="{!m1.Premium_Type__c}"/>
<apex:column value="{!m1.Total_amt_paid__c }">
</apex:column>
</apex:pageBlockTable>
</apex:pageBlock >
</apex:pageBlock>
</apex:form>
</apex:page>
Please use below code:-
if you need any assistanse, Please let me know!!
Kindly mark my solution as the best answer if it helps you.
Thanks
Mukesh
All Answers
Please use below code:-
if you need any assistanse, Please let me know!!
Kindly mark my solution as the best answer if it helps you.
Thanks
Mukesh
now able to get it now my VF page has been saved without any error. and able to get data.
Thank you,
Vignesh
Kindly mark my solution as the best answer if it helps you.
Thanks
Mukesh