Contents tagged with FBQL

  • 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

  • Required of BQL in FBQL of Acumatica

    Hello everybody,

    today I want to describe how analogue to Required works in Acumatica Framework.

    For example, in the past ( before 2019 R1 ) you may read something from Acumatica with help of Required:

    var contact = PXSelect<Contact, Where<Contact.displayName, IsNotNull, And<Contact.displayName,  Contains<Required<Contact.displayName>>>>>.SelectWindowed(graph, startIdx, 1, ' ').First();

    Now, you can use @P.AsString, as shown on code sample below:

    var contact = SelectFrom<Contact>.Where<Contact.displayName.IsNotNull.And<Contact.displayName. Contains<@P.AsString>>>.View.SelectWindowed(graph, startIdx, 1, ' ').First();

    Conclusion

    Also take a note, that … more