# Application Studio Filtering second Grid based on First Grid **URL:** \ **Category:** Kinetic ERP\ **Tags:** application-studio\ **Created:** [December 6, 2024, 5:23pm UTC](https://www.epiusers.help/t/application-studio-filtering-second-grid-based-on-first-grid/121521 "2024-12-06T17:23:17Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![tpynepeak](https://www.epiusers.help/user_avatar/www.epiusers.help/tpynepeak/32/101824_2.png) [@tpynepeak](https://www.epiusers.help/u/tpynepeak)\ **Post date:** [December 6, 2024, 5:23pm UTC](https://www.epiusers.help/t/application-studio-filtering-second-grid-based-on-first-grid/121521/1 "2024-12-06T17:23:17Z")
I have 2 grids. The first grid is BAQ of a filtered list of parts. Dataview **Parts For Label Printing** The second grid is a BAQ of all Part Lots in the system. Dataview **Part Lots** I want to filter the second by the part number in the first. If I set the following under Grid Model → Provider Model -\>BAQ Options → Where list I get all the lots even lots that are linked to parts not in the first list **Column:** PartLot\_PartNum. I’ve also tried Part Lots.PartLot\_PartNum and ??{Part Lots.PartLot\_PartNum) **Condition** : = **Value:**??{Parts For Label Printing.Part\_PartNum}, I’ve also tried without the ?? I just get all results. No errors. The first few results are not parts from the first BAQ, its just the entire second dataview unfiltered I put it in a static filter on the dataview and get the first part in the first dataview but then if I click another line it doesn’t change so that is not the answer either. ---
**Author:** ![tpynepeak](https://www.epiusers.help/user_avatar/www.epiusers.help/tpynepeak/32/101824_2.png) [@tpynepeak](https://www.epiusers.help/u/tpynepeak)\ **Post date:** [December 6, 2024, 5:24pm UTC](https://www.epiusers.help/t/application-studio-filtering-second-grid-based-on-first-grid/121521/2 "2024-12-06T17:24:41Z")
Have to say this has been one of the hardest language I have used in 30 years to disable a button or to filter a grid. I’m even including some weird languages like Clipper or Clarion in that list. (I did figure out the button disable thanks to Hannah). In comparison writing the function that this application calls to generate Bartender files and send them to a remote FTP site to be processed for printing was a snap. ---
**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:** [December 6, 2024, 5:28pm UTC](https://www.epiusers.help/t/application-studio-filtering-second-grid-based-on-first-grid/121521/3 "2024-12-06T17:28:06Z")
> [@tpynepeak](#): > > {Parts For Label Printing This isn’t right. You shouldn’t have spaces in a dataview name. ---
**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:** [December 6, 2024, 5:35pm UTC](https://www.epiusers.help/t/application-studio-filtering-second-grid-based-on-first-grid/121521/4 "2024-12-06T17:35:27Z")
> [@hmwillett](#): > > You shouldn’t have spaces in a dataview name. Okay, while this _does_ work, this is bad practice and bound to get you in trouble at some point. > [@tpynepeak](#): > > ??{Parts For Label Printing.Part\_PartNum} This needs single quotes around it all. ```auto '??{Parts For Label Printing.Part_PartNum}' ``` ---
**Author:** ![tpynepeak](https://www.epiusers.help/user_avatar/www.epiusers.help/tpynepeak/32/101824_2.png) [@tpynepeak](https://www.epiusers.help/u/tpynepeak)\ **Post date:** [December 6, 2024, 7:19pm UTC](https://www.epiusers.help/t/application-studio-filtering-second-grid-based-on-first-grid/121521/5 "2024-12-06T19:19:59Z")
Didn’t work. It just pulls everything. Now if I put quotes around the column parameter nothing shows up. The filter itself doesnt seem to matter, I can type anything in there and it just pulls everything. If it was wrong shouldn’t it blow up? ![Screenshot 2024-12-06 142504](https://www.epiusers.help/uploads/default/original/3X/d/4/d43051508c0b55f50f55d43eaa33572cfcc1531d.png) ---
**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:** [December 6, 2024, 7:34pm UTC](https://www.epiusers.help/t/application-studio-filtering-second-grid-based-on-first-grid/121521/6 "2024-12-06T19:34:22Z")
Your column should be PartLot\_PartNum only. ---
**Author:** ![tpynepeak](https://www.epiusers.help/user_avatar/www.epiusers.help/tpynepeak/32/101824_2.png) [@tpynepeak](https://www.epiusers.help/u/tpynepeak)\ **Post date:** [December 6, 2024, 8:15pm UTC](https://www.epiusers.help/t/application-studio-filtering-second-grid-based-on-first-grid/121521/7 "2024-12-06T20:15:43Z")
Thanks but that did not pan out either. I just get all the records. It does not do anything with the filter. At least if it errored I’d know that something is wrong. Now if I set the where filter one level up in the BAQ options I get no records. So it literally is all or nothing. At this point - I can get the first BAQ populating, the second one is all or nothing. I can call a rest function and have parameters pass back and forth and move files to other servers and trigger 3rd party software to print labels (which should have been the hard part). Filtering BAQs and setting buttons inactive seems to be such a pain that there are multiple threads asking this basic question haha I figured out the button issue from one of your threads. Thank you. ---
**Author:** ![tpynepeak](https://www.epiusers.help/user_avatar/www.epiusers.help/tpynepeak/32/101824_2.png) [@tpynepeak](https://www.epiusers.help/u/tpynepeak)\ **Post date:** [December 6, 2024, 8:29pm UTC](https://www.epiusers.help/t/application-studio-filtering-second-grid-based-on-first-grid/121521/8 "2024-12-06T20:29:01Z")
Now if I let it pull all data and tell it to refresh grid and type the part number into the slider it works. So I know the query behind the scenes is working ---
**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:** [December 7, 2024, 2:28pm UTC](https://www.epiusers.help/t/application-studio-filtering-second-grid-based-on-first-grid/121521/9 "2024-12-07T14:28:33Z")
Have you looked at the network calls in Dev Tools? Specifically, the payload? What’s it sending? ---
**Author:** ![tpynepeak](https://www.epiusers.help/user_avatar/www.epiusers.help/tpynepeak/32/101824_2.png) [@tpynepeak](https://www.epiusers.help/u/tpynepeak)\ **Post date:** [May 2, 2025, 4:02pm UTC](https://www.epiusers.help/t/application-studio-filtering-second-grid-based-on-first-grid/121521/10 "2025-05-02T16:02:16Z")
I had too much to do so rewrote it as one query combining all the records of both. I have many dozens of these to convert and the calculus is bad. What used to be a 15 minute job with classic can turn into hours or longer of slogging. Adding in that there is still no way to do kinetic inspection plans (May change on May 15th) and our company is going to be spending months on this beta product. Appreciate the help though =)