Help with Filter for Relationship please. I am stumped

BLOMASKY

Let me start explaining the system design.

There are Items that can be supplied by multiple Vendors. There is a BO for both of these plus a BO called VendorItems that is related to both of these tables (and it also has additional info, like pricing, delivery dates, etc.) Some Items can be supplied by multiple Vendors

All is good with these 3 BOS. Here is where I am scratching my head. There are 2 other BOs, OrderHeader and OrderLine. The OrderHeader has a peer relationship to Vendors. (There is only one Vendor for for each Order Header). The OrderLine has a peer relationship to Items.

I need a filter on the Items Relationship in the OrderLines so that will ONLY show the items that are for the Vendor that is in the OrderHeader. In other words, if the OrderHeader is related to ACME Vendor, and there are 5 records in the VendorItems for ACME, when I am entering OrderLines, I want to only see these 5 items to choose from.

Any suggestions for the custom query for the filter? Or have I confused everyone?

Thanks

Bruce

tford

Have you looked at the documentation for the THIS prefix?

BenHayat

BLOMASKY wrote
Let me start explaining the system design.

There are Items that can be supplied by multiple Vendors. There is a BO for both of these plus a BO called VendorItems that is related to both of these tables (and it also has additional info, like pricing, delivery dates, etc.) Some Items can be supplied by multiple Vendors

All is good with these 3 BOS. Here is where I am scratching my head. There are 2 other BOs, OrderHeader and OrderLine. The OrderHeader has a peer relationship to Vendors. (There is only one Vendor for for each Order Header). The OrderLine has a peer relationship to Items.

I need a filter on the Items Relationship in the OrderLines so that will ONLY show the items that are for the Vendor that is in the OrderHeader. In other words, if the OrderHeader is related to ACME Vendor, and there are 5 records in the VendorItems for ACME, when I am entering OrderLines, I want to only see these 5 items to choose from.

Any suggestions for the custom query for the filter? Or have I confused everyone?

Thanks

Bruce

Based on what I'm reading, you want to do the filtering in LineItems based on on it's parent (Header BO) Vendor.
If that's the case, it's easy. In your LineItem's filter WHERE clause you can filter LineItem.ParentHeader.Vendor against any value.

ACDC

I need a filter on the Items Relationship in the OrderLines so that will ONLY show the items that are for the Vendor that is in the OrderHeader.

On your Item reference in OrderLines:

FIND Items WHERE OrderLines.OrderHeader.Vendor IN Items.Vendor

customaware

FIND Process WHERE COUNT ContractorProcess WHERE (ContractorProcess.ob_Contractor=QuoteStep.ob_Quote.ps_Contractor AND ContractorProcess.ps_Process=Process)>0

BLOMASKY

Right after I posted the question, I got heard from Mark and in about 10 seconds he came up with his answer (which works fine. I did change the COUNT (......) > 0 to EXISTS (....)

Thanks to all who have a MUCH better grasp of Aware than I do.

Bruce

BLOMASKY

ACDC wrote
I need a filter on the Items Relationship in the OrderLines so that will ONLY show the items that are for the Vendor that is in the OrderHeader.

On your Item reference in OrderLines:

FIND Items WHERE OrderLines.OrderHeader.Vendor IN Items.Vendor

This does not work, because there I would have to change the text after the IN to VendorItems.Vendor and that finds NO match. There is no relationship Items to Vendors, except in the VendorItem BO and since thats a peer with MULTIPLE records, I think the system cant navigate properly.