Operator In In Bql

Hello everybody,

today I want to write a few words about operator in which was presented in SQL for long ago, but weren't available in Acumatica BQL. But time goes on and now you can use it. For example like this:

Object[] values = new String[] { "BXW000004", "BXW000005" };
 
                POOrder item = PXSelect<POOrder,
                    Where<POOrder.orderNbr, In<Required<POOrder.orderNbr>>>>.Select(Base, values);

that code will generate following sql statement:

Select * from POOrder POOrder Where POOrder.OrderNbr In ('BXW000005', 'BXW000004')
	Order by POOrder.OrderNbr

I can say that such approach simplifies some tasks that require dynamic passing of arguments.

Ready to streamline your Acumatica development process? If you found this article on using the In operator in BQL helpful, imagine what custom solutions could do for your business! Whether you need dynamic query optimizations, tailored workflows, or other customizations, our team is here to help. Leave a customization request today, and let’s transform your Acumatica experience together. Your efficiency is just a click away!