Custom Setting

Custom Setting

 Custom Settings is an essentially custom object that is exposed in the applications cache and accessible via their own API. Custom setting will give us to use in SOQL and there is no limit of fields and also use custom settings in formula fields, validation rules, Apex code and the Web Services API.

     * Provide advanced application personalization and customization

    * Deliver efficient cached data access by user.

How to Create Custom Setting?

Go to SetupàApp Set upàDevelopàCustom SettingàNew

Custom Setting Definition Page will open enter the required fields value.

Like Label: OpportunityAction

       Object: Opportunity.

      Setting Type: List

       Visibility: Public

     Description: Created for which action.

Setting Type (A List type defines application-level data, such as country codes, that is stored in the application cache. A Hierarchy type defines personalization settings, such as default field values, that can be the overridden at the organization, profile, or user level).

Add New Two Custom Fields this declaration of Oppty fields and related list: Click on New Button

1) Label: API Name

        Data Type: Text

        Length: 200

2) Label: Object

        Data Type: Text

        Length: 200

Etc.

Click on Manage Button and enter all fields which you want to in SOQL.

1) Label: Account Name

    API Name: AccountId

    Object: Opportunity

2) Label: Agents

   API Name: Agents__c

   Object: Operations_Service__c

Etc.

Apex class Code:

Object Following example is for the fetching the fields from Custom Setting and insert the record.

List<OpportunityAction__c> FieldList =[Select API_Name__c,Object__c fromOpportunityAction__c];

Map<String,Set<String>> objectFieldsList= newMap<String,Set<String>>();

for(OpportunityAction__c field:FieldList){

            Set<String> temp= objectFieldsList.get(field.Object__c);

            if(temp!=null){

                 temp.add(field.API_Name__c);

            }

            else{

                temp = new Set<String>();

                temp.add(field.API_Name__c);

            }

            objectFieldsList.put(field.Object__c,temp);

      }

//this for loop picks up the API names of all fields against the object OpportunityAction__c in custom setings

      for(String OpptyField:objectFieldsList.get(OpportunityAction__c')){

        if(OppQuery!=''){

            OppQuery=OppQuery+' , ';

        }

        OppQuery = OppQuery + OpptyField;

      }

OppQuery ='Select ' + OppQuery + ' from OpportunityAction__c WHERE Id =\'' + ids + '\' ';

OpportunityAction__c objOppty=Database.query(OppQuery);       

      insertOpportunity = objOppty.clone(false);   

try{

insert insertOpportunity;

}catch(Exception ex){

           msg='';

           System.debug('Exception 1 : '  +ex);

           Database.rollback(sp);

      }     

Conclusion:  As above example we can fetch number of fields in our code and made dynamic SOQL. This feature is very important for our dynamic SOQL and client flexible reqiurment.