Xjyuk

New coworker has strange workplace requirements - how should I deal with them?

Necessity of tenure for lifetime academic research

LINQ Extension methods MinBy and MaxBy

Does the telecom provider need physical access to the SIM card to clone it?

What are ways to record who took the pictures if a camera is used by multiple people?

How can I improve my formal definitions?

Using font to highlight a god's speech in dialogue

Longer digital trace further from analog vs shorter digital trace closer to analog

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

Welche normative Autorität hat der Duden? / What's the normative authority of the Duden?

Did NASA/JPL get "waning" and "waxing" backwards in this video?

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

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

What is this "opened" cube called?

Can UV radiation be safe for the skin?

When you have to wait for a short time

Divide Numbers by 0

Padding a column of lists

Am I required to correct my opponent's assumptions about my morph creatures?

How can I store milk for long periods of time?

Sum and average calculator

Fishing from underwater domes

How to get frequency counts using column breaks by row?

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?

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