• sekhara
  • NEWBIE
  • 155 Points
  • Member since 2011

  • Chatter
    Feed
  • 6
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 56
    Questions
  • 134
    Replies

I'm trying to embed a visualforce page into the home page of the customer portal. When I add a new home page component, and do an iFrame it always shows a vertical scrollbar. When i change it to height="100%" and scrollbars="false" it still shows the scrollbars, and the height doesn't change.

 

Anyone else experience this problem?

Hi In Below VF page i am not getting background colour,

 

Could you please help me here..

 

<apex:page standardController="Business_Plan__c" extensions="Business_Plan" sidebar="true">
  <head><meta http-equiv="X-UA-Compatible" content="IE=edge" /></head>

   <apex:stylesheet value="{!URLFOR($Resource.DSP, 'css/vf-tab.css')}" />
   <apex:stylesheet value="{!URLFOR($Resource.DSP, 'css/dsp-tab-data.css')}" />
  
   <div class="bPageBlock brndScnBrd secondaryPalette">
   <div class="pbBody">
          <table class="list" width="100%" border="0" cellspacing="0" cellpadding="0">
            <tbody>
            <tr class="headerRow" >
            <th scope="col" class="zen-deemphasize">Contact Name</th>
           
            <th scope="col" class="zen-deemphasize">Job Title</th>
            
            <th scope="col" class="zen-deemphasize">Email</th>
            <th scope="col" class="zen-deemphasize">Phone</th>
            </tr>
            <apex:repeat value="{!contactList}" var="ContactRL" id="foreaContact">
            <tr class="dataRow with-data" onblur="if (window.hiOff){hiOff(this);}" onfocus="if (window.hiOn){hiOn(this);}" onmouseout="if (window.hiOff){hiOff(this);}" onmouseover="if (window.hiOn){hiOn(this);}">
            <td class="ContactRL odd"><div><a href="/{!ContactRL.Id}" target="_top">{!ContactRL.Name}</a></div></td>
           
            <td class="Job Title even">{!ContactRL.Job_title__c}</td>
            <td class="ContactRL d odd">{!ContactRL.email}</td>
            <td class="ContactRL even">{!ContactRL.phone}</td>
            </tr>
            </apex:repeat>
            </tbody>
          </table>
    </div>
    </div>
    </apex:page>

 

 

 
  • November 29, 2012
  • Like
  • 0

HI  SFDC guys , if any one is interested  to teach salesforce as a trainee please mail me  with your contact details as soon as possible

ashoksalesforce3@gmail.com

HI

 

I have two field 1 of Currency & other of amount field .

In it we i am getting Negative values , but i want to remove that Minus Symbol in visulaforce email template

 

Now i am using  {!RIGHT(time,LEN(time)-3)} but this is only for text field.

 

And we can sort by date 

 

 

Can  any one help on this... 

How to send n number of Emails from Salesforce with visualforce templates

Error: System.DmlException: Insert failed. First exception on row 0; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, trgCaptureConsultants: execution of BeforeInsert caused by: System.QueryException: Non-selective query against large object type (more than 100000 rows). Consider an indexed filter or contact salesforce.com about custom indexing. Even if a field is indexed a filter might still not be selective when: 1. The filter value includes null (for instance binding with a list that contains null) 2. Data skew exists whereby the number of matching rows is very large (for instance, filtering for a particular foreign key value that occurs many times) Trigger.trgCaptureConsultants: line 97, column 1: [] (System Code)

Hi,

 

I am new to Visaul workflows, I am trying to populate values when user clicked finish button to URL.

 

Can any one help on this ?

  • September 10, 2013
  • Like
  • 0

Hi,

 

I am trying to send 2 mails when client is enabled as customer portal. 

 

1. Standard mail contains URL, Username, Password.

2. Contains company info.

 

But for 2nd mail I am trying to workflow email alert but it is not working. Can any ine can help on this issue.

 

 

Thanks In Advance.

Hi ,

 

I am trying to search using Multi select picklist but my code is working for only picklist.

 

Code:

public List<String> technologies {
get {
if (technologies == null) {

technologies = new List<String>();
Schema.DescribeFieldResult field = Contact.test__c.getDescribe();

for (Schema.PicklistEntry f : field.getPicklistValues())
technologies.add(f.getLabel());

}
return technologies;
}
set;
}

 

Can any one convert this code to Multi select picklist.

 

Thanks in advance.

Hi ,

 

I am trying to generate pdf using Rich text area Data Type Fields , but I am unable to set all data in same font .

 

Font family calibri 

 

 

Can any one help on it.

Hi ,

 

 

I am using on Rich text Data Type field in PDF.  

 

<apex:outputtext Value="{!Richtextarea__c}" escape="false"/>

 

I am Use this field in Apex:repeat tag

 

While in output data is cutting at last.

 

For ex :

 

I am using on Rich text Data Type field in PDF.    Actual Data what i except as output.

But

I am using on Rich text Data Type field in

PDF. Data is coming like this.

 

Thanks in advance....

 

Hi Pals,

 

I am trying to integrate Thunderbird to Linux Operation System, but in some conditiond it is working properly in some conditions it is not working porpertly.

 

Can any one give suggestion on it.

 

 

Thanks in Advance.

Hi,

 

I've created below class and want to display records in Visual source page.

 

And my jSon :

{
   "data": [
      {
         "name": "dsvsd",
         "id": "5275838"
      },

 

 

 

public class JSON2Apex1{

    public class Data {
        public String name;
        public String id;
    }

    public class Paging {
        public String next;
    }

    public List<Data> data;
    public Paging paging;

    
    public static JSON2Apex1 parse(String json) {
        return (JSON2Apex1) System.JSON.deserialize(json, JSON2Apex1.class);
    }
    }

  • September 24, 2012
  • Like
  • 0

HI ,

I am new to Mobile apps .

 

Can I get any code snippet or relevant document for Mobile Apps development.

If so can any one mail them.

 

mvrsreddy@gmail.com

 

Thanks in advance

  • September 04, 2012
  • Like
  • 0

Hi All,

 

I want to know steps how to use Apex Data Loader Command Line Pass.

At present I am use below link 

http://wiki.developerforce.com/page/Using_Data_Loader_from_the_command_line

 

  1. I can able to encrypt key and password.
  2. I can test Encrypted Password, It is showing positive result only.
  3. But while starting process the bat file then error is hitting

Error Message :

 

nternal (PartnerClient.java:519) - Salesforce login to https://login.salesforce.
com/services/Soap/u/25.0 as user mvrsreddy@gmail.com
2012-08-30 17:33:06,953 ERROR [accountMasterProcess] client.PartnerClient runOpe
ration (PartnerClient.java:332) - Error while calling web service operation: log
in, error was:
[LoginFault [ApiFault exceptionCode='INVALID_LOGIN'
exceptionMessage='Invalid username, password, security token; or user locked ou
t.'
]
]

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at com.sforce.ws.bind.TypeMapper.readSingle(TypeMapper.java:627)
at com.sforce.ws.bind.TypeMapper.readObject(TypeMapper.java:504)
at com.sforce.ws.transport.SoapConnection.parseDetail(SoapConnection.jav
a:229)
at com.sforce.ws.transport.SoapConnection.createException(SoapConnection
.java:203)
at com.sforce.ws.transport.SoapConnection.receive(SoapConnection.java:14
9)
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:98)
at com.sforce.soap.partner.PartnerConnection.login(PartnerConnection.jav
a:985)
at com.salesforce.dataloader.client.PartnerClient$8.run(PartnerClient.ja
va:161)
at com.salesforce.dataloader.client.PartnerClient$8.run(PartnerClient.ja
va:152)
at com.salesforce.dataloader.client.PartnerClient.runOperation(PartnerCl
ient.java:328)
at com.salesforce.dataloader.client.PartnerClient.loginInternal(PartnerC
lient.java:520)
at com.salesforce.dataloader.client.PartnerClient.login(PartnerClient.ja
va:488)
at com.salesforce.dataloader.client.PartnerClient.connect(PartnerClient.
java:213)
at com.salesforce.dataloader.controller.Controller.login(Controller.java
:172)
at com.salesforce.dataloader.controller.Controller.login(Controller.java
:167)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:128)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:100)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:253)
2012-08-30 17:33:07,015 ERROR [accountMasterProcess] client.PartnerClient loginI
nternal (PartnerClient.java:534) - Error while logging in to web service at: htt
ps://login.salesforce.com/services/Soap/u/25.0, error was:
[LoginFault [ApiFault exceptionCode='INVALID_LOGIN'
exceptionMessage='Invalid username, password, security token; or user locked ou
t.'
]
]

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at com.sforce.ws.bind.TypeMapper.readSingle(TypeMapper.java:627)
at com.sforce.ws.bind.TypeMapper.readObject(TypeMapper.java:504)
at com.sforce.ws.transport.SoapConnection.parseDetail(SoapConnection.jav
a:229)
at com.sforce.ws.transport.SoapConnection.createException(SoapConnection
.java:203)
at com.sforce.ws.transport.SoapConnection.receive(SoapConnection.java:14
9)
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:98)
at com.sforce.soap.partner.PartnerConnection.login(PartnerConnection.jav
a:985)
at com.salesforce.dataloader.client.PartnerClient$8.run(PartnerClient.ja
va:161)
at com.salesforce.dataloader.client.PartnerClient$8.run(PartnerClient.ja
va:152)
at com.salesforce.dataloader.client.PartnerClient.runOperation(PartnerCl
ient.java:328)
at com.salesforce.dataloader.client.PartnerClient.loginInternal(PartnerC
lient.java:520)
at com.salesforce.dataloader.client.PartnerClient.login(PartnerClient.ja
va:488)
at com.salesforce.dataloader.client.PartnerClient.connect(PartnerClient.
java:213)
at com.salesforce.dataloader.controller.Controller.login(Controller.java
:172)
at com.salesforce.dataloader.controller.Controller.login(Controller.java
:167)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:128)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:100)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:253)
2012-08-30 17:33:07,093 FATAL [main] process.ProcessRunner topLevelError (Proces
sRunner.java:238) - Unable to run process accountMasterProcess
java.lang.RuntimeException: Invalid username, password, security token; or user
locked out.
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:160)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:100)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:253)
Caused by: [LoginFault [ApiFault exceptionCode='INVALID_LOGIN'
exceptionMessage='Invalid username, password, security token; or user locked ou
t.'
]
]

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at com.sforce.ws.bind.TypeMapper.readSingle(TypeMapper.java:627)
at com.sforce.ws.bind.TypeMapper.readObject(TypeMapper.java:504)
at com.sforce.ws.transport.SoapConnection.parseDetail(SoapConnection.jav
a:229)
at com.sforce.ws.transport.SoapConnection.createException(SoapConnection
.java:203)
at com.sforce.ws.transport.SoapConnection.receive(SoapConnection.java:14
9)
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:98)
at com.sforce.soap.partner.PartnerConnection.login(PartnerConnection.jav
a:985)
at com.salesforce.dataloader.client.PartnerClient$8.run(PartnerClient.ja
va:161)
at com.salesforce.dataloader.client.PartnerClient$8.run(PartnerClient.ja
va:152)
at com.salesforce.dataloader.client.PartnerClient.runOperation(PartnerCl
ient.java:328)
at com.salesforce.dataloader.client.PartnerClient.loginInternal(PartnerC
lient.java:520)
at com.salesforce.dataloader.client.PartnerClient.login(PartnerClient.ja
va:488)
at com.salesforce.dataloader.client.PartnerClient.connect(PartnerClient.
java:213)
at com.salesforce.dataloader.controller.Controller.login(Controller.java
:172)
at com.salesforce.dataloader.controller.Controller.login(Controller.java
:167)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:128)
... 2 more

 

 

Thanks in advance....

 

HI,

 

I am new to Integration part in Salesforce.

I want to integrate Salesforce Chatter for Twitter .

 

My fuctionality just like:

 

http://www.youtube.com/watch?v=FqeGxAuFqSM&feature=player_embedded

 

and 

 

http://techblog.appirio.com/2010/03/integrate-chatter-twitter-on-google-app.html

 

Thanks in advance!!

hi
 
my requirement is to add the rows & column values like
 
1 2 3  = 6
2 3 1  = 6
1 1 1 =  3
4 6 5
 
so i wrote code like this but will saving
 
 Error: Compile Error: Invalid type: objBudClass at line 19 column 40 . 
 
Can any one help on this issue.
 
Thank q .
 
 
 
public class GroupedQuery123
    public list<AggregateResult> lstAr = new list<AggregateResult>();
   
    public GroupedQuery123()
    {
        lstar = [SELECT Product_Service_Category_Poc__c, Case_Type_Poc__c ,
GROUPING(Product_Service_Category_Poc__c ) p1 , GROUPING(Case_Type_Poc__c ) p2,
COUNT(casenumber) tot1
FROM Case
where CreatedDate = THIS_WEEK and Status = 'open'
GROUP BY CUBE(Product_Service_Category_Poc__c , Case_Type_Poc__c )
order by GROUPING(Product_Service_Category_Poc__c ) , GROUPING(Case_Type_Poc__c )];
    }
    public list<BudClass> getResults(){
        list<BudClass> lstResult = new list<BudClass>();
        for(AggregateResult ar : lstAr){
            BudClass objBudClass = new objBudClass(ar);
            lstResult.add(objBudClass);
        }
        return lstResult;
    }
  
    class BudClass{
        public Double tot1{get;set;}
        public String p1 {get;set;}
        public String p2 {get;set;}
      
        public BudClass(AggregateResult ar){
        tot1 = (Double) ar.get('tot1');
           p1= (String) ar.get('p1');
            p2= (String) ar.get('p2');
        }
    }
}
 

hi

i am unable to sum the values in vf page can any one help on this.

 

My controller :

 

public class AAA_Cases
{
 public  AAA_Cases(ApexPages.StandardController controller)
    {  }
    public  Case[] c;
    
 public String[] states {get;set;}
  public String[] state1 {get;set;}
 public list<AggregateResult> lstAR = new list<AggregateResult>();
 public list<AggregateResult> lstAR1 = new list<AggregateResult>();
 /*
 Date currentdate = system.today();
  Date cr = currentdate+7;
  */
 public  AAA_Cases()
{
c = [select Product_Service_Category_Poc__c ,Case_Type_Poc__c from case where CreatedDate = THIS_WEEK ];// where CaseNumber = '00626808' ];
lstar = [Select Count(CaseNumber) tot1,Product_Service_Category_Poc__c p1,Case_Type_Poc__c p2 from  Case where CreatedDate = THIS_WEEK and Status = 'Open' group by Product_Service_Category_Poc__c,Case_Type_Poc__c];
//lstar = [Select Grouping(Product_Service_Category_Poc__c) p1,Case_Type_Poc__c p2, Count(CaseNumber) tot1 from  Case where CreatedDate = THIS_WEEK and Status = 'Open' group by Case_Type_Poc__c];
lstar1 = [Select Count(CaseNumber) tot , Product_Service_Category_Poc__c p,Case_Type_Poc__c p0 from  Case where CreatedDate = THIS_WEEK and Status = 'Closed' group by Product_Service_Category_Poc__c,Case_Type_Poc__c ];
Set<String> stateSet = new Set<String>();
      for(Case a : c)
     stateSet.add(a.Product_Service_Category_Poc__c); 
   states = new String[stateSet.size()];
    Integer i = 0;
    for (String state : stateSet) { 
      states[i] = state;
      i++;
    }
 states.sort();
 
 /*==========================*/
 
 Set<String> stateSet1 = new Set<String>();
      for(Case a1 : c)
     stateSet1.add(a1.Case_Type_Poc__c); 
   state1 = new String[stateSet1.size()];
    Integer j = 0;
    for (String state : stateSet1) { 
      state1[j] = state;
      j++;
    }
 state1.sort();
 /*==========================*/
 
}
 public String getname() {
return 'AAA_Cases';
}
public Case[] getc() {
return c;
}
 public list<Opp> getResult()  
{  
list<Opp> lstResult = new list<Opp>();  
for (AggregateResult ar: lstAR)  
{  
opp objOpp= new opp(ar);  
lstResult.add(objOpp);  
}  
return lstResult;  
}  
  
class opp
{  
public Double Tot1
{ get;set; } 
//public Double i{ get;set; } 
public string p1
{ get;set; } 
public string p2
{ get;set; }   
  
public opp(AggregateResult ar)  
{  
Tot1 = (Double)ar.get('Tot1');
//i = (Double)ar.get('i');
p1 = (string)ar.get('p1');
p2 = (string)ar.get('p2');
     }
   
 }
 /*============================= */ 
 public list<Opp1> getResult1()  
{  
list<Opp1> lstResult1 = new list<Opp1>();  
for (AggregateResult ar: lstAR1)  
{  
opp1 objOpp1= new opp1(ar);  
lstResult1.add(objOpp1);  
}  
return lstResult1;  
}  
  
class opp1
{  
public Double Tot
{ get;set; } 
public string p
{ get;set; } 
public string p0
{ get;set; }   
  
public opp1(AggregateResult ar)  
{  
Tot = (Double)ar.get('Tot');
p = (string)ar.get('p');
p0 = (string)ar.get('p0');
     }
   
 }
 /* =============================*/
 }
Vf Page :
<apex:page controller="AAA_Cases"  showHeader="false" sidebar="false">
<apex:form>
<!--
<apex:outputpanel id="counter">
<apex:outputText value="Click Me!: {!count}"/>
apex:actionSupport event="onclick"
action="{!incrementCounter}"
rerender="counter" status="counterStatus"/>
<apex:actionStatus id="counterStatus"
startText=" (incrementing...)"
stopText=" (done)"/>
</apex:outputpanel> -->
<html>
<br/><br/> 
<tr> <td >
        <font style="font-size: 20px;" color="#000000" face="Calibri"><b>Open Case</b></font></td></tr> 
        <br/> <br/>
<table border='1' cellpadding='0' cellspacing='0'>
<td width='100px'> </td>
<apex:repeat value="{!States}" var="doc">
      
      <td width='100px' align = 'Center'>{!doc}</td>
        </apex:repeat>
           <apex:repeat value="{!State1}" var="time">
    <tr>
     
         <td width='100px'><b><center>{!time}  </center></b></td> 
             <apex:repeat value="{!States}" var="doc">
           
          
         <td width='150px'>
<table>
             <apex:repeat value="{!result}" var="app"> 
              
             <apex:outputPanel rendered="{!IF((app.p1=doc) && (app.p2 = time),true,false)}"><center>{!floor(app.tot1)}</center>
              
         <!--  
<apex:outputpanel id="counter">
<apex:outputText value="Calc!: {!count}"/>
</apex:outputpanel>
 
     
    <tr>
          <td width='100px' align = 'center'>{!floor(app.tot1)}
         </td>
    </tr>
            -->
                   
             </apex:outputPanel> 
  
             </apex:repeat> 
</table>
        </td>
            </apex:repeat>
    </tr>
            </apex:repeat>
</table>
<!-- ------------------------------------------  Closed Cases --------------------------------------- -->
<br/><br/> 
<tr> <td >
        <font style="font-size: 20px;" color="#000000" face="Calibri"><b>Closed Case</b></font></td></tr> 
        <br/> <br/>
<table border='1' cellpadding='0' cellspacing='0'>
<td width='100px'>  </td>
<apex:repeat value="{!States}" var="doc">
     <td width='100px' align = 'center'>{!doc}</td>
        </apex:repeat>
        
           <apex:repeat value="{!State1}" var="time">
    <tr>
     
         <td width='100px'><b><center>{!time}  </center></b></td> 
             <apex:repeat value="{!States}" var="doc">
          
         <td width='150px'>
<table>
             <apex:repeat value="{!result1}" var="ap"> 
              
             <apex:outputPanel rendered="{!IF((ap.p=doc) && (ap.p0 = time) ,true,false)}"><center>{!floor(ap.tot)}</center>
             <!--
           
    <tr>
          <td width='100px' align = 'center'>{!floor(ap.tot)}
         </td>
    </tr>
            -->
            
                   
             </apex:outputPanel> 
  
             </apex:repeat> 
</table>
        </td>
            </apex:repeat>
    </tr>
            </apex:repeat>
</table>
 
 
</html>
</apex:form>
</apex:page>

HI

i am getting problem went i am sending e mail directly by using onclick function , 

I wrote Apex class for that . But i am getting error as " Email could not be sent. Email address may not be set or may be invalid ".

 

I am posting my controller here ,

 

global class SendAccountAsEmail
{
   
    static String SUBJECT = 'Prospect- Counselling Note';
    static String ERROR_MSG = 'Error Sending Email.<br/>Check validity of email addresses.';
    static String SUCCESS_MSG = 'Mail Successfully Sent.<br/>You can close the window.';
     
     webservice static String sendMail(Id recordId)
     {   
        Blob pdfAttachment;
        String Content_To_Send;         
        Account controller = [Select id,name,Last_Purchaser_Email__c from account where Id = :recordId];
        Content_To_Send= 'Please Find Attached Counselling Note For '+controller.ID +' ' +controller.Name;
        try
        {
      
            
            Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage();
            List<Messaging.EmailFileAttachment> attachList = new List<Messaging.EmailFileAttachment>();
            if(!Test.isRunningTest())
            {
                Messaging.EmailFileAttachment attachPdf = new Messaging.EmailFileAttachment();
                attachPdf.setBody(pdfAttachment);    
                attachPdf.setFileName('test.pdf');
                attachList.add(attachPdf);
                mail.setFileAttachments(attachList);  
            } 
         
             List<String> toAddresses = new List<String>();
           
                toAddresses.add('swathibhouni@gmail.com') 
            mail.setToAddresses(toAddresses);
            mail.setSubject(SUBJECT);
            mail.setHtmlBody(Content_To_Send);
            mail.setSenderDisplayName('Salesforce Support');
            Messaging.sendEmail(new Messaging.SingleEmailMessage[] { mail });
            return '1';
        }
        catch(Exception e)
        {
            System.Debug('Exception : ' + e.getMessage());
            return '0';
        }
    }
}
Can any one help on this issue .

Thanks in advance .. 
  • September 27, 2011
  • Like
  • 0

hi to one & all ,

I have a small problem that i have to get usertype picklist vales in USER Object , But i am un able to take that values .


Can any one give suggestion , It may help to me alot ..

 

 

Thank q in advance  

  • September 14, 2011
  • Like
  • 0

HI,

I am trying to sort my points by Date . 

<td><apex:outputText value=" {!opp.Points_Transaction_Date__c}"> </apex:outputText></td> 

Can any help on this ....

 

 

Here i am Posting My Code,

 

 

 

<messaging:emailTemplate subject="HI Account to Points" 
recipientType="User" 
relatedToType="Account">

<messaging:htmlEmailBody >
<html>
<body>
<p>
 <font style="font-size: 13px;" color="#000000" face="Calibri"> 
Dear <b>{!relatedTo.Last_Purchaser_Name__c} </b> at <b>{!relatedTo.Name} </b><br/><br/>
Thank you for recent purchase.<br/><br/>

You now have available SimStore Points to purchase valuable educational content. <b>Select from thousands of clinically relevant scenarios, trends, handlers, and images.</b> <br/><br/>
<b>Your Institution’s Points Balance is: 
<apex:outputText value="{0, number, ###,###,###,##0.00}">    <apex:param value="{!relatedTo.Points_Balance__c}"/>
</apex:outputText>
&nbsp; &nbsp;</b>  <br/><br/>
<b>Please save this e-mail as a record of your SimStore Points balance for future orders.</b><br/> <br/>
To use your SimStore points, follow the process below:<br/><br/>
•     Log into your SimStore account at www.mysimcenter.com/store <br/><br/>
•     Add products to your cart.<br/><br/>
•     Click “checkout” to proceed to the checkout screen.<br/><br/>
•     At the payment screen, select the “Points” payment option.<br/><br/>
•     Click “Purchase” and you will have immediate access to your SimStore content.<br/><br/>

If your order exceeds your current SimStore points balance, you will be invoiced for the difference.<br/><br/>
If your order is below your current SimStore point balance, you will receive an e-mail notification of your remaining Points balance.<br/><br/>
Sincerely,<br/>
Your SimCenter Team<br/>
 </font></p>
 <table border = '1' width="100%" cellpadding="0" cellspacing="0"> 
  <tr>
<td colspan = '4'>
<Left><b> Current Saved Point  </b></Left></td>
</tr>
  <tr>
 <td>Date</td>
<td>Reason</td>
<td>Amount</td>
<td>Currency</td>
  </tr>
  <tr>
 <td><apex:outputText value=" {!relatedTo.Point_Date__c}"/> </td>
<td>{!relatedTo.Point_Reason__c}</td>
<td>{!relatedTo.Points_Amount__c}</td>
<td>{!relatedTo.Last_Purchaser_Name__c}</td>
  </tr>
  
  </table><br/><br/>
  <table border = '1' width="100%" cellpadding="0" cellspacing="0"> 
<tr>
<td colspan = '4'>
<Left><b> Transaction History </b></Left></td>
</tr>
<tr>
 <td>Date</td>  
 <td>Reason</td>
<td>Amount</td>
<td>Currency</td>
</tr>

 
<apex:repeat var="opp" value="{!relatedTo.points__r}" >
<tr>
    <td><apex:outputText value=" {!opp.Points_Transaction_Date__c}"> </apex:outputText></td>  
    <td>{!opp.Points_Transaction_Reason__c}</td>
    <td><apex:outputText value="{0, number, ###,###,###,##0.00}"><apex:param value="{!opp.Points_Transaction_Amount__c}"/></apex:outputText></td>
    <td>{!opp.Points_Transaction_Comment__c} </td>
</tr>
 </apex:repeat>
 </table>
 </body>
 </html>
</messaging:htmlEmailBody>
</messaging:emailTemplate>

 



  • September 09, 2011
  • Like
  • 0

 

can any one help on this ..

HI,

I have stuck in one small issue

that is i wrote visualforce email template in it data is taken directly from database with out any sorting format . 

 

Now i want to sort it and display it , i want to sort date field.

  • September 08, 2011
  • Like
  • 0

can any one help on this ..

HI,

I have stuck in one small issue

that is i wrote visualforce email template in it data is taken directly from database with out any sorting format . 

 

Now i want to sort it and display it , i want to sort date field.

 

  • September 08, 2011
  • Like
  • 0

HI,

I have stuck in one small issue

that is i wrote visualforce email template in it data is taken directly from database with out any sorting format . 

 

Now i want to sort it and display it , i want to sort date field.

 

can any one help on this ..

  • September 07, 2011
  • Like
  • 0

Error: System.DmlException: Insert failed. First exception on row 0; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, trgCaptureConsultants: execution of BeforeInsert caused by: System.QueryException: Non-selective query against large object type (more than 100000 rows). Consider an indexed filter or contact salesforce.com about custom indexing. Even if a field is indexed a filter might still not be selective when: 1. The filter value includes null (for instance binding with a list that contains null) 2. Data skew exists whereby the number of matching rows is very large (for instance, filtering for a particular foreign key value that occurs many times) Trigger.trgCaptureConsultants: line 97, column 1: [] (System Code)

We have an approval process that has 4 steps of approval.  Can the system fire a validation rule in between approval steps. For example, Rep A approves in step 1.  In step 2, Rep B needs to fill in some fields before approving.  How can I alert Rep B in step 2 that he needs to fill out a field before he can successfully approve.

 

Thanks,

John

  • August 22, 2013
  • Like
  • 0

Hi ,

 

I want to Display Images in Customer Portal from Custom object.

  • August 22, 2013
  • Like
  • 0

Hi

 

We have an internal feature to allow our staff to login as a specific Sites portal user. For that we are using the following URL:

 

/servlet/servlet.su?oid=xxx&suportaluserid={!userId}&retURL=%2Fapex%2FdcEdit%3FuserId%3D{!userId}&targetURL=%2Fapex%2Fms_dashboard&suportalid=xxx

 

The URL seems to work just fine except for the targetURL, which seems to be ignored. So, I tried to find any documentation about this feature, but was not able to. Are there any docs about how to use this URL? Is this a supported feature? If so, what is wrong with the targetURL param?

 

Thanks in advance

 

Rodrigo

  • August 13, 2013
  • Like
  • 0

Hi I have a vfPage and it has three command buttons to rerender the three output panels containing textboxes.. and I want to make these textboxes required on the basis of the output panel being selected via the command button selection..

Action region not helping

Hi there,


In our Dev Instance we are generating PDF documents for certain custom objects, and in these pages have images placed in them, they are either accessed by adding in the documents folder, which is set to be accessible to everyone and externally available  too.   And sometimes accessing external images from other websites by adding them in remote settings, and both of the ways work fine.

 

However  in our  test instance the image appears to be broken.

 

The image URL is passed as string from the controller to the VF page:

 

<apex:image url="{!Logo_URL}" width="25%"/>



Im not sure how to handle this.

 

Any work around is greatly appreciated.

 

Regards and thanks in advance

S.AJ

  • March 18, 2013
  • Like
  • 0

Validation Rule: Once a quote is generated, lock the field Amount

 

 

  • March 16, 2013
  • Like
  • 0

Hi, 

 

    I'm working on email templates recent days, and I encounted a problem that I can't import css in a Visualforce Email Template.

 

    The strange thing is that even I paste the code in this article the css code still takes no effect.

http://www.salesforce.com/us/developer/docs/pages/Content/pages_email_templates_stylesheets.htm

 

    Is this usage not supported in new version? Or do I miss some details?  Your help would be appreciated, Thanks.

    

<html>
			<style type="text/css">
			body {font-family: Courier; size: 12pt;}

			table {
			border-width: 5px;
			border-spacing: 5px;
			border-style: dashed;
			border-color: #FF0000;
			background-color: #FFFFFF;
		}

		td {
			border-width: 1px;
			padding: 4px;
			border-style: solid;
			border-color: #000000;
			background-color: #FFEECC;
		}

		th { 
			color: #000000;
			border-width: 1px ;
			padding: 4px ;
			border-style: solid ;
			border-color: #000000;
			background-color: #FFFFF0;
		}
		</style>
		<body>

    

So, if I have a sites page that displays various links (some of which are pages contained in the customer portal) when they click the link they are taken to the generic customer portal login, how do I route it so they get taken to a login page that I create myself?

 

Thanks

I want to have a series of unauthenticated visualforce pages that are displayed via sites, but at a certain point, I want the user to login and authenticate to go any further.

 

When I setup a sites page how do I link to another visualforce page without it being routed to the standard customer portal login? I have created a custom login, but when I change the "Authorization required" page in the sites layout, it still goes to the generic customer portal login.

 

Any help would be appreciated!

Hi ,

 

 

I am using on Rich text Data Type field in PDF.  

 

<apex:outputtext Value="{!Richtextarea__c}" escape="false"/>

 

I am Use this field in Apex:repeat tag

 

While in output data is cutting at last.

 

For ex :

 

I am using on Rich text Data Type field in PDF.    Actual Data what i except as output.

But

I am using on Rich text Data Type field in

PDF. Data is coming like this.

 

Thanks in advance....

 

I currently have a custom object called Mailing List and a child custom object called List Members (Contact). The child object gets its list members via a lookup field that accesses the Contact object. This method only allows me to add one record at a time, which is too time consuming for managing a mailing list.

 

What I'm hoping to do is build a Visualforce page that searches the Contact object with filters, so I can do something like - state a Field from a picklist (eg. Country), an Operator from a picklist (eg. equals) and a Value (eg. Australia) and all contacts that live in Australia are returned and I can add them to my mailing list.

 

Does this sound like the best way to go about it? And can anyone direct me to some useful information on how I'd build the filter fucntionality?

 

Thanks.

Hi,

I have requirment that in visualforce page, i have to create lookup feld that reference to 2 object(User, custom object). I am new to saleforce so i dont know how to add this functionalty in visualforce page. 

please help me

thanks

 

 

 

  • December 15, 2012
  • Like
  • 0

We have created a flow that creates an Opportunity and we want the "finishlocation" of the flow, where they end up when they click "Finish", to be the newly created Opportunity. I know that we will have to create a VF page and controller to pass the OpptyID (once created) back to the VF page and set as the finishlocation, but can't figure out how to do it. Any ideas?