Guys,

i found following solution but this one shows the result based on days in month.

select day_only(createdDate) createdonDate,
count(createdDate) numCreated
from account
group by day_only(createdDate)
order by day_only(createdDate) desc

But i want result based on month.

Regards,

Vishal Thoriya.

Hi,

I have a "New Account" button on Account object.

this new Account button redirects to another visualforce page.

Now, i want When a user clicks the "New Account" button on the Account Page Layout and they do not have the "Create" permission on their user profile or granted through permission sets, the following error message is displayed: "You have insufficient privileges to create Accounts".

Bid__c Object record values does not getting updated when I exectute this trigger. But I didn't receive any error in this trigger. The Bid__c object values alone not getting updated

trigger UpdateRFQBid on RFQ__c (after update)
{
  List<Bid__c> lstBid = new List<Bid__c>();
   for(RFQ__c r : Trigger.new)
  {
   if(r.Mode_s__c != null)
    {
      // split out the multi-select picklist using the semicolon delimiter
     for(String modes: r.Mode_s__c.split(';'))
    {
        if (modes == 'Private Fleet' && r.Bid_Private_Fleet__c == true)
        {
          // Check for EXISTING Record:
          Bid__c[] Old_Bid =
          [ SELECT Id FROM Bid__c WHERE Modes__c='Private Fleet' AND RFQ__c=:r.id];
          System.debug('Old_Bid.Size()=' + Old_Bid.Size());
          if(Old_Bid.Size()==0) // If NONE then Add
          {
             {
                Bid__c b               = new Bid__c();
                b.RFQ__C               = r.id;
                b.RecordTypeId         = '012Z00000004XEsIAM';
                b.Modes__c             = 'Private Fleet';
                b.Apex_trigger__c      = true;
                lstBid.add(b);
             }
          }     
         }
       
       {
        if (modes == 'Dry Van')
        {
         // Check for EXISTING Record:
          Bid__c[] Old_Bid =
          [ SELECT Id FROM Bid__c WHERE Modes__c='Dry Van' AND RFQ__c=:r.id];
          System.debug('Old_Bid.Size()=' + Old_Bid.Size());
          if(Old_Bid.Size()==0) // If NONE then Add
         {
            Bid__c b               = new Bid__c();
            b.RFQ__C               = r.id;
            b.RecordTypeId         = '012Z00000004XExIAM';
            b.Modes__c             = 'Dry Van';
            b.Apex_trigger__c      = true;
            lstBid.add(b);
          }
        }
       }
       
       {
          if (modes == 'Flatbed')
        {
          // Check for EXISTING Record:
           system.debug('&&&&&&');
          Bid__c[] Old_Bid =
          [ SELECT Id FROM Bid__c WHERE Modes__c='Flatbed' AND RFQ__c=:r.id];
          System.debug('Old_Bid.Size()=' + Old_Bid.Size());
          if(Old_Bid.Size()==0) // If NONE then Add
          {
            Bid__c b               = new Bid__c();
            b.RFQ__C               = r.id;
            b.RecordTypeId         = '012Z00000004XFqIAM';
            b.Modes__c             = 'Flatbed';
            b.Apex_trigger__c      = true;
            lstBid.add(b);
          }
          }
       }
       
       {
          if (modes == 'IMDL')
        {
          // Check for EXISTING Record:
          Bid__c[] Old_Bid =
          [ SELECT Id FROM Bid__c WHERE Modes__c='IMDL' AND RFQ__c=:r.id];
          System.debug('Old_Bid.Size()=' + Old_Bid.Size());
          if(Old_Bid.Size()==0) // If NONE then Add
          {
            Bid__c b               = new Bid__c();
            b.RFQ__C               = r.id;
            b.RecordTypeId         = '012Z00000004XG5IAM';
            b.Modes__c             = 'IMDL';
            b.Apex_trigger__c      = true;
            lstBid.add(b);
          }
          }
       }
       
       {
         if (modes == 'LTL')
        {
          // Check for EXISTING Record:
          Bid__c[] Old_Bid =
          [ SELECT Id FROM Bid__c WHERE Modes__c='LTL' AND RFQ__c=:r.id];
          System.debug('Old_Bid.Size()=' + Old_Bid.Size());
          if(Old_Bid.Size()==0) // If NONE then Add
          {
            Bid__c b               = new Bid__c();
            b.RFQ__C               = r.id;
            b.RecordTypeId         = '012Z00000004XG0IAM';
            b.Modes__c             = 'LTL';
            b.Apex_trigger__c      = true;
            lstBid.add(b);
          }
        }
        }
        
       {
         if (modes == 'Reefer')
        {
          // Check for EXISTING Record:
          Bid__c[] Old_Bid =
          [ SELECT Id FROM Bid__c WHERE Modes__c='Reefer' AND RFQ__c=:r.id];
          System.debug('Old_Bid.Size()=' + Old_Bid.Size());
          if(Old_Bid.Size()==0) // If NONE then Add
          {
            Bid__c b               = new Bid__c();
            b.RFQ__C               = r.id;
            b.RecordTypeId         = '012Z00000004XFlIAM';
            b.Modes__c             = 'Reefer';
            b.Apex_trigger__c      = true;
            lstBid.add(b);
          }
        }
        }
       
      {
         if (modes == 'RFI')
        {
          // Check for EXISTING Record:
          Bid__c[] Old_Bid =
          [ SELECT Id FROM Bid__c WHERE Modes__c='RFI' AND RFQ__c=:r.id];
          System.debug('Old_Bid.Size()=' + Old_Bid.Size());
          if(Old_Bid.Size()==0) // If NONE then Add
          {
            Bid__c b               = new Bid__c();
            b.RFQ__C               = r.id;
            b.RecordTypeId         = '012Z00000004XFvIAM';
            b.Modes__c             = 'RFI';
            b.Apex_trigger__c      = true;
            lstBid.add(b);
          }
        }
      }
     }
   }
    }
   upsert lstBid;
 }

Can u tell  me how i can reframe  logic to elimiate soql inside for loop. What is the best possible way.

I had written a logic in which a soql was placed inside a for loop. I got to know it is not a good way of implementation.

Please share your knowledge.