How To Use F Bql View Instead Of Pxselect

Hello everybody,

today I want to leave a short note on how to use F-BQL version of PXSelect in Acumatica.

In past it was common to have this line of code in your graph:

public PXSelect<Student1> Students;

In new F-BQL introduced new construction, SeleftFrom. Proper way of using it is this:

public SelectFrom<Student2>.View Students;

Take notice of suffix .View. Without that suffix you'll not get proper F-BQL view. And Acuminator will give you this warning:

So if to summarize, don't forget to add suffix .View 

If you're looking to streamline your Acumatica development with custom solutions or need help implementing the new F-BQL functionality, don't hesitate to reach out! Submit your customization request today, and our team will assist in tailoring Acumatica to meet your unique business needs. Whether it’s fine-tuning PXSelect or anything else, we’re here to help you optimize your workflows!