Dynamically Querying PickList for Standdard and Custom Field in Apex

By
You can refer below sample example in order to get an idea.
VF
--------------------------
<apex:page Controller="DynamicPickListCtrl">
    <apex:form >
        <apex:pageMessages />
        <apex:pageBlock >
            <apex:pageBlockSection columns="2">
                <apex:pageblockSectionItem >
                    <apex:outputLabel value="SLA"/>
                </apex:pageblockSectionItem>
                <apex:pageblockSectionItem >
                    <apex:selectList value="{!SLA}" size="1" >
                        <apex:selectOptions value="{!slaOptiions}"/>
                    </apex:selectList>
                </apex:pageblockSectionItem>
            </apex:pageBlockSection>
        </apex:pageBlock>
    </apex:form>
</apex:page>
----------------------

Controller
--------------------------------
public class DynamicPickListCtrl {
 public String SLA {
  get;
  set;
 }

 public DynamicPickListCtrl() {

 }

 public List < SelectOption > getslaOptiions() {
  List < SelectOption > options = new List < SelectOption > ();
  options.add(new selectOption('None', '--- None ---'));
  Schema.DescribeFieldResult fieldResult = Account.SLA__c.getDescribe();
  List < Schema.picklistEntry > ple = fieldResult.getPicklistValues();
  for (Schema.picklistEntry f: ple) {
   options.add(new selectOption(f.getLabel(), f.getValue()));
  }
  return Options;
 }
}
-----------------------------------

I hope this will help you.


Generic Method for getting pick as List<String>
---------------------------------------------------------------
 public static List < String > getPicklistValues(String ObjectApi_name, String Field_name) {

  List < String > lstPickvals = new List < String > ();
  Schema.SObjectType targetType = Schema.getGlobalDescribe().get(ObjectApi_name); //From the Object Api name retrieving the SObject
  Sobject Object_name = targetType.newSObject();
  Schema.sObjectType sobject_type = Object_name.getSObjectType(); //grab the sobject that was passed
  Schema.DescribeSObjectResult sobject_describe = sobject_type.getDescribe(); //describe the sobject
  Map < String, Schema.SObjectField > field_map = sobject_describe.fields.getMap(); //get a map of fields for the passed sobject
  List < Schema.PicklistEntry > pick_list_values = field_map.get(Field_name).getDescribe().getPickListValues(); //grab the list of picklist values for the passed field on the sobject
  for (Schema.PicklistEntry a: pick_list_values) { //for all values in the picklist list
   lstPickvals.add(a.getValue()); //add the value  to our final list
  }

  return lstPickvals;
 }

 ---------------------------------------------------------------


Generic Method for getting pick as List < SelectOption >
---------------------------------------------------------------
 public static List < SelectOption > getPicklistValues(String ObjectApi_name, String Field_name) {

  List < SelectOption > options = new List < SelectOption > ();
  Schema.SObjectType targetType = Schema.getGlobalDescribe().get(ObjectApi_name); //From the Object Api name retrieving the SObject
  Sobject Object_name = targetType.newSObject();
  Schema.sObjectType sobject_type = Object_name.getSObjectType(); //grab the sobject that was passed
  Schema.DescribeSObjectResult sobject_describe = sobject_type.getDescribe(); //describe the sobject
  Map < String, Schema.SObjectField > field_map = sobject_describe.fields.getMap(); //get a map of fields for the passed sobject
  List < Schema.PicklistEntry > pick_list_values = field_map.get(Field_name).getDescribe().getPickListValues(); //grab the list of picklist values for the passed field on the sobject
  for (Schema.PicklistEntry a: pick_list_values) { //for all values in the picklist list
   options.add(new selectOption(a.getLabel(), a.getValue()));
  }

  return options;

 }

---------------------------------------------------------------

 I hope this will help you.

Have almost 7 years of experience and expertise in Core Java, JDBC, Servlet, JSP, Java Web Services and Struts, Oracle Database, MS SQL Server,Apex,Visual Force,Force.com platform. Good Experience on Oracle CRM ON DEMAND, Sales force CRM with ability to work independently and in a team environment. Good Analytical & Reasoning skills. Strongly creative in learning new technologies and systems, extremely passionate to work in a challenging place. Apart from that, I have very vast experience in integration and data migration from one system to other system. Certifications: 1. Salesforce Certified Platform Developer I 2. Salesforce Certified Administrator 3. Salesforce Certified Sales Cloud Consultant 4. Salesforce Certified Service Cloud Consultant 5. Oracle Certified Java Developer 6.Oracle Certified Web Component Developer 7. Oracle Certified SQL Associate

Comments

Post a Comment

Popular posts from this blog

Custom Setting Creation in Apex Test Class

By
Please refer following approach to insert/update custom setting record in test class. @isTest(SeeAllData=FALSE) private class YouTestClass {     //Initialize custom settings to prevent test failures     // replace Dreamhouse_Settings__c  = your custom setting name     private static Dreamhouse_Settings__c customSettingInstance;       static {         customSettingInstance = new Dreamhouse_Settings__c ();         customSettingInstance. LIFX_Token__c = '';         upsert customSettingInstance;     }       static testMethod void yourTestMethod() {               Test.startTest();         //Your unit test here         Test.startTest();     } } I hope this will help you.
Read more

System.AsyncException: The Apex job named is already scheduled for execution.

By
System.AsyncException: The Apex job named is already scheduled for execution. Hi All, When i was trying to schedule my class for every 15 miuntes to run. I was getting below error. System.AsyncException: The Apex job named "Global App Logs Purge" is already scheduled for execution. e.g. Schedular_GlobalAppLogPurgeBatch globalPurgeBatchSchedular = new Schedular_GlobalAppLogPurgeBatch(); System.schedule(' Global App Logs Purge ', '0 0 * * * ? *', globalPurgeBatchSchedular); System.schedule(' Global App Logs Purge ', '0 15 * * * ? *', globalPurgeBatchSchedular); System.schedule(' Global App Logs Purge ', '0 30 * * * ? *', globalPurgeBatchSchedular); System.schedule(' Global App Logs Purge ', '0 45 * * * ? *', globalPurgeBatchSchedular); When i change the all the 4 job name from " Global App Logs Purge " to "Global App Logs Purge 1 ","Global App Logs Purge 2 ","Global...
Read more

Salesforce Trace Log Query Using Apex

By
Image
To activate debug logging for users, Apex classes, and Apex triggers, configure trace flags and debug levels in the Developer Console or in Setup. Each trace flag includes a debug level, start time, end time, and log type. The trace flag’s log type specifies the entity you’re tracing. You can navigate to Setup->Debug then you will see the below screen for trace logs configured in your instance. If you want to query Trace Log for your instance using Apex then you can use following SOQL query for the same. But please check API Tooling checkbox in developer console while querying. 1. To Query all trace log SELECT Id, CreatedDate, CreatedById, ExpirationDate, LogType,TracedEntityId,TracedEntity.Name, ApexCode, ApexProfiling, Callout, Database, System, Validation, Visualforce, Workflow FROM TraceFlag 2. To Query trace log only for class SELECT Id, CreatedDate, CreatedById, ExpirationDate, LogType,TracedEntityId,TracedEntity.Name, ApexCode, ApexProfiling, Call...
Read more

AJAX Toolkit Debug Shell

By
You want to browse through the fields, attributes, and relationships of every object in your Salesforce.com organization. There are lots of ways to do this. But I feel productive when I use Ajax Toolkit Debug Shell. To navigate to the Ajax Toolkit Debug shell you please follow the below steps. Step 1: You need to navigate to below URL depending on your environments. Sandbox:  https://test.salesforce.com/soap/ajax/15.0/debugshell.html Production:  https:/login.salesforce.com/soap/ajax/15.0/debugshell.html Developer:  https:/login.salesforce.com/soap/ajax/15.0/debugshell.html Step 2: if it asks you to login then please execute below the line with your credentials. sforce.connection.login("MyName@myISP.com", "myPassword") Step3: To query field of Account, please fire below query. sforce.connection.describeSObject("Account")
Read more

Error : "Trigger must be associated with a job detail"

By
Error : "Trigger must be associated with a job detail" Hi All, I was just trying to schedule my schedulable class ' Schedular_GlobalAppLogPurgeBatch ' in Apex. That time I was facing this error. Error : "Trigger must be associated with a job detail" e.g. Schedular_GlobalAppLogPurgeBatch globalPurgeBatchSchedular = new Schedular_GlobalAppLogPurgeBatch(); System.schedule(' Global App Logs Purge ', '0 0 * * * ? *', globalPurgeBatchSchedular); you can notice there is a space after " Global App Logs Purge ", when I removed this extra space from the name (" Global App Logs Purge ") my class was scheduled as expected. Corrected Space from code: Schedular_GlobalAppLogPurgeBatch globalPurgeBatchSchedular = new Schedular_GlobalAppLogPurgeBatch(); System.schedule(' Global App Logs Purge ', '0 0 * * * ? *', globalPurgeBatchSchedular); I hope this will help you.
Read more

How to Query All the batch classes in your Salesforce Instance using APEX

By
You can use the following scripts to know the batch classes in your Salesforce instance. List asyncApexJobList = [select ApexClassId, Id, JobItemsProcessed, JobType, Status, NumberOfErrors, MethodName from AsyncApexJob where JobType in ('BatchApexWorker','BatchApex')]; List idList = new List (); for(AsyncApexJob eachRecord:asyncApexJobList){ idList.add(eachRecord.ApexClassId); } List apexClassList = [Select Name from ApexClass where Id IN:idList]; for(ApexClass eachApexClass : apexClassList){ System.debug(eachApexClass.Name); } Additionally, You can use above to get all schedulable and other classes by adding the JobType filter. The possible values for JobType are: Future SharingRecalculation ScheduledApex BatchApex BatchApexWorker TestRequest TestWorker ApexToken Queueable Also, you can use the above script to find the status of the job as well by adding a filter on AsyncApexJob. Type. The possible values are: Holding Queued P...
Read more

Prefix List Of Salesforce Object

By
Record ID Prefix Decoder Entity Prefix ACCOUNT '001' QUOTE  '0Q0' NOTE '002' CONTACT  '003' USERS '005' OPPORTUNITY  '006' ACTIVITY '007' OPPORTUNITY_HISTORY '008' FORECAST_ITEM '00A' FILTER '00B' DELETE_EVENT '00C' ORGANIZATION '00D' USER_ROLE '00E' QUEUE '00G' GROUPS '00G' PARTNER  '00I' OPPORTUNITY_COMPETITOR '00J'  OPPORTUNITY_CONTACT_ROLE '00K' CUSTOM_FIELD_DEFINITION '00N' REPORT '00O' ATTACHMENT '00P' LEAD '00Q' IMPORT_QUEUE '00S' TASK '00T' EVENT '00U' EMAIL_TEMPLATE '00X' EMAIL_TEMP '00Y' COMMENTS '00a' CUSTOM_RESOURCE_LINK '00b' TRAINING '00c' PROFILE '00e' MH_BLUESHEET '00f' MH_GOLDSHEET '00g' LAYOUT  '00h' PRICEBOOK_MAPPING  '00i' PRICEBOOK_ENTRY_MAPPING '...
Read more

how to get object name from id / prefix value in salesforce

By
Standard and Custom Objects in Salesforce have three character prefixes which form the first part of the record ID.  For example, a User record with ID 00561000000Mjya has the prefix 005, which is the prefix for the User object.  To get an Id from RecordId / Record Prefix, you can use below class. ---------------------------------------------------------------------------------------------------- public class SchemaGlobalDescribe{     public static String findObjectNameFromRecordIdPrefix (String recordIdOrPrefix){         String objectName = '';         try{             //Get prefix from record ID             //This assumes that you have passed at least 3 characters             String myIdPrefix = String.valueOf(recordIdOrPrefix).substring(0,3);                     ...
Read more

Creating Salesforce Developer Account

By
Image
To start with any technology/language, we need to setup environment first. As far as salesforce development environment is concerned, we no need to install anything locally to start with. You just need to provide basic information about you and you will get salesforce environment with username and password. In addition, you can access this environment any where if you have any browser like google chrome , IE or any other browser with internet.  Step 1 : Please click below link to get the salesforce environment. After clicking below url, you see the following page. Once you are able to register successfully then you will get an activation link to your provided email in order to reset the password.  https://developer.salesforce.com/signup Step 2 : Once you reset your password, it will redirect you to salesforce login page. In case, it is not redirecting due to any reason then you can click below link to login to salesforce. The login page will look like a...
Read more