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,
.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.
Best answer by Dmitrii NaumovView original