Salesforce Developer Community

Sampath Reddy 15
NEWBIE
5 Points
Member since 2017

Chatter

Feed
0

Best Answers
0

Likes Received
0

Likes Given
3

Questions
3

Replies

How to get the picklist values from wrapper (Fieldset) to lightning component controller

Apex:
public class JobRequisitionFields {
    private static String WhereClause;
    public class SearchResult
    {
        @AuraEnabled public List<Job_Requisition__c> jobRequisitionList;
        @AuraEnabled public List<FieldDetails> fieldSetdetails;
        @AuraEnabled public List<JobSearchWrapper> jobSearchWrapper;
    }
    public class FieldDetails
    {
        @AuraEnabled public string fieldType{ get; set; }
        @AuraEnabled public string fieldAPIName{ get; set; }
        @AuraEnabled public string fieldLabel{ get; set; }
        @AuraEnabled List<PickListOption> pickListOptionList {get;set;}
    }
    public class PickListOption
    {
        @AuraEnabled public string label {get; set; }
        @AuraEnabled public string value {get; set; }
    }
    public class JobSearchWrapper
    {
        @AuraEnabled public String jobRecordField{set;get;}
        @AuraEnabled public String operator{set;get;}
        @AuraEnabled public String value{set;get;}
        @AuraEnabled public String fielddatatype{set;get;}
    }
    @AuraEnabled
    public static List<FieldDetails> getJobRequisitionFields(String jobrecordField)
    {
        system.debug('Field value inside getJobRequisitionFields() is: '+jobrecordField);
        Schema.DescribeSObjectResult a_desc = Job_Requisition__c.sObjectType.getDescribe();
        List<FieldDetails> fieldDetailsList = new List<FieldDetails>();
        for(String jobField : a_desc.fields.getMap().keySet()){
             PickListOption pickListOption = new PickListOption();
            if(jobField.contains('__c') || jobField == 'Name' ){
                Schema.SObjectField field = a_desc.fields.getMap().get( jobField );
                Schema.DescribeFieldResult fieldResult = field.getDescribe();
                FieldDetails fieldDetails = new FieldDetails();
                fieldDetails.fieldAPIName =fieldResult.getName();
                fieldDetails.fieldLabel = fieldResult.getLabel();
                fieldDetails.fieldType = String.valueOf(fieldResult.getType());
                fieldDetailsList.add(fieldDetails);
                system.debug('Fieldtype inside getJobRequisitionFields is: '+fieldDetails.fieldType);
                system.debug(fieldDetails.fieldAPIName);
                if(fieldDetails.fieldType == 'PICKLIST'){
               system.debug('Inside if '+fieldResult.getPicklistValues());
                    list<PickListOption> pickListOptionList = new list<PickListOption>();
                    list <Schema.PicklistEntry> values = fieldResult.getPickListValues();
                   for (Schema.PicklistEntry picklist: values) {
                           pickListOption.label = picklist.getLabel();
                            pickListOption.value = picklist.getValue();
                            system.debug('@@@@@@@@   '+pickListOption.value);
                            pickListOptionList.add(pickListOption);
                        }
                    system.debug('*****pickListOptionList '+pickListOptionList);
                }else{
                    pickListOption.value =' ';
                }

            }
        }
        System.debug('22222222222222222222222222 '+fieldDetailsList);
        return fieldDetailsList;
    }

    @AuraEnabled
    public static List<PickListOption> findPicklistOptions(string pickListVal) {
        list<PickListOption> pickListOptionList = new list<PickListOption>();
        Map<String, Schema.SObjectType> schemaMap = Schema.getGlobalDescribe();
        Schema.sObjectType objType = schemaMap.get(pickListVal);
        Schema.DescribeSObjectResult objDescribe = objType.getDescribe();
        map < String, Schema.SObjectField > fieldMap = objDescribe.fields.getMap();
        list < Schema.PicklistEntry > values = fieldMap.get(pickListVal).getDescribe().getPickListValues();
        PickListOption picklistDetails = new PickListOption();
        for (Schema.PicklistEntry picklist: values) {
            PickListOption pickListOption = new PickListOption();
            pickListOption.label = picklist.getLabel();
            pickListOption.value = picklist.getValue();
            pickListOptionList.add(pickListOption);
        }
        system.debug('*****pickListOptionList'+pickListOptionList);
        return pickListOptionList;
    }

    @AuraEnabled
    public static List<FieldDetails> getFields()
    {
        system.debug('inside the field sets ');
        List<FieldDetails> fieldDetailList = new List<FieldDetails>();
        for(Schema.FieldSetMember fieldMember : SObjectType.Job_Requisition__c.FieldSets.JobSearchFieldset.getFields()){
            system.debug(fieldMember);
            FieldDetails fieldDetails= new FieldDetails();
            fieldDetails.fieldType = String.valueOf(fieldMember.getType());
            fieldDetails.fieldAPIName = fieldMember.getFieldPath();
            fieldDetails.fieldLabel = fieldMember.getLabel();
            fieldDetailList.add(fieldDetails);
        }
        system.debug(fieldDetailList);
        return fieldDetailList;
    }
    //Wrapper class to hold Columns with headers
    public class DataTableColumns
    {
        @AuraEnabled
        public String label {get;set;}
        @AuraEnabled
        public String fieldName {get;set;}
        @AuraEnabled
        public String type {get;set;}

        //Create and set three variables label, fieldname and type as required by the lightning:datatable
        public DataTableColumns(String label, String fieldName, String type){
            this.label = label;
            this.fieldName = fieldName;
            this.type = type;
        }
    }
    //Wrapper calss to hold response - This response is used in the lightning:datatable component
    public class DataTableResponse
    {
        @AuraEnabled
        public List<DataTableColumns> lstDataTableColumns {get;set;}
        @AuraEnabled
        public List<sObject> lstDataTableData {get;set;}
        @AuraEnabled
        public List<FieldDetails> fieldSetdetails;
        public DataTableResponse(){
            lstDataTableColumns = new List<DataTableColumns>();
            lstDataTableData = new List<sObject>();
            fieldSetdetails = new List<FieldDetails>();
        }
    }

    @AuraEnabled
    public static DataTableResponse SearchQueryMethod(List<JobSearchWrapper> jobSearchWrapperList)
    {
        System.debug('Inside SearchQueryMethod'+jobSearchWrapperList);
        List<string> conditions = new List<string>();
        Schema.SObjectType SObjectTypeObj = Schema.getGlobalDescribe().get('Job_Requisition__c');
        Schema.DescribeSObjectResult DescribeSObjectResultObj = SObjectTypeObj.getDescribe();
        Schema.FieldSet fieldSetObj = DescribeSObjectResultObj.FieldSets.getMap().get('JobSearchFieldSet');
        /* Schema.DescribeSObjectResult res=globalDescribe.get('Job_Requisition__c').getDescribe();
Map<String, Schema.FieldSet> fieldSetMap= res.fieldSets.getMap();
Schema.FieldSet jobFieldSet = fieldSetMap.get('JobSearchFieldSet');*/

        FieldDetails fieldDetails= new FieldDetails();
        //string selectfields = 'select Id, Name';
        WhereClause = 'select Id, Name,Skill_Set__c,Work_Experience__c,State__c,Start_Date__c,Job_Type__c,Industry__c,Country__c,City__c from Job_Requisition__c where Id != null';
        // WhereClause = 'select :jobSearchFields from Job_Requisition__c where Id != null';
        //To hold the table hearders
        List<DataTableColumns> lstDataColumns = new List<DataTableColumns>();
        Map<string,DataTableColumns> DataColumnsMap = new Map<string,DataTableColumns>();
        //Field to be queried - fetched from fieldset
        List<String> lstFieldsToQuery = new List<String>();
        //The final wrapper response to return to component
        DataTableResponse response = new DataTableResponse();
for( Schema.FieldSetMember eachFieldSetMember : fieldSetObj.getFields())
        {
            String dataType = String.valueOf(eachFieldSetMember.getType()).toLowerCase();
            system.debug('The datatype of field inside searchQuery() is : '+dataType);
            //This way we can set the type of a column
            //We do not get the exact type from schema object which matches to lightning:datatable component structure
            if(dataType == 'datetime'){
                dataType = 'date';
            }
            //Create a wrapper instance and store label, fieldname and type.
            DataTableColumns datacolumns = new DataTableColumns( String.valueOf(eachFieldSetMember.getLabel()) ,
                                                                String.valueOf(eachFieldSetMember.getFieldPath()),
                                                                String.valueOf(eachFieldSetMember.getType()).toLowerCase() );
            lstDataColumns.add(datacolumns);
            //DataColumnsMap.put(String.valueOf(eachFieldSetMember.getFieldPath()),datacolumns);
        }
       for(JobSearchWrapper jobWrapper:jobSearchWrapperList)
        {
            System.debug('Inside for loop of SearchQueryMethod '+jobWrapper);
            if(jobWrapper.jobRecordField!=null && jobWrapper.jobRecordField!= '' && jobWrapper.operator!=null && jobWrapper.operator!= ''
               && jobWrapper.value!=null && jobWrapper.value!= ''){
                   if(jobWrapper.jobRecordField == 'Start_Date__c' ||jobWrapper.jobRecordField ==     'End_Date__c' ){
                       conditions.add(jobWrapper.jobRecordField + jobWrapper.operator + jobWrapper.value);
                   }else
                       conditions.add(jobWrapper.jobRecordField + jobWrapper.operator + '\'' + jobWrapper.value + '\'');
               }
      }
        system.debug('size is: '+conditions.size());
        if (conditions.size() > 0) {
            for (Integer i = 0; i < conditions.size(); i++){
                WhereClause += ' AND ' + conditions[i] ;
            }
        }
        system.debug('WhereClause-----------'+WhereClause);
        List<Job_Requisition__c> whereclauseDemo = Database.query(WhereClause);
        System.debug('Result of Query is '+whereclauseDemo);
        for(Job_Requisition__c newrecord : whereclauseDemo){
            system.debug(newrecord.Name);
        }
        system.debug('WhereClause-----------'+WhereClause);
        response.lstDataTableColumns = lstDataColumns;
        response.lstDataTableData = Database.query(WhereClause);
        return response ;
    }
    @AuraEnabled
    public static Map<String, String> fieldPickListValues(String jobField)
    {
        system.debug('We are in getFieldType method'+jobField);
        //String dataType = '';
        system.debug('field inside getFieldType method is: '+ jobField);
        Map<String, Schema.SObjectType> schemaMap = Schema.getGlobalDescribe();
        Schema.SObjectType leadSchema = schemaMap.get('Job_Requisition__c');
        Map<String, Schema.SObjectField> fieldMap = leadSchema.getDescribe().fields.getMap();
        system.debug(fieldMap);
        Map<String, String> options = new Map<String, String>();
        List<Schema.PicklistEntry> pick_list_values = New List<Schema.PicklistEntry>();
          pick_list_values = fieldMap.get(jobField).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.put(a.getLabel(), a.getValue());
        }
        return options;
    }
}

Sampath Reddy 15
October 18, 2019
Like
0

1 replies

How to remove standard fields of an object from the fields dropdown in UI, we need to show only custom fields in dropdown

This is UI , in Job requisition fields dropdown we need to display only custom fields.

Sampath Reddy 15
September 11, 2019
Like
0

0 replies

can anybody help me how to get the auto populated values for the fields state, city, country fields in my custom object called applicant. s

Sampath Reddy 15
July 29, 2019
Like
0

2 replies

How to get the picklist values from wrapper (Fieldset) to lightning component controller

Sampath Reddy 15
October 18, 2019
Like
0

9 replies

Create Reports and Dashboards for Sales and Marketing Managers: Filter Your Reports

Hello,
I am getting error that says Central and Eastern Target Accounts' report does not appear to have a filter where Prospect Rating equals 'Hot, Warm'. The filter does not give me option for Field: Prospect Rating?
User-added image

Keith Stephens
September 24, 2017
Like
1