Grab the first 200 records by using (SQLserver) the Top 200 feature

When Maximo limits your work order QUERY to 200 records (and you know you have maybe 2500 to edit) …..

here is a trick to grab the first 200 (or whatever value <= 200)  …

and then do something with that “first set of records”, such as, Change Status (and then, re-query).

004-TOP200

 

Series Navigation< Utilizing a field called SITEVISITLabor Actuals – sometimes you get a ZERO value >

Did You Know...

As Maximo Experts, we have developed Maximo adds on products to make Maximo work assignment simple, reporting easy, and facilitating service requests seamless. Check out our additional products EZPlanner, EZInsight, and EZRequest.

Find Out More

Leave a Reply

Your email address will not be published. Required fields are marked *