I am creating a BAQ and using 2 parameters. When I put in the Transfer Order and Packnum, it is showing all the PackNums within that Transfer Order.
When I do it via SQL like the first screenshot, it works fine. Any ideas how I can accomplish the same with BAQ?
This is what my BAQ looks like. I want to allow the user to be able to input the Transfer Order Number and PackNum together, or just one or the other. If they input only the Transfer Order Number, then bring all the packnum. If they just want to input the packnum, it would only bring that. However, I have some users wanting to put both and then it brings all the packnum and should only be bringing in just the one packnum.
Yeah, I am trying to get to the 4 conditions similar to my sql statement, but doesnât seem like itâs possible. I know that when I define the parameters, I can have it skip the condition if it is empty. However, if I input both the Transfer Order Number and PackNum, it still pull all the packnums related to that transfer order and not just the specific one in the parameter.
The bold section from the where clause with the SQL Query, is that doable within a BAQ?
Thanks for the suggestion Ken. I tried that as well and didnât work. I needed to have the ability to type in just the Transfer Order Number, just the PackNum, or Both. When they entered both, it shouldâve just returned the 1 packnum, which is same as entering the packnum itself. However, it was returning all 3 packnum associated to that transfer order. So the âSkip Condition If Emptyâ wouldnât work for that.