SOQL Archives | 799 The Coder

Just in case if we need to fetch all fields with SOQL in salesforce, what we will do? SOQL query to fetch all fields of an object can be achieved with below approach.

Write each field in SOQL
Go to developer console, open the object, select all fields and click on query, then copy all fields from query tab.
Write code in such a way that it will fetch all fields.

Now lets consider pros and cons of each approach. In first approach “Write each field in SOQL”, if any new field is created in future then code update required. Also we its time taking if there are too many fields.

In Second Approach, if any new fields is created in future then code update required.

In Third approach where we are writing code such that code doesn’t need any update if any new field added.

Apex Code

Below is the apex method for getting SOQL query to fetch all fields of an object.

public static String getSOQLQuery(String obj){
	String query = 'SELECT ';
	Map <String, Schema.SObjectField> fieldMap = Schema.getGlobalDescribe().get(obj).getDescribe().fields.getMap();
	for(String fieldName : fieldMap.keySet()){
		query += fieldName+',';
	}
	query = query.removeEnd(',');
	query += ' FROM '+obj;
	return query;
}

public static String getSOQLQuery(String obj){

String query = 'SELECT ';

Map <String, Schema.SObjectField> fieldMap = Schema.getGlobalDescribe().get(obj).getDescribe().fields.getMap();

for(String fieldName : fieldMap.keySet()){

query += fieldName+',';

}

query = query.removeEnd(',');

query += ' FROM '+obj;

return query;

}

This method can be used as below.

String  query = getSOQLQuery('Account');
System.debug('query => '+query);
List<Account> accountList = Database.query(query);

String query = getSOQLQuery('Account');

System.debug('query => '+query);

List<Account> accountList = Database.query(query);

Hope this will help and increase productivity of developers.

Tag Archives: SOQL

Apex Code