• Krrish Karthik
  • NEWBIE
  • 0 Points
  • Member since 2014
  • Puthuvannam Technology Solution


  • Chatter
    Feed
  • 0
    Best Answers
  • 3
    Likes Received
  • 1
    Likes Given
  • 3
    Questions
  • 5
    Replies
public list<AggregateResult> Agre = new list<AggregateResult>();
Sql = 'SELECT Owner.Name,Avg(Evaluated_Area_1__c)ev1,Avg(Evaluated_Area_2__c)ev2,Avg(Evaluated_Area_3__c)ev3,Avg(Evaluated_Area_4__c)ev4,'
                 +'Avg(Evaluated_Area_5__c)ev5 FROM Survey_Result__c where'
                 +' Survey_Date__c >=:Date.Parse(FromDate) And Survey_Date__c <=:Date.Parse(ToDate) Group by Owner.Name';
         System.debug('qqqqqqqq'+Sql);       
         Sql1 = 'SELECT Avg(Evaluated_Area_1__c)ev1,Avg(Evaluated_Area_2__c)ev2,Avg(Evaluated_Area_3__c)ev3,Avg(Evaluated_Area_4__c)ev4,'
                 +'Avg(Evaluated_Area_5__c)ev5 FROM Survey_Result__c where '
                 +'Survey_Date__c >=:Date.Parse(FromDate) And Survey_Date__c <=:Date.Parse(ToDate)';
         System.debug('xxxxxxx'+Sql1);       
       
         if(alUsr.Checked){       
             Agre = Database.query(Sql);
             System.debug('sssssssss'+Agre);
         }
         else if(alUsr.Checked1){       
             Agre = Database.query(Sql1);
             System.debug('vvvvvvv'+Agre);
         }


i got an Error  System.QueryException: unexpected token: '('
I have Create a Custom Object(Survey_Result__c) With Fields are Evaluated_Area_1__c, Evaluated_Area_2__c, Evaluated_Area_3__c, Evaluated_Area_4__c, Evaluated_Area_5__c.. 5 fileds.  i get all fields Average using soql.. i have using all users list in vf page with checkboxes.
if i click first checkbox user and display the if i click first user Survey Result Records are to be display with Avg. and then click second User Displayed frst user survey records and seecond user records both are averaged to be display.. whats the solution? if I get What user I click i can display the survey Result records.. Whats the Solution? tell the Answer..
I have Create a Custom Object(Survey_Result__c) With Fields are Evaluated_Area_1__c, Evaluated_Area_2__c, Evaluated_Area_3__c, Evaluated_Area_4__c, Evaluated_Area_5__c.. 5 fileds.  i get all fields Average using soql.. i have using all users list in vf page with checkboxes.
if i click first checkbox user and display the if i click first user Survey Result Records are to be display with Avg. and then click second User Displayed frst user survey records and seecond user records both are averaged to be display.. whats the solution? if I get What user I click i can display the survey Result records.. Whats the Solution? tell the Answer..
public list<AggregateResult> Agre = new list<AggregateResult>();
Sql = 'SELECT Owner.Name,Avg(Evaluated_Area_1__c)ev1,Avg(Evaluated_Area_2__c)ev2,Avg(Evaluated_Area_3__c)ev3,Avg(Evaluated_Area_4__c)ev4,'
                 +'Avg(Evaluated_Area_5__c)ev5 FROM Survey_Result__c where'
                 +' Survey_Date__c >=:Date.Parse(FromDate) And Survey_Date__c <=:Date.Parse(ToDate) Group by Owner.Name';
         System.debug('qqqqqqqq'+Sql);       
         Sql1 = 'SELECT Avg(Evaluated_Area_1__c)ev1,Avg(Evaluated_Area_2__c)ev2,Avg(Evaluated_Area_3__c)ev3,Avg(Evaluated_Area_4__c)ev4,'
                 +'Avg(Evaluated_Area_5__c)ev5 FROM Survey_Result__c where '
                 +'Survey_Date__c >=:Date.Parse(FromDate) And Survey_Date__c <=:Date.Parse(ToDate)';
         System.debug('xxxxxxx'+Sql1);       
       
         if(alUsr.Checked){       
             Agre = Database.query(Sql);
             System.debug('sssssssss'+Agre);
         }
         else if(alUsr.Checked1){       
             Agre = Database.query(Sql1);
             System.debug('vvvvvvv'+Agre);
         }


i got an Error  System.QueryException: unexpected token: '('
I have Create a Custom Object(Survey_Result__c) With Fields are Evaluated_Area_1__c, Evaluated_Area_2__c, Evaluated_Area_3__c, Evaluated_Area_4__c, Evaluated_Area_5__c.. 5 fileds.  i get all fields Average using soql.. i have using all users list in vf page with checkboxes.
if i click first checkbox user and display the if i click first user Survey Result Records are to be display with Avg. and then click second User Displayed frst user survey records and seecond user records both are averaged to be display.. whats the solution? if I get What user I click i can display the survey Result records.. Whats the Solution? tell the Answer..
{
    "name": "testparser",
    "org": "test",
    "email": "rpl@gmail.com",
    "courses": [
        {
            "cname": "this is course1",
             "startdate": "2014-04-12"
        },
        {
            "cname": "this is course2",
            "startdate": "2014-04-13"
        }
    ]
}
  • March 26, 2014
  • Like
  • 0
public list<AggregateResult> Agre = new list<AggregateResult>();
Sql = 'SELECT Owner.Name,Avg(Evaluated_Area_1__c)ev1,Avg(Evaluated_Area_2__c)ev2,Avg(Evaluated_Area_3__c)ev3,Avg(Evaluated_Area_4__c)ev4,'
                 +'Avg(Evaluated_Area_5__c)ev5 FROM Survey_Result__c where'
                 +' Survey_Date__c >=:Date.Parse(FromDate) And Survey_Date__c <=:Date.Parse(ToDate) Group by Owner.Name';
         System.debug('qqqqqqqq'+Sql);       
         Sql1 = 'SELECT Avg(Evaluated_Area_1__c)ev1,Avg(Evaluated_Area_2__c)ev2,Avg(Evaluated_Area_3__c)ev3,Avg(Evaluated_Area_4__c)ev4,'
                 +'Avg(Evaluated_Area_5__c)ev5 FROM Survey_Result__c where '
                 +'Survey_Date__c >=:Date.Parse(FromDate) And Survey_Date__c <=:Date.Parse(ToDate)';
         System.debug('xxxxxxx'+Sql1);       
       
         if(alUsr.Checked){       
             Agre = Database.query(Sql);
             System.debug('sssssssss'+Agre);
         }
         else if(alUsr.Checked1){       
             Agre = Database.query(Sql1);
             System.debug('vvvvvvv'+Agre);
         }


i got an Error  System.QueryException: unexpected token: '('
I have Create a Custom Object(Survey_Result__c) With Fields are Evaluated_Area_1__c, Evaluated_Area_2__c, Evaluated_Area_3__c, Evaluated_Area_4__c, Evaluated_Area_5__c.. 5 fileds.  i get all fields Average using soql.. i have using all users list in vf page with checkboxes.
if i click first checkbox user and display the if i click first user Survey Result Records are to be display with Avg. and then click second User Displayed frst user survey records and seecond user records both are averaged to be display.. whats the solution? if I get What user I click i can display the survey Result records.. Whats the Solution? tell the Answer..
How do I relate a standardcontroller to a custom object on a visual force page 
<apex:page standardController="ts2__Placement__c"  showHeader="false" sidebar="false">
  <p>You are viewing the {!ts2__Placement__c.name} record .</p>
Sample Encrypted Bank Account:  <apex:outputField value="{!ts2__Placement__c.Sample_Bank_Acc__c}" /><br />
</apex:page>

I am getting a error saying I cannot use the custom object on the visualforce page when I try to do this.