function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
pChan1412pChan1412 

Maximum number of formula fields per SOQL

Hi,

 

We have up to 150 formula fields in one of the objects in our org. We ran into 'Query is either selecting too many fields or the filter conditions are too complicated.' error when we tried to query all of them is a single query. But splitting it into two separate queries with 75 formula fields each does not do the trick either. We ended up with the same error. So is there any limit on the no. of these formula fields in a single SOQL statement? Please help.

 

Thanks,

Puneeth.

Best Answer chosen by Admin (Salesforce Developers) 
Vinit_KumarVinit_Kumar

It seems that there is ,however this is not documented any where.In case of confusion,you can always reach to salesforce support to get a confirmation.