Contents tagged with Brackets

• FBQL brackets

  Friday, June 21, 2019 3:28:30 PM

  No Comments

  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