The web blog http://www.learnsccd.com strives to be a comprehensive guide to SCCD, TADDM, SERVICE NOW and MAXIMO tools. This is a personal site maintained solely by me. I intend to update it regularly.For live updates please follow us on.

How do we list only three months of work orders by reported date ?

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.