BAQ Filter Condition

Epicor ERP 10
,
1

Hi,

I am new to BAQs and customization so I may be missing something, but is it possible to filter a BAQ with a where clause ONLY if the EpiBinding is not null? I would know how to do this if I were just coding the SQL statements myself, but the Designer is not as flexible in my hands.

In the query below, I am trying to get a BAQCombo to filter only if EpiBinding:OrderHed.WarehouseCode_c is not null. Otherwise, I would like to display all options. Does anyone have any tips on where to look? Thanks in advance.

image
image1057×157 5.42 KB

2

Try:

where WareHse.WarehouseCode like '%[EpiBinding:OrderHed.WarehouseCode_c]'
1 Like
3

Thanks for the reply! I’ve tried using the BEGINS operation before but the values do not populate in my drop-down when the warehousecode field is not yet set. I agree that logically, if the warehousecode field is empty, filtering for any record with a warehousecode starting in “” should produce all results. But I just don’t understand why that hasn’t been working.

Or was the main focus of your advice for me to do WarehouseCode without the “Warehse” table preceding it?

4

That was a typo. The main purpose was to add the Like ‘%…’