Use this query on post processing of EngWorkbench.Checkout. Since the method is getting data from the server to the client, you want post processing. The ipPartNum below is the parameter sent for the checkout. This has been tested.
Greg
for each Part no-lock , each PartRev no-lock where (Part.Company = PartRev.Company and Part.PartNum = PartRev.PartNum ) and PartRev.CheckBox01 = true and Part.PartNum = {ipPartNum}
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, December 03, 2015 9:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM Issue
Jim,
Thanks for the tip. I updated my query:
for each Part no-lock , each PartRev no-lock where (Part.Company = PartRev.Company and Part.PartNum = PartRev.PartNum ) and PartRev.CheckBox01 = true , each ECORev no-lock where (PartRev.Company = ECORev.Company and PartRev.PartNum = ECORev.PartNum and PartRev.RevisionNum = ECORev.RevisionNum )
and still get the same result, the box no matter what.
CONFIDENTIALITY NOTICE
The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6240 and immediately delete the communication.
"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."