You need to sign in to do that
Don't have an account?
Dnyaneshwar
lead record summary in visualforce page
Hi,
I was trying to get the number of Lead records with XYZ picklist values equals particular values i.e. a table with
coloumn 1 coloumn 2
row1 : ABC ABC (i.e. count of lead records where field XYZ = A or B or C)
row2 : ACD ACD (i.e. count of lead records where field XYZ = A or C or D)
row3 : BCD BCD (i.e. count of lead records where field XYZ = B or C or D)
I tried to acheive this using bucketing in report but couldn't because of salesforce some limitations on bucket fields. So i am trying to create a vf page table. Any suggestions?
Thanks a Ton! for any help.
I was trying to get the number of Lead records with XYZ picklist values equals particular values i.e. a table with
coloumn 1 coloumn 2
row1 : ABC ABC (i.e. count of lead records where field XYZ = A or B or C)
row2 : ACD ACD (i.e. count of lead records where field XYZ = A or C or D)
row3 : BCD BCD (i.e. count of lead records where field XYZ = B or C or D)
I tried to acheive this using bucketing in report but couldn't because of salesforce some limitations on bucket fields. So i am trying to create a vf page table. Any suggestions?
Thanks a Ton! for any help.
You will have to use aggregateResult in apex controller and get the value in page page to display results accourding.
//Pseudo Apex logic
Thanks a lot for the reply.
From yesterday i am trying to get familier with syntax to calculate count of records using AggregateResult and displaying it in a table. but i am more of a admin and in dire need of help in creating this table.
Also in the query above i didn't understand 2 things : 1) count(id) will calculate all record where id is not blank then what is countid 2) We just need the count so do we need group by?
I can hire you as a freelancer if required.
#2. Correct, we need group by clause as per syntax
this is more of syntax of aggregate results sObject.
i will be happy to help you!
email:contriverssoftc@gmail.com