How to work with Bql for a drop down value

Thanks!! it worked.

Also, I just tried the same thing by implementing to a PXSelector. Below is the code .but it doesn’t work. btw it worked on getting single value. Something wrong with the query?

[PXSelector
            (typeof(Search<SOOrder.orderNbr,
                    Where<SOOrder.status,
                    Equal<SOOrderStatus.open>,
                    And<SOOrder.status,
                    Equal<SOOrderStatus.hold>>>>))]

This works fine,

[PXSelector
            (typeof(Search<SOOrder.status,
                    Where<SOOrder.status,
                    Equal<SOOrderStatus.open>>>))]

@rashmikamudalinayake10  Great, Thanks for sharing the update!!

In your PXSelector attribute you need to update And<> condition with Or<> to be able to get the more than one record. But my suggestion bellow

 [PXSelector(typeof(Search<SOOrder.orderNbr,Where<SOOrder.status,In3<SOOrderStatus.open, SOOrderStatus.hold>>>))]

Yes @rashmikamudalinayake10  Please change the Condition to OR instead of AND.

Due to this AND condition system not fetching any records.

Thanks!! it worked.

Correct query for fetching open state and hold state using PXSelector as below

[PXSelector
            (typeof(Search<SOOrder.orderNbr,
                    Where<SOOrder.status,
                    Equal<SOOrderStatus.open>,
                    Or<SOOrder.status,
                    Equal<SOOrderStatus.hold>>>>))]

Note: The above mentioned snippet by vardan22 also work as well.