Skip to main content

Hello.  I execute a simple BQL query.

SOOrderType orderType = SelectFrom<SOOrderType>
    .Where<SOOrderType.orderType.IsEqual<@P.AsString>>.View.Select(Base, tran.SOOrderType);

I verified the BQL parameter returns “SO”

However the results of the BQL is null.  I verified that only 1 version of SO order type exists.  I’m unsure why this happens.

Have you tried trimming tran.SOOrderType? I get caught with this sometimes, but more often with something like InventoryCD.


Reply