SelectFrom For Usage In View Select

Hello everybody,

I want to leave a short note on how to use SelectFrom for legacy code, and pass it in View.Select for Acumatica newer versions. 

var cmd = new SelectFrom<PartsCatalog>.
    InnerJoin<INSiteStatus>.On<Use<PartsCatalog.inventoryID>.AsInt.IsEqual<Use<INSiteStatus.inventoryID>.AsInt>>.View(this);
 
var s = (currentFilter.PageNbr ?? 0) * (currentFilter.PageSize ?? 0);
int startRow = s > 0 ? s : PXView.StartRow;
int totalRows = 0;
int maxRows = (currentFilter.PageSize ?? 0) == 0 ? PXView.MaximumRows : currentFilter.PageSize ?? 0;
 
var list = cmd.View.Select(new[] { currentFilter }, null, PXView.Searches,
    PXView.SortColumns, PXView.Descendings, PXView.Filters, ref startRow, maxRows, ref totalRows).ToList();

As you can see, each time, when field is not converted to a newer Acumatica FBQL, you can refer to Use and AsType.

Looking to streamline your Acumatica customization with the latest development best practices? If you need help migrating legacy code or optimizing your queries with SelectFrom, our team is here to assist!

📩 Leave a request for a customization consultation today, and let’s tailor Acumatica to fit your business needs seamlessly.