hi,i am trying to get total of a custom field i.e sum of premium,but the problem is whenever i m using SUM its throwing error.i have pasted my code in that code only i m using the function.When i m grouping the fields also its throwing error.i used aggregate methods also.Can anyone tell how to get the sum??
public class MyPolicy{ public MyPolicy(ApexPages.StandardController controller) {
}
public List<Policy__c> getMyPolicy() { Policy__c[] Pol = [SELECT name,Sum_Of_Premium__c,Channel_Name__r.Target__c,Channel_Name__r.name from Policy__c ]; return Pol; }
Hi I am using Contact and Lead. In both Contact and Lead I have a custom field called TEB_ID__c. Now when I am creating a Contact record I am comparing all the TEB_ID_c of Customer with all the records Lead for similar TEB_ID__c. If TEB_ID_c of Lead and Customer matches the Status__c field of Lead is updated to Close and that Lead record whose Status__c field has been updated will become a child record of customer for which TEB_ID_c is matching.
Now my issue is in my code I am able to update the Status__c field to Close but I am not able to get any clue how to add this updated Lead as child of Contact.
My code for to update Status__c field:
trigger CloseLead2NEW on Contact (before update, before insert) {
List<Lead> lee=new List<Lead>();
Lead leeList;
Contact cc;
List<Lead> Updatelee=new List<Lead>();
if (Trigger.isUpdate||Trigger.isInsert)
{
cc=Trigger.New[0]; lee=[select id,TEB_ID__c,Citizenship_Number__c,Tax_Number__c from Lead where TEB_ID__c=:cc.TEB_ID__c OR Citizenship_Number__c=:cc.Citizenship_Number__c ]; if(lee.size()>0) {
for(Lead l:lee) {
l.Status='Closed';
leeList= new Lead(id=l.id,Status=l.Status); Updatelee.add(leeList);
} } }
update Updatelee;
}
Help me to cretate this updated Lead as child of Contact record which has triggered the Lead record to get updated.
Hi i am new to salesforce. my code is not working, the where condition in query is not filtering data and when i am using groupby its showing the error
Field must be grouped or aggregated..even when i use WHERE its throwing error.
here is the class
public List<Policy__c> getMyPolicy() { List<Policy__c> temp =[SELECT name,AVG(Sum_Of_Premium__c),Channel_Name__r.Target__c from Policy__c GROUP BY CreatedDate]; return temp;
In this i need average of custom field sum of premium.
Hi I am new to salesforce. my code is not giving any error but the where condition in query is not filtering data when I am adding second 'OR' clause in it. If I am not adding second OR clause the code is working in the expected way but moment I am adding any OR clause the query is not filtering any record it is just returning entire data.
trigger CloseLead2NEW on Contact (before update, before insert) {
List<Lead> lee=new List<Lead>();
Lead leeList;
Contact cc;
List<Lead> Updatelee=new List<Lead>();
if (Trigger.isUpdate||Trigger.isInsert)
{
cc=Trigger.New[0];
lee=[select id,TEB_ID__c,Citizenship_Number__c,Tax_Number__c from Lead where TEB_ID__c=:cc.TEB_ID__c OR Citizenship_Number__c=:cc.Citizenship_Number__c OR Tax_Number__c=:cc.Tax_Number__c ]; if(lee.size()>0) {
hi,i am trying to get total of a custom field i.e sum of premium,but the problem is whenever i m using SUM its throwing error.i have pasted my code in that code only i m using the function.When i m grouping the fields also its throwing error.i used aggregate methods also.Can anyone tell how to get the sum??
public class MyPolicy{ public MyPolicy(ApexPages.StandardController controller) {
}
public List<Policy__c> getMyPolicy() { Policy__c[] Pol = [SELECT name,Sum_Of_Premium__c,Channel_Name__r.Target__c,Channel_Name__r.name from Policy__c ]; return Pol; }
Hi I am using Contact and Lead. In both Contact and Lead I have a custom field called TEB_ID__c. Now when I am creating a Contact record I am comparing all the TEB_ID_c of Customer with all the records Lead for similar TEB_ID__c. If TEB_ID_c of Lead and Customer matches the Status__c field of Lead is updated to Close and that Lead record whose Status__c field has been updated will become a child record of customer for which TEB_ID_c is matching.
Now my issue is in my code I am able to update the Status__c field to Close but I am not able to get any clue how to add this updated Lead as child of Contact.
My code for to update Status__c field:
trigger CloseLead2NEW on Contact (before update, before insert) {
List<Lead> lee=new List<Lead>();
Lead leeList;
Contact cc;
List<Lead> Updatelee=new List<Lead>();
if (Trigger.isUpdate||Trigger.isInsert)
{
cc=Trigger.New[0]; lee=[select id,TEB_ID__c,Citizenship_Number__c,Tax_Number__c from Lead where TEB_ID__c=:cc.TEB_ID__c OR Citizenship_Number__c=:cc.Citizenship_Number__c ]; if(lee.size()>0) {
for(Lead l:lee) {
l.Status='Closed';
leeList= new Lead(id=l.id,Status=l.Status); Updatelee.add(leeList);
} } }
update Updatelee;
}
Help me to cretate this updated Lead as child of Contact record which has triggered the Lead record to get updated.
Hi i am new to salesforce. my code is not working, the where condition in query is not filtering data and when i am using groupby its showing the error
Field must be grouped or aggregated..even when i use WHERE its throwing error.
here is the class
public List<Policy__c> getMyPolicy() { List<Policy__c> temp =[SELECT name,AVG(Sum_Of_Premium__c),Channel_Name__r.Target__c from Policy__c GROUP BY CreatedDate]; return temp;
In this i need average of custom field sum of premium.
I am running into the issues. I do not understand what the below messages meant. can any one point me in the right direction.
Microsoft Windows [Version 6.1.7600]Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:\Windows\system32>cd C:\Program Files\salesforce.com\Apex Data Loader 22.0\bin
C:\Program Files\salesforce.com\Apex Data Loader 22.0\bin>process.bat "C:\Program Files\salesforce.com\Apex Data Loader 22.0\test\" csvLeadInsertProcess
Usage: java [-options] class [args...]
(to execute a class)
or java [-options] -jar jarfile [args...]
(to execute a jar file) where options include:
-client to select the "client" VM
-server to select the "server" VM
-hotspot is a synonym for the "client" VM [deprecated]
The default VM is client. -cp <class search path of directories and zip/jar files>
-classpath <class search path of directories and zip/jar files>
A ; separated list of directories, JAR archives,
and ZIP archives to search for class files.
-D<name>=<value> set a system property
-verbose[:class|gc|jni] enable verbose output
-version print product version and exit
-version:<value> require the specified version to run
-showversion print product version and continue
-jre-restrict-search | -jre-no-restrict-search include/exclude user private JREs in the version search
-esa | -enablesystemassertions enable system assertions
-dsa | -disablesystemassertions disable system assertions
-agentlib:<libname>[=<options>] load native agent library <libname>, e.g. -agentlib:hprof see also, -agentlib:jdwp=help and -agentlib:hprof=help -agentpath:<pathname>[=<options>] load native agent library by full pathname -javaagent:<jarpath>[=<options>] load Java programming language agent, see java.lang.instrument C:\Program Files\salesforce.com\Apex Data Loader 22.0\bin>
I have no idea what it meant and all i know id that my process did not create the Leads from my csv file.
