• Gobinathan Nagarajan 12
  • NEWBIE
  • 0 Points
  • Member since 2017

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies

Hi,

 

Tolable() not retrieving the translated value in the group by Clause. All Variable are initialised properly .

 

aResult = [ select tolabel(Solution__c) from Validated_Solution__c where Publish_Flag__c=TRUE AND Account__c =:AccountIdProfile group by Solution__c Order By Solution__c];

 

if(!aResult.IsEmpty()){

 

for(AggregateResult a:aResult){ 

     String str1 = (String)a.get('Solution__c');

      ValidatedSol.add(str1);

     }

 }

 

with ValidatedSol List i am displaying the results in VF page . While displaying it gives master picklist value but i want to display the translated value .If i use a query w/o Group by It will work . I want to use Group by . Please help me how to achieve this.

 

Many Thanks in advance ,

Prakash.N