Ben,
Add JobOper.
Filter by JobOper.OpComplete = false.
(If you need details ask).
Add BY JobOper.OprSeq before the : at the end of the query.
That should show all remaining operations (starting with the current one) in
order for each job.
If I am wrong, someone please correct me.
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: bbelzer42 [mailto:bbelzer@...]
Sent: Monday, January 24, 2005 4:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Dashboard Query for Current Operation
I currently have a query that shows me late jobs. Is there a way to
display what operation sequence it is currently on? And what is
next?
Thanks,
Ben
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/links
Yahoo! Groups Links
Add JobOper.
Filter by JobOper.OpComplete = false.
(If you need details ask).
Add BY JobOper.OprSeq before the : at the end of the query.
That should show all remaining operations (starting with the current one) in
order for each job.
If I am wrong, someone please correct me.
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: bbelzer42 [mailto:bbelzer@...]
Sent: Monday, January 24, 2005 4:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Dashboard Query for Current Operation
I currently have a query that shows me late jobs. Is there a way to
display what operation sequence it is currently on? And what is
next?
Thanks,
Ben
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/links
Yahoo! Groups Links