• Dhanasekar K
  • NEWBIE
  • 0 Points
  • Member since 2018

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 3
    Questions
  • 5
    Replies
I need to add startURL parameter in reset password mail (Community User)
After successfull password reset i want to redirect custom url instead of homepage of community. 
Can we achieve this by adding startURL parameter in password reset mail?
Note: I dont want to go with customize password reset screen.
After successfull password reset i want to redirect custom url instead of homepage of community. 
Can we achieve this by adding startURL parameter in password reset mail?
Note: I dont want to go with customize password reset screen.
Good morning All,

Can someone suggest me to find duplicate reocrds in custom object (which have more than 15 million reocods). I tried by using below query but it consumes more time and failing with CPU time limit exception.

List<AggregateResult> acc=[SELECT Name, count(Id) FROM Account GROUP BY Name HAVING count(Id)>1];

Now i am planning to create batch job find and update those records, but it has to be done by subset of records I guess. 

Can someone advise me "Is there any other way to achieve this?"

Thanks in advance !!!
I need to add startURL parameter in reset password mail (Community User)
After successfull password reset i want to redirect custom url instead of homepage of community. 
Can we achieve this by adding startURL parameter in password reset mail?
Note: I dont want to go with customize password reset screen.
public static void removeold(Set<Id> oldRecords){

    try{       
       ShareListoAgent = New List<SObject> ();
        ObjectName=new List<Id>(oldRecords).get(0).getSObjectType().getDescribe().getName();
        String queryStr ='select id,UserOrGroupId,parentid,RowCause  from';
        
        if(ObjectName == MemberUpper){
            queryStr = queryStr + ' MemberUpper_Share ';
        }
        if(ObjectName == MemberLower){
            queryStr = queryStr + ' MemberLower_Share ';
        }
        if(ObjectName == 'Account'){
            queryStr = 'select id,UserOrGroupId,AccountId,RowCause  from' + ' AccountShare where AccountId in:oldRecords and RowCause = \'Manual\'';
        }
        if(ObjectName == MemberLower || ObjectName == MemberUpper){
            queryStr = queryStr+'where ParentId in:oldRecords and RowCause = \'Manual\'';
        }
        ShareListoAgent.addAll(Database.query(queryStr));
        //ShareListoAgent = [select id,UserOrGroupId,parentid,RowCause  from MemberUpper_Share where parentid in: oldRecords and RowCause = 'Manual' ];
        system.debug('*******ShareListoAgent*******'+ShareListoAgent);
        if(ShareListoAgent !=null && ShareListoAgent.size()>0){
            delete ShareListoAgent;
        }
      }

 
Suggest a soql query to find duplicates in Account objects . R1_ACC_TXT_Id_Golden_record__c is a primay key on our Account object.I am using below query to find all instnaces of an Account in our org but the query is timing out.
SELECT count(Id) FROM Account GROUP BY R1_ACC_TXT_Id_Golden_record__c HAVING count(Id)>1 
Hi,
I have the field name and I need to find the object to which it belongs to?
example:
field name: Status
I need to find the object to which this field belongs?