Contents tagged with Brackets
-
FBQL brackets
Hello everybody,
today I want to speak about one very interesting feature of FBQL, which I don't know if exists in BQL. Function Brackets!
Take a look on following code sample:
var bracketsDemo = SelectFrom<SOOrder>.InnerJoin<SOLine>.On<SOLine.orderNbr.IsEqual<SOOrder.orderNbr>>.InnerJoin<SOShipLine>
.On<SOShipLine.origOrderNbr.IsEqual<SOOrder.orderNbr>>.Where<
Brackets<SOShipLine.confirmed.IsNotNull.
And<SOShipLine.baseOrigOrderQty.IsNotNull>.
And<SOShipLine.completeQtyMin.IsNotNull>.
And<SOShipLine.confirmed.IsEqual<True>.
Or<SOShipLine.confirmed.IsNull>>.
And<SOShipLine.baseOriginalShippedQty.IsGreater<SOShipLine.unassignedQty>.
Or<SOShipLine. … more