# Dataview

**URL:** <https://www.epiusers.help/t/dataview/106172>\
**Category:** Kinetic ERP\
**Tags:** e10\
**Created:** [August 17, 2023, 8:30pm UTC](https://www.epiusers.help/t/dataview/106172 "2023-08-17T20:30:43Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![naruto](https://www.epiusers.help/letter_avatar_proxy/v4/letter/n/6bbea6/32.png) [@naruto](https://www.epiusers.help/u/naruto)\
**Post date:** [August 17, 2023, 8:30pm UTC](https://www.epiusers.help/t/dataview/106172/1 "2023-08-17T20:30:43Z")

</div>

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

 ![image](https://www.epiusers.help/uploads/default/original/3X/f/6/f64b53e723ec3566522af3c4bd2f104f961f3e3b.png)

---

<div class="post-metadata">

**Author:** ![dcamlin](https://www.epiusers.help/user_avatar/www.epiusers.help/dcamlin/32/57759_2.png) [@dcamlin](https://www.epiusers.help/u/dcamlin)\
**Post date:** [August 18, 2023, 2:37pm UTC](https://www.epiusers.help/t/dataview/106172/2 "2023-08-18T14:37:12Z")

</div>

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.

![image](https://www.epiusers.help/uploads/default/original/3X/5/f/5f0d1a781f3b6f87faf77cfd3a6736d87d1df33e.png)

---

<div class="post-metadata">

**Author:** ![naruto](https://www.epiusers.help/letter_avatar_proxy/v4/letter/n/6bbea6/32.png) [@naruto](https://www.epiusers.help/u/naruto)\
**Post date:** [August 18, 2023, 2:46pm UTC](https://www.epiusers.help/t/dataview/106172/3 "2023-08-18T14:46:23Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Engineer88](https://www.epiusers.help/user_avatar/www.epiusers.help/engineer88/32/61230_2.png) [@Engineer88](https://www.epiusers.help/u/Engineer88)\
**Post date:** [August 20, 2023, 4:05pm UTC](https://www.epiusers.help/t/dataview/106172/4 "2023-08-20T16:05:50Z")

</div>

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).

 ![image](https://www.epiusers.help/uploads/default/original/3X/6/7/67ce385132f7044c5f7c5406f59fef16245a243b.png)

---

<div class="post-metadata">

**Author:** ![hmwillett](https://www.epiusers.help/user_avatar/www.epiusers.help/hmwillett/32/93207_2.png) [@hmwillett](https://www.epiusers.help/u/hmwillett)\
**Post date:** [August 21, 2023, 2:46pm UTC](https://www.epiusers.help/t/dataview/106172/5 "2023-08-21T14:46:22Z")

</div>

> [@naruto](#):
>
> is there a syntax error?

Remove the `??`.  
That syntax is not used here.

`ECOMtl1_PartNum = '{ECORev.PartNum}'`