Skip to main content
Topics#Data ManagementFrage von shabbir sk
shabbir sk (Iridium Interactive) fragte in #Data Management
21. Feb. 2014, 04:37

display country wise data

Hi,

 

 I need to display countrywise all records from object in a VF page.

 

 how can i achieve this in the controller without hitting the governer limit ?

 

I need to call around a 150 countries and am trying to do this with dynamic pageblocktable however am getting this error -  'exceed soql limit 101 error'.

 

Any thoughts on this?
2 Antworten
  1. Raj Kumar Jha (Appistoki)
    21. Feb. 2014, 06:21
    Hello Shabbir, 

     

    I think you have fired a SOQL query in a for loop.

     

    If you have use Aggregate Result in that case only one query will fire. 

     

    OR

     

    you can fetch all records at once then according to countrywise put you data in a Map. 

     

    Thanks
Antwort schreiben...
0/9000