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
ra811.3921220580267847E12ra811.3921220580267847E12 

Inline vf error in page layout

Hi All,

We had a requirement where i must use for a single object, i need to use 156 formula fields. now iam trying to display those fileds in the VF page(inline vf in the page layout). iam able to display 52 fields only. for remaining fields it is showing the below error:
QueryUser-added image
Ashish_SFDCAshish_SFDC
Hi Ramesh, 


The only known work-around is to reduce the complexity of your query. Limit the number of fields, formula fields, large text area fields (limit size helps), reduce roll up summary fields in your query, and limit your filters if possible.

http://salesforce.stackexchange.com/questions/16501/any-good-workarounds-to-query-too-complicated-error-for-dynamic-soql

https://developer.salesforce.com/forums/ForumsMain?id=906F00000008zePIAQ


Regards,
Ashish

ra811.3921220580267847E12ra811.3921220580267847E12
Hi Ashish,

i have to dispay all the formula fields . there is no option for limiting the query. please suggest  how to reslove this.
Ashish_SFDCAshish_SFDC
Hi Ramesh,


Can you try with a much smaller set of columns ( just clear some out ), and see if you can get a subset of the fields to come back?

https://developer.salesforce.com/forums?id=906F00000009CZCIA2


You could try using a feature of DBAmp called Column Subsets which allow you to replicate subsets of columns of a table and then glue them together locally. This effectively decreases the number of formula fields in the query. See Column Subset Views in Chapter 2 of the DBAmp doc.

exec sf_replicate 'SALESFORCE','Object_ColumnSubsetAM'
exec sf_replicate 'SALESFORCE','Object_ColumnSubsetNZ'

and then use following to construct the table

Select column1,column2,column3 into Object
from Object_ColumnSubsetAM AM
inner Join Object_ColumnSubsetNZ NZ on AM.id = NZ.id

Alternatively, you can just construct multiple select statements yourself with subsets of the columns.

http://jatindersingh.blogspot.in/2012/08/salesforce-query-is-either-selecting.html


Regards,
Ashish