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”
Question
Models using ALL ROWS do not keep ALL ROWS after table filter
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.