Results from Query 1 as criteria in Query 2

Is it possible to automatically use results from Query 1 as criteria in Query 2? Query 1 will be pulling customer payment terms codes from Customer Universe. I would like to use those results as criteria in Query 2 Orders Universe “Not in list” to capture any orders processed with payment terms codes different than what is valid terms listed in Customer Universe. Since valid payment terms change in the Customer Universe frequently, I would like to use above approach rather than trying to maintain a list of codes on the query itself.


deano334981 (BOB member since 2009-09-15)

Welcome to B:bob:B!

This query on another query is not possible in Web-I unless you have Web-I XI 3.1 SP2.


Jansi :india: (BOB member since 2008-05-12)

We are running BOXI R3.1 +Fixpack 1.6, which I am told has more fixes than SP2. So with the version running, is it possible to do what I’m looking for? If so, how?


deano334981 (BOB member since 2009-09-15)

No. This is a new feature in 3.2. 3.2 has a bunch of new functionality AND the fixes up to FixPack 1.5. There will be a FixPack 2.1 which will catch everything up. We were told it would be out in October.


Steve Krandel :us: (BOB member since 2002-06-25)