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”