You need to sign in to do that
Don't have an account?
AditiSFDC
Using Long Text Area field in SELECT query returns less number of records
Adding a Long Text Area field in a Select query then it returns weird number of records then actual records available or returned when using select query without Long Text Area field. However, adding more than one Long Text Area field in select query, number of records decreased even more as compared to those which returned with single Long Text Area field. Let Say : We have two Object A & B. B is A child and have two long text area fields lat sat Long_Desc_1 and Long_Desc_2. Number of A's record exists : more than 5000 Number of B's record exists : more than 3000 where around 2900 B's record belongs to a single Parent record. Query results :
Thanks |
I have tested this again in Salesforce Summer'12 release and its working expected.
Salesforce has fixed this issue in its new release :)