WhatASalesForce

Get Records from Report and Assign equally to available users

2024-09-02T21:43:00.001+05:30

global class CreateDailyDialListTasksForAgents implements Schedulable {

global void execute(SchedulableContext SC) {

String reportName = 'DQ_Account_Buckets';

List<Report> reportList = [SELECT Id, DeveloperName FROM Report WHERE DeveloperName = :reportName];

if (!reportList.isEmpty()) {

fetchReportData(reportList[0].Id);

}

global void fetchReportData(Id reportId){

Reports.ReportResults results = Reports.ReportManager.runReport(reportId, true);

if(results != null && results.getFactMap() != null){

List<String> headers = new List<String>();

for(String colName : results.getReportMetadata().getDetailColumns()) {

String label = results.getReportExtendedMetadata().getDetailColumnInfo().get(colName).getLabel();

headers.add(label);

}

Reports.ReportFactWithDetails factDetails = (Reports.ReportFactWithDetails)results.getFactMap().get('0!0_0');

Map<String,String> accPhoneMap = new Map<String,String>();

for (Reports.ReportDetailRow row : factDetails.getRows()) {

Integer cellIndex = 0;

String Name;

String Phone;

for (Reports.ReportDataCell cell : row.getDataCells()){

String column = headers.get(cellIndex);

if(Column == 'Property Owner: Account Name'){

Name = cell.getLabel();

}

if(Column == 'Property Owner: Phone'){

Phone = cell.getLabel();

}

cellIndex++;

}

accPhoneMap.put(Name,Phone);

}

system.debug(accPhoneMap);

if(accPhoneMap != null && !accPhoneMap.isEmpty()){

createTasksForAgents(accPhoneMap);

}

global void createTasksForAgents(Map<String,String> accPhoneMap){

List<Id> usersIds = new List<Id>();

List<Id> availableUsersIds = new List<Id>();

/* for(GroupMember gm :[Select UserOrGroupId From GroupMember where Group.Name ='Collection Queue']){

String uId = gm.UserOrGroupId;

if(uId.startsWith('005')){

usersIds.add(uId);

}

}*/

for(User u :[Select Id From User where Profile.Name ='HOA Account Loyalty' OR Profile.Name ='HOA Account Loyalty Mgr']){

usersIds.add(u.Id);

}

if(!usersIds.isEmpty()){

for(UserServicePresence usp :[Select UserId From UserServicePresence Where IsCurrentState = true and UserId IN:usersIds]){

availableUsersIds.add(usp.UserId);

}

if(availableUsersIds.isEmpty()){

return;

}

List<Task> tasksList = new List<Task>();

for(String acc : accPhoneMap.keySet()){

Task t = new Task();

t.Subject = 'Call '+acc+' @ '+accPhoneMap.get(acc);

t.IsReminderSet = true;

t.ReminderDateTime = System.now();

t.ActivityDate = Date.today();

tasksList.add(t);

}

Integer noOfUsers = availableUsersIds.size();

Integer noOfTasks = tasksList.size();

Integer recordsPerUser = (noOfTasks + noOfUsers - 1) / noOfUsers;

Map<Id, List<Task>> userTaskMap = new Map<Id, List<Task>>();

for(Id uId : availableUsersIds){

userTaskMap.put(uId, new List<Task>());

}

Integer currentIndex = 0;

for(Task t : tasksList){

String uId = availableUsersIds[Math.mod(currentIndex, noOfUsers)];

userTaskMap.get(uId).add(t);

currentIndex++;

}

List<Task> tasksToInsert = new List<Task>();

for(Id uId : userTaskMap.keySet()){

List<Task> tasks = userTaskMap.get(uId);

for (Task t : tasks) {

t.OwnerId = uId;

tasksToInsert.add(t);

}

Database.insert(tasksToInsert,false);

}

LWC Datatable with Pagination and keep selected rows persistent

2022-09-28T11:47:00.000+05:30

Here is the code to display data in LWC Datatable with pagination and keep selected rows persistent between each page.

accountsTable.html :

<template>
  <lightning-card
    variant="Narrow"
    title="Partner Lookup"
    icon-name="standard:contact"
    class="slds-var-m-around_small"
  >
    <lightning-button
      variant="brand"
      icon-name="utility:email"
      label="Send Email"
      title="Brand action"
      slot="actions"
      onclick={openEmailPopup}
      disabled={disableEmail}
    >
    </lightning-button>
    <div class="slds-card__body slds-card__body_inner">
      <template if:true={showLoading}>
        <lightning-spinner
          alternative-text="Loading"
          size="medium"
          class="spinnerClass"
          variant="brand"
        >
        </lightning-spinner>
      </template>
      <lightning-input
        type="search"
        class="slds-size_4-of-12 slds-var-p-bottom_small"
        label="Company"
        value={searchKey}
        onchange={handleSearchChange}
      >
      </lightning-input>
      <template if:false={noData}>
        <lightning-datatable
          data-id="table"
          key-field="Id"
          data={data}
          columns={columns}
          onrowselection={onRowSelection}
          selected-rows={allSelectedRows}
          class="slds-table_bordered"
        >
        </lightning-datatable>
        <div slot="footer">
          <lightning-layout class="slds-var-p-around_small">
            <lightning-layout-item class="slds-size_2-of-12">
              <lightning-button
                label="Previous"
                icon-name="utility:chevronleft"
                onclick={previousHandler}
                disabled={disbalePrevious}
              >
              </lightning-button>
            </lightning-layout-item>
            <lightning-layout-item class="slds-size_2-of-12">
              Page {page} of {totalPage}
            </lightning-layout-item>
            <lightning-layout-item class="slds-size_2-of-12">
              <lightning-button
                label="Next"
                icon-name="utility:chevronright"
                icon-position="right"
                onclick={nextHandler}
                disabled={disbaleNext}
              >
              </lightning-button>
            </lightning-layout-item>
          </lightning-layout>
        </div>
      </template>
      <template if:true={noData}>
        <p class="slds-text-heading_small slds-var-p-top_small">
          No matching Accounts to display.
        </p>
      </template>
    </div>
  </lightning-card>
  <template if:true={showModal}>
    <section aria-modal="true" class="slds-modal slds-fade-in-open">
      <div class="slds-modal__container">
        <header class="slds-modal__header">
          <h2 class="slds-text-heading_small">Send Email</h2>
          <lightning-button-icon
            class="slds-modal__close"
            icon-name="utility:close"
            variant="bare-inverse"
            onclick={closeModal}
            alternative-text="Close"
            title="Close"
          >
          </lightning-button-icon>
        </header>
        <div
          class="slds-var-p-around_small slds-modal__content modalBody slds-is-relative"
        >
          <template if:true={showModelLoading}>
            <lightning-spinner
              alternative-text="Loading"
              size="medium"
              class="spinnerClass"
              variant="brand"
            >
            </lightning-spinner>
          </template>
          <lightning-layout multiple-rows="true" horizontal-align="space">
            <lightning-layout-item size="12">
              <lightning-input
                name="recipients"
                required="true"
                value={recipients}
                label="Recipients"
                onchange={onChangeRecipient}
              >
              </lightning-input>
            </lightning-layout-item>
            <lightning-layout-item size="12">
              <lightning-combobox
                name="template"
                label="Template"
                value={selectedTemplate}
                placeholder="Select Template"
                options={templateOptions}
                onchange={handleTemplateChange}
              >
              </lightning-combobox>
            </lightning-layout-item>
            <lightning-layout-item size="12">
              <lightning-input
                name="subject"
                required="true"
                value={subject}
                label="Subject"
                onchange={onChangeSubject}
              >
              </lightning-input>
            </lightning-layout-item>
            <lightning-layout-item size="12">
              <lightning-input-rich-text
                value={htmlBody}
                label="Content"
                label-visible="true"
                share-with-entity-id={recordId}
                required="true"
                onchange={onChangeContent}
              >
              </lightning-input-rich-text>
            </lightning-layout-item>
          </lightning-layout>
        </div>
        <footer class="slds-modal__footer">
          <lightning-button
            variant="neutral"
            label="Cancel"
            title="Cancel"
            onclick={closeModal}
            class="slds-var-p-right_small"
          >
          </lightning-button>
          <lightning-button
            variant="brand"
            icon-name="utility:send"
            label="Send"
            title="Send"
            onclick={onClickSendEmail}
          >
          </lightning-button>
        </footer>
      </div>
    </section>
    <div class="slds-backdrop slds-backdrop_open"></div>
  </template>
</template>


AccountsTable.js:


import { LightningElement, wire, api, track } from "lwc";
import getPartners from "@salesforce/apex/AccountController.getPartners";
import getRecipients from "@salesforce/apex/AccountController.getRecipients";
import getEmailBody from "@salesforce/apex/AccountController.getEmailBody";
import sendEmail from "@salesforce/apex/AccountController.sendEmail";
import emailTemplateLabel from "@salesforce/label/c.AccountTemplates";
import { ShowToastEvent } from "lightning/platformShowToastEvent";

const columns = [
  { label: "First Name", fieldName: "FirstName", type: "text" },
  { label: "Last Name", fieldName: "LastName", type: "text" },
  { label: "Email", fieldName: "Email", type: "text" },
  { label: "Phone", fieldName: "Phone", type: "Text" },
  { label: "Country", fieldName: "MailingCountry", type: "Text" }
];
const DELAY = 300;
export default class AccountsTable extends LightningElement {
  @api recordId = null;
  @track showLoading = true;
  @track showModelLoading = true;
  @track searchKey = "";
  @track page = 1;
  @track items = [];
  @track data = [];
  @track columns;
  @track startingRecord = 1;
  @track endingRecord = 0;
  @track pageSize = 10;
  @track totalRecountCount = 0;
  @track totalPage = 0;
  @track disableEmail = true;
  @track allSelectedRows = [];
  @track error;
  @track showModal = false;
  @track recipients;
  @track selectedrecipients;
  @track selectedTemplate;
  @track subject;
  @track htmlBody;
  isPageChanged = false;
  initialLoad = true;

  @wire(getPartners, {
    recId: "$recordId",
    searchKey: "$searchKey"
  })
  wiredPartners({ error, data }) {
    if (data) {
      this.processRecords(data);
      this.error = undefined;
      this.showLoading = false;
    } else if (error) {
      this.error = error;
      this.data = undefined;
      this.showLoading = false;
    }
  }
  processRecords(data) {
    this.items = data;
    this.totalRecountCount = data.length;
    this.totalPage = Math.ceil(this.totalRecountCount / this.pageSize);
    const arr = this.items.slice(0, this.pageSize);
    const newArr = arr.map((object) => {
      return { ...object, Id: object.Id + "-1" };
    });
    this.data = newArr;
    this.endingRecord = this.pageSize;
    this.columns = columns;
  }
  get disbalePrevious() {
    return this.page == 1;
  }
  get disbaleNext() {
    return this.page == this.totalPage;
  }
  previousHandler() {
    this.showLoading = true;
    this.isPageChanged = true;
    if (this.page > 1) {
      this.page = this.page - 1;
      this.displayRecordPerPage(this.page);
    }
    this.showLoading = false;
  }
  nextHandler() {
    this.showLoading = true;
    this.isPageChanged = true;
    if (this.page < this.totalPage && this.page !== this.totalPage) {
      this.page = this.page + 1;
      this.displayRecordPerPage(this.page);
    }
    this.showLoading = false;
  }
  displayRecordPerPage(page) {
    this.startingRecord = (page - 1) * this.pageSize;
    this.endingRecord = this.pageSize * page;
    this.endingRecord =
      this.endingRecord > this.totalRecountCount
        ? this.totalRecountCount
        : this.endingRecord;
    const arr = this.items.slice(this.startingRecord, this.endingRecord);
    const newArr = arr.map((object) => {
      return { ...object, Id: object.Id + "-" + page };
    });
    this.data = newArr;
    this.startingRecord = this.startingRecord + 1;
    this.template.querySelector(
      '[data-id="table"]'
    ).selectedRows = this.allSelectedRows;
  }
  onRowSelection(event) {
    if (!this.isPageChanged || this.initialLoad) {
      this.initialLoad = false;
      var selectedRows = event.target.selectedRows;
      var allSelectedRows = this.allSelectedRows;
      var currentPageNumber = this.page;
      //Process the rows now
      //Condition 1 -> If any new row selected, add to our allSelectedRows attribute
      //Condition 2 -> If any row is deselected, remove from allSelectedRows attribute
      //Solution - Remove all rows from current page from allSelectedRows attribute and then add again
      //Removing all rows coming from curent page from allSelectedRows
      var i = allSelectedRows.length;
      if (i > 0) {
        while (i--) {
          var pageNumber = allSelectedRows[i].split("-")[1];
          if (pageNumber && pageNumber == currentPageNumber) {
            allSelectedRows.splice(i, 1);
          }
        }
      }
      selectedRows.forEach(function (row) {
        allSelectedRows.push(row);
      });
      if (allSelectedRows.length > 0) {
        this.disableEmail = false;
      } else {
        this.disableEmail = true;
      }
      this.allSelectedRows = allSelectedRows;
    } else {
      this.isPageChanged = false;
    }
  }
  handleSearchChange(event) {
    this.showLoading = true;
    window.clearTimeout(this.delayTimeout);
    const searchKey = event.target.value;
    this.delayTimeout = setTimeout(() => {
      this.searchKey = searchKey;
      var data = [];
      for (var i = 0; i < this.items.length; i++) {
        if (
          this.items[i] != undefined &&
          this.items[i].FirstName.includes(this.searchKey)
        ) {
          data.push(this.items[i]);
        }
      }
      this.processRecords(data);
      this.page = 1;
      this.showLoading = false;
    }, DELAY);
  }
  openEmailPopup() {
    this.showModal = true;
    this.showModelLoading = true;
    var recs = [];
    for (var i = 0; i < this.allSelectedRows.length; i++) {
      recs.push(this.allSelectedRows[i].split("-")[0]);
    }
    getRecipients({ recIds: recs })
      .then((result) => {
        this.showModelLoading = false;
        this.recipients = result;
        this.selectedrecipients = result;
        this.error = undefined;
      })
      .catch((error) => {
        this.showModelLoading = false;
        this.recipients = undefined;
        this.selectedrecipients = undefined;
        this.error = error;
      });
  }
  get templateOptions() {
    var options = emailTemplateLabel.split(";");
    var resultMap = [];
    for (let i = 0; i < options.length; i++) {
      resultMap.push({
        class: "optionClass",
        label: options[i],
        value: options[i]
      });
    }
    return resultMap;
  }
  onChangeRecipient(event) {
    this.recipients = event.detail.value;
  }
  onChangeSubject(event) {
    this.subject = event.detail.value;
  }
  onChangeContent(event) {
    this.htmlBody = event.detail.value;
  }
  handleTemplateChange(event) {
    this.showModelLoading = true;
    this.selectedTemplate = event.detail.value;
    getEmailBody({ leadId: this.recordId, templateName: this.selectedTemplate })
      .then((result) => {
        this.showModelLoading = false;
        for (var key in result) {
          this.subject = key;
          this.htmlBody = result[key];
        }
        this.error = undefined;
      })
      .catch((error) => {
        this.showModelLoading = false;
        this.error = error;
        this.subject = undefined;
        this.htmlBody = undefined;
      });
  }
  get noData() {
    return this.items.length == 0 ? true : false;
  }
  closeModal() {
    this.closeEmailModel();
  }
  onClickSendEmail() {
    if (
      this.recipients == undefined ||
      this.recipients == null ||
      this.recipients == ""
    ) {
      this.showToast("error", "Error", "Enter the Recipients");
    } else if (
      this.subject == undefined ||
      this.subject == null ||
      this.subject == ""
    ) {
      this.showToast("error", "Error", "Enter the Subject");
    } else if (
      this.htmlBody == undefined ||
      this.htmlBody == null ||
      this.htmlBody == ""
    ) {
      this.showToast("error", "Error", "Enter the Content");
    } else {
      this.showModelLoading = true;
      sendEmail({
        leadId: this.recordId,
        toAddress: this.recipients,
        subject: this.subject,
        body: this.htmlBody
      })
        .then((result) => {
          this.showToast("success", "Success!", "Email sent successfully.");
          this.error = undefined;
          this.closeEmailModel();
        })
        .catch((error) => {
          this.showModelLoading = false;
          this.error = error;
          this.showToast("error", "Email sending failed!", this.error);
        });
    }
  }
  closeEmailModel() {
    this.recipients = this.selectedrecipients;
    this.selectedTemplate = undefined;
    this.subject = undefined;
    this.htmlBody = undefined;
    this.showModelLoading = false;
    this.showModal = false;
  }
  showToast(type, title, msg) {
    const evt = new ShowToastEvent({
      title: title,
      message: msg,
      variant: type,
      mode: "dismissable"
    });
    this.dispatchEvent(evt);
  }
}

AccountController.apxc

public class AccountController { @AuraEnabled(cacheable=true) public static List<partnerData> getPartners(String recId, String searchKey){ String partnerName; if(String.isNotBlank(searchKey)){ partnerName = searchKey+'%'; } List<partnerData> partnerList = new List<partnerData>(); for(Contact con : [SELECT Id,FirstName,LastName,Email,Phone,MailingCountry From Contact where FirstName like:partnerName]){ partnerList.add(new partnerData(con)); } return partnerList; } @AuraEnabled public static String getRecipients(List<String> recIds){ Set<String> recSet = new Set<String>(); for(Contact con :

[SELECT Id,FirstName,LastName,Email,Phone,MailingCountry From Contact Where Id IN:recIds order by Name]){ recSet.add(con.Email); } return String.join(new List<String>(recSet),';'); } @AuraEnabled public static map<string,string> getEmailBody(String leadId, String templateName){ map<string,string> emailmap = new map<string,string>(); EmailTemplate et = [select id,Name,Subject,Body from EmailTemplate where Name=:templateName]; Messaging.SingleEmailMessage email = Messaging.renderStoredEmailTemplate(et.id, leadId ,null); if(email.getHtmlBody() != null ){ emailmap.put(email.getSubject(),email.getHtmlBody()); }else{ emailmap.put(email.getSubject(),email.getPlainTextBody()); } return emailmap; } @AuraEnabled public static String sendEmail(String leadId,String toAddress,String subject,String body){ List<Messaging.SingleEmailMessage> mails = new List<Messaging.SingleEmailMessage>(); Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage(); mail.setToAddresses(toAddress.split(';')); mail.setTargetObjectId(leadId); // mail.setReplyTo('noreply@gmail.com'); // change it with your mail address. // mail.setSenderDisplayName('salesforce User'); mail.setSubject(subject); mail.setHtmlBody(body); mail.setTreatTargetObjectAsRecipient(false); mail.setSaveAsActivity(true); mails.add(mail); try{ Messaging.sendEmail(mails); return 'Success'; }catch(exception e){ return e.getMessage(); } } public class partnerData{ @AuraEnabled public string Id{get;set;} @AuraEnabled public string FirstName{get;set;} @AuraEnabled public string LastName{get;set;} @AuraEnabled public string Email{get;set;} @AuraEnabled public string Phone{get;set;} @AuraEnabled public string MailingCountry{get;set;} public partnerData(Contactpartner){ this.Id = partner.Id; this.FirstName = partner.FirstName; this.LastName = partner.LastName; this.Email = partner.Email; this.Phone = partner.Phone; this.MailingCountry = partner.MailingCountry ; } } }

SOQL to view all permissions enabled for a Permisssionset

2022-09-26T17:53:00.005+05:30

SELECT Id, Name, Label, LicenseId, ProfileId, IsOwnedByProfile, IsCustom, PermissionsEmailSingle, PermissionsEmailMass, PermissionsEditTask, PermissionsEditEvent, PermissionsExportReport, PermissionsImportPersonal, PermissionsDataExport, PermissionsManageUsers, PermissionsEditPublicFilters, PermissionsEditPublicTemplates, PermissionsModifyAllData, PermissionsManageCases, PermissionsMassInlineEdit, PermissionsEditKnowledge, PermissionsManageKnowledge, PermissionsManageSolutions, PermissionsCustomizeApplication, PermissionsEditReadonlyFields, PermissionsRunReports, PermissionsViewSetup, PermissionsTransferAnyEntity, PermissionsNewReportBuilder, PermissionsActivateContract, PermissionsActivateOrder, PermissionsImportLeads, PermissionsManageLeads, PermissionsTransferAnyLead, PermissionsViewAllData, PermissionsEditPublicDocuments, PermissionsViewEncryptedData, PermissionsEditBrandTemplates, PermissionsEditHtmlTemplates, PermissionsChatterInternalUser, PermissionsManageEncryptionKeys, PermissionsDeleteActivatedContract, PermissionsChatterInviteExternalUsers, PermissionsSendSitRequests, PermissionsOverrideForecasts, PermissionsViewAllForecasts, PermissionsApiUserOnly, PermissionsManageRemoteAccess, PermissionsCanUseNewDashboardBuilder, PermissionsManageCategories, PermissionsConvertLeads, PermissionsPasswordNeverExpires, PermissionsUseTeamReassignWizards, PermissionsEditActivatedOrders, PermissionsInstallPackaging, PermissionsPublishPackaging, PermissionsManagePartners, PermissionsChatterOwnGroups, PermissionsEditOppLineItemUnitPrice, PermissionsCreatePackaging, PermissionsBulkApiHardDelete, PermissionsInboundMigrationToolsUser, PermissionsSolutionImport, PermissionsManageCallCenters, PermissionsManageSynonyms, PermissionsOutboundMigrationToolsUser, PermissionsDelegatedPortalUserAdmin, PermissionsViewContent, PermissionsManageEmailClientConfig, PermissionsEnableNotifications, PermissionsManageDataIntegrations, PermissionsViewDataCategories, PermissionsManageDataCategories, PermissionsAuthorApex, PermissionsManageMobile, PermissionsApiEnabled, PermissionsManageCustomReportTypes, PermissionsManagePartnerNetConn, PermissionsEditCaseComments, PermissionsTransferAnyCase, PermissionsContentAdministrator, PermissionsCreateWorkspaces, PermissionsManageContentPermissions, PermissionsManageContentProperties, PermissionsManageContentTypes, PermissionsScheduleJob, PermissionsManageExchangeConfig, PermissionsManageAnalyticSnapshots, PermissionsScheduleReports, PermissionsManageBusinessHourHolidays, PermissionsManageDynamicDashboards, PermissionsManageInteraction, PermissionsViewMyTeamsDashboards, PermissionsModerateChatter, PermissionsResetPasswords, PermissionsFlowUFLRequired, PermissionsCanInsertFeedSystemFields, PermissionsActivitiesAccess, PermissionsManageKnowledgeImportExport, PermissionsEmailTemplateManagement, PermissionsEmailAdministration, PermissionsManageChatterMessages, PermissionsForceTwoFactor, PermissionsViewEventLogFiles, PermissionsManageNetworks, PermissionsManageAuthProviders, PermissionsRunFlow, PermissionsViewGlobalHeader, PermissionsManageQuotas, PermissionsCreateCustomizeDashboards, PermissionsCreateDashboardFolders, PermissionsViewPublicDashboards, PermissionsManageDashbdsInPubFolders, PermissionsCreateCustomizeReports, PermissionsCreateReportFolders, PermissionsViewPublicReports, PermissionsManageReportsInPubFolders, PermissionsEditMyDashboards, PermissionsEditMyReports, PermissionsViewAllUsers, PermissionsAllowUniversalSearch, PermissionsConnectOrgToEnvironmentHub, PermissionsCreateCustomizeFilters, PermissionsContentHubUser, PermissionsModerateNetworkFeeds, PermissionsModerateNetworkFiles, PermissionsGovernNetworks, PermissionsSalesConsole, PermissionsTwoFactorApi, PermissionsDeleteTopics, PermissionsEditTopics, PermissionsCreateTopics, PermissionsAssignTopics, PermissionsIdentityEnabled, PermissionsIdentityConnect, PermissionsAllowViewKnowledge, PermissionsContentWorkspaces, PermissionsManageSearchPromotionRules, PermissionsCustomMobileAppsAccess, PermissionsViewHelpLink, PermissionsManageProfilesPermissionsets, PermissionsAssignPermissionSets, PermissionsManageRoles, PermissionsManageIpAddresses, PermissionsManageSharing, PermissionsManageInternalUsers, PermissionsManagePasswordPolicies, PermissionsManageLoginAccessPolicies, PermissionsManageCustomPermissions, PermissionsCanVerifyComment, PermissionsManageUnlistedGroups, PermissionsStdAutomaticActivityCapture, PermissionsInsightsAppDashboardEditor, PermissionsManageTwoFactor, PermissionsInsightsAppUser, PermissionsInsightsAppAdmin, PermissionsInsightsAppEltEditor, PermissionsInsightsAppUploadUser, PermissionsInsightsCreateApplication, PermissionsDebugApex, PermissionsLightningExperienceUser, PermissionsConfigCustomRecs, PermissionsSubmitMacrosAllowed, PermissionsBulkMacrosAllowed, PermissionsShareInternalArticles, PermissionsModerateNetworkMessages, PermissionsManageSessionPermissionSets, PermissionsManageTemplatedApp, PermissionsUseTemplatedApp, PermissionsSendAnnouncementEmails, PermissionsChatterEditOwnPost, PermissionsChatterEditOwnRecordPost, PermissionsCreateAuditFields, PermissionsUpdateWithInactiveOwner, PermissionsWaveTrendReports, PermissionsWaveTabularDownload, PermissionsManageSandboxes, PermissionsAutomaticActivityCapture, PermissionsImportCustomObjects, PermissionsDelegatedTwoFactor, PermissionsChatterComposeUiCodesnippet, PermissionsSelectFilesFromSalesforce, PermissionsModerateNetworkUsers, PermissionsMergeTopics, PermissionsSubscribeToLightningReports, PermissionsManagePvtRptsAndDashbds, PermissionsAllowLightningLogin, PermissionsCampaignInfluence2, PermissionsViewDataAssessment, PermissionsRemoveDirectMessageMembers, PermissionsCanApproveFeedPost, PermissionsAddDirectMessageMembers, PermissionsAllowViewEditConvertedLeads, PermissionsShowCompanyNameAsUserBadge, PermissionsAccessCMC, PermissionsViewHealthCheck, PermissionsManageHealthCheck, PermissionsPackaging2, PermissionsManageCertificates, PermissionsCreateReportInLightning, PermissionsPreventClassicExperience, PermissionsHideReadByList, PermissionsUseSmartDataDiscovery, PermissionsGetSmartDataDiscovery, PermissionsCreateUpdateSDDDataset, PermissionsCreateUpdateSDDStory, PermissionsManageSmartDataDiscovery, PermissionsShareSmartDataDiscoveryStory, PermissionsManageSmartDataDiscoveryModel, PermissionsListEmailSend, PermissionsFeedPinning, PermissionsChangeDashboardColors, PermissionsManageRecommendationStrategies, PermissionsManagePropositions, PermissionsCloseConversations, PermissionsSubscribeReportRolesGrps, PermissionsSubscribeDashboardRolesGrps, PermissionsUseWebLink, PermissionsHasUnlimitedNBAExecutions, PermissionsViewOnlyEmbeddedAppUser, PermissionsAdoptionAnalyticsUser, PermissionsViewAllActivities, PermissionsSubscribeReportToOtherUsers, PermissionsLightningConsoleAllowedForUser, PermissionsSubscribeReportsRunAsUser, PermissionsSubscribeToLightningDashboards, PermissionsSubscribeDashboardToOtherUsers, PermissionsCreateLtngTempInPub, PermissionsTransactionalEmailSend, PermissionsViewPrivateStaticResources, PermissionsViewCustomerSentiment, PermissionsCreateLtngTempFolder, PermissionsApexRestServices, PermissionsEnableCommunityAppLauncher, PermissionsGiveRecognitionBadge, PermissionsCanRunAnalysis, PermissionsLtngPromoReserved01UserPerm, PermissionsManageSubscriptions, PermissionsWaveManagePrivateAssetsUser, PermissionsCanEditDataPrepRecipe, PermissionsAddAnalyticsRemoteConnections, PermissionsManageSurveys, PermissionsRecordVisibilityAPI, PermissionsViewRoles, PermissionsSmartDataDiscoveryForCommunity, PermissionsCanManageMaps, PermissionsStoryOnDSWithPredicate, PermissionsModifyDataClassification, PermissionsPrivacyDataAccess, PermissionsQueryAllFiles, PermissionsModifyMetadata, PermissionsSandboxTestingInCommunityApp, PermissionsCanEditPrompts, PermissionsViewUserPII, Description, CreatedDate, CreatedById, LastModifiedDate, LastModifiedById, SystemModstamp, NamespacePrefix, HasActivationRequired, Type FROM PermissionSet

How to login to Salesforce using Session id

2022-08-30T12:11:00.006+05:30

Replace host url and session id in url

https://<endpoint host>/secur/frontdoor.jsp?sid=<session id>

How to Run Schedule Apex only once or every few mins

2021-02-04T08:29:00.000+05:30

Using Scheduled Apex in UI, you cannot set a scheduled class to run only once. It's always recurring. So, you'll need to use System.scheduled via the system log to implement a workaround.

Example code for running a job 10 minutes from now only once

String hour = String.valueOf(Datetime.now().hour());

String min = String.valueOf(Datetime.now().minute() + 10);

String ss = String.valueOf(Datetime.now().second());

//parse to cron expression

String nextFireTime = ss + ' ' + min + ' ' + hour + ' * * ?';

MyScheduledJob s = new MyScheduledJob();

System.schedule('Job Started At ' + String.valueOf(Datetime.now()), nextFireTime, s);

Abort the job by adding a finish method to your class that implements the Schedulable Interface. This stops the job from running more than once.

Example code to abort the job

global void finish(Database.BatchableContext BC)

{

// Get the ID of the AsyncApexJob representing this batch job from Database.BatchableContext.

// Query the AsyncApexJob object to retrieve the current job's information.

AsyncApexJob a = [SELECT Id, Status, NumberOfErrors, JobItemsProcessed, TotalJobItems, CreatedBy.Email ..... FROM AsyncApexJob WHERE Id =

:BC.getJobId()];

//then use the active job id and abort it

system.abortJob(a.id);

}

Example code for running a job every 2 mins

Integer frequency = 2;
Integer totalIterations = 60/frequency - 1;
for(Integer i = 0; i <= totalIterations; i++){
Integer count = i*frequency;
String minuteString = (count < 10) ? '0' + count : '' + count;
System.schedule('Scheduled Job ' + i, '0 ' + minuteString + ' * * * ?', new MyScheduledJob());
}

How to start learning Salesforce

2020-12-20T21:43:00.025+05:30

Salesforce.com is a company that leverages cloud computing to design Customer Relationship Management (CRM) software for organizations. This CRM software can be used by salespeople to track sales, support people to track the resolution of queries and cases, and the entire workforce of a company to collaborate with each other.

The best of SFDC is its vast documentation and publicly available resources to learn easily.

My goal is to help you learn Salesforce as quickly as possible!

Disclaimer: all the resources provided in this blog post are publicly available I am just guiding you to those resources.

Modules in the salesforce

1. Admin
2.    Development
3.    Lightning Aura Components
4.    Lightning Web Components
5.    Integration

I would recommend start learning in this flow

Admin >> Development >> Lightning Aura Components (or) Lightning Web Components >> Integration

Trailhead is the fun way to learn Salesforce, checkout about Trailhead here:

https://trailhead.salesforce.com/content/learn/modules/trailhead_basics/get-started-with-trailhead

Click on each link to see details

1. Admin:

Trailhead:

https://trailhead.salesforce.com/content/learn/trails/force_com_admin_beginner

https://trailhead.salesforce.com/en/content/learn/trails/force_com_admin_intermediate

https://trailhead.salesforce.com/en/content/learn/trails/force_com_admin_advanced

Guide:

https://help.salesforce.com/articleView?id=basics_welcome_salesforce_users.htm&type=5

https://help.salesforce.com/articleView?id=overview.htm&type=5#quicktour_tips

Blogs:

http://www.apexhours.com/introduction-to-salesforce/

Video Tutorial:

https://www.youtube.com/playlist?list=PLaGX-30v1lh1BaUKgXa05gqrOP0vUg_6i

https://www.youtube.com/c/Salesforce/playlists

https://www.youtube.com/watch?v=bOzlOkPU0cI&list=PLdYQMTciVWO9xjvh1J7SXjhzpnzWvLih4

https://www.youtube.com/watch?v=nUARw_Yci3Y&list=PLy9U5GDpYZVPfD-kJg_hceKPo6JZi5BpT

2. Development:

Trailhead:

https://trailhead.salesforce.com/content/learn/trails/force_com_dev_beginner

https://trailhead.salesforce.com/en/content/learn/trails/force_com_dev_intermediate

https://trailhead.salesforce.com/en/content/learn/trails/force_com_dev_advanced

Guide:

https://resources.docs.salesforce.com/228/latest/en-us/sfdc/pdf/salesforce_apex_language_reference.pdf

https://resources.docs.salesforce.com/228/latest/en-us/sfdc/pdf/salesforce_pages_developers_guide.pdf

Blogs:

https://www.sfdc-lightning.com/p/triggers.html

https://www.sfdc-lightning.com/p/apexvisualforce.html

Video Tutorial:

https://www.youtube.com/playlist?list=PLaGX-30v1lh1e8roeCUumUEel5ukdPubj

https://www.sfdc99.com/video-tutorials/

https://www.sfdc99.com/apex-academy/

https://www.youtube.com/c/SalesforceDevelopers/playlists

https://www.youtube.com/watch?v=iPlfPKBXhAw&list=PLdYQMTciVWO8D1lxAzLdEwmt1k8f8ic0t

3. Lightning Aura Components:

Trailhead:

https://trailhead.salesforce.com/en/content/learn/trails/lex_dev

Guide:

https://resources.docs.salesforce.com/228/latest/en-us/sfdc/pdf/lightning.pdf

Blogs:

https://www.sfdc-lightning.com/p/salesforce-lightning.html

Video tutorial:

https://www.youtube.com/watch?v=FrnmcH0Lrkw&list=PLQXsHnNZgiNe35JsuHAb-PsDmD4kwEIsg

https://www.youtube.com/watch?v=CiqCfsTrlLA&list=PLV3ll8m0ZlppQBGJUItatmL8HU2UtmByd

4. Lightning Web Components:

Trailhead:

https://trailhead.salesforce.com/en/content/learn/trails/build-lightning-web-components

Guide:

https://developer.salesforce.com/docs/component-library/documentation/en/lwc

Blogs:

https://www.sfdc-lightning.com/p/lightning-web-components.html

Video Tutorial:

https://www.youtube.com/playlist?list=PLaGX-30v1lh2R0DmV94hqMtPSpiIT7xmO

https://www.youtube.com/watch?v=dcRM7Mq541Y&list=PLV3ll8m0Zlpog5kPVuyYc1d3CzbsNqPxK

https://www.youtube.com/watch?v=7hhdKS-yChs&list=PLgIMQe2PKPSJ0hK7DInqhLlw7QK5Pt6fD

https://www.youtube.com/watch?v=6p2Ia4XWnNw&list=PL-JzyFWuCbkKcFSOCRlCUk79YbET5QvZC

5. Integration:

Trailhead:

https://trailhead.salesforce.com/en/content/learn/modules/apex_integration_services

Guide:

https://resources.docs.salesforce.com/228/latest/en-us/sfdc/pdf/api_rest.pdf

https://resources.docs.salesforce.com/228/latest/en-us/sfdc/pdf/apex_api.pdf

Blogs:

https://www.sfdc-lightning.com/p/integration-topics.html

Video Tutorial:

https://www.youtube.com/playlist?list=PLaGX-30v1lh2Y-TZgeQWSnGQWgWHP9mPH

https://www.youtube.com/watch?v=Jcmw5WqjNwU&list=PLV3ll8m0ZlpqVOJCTFJu8uNJ-f2OppInR

https://www.youtube.com/watch?v=H7k3zlPGlkA&list=PLuL63vr-9xHzI83rrXaXHDcsfVqzrp0iO

Data Loader:

https://resources.docs.salesforce.com/228/latest/en-us/sfdc/pdf/salesforce_data_loader.pdf

https://www.youtube.com/watch?v=fnPXaq5A-2c

ANT Migration Tool:

https://resources.docs.salesforce.com/sfdc/pdf/salesforce_migration_guide.pdf

https://www.youtube.com/watch?v=i_FwNDegf_o

Marketing Cloud:

https://www.youtube.com/playlist?list=PLaGX-30v1lh34rpIP_g1Daabqq7_xvcmp

Community Cloud:

https://www.youtube.com/playlist?list=PLaGX-30v1lh0yjm8UbB-4smaykJzCsH2y

Useful Blog URLs

https://jenwlee.com/

https://automationchampion.com/

http://vinaychaturvedi.com/

https://www.simplysfdc.com/

https://www.asagarwal.com/

http://www.miraforce.net/

https://salesforceweek.ly/

https://salesforcediaries.com/

https://www.salesforceblogger.com/

https://www.sfdc-lightning.com/

https://www.apexhours.com/blog/

https://www.sfdc99.com/

https://www.jitendrazaa.com/blog/

https://blog.enree.co/

https://sfdcfanboy.com/

https://hellosnl.blogspot.com/

https://www.brcline.com/blog/category/programming/salesforce

http://www.sfdcpanda.com/

http://santanuboral.blogspot.com/?m=0

https://www.auraforce.ca/

https://sfdcmonkey.com/

http://theblogreaders.com/

https://www.sfdcpanther.com/

https://www.sfdcstuff.com/?m=0

https://nitinindora.wordpress.com/

https://www.srinivas4sfdc.com/?m=0

https://bobbuzzard.blogspot.com

Custom permissions in Salesforce

2019-06-21T12:42:00.000+05:30

Custom permissions let you define access checks that can be assigned to users via permission sets or profiles, similar to how you assign user permissions and other access settings. For example, you can define access checks in Apex that make a button on a Visualforce page available only if a user has the appropriate custom permission.

1. Create a Custom Permission.

2. Assign it to your profile.

3. Use the sample code.

Visualforce Page:

<apex:page controller="Sample">
Checking Custom Permission in Visualforce page - {!$Permission.Create_Account}
<br/><br/>
Checking Custom Permission from Apex Class - {!accessBool }
</apex:page>

Apex Controller:

public with sharing class Sample {

public Boolean accessBool {get;set;}

public Sample() {
accessBool = checkUserHasCustomPermissionAccess('Create_Account', UserInfo.getUserId());
}

public static Boolean checkUserHasCustomPermissionAccess(String permissionName, Id userId) {
Set < Id > permissionSetIds = new Set < Id >();
List < User > userList = new List < User >();
for ( SetupEntityAccess access : [ SELECT ParentId FROM SetupEntityAccess
WHERE SetupEntityId IN ( SELECT Id
FROM CustomPermission
WHERE DeveloperName = :permissionName )
])
permissionSetIds.add(access.ParentId);
userList = [ SELECT Username FROM User WHERE Id IN (
SELECT AssigneeId FROM PermissionSetAssignment
WHERE PermissionSetId IN :permissionSetIds AND AssigneeId =: userId ) ];
return userList.isEmpty() ? false : true;
}

}

Output:

Closing window in Visualforce

2018-06-21T07:46:00.004+05:30

Using JavaScript:

<apex:page showChat="false" wizard="true" sidebar="false" >

<script type = "text/javascript">
    function winClose()
    {
        self.close();
    }
</script>


<apex:commandButton onComplete = "winClose();">
</apex:page>

Using Apex PageReference :

public PageReference method(){
if(variable== null || variable == ''){
ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR,'Please enter variable'));
return null;

}else{
return new PageReference('javascript:window.close()');
}

Difference between deactivate and freeze user in salesforce

2018-06-13T11:59:00.001+05:30

In some cases, you can’t immediately deactivate a user such as when a user is selected in a custom hierarchy field or a user that’s assigned as the sole recipient of a workflow email alert. To prevent users from logging into your organization while you perform the steps to deactivate them you can freeze users.

Freezing user doesn’t make their user licenses available for use in your organization.
Deactivating a user will be available user licenses available for use in your organization.

Salesforce Interview Questions and Answers

2018-05-18T15:22:00.000+05:30

http://www.salesforce-interviewquestions.com/p/interview-questions.html?m=1

1. What is Cloud Computing ?

Ans:

Cloud Computing is an approach to provide the following services -

SAAS (Software As A Service)
PAAS (Platform As A Service)
IAAS (Infrastructure As A Service)

With this approach everything can be done in internet (Using Application, Developing Application and distributing the hardware), no need of any minimum hardware requirements and no need to install any software in local system.

2. What is Salesforce?

Ans:

Salesforce is a company which provides a web based tool called Salesforce
Salesforce by following the Cloud Computing approach, providing SAAS and PAAS
SAAS: Providing Sales, Marketing and Call Center applications as a service
PAAS: Providing Force.com platform in which we can develop Apex (Programming language similar to Core Java) and Visualforce (Mark up language similar to HTML) logic.

7. What is the architecture of the salesforce?

Ans:

MVC (Model View Controller ) Architecture Contains three components Model,View and Controller.

Model is the Database ,
View is the user interface ,
Controller is the Business Logic.

Model View Controller architecture separates the user interface layer which is called VIEW from the data layer called MODEL.

Controller layer is between Model layer and View layer. This layer connects both View and Model.

Salesforce follows MVC architecture,

In Salesforce point of view

Model component will have Standard objects and Custom objects,which will store Data.

View component defines how the data is represented. Visualforce pages, Standard pages are the view components. Page layouts,Apps and Tabs are also comes under this components.

Controller components defines the business logic. Here we have standard controller and custom controllers. Some of the components under this category are Apex classes, triggers, workflows, approvals and validation rules,(Save, Edit, New, Cancel and Delete - upon click on these button salesforce execute some logic from controller).

8. What is the difference between 15 digit and 18 digit id in Salesforce?

Ans:

In Salesforce, whenever user create any component (Object, field, tab etc...) or record then salesforce will generate an unique id with which user can identify the record or component.
After creating the record, in the URL user can see the id of the record which is of 15 digits length.
Through user interface user always see 15 digit id which is Cases-Sensitive.
If the user query the existing records from the database through API (Either from Query Tool or from a program), it will always return 18 digit id which is Case-Insensitive.
Last 3 digits of the 18 digit represents checksum of the capitalization of 15 digit id.
Based on the first 3 digits user can identify the object of the record.
All the records belongs to same object will contain same first 3 digits.

9.Object Relationships?

Ans:

Master-detail
Many-to-many
Lookup
External lookup : An external lookup relationship links a child standard, custom, or external object to a parent external object
Indirect lookup : An indirect lookup relationship links a child external object to a parent standard or custom object.
Hierarchical : A special lookup relationship available for only the user object. It lets users use a lookup field to associate one user with another that does not directly or indirectly refer to itself.

10. Difference between standard controller and custom controller ?

Ans:

Standard controller:

If VF uses Standard controllers then it contains the functionality and logic that are used for standard Salesforce pages. For example, if you use the standard Accounts controller, clicking a Save button in a Visualforce page results in the same behavior as clicking Save on a standard Account edit page.

A standard controller exists for every Salesforce object that can be queried using the Force.com API.

Custom controller:

A custom controller is an Apex class that implements all of the logic for a page without leveraging a standard controller. Use custom controllers when you want your Visualforce page to run entirely in system mode, which does not enforce the permissions and field-level security of the current user.

Override existing functionality
Make new actions available to the page
Customize the navigation
Use HTTP callouts or web services
Have greater control of how information is accessed on the page

A controller extension is an Apex class that extends the functionality of a standard or custom controller. Use controller extensions when:

You want to leverage the built-in functionality of a standard controller but override one or more actions, such as edit, view, save, or delete.
You want to add new actions.

11. What is the difference between workflow and process builder ?

Ans:

You can use the Process Builder to perform more actions than with workflow:

Create a record
Update any related record
Use a quick action to create a record, update a record, or log a call
Launch a flow
Send an email
Post to Chatter
Submit for approval
Call apex methods

But the process builder doesn’t support outbound messages.

Workflow does only 4 actions

Create Task
Update Field
Email Alert
Outbound Message

12. What is the outbound message ?

Ans:

Outbound messaging is part of the workflow rule functionality in Salesforce. Workflow rules watch for specific kinds of field changes and trigger automatic Salesforce actions, such as sending email alerts, creating task records, or sending an outbound message to external services. Outbound messages can contain database field values.

Outbound messaging uses the notifications() call to send SOAP messages over HTTP(S) to a designated endpoint when triggered by a workflow rule.

After you set up outbound messaging, when a triggering event occurs, a message is sent to the specified endpoint URL. The message contains the fields specified when you created the outbound message. Once the endpoint URL receives the message, it can take the information from the message and process it.

13. Difference between SOAP and REST API ?

Ans:

SOAP : Simple Object Access Protocol
REST : Representational State Transfer
* REST and SOAP are the two web service frameworks available on the Force.com platform.
* The SOAP API uses authentication with username and password, and communicates using XML messages. There are different API's to work with the Enterprise, Partner, Bulk, Metadata etc.
*The REST API uses HTTP to authenticate, it uses a token authentication and can use OATH to authenticate, it communicates using JSON messages.
*REST API is generally lighter weight than the SOAP API, works well with mobile applications especially.
JSON is mostly preferred as it is light weight and therefore REST API's are most suited for mobile and web applications.
* SOAP works with WSDL and REST works with GET, POST, PUT, DELETE

* SOAP Handles large data load and fit for large enterprise applications and REST Handles less data and fit for mobile and web applications.

14.How can you expose REST API ?

Ans:

https://developer.salesforce.com/page/Creating_REST_APIs_using_Apex_REST

https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_rest_code_sample_basic.htm

http://www.wadewegner.com/2013/03/creating-anonymous-rest-apis-with-salesforce-com/

Six new annotations have been added that enable you to expose an Apex class as a RESTful Web service.
At Class level

@RestResource(urlMapping='/yourUrl')

At Method Level

@HttpDelete
@HttpGet
@HttpPatch
@HttpPost - Create Only
@HttpPut - Create or Update

15. Order of Execution?

Ans:

1. Old record loaded from database (or initialized for new inserts)
2. New record values overwrite old values
3. System Validation Rules (If inserting Opportunity Products, Custom Validation Rules will also fire in addition to System Validation Rules)
4. All Apex before triggers (EE / UE only)
5. Custom Validation Rules
6. Record saved to database (but not committed)
7. Record reloaded from database
8. All Apex after triggers (EE / UE only)
9. Assignment rules
10. Auto-response rules
11. Workflow rules
12. Processes
13. Escalation rules
14. Parent Rollup Summary Formula value updated (if present)
15. Database commit
16. Post-commit logic (sending email)

16. Difference between database.query and database.QueryLocator ?

Ans:

database.query allows you to make a dynamic SOQL query at runtime. You can build up a string and then use that as a query string at run time in the database.query.
it supports 50,000 records only.

database.getQueryLocator returns a Query Locator that runs your selected SOQL query returning list that can be iterated over in batch apex.
it supports upto 50 million records.
If VF page have read only attribute, use Database.getQueryLocator().

17. What is Synchronous and Asynchronous ?

Ans:

Synchronous:
In a Synchronous call, the thread will wait until it completes its tasks before proceeding to next. In a Synchronous call, the code runs in single thread.

Example:

Trigger
Controller Extension
Custom Controller

Asynchronous:

In a Asynchronous call, the thread will not wait until it completes its tasks before proceeding to next. Instead it proceeds to next leaving it run in separate thread. In a Asynchronous call, the code runs in multiple threads which helps to do many tasks as background jobs.

Example:

Batch
@future Annotation

18. What is the difference between trigger.new and trigger.old?.When do use ?

Ans:

Trigger.new Returns a list of new version of sObject records.
Trigger.Old Returns a list of old version of sObject records.

trigger.new used in Insert and Update.

trigger.old used in Update and Delete.

No trigger.new in Delete.

No trigger.old in Insert.

– Trigger.Old is always readOnly
– We cannot delete trigger.new
– In before triggers, trigger.new can be used to update the fields on the same object.
– In After trigger, we get run time exception is thrown when user try to modify the fields in the same object.

19. How to restrict the trigger to Recursion?

Ans:

Trigger:

trigger updateTrigger on anyObject(after update) {

if(checkRecursive.runOnce()) {

//write your code here

}

Class:

public Class checkRecursive{

private static boolean run = true;

public static boolean runOnce(){

if(run){

run=false;

return true;

}else{

return run;

}

20. How many methods are available in batch apex?

Ans:

The Database.Batchable interface contains three methods that must be implemented.
Start method:

global (Database.QueryLocator | Iterable<sObject>) start(Database.BatchableContext ***bc***) {}

execute method:

global void execute(Database.BatchableContext ***BC***, list<P>){}

finish method:

global void finish(Database.BatchableContext ***BC***){}

21. Salesforce Governor limits.

Ans:

Total number of SOQL queries - 100

Total number of DMLs - 150

Total number of records retrieved by SOQL - 50000

Total number of callouts - 100
Maximum number of batch Apex jobs in the Apex flex queue - 100
Maximum number of batch Apex jobs queued or active - 5

22. What is call-out and when we can use them?
Ans:
Apex Callouts enable Apex to invoke external web services.

Each callout request is associated with an HTTP method and an endpoint. The HTTP method indicates what type of action is desired.

GET Retrieve data identified by a URL.
POST Create a resource or post data to the server.
DELETE Delete a resource identified by a URL.
PUT Create or replace the resource sent in the request body.

GET the data from server

Http http = new Http();

HttpRequest request = new HttpRequest();

request.setEndpoint('https://th-apex-http-callout.herokuapp.com/animals');

request.setMethod('GET');

HttpResponse response = http.send(request);

// If the request is successful, parse the JSON response.

if (response.getStatusCode() == 200) {

// Deserialize the JSON string into collections of primitive data types.

Map<String, Object> results = (Map<String, Object>) JSON.deserializeUntyped(response.getBody());

// Cast the values in the 'animals' key as a list

List<Object> animals = (List<Object>) results.get('animals');

System.debug('Received the following animals:');

for (Object animal: animals) {

System.debug(animal);

}

23. What is FUTURE method ?

Ans:

A future method runs in the background, asynchronously. You can call a future method for executing long-running operations, such as callouts to external Web services or any operation you’d like to run in its own thread, on its own time. You can also make use of future methods to isolate DML operations on different sObject types to prevent the mixed DML error.

24. Difference between Public and Global in Salesforce?

Ans:

public

This means the method or variable can be used by any Apex in this application or namespace.

global

This means the method or variable can be used by any Apex code that has access to the class, not just the Apex code in the same application. This access modifier should be used for any method that needs to be referenced outside of the application, either in the SOAP API or by other Apex code. If you declare a method or variable as global, you must also declare the class that contains it as global.

25. Have you used Offset in SOQL?

Ans:

The SOQL query normally returned 100 rows, you could use OFFSET 20 in your query to skip the first 20 rows and returns 21th row to 120th rows.

SELECT Name FROM Account WHERE Industry = 'Media' ORDER BY Name LIMIT 100 OFFSET 20

For example if there are 20 records then, if we specify offset as 10 in the query then it would return record 11 through 20.

OFFSET keyword can be used to implement pagination in visaulforce page tables.

26. Wrapper Class ?

Ans:

A wrapper or container class is a class, a data structure, or an abstract data type which contains different objects or collection of objects as its members

In the Visualforce most important use case is to display a table of records with a check box and then process only the records that are selected.

27. What is External ID ?

Ans:

External ID

Set the field as the unique record identifier from an external system.

You can have multiple records with the same external ID.

Unique ID field

This is a setting for the field that will prevent you from using the same value in multiple records for the unique field.

28. Exceptions in Apex ?

Ans:

SObjectException
CalloutException
DmlException
EmailException
LimitException
JSONException
ListException
NullPointerException
QueryException
StringException
TypeException
VisualforceException
RequiredFeatureMissing
NoSuchElementException
MathException
InvalidParameterValueException

29. SOQL query to get the deleted Rows also ?
Ans:
List<account> accs = [SELECT ID FROM account ALL ROWS];
System.debug(accs.size());

30. Delegate Administrative ?

Ans:

Use delegated administration to assign limited admin privileges to users in your org who aren’t administrators.

ICANN project Short Description:

ICANN (Internet Corporation for Assigned Names and Numbers) is US based a non-profit organization responsible for providing Domain name to the Requested Users.

Previously ICANN is using a Drupal system for managing the Requests raised for domain, We migrated that entire system to the Salesforce.Now when an end user requested for a domain from drupal system a Request will be created in Salesforce Org under Request object.Every Request is Related to a Domain(TLD Object in salesforce),Every TLD object is related to a Registry(Account object in salesforce),everyregistry will have Contact(Registry manager).there is a junction object which will relate many Registries to many registry managers.

Once an end user request for a domain an email will be sent to the Registry manager with request details including request Url in Community and end user details using Trigger.Registry manager can click on the link in the mail it will take them to Community there they will be able to see the all the requests and they can Accept those Requests or Decline those requests.

// prime numbers printing code
for(integer i=1;i<=90;i++)
{
integer count =0;
for(integer j=1;j<=i;j++){
if(math.mod(i,j)==0)
count++;
}
// system.debug(count);
if(count==2){
system.debug(i);
}
}

// num is prime or not checking
integer count =0;
for(integer j=1;j<=2;j++){
if(math.mod(2,j)==0)
count++;
}
if(count==2){
system.debug('yes prime number');
}
else{
system.debug('no not a prime number');
}

// displaying numbers from 100 to 1
for(integer i=0;i<100;i++)
{
integer j=100-i;
system.debug(j);

}

SDLC :

1.Planning

2..Designing

3. Building

4. Testing

5. Deploying

Restricting User to Double Click on Button in VF

2018-01-02T19:20:00.000+05:30

This post is regarding to avoid one small issue I have come across it.
Let say there is a visual force page where input fields and one button is present. When that button is clicked records are inserted in to the object. If button is clicked twice in same time(double click) then records(duplicate records ) are being created twice.

How will we avoid that?
How will restrict user to do double click on button?

Here I am sharing some snippet of code.Hope It will help you.

Page:

<apex:page standardController="Account">
<apex:form >
<apex:pageMessages id="messages"></apex:pageMessages>
<apex:pageBlock title="Avoid Doublle Click" >
<apex:pageBlockButtons location="both">
<apex:actionStatus id="saveStatus">
<apex:facet name="stop">
<apex:outputPanel >
<apex:commandButton action="{!save}" value="save" reRender="messages" status="saveStatus"/>
<apex:commandButton action="{!Cancel}" value="Cancel" immediate="true" />
</apex:outputPanel>
</apex:facet>
<apex:facet name="start">
<apex:outputPanel >
<apex:commandButton value="Saving..." disabled="true" />
<apex:commandButton value="Saving..." disabled="true" />
</apex:outputPanel>
</apex:facet>
</apex:actionStatus>
</apex:pageBlockButtons>
<apex:pageBlockSection title="Account Creating">
<apex:inputField value="{!Account.Name}"/>
</apex:pageBlockSection>
</apex:pageBlock>
</apex:form>
</apex:page>

Preventing Right Click,Copy,Paste in VF Page

2018-01-02T19:12:00.002+05:30

Everybody must have visited bank site there we can not do right click or copy Account number and paste in another field Retype Account Number. That means we should not give any chance to anybody to see page source. We do this for more security purpose.

That made me to think and try to design same in visual-force page. Here I have only used JavaScript for this functionality.

There are some snippet of code.Hopefully It will help you.

Functionality

Preventing to see the Page Source.
Preventing paste Email field value in Re Email field.

Here is the page:-

<apex:page StandardController="Contact">

function DisableRightClick(event){

if (event.button==2)

{

alert("Right Click is not Allowed");

}

function DisableCtrlKey(e){

var code = (document.all) ? event.keyCode:e.which;

if (parseInt(code)==17){

alert("Please re-type your email address");

}

</script>

<apex:form >

<apex:pageBlock title="Create Contact" onmousedown="DisableRightClick(event)">

<apex:pageBlockButtons >

<apex:commandButton value="Save" action="{!save}"/>

</apex:pageBlockButtons>

<apex:pageBlockSection columns="1">

<apex:inputField value="{!Contact.Firstname}"/>

<apex:inputField value="{!Contact.LastName}"/>

<apex:inputField value="{!Contact.Email}"/>

<apex:inputtext value="{!Contact.Email}" label="Re-Type Email Id" onKeyDown="DisableCtrlKey(event)"/>

<apex:inputField value="{!Contact.Phone}"/>

</apex:pageBlockSection>

</apex:pageBlock>

</apex:form>

</apex:page>

Visualforce Page Exactly Same as Contact Edit Page

2018-01-02T19:08:00.000+05:30

The question was there will be a link called "Copy Mailing Address to Other Address" when clicked that link all Mailing address will be copied to other address same as standard edit page of contact.
This can be done two ways.

By using java script
By using Controller extension

In the command link we have to call java script method there we will get all the field value of mailing addresss using documnet.getElementByid() method in javascript and will assign to the other address field.

Second approach is we will call extension method where will assign all the mailing address field to other address field and will reRender (refresh) the block. It will behave exactly like as standard edit page layout of Contact functionality.
Now the challenge is how will we display that command link inside that pagablock section header.

This is the page and controller

<apex:page standardController="Contact" extensions="contactEditPageExtension">
<apex:sectionHeader title="Contact Edit" subtitle="New Contact"/>
<apex:outputText value="Contacts not associated with accounts are private and cannot be viewed by other users or included in reports.">
</apex:outputText><br/><br/>
<apex:form >
<apex:pageBlock title="Contact Edit" id="test">
<apex:pageBlockButtons location="both">
<apex:commandButton value="Save" action="{!Save}"/>
<apex:commandButton value="Save & New" />
<apex:commandButton value="Cancel" action="{!Cancel}"/>

</apex:pageBlockButtons>
<apex:pageBlockSection title="Contact Information">
<apex:inputField value="{!contact.FirstName}"/>
<apex:inputField value="{!contact.LastName}"/>
</apex:pageBlockSection>
<apex:pageBlockSection title="Test">
<apex:facet name="header">
<apex:pageBlockSectionItem >
<apex:outputText value="Address Information" style="float:left;"></apex:outputText>
<apex:commandLink value="Copy Malling Address to Other Address" style="float:right;" action="{!test}" reRender="test"/>
</apex:pageBlockSectionItem>
</apex:facet>

<apex:inputField value="{!contact.MailingCountry}"/>
<apex:inputField value="{!contact.otherCountry}"/>
<apex:inputField value="{!contact.MailingStreet}"/>
<apex:inputField value="{!contact.otherStreet}"/>
<apex:inputField value="{!contact.MailingState}"/>
<apex:inputField value="{!contact.otherState}"/>

</apex:pageBlockSection>

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

My controller

public with sharing class contactEditPageExtension {
public Contact contact{get;set;}
public contactEditPageExtension(ApexPages.StandardController controller) {
//this.contact = (Contact )controller.getRecord();
contact = new Contact();
}

public void test(){
contact.otherCountry = contact.MailingCountry;
contact.otherState = contact.MailingState;
contact.otherStreet = contact.MailingStreet;
//return null;
}

}

Add/Remove Functionality in a VF page pageblock table for Creating Multiple Records For a Particular Object.

2018-01-02T18:58:00.001+05:30

I had come across a scenario where I was asked to develop some functionality where user can create list of records at a time(clicking on save button on one time) and can remove row.

Here I have created a pageblock table and there I am displaying 5 rows to enter data and there column, Name , Phone and Action. In Action column Delete link is present.When that link(Delete) is clicked then particular row will be removed. Two button is there Add Row and Save.

Add Row--> When that button is clicked one more row will be created in the pagablock table

Save--> It will save the record.

Here is the page

<apex:page controller="creatingListOfRecordsController">

<apex:form >

<apex:pageBlock title="Creating List Of Account Records">

<apex:pageMessages></apex:pageMessages>

<apex:pageBlockButtons location="top">

<apex:commandButton value="Add Row" action="{!addRow}" reRender="table" immediate="true"/>

</apex:pageBlockButtons>

<apex:pageBlockTable value="{!accountwrapperList}" var="page" id="table">

<apex:column headerValue="Name">

<apex:inputField value="{!page.account.name}"/>

</apex:column>

<apex:column headerValue="Phone">

<apex:inputField value="{!page.account.Phone}" />

</apex:column>

<apex:column headerValue="Action">

<apex:commandLink value="Delete" action="{!removingRow}" immediate="true">

<apex:param name="index" value="{!page.counterWrap}"/>

</apex:commandLink>

</apex:column>

</apex:pageBlockTable>

<apex:commandButton value="Save" action="{!saving}" />

</apex:pageBlock>

</apex:form>

</apex:page>

Here is the Controller

public with sharing class creatingListOfRecordsController {

public list<Account> accountList{get;set;}

public list<Accountwrapper> accountwrapperList{get;set;}

public Integer counter{get;set;}

public creatingListOfRecordsController(){

counter = 0;

accountList = new list<Account>();

accountwrapperList = new list<Accountwrapper>();

for(Integer i=0;i<5;i++){

Accountwrapper actWrap = new Accountwrapper(new Account());

counter++;

actWrap.counterWrap = counter;

accountwrapperList.add(actWrap);

}

public PageReference addRow(){

//accountList.add(new Account());

Accountwrapper actWrap = new Accountwrapper(new Account());

counter++;

actWrap.counterWrap = counter;

accountwrapperList.add(actWrap);

return null;

}

public PageReference removingRow(){

Integer param = Integer.valueOf(Apexpages.currentpage().getParameters().get('index'));

for(Integer i=0;i<accountwrapperList.size();i++){

if(accountwrapperList[i].counterWrap == param ){

accountwrapperList.remove(i);

}

counter--;

return null;

}

public PageReference saving(){

list<Account> updateAccountList;

updateAccountList = new list<Account>();

if(!accountwrapperList.isEmpty()){

for(Accountwrapper accountWrapper:accountwrapperList){

updateAccountList.add(accountWrapper.account);

}

if(!updateAccountList.isEmpty()){

upsert updateAccountList;

}

ApexPages.Message myMsg = new ApexPages.Message(ApexPages.Severity.Info,'Record Saved Successfully.');

ApexPages.addMessage(myMsg);

return null;

}

public class Accountwrapper{

public Account account{get;set;}

public Integer counterWrap{get;set;}

public Accountwrapper(Account act){

this.account = act;

}

The out put will be exactly like this image

Encryption and Decryption In Salesforce.

2018-01-02T18:34:00.000+05:30

Encryption, is the process of changing information in such a way as to make it unreadable by anyone except those possessing special knowledge (usually referred to as a "key") that allows them to change the information back to its original, readable form.
To encrypt some value we have to use some key value that can be hard coded or we can generate key also by using this

Blob cryptoKey = Crypto.generateAesKey(256);
We have to use same key to decrypt that value.

Here I am going to share some code.Hope it will help you. I have created one visualforce page and one controller. In the page only one field(Name) is there and two button(Save & Update).
When some value is entered in the name field and clicked on save button that value will be stored in the object encrypted format.
Now record id in the url and click on update button encrypted value will be converted in to original format.

Here is my page

<apex:page standardController="Account" extensions="EncryptionandDecryptionExtension">

<apex:form >

<apex:pageBlock >

<apex:pageBlockSection >

<apex:inputField value="{!encrypt.Name}"/>

<apex:commandButton value="Save" action="{!Save}"/>

<apex:commandButton value="Update" action="{!test}"/>

</apex:pageBlockSection>

</apex:pageBlock>

</apex:form>

</apex:page>

Here is My Controller

public class EncryptionandDecryptionExtension {

public account encrypt{get;set;}

//Blob cryptoKey;

Blob cryptoKey = Blob.valueOf('380db410e8b11fa9');

public Id recordId{get;set;}

public EncryptionandDecryptionExtension(ApexPages.StandardController controller) {

//cryptoKey = Crypto.generateAesKey(256);

recordId = Apexpages.CurrentPage().getParameters().get('id');

if(recordId !=null){

encrypt = [SELECT id,Name From account

WHERE id=:recordId];

}

else{

encrypt = new account();

}

public PageReference Save(){

Blob data = Blob.valueOf(encrypt.Name);

Blob encryptedData = Crypto.encryptWithManagedIV('AES128', cryptoKey , data );

String b64Data = EncodingUtil.base64Encode(encryptedData);

encrypt.name = b64Data ;

insert encrypt;

return null;

}

public PageReference test(){

//Blob cryptoKey = Crypto.generateAesKey(256);

//Blob data = Blob.valueOf(encrypt.Name);

Blob data = EncodingUtil.base64Decode(encrypt.Name);

Blob decryptedData = Crypto.decryptWithManagedIV('AES128', cryptoKey , data);

String dryptData = decryptedData.toString();

System.debug('Printing dryptData '+dryptData);

encrypt.name = dryptData;

update encrypt;

return null;

}

VF Using Action Global Variable Navigating to Standard Layout(Tab, Edit layout,List Layout)

2018-01-02T15:59:00.000+05:30

$Action is a global variable. A global merge field type to use when referencing standard Salesforce actions such as displaying the Accounts tab home page, creating new accounts, editing accounts, and deleting accounts.
Here I am sharing some visualforce code for the same.

<apex:page standardController="Account">

   //Navigating to new record page of Account
<apex:outputLink value="{!URLFOR($Action.Account.New)}">
Creating New Account
</apex:outputLink>

  //Navigating to Account list View
<apex:outputLink value="{!URLFOR($Action.Account.List, $ObjectType.Account)}">
Go to the Account List View
</apex:outputLink>

  //Navigating to Account tab page
<apex:outputLink value="{!URLFOR($Action.Account.Tab, $ObjectType.Account)}">
Go to the Account tab
</apex:outputLink>

  //Cloening Account Record
<apex:outputLink value="{!URLFOR($Action.Account.Clone, id)}">
Cloning record
</apex:outputLink>

   //id means record id
//Here we have to give accountid in url.

  //Editing Account Record
<apex:outputLink value="{!URLFOR($Action.Account.Edit, id)}">
Editing record
</apex:outputLink>

  //Deleting Account Record
<apex:outputLink value="{!URLFOR($Action.Account.Delete, id)}">
Deleting Account Record
</apex:outputLink>

   //submitting account record for approval
<apex:outputLink value="{!URLFOR($Action.Account.Submit for Approval, id)}">
Submitting Record for Approval
</apex:outputLink>
</apex:page>

Getting Picklist Values of an object's field Dynamically using schema Class

2017-12-26T20:48:00.000+05:30

This is very simple. I am sharing some code ,please go through this

Here is My Controller
public class testclass {
public Job__c job{get;set;}
public List<SelectOption> options{get;set;}
public testclass(){
options = new List<SelectOption>();
Schema.DescribeFieldResult fieldResult = Job__c.Status__c.getDescribe();
List<Schema.PicklistEntry> ple = fieldResult.getPicklistValues();
for( Schema.PicklistEntry f : ple){
options.add(new SelectOption(f.getLabel(), f.getValue()));
}
}
}

My Page

<apex:page controller="testclass ">

<apex:form>

<apex:pageBlock>

Order Status:<apex:selectList id="countries" value="{!job.Status__c}" size="1" required="true" >

<apex:selectOptions value="{!options}"/>

</apex:selectList>

</apex:pageBlock>

</apex:form>

</apex:page>

Creating Email template in Apex to send Custom object Data

2017-12-26T20:44:00.003+05:30

Sometimes we try to send some custom object information in mail. For sending mail Sales-force has provided 4 types of email template. We can design the template as per our requirement. We can use simple text template and use merge field to send custom object information. But that template will work perfectly only If we use in the workflow.
If we send mail from apex code then that merge field value will not be displayed, except we can display Lead ,Contact and User object information.

Instead using the Sales-force Email template, design an template in apex code (using some HTMLtags depending according to your design).
Just make a query which information you want to send and then pass these value as parameter to a method.

List<CustomObject__c> listofCustomObjects = [SELECT id, Name,.Expiration__c ,Account_Name__c
FROM CustomObject__c]
for(CustomObject__c license:listofCustomObjects ) {

Integer numberDaysDue = System.Today().daysBetween(license.Expiration__c);
String name = license.Account_Name__c;
if(numberDaysDue == 30){

sendingmail(numberDaysDue ,name );
}
}

public void sendingmail( Integer noOfdays, String accountName){

Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage() ;
String[] toAddresses = new String[] {'jewell@test.com','neha.v@test.com','sexyRadha@test.com'};
mail.setToAddresses(toAddresses) ;
mail.setSubject('LMO:'+' '+accountName+' '+'licency expiry in'+' '+noOfdays+' '+'days');

String body = '<html lang="ja"><body>'+
'<br><br>'+'This email alert is to bring to your notice that the licence of the client :'+' '+'<b>'+accountName+'</b>'+' '+'is going to expiry within'+'<b>'+' '+noOfdays+' '+'</b>'+
'<br><br>'+'From LMO Alert Service'+'</body></html>';
mail.setHtmlBody(body);
Messaging.sendEmail(new Messaging.SingleEmailMessage[] { mail });

}

How to use Date Time Variable in Dynamic Query Salesforce

2017-12-26T20:37:00.000+05:30

In some scenario you might have come across to fetch record with in some date time range.
Here I am sharing some code for this. Suppose I am querying records from Minutes Object. There is two field Start_Time and End_Time present in Minutes Object.
This is my page

<apex:inputField value="{!minute.Start_Time__c}" required="true" label="From Date"/>
<apex:inputField value="{!minuteObj.End_Time__c}" required="true" label="To Date"/>
<apex:commandButton action="{!convertValidMinutesToUsage}" value="Process Minute's"/>

This is my controller
public with sharing class ControllerValidMinutesToUsage {
public Minute__c minute{get;set;}
DateTime startDate;
DateTime endDate;
string query;

public ControllerValidMinutesToUsage(){
minute = new Minute__c();
}

public void convertValidMinutesToUsage(){
String sStartdate;
String sEndDate;
startDate = minute.Start_Time__c;
sStartdate = startDate.format('yyyy-MM-dd\'T\'HH:mm:ss\'Z\'');
endDate = minuteObj.End_Time__c+1;
sEndDate = endDate.format('yyyy-MM-dd\'T\'HH:mm:ss\'Z\'');
query = 'SELECT Start_Time__c ,End_Time__c, Is_Valid__c WHERE Is_Valid__c = false';
query += ' AND Start_Time__c >='+sStartdate+' '+'AND Start_Time__c <='+sEndDate
list<Minute__c> = DateBase.query(query );
}
}

NOT IN Keyword in Soql in Salesforce.( Fetching all accounts record which don't have any contacts )

2017-12-26T20:29:00.002+05:30

Suppose there is a requirement to fetch all accounts record which don't have any contacts,
how will we do it?

We can fetch account with their corresponding contact record in a in line query.
for example
list<Account> listOfAccounts = [SELECT id, Name,
(SELECT id,name FROM Contacts)
FROM Accounts];
list<Account> accountListwithoutContact = new list<Account>();

for(Account act :listOfAccounts ){
if(act .Contacts !=null && act .Contacts.size() !=0){
accountListwithoutContact.add(act) ;
}

}

accountListwithoutContact list will contain all account which dont have any contacts.

Second approach would be using NOT IN keyword.
list<Account> listOfAccounts = [SELECT id, Name
FROM Account
WHERE id NOT IN (SELECT AccountId FROM Contact)];
Now this is the final list which contains all accounts which don't have any contact.

Fetching Unique Record in Salesforce

2017-12-26T20:22:00.002+05:30

lIST<AggregateResult> listofAccountsAggregateResult = [SELECT Name FROM Account GROUP BY Name];

It will return unique record of Accounts

Visualforce Adding CheckBox as header to Select all the records in Pageblock Table

2017-12-26T19:35:00.003+05:30

I have faced some requirement in my development work . User must be able to select all the record in the page block table in one click . So I added header check-box in page block table .

Here is the code how I achieved this. Only Java Script code I have used .

Page

<apex:page controller="ControllerforheaderCheckboxinPBT">

<script type="text/javascript">

function checkAll(cb){

var inputElem = document.getElementsByTagName("input");

for(var i=0; i<inputElem.length; i++){

if(inputElem[i].id.indexOf("checkedone")!=-1)

inputElem[i].checked = cb.checked;

}

</script>

<apex:pageMessages />

<apex:form >

<apex:pageBlock Title="ALL CONTACTS" >

<apex:commandButton value="mass delete" action="{!massdelete}" id="massdelete" onclick="return confirmDelete()"/>

<apex:pageBlockTable value="{!Contacts}" width="100%" var="c" cellpadding="2" border="1" rowClasses="odd,even" styleClass="tableClass" id="opp_table">

<apex:column >

<apex:facet name="header">

<apex:inputCheckbox >

<apex:actionSupport event="onclick" action="{!GetSelected}" onsubmit="checkAll(this)" rerender="opp_table" status="newStatus"/>

</apex:inputCheckbox>

</apex:facet>

<apex:inputCheckbox value="{!c.selected}" id="checkedone">

<apex:actionSupport event="onclick" action="{!GetSelected}" rerender="opp_table"/>

</apex:inputCheckbox>

</apex:column>

<apex:column headervalue="AccountName" styleClass="showline">

<apex:outputField value="{!c.con.AccountId}" />

</apex:column>

</apex:pageBlockTable>

</apex:pageBlock>

</apex:form>

</apex:page>

My Controller..

public with sharing class ControllerforheaderCheckboxinPBT {

public Contact contact{get;set;}

public Id contactId{get;set;}

List<ContactWrapper> contactList = new List<ContactWrapper>();

List<Contact> selectedContacts = new List<Contact>();

public ControllerforheaderCheckboxinPBT() {

Contact contact = new Contact();

}

public List<ContactWrapper> getContacts() {

for(Contact c: [SELECT Id,Name,Accountid,loginURL__c,Account.Name,MobilePhone,Email FROM Contact ORDER BY createdDate DESC]){

contactList.add(new ContactWrapper(c));

}

return contactList;

}

public PageReference getSelected() {

System.debug('======Inside the Get Function======');

selectedContacts.clear();

//adding contacts in list

for(ContactWrapper conWrapper: contactList) {

if(conWrapper.selected == true) {

conWrapper.isChanged = true;

selectedContacts.add(conWrapper.con);

}

return null;

}

public PageReference massDelete() {

//deleting that list

if(selectedContacts.size()>0){

delete selectedContacts;

}

//showing an message to select one contact

else{

ApexPages.addMessage(new ApexPages.message(ApexPages.severity.ERROR,'Please select at least one Contact.'));

return null;

}

PageReference headerCheckboxPage = new PageReference('/apex/headerCheckboxinPBT');

headerCheckboxPage .setRedirect(true);

return headerCheckboxPage ;

}

public class ContactWrapper {

public Contact con{get; set;}

public Boolean selected{get; set;}

public ContactWrapper(Contact c) {

con = c;

selected = false;

}

Salesforce Adding Custom Clone Button In Account

2017-12-26T19:32:00.001+05:30

This is a very simple post. We all have seen clone button is present in Standard and Custom Object record except Account. User may expect clone button in Account object also. For them I have done little work around.
When we will create custom button we will find three content source.

URL
OnCick JavaScript
Visulforce page

By using all there we can do clone functionality. But the best choice will be my favorite URL.

Process

Go to Customize, Account ,Buttons, Links, and Actions
Click on New Button or Link
Enter Label as Clone
Choose Display Type as Detail Page Button
Choose Behavior as Display in existing window without header and side bar.
Content Source as URL
Enter this URL--https://ap1.salesforce.com/{!Account.id}/e?clone=1&retURL=%2F{!Account.Id}
Click on Save
Now add Clone button in layout.

Let's disccuss something about this URL

https://ap1.salesforce.com/{!Account.id}/e?clone=1&retURL=%2F{!Account.Id}

Red color text represent your instance name-

e- Edit mode-Record will open in edit mode

Visualforce Displaying Image in Pdf

2017-12-26T19:29:00.002+05:30

I have come across a scenario image is not appearing in pdf sometimes.For this I have shared some tricks.
It is very easy to display an image in Visulaforce page.
Process

Crate a static resource and store that image
Click in View file link
Copy the url
Add apex:image tag in vf page.

<apex:image url = "https://ap1.salesforce.com/resource/logo" width="180" height="60" />

Image will be displayed. When you render that page as pdf then sometimes image will not be appear.

To appear image every time, I have done some work around and I would love to share it.

Lets talk about the image url --- "https://ap1.salesforce.com/resource/1380178695000/logo".

All must be familiar with each term except this 1380178695000. What is that value?

This is nothing but the lastmodifiedtime of static resource.1380178695000 must be dynamic. To get dynamic value I have used some function SystemModStamp.

Here is my page and Controller.

<apex:page controller="ImageController" renderAs="pdf" >
<table>
<tr>
<td>
<div>
<apex:image value="{!sLogo}" width="180" height="60" />

</div>
</td>
</tr>
</table>

</apex:page>

Controller is

public with sharing class ImageController {
public String sLogo {get;set;}
public ImageController(){
list<StaticResource> listOfStaticResources = [SELECT Id,SystemModStamp
FROM StaticResource
WHERE Name = 'logo'];

if(!listOfStaticResources.isEmpty()) {
sLogo = '/resource/'+listOfStaticResources[0].SystemModStamp.getTime()+'/logo';

System.debug('Printing after slogo'+sLogo );
} else {
//sLogo = (invoiceit_s__Configuration__c.getValues('COMPANY_LOGO').invoiceit_s__String_Value__c);
}
}
}

Now image will appear in pdf all time.

VisualForce Charting in Salesforce

2017-12-26T19:22:00.002+05:30

As salesforce has given us the functionality of report and dashboard to create chart then what is the use of visualforce charting?.

In some situations existing functionality of salesforce can not meet our requirement properly . Suppose there is a requirement to compose custom pages that combine charts and data tables in ways that are more useful to our organization.In that case visual force charting is useful.There are also other way to meet this requirement. We can use Google chart Api for this.In my previous post I have explained.

Visualforce charting gives you an easy way to create customized business charts, based on data sets you create directly from SOQL queries, or by building the data set in your own Apexcode. By combining and configuring individual data series, you can compose charts that display your data in ways meaningful to your organization.

Visualforce charts are rendered client-side using JavaScript. This allows charts to be animated and visually exciting, and chart data can load and reload asynchronously, which can make the page feel more responsive.

This is the my page and controller.

<apex:page controller="OppsControllernew" tabStyle="Account">
<apex:form >
<apex:pageBlock >
<apex:pageBlockSection title="Chart With Table">
<apex:outputPanel style="float:left;">
<apex:chart data="{!Opportunities}" width="500" height="250">
<apex:axis type="Numeric" position="left" fields="Amount" title="Amount"/>
<apex:axis type="Category" position="bottom" fields="Name" title="Name"/>

<apex:barSeries orientation="horizontal" axis="left" xField="Amount" yField="Name"/>

<apex:legend position="right"/>
</apex:chart>

<apex:chart data="{!Opportunities}" width="500" height="250">
<apex:axis type="Category" position="bottom" fields="Name" title="Name" />
<apex:axis type="Numeric" position="left" fields="Amount" title="Amount" grid="true"/>
<apex:lineSeries axis="left" fill="true" xField="Name" yField="Amount" markerType="cross" markerSize="4" markerFill="#FF0000"/>
</apex:chart>
</apex:outputPanel>

<apex:outputPanel style="float:right;margin-right:4cm;height:600px;width:400px;" >
<p><b> Opportunity Table</b></p><br/>
<apex:pageBlockTable value="{!Opportunities}" var="opp">
<apex:column headerValue="Opportunity" value="{!opp.Name}"/>
<apex:column headerValue="Amount" value="{!opp.amount}"/>
<apex:column headerValue="Created Date" value="{!opp.createddate}" style="width:80px"/>
</apex:pageBlockTable>
</apex:outputPanel>
</apex:pageBlockSection>
</apex:pageBlock>
</apex:form>
</apex:page>

My controller is

public class OppsControllernew {

// Get a set of Opportunities

public ApexPages.StandardSetController setCon {
get {
if(setCon == null) {
setCon = new ApexPages.StandardSetController(Database.getQueryLocator(
[SELECT Name, Type,createddate, Amount, Closedate FROM Opportunity]));
setCon.setPageSize(5);
}
return setCon;
}
set;
}

public List<Opportunity> getOpportunities() {
return (List<Opportunity>) setCon.getRecords();
}

}

A Visualforce chart binds to the source of its data through the data attribute on the <apex:chart> component.
Here data source is sObjects that is Opportunity.
Data can be

Name of java script function
Non-Salesforce data sources by building a JavaScript array
Apex wrapper objects

The object field names used as data attributes are case-sensitive in JavaScript while field names in Apex and Visualforce are case-insensitive. Be careful to use the precise field name in the fields, xField, and yField attributes of axes and data series components, or your chart will silently fail.Make sure all the name perfectly equal between fields , xFields and yFields.

Limitations Of Visualforce Charting

Visualforce charts only render in browsers which support scalable vector graphics (SVG).
Visualforce charts won’t display in pages rendered as PDFs
Dynamic (Apex-generated) charting components are not supported at this time

Now the final out put will be like this