How To Use Fbql In Pxprojection

Hello everybody,

Recnetly I had a need to create PXProjection and wanted to use in declaration of it not SelectJoin, but FBQL SelectFrom with combination of InnerJoin. Finally I've got something like this:

[PXProjection(typeof(SelectFrom<SOOrder>.InnerJoin<SOLine>.On<SOOrder.orderType.
    IsEqual<SOLine.orderType>.And<SOOrder.orderNbr.IsEqual<SOLine.orderNbr>>>))]
public class SalesOrderLines
{
}

Nothing fancy, but during initial coding error messages were a bit confusing

Ready to take your Acumatica development to the next level? If you’ve ever faced challenges with customizations like PXProjection or FBQL queries, or if you have a unique business need that requires tailored solutions, we’re here to help! Share your customization request with us today, and let’s turn your ideas into reality. Whether it’s streamlining processes, enhancing functionality, or solving complex integration challenges, our team is ready to bring your vision to life. Leave your request now and let’s build something amazing together!