Salesforce Developer Community

Rahul Borgaonkar
NEWBIE
145 Points
Member since 2012

Chatter

Feed
3

Best Answers
7

Likes Received
0

Likes Given
33

Questions
86

Replies

Community licenses for Developer Org

I am trying to develop something for our production Customer Community in a Developer org. I need Customer Community licenses for testing. How do I get them?

jsymonds24
April 07, 2015
Like
0

SOLVED

5 replies

Too many SOQL queries: 101

Hi I'm having the error on my trigger

CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY:CreateOppForNewSubTriggger: System.LimitException: Too many SOQL queries: 101:--

The trigger is

trigger ZuoraModoProductUpdate on Zuora__SubscriptionProductCharge__c (before insert, before update) {

    Set<Id> zsub_ids = new Set<Id>();
    for(Zuora__SubscriptionProductCharge__c zspc: trigger.new)
    {
        zsub_ids.add(zspc.Zuora__Subscription__c);
    }
    
    List<Zuora__Subscription__c> zsubs = [SELECT Id, Opportunity__c FROM Zuora__Subscription__c WHERE Id IN :zsub_ids];
    
    Map<Id, Zuora__Subscription__c> id_zsubs = new Map<Id, Zuora__Subscription__c>();
    Set<Id> opp_ids = new Set<Id>();
    for(Zuora__Subscription__c zsub : zsubs)
    {
        id_zsubs.put(zsub.Id, zsub);
        opp_ids.add(zsub.Opportunity__c);
    }
    
    List<Opportunity> opps = [SELECT Id, Modo_Web__c FROM Opportunity WHERE Id IN :opp_ids];
    
    Map<Id, Opportunity> id_opps = new Map<Id, Opportunity>();
    for(Opportunity opp : opps)
    {
        id_opps.put(opp.Id, opp);
    }
    
    List<Opportunity> update_opps = new List<Opportunity>();

    for(Zuora__SubscriptionProductCharge__c zspc: trigger.new)
    {
        if(zspc.Zuora__ProductName__c != null && zspc.Zuora__ProductName__c.toLowerCase().contains('modo')) 
        {
            if(zspc.Zuora__Subscription__c != null)
            {
                Zuora__Subscription__c zsub = id_zsubs.get(zspc.Zuora__Subscription__c);
                if(zsub.Opportunity__c != null)
                {
                    Opportunity opp = id_opps.get(zsub.Opportunity__c);
                    opp.Modo_Web__c = true;
                    update_opps.add(opp);
                }
            }
        }
    }
    update update_opps;
}

I believe it's something in the for loop but I can't finde where if someone could give me a light it will be much appreciated.

Thanks in advance.

Olver_Bassov
April 01, 2015
Like
0

SOLVED

3 replies

I need To show google maps into the vf page in which it auto matically detects yhe country and state by detecting clients adress city and pincode It should also shows customer location

I have written the following code Kindly help me in this

<apex:page>
<apex:page standardController="Customer_Information__c">
<apex:pageBlock >
<head>

<script type="text/javascript" src="http://maps.google.com/maps/api/js?sensor=false"></script>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js"></script>
<script type="text/javascript">

$(document).ready(function() {

var myOptions = {
    zoom: 20,
    mapTypeId: google.maps.MapTypeId.HYBRID,
    mapTypeControl: true
}

var map;
var marker;

var geocoder = new google.maps.Geocoder();
var address = "{!Customer_Information__c.Address_Line__c}, " + "{!Customer_Information__c.City__c}, ";

var infowindow = new google.maps.InfoWindow({
    content: "<b>{!Customer_Information__c.Name}</b>"
});

geocoder.geocode( { address: address}, function(results, status) {
    if (status == google.maps.GeocoderStatus.OK && results.length) {
      if (status != google.maps.GeocoderStatus.ZERO_RESULTS) {

        //create map
        map = new google.maps.Map(document.getElementById("map"), myOptions);

        //center map
        map.setCenter(results[0].geometry.location);

        //create marker
        marker = new google.maps.Marker({
            position: results[0].geometry.location,
            map: map,
            title: "{!Customer_Information__c.Name}"
        });

        //add listeners
        google.maps.event.addListener(marker, 'click', function() {
          infowindow.open(map,marker);
        });
        google.maps.event.addListener(infowindow, 'closeclick', function() {
          map.setCenter(marker.getPosition());
        });

      }

    } else {
      $('#map').css({'height' : '15px'});
      $('#map').html("Oops! {!Customer_Information__c.Name}'s address could not be found, please make sure the address is correct.");
      resizeIframe();
    }
});

function resizeIframe() {
    var me = window.name;
    if (me) {
      var iframes = parent.document.getElementsByName(me);
      if (iframes && iframes.length == 1) {
        height = document.body.offsetHeight;
        iframes[0].style.height = height + "px";
      }
    }
}

});
</script>

<style>
#map {
font-family: Arial;
font-size:12px;
line-height:normal !important;
height:500px;
background:transparent;
}
</style>

</head>

<body>
<div id="map"></div>
</body>
</apex:pageBlock>
</apex:page>

Harshad Kokate 13
December 07, 2014
Like
0

2 replies

Running soql in developer console -> query editor and in workbench

Hi,
I am trying to run a query below from developer documentation

SELECT Amount, FORMAT(amount) Amt, convertCurrency(amount) convertedAmount, FORMAT(convertCurrency(amount)) convertedCurrency FROM Opportunity where id = '0069000000va8SS'

When I am running this query from developer console -> query editor I am getting only first column (Amount) as result. And not other columns are showing.

but when I run same query from Workbench it is showing correct results.

User-added image

Could you please let me know what could be reason?

Best Regards,

Rahul

Rahul Borgaonkar
December 09, 2017
Like
0

3 replies

Challenge not found at the end of module

Hi,

I am on Trail head > Admin Beginner > Lightning Experience Customization > Create and Customize List Views module. I am not able to see Challenge at the end of the page. Could you please help.

Thanks,
Rahul

Rahul Borgaonkar
November 05, 2017
Like
4

1 replies

Error - Apex type not found for element http://www.w3.org/2001/XMLSchema=schema

Hi All,

I have converted external system WSDL to a class on our SF sandbox. The part of class is as below

public class PorticoCallOuts {

    public class QUBA_SF_SearchAccountResponse_element {
        public PorticoCallOuts.QUBA_SF_SearchAccountResult_element QUBA_SF_SearchAccountResult;
        private String[] QUBA_SF_SearchAccountResult_type_info = new String[]{'QUBA_SF_SearchAccountResult','http://tempuri.org/',null,'0','1','false'};
        private String[] apex_schema_type_info = new String[]{'http://tempuri.org/','true','true'};
        private String[] field_order_type_info = new String[]{'QUBA_SF_SearchAccountResult'};
    }
    public class QUBA_SF_SearchAccount_element {
        public String accountID;
        public String accountName;
        public String PostCode;
        private String[] accountID_type_info = new String[]{'accountID','http://tempuri.org/',null,'0','1','false'};
        private String[] accountName_type_info = new String[]{'accountName','http://tempuri.org/',null,'0','1','false'};
        private String[] PostCode_type_info = new String[]{'PostCode','http://tempuri.org/',null,'0','1','false'};
        private String[] apex_schema_type_info = new String[]{'http://tempuri.org/','true','true'};
        private String[] field_order_type_info = new String[]{'accountID','accountName','PostCode'};
    }
    public class QUBA_SF_SearchAccountResult_element {
        public String namespace;
        public String tableTypeName;
        private String[] namespace_att_info = new String[]{'namespace'};
        private String[] tableTypeName_att_info = new String[]{'tableTypeName'};
        private String[] apex_schema_type_info = new String[]{'http://tempuri.org/','false','false'};
        private String[] field_order_type_info = new String[]{};
    }

    public class QubaCentre_element {
        public String CentreID;
        public String Name;
        public String Address_1;
        public String Address_2;
        public String Address_3;
        public String Address_4;
        public String Address_5;
        public String Postcode;
        private String[] CentreID_type_info = new String[]{'CentreID','http://tempuri.org/',null,'0','1','false'};
        private String[] Name_type_info = new String[]{'Name','http://tempuri.org/',null,'0','1','false'};
        private String[] Address_1_type_info = new String[]{'Address_1','http://tempuri.org/',null,'0','1','false'};
        private String[] Address_2_type_info = new String[]{'Address_2','http://tempuri.org/',null,'0','1','false'};
        private String[] Address_3_type_info = new String[]{'Address_3','http://tempuri.org/',null,'0','1','false'};
        private String[] Address_4_type_info = new String[]{'Address_4','http://tempuri.org/',null,'0','1','false'};
        private String[] Address_5_type_info = new String[]{'Address_5','http://tempuri.org/',null,'0','1','false'};
        private String[] Postcode_type_info = new String[]{'Postcode','http://tempuri.org/',null,'0','1','false'};
        private String[] apex_schema_type_info = new String[]{'http://tempuri.org/','true','true'};
        private String[] field_order_type_info = new String[]{'CentreID','Name','Address_1','Address_2','Address_3','Address_4','Address_5','Postcode'};
    }
    public class QubaSfV1_element {
        public PorticoCallOuts.QubaCentre_element QubaCentre;
        public PorticoCallOuts.QubaAccountCreateOrUpdateResult_element QubaAccountCreateOrUpdateResult;
        public PorticoCallOuts.QubaContactCreateOrUpdateResult_element QubaContactCreateOrUpdateResult;
        public PorticoCallOuts.QubaContact_element QubaContact;
        public PorticoCallOuts.QubaApprovalCreateOrUpdateResult_element QubaApprovalCreateOrUpdateResult;
        public PorticoCallOuts.QubaUpdateCreditBalanceResult_element QubaUpdateCreditBalanceResult;
        private String[] QubaCentre_type_info = new String[]{'QubaCentre','http://tempuri.org/',null,'1','1','false'};
        private String[] QubaAccountCreateOrUpdateResult_type_info = new String[]{'QubaAccountCreateOrUpdateResult','http://tempuri.org/',null,'1','1','false'};
        private String[] QubaContactCreateOrUpdateResult_type_info = new String[]{'QubaContactCreateOrUpdateResult','http://tempuri.org/',null,'1','1','false'};
        private String[] QubaContact_type_info = new String[]{'QubaContact','http://tempuri.org/',null,'1','1','false'};
        private String[] QubaApprovalCreateOrUpdateResult_type_info = new String[]{'QubaApprovalCreateOrUpdateResult','http://tempuri.org/',null,'1','1','false'};
        private String[] QubaUpdateCreditBalanceResult_type_info = new String[]{'QubaUpdateCreditBalanceResult','http://tempuri.org/',null,'1','1','false'};
        private String[] apex_schema_type_info = new String[]{'http://tempuri.org/','true','true'};
        private String[] field_order_type_info = new String[]{'QubaCentre','QubaAccountCreateOrUpdateResult','QubaContactCreateOrUpdateResult','QubaContact','QubaApprovalCreateOrUpdateResult','QubaUpdateCreditBalanceResult'};
    }
    public class QubaAccountCreateOrUpdateResult_element {
        public String Success;
        public String Quartz_AccountID;
        public String AccountID;
        public String ErrorMessage;
        private String[] Success_type_info = new String[]{'Success','http://tempuri.org/',null,'0','1','false'};
        private String[] Quartz_AccountID_type_info = new String[]{'Quartz_AccountID','http://tempuri.org/',null,'0','1','false'};
        private String[] AccountID_type_info = new String[]{'AccountID','http://tempuri.org/',null,'0','1','false'};
        private String[] ErrorMessage_type_info = new String[]{'ErrorMessage','http://tempuri.org/',null,'0','1','false'};
        private String[] apex_schema_type_info = new String[]{'http://tempuri.org/','true','true'};
        private String[] field_order_type_info = new String[]{'Success','Quartz_AccountID','AccountID','ErrorMessage'};
    }
    public class WSQUBA_SF_V1Soap {
        public String endpoint_x = 'http://qh02ws.quartz-system.com/QuartzWSExtra/BritSafe_ST/WSQUBA_SF_V1.asmx';
        public Map<String,String> inputHttpHeaders_x;
        public Map<String,String> outputHttpHeaders_x;
        public String clientCertName_x;
        public String clientCert_x;
        public String clientCertPasswd_x;
        public Integer timeout_x;
        private String[] ns_map_type_info = new String[]{'http://tempuri.org/', 'PorticoCallOuts'};

        public PorticoCallOuts.QUBA_SF_SearchAccountResult_element QUBA_SF_SearchAccount(String accountID,String accountName,String PostCode) {
            PorticoCallOuts.QUBA_SF_SearchAccount_element request_x = new PorticoCallOuts.QUBA_SF_SearchAccount_element();
            request_x.accountID = accountID;
            request_x.accountName = accountName;
            request_x.PostCode = PostCode;
            PorticoCallOuts.QUBA_SF_SearchAccountResponse_element response_x;
            Map<String, PorticoCallOuts.QUBA_SF_SearchAccountResponse_element> response_map_x = new Map<String, PorticoCallOuts.QUBA_SF_SearchAccountResponse_element>();
            response_map_x.put('response_x', response_x);
            WebServiceCallout.invoke(
              this,
              request_x,
              response_map_x,
              new String[]{endpoint_x,
              'http://tempuri.org/QUBA_SF_SearchAccount',
              'http://tempuri.org/',
              'QUBA_SF_SearchAccount',
              'http://tempuri.org/',
              'QUBA_SF_SearchAccountResponse',
              'PorticoCallOuts.QUBA_SF_SearchAccountResponse_element'}
            );
            response_x = response_map_x.get('response_x');
            return response_x.QUBA_SF_SearchAccountResult;
        }
    }
}

While executing QUBA_SF_SearchAccount(String accountID,String accountName,String PostCode) function I am getting error below
Web service callout failed: Unable to parse callout response. Apex type not found for element http://www.w3.org/2001/XMLSchema=schema

The return xml generated from SoapUI is

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
   <soap:Body>
      <QUBA_SF_SearchAccountResponse xmlns="http://tempuri.org/">
         <QUBA_SF_SearchAccountResult>
            <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
               <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:MainDataTable="QubaCentre" msdata:UseCurrentLocale="true">
                  <xs:complexType>
                     <xs:choice minOccurs="0" maxOccurs="unbounded">
                        <xs:element name="QubaCentre">
                           <xs:complexType>
                              <xs:sequence>
                                 <xs:element name="CentreID" msdata:Caption="ID" type="xs:string" minOccurs="0"/>
                                 <xs:element name="Name" type="xs:string" minOccurs="0"/>
                                 <xs:element name="Address_1" type="xs:string" minOccurs="0"/>
                                 <xs:element name="Address_2" type="xs:string" minOccurs="0"/>
                                 <xs:element name="Address_3" type="xs:string" minOccurs="0"/>
                                 <xs:element name="Address_4" type="xs:string" minOccurs="0"/>
                                 <xs:element name="Address_5" type="xs:string" minOccurs="0"/>
                                 <xs:element name="Postcode" type="xs:string" minOccurs="0"/>
                              </xs:sequence>
                           </xs:complexType>
                        </xs:element>
                     </xs:choice>
                  </xs:complexType>
               </xs:element>
            </xs:schema>
            <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
               <DocumentElement xmlns="">
                  <QubaCentre diffgr:id="QubaCentre1" msdata:rowOrder="0" diffgr:hasChanges="inserted">
                     <CentreID>1</CentreID>
                     <Name>Test Centre</Name>
                     <Address_1>123 Street Name</Address_1>
                     <Address_2>City name</Address_2>
                     <Address_3/>
                     <Address_4/>
                     <Address_5/>
                     <Postcode>GU23 6AE</Postcode>
                  </QubaCentre>
               </DocumentElement>
            </diffgr:diffgram>
         </QUBA_SF_SearchAccountResult>
      </QUBA_SF_SearchAccountResponse>
   </soap:Body>
</soap:Envelope>

Could I kindly request you to find exact issue with this? I guess it is something with schema element from return xml but not able to find exact problem.

Please help.

Best Regards,

Rahul

Rahul Borgaonkar
March 14, 2017
Like
0

2 replies

URL for WSDL to external System

Hi,

This is my first intergration project where webservice class developed by me will be used by external system.

I have created a webservice class on sandbox. The functions from this class will be used by external system. I have created a user so that they will have access to sandbox and can easily access webservice class function. WSDL generated is as below

<!--
 Web Services API : QuartzWS
-->
<definitions targetNamespace="http://soap.sforce.com/schemas/class/QuartzWS">
    <types>
        <xsd:schema elementFormDefault="qualified" targetNamespace="http://soap.sforce.com/schemas/class/QuartzWS">
            <xsd:element name="AllowFieldTruncationHeader">
                <xsd:complexType>
                    <xsd:sequence>
                        <xsd:element name="allowFieldTruncation" type="xsd:boolean"/>
                    </xsd:sequence>
                </xsd:complexType>
            </xsd:element>
            <xsd:element name="CallOptions">
                <xsd:complexType>
                    <xsd:sequence>
                        <xsd:element name="client" type="xsd:string"/>
                    </xsd:sequence>
                </xsd:complexType>
            </xsd:element>
            <xsd:element name="DebuggingHeader">
                <xsd:complexType>
                    <xsd:sequence>
                        <xsd:element name="categories" minOccurs="0" maxOccurs="unbounded" type="tns:LogInfo"/>
                        <xsd:element name="debugLevel" type="tns:LogType"/>
                    </xsd:sequence>
                </xsd:complexType>
            </xsd:element>
            <xsd:complexType name="LogInfo">
                <xsd:sequence>
                    <xsd:element name="category" type="tns:LogCategory"/>
                    <xsd:element name="level" type="tns:LogCategoryLevel"/>
                </xsd:sequence>
            </xsd:complexType>
            <xsd:simpleType name="LogCategory">
                <xsd:restriction base="xsd:string">
                    <xsd:enumeration value="Db"/>
                    <xsd:enumeration value="Workflow"/>
                    <xsd:enumeration value="Validation"/>
                    <xsd:enumeration value="Callout"/>
                    <xsd:enumeration value="Apex_code"/>
                    <xsd:enumeration value="Apex_profiling"/>
                    <xsd:enumeration value="Visualforce"/>
                    <xsd:enumeration value="System"/>
                    <xsd:enumeration value="Wave"/>
                    <xsd:enumeration value="All"/>
                </xsd:restriction>
            </xsd:simpleType>
            <xsd:simpleType name="LogCategoryLevel">
                <xsd:restriction base="xsd:string">
                    <xsd:enumeration value="None"/>
                    <xsd:enumeration value="Finest"/>
                    <xsd:enumeration value="Finer"/>
                    <xsd:enumeration value="Fine"/>
                    <xsd:enumeration value="Debug"/>
                    <xsd:enumeration value="Info"/>
                    <xsd:enumeration value="Warn"/>
                    <xsd:enumeration value="Error"/>
                </xsd:restriction>
            </xsd:simpleType>
            <xsd:simpleType name="LogType">
                <xsd:restriction base="xsd:string">
                    <xsd:enumeration value="None"/>
                    <xsd:enumeration value="Debugonly"/>
                    <xsd:enumeration value="Db"/>
                    <xsd:enumeration value="Profiling"/>
                    <xsd:enumeration value="Callout"/>
                    <xsd:enumeration value="Detail"/>
                </xsd:restriction>
            </xsd:simpleType>
            <xsd:element name="DebuggingInfo">
                <xsd:complexType>
                    <xsd:sequence>
                        <xsd:element name="debugLog" type="xsd:string"/>
                    </xsd:sequence>
                </xsd:complexType>
            </xsd:element>
            <xsd:element name="SessionHeader">
                <xsd:complexType>
                    <xsd:sequence>
                        <xsd:element name="sessionId" type="xsd:string"/>
                    </xsd:sequence>
                </xsd:complexType>
            </xsd:element>
            <xsd:simpleType name="ID">
                <xsd:restriction base="xsd:string">
                    <xsd:length value="18"/>
                    <xsd:pattern value="[a-zA-Z0-9]{18}"/>
                </xsd:restriction>
            </xsd:simpleType>
            <xsd:complexType name="wsOutputs">
                <xsd:sequence>
                    <xsd:element name="referenceId" minOccurs="0" type="xsd:string" nillable="true"/>
                    <xsd:element name="returnId" minOccurs="0" maxOccurs="unbounded" type="xsd:string" nillable="true"/>
                    <xsd:element name="returnMessage" minOccurs="0" type="xsd:string" nillable="true"/>
                    <xsd:element name="success" minOccurs="0" type="xsd:boolean" nillable="true"/>
                </xsd:sequence>
            </xsd:complexType>
            <xsd:complexType name="address">
                <xsd:complexContent>
                    <xsd:extension base="tns:location">
                        <xsd:sequence>
                            <xsd:element name="city" type="xsd:string"/>
                            <xsd:element name="country" type="xsd:string"/>
                            <xsd:element name="countryCode" type="xsd:string"/>
                            <xsd:element name="geocodeAccuracy" type="xsd:string"/>
                            <xsd:element name="postalCode" type="xsd:string"/>
                            <xsd:element name="state" type="xsd:string"/>
                            <xsd:element name="stateCode" type="xsd:string"/>
                            <xsd:element name="street" type="xsd:string"/>
                        </xsd:sequence>
                    </xsd:extension>
                </xsd:complexContent>
            </xsd:complexType>
            <xsd:complexType name="location">
                <xsd:sequence>
                    <xsd:element name="latitude" type="xsd:double"/>
                    <xsd:element name="longitude" type="xsd:double"/>
                </xsd:sequence>
            </xsd:complexType>
            <xsd:element name="addUpdateContact">
                <xsd:complexType>
                    <xsd:sequence>
                        <xsd:element name="Salutation" type="xsd:string" nillable="true"/>
                        <xsd:element name="Firstname" type="xsd:string" nillable="true"/>
                        <xsd:element name="Lastname" type="xsd:string" nillable="true"/>
                        <xsd:element name="Title" type="xsd:string" nillable="true"/>
                        <xsd:element name="Email" type="xsd:string" nillable="true"/>
                        <xsd:element name="Phone" type="xsd:string" nillable="true"/>
                        <xsd:element name="Email_Opt_Out" type="xsd:boolean" nillable="true"/>
                        <xsd:element name="Salesforce_Account_Id" type="tns:ID" nillable="true"/>
                        <xsd:element name="Quartz_Account_Id" type="xsd:string" nillable="true"/>
                        <xsd:element name="Quartz_Contact_Id" type="xsd:string" nillable="true"/>
                    </xsd:sequence>
                </xsd:complexType>
            </xsd:element>
            <xsd:element name="addUpdateContactResponse">
                <xsd:complexType>
                    <xsd:sequence>
                        <xsd:element name="result" type="tns:wsOutputs" nillable="true"/>
                    </xsd:sequence>
                </xsd:complexType>
            </xsd:element>
            <xsd:element name="HelloWorld">
                <xsd:complexType>
                    <xsd:sequence/>
                </xsd:complexType>
            </xsd:element>
            <xsd:element name="HelloWorldResponse">
                <xsd:complexType>
                    <xsd:sequence>
                        <xsd:element name="result" type="xsd:string" nillable="true"/>
                    </xsd:sequence>
                </xsd:complexType>
            </xsd:element>
        </xsd:schema>
    </types>
    <!-- Message for the header parts -->
    <message name="Header">
        <part name="AllowFieldTruncationHeader" element="tns:AllowFieldTruncationHeader"/>
        <part name="CallOptions" element="tns:CallOptions"/>
        <part name="DebuggingHeader" element="tns:DebuggingHeader"/>
        <part name="DebuggingInfo" element="tns:DebuggingInfo"/>
        <part name="SessionHeader" element="tns:SessionHeader"/>
    </message>
    <!-- Operation Messages -->
    <message name="addUpdateContactRequest">
        <part element="tns:addUpdateContact" name="parameters"/>
    </message>
    <message name="addUpdateContactResponse">
        <part element="tns:addUpdateContactResponse" name="parameters"/>
    </message>
    <message name="HelloWorldRequest">
        <part element="tns:HelloWorld" name="parameters"/>
    </message>
    <message name="HelloWorldResponse">
        <part element="tns:HelloWorldResponse" name="parameters"/>
    </message>
    <portType name="QuartzWSPortType">
        <operation name="addUpdateContact">
            <input message="tns:addUpdateContactRequest"/>
            <output message="tns:addUpdateContactResponse"/>
        </operation>
        <operation name="HelloWorld">
            <input message="tns:HelloWorldRequest"/>
            <output message="tns:HelloWorldResponse"/>
        </operation>
    </portType>
    <binding name="QuartzWSBinding" type="tns:QuartzWSPortType">
        <soap:binding style="document" transport="http://schemas.xmlsoap.org/soap/http"/>
        <operation name="addUpdateContact">
            <soap:operation soapAction=""/>
            <input>
                <soap:header use="literal" part="SessionHeader" message="tns:Header"/>
                <soap:header use="literal" part="CallOptions" message="tns:Header"/>
                <soap:header use="literal" part="DebuggingHeader" message="tns:Header"/>
                <soap:header use="literal" part="AllowFieldTruncationHeader" message="tns:Header"/>
                <soap:body use="literal" parts="parameters"/>
            </input>
            <output>
                <soap:header use="literal" part="DebuggingInfo" message="tns:Header"/>
                <soap:body use="literal"/>
            </output>
        </operation>
        <operation name="HelloWorld">
            <soap:operation soapAction=""/>
            <input>
                <soap:header use="literal" part="SessionHeader" message="tns:Header"/>
                <soap:header use="literal" part="CallOptions" message="tns:Header"/>
                <soap:header use="literal" part="DebuggingHeader" message="tns:Header"/>
                <soap:header use="literal" part="AllowFieldTruncationHeader" message="tns:Header"/>
                <soap:body use="literal" parts="parameters"/>
            </input>
            <output>
                <soap:header use="literal" part="DebuggingInfo" message="tns:Header"/>
                <soap:body use="literal"/>
            </output>
        </operation>
    </binding>
    <service name="QuartzWSService">
        <documentation/>
        <port binding="tns:QuartzWSBinding" name="QuartzWS">
            <soap:address location="https://cs8.salesforce.com/services/Soap/class/QuartzWS"/>
        </port>
    </service>
</definitions>

when I tried to access this class using URL https://cs8.salesforce.com/services/Soap/class/QuartzWS at the end of this xml.

<soap:address location="https://cs8.salesforce.com/services/Soap/class/QuartzWS"/>
it is showing message

Problem accessing /services/Soap/class/QuartzWS. Reason:
Only POST allowed

Could you please let me know how to find this URL so that external system will consume WSDL above and then can access function from webservice class using specific user created? It will help a lot.

Also let me know if need further details.

Best Regards,

Rahul

Rahul Borgaonkar
March 13, 2017
Like
0

0 replies

How to disable Contact Lookup field auto populating list of all contact

Hi,

I have a contact look up field on a custom object. I have put a filter so that it should show all contacts for account which relates to custom object. But when I try to select a contact from popup on magnify glass, it also show me list of all contacts on all account. Please find a screen shot of the same. These list of contacts are unwanted list as it is not related to account on custom object.

Could you please let me know how to disable this picklist functionality when I use this lookup contact field on visualforce page? It will help a lot.

User-added image

Please let me know if you need further details.

Best Regards,

Rahul

Rahul Borgaonkar
November 24, 2016
Like
0

1 replies

Update outputtext value in pageblocktable using javascript

Hello All,

I have created a VF page having pageblocktable tag. There are 2 coulmns, first is apex:input and other is apex:outputtext. On input tag using onchange executing a javascript. In this javascript I am using apex:input value and calculating a outputtext value using a formula. I am getting correct formula value but not able to update in outputtext. Please find VF for ref.

<apex:page standardController="Account" tabStyle="Account" extensions="MonthlyDeductionsController" docType="html-5.0" sidebar="false" id="pageid">
    <apex:sectionHeader title="{!account.name}"/>
    <apex:form id="formid" >
        <script type="text/javascript">
        function changeesi1(input, er, er_rate, inx)
        {
            //alert(input.value);
            //alert(er);
            //alert(er_rate);
            //alert(inx);
            //alert(er);
            erid = er;
            //alert(erid);
            er = document.getElementById(erid).value;
            alert(er);
            document.getElementById(erid).value = Math.ceil(input.value * er_rate/100);;
            alert(document.getElementById(erid).value);
        }
        </script>

            <apex:pageBlockTable value="{!deductiondata}" var="ddlist" id="ddid">
                <apex:column headerValue="ESI Wages 1">
                    <apex:input id="esiwgid1" size="10" value="{!ddlist.ESIWages}" onchange="changeesi1(this, '{!$Component.ER}', '{!currentPeriod.ESI_ER_Rate__c}', '{!ddlist.index}');" />
                </apex:column>

                <apex:column headerValue="ESI ER({!currentPeriod.ESI_ER_Rate__c}%)" id="erc">
                    <apex:outputText id="er" value="{0, number, Rs #####0.00}">
                        <apex:param value="{!ddlist.ER}"/>
                    </apex:outputtext>
                </apex:column>
            </apex:pageBlockTable>
    </apex:form>
</apex:page>

It should update/refresh {!ddlist.ER} value using javascript immidiately after onchange. Could you please tell what is missing in javascript?

I have achieved this using apex function using actionFunction but process is slow and want to calculate and refresf {!ddlist.ER} value in page it self using javascript function instead of apex function. Please let me know if you need more details.

Best Regards,

Rahul

Rahul Borgaonkar
April 04, 2016
Like
0

3 replies

Dot matrix out put using Visualforce

Hi,

I want to print account and its contacts on dot matrix printer. Is it possible to do it using visualforce renderas PDF option.
Please find my VF code.

<apex:page standardController="Account" sidebar="false" id="pageid" renderAs="PDF">
    <apex:outputtext value="{!account.name}" style="font-family: 'Courier New'; margin: 100;"/>
    <apex:form id="formid" >
    <apex:dataTable value="{!account.contacts}" var="contact">
        <apex:column headerValue="Employee Name" value="{!contact.name}" style="font-family: 'Courier New'; margin: 0;"/>
    </apex:dataTable>
    </apex:form>
</apex:page>

Please help.

Thanks,

Rahul

Rahul Borgaonkar
February 24, 2016
Like
1

SOLVED

3 replies

SOQL Governor Limit Calculation

Hi,

We are using a managed package. It has custom objects (say abc) on which we have written custom trigger. In this custom trigger we have written SOQL to access managed package other related custom objects (say xyz (relates to abc)).

Does additional SOQLs written by us (on xzy) in custom trigger are counted in managed package's SOQL limits when it updates custom object (abc)?

A function in managed package is throwing Too many SOQL error and not sure it is because of our custom trigger.

Could you please help?

Thanks,

Rahul

Rahul Borgaonkar
October 27, 2015
Like
0

2 replies

Change Set deployement from Developer Pro Sandbox to Full Sandbox

Hi,

I am trying to deploy a change set from Developer Pro Sandbox to Full Sandbox. When I tried to validate inbound change on Full Sandbox it is saying Run Apex Test is not required. Could you please let me know how can I run Apex test on full sandbox while deploying from Dev Pro sandbox?

Best Regards,

Rahul

Rahul Borgaonkar
October 02, 2015
Like
0

1 replies

Webservice Apex Method with List As parameter

Hi,
I have a inner class and method as below. The class and method is defined in outer class WebsiteWS.

global without sharing class WebsiteWS 
{
	    global class wsAttendeeDetails
	    {
	        webservice Id websiteOrderId;
	    }

	    webService static wsOutputs wsPopulateOppEventContactDetails(List<wsAttendeeDetails> attendeeDetails)
	    {
	        system.debug('List<wsAttendeeDetails> attendeeDetails - ' + attendeeDetails);
	        return null;
	    }
}

I am trying to execute this method from Button using sforce.apex.execute.

var ret = sforce.apex.execute("WebsiteWS", "wsPopulateOppEventContactDetails", {"attendeeDetails" : [ { "websiteOrderId" : "11111" } ] } );
alert(ret);

I am not getting correct value in system.debug, getting null as below
15:51:24:928 USER_DEBUG [2209]|DEBUG|List<wsAttendeeDetails> attendeeDetails - (wsAttendeeDetails:[websiteOrderId=null])

Could you please help to find exact problem?

Regards,

Rahul

Rahul Borgaonkar
July 28, 2015
Like
0

0 replies

Sending JSON to webservice

Hi,

I have a inner class and method as below. The class and method is defined in outer class WebsiteWS.

global without sharing class WebsiteWS  
{
    global class wsAttendeeDetails
    {
        webservice Id websiteOrderId;
    }
    webService static wsOutputs wsPopulateOppEventContactDetails(List<wsAttendeeDetails> attendeeDetails)
    {
        system.debug('List<wsAttendeeDetails> attendeeDetails - ' + attendeeDetails);
        return null;
    }
}

I am trying to execute this method from Button using sforce.apex.execute.

var ret = sforce.apex.execute("WebsiteWS", "wsPopulateOppEventContactDetails", {"attendeeDetails" : [ { "websiteOrderId" : "11111" } ] } );
alert(ret);

Rahul Borgaonkar
July 24, 2015
Like
0

2 replies

Error while compiling in Developer Console

Hi,

I am getting attached error while saving an old class from Developer console. It saves from Develop > Apex Classes with out any error.

User-added image

The error is for Financial Force Object. When communicated with FF they replied as

Hi Rahul,

Our development team was able to edit the AutoInvoiceHelper class, but not on developer console, instead from Setup -> Develop -> Apex Classes, and it worked without errors. If developer console is failing, it might be a Salesforce issue. It does appear you have access to the Apex class, CODAAPIInvoiceTypes_9_0.

Please try the steps provided above, but if it still doesn't work on the developer console you may consider contacting Salesforce support.  Unfortunately, this is as far as we can support since this is a custom Apex class.
Please let me know if you're ok to close this case.

Thank you,

FinancialForce.com

Would like to get solution before posting it with Salesforce.

Could I kindly request further help please?

Best Regards,

Rahul

Rahul Borgaonkar
July 16, 2015
Like
0

SOLVED

2 replies

Clear inputtextarea value onclick event

Hi,

I have apex:inputtextarea field which has default inital value. Onclick event on this field it should get empty (blank). How could I acheive this?

<apex:inputTextarea rows="1" id="inputpa" value="{!ebrecs.Attendance_Notes__c}"/>

Thanks,

Rahul

Rahul Borgaonkar
May 08, 2015
Like
0

1 replies

Saving classes/triggers to local drive

Hi,

How can I save my code(classes/triggers/pages) to local drive regularly? I normally use Eclipse to sync/save if I use web based editor. Are you using any other tool. Please share.

Thanks,

Rahul

Rahul Borgaonkar
April 20, 2015
Like
0

SOLVED

1 replies

<apex:inputfield> of type Text Area is not working for <apex:actionSupport>

Hi,
I have TextArea field named Attendance_Notes__c on object EventBooking. I developing a pageblocktable. One column of this table is shown here
When delegate has partial attendance for a course, trainer should put a note.
The checkbox will show Text Area field to put notes.

<apex:Column id="pa">
         <apex:facet name="header">Partial Attendance</apex:facet>
         <apex:inputCheckbox id="isPartialAttendance" value="{!ebrecs.EventBooking['Partial_Attendance_Flag__c']}" selected="false" rendered="{!ebrecs.isCheckBoxShow}">
                  <apex:actionsupport status="submitStatus" event="onclick" action="{!saveValues}" reRender="pa,pm">
                           <apex:param assignto="{!index}" name="param1" value="{!ebrecs.index}"/>
                  </apex:actionsupport>
        </apex:inputCheckbox>
        <apex:inputfield id="inputpa" label="Notes" value="{!ebrecs.EventBooking['Attendance_Notes__c']}" rendered="{!AND(if(ebrecs.EventBooking['Partial_Attendance_Flag__c']==true,true,false),ebrecs.isCheckBoxShow)}">
                 <apex:actionsupport immediate="true" status="submitStatus" event="onchange" action="{!saveValues}" reRender="pa,pm">
                         <apex:param assignto="{!index}" name="param1" value="{!ebrecs.index}"/>
                </apex:actionsupport>
       </apex:inputfield>
</apex:Column>

when inputfield is updated(event="onchange") with notes, action - saveValues on actionsupport should be invoked, which is not invoking now.
It is working fine for all other field type from other column
Could you please help ?

Best Regards,

Rahul

Rahul Borgaonkar
March 25, 2015
Like
0

SOLVED

1 replies

Force.com sites page refresh Vs Normal page refresh for same visualforce page.

Hi,
I am using a VF page in force.com sites. On the page it has Save and Cancel button. Both buttons are executing controller extension methods saveData and cancelData respectively. Controller extension has constructor too.

Extract from Visualforce page

<apex:page standardController="Special_Event__c" extensions="BSCDelegateCaptureController" id="page"  name="Delegate Capture Form">
    <apex:sectionHeader title="Delegate Capture Form"/>
    <apex:form id="form">
        <apex:pageBlock id="pb">
        <apex:pageMessages id="pm"/>

        <apex:pageBlockButtons id="pbb" location="top">

            <apex:actionStatus id="submitStatus">
                <apex:facet name="stop">
                <apex:outputPanel >
                    <apex:commandButton id="sb" status="submitStatus" value="Submit Details" action="{!saveData}"/> 
                    <apex:commandButton status="submitStatus" value="Cancel" action="{!cancelData}"/>
                </apex:outputPanel>
                </apex:facet>
                <apex:facet name="start">
                <apex:outputPanel >
                    <apex:commandButton value="Submit Details" disabled="true" />
                    <apex:commandButton value="Cancel" disabled="true" />
                </apex:outputPanel>
                </apex:facet>
            </apex:actionStatus>

        </apex:pageBlockButtons>
        </apex:pageBlock>
    </apex:form>
</apex:page>

public class BSCDelegateCaptureController
{
    public BSCDelegateCaptureController(ApexPages.StandardController controller)
    {
        system.debug('Inside BSCDelegateCaptureController');
    }

    public PageReference saveData()
    {
        system.debug('Inside saveData');
        PageReference pageRef = new PageReference('/apex/BSCDelegateCapture?id='+BSCEvent.id);
        //PageReference pageRef = new PageReference('/forms/BSCDelegateCapture?id='+BSCEvent.id);
        pageRef.setRedirect(true);
        return pageRef;
    }

    public PageReference cancelData()
    {
        system.debug('Inside cancelData');
        PageReference pageRef = new PageReference('/apex/BSCDelegateCapture?id='+BSCEvent.id);
        //PageReference pageRef = new PageReference('/forms/BSCDelegateCapture?id='+BSCEvent.id);
        pageRef.setRedirect(true);
        return pageRef;
    }
}

When I press Save or Cancel buttonIt should execute saveData or cancelData method
Refresh page and also execute class constructor.While testing in normal salesforce environment it is executing constructor (step2) but it is not executing constructor when page is used in force.com sites.

PageReference pageRef = new PageReference('/apex/BSCDelegateCapture?id='+BSCEvent.id); - Normal url for redirect.
PageReference pageRef = new PageReference('/forms/BSCDelegateCapture?id='+BSCEvent.id); - force.com sites url for redirect.

Kindly let me know what could be the reason. It will help a lot.

Best Regards,

Rahul

Rahul Borgaonkar
March 18, 2015
Like
0

SOLVED

1 replies

Force.com sites page refresh Vs Normal page refresh for same visualforce page.

Extract from Visualforce page

<apex:page standardController="Special_Event__c" extensions="BSCDelegateCaptureController" id="page"  name="Delegate Capture Form">
    <apex:sectionHeader title="Delegate Capture Form"/>
    <apex:form id="form">
        <apex:pageBlock id="pb">
        <apex:pageMessages id="pm"/>

        <apex:pageBlockButtons id="pbb" location="top">

            <apex:actionStatus id="submitStatus">
                <apex:facet name="stop">
                <apex:outputPanel >
                    <apex:commandButton id="sb" status="submitStatus" value="Submit Details" action="{!saveData}"/> 
                    <apex:commandButton status="submitStatus" value="Cancel" action="{!cancelData}"/>
                </apex:outputPanel>
                </apex:facet>
                <apex:facet name="start">
                <apex:outputPanel >
                    <apex:commandButton value="Submit Details" disabled="true" />
                    <apex:commandButton value="Cancel" disabled="true" />
                </apex:outputPanel>
                </apex:facet>
            </apex:actionStatus>

        </apex:pageBlockButtons>
        </apex:pageBlock>
    </apex:form>
</apex:page>

public class BSCDelegateCaptureController
{
    public BSCDelegateCaptureController(ApexPages.StandardController controller)
    {
        system.debug('Inside BSCDelegateCaptureController');
    }

    public PageReference saveData()
    {
        system.debug('Inside saveData');
        PageReference pageRef = new PageReference('/apex/BSCDelegateCapture?id='+BSCEvent.id);
        //PageReference pageRef = new PageReference('/forms/BSCDelegateCapture?id='+BSCEvent.id);
        pageRef.setRedirect(true);
        return pageRef;
    }

    public PageReference cancelData()
    {
        system.debug('Inside cancelData');
        PageReference pageRef = new PageReference('/apex/BSCDelegateCapture?id='+BSCEvent.id);
        //PageReference pageRef = new PageReference('/forms/BSCDelegateCapture?id='+BSCEvent.id);
        pageRef.setRedirect(true);
        return pageRef;
    }
}

When I press Save or Cancel button

It should execute saveData or cancelData method
Refresh page and also execute class constructor.

While testing in normal salesforce environment it is executing constructor (step2) but it is not executing constructor when page is used in force.com sites.

PageReference pageRef = new PageReference('/apex/BSCDelegateCapture?id='+BSCEvent.id); - Normal url for redirect.
PageReference pageRef = new PageReference('/forms/BSCDelegateCapture?id='+BSCEvent.id); - force.com sites url for redirect.

Kindly let me know what could be the reason. It will help a lot.

Best Regards,

Rahul

Rahul Borgaonkar
March 17, 2015
Like
0

1 replies

Getter and Setter method for class sobject variable

Hi,

I am using a class
public class EventBookingRecs
{
        public sObject EventBooking {get; set;}
        public Account bookingAccount {get;set;}
        public Contact bookingContact {get;set;}
}
where variable EventBooking is based on custom object EventBooking already created. The custom object has fields like Name, Status__c etc. I am using EventBooking in visualforce page -> pageblocktable.
example
<apex:pageblocktable value="{!EventBookingRecords}" var="ebrecs" id="pbt">
       <apex:Column >
              <apex:facet name="header">Booking Status</apex:facet>
                    <apex:selectList id="status" onchange="saveValues({!ebrecs.index})" value="{!ebrecs.EventBooking['Status__c']}" size="1">
                        <apex:selectOption itemValue="" itemLabel=""/>
                        <apex:selectOption itemValue="Attended" itemLabel="Attended"/>
                        <apex:selectOption itemValue="No Show" itemLabel="No Show"/>
                    </apex:selectList>
       </apex:Column>
</apex:pageblocktable>

Could you please let me know how to write a getter and setter method for EventBooking['Status__c'] (EventBookingRecs.EventBooking.Status__c) so that when values changes on screen it should set it permamently and screen refresh should not affect it?

Please let me know if you need more details

Best Regards,

Rahul

Rahul Borgaonkar
March 13, 2015
Like
2

1 replies

Error using outputtext & param in Email Template for date field

Hi,

I am getting below error

Error: The value attribute on <apex:outputText> is not in a valid format. It must be a positive number, and of type Number, Date, Time, or Choice.

when using

<apex:outputText value="{0,date,yyyyMMdd'T'HHmmss'Z'}">
<apex:param value="{!relatedTo.ReminderDateTime}"/>
</apex:outputText>

I have also tried

<apex:outputText value="{0,date,yyyyMMdd'T'HHmmss'Z'}">

<apex:param value="{!relatedTo.ReminderDateTime}"/>

</apex:outputText>

but it is not working too.

ReminderDateTime field is from task table.

Can I kidnly request for a help.

Thanks,

Rahul

Rahul Borgaonkar
June 13, 2013
Like
0

13 replies

On Sandbox box Outbound email is not working.

Hi,

I have written a trigger on lead object which checks for duplicates Company name before insert and before update. If it finds duplicate then it should send mail to Owner.

It is working for single and bulk insert except sendMail function.

The trigger is

trigger checkDuplicateLeads on Lead (before insert, before update)
{
    Map<String, Lead> leadMap = new Map<String, Lead>();

    for (Lead lead : Trigger.new)
    {
        if(Trigger.isInsert || (lead.Company != Trigger.oldMap.get(lead.Id).Company) || (lead.Company != null))
        {
            if(leadMap.containsKey(lead.Company))
            {
                lead.Company.addError('Another new lead has the same Company Name');
            }
            else
            {
                leadMap.put(lead.Company, lead);
            }
        }
    }

    for(Account account : [SELECT Name, Owner.Id, Owner.email FROM Account WHERE Name IN :leadMap.KeySet()])
    {
        Lead newLead = leadMap.get(account.Name);

        if(account.Name == newLead.Company)
        {
            String Message = 'An Account (' + account.Name + ') with this Lead Name already exists';
            sendMailToDupLeadsAccounts.sendMail(account.owner.email, Message);
            newLead.Company.addError(Message);
        }
    }

    for(Lead lead : [SELECT Company, OwnerId FROM Lead WHERE Company IN :leadMap.KeySet()])
    {       
        User Owner = [SELECT email FROM User WHERE Id = :lead.ownerid LIMIT 1];
        Lead newLead = leadMap.get(lead.Company);

        if(newLead.Company == lead.Company)
        {
            String Message = 'A Lead (' + lead.Company + ') with this Name already exists';
            sendMailToDupLeadsAccounts.sendMail(Owner.email, Message);
            newLead.Company.addError(Message);
        }
    }
}

The sendMail function is

public class sendMailToDupLeadsAccounts
{
    sendMailToDupLeadsAccounts()
    {
    }
    
    public static void sendMail(String Email, String Message)
    {    
        Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage();
        mail.setToAddresses(new String[] { Email });
        mail.setSubject('Important Message!');
        mail.setPlainTextBody(Message);

        List<Messaging.SendEmailResult> results = Messaging.sendEmail(new Messaging.SingleEmailMessage[] { mail });
        system.debug('Result - ' + results);

    }        
}

I am getting problem with sendMail function. As I am inserting duplicate lead from my account I should receive mai in my Inbox but it is not happening. Is there setting which needs to be done on Sandbox. I tried all sorts of settings from Email Administration and 'Personal Setup -> Email', but no success.

When I tried same trigger and class from my Dev Org it is working fine.

Has anyone came across similar problem. It will help a lot if you can guide me.

Thanks and Regards,

Rahul Borgaonkar

Rahul Borgaonkar
May 13, 2013
Like
0

3 replies

Challenge not found at the end of module

Rahul Borgaonkar
November 05, 2017
Like
4

3 replies

Dot matrix out put using Visualforce

Hi,

I want to print account and its contacts on dot matrix printer. Is it possible to do it using visualforce renderas PDF option.
Please find my VF code.

<apex:page standardController="Account" sidebar="false" id="pageid" renderAs="PDF">
    <apex:outputtext value="{!account.name}" style="font-family: 'Courier New'; margin: 100;"/>
    <apex:form id="formid" >
    <apex:dataTable value="{!account.contacts}" var="contact">
        <apex:column headerValue="Employee Name" value="{!contact.name}" style="font-family: 'Courier New'; margin: 0;"/>
    </apex:dataTable>
    </apex:form>
</apex:page>

Please help.

Thanks,

Rahul

Rahul Borgaonkar
February 24, 2016
Like
1

1 replies

Getter and Setter method for class sobject variable

Rahul Borgaonkar
March 13, 2015
Like
2

2 replies

Running soql in developer console -> query editor and in workbench

Hi,
I am trying to run a query below from developer documentation

SELECT Amount, FORMAT(amount) Amt, convertCurrency(amount) convertedAmount, FORMAT(convertCurrency(amount)) convertedCurrency FROM Opportunity where id = '0069000000va8SS'

Could you please let me know what could be reason?

Best Regards,

Rahul

Rahul Borgaonkar
December 09, 2017
Like
0

2 replies

URL for WSDL to external System

<!--
 Web Services API : QuartzWS
-->
<definitions targetNamespace="http://soap.sforce.com/schemas/class/QuartzWS">
    <types>
        <xsd:schema elementFormDefault="qualified" targetNamespace="http://soap.sforce.com/schemas/class/QuartzWS">
            <xsd:element name="AllowFieldTruncationHeader">
                <xsd:complexType>
                    <xsd:sequence>
                        <xsd:element name="allowFieldTruncation" type="xsd:boolean"/>
                    </xsd:sequence>
                </xsd:complexType>
            </xsd:element>
            <xsd:element name="CallOptions">
                <xsd:complexType>
                    <xsd:sequence>
                        <xsd:element name="client" type="xsd:string"/>
                    </xsd:sequence>
                </xsd:complexType>
            </xsd:element>
            <xsd:element name="DebuggingHeader">
                <xsd:complexType>
                    <xsd:sequence>
                        <xsd:element name="categories" minOccurs="0" maxOccurs="unbounded" type="tns:LogInfo"/>
                        <xsd:element name="debugLevel" type="tns:LogType"/>
                    </xsd:sequence>
                </xsd:complexType>
            </xsd:element>
            <xsd:complexType name="LogInfo">
                <xsd:sequence>
                    <xsd:element name="category" type="tns:LogCategory"/>
                    <xsd:element name="level" type="tns:LogCategoryLevel"/>
                </xsd:sequence>
            </xsd:complexType>
            <xsd:simpleType name="LogCategory">
                <xsd:restriction base="xsd:string">
                    <xsd:enumeration value="Db"/>
                    <xsd:enumeration value="Workflow"/>
                    <xsd:enumeration value="Validation"/>
                    <xsd:enumeration value="Callout"/>
                    <xsd:enumeration value="Apex_code"/>
                    <xsd:enumeration value="Apex_profiling"/>
                    <xsd:enumeration value="Visualforce"/>
                    <xsd:enumeration value="System"/>
                    <xsd:enumeration value="Wave"/>
                    <xsd:enumeration value="All"/>
                </xsd:restriction>
            </xsd:simpleType>
            <xsd:simpleType name="LogCategoryLevel">
                <xsd:restriction base="xsd:string">
                    <xsd:enumeration value="None"/>
                    <xsd:enumeration value="Finest"/>
                    <xsd:enumeration value="Finer"/>
                    <xsd:enumeration value="Fine"/>
                    <xsd:enumeration value="Debug"/>
                    <xsd:enumeration value="Info"/>
                    <xsd:enumeration value="Warn"/>
                    <xsd:enumeration value="Error"/>
                </xsd:restriction>
            </xsd:simpleType>
            <xsd:simpleType name="LogType">
                <xsd:restriction base="xsd:string">
                    <xsd:enumeration value="None"/>
                    <xsd:enumeration value="Debugonly"/>
                    <xsd:enumeration value="Db"/>
                    <xsd:enumeration value="Profiling"/>
                    <xsd:enumeration value="Callout"/>
                    <xsd:enumeration value="Detail"/>
                </xsd:restriction>
            </xsd:simpleType>
            <xsd:element name="DebuggingInfo">
                <xsd:complexType>
                    <xsd:sequence>
                        <xsd:element name="debugLog" type="xsd:string"/>
                    </xsd:sequence>
                </xsd:complexType>
            </xsd:element>
            <xsd:element name="SessionHeader">
                <xsd:complexType>
                    <xsd:sequence>
                        <xsd:element name="sessionId" type="xsd:string"/>
                    </xsd:sequence>
                </xsd:complexType>
            </xsd:element>
            <xsd:simpleType name="ID">
                <xsd:restriction base="xsd:string">
                    <xsd:length value="18"/>
                    <xsd:pattern value="[a-zA-Z0-9]{18}"/>
                </xsd:restriction>
            </xsd:simpleType>
            <xsd:complexType name="wsOutputs">
                <xsd:sequence>
                    <xsd:element name="referenceId" minOccurs="0" type="xsd:string" nillable="true"/>
                    <xsd:element name="returnId" minOccurs="0" maxOccurs="unbounded" type="xsd:string" nillable="true"/>
                    <xsd:element name="returnMessage" minOccurs="0" type="xsd:string" nillable="true"/>
                    <xsd:element name="success" minOccurs="0" type="xsd:boolean" nillable="true"/>
                </xsd:sequence>
            </xsd:complexType>
            <xsd:complexType name="address">
                <xsd:complexContent>
                    <xsd:extension base="tns:location">
                        <xsd:sequence>
                            <xsd:element name="city" type="xsd:string"/>
                            <xsd:element name="country" type="xsd:string"/>
                            <xsd:element name="countryCode" type="xsd:string"/>
                            <xsd:element name="geocodeAccuracy" type="xsd:string"/>
                            <xsd:element name="postalCode" type="xsd:string"/>
                            <xsd:element name="state" type="xsd:string"/>
                            <xsd:element name="stateCode" type="xsd:string"/>
                            <xsd:element name="street" type="xsd:string"/>
                        </xsd:sequence>
                    </xsd:extension>
                </xsd:complexContent>
            </xsd:complexType>
            <xsd:complexType name="location">
                <xsd:sequence>
                    <xsd:element name="latitude" type="xsd:double"/>
                    <xsd:element name="longitude" type="xsd:double"/>
                </xsd:sequence>
            </xsd:complexType>
            <xsd:element name="addUpdateContact">
                <xsd:complexType>
                    <xsd:sequence>
                        <xsd:element name="Salutation" type="xsd:string" nillable="true"/>
                        <xsd:element name="Firstname" type="xsd:string" nillable="true"/>
                        <xsd:element name="Lastname" type="xsd:string" nillable="true"/>
                        <xsd:element name="Title" type="xsd:string" nillable="true"/>
                        <xsd:element name="Email" type="xsd:string" nillable="true"/>
                        <xsd:element name="Phone" type="xsd:string" nillable="true"/>
                        <xsd:element name="Email_Opt_Out" type="xsd:boolean" nillable="true"/>
                        <xsd:element name="Salesforce_Account_Id" type="tns:ID" nillable="true"/>
                        <xsd:element name="Quartz_Account_Id" type="xsd:string" nillable="true"/>
                        <xsd:element name="Quartz_Contact_Id" type="xsd:string" nillable="true"/>
                    </xsd:sequence>
                </xsd:complexType>
            </xsd:element>
            <xsd:element name="addUpdateContactResponse">
                <xsd:complexType>
                    <xsd:sequence>
                        <xsd:element name="result" type="tns:wsOutputs" nillable="true"/>
                    </xsd:sequence>
                </xsd:complexType>
            </xsd:element>
            <xsd:element name="HelloWorld">
                <xsd:complexType>
                    <xsd:sequence/>
                </xsd:complexType>
            </xsd:element>
            <xsd:element name="HelloWorldResponse">
                <xsd:complexType>
                    <xsd:sequence>
                        <xsd:element name="result" type="xsd:string" nillable="true"/>
                    </xsd:sequence>
                </xsd:complexType>
            </xsd:element>
        </xsd:schema>
    </types>
    <!-- Message for the header parts -->
    <message name="Header">
        <part name="AllowFieldTruncationHeader" element="tns:AllowFieldTruncationHeader"/>
        <part name="CallOptions" element="tns:CallOptions"/>
        <part name="DebuggingHeader" element="tns:DebuggingHeader"/>
        <part name="DebuggingInfo" element="tns:DebuggingInfo"/>
        <part name="SessionHeader" element="tns:SessionHeader"/>
    </message>
    <!-- Operation Messages -->
    <message name="addUpdateContactRequest">
        <part element="tns:addUpdateContact" name="parameters"/>
    </message>
    <message name="addUpdateContactResponse">
        <part element="tns:addUpdateContactResponse" name="parameters"/>
    </message>
    <message name="HelloWorldRequest">
        <part element="tns:HelloWorld" name="parameters"/>
    </message>
    <message name="HelloWorldResponse">
        <part element="tns:HelloWorldResponse" name="parameters"/>
    </message>
    <portType name="QuartzWSPortType">
        <operation name="addUpdateContact">
            <input message="tns:addUpdateContactRequest"/>
            <output message="tns:addUpdateContactResponse"/>
        </operation>
        <operation name="HelloWorld">
            <input message="tns:HelloWorldRequest"/>
            <output message="tns:HelloWorldResponse"/>
        </operation>
    </portType>
    <binding name="QuartzWSBinding" type="tns:QuartzWSPortType">
        <soap:binding style="document" transport="http://schemas.xmlsoap.org/soap/http"/>
        <operation name="addUpdateContact">
            <soap:operation soapAction=""/>
            <input>
                <soap:header use="literal" part="SessionHeader" message="tns:Header"/>
                <soap:header use="literal" part="CallOptions" message="tns:Header"/>
                <soap:header use="literal" part="DebuggingHeader" message="tns:Header"/>
                <soap:header use="literal" part="AllowFieldTruncationHeader" message="tns:Header"/>
                <soap:body use="literal" parts="parameters"/>
            </input>
            <output>
                <soap:header use="literal" part="DebuggingInfo" message="tns:Header"/>
                <soap:body use="literal"/>
            </output>
        </operation>
        <operation name="HelloWorld">
            <soap:operation soapAction=""/>
            <input>
                <soap:header use="literal" part="SessionHeader" message="tns:Header"/>
                <soap:header use="literal" part="CallOptions" message="tns:Header"/>
                <soap:header use="literal" part="DebuggingHeader" message="tns:Header"/>
                <soap:header use="literal" part="AllowFieldTruncationHeader" message="tns:Header"/>
                <soap:body use="literal" parts="parameters"/>
            </input>
            <output>
                <soap:header use="literal" part="DebuggingInfo" message="tns:Header"/>
                <soap:body use="literal"/>
            </output>
        </operation>
    </binding>
    <service name="QuartzWSService">
        <documentation/>
        <port binding="tns:QuartzWSBinding" name="QuartzWS">
            <soap:address location="https://cs8.salesforce.com/services/Soap/class/QuartzWS"/>
        </port>
    </service>
</definitions>

Rahul Borgaonkar
March 13, 2017
Like
0

3 replies

Dot matrix out put using Visualforce

Hi,

I want to print account and its contacts on dot matrix printer. Is it possible to do it using visualforce renderas PDF option.
Please find my VF code.

<apex:page standardController="Account" sidebar="false" id="pageid" renderAs="PDF">
    <apex:outputtext value="{!account.name}" style="font-family: 'Courier New'; margin: 100;"/>
    <apex:form id="formid" >
    <apex:dataTable value="{!account.contacts}" var="contact">
        <apex:column headerValue="Employee Name" value="{!contact.name}" style="font-family: 'Courier New'; margin: 0;"/>
    </apex:dataTable>
    </apex:form>
</apex:page>

Please help.

Thanks,

Rahul

Rahul Borgaonkar
February 24, 2016
Like
1

1 replies

How to get the id of a record when i click on this

HI All,

I have created a page with tree nodes. On first level i am showing Account, second level - Contact, third level - Case. Now i want to show the contact record detail page on the side of tree node when i click on any contact record from tree nodes. But i am not able to understand how to get that particular contact record id when i click on this. this is my page and code.

User-added image

public class treenodes
{

    public PageReference contid() {
        return null;
    }

   // public ID contid{get;set;}
    /* Wrapper class to contain the nodes and their children */
    public class cNodes
    {    
        public ID contid{get;set;}
        public List<Contact> parent {get; set;}
        Public Account gparent {get;set;}
        public cNodes(Account  gp, List<Contact> p)
        {       
            parent = p;       
            gparent = gp;  
           // contid = ids;
           System.debug('contactid>>>>>>'+parent); 
           System.debug('Accountid>>>>>>'+gparent); 
        }  
    }
    /* end of Wrapper class */
    Public List<cNodes> hierarchy;
    Public List<cNodes> getmainnodes()
    {
        hierarchy = new List<cNodes>();
        List<Account> tempparent = [Select Id,Name from Account];
        for (Integer i =0; i< tempparent.size() ; i++)
        {
            List<Contact> tempchildren = [Select Id,FirstName,LastName,(Select Id,CaseNumber,Subject from Cases) from Contact where AccountId = :tempparent[i].Id];
            hierarchy.add(new cNodes(tempparent[i],tempchildren));
        }
        return hierarchy;
    }
}

<apex:page sidebar="false" controller="treenodes" showheader="false">
  <!-- Include the Jquery Script files -->     
  <link rel="stylesheet" href="{!URLFOR($Resource.Jtreeview,'Jquerytreeview/jquery.treeview.css')}"/>    
  <script src="{!URLFOR($Resource.Jtreeview,'Jquerytreeview/jquery.js')}" type="text/javascript"></script>     
  <script src="{!URLFOR($Resource.Jtreeview,'Jquerytreeview/jquery.cookie.js')}" type="text/javascript"></script>     
  <script src="{!URLFOR($Resource.Jtreeview,'Jquerytreeview/jquery.treeview.js')}" type="text/javascript"></script>
  <!-- End of Javascript files --> 
  <script type="text/javascript">         
  $(function() 
  {             
  $("#tree").treeview({                 
  collapsed: false,                 
  animated: "slow",                 
  control:"#sidetreecontrol",                 
  persist: "location"            
  });          }) 
  </script>  <br/> <br/> <br/> 
  <!-- Tree --> 
      <table style="width:100%">
          <tr>
              <td style="30%">
                  <div id="sidetreecontrol">
            <a href="?#"><font style="color:blue;">Collapse All</font></a> | <a href="?#"><font style="color:blue;">Expand All</font></a>
        </div>  
        <ul id="tree">     
          <apex:repeat value="{!mainnodes}" var="parent">         
                <li><strong><apex:outputtext style="color:blue;" escape="false" value="{!parent.gparent.Name}"/></strong>              
                  <ul>                  
                      <apex:repeat value="{!parent.parent}" var="child">                     
                          <li><span class="formattextcon"><apex:outputtext style="color:green;" escape="false" value="{!child.LastName}"/>
                          </span>                         
                              <ul>                             
                                  <apex:repeat value="{!child.Cases}" var="gchildren">                                
                                      <li> 
                                          <span class="formattextcon"> 
                                              <apex:outputtext escape="false" style="color:red;" value="{!gchildren.CaseNumber}"/> <b>||</b> &nbsp;
                                              <apex:outputtext escape="false" value="{!gchildren.Subject}"/> 
                                          </span> 
                                      </li>                             
                                  </apex:repeat>                        
                              </ul>                            
                          </li>                  
                        </apex:repeat>                
                    </ul>           
                </li>     
            </apex:repeat> 
        </ul> 
              </td>
              <td style="70%">
                  <apex:pageblock >
                      <apex:pageblocktable value="{!mainnodes}" var="a">
                          <apex:column value="{!a.gparent.Name}"/>
                      </apex:pageblocktable>
                  </apex:pageblock>
              </td>
          </tr>      
      </table>
        
        
  <!-- End of Tree -->        
</apex:page>

please help me..

Thanks,
Parteek

Parteek Kumar 5
January 12, 2016
Like
0

3 replies

I can't schedule thru the list view button

Hi All,

I written the code for calling hte schedule class from button ................But it's not scheduling , i dont knw where i did mistake

Here is my code

var d = new Date();
var h = d.getHours();
var m = d.getMinutes();
var s = d.getSeconds() + 15;

var mn = d.getMonth()+1;
var y = d.getFullYear();
var weekday = new Array(7);
    weekday[0] = "Sunday";
    weekday[1] = "Monday";
    weekday[2] = "Tuesday";
    weekday[3] = "Wednesday";
    weekday[4] = "Thursday";
    weekday[5] = "Friday";
    weekday[6] = "Saturday";

    var n = weekday[d.getDay()];


var nextFireTime = s + ' ' + m + ' ' + h + ' ' + n + ' ' + mn + '?' + y ;
alert(nextFireTime);


var scr="system.schedule('Run the Batch', '" + nextFireTime +"', new Schedularclassname());"

I have taken the ref code is this

String sch= String.valueOf(newtime.second()) +' ' + String.valueOf(newtime.minute()) + ' ' + String.valueOf(newTime.hour()) + ' ' + String.valueOf(newTime.day()) + ' ' + String.valueOf(newTime.month()) + ' ? ' +  String.valueOf(newTime.year());

Adv Thnx
Siv

VSK98
January 04, 2016
Like
0

2 replies

Error while compiling in Developer Console

Hi,

I am getting attached error while saving an old class from Developer console. It saves from Develop > Apex Classes with out any error.

User-added image

The error is for Financial Force Object. When communicated with FF they replied as

Hi Rahul,

Our development team was able to edit the AutoInvoiceHelper class, but not on developer console, instead from Setup -> Develop -> Apex Classes, and it worked without errors. If developer console is failing, it might be a Salesforce issue. It does appear you have access to the Apex class, CODAAPIInvoiceTypes_9_0.

Please try the steps provided above, but if it still doesn't work on the developer console you may consider contacting Salesforce support.  Unfortunately, this is as far as we can support since this is a custom Apex class.
Please let me know if you're ok to close this case.

Thank you,

FinancialForce.com

Would like to get solution before posting it with Salesforce.

Could I kindly request further help please?

Best Regards,

Rahul

Rahul Borgaonkar
July 16, 2015
Like
0

4 replies

Test class to the bellow simple batch class,

Hi all,
I wrote an batch apex class,
Till now i wrote 15 Test classes in my experience so that i am not able to create a test class to the bellow class in proper way, can any body explain me with the test class, it gets healpfull to me to my practice,,,, Thanks in advance,,

The class is:
------------------------
global class batchAccountUpdate implements database.batchable<sObject>{

global database.querylocator start(database.batchablecontext bc){
string sql = 'select id,name from account';
return database.getquerylocator(sql);
}

global void execute(database.batchablecontext bc, list<account> scope){
list<account> lst = new list<account>();
for(account a:scope){
a.name = a.name+'updateddd';
}
update scope;
}

global void finish(database.batchablecontext bc){}
}

venkyyy
June 16, 2015
Like
0

7 replies

When Record from Custom object is deleted Trigger not Firing

All,

I have a one to many relationship between Opportunities and a custom object name Loan__c (one Opportunity to many Loan__c). When I delete a loan record, my trigger below does not fire.

Does anyone know how to update this code so that when I delete a loan record, the trigger will fire?

Trigger updateDealWithLoanInfo2 on Loan__c (after insert, after update) {
if(Trigger.isAfter && ( Trigger.isInsert || Trigger.isUpdate )) {
map<id,id> dealMap = new map<id,id>();
set<id> consumerDeals = new set<id>();
set<id> consumerDealsYellow = new set<id>();
set<id> participatedDeals = new set<id>();
list<Loan__c> loans = new List<Loan__c>();
list<Opportunity> deals = new List<Opportunity>();
list<Opportunity> updatedDeals = new List<Opportunity>();

for(Loan__c l : Trigger.new) {
if(l.Deal__c <> NULL) {
dealMap.put(l.Deal__c, l.Id);
}
}
if(dealMap.size()>0){
loans = [Select Deal__c, Consumer__c, Participated__c from Loan__c where Deal__c in :dealMap.keySet()];
for (Loan__c l2 : loans){
if(l2.Consumer__c == 'Consumer'){
consumerDeals.add(l2.Deal__c);
}
if(l2.Consumer__c == 'Ambiguous' || l2.Consumer__c == NULL || l2.Consumer__c == 'Insufficient information'|| l2.Consumer__c == 'Not reviewed'){
consumerDealsYellow.add(l2.Deal__c);
}
if(l2.Participated__c == TRUE){
participatedDeals.add(l2.Deal__c);
}
}
deals = [Select Id, Consumer_Loan__c,Consumer_Loan_Hidden__c, Participated_Loan__c from Opportunity where Id in :dealMap.keySet()];
for (Opportunity o : deals){
if(consumerDeals.contains(o.Id)){
o.Consumer_Loan__c = TRUE;
o.Consumer_Loan_Hidden__c = FALSE;
}else{
o.Consumer_Loan__c = FALSE;
}
if(consumerDealsYellow.contains(o.Id)){
o.Consumer_Loan_Hidden__c = TRUE;
}else{
o.Consumer_Loan_Hidden__c = FALSE;
}
if(participatedDeals.contains(o.Id)){
o.Participated_Loan__c = TRUE;
}else{
o.Participated_Loan__c = FALSE;
}
updatedDeals.add(o);
}
if(updatedDeals.size()>0){
update updatedDeals;
}
}
}

Forrest Muldune
June 15, 2015
Like
0

2 replies

How to consume SOA service in salesforce?

Hello firends

I am a newbie to salesforce looking for a job.
Please let me know the following:
a) how to consume a webservice in salesforce(spring 2015 edition). basic to advanced steps involved.
b) How to check output?
c) How to check errors if generated
d) Ist it possible to call a webservive in apex trigger or class (psl correct me if I am wrong)

Regards
krishna

krishna casukhela 7
June 03, 2015
Like
0

1 replies

How to catch this error? - "SOQL statements cannot query more than 35 different parent types."

I'm getting following error in a production org.

System.UnexpectedException: SOQL statements cannot query more than 35 different parent types.

I've already contained the code inside a Try/Catch block but still it isn't being catched.

Is there way I can trap this error and act on it?

VarunC
May 21, 2015
Like
0

1 replies

CTI Adapter for Demo and its Pricing

Hi,

We have CTI requirement in our Project. The client wants a Demo on sample CTI implementation(realtime calls from salesforce to phone) and then based on that they would like to buy based on its pricing. Please let me know any trial CTI implementations (with actual phone calls) available in Salesforce for Demo purpose.

Thanks.

JayaJaya
May 18, 2015
Like
0

15 replies

Problem with trigger when Inserting new records on custom object

Hello,

I am trying to insert new records into a custom object (production) via apex data loader. When I do so I get an error like

 ReservationTrigger: execution of AfterInsert

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.ReservationTrigger: line 11, column 1

My trigger is

trigger ReservationTrigger on Reservations__c (after insert,after update) {
    // Get the IDs of related contacts
    Set<Id> contactIds = new Set<Id>();
    for(Reservations__c oneReservation:trigger.new){
        if(oneReservation.ReservationStatus__c == 'Confirmed'){
            contactIds.add(oneReservation.Email__c);
        }
    }
    // Count the distinct Reservation_Number__c from the Reservation objects of all related contacts
    Map<Id, Integer> countDistinctReservationMap = new Map<Id, Integer>();
    for (AggregateResult aggRes : [SELECT COUNT_DISTINCT(ReservationCode__c) resNum, Email__c conId FROM Reservations__c WHERE Email__c IN: contactIds GROUP BY Email__c ]) {
         Id conId = (Id) aggRes.get('conId');
         Integer resNum  = (Integer) aggRes.get('resNum');
         countDistinctReservationMap.put(conId, resNum);
    }
    // Now fetch the Contacts in a list
    List<Contact> listContacts = [Select Id, customRollupField__c from Contact Where Id IN:contactIds];
    if(listContacts.size()>0) {
         for(Contact con : listContacts) {
              // fetch or get the distinct count or rollup from the map and copy it to the contact's field
              con.customRollupField__c = countDistinctReservationMap.get(con.Id);
         }
    }
    // Update the contacts
    update listContacts;
}

Any Ideas why?

Tommy Georgiou
April 22, 2015
Like
0

3 replies

How to update a field in a custom object when a record is inserted in an another custom object field using trigger??

Hello Guys,

please help me in this trigger ASAP.

KRISHNA PRASAD SRINADHU
April 13, 2015
Like
0

10 replies

create a test case for PieWdgeData

I dont know why but this code works perfectly fine in Sandbox, but once I imported to production its says only 72 percent of it passes. I dont know how to write test cases

public class ClosedLostStages {
    public List<Opportunity> Stages {get; private set;}
    public Integer counterLost {get;private set;}
    public Integer counterWon {get;private set;}
    public Integer counterQuoteSent {get;private set;}
    public Integer counterOpportunityIdentified {get;private set;}
    public Integer counterBizOrderFormSigned {get;private set;}
    public Integer counterRTS {get;private set;}
    public Decimal Sum {get;private set;}
    public Double perLost {get;private set;}
    public Double perWon {get;private set;} 

    public ClosedLostStages() {
        Stages = [Select Id, StageName, Amount, Name, Owner.Name
                  FROM Opportunity
                  WHERE   StageName = 'Closed Lost'];
        counterLost = [ Select count() 
                       FROM Opportunity
                       WHERE   StageName = 'Closed Lost' ];

        counterWon = [ Select count() 
                      FROM Opportunity
                      WHERE   StageName = 'Closed Won' ];

        counterQuoteSent = [ Select count() 
                      FROM Opportunity
                      WHERE   StageName = 'Quote Sent' ];

        counterOpportunityIdentified = [ Select count() 
                      FROM Opportunity
                      WHERE   StageName = 'Opportunity Identified' ];

        counterBizOrderFormSigned = [ Select count() 
                      FROM Opportunity
                      WHERE   StageName = 'Biz Order Form Signed' ];


        counterRTS = [ Select count() 
                      FROM Opportunity
                      WHERE   StageName = 'RTS' ];

        

        Sum = counterWon + counterLost ;
        perLost = ((counterLost / Sum) * 100) ;
        System.debug(perLost + 'Lost percentage');
        perWon = ((counterWon / Sum) * 100) ;  
        System.debug(perWon + 'Won percentage');
    }
     public List<PieWedgeData> getPieData() {
        List<PieWedgeData> data = new List<PieWedgeData>();
        data.add(new PieWedgeData('Lost ', counterLost));
        data.add(new PieWedgeData('Won', counterWon));
        data.add(new PieWedgeData('Quote Sent', counterQuoteSent));
        data.add(new PieWedgeData('Opportunity Identified', counterOpportunityIdentified ));
        data.add(new PieWedgeData('RTS', counterRTS));
        data.add(new PieWedgeData('Biz Order Form Signed', counterBizOrderFormSigned));
        return data;
    }
      public class PieWedgeData {

        public String name { get; private set; }
        public Integer data { get; private set; }

        public PieWedgeData(String name, Integer data) {
            this.name = name;
            this.data = data;
        }
    }

}

Behzad Bahadori 18
April 09, 2015
Like
0