It’s me again.
I’m trying to filter a grid via the BAQ options. I have two filters in the where list:
PayrollDate and JCDept.
I’ve set the payroll date > TransView.PayrollDate and the JCDept to = “ASSY”.
I want these filters to operate as an “AND” and have it honor both filters together, but it’s acting as an “OR” and giving me records that are either > than the date filter or equal to the department filter.
Is there a setting that changes this behavior?
Thanks,
Joe
Instead of using a Where List…
Try backing up to the Provider Model > BAQ Options and put your expression in there including “OR”.
I used “AND” in my expression below… but you can chain them together here. Below is my full expression, you can see I had several criteria on this one.
Part_PartNum = ‘??{Part.PartNum}’ AND (PartTran_TranType <> ‘ADJ-CST’ AND PartTran_TranType <> ‘PUR-SUB’ AND PartTran_TranType <> ‘Mfg-Ven’)
I’ll give that a shot. Thanks, David.
That did the trick. Thanks!
Oh… I guess I misread your original post. I thought it was treating them like an “AND” and you wanted an “OR”.
I guess “OR” is the default for Where List?
They need to build this out like the did in the Kinetic Product Configurator. In there, when creating a “where list” (BAQ Criteria) they actually give you the controls to select And/Or, and can also toggle parenthesis, as well:
But in this case they DON’T give you a field on the front end where you can just type in a full expression, which, to be honest is much easier than adding each criteria manually.
I have two grids with multiple filters. One of them works only with the where list and one works only with the BAQ Options where field like you showed above.
Actually, I thought the offending grid was doing an OR, but it was just malfunctioning with the second criteria and dumping everything. The single where field fixed that one.
I guess I’ll pick this stuff up eventually.
Thanks for your help.
Joe
I’m working on a similar project. I have a BAQ to add some additional information to the Inspection Processing app, specifically the PO Receipts. I have created my BAQ, added a Panel Grid Card to the PO Receipts page in Inspection Processing. My problem is, the BAQ information is filled in no matter which record I select. I have the BAQ Options, Where clause as RcvHead_PackSlip = ??{porView.PackSlip} AND RcvDtl_PackLine = ??{porView.PackLine}.
Where have I gone wrong? I feel like I’m ‘this close’.
Not laughing AT you, but you may be right… and its just ironic that you put “this close” in single quotes.
You may need single quotes around your values. Try the below:
RcvHead_PackSlip = '??{porView.PackSlip}' AND RcvDtl_PackLine = '??{porView.PackLine}'
See if that works. I could be wrong. I always have to play around with that stuff until I get it right.
