Application Studio Filtering second Grid based on First Grid

Kinetic ERP
1

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.

2

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.

3

This isn’t right. You shouldn’t have spaces in a dataview name.

1 Like
4

Okay, while this does work, this is bad practice and bound to get you in trouble at some point.

This needs single quotes around it all.

'??{Parts For Label Printing.Part_PartNum}'
5

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
Screenshot 2024-12-06 142504491×867 49.2 KB

6

Your column should be PartLot_PartNum only.

7

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.

8

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

9

Have you looked at the network calls in Dev Tools?
Specifically, the payload? What’s it sending?

1 Like
10

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