Apex Code Development You need to sign in to do that
Don't have an account?
How to add coloumn to list retrive from SOQL Query
Hi,
I had executed a soql query and put the query output in a list. Now I want to add a custom coloumn in the list.
Following is the way I am used it in code :
List<CustomObject> mylist = [select id,name,ipaddress from CustomObject];
I want to add a custom coloumn and display this all list in a table
Can anyone suggest me how to achive this???
Vf page change Like this
<apex:pageBlock title="Account List" id="acct"> <apex:pageBlockTable value="{!accList}" var="acc" columns="5"> <apex:column value="{!acc.Name}"/> <apex:column value="{!acc.Type}"/> <apex:column > <apex:repeat value="{!contList}" var="cont"> <apex:outputText value="{!cont.name}" ></apex:outputText>, </apex:repeat> </apex:column> </apex:pageBlockTable> </apex:pageBlock>see the output
All Answers
Adding new column to list is same as you are adding standard field. Example)
List<CustomObject> mylist = [select id,name,ipaddress, CustomField1__c, CustomField2__c from CustomObject];
If you have to display the same in VF page then there are several ways to do like using "pageBlockTable", using apex:repeat etc.
Detail here:
https://developer.salesforce.com/docs/atlas.en-us.pages.meta/pages/pages_quick_start_display_field_values.htm
https://salesforce.stackexchange.com/questions/161233/how-to-display-list-values-in-vf-page
Thanks,
Harsh
Hi
If you want to show a extra column then use this Code
Apex class:
public with sharing class sample { public List<Account> acc {get;set;} public sample() { acc = [SELECT Name, AccountNumber FROM Account]; } }Vf page:
<apex:page controller="sample" sidebar="false" > <apex:pageBlock title="Pageblock Table"> <apex:pageblockTable value="{!acc}" var="a"> <apex:column value="{!a.Id}"/> <apex:column value="{!a.Name}"/> <apex:column value="{!a.AccountNumber }" </apex:pageblockTable> </apex:pageBlock> </apex:page>see this code
public with sharing class AssociateController { public String selectedValue { get; set; } public List<String> strSearch { get; set; } public List<Account> accList{get;set;} public List<Opportunity> oppList{get;set;} public List<Contact> contList{get;set;} public PageReference searchMethod() { accList = new List<Account>(); oppList = new List<Opportunity>(); contList = new List<Contact>(); String searchItem = '*'+selectedValue+'*'; List<Account> acc= [SELECT Name, (SELECT Name, Type FROM Opportunities),(SELECT Name, email FROM Contacts) FROM Account where Name = :searchItem]; accList = acc; If(accList!=null && accList.size()>0){ contList = new List<Contact>(acc[0].Contacts); oppList = new List<Opportunity>(acc[0].Opportunities); } return null; } public AssociateController(){ strSearch = new List<String>(); for(Account a: [SELECT id, Name From Account]){ strSearch.add(a.name); } } }<apex:page controller="AssociateController" docType="html-5.0"> <apex:form > <apex:inputText list="{!strSearch}" value="{!selectedValue}"/> <apex:commandButton value="Search Lead and Contact" action="{!searchMethod}" reRender="acct,cont,opprty" status="actStatus"/> <apex:actionStatus id="actStatus"> <apex:facet name="start"> <img src="/img/loading.gif"/> </apex:facet> </apex:actionStatus> <apex:pageBlock title="Account List" id="acct"> <apex:pageBlockTable value="{!accList}" var="acc"> <apex:column value="{!acc.Name}"/> <apex:column value="{!acc.Type}"/> </apex:pageBlockTable> </apex:pageBlock> <apex:pageBlock title="Contacts" id="cont"> <apex:pageblockTable value="{!contList}" var="con"> <apex:column value="{!con.name}"/> <apex:column value="{!con.email}"/> </apex:pageblockTable> </apex:pageBlock> <apex:pageBlock title="Oppertunity List" id="opprty"> <apex:pageBlockTable value="{!oppList}" var="opp"> <apex:column value="{!opp.name}"/> <apex:column value="{!opp.StageName}"/> </apex:pageBlockTable> </apex:pageBlock> </apex:form> </apex:page>child to parent :public class nbsp { public List<Contact> con {get;set;} public nbsp() { con = [SELECT Name, Languages__c ,account.Name,account.Website,account.AccountNumber FROM Contact]; } } <apex:page Controller="nbsp"> <apex:pageBlock title="Pageblock Table"> <apex:pageblockTable value="{!con}" var="a"> <apex:column value="{!a.account.Name}"/> <apex:column value="{!a.Name}"/> <apex:column value="{!a.Languages__c }" /> <apex:column value="{!a.account.AccountNumber }" /> <apex:column value="{!a.account.Website }" /> </apex:pageblockTable> </apex:pageBlock> </apex:page>Is this type of queries crating separate row if inner query is giving output as multiple rows.
For example :
Your outer query based on account if there are 10 records present in account obj
and our inner queries (Contact and Opportunities) having multiple records then this query returns 10 records or more than that.
Also can you please provide output of your table for my referance.
Hi
Output of the code Is:
Inner queries will retrieve multiple records , you can see Contacts multiple
That string will be deplayed in account cloumn with heading Related Contact.
it will be like this :
----------------------------------
Account Name || Type || Related Contact
Account 1 || T2 || Contact 1 ; Contact 2
Vf page change Like this
<apex:pageBlock title="Account List" id="acct"> <apex:pageBlockTable value="{!accList}" var="acc" columns="5"> <apex:column value="{!acc.Name}"/> <apex:column value="{!acc.Type}"/> <apex:column > <apex:repeat value="{!contList}" var="cont"> <apex:outputText value="{!cont.name}" ></apex:outputText>, </apex:repeat> </apex:column> </apex:pageBlockTable> </apex:pageBlock>see the output
One small question, why you created nbsp class. what is the role in this situation
Hi
No Bro ... Already nbsp class created in my org i have edited that class.
If You want exact same output use like this
<apex:outputText value="{!cont.name}" ></apex:outputText>,