You need to sign in to do that
Don't have an account?
satish kopuri
External Object Records on VisualForce page
Hi All ,
I am trying to disaplay External Object Records on VisualForce page through Salesforce Connect: OData 2.0.(I have configured this External data Source).Then I tried to query records from External Object.For 200 records I am able to show the records but for more than 200 records I am getting below error.
System.QueryException: Inline query has too many rows for direct assignment, use FOR loop
please help me to resolve this issue.
Please find the below code snippet.
Public List<GetBooks__x> getbookslist { get; set; }
getbookslist= [SELECT ExternalId, BookName__c, BookFeature__c from GetBooks__x
WHERE BusinessPartner__c =:currentRecord.Partner_Number__c ];
If I put LIMIT 200 , I am getting 200 records to display , for more that 200 I am getting the above error.
I am trying to disaplay External Object Records on VisualForce page through Salesforce Connect: OData 2.0.(I have configured this External data Source).Then I tried to query records from External Object.For 200 records I am able to show the records but for more than 200 records I am getting below error.
System.QueryException: Inline query has too many rows for direct assignment, use FOR loop
please help me to resolve this issue.
Please find the below code snippet.
Public List<GetBooks__x> getbookslist { get; set; }
getbookslist= [SELECT ExternalId, BookName__c, BookFeature__c from GetBooks__x
WHERE BusinessPartner__c =:currentRecord.Partner_Number__c ];
If I put LIMIT 200 , I am getting 200 records to display , for more that 200 I am getting the above error.
https://pradhanmantri-yoganas.blogspot.com/2020/04/pradhan-mantri-ujjawal-yojana.html