Mfcttrf

What is the practical impact of using System.Random which is not cryptographically random?

Create a list of snaking numbers under 50,000

apt-file regex: find multiple packages at once using or

Understanding data transmission rates over copper wire

What is the chance of getting a Red Cabbage in year 1?

Could a complex system of reaction wheels be used to propel a spacecraft?

Using font to highlight a god's speech in dialogue

How to query field names from custom object by data type?

Four day weekend?

Received email from ISP saying one of my devices has malware

Given a specific computer system, is it possible to estimate the actual precise run time of a piece of Assembly code

How smart contract transactions work?

Can a human variant take proficiency in initiative?

Can authors email you PDFs of their textbook for free?

Padding a column of lists

How to load files as a quickfix window at start-up

Can I leave a large suitcase at TPE during a 4-hour layover, and pick it up 4.5 days later when I come back to TPE on my way to Taipei downtown?

Can a system of three stars exist?

Does using composite keys violate 2NF

How were US credit cards verified in-store in the 1980's?

How can I portray a character with no fear of death, without them sounding utterly bored?

Heuristic argument for the Riemann Hypothesis

Why 50 Ω termination results in less noise than 1 MΩ termination on the scope reading?

How to run a command 1 out of N times in Bash

How to query field names from custom object by data type?

Controlling the data type of a custom fieldHow to copy field data from object to object with a button-click via Apex?How to create a custom field in test classHow to query Id of a field/Custom field from standard object using Tooling API in .netQuerying a field on an unknown object typeExactTarget Query Activity Data View - Correct NamesQuery custom fields from object with a polymorphic fieldHow to map the state code with state names?Custom Object how to get actual query data?Generic function - Custom meta data type

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

I have custom object ExchangeRate__c. How to get all fields, which have data type "currency" and put their field names in a string?

apex query

share|improve this question

asked 8 hours ago

EviGertsikEviGertsik

1244 bronze badges

add a comment | 

1

I have custom object ExchangeRate__c. How to get all fields, which have data type "currency" and put their field names in a string?

apex query

share|improve this question

asked 8 hours ago

EviGertsikEviGertsik

1244 bronze badges

add a comment | 

I have custom object ExchangeRate__c. How to get all fields, which have data type "currency" and put their field names in a string?

apex query

share|improve this question

asked 8 hours ago

EviGertsikEviGertsik

1244 bronze badges

share|improve this question

asked 8 hours ago

EviGertsikEviGertsik

1244 bronze badges

share|improve this question

asked 8 hours ago

EviGertsikEviGertsik

1244 bronze badges

asked 8 hours ago

EviGertsikEviGertsik

1244 bronze badges

asked 8 hours ago

EviGertsikEviGertsik

1244 bronze badges

2 Answers
2

active

oldest

votes

3

You can use below method and pass the object name ExchangeRate__c as parameter:

public static String getCurrencyFields(String obj) 
 List<String> fields = new List<String>();
 SObjectType objType = Schema.getGlobalDescribe().get(obj);
 Map<String,Schema.SObjectField> mfieldsMap = objType.getDescribe().fields.getMap();

 for(Schema.SObjectField fld : mfieldsMap.values()) 
 if(fld.getDescribe().getType()==Schema.DisplayType.CURRENCY)
 fields.add(fld.getDescribe().getName());
 
 
 return String.join(fields,',');

share|improve this answer

answered 8 hours ago

salesforce-sassalesforce-sas

8,10611 gold badge22 silver badges2424 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank you! But I made a little mistake - I need field labels, not field names.
  
  – EviGertsik
  7 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You can get label instead of name - fields.add(fld.getDescribe().getLabel());
  
  – salesforce-sas
  7 hours ago
  

  
  
  
  

add a comment | 

1

You wouldn't use a query for this, but rather the DescribeSObjectResult and DescribeFieldResult classes.

Schema.SObjectType.<Sobject API Name>.fields gives you a Map<String, Schema.SObjectField> containing the field tokens for all of the fields on the object

You can then iterate over those Schema.SObjectField instances, and get the DescribeFieldResult from them using the getDescribe() method.

The DescribeFieldResult class gives you access to the metadata of the field, including what type of field it is (the getType() method).

share|improve this answer

answered 8 hours ago

Derek FDerek F

22.9k66 gold badges2626 silver badges5555 bronze badges

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "459"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f275590%2fhow-to-query-field-names-from-custom-object-by-data-type%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

3

You can use below method and pass the object name ExchangeRate__c as parameter:

public static String getCurrencyFields(String obj) 
 List<String> fields = new List<String>();
 SObjectType objType = Schema.getGlobalDescribe().get(obj);
 Map<String,Schema.SObjectField> mfieldsMap = objType.getDescribe().fields.getMap();

 for(Schema.SObjectField fld : mfieldsMap.values()) 
 if(fld.getDescribe().getType()==Schema.DisplayType.CURRENCY)
 fields.add(fld.getDescribe().getName());
 
 
 return String.join(fields,',');

share|improve this answer

answered 8 hours ago

salesforce-sassalesforce-sas

8,10611 gold badge22 silver badges2424 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank you! But I made a little mistake - I need field labels, not field names.
  
  – EviGertsik
  7 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You can get label instead of name - fields.add(fld.getDescribe().getLabel());
  
  – salesforce-sas
  7 hours ago
  

  
  
  
  

add a comment | 

3

You can use below method and pass the object name ExchangeRate__c as parameter:

public static String getCurrencyFields(String obj) 
 List<String> fields = new List<String>();
 SObjectType objType = Schema.getGlobalDescribe().get(obj);
 Map<String,Schema.SObjectField> mfieldsMap = objType.getDescribe().fields.getMap();

 for(Schema.SObjectField fld : mfieldsMap.values()) 
 if(fld.getDescribe().getType()==Schema.DisplayType.CURRENCY)
 fields.add(fld.getDescribe().getName());
 
 
 return String.join(fields,',');

share|improve this answer

answered 8 hours ago

salesforce-sassalesforce-sas

8,10611 gold badge22 silver badges2424 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank you! But I made a little mistake - I need field labels, not field names.
  
  – EviGertsik
  7 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You can get label instead of name - fields.add(fld.getDescribe().getLabel());
  
  – salesforce-sas
  7 hours ago
  

  
  
  
  

add a comment | 

You can use below method and pass the object name ExchangeRate__c as parameter:

public static String getCurrencyFields(String obj) 
 List<String> fields = new List<String>();
 SObjectType objType = Schema.getGlobalDescribe().get(obj);
 Map<String,Schema.SObjectField> mfieldsMap = objType.getDescribe().fields.getMap();

 for(Schema.SObjectField fld : mfieldsMap.values()) 
 if(fld.getDescribe().getType()==Schema.DisplayType.CURRENCY)
 fields.add(fld.getDescribe().getName());
 
 
 return String.join(fields,',');

share|improve this answer

answered 8 hours ago

salesforce-sassalesforce-sas

8,10611 gold badge22 silver badges2424 bronze badges

public static String getCurrencyFields(String obj) 
 List<String> fields = new List<String>();
 SObjectType objType = Schema.getGlobalDescribe().get(obj);
 Map<String,Schema.SObjectField> mfieldsMap = objType.getDescribe().fields.getMap();

 for(Schema.SObjectField fld : mfieldsMap.values()) 
 if(fld.getDescribe().getType()==Schema.DisplayType.CURRENCY)
 fields.add(fld.getDescribe().getName());
 
 
 return String.join(fields,',');

share|improve this answer

answered 8 hours ago

salesforce-sassalesforce-sas

8,10611 gold badge22 silver badges2424 bronze badges

answered 8 hours ago

salesforce-sassalesforce-sas

8,10611 gold badge22 silver badges2424 bronze badges

answered 8 hours ago

salesforce-sassalesforce-sas

8,10611 gold badge22 silver badges2424 bronze badges

1

You wouldn't use a query for this, but rather the DescribeSObjectResult and DescribeFieldResult classes.

Schema.SObjectType.<Sobject API Name>.fields gives you a Map<String, Schema.SObjectField> containing the field tokens for all of the fields on the object

You can then iterate over those Schema.SObjectField instances, and get the DescribeFieldResult from them using the getDescribe() method.

The DescribeFieldResult class gives you access to the metadata of the field, including what type of field it is (the getType() method).

share|improve this answer

answered 8 hours ago

Derek FDerek F

22.9k66 gold badges2626 silver badges5555 bronze badges

add a comment | 

1

You wouldn't use a query for this, but rather the DescribeSObjectResult and DescribeFieldResult classes.

Schema.SObjectType.<Sobject API Name>.fields gives you a Map<String, Schema.SObjectField> containing the field tokens for all of the fields on the object

You can then iterate over those Schema.SObjectField instances, and get the DescribeFieldResult from them using the getDescribe() method.

The DescribeFieldResult class gives you access to the metadata of the field, including what type of field it is (the getType() method).

share|improve this answer

answered 8 hours ago

Derek FDerek F

22.9k66 gold badges2626 silver badges5555 bronze badges

add a comment | 

You wouldn't use a query for this, but rather the DescribeSObjectResult and DescribeFieldResult classes.

Schema.SObjectType.<Sobject API Name>.fields gives you a Map<String, Schema.SObjectField> containing the field tokens for all of the fields on the object

You can then iterate over those Schema.SObjectField instances, and get the DescribeFieldResult from them using the getDescribe() method.

The DescribeFieldResult class gives you access to the metadata of the field, including what type of field it is (the getType() method).

share|improve this answer

answered 8 hours ago

Derek FDerek F

22.9k66 gold badges2626 silver badges5555 bronze badges

share|improve this answer

answered 8 hours ago

Derek FDerek F

22.9k66 gold badges2626 silver badges5555 bronze badges

answered 8 hours ago

Derek FDerek F

22.9k66 gold badges2626 silver badges5555 bronze badges

answered 8 hours ago

Derek FDerek F

22.9k66 gold badges2626 silver badges5555 bronze badges