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

Written by John Reeve

Industry Best Practices

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 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, EZPlanner and EZInsight.

Find Out More

Leave a Reply