Hi Ryan,
We use this query in Work Order Tracking to produce a weekly list of work orders created in the 7 days prior to the report date:
((woclass = 'WORKORDER' or woclass = 'ACTIVITY') and historyflag = 0 and siteid = 'BARHBR' and istask = 0 and reportdate >= getdate() - 7)
I'm not sure if that's the "best" or the most elegant way to do it, but it works for us!
Hope that's helpful,
Amy
Amy Tellier-Briggs
Maintenance Planner, CBO, BOC Level 1
Facilities Services
207.288.6356 t | 207.266.4347 m
amy.briggs@jax.org
The Jackson Laboratory
Bar Harbor, ME | Farmington, CT | Sacramento, CA
www.jax.org
The Jackson Laboratory: Leading the search for tomorrow's cures
---
The information in this email, including attachments, may be confidential and is intended solely for the addressee(s). If you believe you received this email by mistake, please notify the sender by return email as soon as possible.