models using ALL ROWS do not keep ALL ROWS after table filter

  • 1
  • Problem
  • Updated 2 years ago
  • Acknowledged
I have a page with a single model and a table on that model. The model is set to query ALL ROWS.

On pageload, the soql looks like this:

"SELECT IsDeleted,Name,Interaction_Category__c,Interaction_Purpose__c,Interaction_Type__c,Room__c,Room__r.Name,Date__c,End__c,Primary_Staff__c,Primary_Staff__r.Name,LastModifiedById,LastModifiedBy.Name,Patient_Case__r.Patient__c,Patient_Case__r.Patient__r.Name,Status__c,Id FROM Interaction__c WHERE (Interaction_Category__c = 'Appointment')AND(IsDeleted = true) LIMIT 21 ALL ROWS"

However, as soon as I apply a table filter or attempt to sort the model, the ALL ROWS is dropped from the soql:

"SELECT IsDeleted,Name,Interaction_Category__c,Interaction_Purpose__c,Interaction_Type__c,Room__c,Room__r.Name,Date__c,End__c,Primary_Staff__c,Primary_Staff__r.Name,LastModifiedById,LastModifiedBy.Name,Patient_Case__r.Patient__c,Patient_Case__r.Patient__r.Name,Status__c,Id FROM Interaction__c WHERE (Interaction_Category__c = 'Appointment')AND(IsDeleted = true) ORDER BY Date__c ASC NULLS LAST LIMIT 21"
Photo of Matt Sones

Matt Sones, Champion

  • 31,478 Points 20k badge 2x thumb

Posted 2 years ago

  • 1
Photo of Karen Waldschmitt

Karen Waldschmitt, Official Rep

  • 8,210 Points 5k badge 2x thumb
Matt~

Thanks for reporting this bug! We will let you know when this is fixed in a future release.

Thanks!
Karen