How to get the latest value from the Database.
I have created a Database where the record is always updating. So I always want to get the latest record.
Clearing Cache is not working
Base.Document.Cache.Clear();
Base.Document.Cache.ClearQueryCache();
e.Cache.Clear();
e.Cache.ClearQueryCache();
using PXSelect is alway providing the Cached Value
PXSelect<TableName,
Where<TableName.bAccountID, Equal<Required<TableName.bAccountID>>,
And<TableName.inventoryID, Equal<Required<TableName.inventoryID>>,
And<TableName.startDate, LessEqual<Required<TableName.startDate>>,
And<TableName.endDate, GreaterEqual<Required<TableName.endDate>>
>>>>>.Select(e.Cache.Graph, new object[] { row.CustomerID, row.InventoryID, Today, Today });