Can I query formula fields in SOQL

formula-fieldsoql

I have a custom object with a custom formula field. When I try to query that field, I get an error.

% sfdx force:data:soql:query --query "SELECT FullNamePrimary__c FROM LoanBorrower__c"
Querying Data... done
ERROR running force:data:soql:query:  
SELECT FullNamePrimary__c FROM LoanBorrower__c
       ^
ERROR at Row:1:Column:8
No such column 'FullNamePrimary__c' on entity 'LoanBorrower__c'...

Are formula fields not available from SOQL? Is this documented somewhere (yes, I did check the formula field documentation on the limits, there was no mention of this limitation).

Best Answer

Formula fields are most certainly available in SOQL.

Your authenticated user almost certainly does not have Field-Level Security (FLS) access to this field. When you access Salesforce via the API, FLS is enforced against your user, which typically produces this exact error.

Related Solutions

[SalesForce] How to access custom fields of Task parent record using SOQL

Since the WhatId can refer to any number of object types, you can't reference a custom field from a single one of those objects.

WhatId: ID of a related Account, Opportunity, Campaign, Case, or custom object

https://www.salesforce.com/us/developer/docs/api/Content/sforce_api_objects_task.htm

You can however use a subquery:

SELECT Name__c FROM My_Object__c WHERE Id IN (SELECT WhatId FROM Task WHERE Id = 'XXXXXX')

UPDATE:

Apparently you can't use a subquery for Tasks. If you are using Apex, you can break it into two separate queries.

Task t = [SELECT WhatId FROM Task WHERE Id = 'xxx'];
My_Object__c m = [SELECT Name__c FROM My_Object__c WHERE Id =: t.WhatId];

You'll want to add some additional checking for null values, but that should do the trick.

[SalesForce] how to soql query on standard object product2

If you are trying to run a query to find the product2ID, the name of the product, quantity sold and the list price for a particular opportunity you could run a SOQL query on the OpportunityLine Item.

Your query would look something like this :

SELECT product2ID, product2.name, quantity, Listprice 
FROM OpportunityLineItem 
WHERE OpportunityId = "your opportunity id"

The amount of rows returned would depend on how many products and line items you have in the opportunity.

Best Answer

Related Solutions

[SalesForce] How to access custom fields of Task parent record using SOQL

[SalesForce] how to soql query on standard object product2

Related Topic