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
This entry is part [part not set] of 6 in the series Industry Best Practices

Did You Know...

As Maximo Experts, we have developed several add-on products for Maximo that mobilize the work force, simplifies assignments, provides ad-hoc reporting capabilities and facilitates the seamless integration of Service Requests into Maximo.

Check out our products by clicking on the following links: EZMaxMobile, EZMaxPlanner and EZMaxRequest.

Find Out More

Leave a Reply