Hi pls help me in solving below issue...

In the IDEA tool when u post a comment on a submitted request those comments are not getting updated  in the email.New  comments has to get updated in the email according to requirement.

Thanks,

Indu

Hi, Can any one help me how to create email template of below format & in workflow when we select template in email alert then email has to ba sent to creator & owner.

To:  <Product Creator>

Bcc:  <Product Owner>

From:  <AeroDoNotReply>

Subject:  Product Exchange:  <insert Idea Title>

Dear Colleague:

Thank you for submitting your Product <insert Product link>.  Please refer to

latest status and any updated comments below:

Please use the Product Exchange “Comments” to post feedback.

Thank you, we appreciate your support!

Sincerely,

Product Exchange Team 

Thanks,

Indu.

Hi,

Can any one help....

When status changes or comments post the email has to be sent.

Hi-pls can any one help me to fix this issue.Its urgent requirement..

How to write formula for a formula field to calculate time when the status=open or reopen til lthe record will be saved.

For example if we keep the status=open or eopen for 10 mins it should display time as 10 mins.

Thanks,

Indu.

Hi,

Pls help me ou in fixing the below error.

{!REQUIRESCRIPT("/soap/ajax/19.0/connection.js")}
var fevent='{!Field_Event__c.Id}';
var result=sforce.connection.query("Select Id,Name,Account_Name__c,Account_Name_Formula__c,Contact__c,Contact_Name__c,Aircraft_Type__c,Aircraft_Tail_Number__c,Product_Type__c,Catalog_Product_Group__c,Supported_Product__c,Problem_Description__c from Field_Event__c where Id='"+ fevent+"'");
var records1 = result.getArray('records');
var AccountName = escape(records1[0].Account_Name_Formula__c);
if(AccountName==null)
{
AccountName = '';
}
var ContactName = records1[0].Contact__c;
var AirCraftType = records1[0].Aircraft_Type__c;
var TailNumber = records1[0].Aircraft_Tail_Number__c;
if(TailNumber==null)
{
TailNumber='';
}
var ProductType =escape(records1[0].Product_Type__c);
var CatalogProductGroup = escape(records1[0].Catalog_Product_Group__c);
var SupportedProduct= escape(records1[0].Supported_Product__c);
var Description = escape(records1[0].Problem_Description__c);
var fno = records1[0].Name;
if(AirCraftType!=null)
{
AirCraftType=AirCraftType.substring(0,15);
var airr=sforce.connection.query("Select Id,Name from Platform__c where Id ='"+ AirCraftType+"'");
var records2 = airr.getArray('records');
var AirCraftName =escape(records2[0].Name);
}

if(ContactName!=null)
{
ContactName=ContactName.substring(0,15);
var con=sforce.connection.query("Select Id,Name from Contact where Id ='"+ ContactName+"'");
var records3= con.getArray('records');
var ConName =escape(records3[0].Name);
}

var RecordtypeName='SR(General)';
var result=sforce.connection.query("Select Id,Name from RecordType where name ='"+ RecordtypeName+"'");
var records1 = result.getArray('records');
rec = records1[0];
var recordType=rec.Id;
var recName = rec.Name;

if(AirCraftType!=null && ContactName!=null)
{

parent.window.location.replace ('/a1V/e?CF00N30000004rd0p='+AccountName+'&CF00N30000004rd1J='+ConName+ '&CF00N30000004rd0r='+AirCraftName+'&00N30000004rd0q='+TailNumber+'&00N30000004rd1z='+ProductType+'&00N30000004rd12='+CatalogProductGroup +'&00N30000004rd2P='+SupportedProduct+'&00N30000004rd1t='+Description+'&RecordType='+recordType+'&CF00N30000004rd1d='+fno+'&retURL=/'+fevent+'&nooverride=1');
}
else if(ContactName!=null)
{
parent.window.location.replace ('/a1V/e?CF00N30000004rd0p='+AccountName+'&CF00N30000004rd1J='+ConName+ '&00N30000004rd0q='+TailNumber+'&00N30000004rd1z='+ProductType+'&00N30000004rd12='+CatalogProductGroup +'&00N30000004rd2P='+SupportedProduct+'&00N30000004rd1t='+Description+'&RecordType='+recordType+'&CF00N30000004rd1d='+fno+'&retURL=/'+fevent+'&nooverride=1');
}
else if(AirCraftType!=null)
{
parent.window.location.replace ('/a1V/e?CF00N30000004rd0p='+AccountName+'&CF00N30000004rd0r='+AirCraftName+'&00N30000004rd0q='+TailNumber+'&00N30000004rd1z='+ProductType+'&00N30000004rd12='+CatalogProductGroup +'&00N30000004rd2P='+SupportedProduct+'&00N30000004rd1t='+Description+'&RecordType='+recordType+'&CF00N30000004rd1d='+fno+'&retURL=/'+fevent+'&nooverride=1');

}

 Thanks,

Indu.

A problem with the onsite java script for the button or link was encountered missing ; before statement

Hi,

The requirement is like when the status=open or reopen till the record is saved it has to capture the time,for this help me out how to write trigger .Bsaed on the time the SLA Flag has to set.

Thanks,

Indu.

trigger User_NonAdminProfiles_EditFields on User (before update) {
    List<User> users = Trigger.new;
    String prof = Userinfo.getProfileId();
    String profname = [Select name from Profile where Id=:prof].name;
    profname = profname.tolowercase();

    if(profname == 'D&S Sales Admin')
    {
        for(Integer i=0;i<users.size();i++){
            if(Trigger.old[i].Profile_Name__c.contains('D&S') ||  Trigger.new[i].Role_Name__c.contains('D&S'))
            {
                if(Trigger.old[i].EmployeeNumber != Trigger.new[i].EmployeeNumber || Trigger.old[i].email != Trigger.new[i].email
                    || Trigger.old[i].CommunityNickname != Trigger.new[i].CommunityNickname ||Trigger.old[i].IsActive != Trigger.new[i].IsActive 
                    || Trigger.old[i].UserPermissionsOfflineUser != Trigger.new[i].UserPermissionsOfflineUser
                    || Trigger.old[i].Citizenship_Cntry__c != Trigger.new[i].Citizenship_Cntry__c
                    || Trigger.old[i].Citizenship_Status_Descr__c != Trigger.new[i].Citizenship_Status_Descr__c
                    || Trigger.old[i].US_Permanent_Resident__c != Trigger.new[i].US_Permanent_Resident__c
                    || Trigger.old[i].US_Permanent_Resident_Card_Expiry__c != Trigger.new[i].US_Permanent_Resident_Card_Expiry__c)
                {
                    Trigger.new[i].addError('You are not authorized to change this information');
                }
            } 
            else
            {
                if(Trigger.old[i] != Trigger.new[i])
                {
                    Trigger.new[i].addError('You are not authorized to change this information');
                }
            }
        }
    }
    else
    {
        if(!(profname.contains('peoplesoft')) && !(profname.contains('admin')) && !(profname.contains('sales admin'))){
            for(Integer i=0;i<users.size();i++){
                if((Trigger.old[i].FirstName != Trigger.new[i].FirstName) ||
                (Trigger.old[i].CurrentStatus != Trigger.new[i].CurrentStatus) || 
                (Trigger.old[i].AboutMe != Trigger.new[i].AboutMe) ||
                (Trigger.old[i].Street != Trigger.new[i].Street) ||
                (Trigger.old[i].City != Trigger.new[i].City) ||       
                (Trigger.old[i].State != Trigger.new[i].State) ||
                (Trigger.old[i].PostalCode != Trigger.new[i].PostalCode) ||     
                (Trigger.old[i].Country != Trigger.new[i].Country) ||            
                (Trigger.old[i].Fax != Trigger.new[i].Fax) ||
                (Trigger.old[i].Title != Trigger.new[i].Title) ||
                (Trigger.old[i].LocaleSidKey != Trigger.new[i].LocaleSidKey) ||
                (Trigger.old[i].LanguageLocaleKey != Trigger.new[i].LanguageLocaleKey)||                        
                (Trigger.old[i].TimeZoneSidKey != Trigger.new[i].TimeZoneSidKey) || 
                (Trigger.old[i].MobilePhone != Trigger.new[i].MobilePhone) || 
                (Trigger.old[i].Phone != Trigger.new[i].Phone) || 
                (Trigger.old[i].Signature1__c != Trigger.new[i].Signature1__c) ||
                (Trigger.old[i].Tier_1_Leader__c != Trigger.new[i].Tier_1_Leader__c) ||
                (Trigger.old[i].Tier_2_Leader__c != Trigger.new[i].Tier_2_Leader__c) ||
                (Trigger.old[i].Tier_3_Leader__c != Trigger.new[i].Tier_3_Leader__c) ||
                (Trigger.old[i].Tier_4_Leader__c != Trigger.new[i].Tier_4_Leader__c) ||
                (Trigger.old[i].Tier_5_Leader__c != Trigger.new[i].Tier_5_Leader__c) ||
                (Trigger.old[i] == Trigger.new[i])
                )
                    System.Debug('Editable fields');
                else
                    Trigger.new[i].addError('You are not authorized to update any information except First Name, Address, Title, Language, Time zone, Signature, Work and Mobile phone numbers');
            }
        }
    }
}

@isTest
private  class Test_updateTempBasedOnSBU
{
    static testmethod void updateTempBasedOnSBU_Triggers(){

        Profile pf= [select id from Profile where name = 'System Administrator'];
    
        User usr = new User(LastName = 'UrMst',Username = 'UrMst@test.com',Email = 'UrMst@test.com',Alias = 'UrMst9' ,CommunityNickname= 'UrMst3' ,TimeZoneSidKey = 'America/Los_Angeles',LocaleSidKey='en_US',EmailEncodingKey= 'ISO-8859-1',ProfileId = pf.Id, LanguageLocaleKey = 'en_US',SBU_User__c = 'D&S');
        insert usr;
    
        System.runAs(usr)
        {
            try
            {
                Account acc= new Account(name='NewAcnt', Market_Name__c = 'Helicopters');
                insert acc;
                
                acc.Strategic_Business_Unit__c = 'ATR';
                acc.Market_Name__c = 'Military';
                update acc;
                
                acc.Strategic_Business_Unit__c = 'BGA';
                update acc;
                
                acc.Strategic_Business_Unit__c = 'D&S';
                update acc;
                
                
                
                Account acc1 = new Account(name = 'New Test Account', Market_Name__c = 'Intercompany');
                insert acc1;
                
                acc1.Market_Name__c = 'Intercompany';
                acc1.Name = 'HONEYWELL EMPLOYEE AMERICAS';
                update acc1;

                acc1.Market_Name__c = 'Helicopters';
                acc1.Strategic_Business_Unit__c = 'D&S';
                update acc1;
            }
            catch(System.DMLException e){
            }
        }
    }
}

 Hi,

  I have added Tier1 Leader,Tier2 Leader,Tier3 Leader,Tier4 Leader,Tier5 Leader fields in trigger according to it pls do changes in testclass to improve codecoverage.pls help me in this,...

Thanks,

Indu.

Hi,

    Can any one suggest me how to fix the below requirement issue.

The Tech Ops Center needs SLA flags set for Technical Issue Cases.  Flags need to be set from Case Created and from Case Re-Opened.

From Case Created and Case Status = Open

Green = Case Age < 10 hours

Yellow = Case Age > or = 10 hours and < or = 15 hours

Red = Case Age > or = 16 hours

From Case Re-opened and Case Status = Re-Open 

Create a new field called Re-Open Age to calculate the time from when a case is re-opened until when it is closed.

Green = Case Re-Open Age < 10 hours

Yellow = Case Re-Open Age > or = 10 hours and < or = 15 hours

Red = Case Re-Open Age > or = 16 hours

Thanks,

Indu.

Thanks,

Indu.

Hi,

 Can any one help me out to write test class for below apex class.

public class StopRecursivecall
 {
                 private static boolean Update_OnBehalfendUserStatus = false;
      public static boolean hasUpdate_OnBehalfendUserStatus() 
                  {
        return Update_OnBehalfendUserStatus;
     }
                 public static void setUpdate_OnBehalfendUserStatus() {
        Update_OnBehalfendUserStatus = true;
    }
 }

 Thanks,

Indu.

Hi,

The requirement is like when the status=open or reopen till the record is saved it has to capture the time,for this help me out how to write trigger .Bsaed on the time the SLA Flag has to set.

Thanks,

Indu.

Thanks,

Indu.

Hi,

 Can any one help me out to write test class for below apex class.

public class StopRecursivecall
 {
                 private static boolean Update_OnBehalfendUserStatus = false;
      public static boolean hasUpdate_OnBehalfendUserStatus() 
                  {
        return Update_OnBehalfendUserStatus;
     }
                 public static void setUpdate_OnBehalfendUserStatus() {
        Update_OnBehalfendUserStatus = true;
    }
 }

 Thanks,

Indu.