Vantage - BAQ for JobDtl

I would do this:

for each JobHead where ( JobHead.JobReleased = True AND JobHead.JobComplete = False) no-lock , first JobOper where ( JobOper.OpComplete = False) and (JobHead.Company = JobOper.Company and JobHead.JobNum = JobOper.JobNum) no-lock , last LaborDtl outer-join where (JobOper.Company = LaborDtl.Company and JobOper.JobNum = LaborDtl.JobNum and JobOper.AssemblySeq = LaborDtl.AssemblySeq and JobOper.OprSeq = LaborDtl.OprSeq) no-lock , each EmpBasic outer-join where (LaborDtl.Company = EmpBasic.Company and LaborDtl.EmployeeNum = EmpBasic.EmpID) no-lock .

-bws

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Wednesday, February 09, 2011 7:00 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage - BAQ for JobDtl

Hi all

Im trying to write a BAQ which will show a Job Number and show the currect
operation.

Example:

If a job XYZ for part ABC has 3 operations - Pickup > Move > Put Down

Pickup has been complete, so an operator is working on 'Move'.

Move many have been partially completed but not ticked as 'Complete'.

I dont want to see 'Put Down' becasue that isnt started yet.

I only want to be able to see the following ...


Job Number      Part         Current Operation      Operator (not
essential but would be nice to have)

XYZÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â ABCÂ Â Â Â Â Â Â Â Â MOVEÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â B. Clinton


Then when MOVE has been complete, the next time I run the BAQ it would be as
follows ...

Job Number      Part         Current Operation      Operator (not
essential but would be nice to have)

XYZÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â ABCÂ Â Â Â Â Â Â Â Â Â Â Â PUT DOWNÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â G. Bush



So far, I have it so it shows ALL operations that havent been complete, but I'm
just interested in the CURRENT operation.


Any help would be greatly appreciated.

Thanks.




[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
Hi all

Im trying to write a BAQ which will show a Job Number and show the currect
operation.

Example:

If a job XYZ for part ABC has 3 operations - Pickup > Move > Put Down

Pickup has been complete, so an operator is working on 'Move'.

Move many have been partially completed but not ticked as 'Complete'.

I dont want to see 'Put Down' becasue that isnt started yet.

I only want to be able to see the following ...


Job Number      Part         Current Operation      Operator (not
essential but would be nice to have)

XYZÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â ABCÂ Â Â Â Â Â Â Â Â MOVEÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â B. Clinton


Then when MOVE has been complete, the next time I run the BAQ it would be as
follows ...

Job Number      Part         Current Operation      Operator (not
essential but would be nice to have)

XYZÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â ABCÂ Â Â Â Â Â Â Â Â Â Â Â PUT DOWNÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â G. Bush



So far, I have it so it shows ALL operations that havent been complete, but I'm
just interested in the CURRENT operation.


Any help would be greatly appreciated.

Thanks.




[Non-text portions of this message have been removed]