I have sql view for process screen. When I refresh grid. Data not updated. When I refresh page data is updated. How to solve this ?
Answer
sql view not refreshed data
Best answer by jinin
Hi
It appears to be a cache issue. Have you tried clearing the cache and checking if the issue is resolved?
Sample:
public PXSelect<DACName> Records;
protected virtual IEnumerable records()
{
// Clear previous cached data
Records.Cache.Clear();
Records.Cache.ClearQueryCache();
// Re-run the BQL which points to SQL view
return PXSelect<DACName>.Select(graph);
}
+11Hi
It appears to be a cache issue. Have you tried clearing the cache and checking if the issue is resolved?
Sample:
public PXSelect<DACName> Records;
protected virtual IEnumerable records()
{
// Clear previous cached data
Records.Cache.Clear();
Records.Cache.ClearQueryCache();
// Re-run the BQL which points to SQL view
return PXSelect<DACName>.Select(graph);
}
Jini N
Hi
It’s not recommended to map DACs to SQL views in Acumatica precisely because of such issues with refresh of the data. You should use Projection DACs instead. You can check out my post on projection DACs:
Or you can find similar info on the Help Portal:
https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=e8f097ea-69a0-496d-84d1-807f21b072b4
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.