SOQL SELECT ALL FIELD

 

Have you ever wanted to do an SQL SELECT * statement in SOQL? Well here's the workaround. Generally, I would recommend that you only query for data that you need, however I have been using this on my current project where the data model constantly changes.

To use, copy and paste this code into your org and modify the 3 lines with // modify as needed at the end.

// Initialize setup variables
String objectName = 'Contact';  // modify as needed
String query = 'SELECT';
Map<String, Schema.SObjectField> objectFields = Schema.getGlobalDescribe().get(objectName).getDescribe().fields.getMap();

// Grab the fields from the describe method and append them to the queryString one by one.
for(String s : objectFields.keySet()) {
   query += ' ' + s + ', ';
}

// Manually add related object's fields that are needed.
query += 'Account.Name,'; // modify as needed

// Strip off the last comma if it exists.
if (query.subString(query.Length()-1,query.Length()) == ','){
    query = query.subString(0,query.Length()-1);
}

// Add FROM statement
query += ' FROM ' + objectName;

// Add on a WHERE/ORDER/LIMIT statement as needed
query += ' WHERE firstName = \'test\''; // modify as needed
  
try {
        List<Contact> contacts = database.query(query);
} catch (QueryException e){
        //perform exception handling
}