How To Use Fbql In Pxprojection
12 March 2020
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