Filter BAQ Grid by Form Field

Ricky90 · February 2, 2022, 3:16pm

Hi, I am in Price List Inquiry and when the Part Code changes i want to filter a grid from a BAQ I have created to show all Part Codes. I have tried to follow How To: Kinetic BAQ Grid Pub-Sub - Experts’ Corner - Epicor User Help Forum (epiusers.help) but this seems to lend itself towards Publish and Filter from the E10 Classic Dashboards.

I have the BAQ loading the DataView when the Part Changes, i was hoping using the right relationships from within the dataview but it didnt help filter out the BAQ results.

Current Settings below.

hmwillett · February 2, 2022, 4:34pm

Sorry–I misread your question.
Is there a reason you want to do the filter in the DataView instead of what you currently have set?

What you show in your images is definitely the way to go for a dynamic filter.

Ricky90 · February 2, 2022, 4:55pm

Hi @hmwillett

I was attempting to filter a baq by the PartNum that is chosen in price list inquiry and then show it within a grid.

hmwillett · February 2, 2022, 4:56pm

What you have should work. What issues are you running into?

Ricky90 · February 2, 2022, 4:57pm

If I put the where statement in I get nothing returned. If it is empty I get the whole query (which I would expect).

Running the baq in the designer returns at least 1 row per PartNum

hmwillett · February 2, 2022, 5:03pm

Here’s what I created for reference (slightly different BAQ, but same idea).

PartWhse_PartNum = ?{PriceListInquiryCriteria.PartNum}

PriceListInquiry

Ricky90 · February 2, 2022, 8:02pm

Hi,

The query shows all rows when that WHERE clause is empty.
As soon as i put in Part_PartNum = ?{PriceListInquiryCriteria.PartNum} I get blank no records found.
I followed your instructions to the letter.

hmwillett · February 2, 2022, 8:25pm

Can you send me your BAQ?
I’ll give it a try with that and see what I can find out.

You might also try adding a second “?” which will allow for nulls. It may be choking on one.

Part_PartNum = ??{PriceListInquiryCriteria.PartNum}

Or try adding single quotes. The syntax in App Studio is duuuuuuuuumb and inconsistent.

Part_PartNum = '?{PriceListInquiryCriteria.PartNum}'

hmwillett · February 2, 2022, 8:26pm

Actually, you know what? Start with adding the quotes.
You may have part numbers where it necessitates those. Ours just happen to play nice.

Ricky90 · February 2, 2022, 8:42pm

WINNER
The quotes looked to have sorted my issue here.

I will bear this in mind for future dealings with out PartNums.

Thank you!!

hmwillett · February 2, 2022, 8:44pm