List only three months of work orders by reported date ?
1. Go To Work Order Tracking Application.
2. Click Advanced Search to select where clause.
3. Enter the query as below and click Find.
((woclass = 'WORKORDER' or woclass = 'ACTIVITY') and historyflag = 0 and istask = 0 and reportdate > (sysdate - 90) )
The results will be displayed.
4. Click on Save Query select Save Current Query.
5. Enter a Query Name and Description.
6. Check Public so everyone can use the query.
Note: If you make it Default every time you go to Work Order Tracking Application this result is listed.
0 comments:
Post a Comment