• Raumil Setalwad
  • NEWBIE
  • 97 Points
  • Member since 2010

  • Chatter
    Feed
  • 3
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 3
    Questions
  • 54
    Replies

Hi All,

 

We have 1 million records in Account object, It is getting long time to respond open a report.

Can you tell me the possible ways to open report quickly manner.(Is any configurations we need setup)

  • April 28, 2011
  • Like
  • 0

In Standard Object , why can't set picklist as required field ?

Hello,

 

Is It possible to obtain a fourth column in the dashboard?

 

Thanks in advance!

  • January 19, 2011
  • Like
  • 0

Hello Friends

Currently according to one of our Customer requirement we need to use "Cases" standrad object of salesforce. I searched but couldn't find anything so i would request members to guide me how to use "Cases" or provide me link for tutorial of how to use "Cases" . Any Help will be appreciated

 

Regards

Raumil Setalwad

Hello freinds recently i am facing a starnge issue that all sites related to bloga such as "blog.sforce.com" or on clicking on "blog" link in website "Developer.force.com" the message displayed "could not connect to "blog.sforce.com"  I have checked in chrome, Mozilla and IE in all browsers the blogs are not opening. I don't why what has happened. but since 1 month i am facing this issue. Please suggest Me solution.

 

Regards

Raumil Setalwad

Hello Friends,

I am creating s functionality in which user can create its own Email Template not templates which are already predefined. For that I am using tinyMCE editor. My main question is that if we create a Custom Template using salesforce "Merge Field" functionality is provided. I want to implement that functionality.Please guide me how to implement this functionality. Any help would be appreciated

wat is mini page layout and mini console view?
Hi,
Is there any way to provide the ability to sync sent emails from CRM to Outlook and Outlook to CRM.
Thanks in Advance
Rasesh

Hi All,

 

We have 1 million records in Account object, It is getting long time to respond open a report.

Can you tell me the possible ways to open report quickly manner.(Is any configurations we need setup)

  • April 28, 2011
  • Like
  • 0

Is there word, blog posts, wiki articles or anything that gives insight into the timing of the availablity and what shape the programming interface will take in the announced integration/partnership between QuickBooks and Salesforce.

  • April 26, 2011
  • Like
  • 0

Hi all,

 

I want to ask is it possible to view, create, edit Account or Contact records in Customer Portal? I only can create, edit, view Cases in Customer portal user.. I want to have access to Account or COntact using customer portal user. Any suggestions would be great..

Thanks...

 

 

Regards

New post, This is very helpful to get the field comparison in a SOQL query in where clause.

 

http://simplyforce.blogspot.com/2011/04/tricks-comparing-two-fields-in-soql.html

 

Hi All,

 

    I have a requirement wherein, I need to create the packages in the Invoice, when the record type of the Items is 'package' in the Invoice_Line_Item, then the required number of packages are to be created.

 

   I am getting the desired output, but when I have written the TestCase, the code coverage is 42%.   But, in order to migrate the code on to Live, we need a minimum code coverage of 75%.  

 

  So, could anyone suggest a solution for the above mentioned problem.  I am posting both the Class and TestCase, do suggest a solution.

 

Apex Class

 

 

public class MyClass
{
    
      public static void createPackage(Invoice__c [] inv)
      {
       
         
       for(Invoice__c i : inv)
       {
           Invoice_Line_Item__c[] a1;
           a1 = [select id,name,Item__r.RecordTypeId  from Invoice_Line_Item__c  where invoice_number__c =:i.id and Item__r.RecordTypeId='01290000000K8Ba'];
           Integer j=a1.size();
           for(Invoice_Line_Item__c a2 : a1)
           {
            
            if((i.Create_Package__c==true)||(i.Status__c=='FULLY PAID'))
            {
                 for(Integer k=1;k<=j;k++)
                 {
                 if(i.Package_Status__c!='Package Created')
                  {
                   
                  Package__c p1 = new Package__c();
                  p1.RecordTypeId='01290000000Xn01';
                  p1.invoice__c = i.id;
                  p1.Invoice_Line_Item__c = a2.id;
                  p1.patient__c= i.Patient__c;
                 
                   insert p1;
                 }
                 }
                 
                  i.Package_Status__c='Package Created';
             }
             
            }  
               
             
        }        
                
      }
    }
   
Test Case
@isTest
private class MyClassTestCase {
static testMethod void createPackage() {
item__c v =[select id,name from item__c limit 1];
// invoice__c i = [select id,name, Patient__c from invoice__c limit 1];
               
invoice__c i = [select id,name,Create_Package__c, Status__c, Patient__c, 
                Package_Status__c from invoice__c limit 1];
Invoice_Line_Item__c il = new Invoice_Line_Item__c ();
il.invoice_number__c = i.id;
il.item__c = v.id;
insert il;
if((i.Create_Package__c==true)||(i.Status__c=='FULLY PAID'))
{
         
   if(i.Package_Status__c!='Package Created')
   {
    Package__c p1 = new Package__c();
    p1.RecordTypeId='01290000000Xn01';
    p1.invoice__c = i.id;
    p1.Invoice_Line_Item__c = il.id;
    p1.patient__c= i.Patient__c;
               
    insert p1;
    
    }
    
   i.Package_Status__c='Package Created';
  }
}
}
           
Do suggest a solution and guide me in the right path.
Thanks and Regards
Arun
           
           
           
           
       
       
      

 

I am doing a scheduled batch function. When I runing the batch class, it will occur a 'UNKNOWN_EXCEPTION' this is the information of the exception:

 

Apex script unhandled exception by user/organization:

005M0000000Dk0p/00DM00000008c2d

Source organization: 00D80000000LyP5 (null)

Failed to process batch for class 'HsAppExtEventBatchClass' for job id

'707M00000004nRD'

 

 caused by: System.DmlException: Update failed. First exception on row 96 with id 00UM00000016W9HMAU; first error: UNKNOWN_EXCEPTION, An unknown exception has occurred.: []

 

 Class.HsAppExtEventBatchClass.execute: line 40, column 6 External entry point

 

Is here any one can  provide me with any solutions or suggestions?

Thank you!

 

-------------------------schedule class----------------------------------

        Date t = system.today() - 365;

        List<Id> tempList = new List<Id>();
        String accountIdStr = '';
        String userIdStr = '';
        HsAppExtEventBatchClass eventBatch = new HsAppExtEventBatchClass();
        
        List<Event> el = [Select AccountId From Event where EndDateTime < :t and AccountId <> null and IsDeleted = false];
        if(el != null && el.size() != 0){
            for(Event ev: el){
                tempList.add(ev.AccountId);
            }    
            
            List<User> userList = [select id from User where IsActive = true];
            for(User u: userList){
                userIdStr = userIdStr + ',\'' + u.id + '\'';
            }
            userIdStr = userIdStr.substring(1,userIdStr.length());
            
            List<Contact> conList = [Select AccountId From Contact where AccountId = :tempList and Litigation_Hold__c != true and AccountId <> null and IsDeleted = false];
            if(conList != null && conList.size() != 0){    
                for(Contact con: conList){
                    accountIdStr = accountIdStr + ',\'' + con.AccountId + '\'';
                }
                accountIdStr = accountIdStr.substring(1,accountIdStr.length());
                eventBatch.query = 'select id,PreCall__c, RecordTypeId, PostCall__c, Status__c, Description, EndDateTime,StartDateTime,DurationInMinutes From Event where AccountId in ('+ accountIdStr +') and OwnerId in ('+ userIdStr +')';
            }else{
                eventBatch.query = '';
            }                    
        }else{
            eventBatch.query = '';
        }
                       
        Database.executeBatch(eventBatch);

--------------------------------------------end----------------------------------

 

--------------------------------------batch class---------------------------

    global void execute (Database.BatchableContext bc, List<sObject> scope){
        Date t = system.today() - 365;
        RecordType rt  = [select id,name from RecordType where name='Locked Activity Type'];
        List<Event> evList = new List<Event>();
        List<FeedPost> fpList = new List<FeedPost>();
        List<ID> eventIdList = new List<ID>();
       
        for(sObject s : scope){
            Event ev = (Event)s;
            ev.PreCall__c = null;
            ev.PostCall__c = null;
            ev.Description = null;
            ev.RecordTypeId = rt.Id;      
            ev.Status__c = 'Did not occur';
            if(ev.DurationInMinutes>0){
                evList.add(ev);
                eventIdList.add(ev.id);
            }            
        }
       
        EventFeed[] cfList = [SELECT Id, FeedPost.id  FROM EventFeed where ParentId = :eventIdList and CreatedDate < :t];
        for(EventFeed cf: cfList){
                fpList.add(cf.FeedPost);
        }    
        
        try{
            update evList;
            delete fpList;
        }catch(Exception ex){
            system.debug(ex);
        }
    }

-------------------------------------batch end--------------------------------------------------

Hi,

 

I had created a application using a Free Developer Edition and did an Unmanaged package of the application and got a link. I am trying to use the link to install the Application in our Sandbox and am not able to do so. The link is always pointing to the Production environment and not to the sandbox.

 

What should I do now? 

 

Thanks

KD

Dashboard other user cant see using force.com-free licence. 

when i try to migrate the opportunity, they throw an error that

 

close date greater than todays date

 

if any body knows the answer for this please let me know


thanks in advance.

  • April 11, 2011
  • Like
  • 0

Restrict Duplicate Records In Salesforce [Duplicate Detector]
http://techsahre.blogspot.com/2011/04/restrict-duplicate-records-in.html

 

Thanks

Aslam Bari

  • April 09, 2011
  • Like
  • 0

Hi. My website requires leads to upload 3 photographs (jpg images), and I need these photos to come over to the lead record when created.  Is this possible?

  • April 08, 2011
  • Like
  • 0

Unable to read repository at http://www.adnsandbox.com/tools/ide/install/site.xml.
  Unable to read repository at http://www.adnsandbox.com/tools/ide/install/site.xml.
  sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

In Standard Object , why can't set picklist as required field ?

i create totally 3 users in salesforce.i create a dashboard in admin user. other two user cannot view the dashboard. how to other user view the dashboard?  

Hi,

I want delete many activiy history for reduce the data storage into SF.

 

I did a query with data loader by query task using filter like "where createddate < 2010-06-01:00:00:00.000z" and work properly (I got id and I deleted with dataloader many task)

 

But I see that there are many activity history which I can't delete, I try to count it on eclipse with this code :

select count() from activityhistory where createddate < 2010-06-01....

 but eclips give me a popup : "you can't do a query into this object"

 

How can I get ids of activityhistory and then delete it with dataloader?

 

thanks

 

 

 

I've signed up twice and never recieved the email with the GoToMeeting link.  Does anyone know the URL for the meeting?  I'm on the call bridge (Salesforce makes that available to people who have registered under the "If you didn't get the email, here's the info" but it doesn't include the GoToMeeting.  Silly Salesforce!

I am trying to write a single query to get an account record and the count of contacts for the account.  Can this be done?

 

Ex: 

SELECT Name,Id,BillingState, (SELECT count() FROM Contact Where Contact.AccountID = Id) FROM Account WHERE Name like '%Test%'"

 

Thank You

Dakota

 

 

  • March 29, 2011
  • Like
  • 0

I am trying to refresh my dashboard but it is continuously showing 'Refreshing dashboard...' and Last refreshed date is not being refreshed. All other dashboards are refreshing.

 

I dont understand why this issue is coming? I am new to Reports and dashboards, Plz help..