When RDBMS is avoided?
RDBMS efficiency is very less for the below scenarios Storing images and video Processing images and video Storing and processing other large files. Example: PDFs, Excel files Processing large blocks ....
Category: Salesforce
How to get Account’s State, City, Country fields in Visualforce page?
Billing Address Fields: BillingStreet BillingCity BillingCountry BillingState BillingPostalCode Sample SOQL: SELECT BillingStreet, BillingCity, BillingCountry, BillingState, BillingPostalCode FROM Account
How to track more than 20 fields values in Salesforce?
Write a tirgger and create a Chatter feed. Sample Trigger: trigger FieldHistory on Member__c (after insert, after update) { Map<Id, Member__c> MemberMap = trigger.oldMap; List<FeedItem> FIList = new List<FeedItem>(); if(trigger.isInsert) ....
How to refresh Apex variable inside Javascript in Visualforce page?
To refresh Apex variable inside Javascript in Visualforce page, move the Javascript inside apex:outputPanel and rerender the apex:outputPanel to refresh Apex variable inside Javascript. Don't keep the Javascript snippet in ....
Test Class for Batch Apex in Salesforce
Sample Batch Class: Test class for above Batch Class: @isTestpublic class AccountUpdateTest { static testMethod void test() { Database.QueryLocator QL; Database.BatchableContext BC; List<Account> AcctList = new List<Account>(); AccountUpdate AU = ....
How to store value checked by checkbox ( on the VF page ) in the database with controller?
Sample Code: Visualforce page: <apex:page controller="Sample"> <apex:form > <apex:pageblock > <apex:pageBlockSection > <apex:panelGrid columns="2"> Name : <apex:inputText value="{!Nam}"/> Skilled : <apex:inputCheckbox value="{!Skilled}"/> ....
How to give SOQL limit size dynamically for retrieving records using Apex in Salesforce?
Sample Code: Visualforce page: <apex:page controller="Sample"> <apex:form > <apex:pageblock > <apex:pageBlockTable value="{!MemList}" var="M"> <apex:column value="{!M.Name}"/> </apex:pageBlockTable> </apex:pageblock> </apex:form> </apex:page> Apex Controller: public class Sample { ....
How open in a new Tab for PageReference?
To open the URL in a new Tab for PageReference, kindly use <apex:commandLink/>. Sample Code: Visualforce page: <apex:page controller="Sample"> <apex:form > <apex:pageblock > <apex:commandlink action="{!openSearch}" target="_blank" style="text-decoration:none;"> ....
How to get Date from DateTime field using Apex in Salesforce?
Date() can be used to get the date from datetime field. Sample Code: Datetime LastModifiedDateTime = Datetime.now(); System.debug( 'LastModifiedDateTime is ' + LastModifiedDateTime ); Date ModifiedDate = LastModifiedDateTime.Date(); System.debug( 'ModifiedDate is ....
Capture Salesforce User Deactivation Date Time
1. Create a Custom Field on the User object to store the user deactivate date time. 2. Use the following sample trigger on the User object. Sample Code: trigger UserTrigger ....