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
Shanky77Shanky77 

very imp--SOQL statements can not be longer than 10000 characters

Hi Dedicated Salesforce Team or All,

              I am facing an error from long.

 

 

'SOQL statements can not be longer than 10000 characters' .

 

I am doubting it could be beacasue of size of  API name of the fields. Even if I reduce the lenght it will not accomodate

more than 450 or max 500 fields . how can I expose remaining 250 - 300 fields on the same VF page.

 

Please give me the step by step by solution. If etensn is required then what would be format. How will it take the input from the user. give me the code of the extens that will store the user input for remaing 250-300 fields other than Standard controller. Because in case of standasrd controller it automatically creates the record.

 

Impatiently waiting for reply.

 

Regards

Shanky

 

SuperfellSuperfell

I'm having a hard time imagining how a single VF page with 700 fields on it is even remotely usable. I think you'll need to write a custom controller and break up your data so you can query it in 2 or 3 queries instead of 1. 

 

You can only have 500 fields on an object, are these extra fields related data you're reading in to display, or are you editing multiple rows of data at once?

Shanky77Shanky77

All fields are input fields. Generally when extensn is written to query the realated object to extract the field values that would be displayed as output/read fields on the VF page but in my case all has to be edit/input fields .

 

Please advice how can i write the extn that would support the input given by the user and will save it in another object.

 

I have not recieved the convincing answer yet...

Regards

Shanky