How to select without merging with Cache

Hello everyone,

I need to run a query without the platform merging the DB result with the Cache and showing it to me. I have something very simple like this

bool isResumed = PXSelect<EPApproval,
    Where<EPApproval.refNoteID, Equal<Required<EPApproval.refNoteID>>,
        And<EPApproval.status, Equal<Required<EPApproval.status>>>>>
    .Select(Base, RefNoteID, HCLEPStatuses.CustomPending) != null;

In one of my queries I know for sure it should return false as I do not have the matching criteria in DB but because the query result is merged with Cache “true” is returned. I could clear the Cache before querying but the case is I need the data stored in the Cache by the platform for further processing. Any help will be appreciated. I got around it using “PXDatabase.SelectSingle<EPApproval> …” but I do not believe it is the correct way.