[SalesForce] Display fields only if the values are not null or blank for a dynamic SOQL Query

I stored all the editable fields in a variable and calling the variable in a dynamic SOQL query.
My Query:

String fieldApiList = String.join(fieldsApiNames, ',');
        query = 'SELECT Name,'+ fieldApiList +' from EP_Service_License__c WHERE ID IN:recordIdSet';
        
        SelectedEpserviceRecords=Database.query(query);

Now, using a VF page I am displaying the fields and its values like as follows

my requirement is, if any field value is null or blank in the selected records or any field values is same in all the selected records then I should not display that field.
For example, here in the picture, product license number is same for all the selected records and Copy Primary Prod Co License(s) field is null for all the selected records. Now, I should avoid displaying those two in the output. This should happen dynamically for all the fields.

Kindly help me on this

Best Answer

With your fieldApiNames, you can check each field to see which values are returned:

String[] fieldsToDisplay = new String[0];
for(String fieldName: fieldApiNames) {
  Set<Object> values = new Set<Object>();
  for(sObject record: SelectedEpserviceRecords) {
    values.add(record.get(fieldName));
  }
  if(values.size() > 1) {
    fieldsToDisplay.add(fieldName);
  }
}

Then you'll be able to show only the fields that have at least two different values.

Related Solutions

[SalesForce] Need to build the dynamic soql query in trigger

As @Birthus mentioned a trigger will only work for this assuming you have less than 50k records in the DB. You can try to further filter your SOQL, but beyond that Batch may be the way to go.

Assuming that you have less than 50k records, then something like below should work, but will not work should you have a large number of Schedule__c records in the database already

trigger newrunway on Schedule__c (before insert, before update) {

    map<string,set<DateTime>> runway2DateMap = new map<string,set<DateTime>>();

    for(Schedule__c sched : [Select Id, Date__c, Runway__c From Schedule__c Where Date__c > TODAY And Id Not In : trigger.new]){
        if(!runway2DateMap.containsKey(sched.Runway__c)){
            runway2DateMap.put(sched.Runway__c, new set<DateTime>());
        }
        runway2DateMap.get(sched.Runway__c).add(sched.Date__c);
    }

    for(Schedule__c sched : trigger.new){
        if(runway2DateMap.get(sched.Runway__c).contains(sched.Date__c)){
            sched.addError('Flight Already Scheduled on the Runway');
        }
    } 
}

[SalesForce] SOQL dynamic query issue – managed package

This is a documented "feature" (though I can't seem to find it right now). A managed package cannot reference custom objects or fields created by a subscriber with the same name as a custom object or field by the same name. The reason why is that because the compiler automatically resolves these references to the managed package version. This is done as a convenience to developers so that they don't need to include the namespace in their code everywhere.

In other words, despite what you think, the query actually looks like this by the time the SOQL is executed:

SELECT Id FROM sf_com_bh__Application__c WHERE 
(sf_com_bh__Application_method__c LIKE :keyword OR 
 sf_com_bh__Application_method__c LIKE :keyword) 
LIMIT 100

Obviously, this won't work like you expected. You need to tell the subscribers that they cannot use the same name as a custom field on the object.

This behavior works both ways. Local fields will be described preferentially in subscriber code, but the managed package field will be described preferentially in the managed code. This design is intentional; it allows a package and a namespace to not conflict with each other.

Best Answer

Related Solutions

[SalesForce] Need to build the dynamic soql query in trigger

[SalesForce] SOQL dynamic query issue – managed package

Related Topic