how to select all fieldsin a soql query

Solutions on MaxInterview for how to select all fieldsin a soql query by the best coders in the world

showing results for - "how to select all fieldsin a soql query"

13 Jun 2019

1// This is the object for which we required data.
2Map<String, Schema.SObjectField> fieldMap = Opportunity.sObjectType.getDescribe().fields.getMap();
3  
4// Get all of the fields on the object
5Set<String> fieldNames = fieldMap.keySet();
6 
7// Build a Dynamic Query String.
8List<Opportunity> opps = Database.query('select ' + string.join(fieldNames, ',') + ' from Opportunity');
9

source

Paul

09 Mar 2017

1Id rId = 'SomeValidSFDCId';
2 
3DescribeSObjectResult describeResult = rId.getSObjectType().getDescribe();      
4Map<String, Schema.SObjectField> fieldMap = describeResult.fields.getMap();
5  
6// Get all of the fields on the object
7Set<String> fieldNames = fieldMap.keySet();
8 
9// Build a Dynamic Query String.
10String soqlQuery = ' SELECT ' + string.join (fieldName, ',') + ' FROM ' + describeResult.getName() + ' Where Id =: rId';
11 
12// Need to return a generic list of sObject because we don't necessarily know exactly what the object is.
13List<sObject> record = Database.query(soqlQuery);
14

source

similar questions

mysql get only the field names in a table tsql get all columns in table sql search all columns of database oracle sql select all columns except one sql get all tables with column name sql selecting all columns from table sql database how to select all attributes from a row if there is a certain string in it mysql mssql get all table names sql all columns read all columns of a table sql mysql select all table that have field names sql server search column name in all tables how to get all table names in sql query mysql select all columns and specific fields as search all tables all columns for a specific value in mssql server sql select all from table sql query to return field name of a table get all columns from table sql

queries leading to this page

select all fields in soql soql fields all query get all fields salesforce selecting all fields in soql get all fields from object salesforce soql all fileds in soql saleforce how to select all fields in soql soql query to select all fields soql query for all fields select allfields 28all 29 from account salesforce soql select all soql query all fields select fields 28all 29 soql soql select all fields salesforce soql select all where select all from table salesforce sql soql all fields select 7ball fields 7d soql select all fields soql soql select all how to select all feilds in soql soql select fields 28all 29 select all fields in salesforce query get all fields in soql query how to select all the field in soql soql all fields sosl select allfields 28all 29 salesfroce soql select 2a from all fields get all fields in a table soql select fields all soql select 7bfields all 7d soql get all fields selector salesforce query returns all fields salesforce query all fields in soql get all columns from salesforce query soql get all fields how to select all fieldsin a soql query