Why there is a mismatch on different SOQL queries on FieldPermissions Object?
|Knowledge Article Number||000240176|
|Description||Some customers may encounter an issue when downloading records from the "Fieldpermissions" object using API, they may notice that the batch abruptly finishes indicating a portion of records were downloaded than the complete batch itself.|
|Resolution||This is a known documentation issue since the total number of records being displayed are incorrect while API applications actually download the correct number of records. We are working on creating the official documentation to address this behavior. This is due to the fact that filter logic in background is not able to correctly reflect the correct total number of rows that should be returned in the query mode while it works fine during the extraction.|