Recent content by Patrick659

Many thanks Patrick T.! - both work very well. We're also able to add other conditions to the ANDs, and they continue to work well. Right now we're scaling up testing (e.g. "tray" population of 21,000), and so far so good. Thanks again and best to all for your help!

Thanks all - OpenEdge 12.2.17 linux redhat7 Unfortunately, none of the foregoing worked - still keeps reporting trays with request history. However, some more knocking around seems to at least omit such trays. But now it seems to be stopping short. For example, where we know of 45 trays...

Hello - Our inventory management system (IMS) stores items in "trays". When an item is requested, a "history" record is created for that item. What we're trying to do is identify trays whose items have never been requested. Since the IMS doesn't have any such reporting, we're trying various...