-
ChatterFeed
-
0Best Answers
-
2Likes Received
-
0Likes Given
-
20Questions
-
10Replies
dublicate records
hello friends
can any one tell me the proper code for Merging duplicate records, i have merged files but not able to delete duplicate files.
can any one tell me the proper code for Merging duplicate records, i have merged files but not able to delete duplicate files.
global class batch3 implements Database.Batchable<sObject> { global Database.QueryLocator start(Database.BatchableContext BC) { String query = 'SELECT Id,Name,Name__c,MobilePhone,Email,AnnualRevenue,LeadSource FROM Lead'; return Database.getQueryLocator(query); } global void execute(Database.BatchableContext BC, List<Lead> leadlist) { for( Lead a : leadlist) { for(Lead b: leadlist) { if(a.Name__c == b.Name__c ) { if(a.MobilePhone== null) { a.MobilePhone=b.MobilePhone; } if(a.Email== null) { a.Email=b.Email; } if(a.AnnualRevenue== null) { a.AnnualRevenue=b.AnnualRevenue; } if(a.LeadSource== null) { a.LeadSource=b.LeadSource; } //delete b; //[select id from Lead where Name__c='b.Name__c']; /* Lead[] dlist1 = [SELECT Id, Name FROM Lead WHERE Name__c = 'b.Name__c']; try { delete dlist1; } catch (DmlException e) { // Process exception here } */ } } // update a; } /* system.debug('leadlist a>>>>>'+leadlist); system.debug('outside loop>>>>>'); list<lead> list1=new list<lead>(); for( Lead a : leadlist) { for(Lead b: leadlist) { if(a.Name__c != b.Name__c ) { list1.add(a); } else { } } update a; } // List<Lead> list2 = new List<Lead>(list1); */ update leadlist; } global void finish(Database.BatchableContext BC) { } }plz correct in this.
- Pankaj Parihar
- December 19, 2017
- Like
- 0
- Continue reading or reply
account city field update trigger
Hi friends
i want a trigger code for this
When a contact is made primary(1) the city of the contact should be updated in the Account’s city(3) field.
i want a trigger code for this
When a contact is made primary(1) the city of the contact should be updated in the Account’s city(3) field.
- Pankaj Parihar
- December 19, 2017
- Like
- 0
- Continue reading or reply
Batch code junction object
hi plz help me with batch code or tell me the flow step by step.
Create the following custom objects and establish the relationships as mentioned below:
Custom object called Policy
Junction object between standard Account object and Policy custom object called Account/Policy relationship
Junction object between standard User object and Policy custom object called Policy/Agent relationship
Enable Account teams in the Org.
Assume that there are more than 4 million Account records, 2 million Policy records, 1 million Account/Policy relationship records and 1 million Policy/Agent relationship records in the Org.
Scenario is to add all the Users related to a Policy via Agent/Policy relationship records to the Account teams of Accounts related to the Same Policy via Account/Policy relationship.
Create the following custom objects and establish the relationships as mentioned below:
Custom object called Policy
Junction object between standard Account object and Policy custom object called Account/Policy relationship
Junction object between standard User object and Policy custom object called Policy/Agent relationship
Enable Account teams in the Org.
Assume that there are more than 4 million Account records, 2 million Policy records, 1 million Account/Policy relationship records and 1 million Policy/Agent relationship records in the Org.
Scenario is to add all the Users related to a Policy via Agent/Policy relationship records to the Account teams of Accounts related to the Same Policy via Account/Policy relationship.
- Pankaj Parihar
- December 11, 2017
- Like
- 0
- Continue reading or reply
batch problem on specified queue
hi friends
plz hepl me in this queue thing just tell me how to do.. coding also if possible
Assign all the leads created during non-business hours to specified queue and leads created during business hours to specified queue.
plz hepl me in this queue thing just tell me how to do.. coding also if possible
Assign all the leads created during non-business hours to specified queue and leads created during business hours to specified queue.
- Pankaj Parihar
- December 06, 2017
- Like
- 0
- Continue reading or reply
Assign all the leads created during non-business hours to specified queue and leads created during business hours to specified queue.
hi piush
can u help me in this batch program same createdby date related Assign all the leads created during non-business hours to specified queue and leads created during business hours to specified queue.
can u help me in this batch program same createdby date related Assign all the leads created during non-business hours to specified queue and leads created during business hours to specified queue.
- Pankaj Parihar
- November 29, 2017
- Like
- 0
- Continue reading or reply
sapreat date from createdby
hi friends
i wanted to acess date and time separately how can i get it
through batch code
- Pankaj Parihar
- November 29, 2017
- Like
- 0
- Continue reading or reply
trigger 4
hello
plz help me in this trigger code
If owner of an Account has gone on leave for more than 90 days then type field should be updated with "Former Client".
If owner of an Account has gone on leave for more than 180 days and if the owner has a delegated user then the delegated user should be updated as Owner.
If owner of an Account has gone on leave for more than 180 days and if the owner has no delegated user then type field should be updated with "Deactivated".
plz help me in this trigger code
If owner of an Account has gone on leave for more than 90 days then type field should be updated with "Former Client".
If owner of an Account has gone on leave for more than 180 days and if the owner has a delegated user then the delegated user should be updated as Owner.
If owner of an Account has gone on leave for more than 180 days and if the owner has no delegated user then type field should be updated with "Deactivated".
- Pankaj Parihar
- November 21, 2017
- Like
- 0
- Continue reading or reply
trigger 3
hi
sir, plz help me with the code i m very fresh to codeing and salesforce
Campaigns should contain both Leads and Contacts as Campaign Members.
Either Lead or Contact of Campaign Members cumulative amount whichever is greater should be updated in Campaign object - Cumulative Amount of Leads or Contacts.
sir, plz help me with the code i m very fresh to codeing and salesforce
Campaigns should contain both Leads and Contacts as Campaign Members.
Either Lead or Contact of Campaign Members cumulative amount whichever is greater should be updated in Campaign object - Cumulative Amount of Leads or Contacts.
- Pankaj Parihar
- November 21, 2017
- Like
- 0
- Continue reading or reply
case study
hi friends
help me plz .tell me the 2 Approval Process
1) Create a two-step expense report approval process for all employees in your headquarters office. It specifies that expenses less than $50 are automatically approved, those $50 and over require manager approval, and those over $5,000 require additional approval from two VPs. This example highlights the “else” option, as well as the parallel approvals feature.
2) Orders that are discounted more than 40% require a CEO approval.
help me plz .tell me the 2 Approval Process
1) Create a two-step expense report approval process for all employees in your headquarters office. It specifies that expenses less than $50 are automatically approved, those $50 and over require manager approval, and those over $5,000 require additional approval from two VPs. This example highlights the “else” option, as well as the parallel approvals feature.
2) Orders that are discounted more than 40% require a CEO approval.
- Pankaj Parihar
- November 20, 2017
- Like
- 0
- Continue reading or reply
workflow on date change
Remind the opportunity owner and senior management when the close date is approaching for a large deal, an opportunity that has an amount greater than $100,000. Also, create a follow-up task for the opportunity owner if the deal is still open when the close date passes.
- Pankaj Parihar
- November 20, 2017
- Like
- 0
- Continue reading or reply
trigger calculation
hello friends
plz help me with the code.
Based on the probability, calculate the amount for each product and display the amount.
Display the cumulative amount in Opportunity object only if the cumulative probability has crossed 50%.
plz help me with the code.
Based on the probability, calculate the amount for each product and display the amount.
Display the cumulative amount in Opportunity object only if the cumulative probability has crossed 50%.
- Pankaj Parihar
- November 20, 2017
- Like
- 0
- Continue reading or reply
workflow for calculating date
hi friends
Update the Shipment Status field to “Delayed” if a shipment has exceeded the expected delivery date and not reached the customer.
plz tell me the steps to do this workflow
Update the Shipment Status field to “Delayed” if a shipment has exceeded the expected delivery date and not reached the customer.
plz tell me the steps to do this workflow
- Pankaj Parihar
- November 20, 2017
- Like
- 0
- Continue reading or reply
batch programming
hello friends
i m new to programming ...i dont know how to write batch code. plz help me with code.
2 casestudys are there i need both the questions.
CaseStudy Batch 1
1.Merging duplicate records in leads based on first name and last name. Batch should run every day.
CaseStudy Batch 2
1.Assign all the leads created during non-business hours to specified queue and leads created during business hours to specified queue.
i m new to programming ...i dont know how to write batch code. plz help me with code.
2 casestudys are there i need both the questions.
CaseStudy Batch 1
1.Merging duplicate records in leads based on first name and last name. Batch should run every day.
CaseStudy Batch 2
1.Assign all the leads created during non-business hours to specified queue and leads created during business hours to specified queue.
- Pankaj Parihar
- November 17, 2017
- Like
- 0
- Continue reading or reply
workflow on top account
hello
plz direct me with sutable workflow to this question.
1.The sales VP wants to know about any cases filed for top accounts, where top accounts are determined by size and revenue.
plz tell me all the steps.
plz direct me with sutable workflow to this question.
1.The sales VP wants to know about any cases filed for top accounts, where top accounts are determined by size and revenue.
plz tell me all the steps.
- Pankaj Parihar
- November 17, 2017
- Like
- 0
- Continue reading or reply
workflow on dateupdate
Hello friends
stucked in this question
1.Set the case target resolution date for accounts that have basic support level to 30 days from today.
plz help me in completing this workflow with steps.i dont know codding.
stucked in this question
1.Set the case target resolution date for accounts that have basic support level to 30 days from today.
plz help me in completing this workflow with steps.i dont know codding.
- Pankaj Parihar
- November 17, 2017
- Like
- 0
- Continue reading or reply
notify to VP workflow
Hi All
Notify the VP of Sales when a deal is lost if the stage was “Proposal/Price Quote” and the amount was greater than $1,000,000. plz help me in steps how to do code if required..
Notify the VP of Sales when a deal is lost if the stage was “Proposal/Price Quote” and the amount was greater than $1,000,000. plz help me in steps how to do code if required..
- Pankaj Parihar
- November 17, 2017
- Like
- 0
- Continue reading or reply
batch code
plz help with code
Merging duplicate records in leads based on first name and last name. Batch should run every day.
Merging duplicate records in leads based on first name and last name. Batch should run every day.
- Pankaj Parihar
- November 16, 2017
- Like
- 0
- Continue reading or reply
product records on vf page
hello
i need to display this table on vf page on a button click which is inside of an opportunity record.
plz help me with code.
- Pankaj Parihar
- November 09, 2017
- Like
- 1
- Continue reading or reply
workflow to check and update field by date difffrence
hi
Update the Shipment Status field to “Delayed” if a shipment has exceeded the expected delivery date and not reached the customer.
Update the Shipment Status field to “Delayed” if a shipment has exceeded the expected delivery date and not reached the customer.
- Pankaj Parihar
- November 08, 2017
- Like
- 1
- Continue reading or reply
- Pankaj Parihar
- September 23, 2017
- Like
- 0
- Continue reading or reply
product records on vf page
hello
i need to display this table on vf page on a button click which is inside of an opportunity record.
plz help me with code.
- Pankaj Parihar
- November 09, 2017
- Like
- 1
- Continue reading or reply
workflow to check and update field by date difffrence
hi
Update the Shipment Status field to “Delayed” if a shipment has exceeded the expected delivery date and not reached the customer.
Update the Shipment Status field to “Delayed” if a shipment has exceeded the expected delivery date and not reached the customer.
- Pankaj Parihar
- November 08, 2017
- Like
- 1
- Continue reading or reply
dublicate records
hello friends
can any one tell me the proper code for Merging duplicate records, i have merged files but not able to delete duplicate files.
can any one tell me the proper code for Merging duplicate records, i have merged files but not able to delete duplicate files.
global class batch3 implements Database.Batchable<sObject> { global Database.QueryLocator start(Database.BatchableContext BC) { String query = 'SELECT Id,Name,Name__c,MobilePhone,Email,AnnualRevenue,LeadSource FROM Lead'; return Database.getQueryLocator(query); } global void execute(Database.BatchableContext BC, List<Lead> leadlist) { for( Lead a : leadlist) { for(Lead b: leadlist) { if(a.Name__c == b.Name__c ) { if(a.MobilePhone== null) { a.MobilePhone=b.MobilePhone; } if(a.Email== null) { a.Email=b.Email; } if(a.AnnualRevenue== null) { a.AnnualRevenue=b.AnnualRevenue; } if(a.LeadSource== null) { a.LeadSource=b.LeadSource; } //delete b; //[select id from Lead where Name__c='b.Name__c']; /* Lead[] dlist1 = [SELECT Id, Name FROM Lead WHERE Name__c = 'b.Name__c']; try { delete dlist1; } catch (DmlException e) { // Process exception here } */ } } // update a; } /* system.debug('leadlist a>>>>>'+leadlist); system.debug('outside loop>>>>>'); list<lead> list1=new list<lead>(); for( Lead a : leadlist) { for(Lead b: leadlist) { if(a.Name__c != b.Name__c ) { list1.add(a); } else { } } update a; } // List<Lead> list2 = new List<Lead>(list1); */ update leadlist; } global void finish(Database.BatchableContext BC) { } }plz correct in this.
- Pankaj Parihar
- December 19, 2017
- Like
- 0
- Continue reading or reply
account city field update trigger
Hi friends
i want a trigger code for this
When a contact is made primary(1) the city of the contact should be updated in the Account’s city(3) field.
i want a trigger code for this
When a contact is made primary(1) the city of the contact should be updated in the Account’s city(3) field.
- Pankaj Parihar
- December 19, 2017
- Like
- 0
- Continue reading or reply
sapreat date from createdby
hi friends
i wanted to acess date and time separately how can i get it
through batch code
- Pankaj Parihar
- November 29, 2017
- Like
- 0
- Continue reading or reply
workflow on date change
Remind the opportunity owner and senior management when the close date is approaching for a large deal, an opportunity that has an amount greater than $100,000. Also, create a follow-up task for the opportunity owner if the deal is still open when the close date passes.
- Pankaj Parihar
- November 20, 2017
- Like
- 0
- Continue reading or reply
trigger calculation
hello friends
plz help me with the code.
Based on the probability, calculate the amount for each product and display the amount.
Display the cumulative amount in Opportunity object only if the cumulative probability has crossed 50%.
plz help me with the code.
Based on the probability, calculate the amount for each product and display the amount.
Display the cumulative amount in Opportunity object only if the cumulative probability has crossed 50%.
- Pankaj Parihar
- November 20, 2017
- Like
- 0
- Continue reading or reply
notify to VP workflow
Hi All
Notify the VP of Sales when a deal is lost if the stage was “Proposal/Price Quote” and the amount was greater than $1,000,000. plz help me in steps how to do code if required..
Notify the VP of Sales when a deal is lost if the stage was “Proposal/Price Quote” and the amount was greater than $1,000,000. plz help me in steps how to do code if required..
- Pankaj Parihar
- November 17, 2017
- Like
- 0
- Continue reading or reply
batch code
plz help with code
Merging duplicate records in leads based on first name and last name. Batch should run every day.
Merging duplicate records in leads based on first name and last name. Batch should run every day.
- Pankaj Parihar
- November 16, 2017
- Like
- 0
- Continue reading or reply
product records on vf page
hello
i need to display this table on vf page on a button click which is inside of an opportunity record.
plz help me with code.
- Pankaj Parihar
- November 09, 2017
- Like
- 1
- Continue reading or reply
- Pankaj Parihar
- September 23, 2017
- Like
- 0
- Continue reading or reply