Contents tagged with F-BQL

  • 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

    more