Skip to main content
Topics#ApexEmmanuel Corona의 질문
Emmanuel Corona 님이 #Apex에 질문했습니다
2016년 6월 7일 오후 9:02

Display columns from subquery on VF Page

Hi ! I have this query

 

SELECT Id, Name, (SELECT Proveedores__c FROM Proveedores__r), (select name from opportunities where createddate =this_year and stagename='Ganada') FROM Account 

where id in (SELECT Cuenta__c FROM Proveedores__c)

and id in (select accountid from opportunity where createddate =this_year and stagename='Ganada')    

But now i'm stuck in how i can show all the Account Name, the Proveedores__c columns and the Opportunity name in a visualforce page

I'll really appreciate your help!!!

 
답변 3개
  1. Nayana KashiGowda (Walmart)
    2016년 6월 8일 오전 7:13
    Suppose you have stored accounts in lstAccount variable then in VF you can do like this :
    <apex:pageBlock id="pb"> 
    	<apex:repeat value="{!lstAccount}" var="objAcc">
    		<table border="1" width="95%">
    		<tr>
    			<td>
    				<h5>{!objAcc.Name}</h5>
    			</td>
    		</tr>
    		<tr>
    			<td>
    				Proveedores <br/>
    				<table border="1" style="margin-left:10px;" width="90%">
    					 <apex:repeat value="{!objAcc.Proveedores__r}" var="objProv" rendered="{!objAcc.Proveedores__r.size > 0}">
    						<tr>
    							<td><apex:outputField value="{!objProv.Proveedores__c}"/></td>
    						</tr>
    					</apex:repeat>
    					<tr style="display:{!IF(objAcc.Proveedores__r.size == 0,'block','none')}">
    						<td><h1>No Proveedores</h1></td>
    					</tr>
    				</table>
    			</td>
    		</tr>
    		<tr>
    			<td>
    				Opportunities <br/>
    				<table border="1" style="margin-left:10px;" width="90%">
    					 <apex:repeat value="{!objAcc.Opportunities}" var="objOpp" rendered="{!objAcc.Opportunities.size > 0}">
    						<tr>
    							<td><apex:outputField value="{!objOpp.Name}"/></td>
    						</tr>
    					</apex:repeat>
    					<tr style="display:{!IF(objAcc.Opportunities.size == 0,'block','none')}">
    						<td><h1>No Opportunities</h1></td>
    					</tr>
    				</table>
    			</td>
    		</tr>
    		</table> 
    		<br/>
    	</apex:repeat>
    </apex:pageBlock>

     
답변을 작성하세요...
0/9000