Hello,
I created a baq and then created a dataview to bind the baq.
but I need filter the baq with partnum. i put the conditon in the where section. but it doesn’t work. without the filter, i got the listin the grid. but if I added the filter, i got empty in the grid.
is there a syntax error?
thanks,
Eddy
I don’t know your whole set up here… but one thing you could try:
I’m not exactly sure if you need to filter the erp-baq event. If you have a Dataview for the BAQ, you can just let all the values/rows come in… but then filter it on the grid where you’re displaying the desired results:
Pick the grid you’re displaying the BAQ results in…
… open Data > Grid Model > Provider Model > BAQ Options.
You can put a “Where” clause here to filter what’s being displayed in the grid.
Below is an example.
thanks David,
i know i can filter on the grid but we will have performance issue.
i wonder if it is possible to filter on baq so the subset of data will send to client NOT the whole dataset sent back to client.
regards,
Eddy
In your BAQ you can add a table criteria for PartNum and set it to ‘specified parameter’. Then click on the word specified to setup the parameter. This creates a user prompt when running the BAQ to filter by that 1 part number(dataset won’t populate until parameter is set). You can then turn your BAQ into a menu with the dashboard tool(I’m glazing over some steps involved here).
Remove the ??.
That syntax is not used here.
ECOMtl1_PartNum = '{ECORev.PartNum}'
