• kkr.dev
  • NEWBIE
  • 174 Points
  • Member since 2011

  • Chatter
    Feed
  • 7
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 35
    Questions
  • 67
    Replies

Hello,

 

I am currently working on setting up a UI in which the leads tab would be in a Tabbed format and would like to know how I can break out the Lead Detail page to have each section ( Lead detail,Address Information. Additional Information) each be its own tab..  I added a snip of the code to give an idea where i am going wrong.. The tab is the created but includes all section of lead detail

 

<apex:tabPanel switchType="client"
                  selectedTab="tabdetails"
                  id="LeadTabPanel">
      <apex:tab label="Details" name="AccDetails"
                id="tabdetails">
         <apex:detail relatedList="false" title="true"/>
      </apex:tab>

 

I want to add the below but doesnt work

 

<apex:tabPanel switchType="client"
                  selectedTab="tabdetails"
                  id="LeadTabPanel">
      <apex:tab label="Details" name="AccDetails"
                id="tabdetails">
         <apex:detail relatedList="false" title="true"/>
      </apex:tab>

 

      
      <apex:tab label="Additional Information" name="AdditionalInformation"
                id="tabAdditionalInformation">
         <apex:detail relatedList="false" title="true"/>
      </apex:tab>
      

 

Thanks!
               

I have a custom related list that I have setup with the APEX page code below. The problem is that the custom related list does not include hyperlinks to the related items. In this case, I have created a custom list that displays opportunities that are associated with the same account as the contact is. The problem is that a user cannot click the associated opportunity and navigate to that page. What do I need to add to get hyper link functionality? Any help is greatly appreciated.

 

<apex:page standardController="Contact" 
extensions="sampleDetailPageCon">
<style>
.fewerMore { display: none;}
</style>
<apex:form > 
 <apex:pageMessages /> 
 <apex:detail relatedList="true"></apex:detail>
 <apex:pageblock id="CustomList" title="Related Opportunities"  >   
     <apex:pageBlockTable value="{!oppz}" var="o" rendered="{!NOT(ISNULL(oppz))}">
             <apex:column value="{!o.Name}"/>        
             <apex:column value="{!o.Account.Name}"/>        
             <apex:column value="{!o.Type}"/>       
             <apex:column value="{!o.Service_MRR__c}"></apex:column>       
             <apex:column value="{!o.CloseDate}"/>   
          </apex:pageBlockTable>   
          <apex:outputLabel value="No records to display" rendered="{!(ISNULL(oppz))}" styleClass="noRowsHeader"></apex:outputLabel> 
      </apex:pageblock>
   </apex:form>
</apex:page>

 

  • December 15, 2011
  • Like
  • 0

Hi All,

 

     I need to sort the records after insertion of all records through data loader.If i go with trigger i need to sort records after each insert.We insert the records only through data loader once in a day not through UI.So what do you think the best approach to do it?Please post some sample code.

 

Thanks

 

 

Hi All,

  

  Soql is giving different results for each profile ?Any Settings that i need to make

 

Thanks

Hi All,

 

    I need to run apex trigger every day.Is there any way to do this without writing the logic in schedule apex ?

 

Thanks

Hi All,

 

 

What i have Done is from GROUP object i retrieved records

List<Group> lstGroup = [select id,Type,Email,OwnerId,DoesSendEmailToMembers fromGroupwhere Type='Queue' and id='1234xxx']

 

Now from GroupMember Object retrived based on GroupID

list<GroupMember> lstGroupMember=[Select Id,UserOrGroupId, Group.NamefromGroupMemberwhere GroupId=:lstGroup [0].id];  

 

Now i need to retrive the user from that group.Any Thoughts

 

Thanks

Hi All,

 

 

What i have Done is from GROUP object i retrieved records

List<Group> lstGroup = [select id,Type,Email,OwnerId,DoesSendEmailToMembers fromGroupwhere Type='Queue' and id='1234xxx']

 

Now from GroupMember Object retrived based on GroupID

list<GroupMember> lstGroupMember=[Select Id,UserOrGroupId, Group.NamefromGroupMemberwhere GroupId=:lstGroup [0].id];  

 

Now i need to retrive the user from that group.Any Thoughts

 

Thanks

Hi All,

 

 Do you have any example of calling apex from list button?

 

Thanks

Hi All,

 

 How to remove the duplicate records from list.Any Idea?

 

Thanks

Hi All,

 

I am overrriding the standard New button on Account with vf page.Its running into infinite loop.

 

<apex:page standardController="Account" extensions="newvsold" action="{!pageredir}">

</apex:page>

 

public class newvsold
{

public newvsold(ApexPages.StandardController controller)
{

}
public Pagereference pageredir()
{
    Pagereference newpage = new Pagereference ('/001/e?acc2=test&retURL=/001/');
    return newpage;
}
}

 

 

Any thoughts?

 

Thanks

Hi All,

 

    Web 2 Case record refreshes infinitely. Any Thoughts?

 

Thanks

 

 

FATAL_ERROR|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 InsertFin  on Case (after insert) {
 list<Fin__c> falist = new list<Fin__c>();
 
  if ((Trigger.new.size() == 1)&&(trigger.new[0].MID__c !=null)){
      list<Contact> con = new list<Contact>([Select  c.EmpId__c,c.branch__c,c.branch__r.name,c.Id,c.name From Contact c where c.EmpId__c!=null and c.EmpId__c =: trigger.new[0].MID__c limit 1]);
      Fin__c f1 = new Fin__c();
        f1.Case__c = trigger.new[0].Id;
        if(con.size()>0){
        f1.Branch__c = con[0].branch__r.name;
        f1.name= con[0].name;
        }
        falist.add(f1);
      }
  if ((Trigger.new.size() == 1)&&(trigger.new[0].MID_2__c !=null)){
      list<Contact> con = new list<Contact>([Select  c.EmpId__c,c.branch__c,c.branch__r.name,c.Id,c.name From Contact c where c.EmpId__c!=null and c.EmpId__c =: trigger.new[0].MID_2__c limit 1]);
      Fin__c f2 = new Fin__c();
        f2.Case__c = trigger.new[0].Id;
        if(con.size()>0){
        f2.Branch__c = con[0].branch__r.name;
        f2.name= con[0].name;
        }
        falist.add(f2);
      }
      
  if ((Trigger.new.size() == 1)&&(trigger.new[0].MID_3__c !=null)){
      list<Contact> con = new list<Contact>([Select  c.EmpId__c,c.branch__c,c.branch__r.name,c.Id,c.name From Contact c where c.EmpId__c!=null and c.EmpId__c =: trigger.new[0].MID_3__c limit 1]);
      Fin__c f3 = new Fin__c();
        f3.Case__c = trigger.new[0].Id;
        if(con.size()>0){
        f3.Branch__c = con[0].branch__r.name;
        f3.name= con[0].name;
        }
        falist.add(f3);
      }
      
      if ((Trigger.new.size() == 1)&&(trigger.new[0].MID_4__c !=null)){
      list<Contact> con = new list<Contact>([Select  c.EmpId__c,c.branch__c,c.branch__r.name,c.Id,c.name From Contact c where c.EmpId__c!=null and c.EmpId__c =: trigger.new[0].MID_4__c limit 1]);
      Fin__c f4 = new Fin__c();
        f4.Case__c = trigger.new[0].Id;
        if(con.size()>0){
        f4.Branch__c = con[0].branch__r.name;
        f4.name= con[0].name;
        }
        falist.add(f4);
      }
      if ((Trigger.new.size() == 1)&&(trigger.new[0].MID_5__c !=null)){
      list<Contact> con = new list<Contact>([Select  c.EmpId__c,c.branch__c,c.branch__r.name,c.Id,c.name From Contact c where c.EmpId__c!=null and c.EmpId__c =: trigger.new[0].MID_5__c limit 1]);
      Fin__c f5 = new Fin__c();
        f5.Case__c = trigger.new[0].Id;
        if(con.size()>0){
        f5.Branch__c = con[0].branch__r.name;
        f5.name= con[0].name;
        }
        falist.add(f5);
      }
      insert falist;
      
      
}

How to fix this trigger.Any Idea?

 

 

Thanks


I am getting  this error  System.QueryException: Non-selective query against large object type (more than 100000 rows).  only in production

Here is the query in my trigger.

 

list<Contact> con = new list<Contact>([Select c.Phone, c.EmpID__c, c.Id, c.Email From Contact c where c.EmpID__c!=null and c.EmpID__c =: trigger.new[0].ID__c limit 1])

 

Thanks

 

Hi All,

 

ApexPages.Message myMsg = new ApexPages.Message(ApexPages.Severity.ERROR, 'Please go this link'+www.google.com);

 

I want to have a link to google.com on error message. Any Idea?

 

Thanks

Hi,

       Very few users are getting this Authorization Required error on Sites Page.Any Idea?

 

Thanks

HI All,

 

 I am  getting an error  Maximum trigger depth exceeded .Please help.

 

trigger UpdateContact on Case (before insert,after insert) {
if(Trigger.isBefore){    
 if ((Trigger.new.size() == 1)&&(trigger.new[0].Source_ID__c !=null)){
    list<Contact> con = new list<Contact>([Select c. Employee_ID__c, c.Id, c.Email From Contact c where c.Employee_ID__c =: trigger.new[0].Source_ID__c]);
    if(con.size()>0){
    system.debug('----con[0].Id-------'+con[0].Id);
    trigger.new[0].ContactID = con[0].Id;
    system.debug('-------trigger.new[0].ContactID-------'+trigger.new[0].ContactID);
    }   
  }

}
 
 if(Trigger.isAfter){

   list<Case> clist = new list<Case>();
     for(Case c:trigger.new){
       clist.add(new Case(  Tool__c= c.Tool__c,Source_ID__c= c.Source_ID_2__c,));
     }
     insert clist;
 }
}

Hi,

 

   I am trying to parse wsdl.I am getting above error.Here is the link to wsdl file.http://integration.services.7-5.identifythebest.com/service.asmx?wsdl

 

Thanks

  Is it possible to have look up fields in force.com sites page?

 

Thanks

Hi ,

 

 How to call salesforce from another system.I am working on Integration of other sytem with salesforce.I need to understand what details i need to provide them so that they can talk to salesforce.Any idea? I am very new to integration stuff?

Hi All,

 

     I need to sort the records after insertion of all records through data loader.If i go with trigger i need to sort records after each insert.We insert the records only through data loader once in a day not through UI.So what do you think the best approach to do it?Please post some sample code.

 

Thanks

 

 

Hi All,

  

  Soql is giving different results for each profile ?Any Settings that i need to make

 

Thanks

Hi,

 

I want to access the current time of the Contact based on the location/address. Please suggest some solution to do this.

 

Thanks.

Hi All,

 

    I need to run apex trigger every day.Is there any way to do this without writing the logic in schedule apex ?

 

Thanks

Hi All,

 

 

What i have Done is from GROUP object i retrieved records

List<Group> lstGroup = [select id,Type,Email,OwnerId,DoesSendEmailToMembers fromGroupwhere Type='Queue' and id='1234xxx']

 

Now from GroupMember Object retrived based on GroupID

list<GroupMember> lstGroupMember=[Select Id,UserOrGroupId, Group.NamefromGroupMemberwhere GroupId=:lstGroup [0].id];  

 

Now i need to retrive the user from that group.Any Thoughts

 

Thanks

Hi All,

 

 Do you have any example of calling apex from list button?

 

Thanks

Hi All,

 

 How to remove the duplicate records from list.Any Idea?

 

Thanks

Hello,

I have what I thought would be a simple requirement, namely to automatically approve a record if the assigned approver is a specific user. Unfortunately, the Approval object does not allow for triggers, and I can't find any sample code anywhere to go off of. 

Thanks,

Geoffrey

Hi All,

 

I am overrriding the standard New button on Account with vf page.Its running into infinite loop.

 

<apex:page standardController="Account" extensions="newvsold" action="{!pageredir}">

</apex:page>

 

public class newvsold
{

public newvsold(ApexPages.StandardController controller)
{

}
public Pagereference pageredir()
{
    Pagereference newpage = new Pagereference ('/001/e?acc2=test&retURL=/001/');
    return newpage;
}
}

 

 

Any thoughts?

 

Thanks

Hi there everyone!

I need some help constructing a formula for my "Close Date' field on my opportunities. It seems like a fairly simple concept, however I can not wrap my brain around the right function!

Here is what I would like to do...

If the "Close Date" is changed to "Closed Won" than the value should equal "Today"
If the "Close Date" is changed to "Closed  Lost" than the value should equal "Today"
If the "Close Date" is changed to "Closed Terminated" than the value should equal "Today"
If the stage is not new, or any other stage than the value should not change.

Does anyone have a suggestion for me?

Thanks!

  • January 31, 2012
  • Like
  • 0

FATAL_ERROR|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 InsertFin  on Case (after insert) {
 list<Fin__c> falist = new list<Fin__c>();
 
  if ((Trigger.new.size() == 1)&&(trigger.new[0].MID__c !=null)){
      list<Contact> con = new list<Contact>([Select  c.EmpId__c,c.branch__c,c.branch__r.name,c.Id,c.name From Contact c where c.EmpId__c!=null and c.EmpId__c =: trigger.new[0].MID__c limit 1]);
      Fin__c f1 = new Fin__c();
        f1.Case__c = trigger.new[0].Id;
        if(con.size()>0){
        f1.Branch__c = con[0].branch__r.name;
        f1.name= con[0].name;
        }
        falist.add(f1);
      }
  if ((Trigger.new.size() == 1)&&(trigger.new[0].MID_2__c !=null)){
      list<Contact> con = new list<Contact>([Select  c.EmpId__c,c.branch__c,c.branch__r.name,c.Id,c.name From Contact c where c.EmpId__c!=null and c.EmpId__c =: trigger.new[0].MID_2__c limit 1]);
      Fin__c f2 = new Fin__c();
        f2.Case__c = trigger.new[0].Id;
        if(con.size()>0){
        f2.Branch__c = con[0].branch__r.name;
        f2.name= con[0].name;
        }
        falist.add(f2);
      }
      
  if ((Trigger.new.size() == 1)&&(trigger.new[0].MID_3__c !=null)){
      list<Contact> con = new list<Contact>([Select  c.EmpId__c,c.branch__c,c.branch__r.name,c.Id,c.name From Contact c where c.EmpId__c!=null and c.EmpId__c =: trigger.new[0].MID_3__c limit 1]);
      Fin__c f3 = new Fin__c();
        f3.Case__c = trigger.new[0].Id;
        if(con.size()>0){
        f3.Branch__c = con[0].branch__r.name;
        f3.name= con[0].name;
        }
        falist.add(f3);
      }
      
      if ((Trigger.new.size() == 1)&&(trigger.new[0].MID_4__c !=null)){
      list<Contact> con = new list<Contact>([Select  c.EmpId__c,c.branch__c,c.branch__r.name,c.Id,c.name From Contact c where c.EmpId__c!=null and c.EmpId__c =: trigger.new[0].MID_4__c limit 1]);
      Fin__c f4 = new Fin__c();
        f4.Case__c = trigger.new[0].Id;
        if(con.size()>0){
        f4.Branch__c = con[0].branch__r.name;
        f4.name= con[0].name;
        }
        falist.add(f4);
      }
      if ((Trigger.new.size() == 1)&&(trigger.new[0].MID_5__c !=null)){
      list<Contact> con = new list<Contact>([Select  c.EmpId__c,c.branch__c,c.branch__r.name,c.Id,c.name From Contact c where c.EmpId__c!=null and c.EmpId__c =: trigger.new[0].MID_5__c limit 1]);
      Fin__c f5 = new Fin__c();
        f5.Case__c = trigger.new[0].Id;
        if(con.size()>0){
        f5.Branch__c = con[0].branch__r.name;
        f5.name= con[0].name;
        }
        falist.add(f5);
      }
      insert falist;
      
      
}

How to fix this trigger.Any Idea?

 

 

Thanks


Hi All,

 

ApexPages.Message myMsg = new ApexPages.Message(ApexPages.Severity.ERROR, 'Please go this link'+www.google.com);

 

I want to have a link to google.com on error message. Any Idea?

 

Thanks

Salesforce Developer

Posting Job Description            

About Patch

Communities use Patch every day to make navigating local life easier and more informed. We provide the neighborhood news and information you must know; the best things to do; ways to buy, sell and save money; and a platform to connect and share with your neighbors. And we need your help.

 

Area: Sales Operations

Patch Sales Operations is a talented, cross-functional and growing team, with a passion for strategy, metrics, and process improvement, dedicated to strengthening our overall revenue operations. Our work spans six primary functions: sales operations and optimization, accounts services, advertising operations, sales training, sales marketing, and all sales systems engineering and product development. We work daily with sales executives and managers, as well as engineering when launching all new revenue products and initiatives.

 

Salesforce Developer

As a Salesforce Developer, you will be part of a collaborative project team responsible for successfully implementing, customizing and integrating Salesforce with other systems. You will leverage a number of proprietary and standard technologies/

 

    •    Salesforce.com Salesforce Automation

    •    Salesforce.com Force.com platform development

    •    Java/Web development and the software development methodology/lifecycle

    •    Apex development

 

 

In this role you will:

Focus on solution design, development and data migration / load activities. With supervision as required from a Lead Developer or Manager, provide technical expertise in design, development, testing and debugging.

Work with team members as needed to scope, design, develop, test and refine customized Salesforce solutions, while working closely with a Project Manager to escalate any out-of-scope items and project delays.

 

Job Requirements

In order to qualify you must have the following essential qualities and experiences:

•    Experience and education in the following areas is preferred: Computer Science, Computer   Engineering, Software Engineering or equivalent training/experience

    •    1-2 years of experience with custom development

    •    Solid foundation in object-oriented methodologies, relational databases and data modeling

    •    Experience deploying enterprise software systems using industry standard environments including XML, HTTP/HTTPS, Java, Flex, ASP, JavaScript and Web Services (including SOAP, XML, XML Schema, JSON, open APIs and/or REST)

    •    Knowledge of enterprise systems including CRM, SFA, and ERP

    •    A good understanding of XML, SQL, and enterprise application integration

    •    Technical acumen to translate requirements into detailed, modular and extensible designs

    •    A customer advocate with excellent listening skills to fully understand customer requirements and pain points

    •    Proven presentation and communication skills

    •    Strong analytical skills and the ability to meet tight deadlines

    •    Ability to work in a fast-paced environment, both independently and in a team

    •    Autonomy in the overall development lifecycle (Business Process design, documentation, testing strategy and execution, troubleshooting analysis)

It would be an added bonus if you also had the following:

    •    Exposure to Salesforce.com configuration and custom development, knowledge of Salesforce.com platform, Visual force, Apex triggers, Flex, SOQL, Controllers, Triggers, Force.com IDE, Migration Tool (Data Loader, Excel Connector) and Web Services.

    •    Experience with enterprise integration tools and extract, transformation and load (ETL) tools (Talend, Scribe, Pervasive, DBsync, etc)

    •    Experience with other CRM software (Siebel, Clarify, Vantive, Peoplesoft, NetSuite, CRM Dynamics, etc.)

    •    Experience with Agile development methodologies

    •    Work experience with a professional consulting organization

    •    Salesforce.com Certifications (Admin, Consultant, and/or Developer), specifically DEV401 and DEV501

    •    Experience with Accounting Packages (QuickBooks, Microsoft Great Plains)

 

Join Our Team !! Email your resume to  johnb@patch.com   

Hi All,

 

     Any Idea of how to create pagination in custom related list.Here is my page and class. I need to display 5 oppty records.If there are more than 5 records then i need to show a link  Show More link which goes to next page and displays all records like below.

 



 

 

<apex:page standardController="Contact" extensions="sampleDetailPageCon">
<style>
.fewerMore { display: none;}
</style>
<apex:form >
 <apex:pageMessages />
 <apex:detail relatedList="false"></apex:detail>
<apex:pageblock id="CustomList" title="Related Opportunities"  >
   <apex:pageBlockTable value="{!oppz}" var="o" rendered="{!NOT(ISNULL(oppz))}">
        <apex:column value="{!o.Name}"/>
        <apex:column value="{!o.Account.Name}"/>
        <apex:column value="{!o.Type}"/>
       <apex:column value="{!o.Amount}"></apex:column>
       <apex:column value="{!o.CloseDate}"/>
   </apex:pageBlockTable>
   <apex:outputLabel value="No records to display" rendered="{!(ISNULL(oppz))}" styleClass="noRowsHeader"></apex:outputLabel>
 </apex:pageblock>
</apex:form>
</apex:page>

 

 

 

public class sampleDetailPageCon {
    private List<Opportunity> oppz;
    private Contact cntact;
    public sampleDetailPageCon(ApexPages.StandardController controller) {
        this.cntact= (Contact)controller.getRecord();
    }
    public List<Opportunity> getOppz()
    {
        Contact con = [Select id, Account.id FROM Contact where id = :cntact.id];
        if (con.Account == null)
         return null;
        oppz = [Select id, Name, Account.Name, CloseDate, Amount, Type from Opportunity where Account.id = :con.Account.id];
        return oppz;
    }
}

 

Thanks